Whatever Happened to Starswirl the Bearded?

Twilight gets curious about Starswirl's death. She finds out that he is both cooler and lamer than she ever thought.

Twilight knows a lot about the great unicorn mage, Starswirl the Bearded. In fact, she only really had one question about him.

What happened to him?