A man has been taken to hospital after a dramatic crash which caused disruption in a Sheffield neighbourhood this afternoon.