The two stories that can relate to one another by tragedy taking over at the end of the story are: "The tragedy of Sohrab and Rostam" and the "Gilgamesh". Most of the time when there is a hero in a play, it would end with some sort of tragic loss. While a hero can posses special powers, he will use them despite the consequences that he will face afterwards.

In the story "The tragedy of Sohrab and Rostam", Rostam is the hero of the Persian army, and Sohrab grew up becoming the best fighter of Turan army. Rostam was the father of Sohrab, but unfortunately they never met face to face until the war between Iran and Turan started. Since everyone was scared to fight Rostam, they sent Sohrab to challenge him, but they never told him the challengers name. After a brutal battle Rostam feels like he might lose, and didn't want to ruin his reputation, so he stabbed Sohrab in the heart. He remembers giving Tahmina an bracelet to give to her son, and realizes that this is his son because he is wearing the same bracelet.
From then on, regret and pain stayed with him for rest of his

While in the epic story Gilgamesh, the Gods decide that Enkidu needs to die, because he and Gilgamesh have slain Humbaba the protector of the cedar forest, and the bull of heaven. For most of the part Enkidu was innocent, because Gilgamesh will abuse his un humanlike powers wherever he would go. Once Enkidu passes away Gilgamesh agonizingly cries after Enkidu ,willing to do anything to bring him to life. He carves a stone with Enkidu's name on it, to show respect and the importance of him being in Gilgamesh's life.
As you can see it's great to be a hero, but when you abuse your powers and let your ego take over, tragic moments will occur.