The Canterlot Archive decides to create a document listing the age of every pony in Equestria. It's impossible to mess this up.

The Canterlot Archive messes this up.

Proofread by Octavia Harmony.

Special thanks to Selbi for additional help.

Live reading by CaptainBron3y

Now Featured on Equestria Daily!
TV Tropes and a group of its own.
Audio version
( EPUB / MOBI )
Three Nights in Manehattan, a sequel
Hardcover Print-on-Demand Order Page

As a child, Daphne knew of a world where magic lived, where an immortal princess reigned over a beautiful kingdom, and longed to journey there beside Leit Motif, the filly she'd grown to love in the woods behind her home. But one day, when she needed her most, Leit Motif was gone, and she never came back to show her the way. As she grew, she put aside her childish dreams, and taught herself to believe the lie.
When forces beyond her knowing take her sister Amelia, though, she discovers that her childhood fancies were entirely too real, and is thrust into a journey that will take her back to that land she longed for, back to the childhood friend she'd abandoned, and to worlds she'd only dreamed of.

Interview with Pre-Reader Amacita
PresentPerfect's Review

Twilight Sparkle is called upon to negotiate trade arrangements with the griffons. Of course, all her friends join her for what should be a casual pleasure cruise in the airship Canvas Streak. After all, this is her first REAL test as a princess, and why shouldn't they support her?

Late one night, though, Applejack feels restless and goes up on deck to watch the stars. She considers her life. She considers her family. She considers her friends. She considers the freak storm approaching from the south.

In retrospect, it might have been better to let the crew handle that and head back below deck.

Now alone on a small island, Applejack must survive and wait for her friends to come pick her up... even though the freak storm is blocking them off. Surviving's easy. Waiting's easy too! She can do this.

....she can do this....

Image by WhiteDiamondsLtd.

Rainbow Dash, best pony, fastest flier in Equestria, all around awesome mare, was called upon to help with the wedding of her friend's big brother. And hey, she never leaves her friends hanging! Of course, when it turned out some kind of bug thing had replaced the bride, Rainbow was more then ready to fight. Heck, even after it seemed all hope was lost, the pegasus refused to give up.

So when she saw Shining Armor charge up a final spell, she smirked.

But when that spell reached her and flung her against the wall, her smirk devolved into shock...

Cover art is a combination of Deception is Magic vector by Helios and Sonic Rainboom Version One by SkyRings.

One foggy morning in Ponyville, the residents wake up to find their deepest darkest secrets sloppily written in red paint on their homes. No one knows who the culprit was, the only thing that the town knows is that it will not come off, no matter how hard you scrub. The town is baffled, humiliated, and in shambles. But no more than Twilight and her friends.

In a time where everything you fought to keep hidden is out into the open, will you embrace your faults or sins, or will you let them consume just who you really are?

Time to fess up, Ponyville.

Thanks to ThePristineEye for the coverart!

Also thanks to Kleora for editing!

Oh, and Skeeter The Lurker for proofreading.

Reader, in ancient days, the old lords of the world numbered in thousands. Then hundreds. Then even less.
Now, they are found only in tapestries and fanciful ballads.
The creatures are all vanished. All but one.

Rumors say there are more of him, somewhere far away. A young and supposedly gifted mage called Star Swirl, and Heartstrings, a gentle spinster, have joined him on a journey to find the rest.

Featured in The Royal Guard's Fic Spotlight #5
TV Tropes page (that could use more love)

This story is a sequel to Project: Sunflower

After the events of Project: Sunflower, Erin Olsen has returned to Ponyville, happy to pursue her studies in magic. After everything that happened the year before, she's looking forward to spending her days studying and having fun with her friends.

Meanwhile, on the newly discovered world of Harmony, humans and ponies work together to study this strange new world. However, their arrival causes something ancient to begin stirring. Something that may end up changing everything.

Erin will need all of her courage, all of her cleverness and, of course, all of her friends to see herself through what happens next.

Cover art by Valkyrie-Girl
Editing provided by:
Brilliant Point, Coandco, Ekevoo, Ludicrous Lycan, Merlos the Mad and Razalon the Lizardman.

This story is a sequel to Stardust

When Equestria’s newest member of royalty asks for aid to be offered to her friends from abroad, the best and the brightest volunteer to serve. Captain Steel Song of the Dusk Guard are immediately mobilized to help XCOM defend their world from the enemies that besiege them. However, their first joint operation with the humans takes a turn for the worse and they quickly find themselves fighting for their lives against the full force of the monsters that threaten Earth.

(Stardust/Dusk Guard crossover)
(Coverart provided by a friend of Viking ZX!)
(While familiarity with both stories isn’t required, it is recommended)
(Many thanks to Arzoo for pre-reading!)
(All screenshots can be found at XCOM.wikia.com)
(Featured on 3/13/2013. Thanks everyone!)
(Now has it's own section on TVTropes as part of the Stardust series!)

"... at the forefront of our fandom’s writing scene ... Masterpiece." —PCaRG
"... really enjoyable ..." —City of Doors
"...worthy of high praise." —PaulAsaran
"Lots of wonderful world-building, great action, well-developed characters and an engaging story." —Hoopy McGee

Steel Song is a lot of things. Earth pony. Uncle. Professional bodyguard.

Retired.

So when he receives a mysterious package from Princess Luna a few weeks after the changeling invasion, he's understandably apprehensive. More-so when he presents himself before the Royal Diarchs to find that not only do they desire him to come out of retirement, but to take command of a most unusual position...

A position that may have more significance than any of them suspect. Because strange thefts are occurring on the Equestrian Railway, thefts that nopony can explain. Thefts that may have far more sinister intentions than their seemingly innocent nature may convey.

Intentions sinister enough to shift the balance of power in Equestria forever.

Book I of The Dusk Guard Saga.
Epic Fantasy
Has a collection of Side Stories as well, the first of which is here.
Now with a TV Tropes page!
"This is 100% Approved by Twilight's Library!"
Added to Twilight's Library 11/26/2013
Added to Canterlot's Finest 12/01/2013

Isolated from her friends and taken prisoner in the middle of a war, Twilight must deal with the very real dangers of being percieved as an enemy as well as the nightmares of her arrival on 'Earth'. Can she overcome her own fears and the fears of her captors? Will the wayward unicorn's assistance be a boon or a curse to the 'humans?' Most importantly, will she ever find her way home?

"In short, it's a story of friendship and plasma rifles, with the emphasis on the friendship. The characters are well written, the XCOM setting is fleshed out very well, and the story is compelling. If you love XCOM, you'll love the story, but even if you've never heard of it, it's more than worth giving the first 3 chapters a read.

There's excellent action later on, but the real strength lies in the collision between the friendly and naive world of Twilight Sparkle and the desperate world of humans fighting a losing war for survival and willing to do anything to turn the tide."

--Arzoo

(XCOM/FiM crossover)
(Cover art commissioned by a friend and created by the magnificent FoxInShadow!)
(Original cover art by the amazing Carnelian can be viewed here!)
(Gore tag for blood and some violence)
(Many thanks to the studius OminousTen, Arzoo, xXFluttershyForeverXx and finally Setokaiva for giving my rambles a once-over)
(Now with it's own TV Tropes page! Get to tropin' folks!)