A man in his 30s "nearly died" when he fell down a 20ft waterfall at a Lancashire beauty spot, with the shocking incident caught on camera.