I would love to know how often this happens.

I think I saw a similar trajectory where a small startup in New Zealand with a working product was accepted into YC: then the product needed a complete rethink for the US market and it quietly died.

Very difficult to discern cause and effect.