Canada's PM Mark Carney described the incident as "one of the worst tragedies" for the country's military in peacetime