Littlefoot's mother and Aerith/Aeris (Final Fantasy VII character)
Both female characters died, although everyone saw Littlefoot's mother's death, while NO ONE could have predicted that Aerith was going to die... stabbed in the back while praying by Sephiroth.