Tom an Average Joe, saves a girl from an attempted rape. But he is fatalily injured and blacks out, only to wake up in a strange place in a body of a horse. A horse known to the locals as Nightmare moon.

Edited by Izanagi

Cover Art done by SwedishRoyalGuard http://www.deviantart.com/art/Nightmare-Moon-372321197

After a tragic accident, a human ends up in Lord Tirek's body, as part of an attempt to reform the villain after his recent escapades. While the hero of our tale is trying to make sense of his new surroundings, the rest of Equestria thinks that the most terrible threat that their world has ever seen is back...
And the powers that be are definitely not happy about it.
New Cover Art By Shadow Bolt

Due to the recent animal activity from the Everfree Forest, Princess Celestia has sent an agent from The Academy. What will happen when a certain librarian starts to fall for the crimson haired warrior? What secret is he keeping from the town folk of Ponyville? Join Crimson Storm on a journey that will shake the foundation of the world.

All ponies are humanized. Pegasi still have wings and Unicorn's cast magic with their hands.

Inspired by Gentlemanj's amazing series. 'The Journey of Graves.' and RoosterTeeth's RWBY

I should have refused to follow him for a night at the bar. I should have stayed at home. Why did I do that? What was I trying to prove?
---
Our main character has a nasty habit of falling into deep slumbers and waking up where he doesn't know where he is. In fact, the first place he wakes up...
... is in Hell.
---
Through some horrifying circumstances, the blue armor that was scattered in the ruins of the Royal Sisters' Castle reconstitutes the vessel of Nightmare Moon. Only this time, a human soul is its life source.
---
Rated Teen for some questionably older implications toward the beginning. In contrast, pyromaniacs will find said implications very underwhelming.
(Warning! Transgender imminent!)
Edit: This story was written solely for entertainment purposes. Please do not dive into this expecting a well-tested chemistry report.

Edit: I think I found a cover that just might work for now.

When a human is thrust into Equestria on a whim, he struggles to fit in with the locals of this strange land and tries to figure out how to get home, making new friends along the way.