Catastrophic flooding prompts state of emergency across northeast US