Today's story comes from folklore, not history - while I am pretty sure that love and yearning has killed quite a few people over the centuries, I couldn't find a good example. However, I am in the process of translating this really dark Hungarian folktale into English, and it just happens to start with death by yearning. So, here it is.
(Folktale collected and published by János Erdélyi in 1855)
The Princess' Curse
While the younger brother was away, the older brother also came to visit the princess. The moment he saw her, he wanted her for himself. He spent days and weeks trying to seduce her, telling her tales of how his younger brother was a liar, a cheat, a good-for nothing... But the princess knew better, and didn't believe a word of it.
Three years passed, and the younger prince returned home. His brother was already waiting for him, ready with a lie: He said the princess forgot him, didn't want him anymore, and in fact was engaged to someone else. The younger prince, heartbroken, locked himself into his room. The princess waited and waited, but her lover didn't return; she stopped eating and grew thin and pale. One day she told her father that if her lover didn't return in three days, she would surely die; once dead, she asked to be buried in the crypt inside the cathedral, and her resting place to be guarded by armed men.
Three days passed, and the prince didn't appear - the princess breathed her last. She was dressed in silk and brocade, and laid to rest in a coffin inside the cathedral crypt. The bells rang, the city was covered in black drapes, and everyone mourned the princess. Just as the funeral was ending, the older prince walked into town, and was shocked to find out that the princess was dead (he hoped that she would give up on her love for the young prince and be willing to marry him instead). He went straight to the king, and volunteered to be the first armed guard to stand vigil at the princess' grave.
Night fell, and the prince stood by the crypt alone, in the quiet of the church. But just as the bells tolled ten o'clock, the door of the crypt opened with terrible screeching and crackling, and our came the princess, her face pale and terrible.
"You lied to me and you lied to the one I loved! For that, you shall die."
And with that, she tore the prince to pieces, and left his bones in a pile on the floor. Then, she returned into her crypt, and the door shut behind her with a resounding crack.
The next day the younger prince finally appeared in court, asking the king what happened. He was devastated to find out that the princess was dead, and so was his brother. He volunteered to guard the crypt that night.
As the bells tolled ten, the crypt opened once again, and the younger prince was faced with the woman he had loved, her face pale and terrible.
"You gave up on me!" she screeched "You believed the lies about me! For that, you shall die."
She tore the younger prince to pieces, and left his bones in a pile on the ground.
Things went the same way every night after that. No matter how many people volunteered, no matter how much gold the king offered to anyone who could survive one night, no one left the cathedral alive in the morning.
Until one tired soldier called János wandered into town one day...
(The rest of the folktale follows folktale type 307, The Princess in the Shroud)
(Storytellers: If you want the full story let me know, I'll send you a full translation!)