You shouldn't need a visa to flagpole at the US, regardless of mode of transport or citizenship. You are not looking to enter the US, you're looking to leave Canada. So when you get to the border it's ok if you don't get let in to the States, they'll just send you back where you came from, which...