Four people are dead and more than thirty are missing following flooding in western Germany that caused half a dozen houses to collapse, police said on Thursday.