A Yemeni adventurer, known as “The Spider-Man of Yemen,” has died after falling into a volcano crater, authorities said