A freak accident causes New York Police Detective Kate Beckett and her partner, best selling mystery writer Richard Castle, to be turned into ponies and transported to Ponyville. Meeting up with Twilight and her friends, Beckett and Castle try to deal with their new bodies, the citizens of Ponyville and all the insanity that the Mane 6 seem to attract, all while trying to find a way home.

TVtrope page found HERE

Jesus finds his way into Equestria.

Pirates, adventure, and romance.
Rainbow Dash may have just gotten ahold of the greatest piece of useless blackmail material ever.

And absolutely nothing happens. At all.

Contains adult themes. But it's not like that's going to stop anybody, so whatever.

Cover art by balister, and editing credits go to my sexy cop in a nurse outfit, Future

When Twilight is searching the Everfree Forest for a certain 'mystery potion', she accidentally stumbles onto Zecora's front door step. However, Zecora is not acting herself, the zebra preaching to the unicorn about an impending 'disaster' the day when the traditional Zebrian calendar ends, and that day is tomorrow. How does Twilight react to such ominous and shocking accusations regarding the future? And what does she plan to do about it?

In a poorly informed bout of revenge, Trixie has returned to Ponyville to make Big Macintosh and Rarity fall in love, because she's convinced this will prove she is the Best Showpony in all Equestria.
But Rarity's going to the spa with Fluttershy, Big Mac has chores to do, and Twilight hasn't the faintest as to why her best friend and best friend's brother are having an episode of freaky Friday...

This story will not be completed by its original author, though if one is interested, they can adopt the story and finish it as they see fit. Unpublicized story resources exist.

Before Shining Armor was Captain of the Royal Guard and spouse to Princess Cadence, he was just an ordinary big brother. But when the love of his youth proves not meant to be, he vows to be the very best stallion he can be to prove his worth. Years later he succeeds, and he is a shining example of a pony. So why does he hate himself so much?

Fluttershy has always been the most cowardly of the Mare Six, not to mention the most paranoid. So when the "end of days" reveals its ugly head, our favorite yellow Pegasus is ready to batten down the hatches. Can Rarity be able to convince her best friend that she's being ridiculous and bring her back to reality, or will she need a helping hand? (PinkRariShy friendship with a hint of Flutterdash romance/friendship)

I change my mind, this story, whilst slightly(incredibly) immature, is amazing and you should read it. Might get a chuckle.

WARNING! THIS STORY SUCKS! I cannot fathom how this got as many likes as it has.

My name is Michael. A couple of my friends took me hunting for my 23rd birthday, which was the worst idea ever. You see, they're dead, some eight armed pasty faced nutsack is chasing me, and all I have left is my dog, Colmillo, a shotty and shells, and a bow with a few arrows(which I don't even like). I think he is close, because I can hear him coming. I only hope Colmillo makes it out okay. I love that dog. And if he takes me, I'll at least go down like a man.

You know what? I don't even like hunting.

Frosty Mug runs the premiere (and only) watering hole in Ponyville. He's been behind the pine for years, and listened to many a sob story, and joyous announcement. Enjoy his recollections of a rather strange week in which he served a different Element of Harmony every day, and a pony he would have never thought he'd have the honor of getting drunk. These are the memoirs of a Ponyville booze vendor.

Now with bonus drinks! Consider it 'Happy Hour'!

Warning: Shipping is mentioned.