A daredevil social media free-climber nicknamed the "Spider-Man of Yemen" has died after falling into a volcanic crater in the country's south-west.