A waterspout was spotted swirling over the water off the coast of Cape Cod and a funnel cloud was seen on the Pennsylvania and Delaware state line.