Tales

Tales is a ~18,000-word novella written by George Pollock, Jr. It is narrated by an aged Twilight Sparkle, now a grandmother, who imparts several "tales" of her adventures as a young adult. The story is segmented into 16 fairly short chapters. Among the developments revealed over the course of the story:
 * Pinkie Pie and Big McIntosh become a couple
 * Twilight ends up marrying the captain of the royal guard and becomes the royal librarian at Canterlot
 * Rainbow Dash dies after an accident while trying out for the Wonderbolts
 * Celestia is only a regent filling in for her father, the king of Equestria, until he dies and she becomes queen
 * Zecora disappears at some point, leaving her apparently magical cloak to Fluttershy, who becomes a hermit
 * Spike is the heir to the throne of the dragon kingdom

Since the final chapter was published in February 2011, several ideas and developments from the story do not line up with what was later established in the show (such as Spike's origin).