A US border patrol agent has been killed following a traffic stop near the Canadian frontier, officials say.