The near-death ordeal left multiple people needing hospital treatment, with one tourist from Portsmouth describing it as 'the most terrifying experience of my life'