A daredevil adventurer nicknamed "The Spider-Man of Yemen" has died after falling into a volcano crater while attempting to climb a vertical rock face without safety equipment.