The mythological figure cursed to turn into stone upon looking at others is Medusa. Once a beautiful maiden, she was transformed by the goddess Athena as punishment. This curse makes her a tragic character in Greek mythology, and her ability to petrify others symbolizes the fear and consequences of emotional isolation and rage.