At least 18 people have died after torrential rain caused significant flooding across several states in the Midwest and South.