They don't need an oil pipeline in the NE US.  They don't have a lot of refineries.  Like Eastern Canada, refineries in the US Northeast can't refine heavy crude, and they get their oil by ship.  In fact, they buy most of Newfoundland's light oil and most of Irving's refined products by ship, plus refined products from Texas by pipeline. 

There is an old oil pipeline of 100,000 bbl/day between Montreal and Portland, Maine owned by Suncor and Exxon.  It had been used to import light oil to Montreal, but with reversal of line 9, it's not used now.  The owners are trying to reverse it to ship bitumen south.  The city does not want bitumen crossing their drinking water sources so they enacted a law banning loading and shipping of oil from their port to prevent it.  Blame Kalamazoo.  It's before the courts now.