Torrential downpours and historic flash flooding prompted a state of emergency in Missouri