Prime Minister Mark Carney described it as one of the worst peacetime tragedies for the Canadian armed forces