I looking for a hie fiction. He wakes near discord statue and is a pony and he is a bronie. He is an engineer and makes the first pedal power helicopter used to help people. He helps the princesses with fighting discord while they are helping twilight defeat him. I think he drove discord crazy. The end was happy and sad because they won the war but lost the battle. A new and old statue were added to the garden.

Sounds like you're thinking of Out of Place by Dan_s Comments.

7871120
I agree, it very much sounds like the character P.T. McHorsefly from the story "Out Of Place".

I highly recommend Dan_s Comments works. My recommended reading order would be

The Drawn with the Night series.
https://www.fimfiction.net/story/212048/drawn-with-the-night

Cultural Artifacts
https://www.fimfiction.net/story/71281/cultural-artifacts

I Am Not Spartacus
https://www.fimfiction.net/story/156213/your-human-and-you-i-am-not-spartacus

Yummy Lies
https://www.fimfiction.net/story/375961/yummy-lies
(Dont read the comments. Spoilers WILL ruin the story.)

From Outside
https://www.fimfiction.net/story/387627/from-outside
( With the warning that there is a chapter that see the world through the eyes of a Cthulhian alien. That part is a bit confusing, but the story clears up very quickly and takes off fast. Also an "arboreal" refers to a cat, and the wizard that gets torched is not Ranma. Those tips helped me clear things up.)

Monk

7871046
Darn I really can't remember that one. Sorry.

7871120
Thanks