I had several moments of tears in several movies though out the life I've lived so far.
[Child]
Land before Time: The baby pterodactyl's death had be crying my eyes out. I almost ran out of the theater before they showed he had actually survived.
The Neverending Story: SADDEST...HORSE DEATH SCENE...EVER. I mean it people. If you love horses DO NOT WATCH THIS MOVIE! This movie I will NEVER watch EVER AGAIN (also it was very scary at parts).
Transformers (The Cartoon Movie): Optimis Prime's heroic death was seeing a hero die in battle giving one last final blow to his nemesis. Sad, tragic, and the only way for a true autobot hero to die.
[Teenager]
Godzilla 1985: Godzilla's final death scream as he tumbles into the volcano is enough to bring even the most stoic ToHo fan to tears. The sad music coupled by the wise and profound final words uttered by Steve Martin as the volcano erupts are more than enough to make ANYONE who is not a ToHo fan cry.
Jesus Christ Superstar: I don't believe in the roman catholic church's dogma and I certainly don't believe in the bible's interpretation of events that happened 2,000 years ago but in this movie, even though some now think Paul and Peter were the ones who betrayed Jesus and framed Judas in the process, in this one movie, I have never heard a more haunting requiem of despair and loss than in Judas's song which his actor sings before hanging himself. It's simply...haunting.
[Woman]
A.I. (Artificial Intelligence): I didn't find the boy's fate as sad as what was implied to be humanity's eventual fate (aka our race's destined self-inflicted destruction).