Prime Minister calls incident ‘one of the worst tragedies that our armed forces have experienced on Canadian soil in peacetime’