Bitcoin Cryptocurrency Mastering Development

Is there a real case where a very long blockchain got overtaken?

The longer the longest blockchain is, the harder it is to get overtaken by new blockchain with different sequence of transactions. But is there a case where it happened? What happened afterwards if there’s so many transactions which got deleted or override by new blockchain?