Two people were taken to hospital after a dramatic crash on a busy road around a Sheffield estate.