SELECT 
  YEAR("date") "year", 
  COUNT (DISTINCT "unnamed_0") "crashes", 
  SUM(CAST(REGEXP_EXTRACT("fatal", '([0-9]+)') AS INT)) "fatalities"
FROM @kaggle.aryan112345_worst_plane_crashes_in_history.plane_crash_info
GROUP BY "year"
ORDER BY "year"