Prime Minister Mark Carney called the incident one of the ‘worst tragedies’ Canada has seen during peacetime