The rider, from the Isle of Man, was competing in his second Manx Grand Prix and died on Wednesday afternoon, organisers tragically confirmed later the same day