Please don't list this on a work's page as a trope. Examples can go on the work's YMMV tab.
Tear Jerker: Ikaruga
Ikaruga, the spiritual successor to Radiant Silvergun also has quite a sad ending. "Was I useful to you?".
Even more when you realize what happens during that last barrage. Shinra didn't know if his final attack worked or not - the Ikaruga was annihilated a mere second before the explosion.