At least six people died, and two others were missing, after flash floods swept through North Carolina on Thursday