An engineer loses his family, and finds himself as a colt in Canterlot, beside Discord's statue. When he realizes he knows the means to defeat Discord, he must do little to disrupt those events. But the rise of the New Lunar Republic demands his action. And the knowledge he can share to help everypony, demands he do something to help. He must do what he can to help his new friends, yet must carefully avoid changing things too much to let the actions to defeat Discord still work.
The Princesses and the buearcracy also realize his usefulness in forwarding their own schemes.

A look into the politics and psychology of the capital, and its people. And theory on the rise of the New Lunar Republic. Celestia faces Luna, and the NLR leadership , alone.

A human finds himself in Equestria under very unpleasant circumstances with no explanation.
His reaction: get the heck out of Dodge and start a new life where Equestria and her ponies can't reach him.
But an alicorn's reach is long and the events which brought him here and his treatment in Canterlot are not so easily forgotten by those who did it. How does one say 'go away' to an immortal goddess?

Yay! Featured, thank you all.
A TV Tropes page
Revised 08/31/14 for clarity and grammatical issues, no events changed. I am working on a sequel, but it will be from Fancy's POV.
P.S. Green is NOT Lyra. There are other green unicorns.

The sequel to this story: Sweetie Belle and the Quest for Knowledge is now available!

When Sweetie Belle finds a mysterious artifact of a now lost civilization, how will she come to terms with the wealth of knowledge it provides? It says it can be ignored, it says it will never try to influence her, but can an artifact of such power really be so harmless?

Book I of III

Prologue and Chapter 1: Thanks to TheOtherSideOfFluttershy for pre-reading and editing.
The whole story: Thanks to RaylanKrios for editing.
Chapter 4: Thanks to AuthorGenesis for editing.
Epilogue:
Thanks to Malefactory for editing.

Friendship can be found in the most unlikely of places. It can happen on a completely ordinary day to some, and a desperate struggling day to another. Some might say that it doesn't matter how it begins, but instead what is important is how things proceed. However, even from those who say that, the question will eventually come up.

How did you meet?

This is the tale of how one friendship began, when two different younglings, one changeling and one pony, found themselves meeting the other.

A regular human arrives in Equestria and to most it would be a dream come true. But this human knows pratically nothing about the ponies or their world. With no home to return to, he is forced to brave this new world. So he does what any human in his situation would do. He survives.

Rated teen for swearing, blood and how it gets kinda dark. Written after season two. Updated after season 4.

Disgraced. Dethroned. Unwanted by her own parents. These are just the few things that describe the former queen of the changelings. For Chrysalis, the only thing she can properly call herself is desperate, hungry, and lonely. Fortunately for her, she isn’t fully alone. Fortunately for her, she carries the unwanted offspring from a pony that sent her hurling across Equestria with a blinding light. Though she has nothing left to live for, she reluctantly chooses to raise the child once it’s born. The only question is, does she have enough strength to deliver it?

Edited by: Sorren, SolidFire, and Mikemeiers

There was only one explanation. For all of it. All of the strange, erratic behavior. Her irrational fear of the sun. Her nocturnal habits of locking herself in in the dark and closing all the blinds. Wearing her sunglasses everywhere, even inside! It was time to invest in some silver, garlic, and a wooden stake.

After the Smarty Pants incident, Big Mac ran off with Twilight's Smarty Pants doll, much to his little sisters' amusement. When he refused to return it, an anger fueled spell from Twilight resulted in a BIG problem for Big Mac, with Smarty Pants at the 'heart' of it

Cover art by Paper-pony

A young filly in present day Ponyville is cursed with nightmares of post-apocalyptic Equestria. She finds herself influencing the course of future history in ways that she cannot understand. She must learn to balance her life at home with her life on the other side of the veil, and fight to preserve her own sanity, and her own innocence.

She discovers that such a task is only possible through the magic of friendship.

Twilight Sparkle has too much magic, and it will take her decades to learn to control it. Her spectacular loss of control during her entrance exam only proves that fact. She is a danger to herself and others.

After Sunset Shimmer’s disappearance, Princess Celestia needs a new student to bear The Element of Magic to defeat Nightmare Moon. With all of Equestria at stake, Twilight Sparkle…is not the pony she needs.

Princess Celestia seals Twilight Sparkle’s magic with the distant promise of one day teaching her.

But there are two diarchs of Equestria. Amidst a lucid dream, an offer is made.

“Hello, Twilight. Would you like to be my student?”

Cover art provided by Lafiir.