NTSB investigations, 2022, Outside the U.S.

106 cases where the phase of flight was Enroute.

Cases per year

19622026
NTSB investigations, 2022, Outside the U.S. per year, 1962–2026: 1,774 cases
19623
19632
196423
196521
196618
196726
19689
196922
197015
197111
197219
197316
197414
197519
19763
19778
19788
19794
19812
19823
19843
19861
19871
19886
19891
19901
19912
19941
19972
19981
20001
20022
20032
20041
20071
200810
200930
201031
201139
201253
201357
201451
201571
201689
201777
2018100
2019124
202071
2021119
2022106
2023112
2024152
2025138
202672

Latest cases

Query with SQL
duckdb -csv -c "WITH phase_names(main, name) AS (VALUES (100, 'Prior to flight'), (150, 'Standing'), (200, 'Pushback/towing'), (250, 'Taxi'), (300, 'Takeoff'), (350, 'Initial climb'), (400, 'Enroute'), (450, 'Maneuvering'), (500, 'Approach'), (550, 'Landing'), (600, 'Emergency descent'), (650, 'Uncontrolled descent'), (700, 'Post-impact'), (750, 'After landing'), (800, 'Other'), (990, 'Unknown')),
    crosswalk(code, main, name) AS (VALUES (500, 150, 'Standing'), (501, 150, 'Standing - pre-flight'), (502, 150, 'Standing - starting engine(s)'), (503, 150, 'Standing - engine(s) operating'), (504, 150, 'Standing - engine(s) not operating'), (505, 150, 'Standing - idling rotors'), (510, 250, 'Taxi'), (511, 200, 'Taxi - pushback/tow'), (512, 250, 'Taxi - to takeoff'), (513, 250, 'Taxi - from landing'), (514, 250, 'Taxi - aerial'), (520, 300, 'Takeoff'), (521, 300, 'Takeoff - roll/run'), (522, 350, 'Takeoff - initial climb'), (523, 300, 'Takeoff - aborted'), (530, 400, 'Climb'), (531, 400, 'Climb - to cruise'), (540, 400, 'Cruise'), (541, 400, 'Cruise - normal'), (542, 400, 'Maneuvering - holding (IFR)'), (550, 400, 'Descent'), (551, 400, 'Descent - normal'), (552, 600, 'Descent - emergency'), (553, 650, 'Descent - uncontrolled'), (560, 500, 'Approach'), (561, 500, 'Approach - VFR pattern - downwind'), (562, 500, 'Approach - VFR pattern - base turn'), (563, 500, 'Approach - VFR pattern - base leg/base to final'), (564, 500, 'Approach - VFR pattern - final approach'), (565, 500, 'Go-around (VFR)'), (566, 500, 'Approach - IAF to FAF/outer marker (IFR)'), (567, 500, 'Approach - FAF/outer marker to threshold (IFR)'), (568, 500, 'Circling (IFR)'), (569, 500, 'Missed approach (IFR)'), (570, 550, 'Landing'), (571, 550, 'Landing - flare/touchdown'), (572, 550, 'Landing - roll'), (573, 550, 'Landing - aborted'), (574, 550, 'Emergency landing'), (575, 550, 'Emergency landing after takeoff'), (576, 600, 'Emergency descent/landing'), (580, 450, 'Maneuvering'), (581, 450, 'Maneuvering - aerial application'), (582, 450, 'Maneuvering - turn to reverse direction'), (583, 450, 'Maneuvering - turn to landing area (emergency)'), (590, 450, 'Hover'), (591, 450, 'Hover - in ground effect'), (592, 450, 'Hover - out of ground effect'), (600, 800, 'Other'), (610, 990, 'Unknown')),
    current_codes AS (
      SELECT e.case_mkey, TRY_CAST(e.\"tier1Number\" AS INTEGER) AS code,
        row_number() OVER (PARTITION BY e.case_mkey ORDER BY coalesce(e.\"isDefiningEvent\", false) DESC, e.position) AS n
      FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e
      WHERE e.aircrafts_position = 1 AND e.\"tier1Number\" GLOB '[1-9][0-9]*'
        AND (e.\"isDefiningEvent\" OR e.case_mkey IN (SELECT \"mKey\" FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' WHERE \"isPre1982\"))
    ),
    phases AS (
      SELECT case_mkey, 'current' AS scheme, code, CASE WHEN code >= 990 THEN 990 ELSE code // 50 * 50 END AS main
      FROM current_codes WHERE n = 1
      UNION ALL
      SELECT o.case_mkey, 'older', o.\"phaseOfFlightCode\", w.main
      FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o JOIN crosswalk w ON w.code = o.\"phaseOfFlightCode\"
      WHERE o.aircrafts_position = 1 AND o.\"occurrenceNumber\" = 1 AND o.case_mkey NOT IN (SELECT case_mkey FROM current_codes)
    ),
    case_phases AS (
      SELECT p.*, c.\"eventDate\", c.\"highestInjuryLevel\" = 'Fatal' AS fatal, a.aircraft_model_code
      FROM phases p JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = p.case_mkey
      LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = p.case_mkey AND a.position = 1
      WHERE c.\"eventDate\" >= DATE '1962-01-01' AND p.main IN (SELECT main FROM phase_names)
    )
  SELECT c.\"ntsbNumber\", c.\"eventDate\", c.\"eventType\", c.\"eventCity\", c.\"eventStateOrRegion\", a.n_number, a.\"aircraftMake\", a.\"aircraftModel\", c.\"highestInjuryLevel\", c.\"totalFatal\", c.\"completionStatus\", c.report_url
  FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c.\"mKey\" AND a.position = 1
  WHERE year(c.\"eventDate\") = 2022
    AND c.\"eventCountry\" <> 'USA'
    AND c.\"mKey\" IN (SELECT case_mkey FROM case_phases WHERE main = 400)
  ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

NTSB ENG23WA013Accident · 2 fatalClass 5 · ForeignBombardier CL600 · Venado, MexicoDec 30, 2022 · XB-SGV · DestroyedNTSB GAA23WA097Accident · 1 fatalClass 5 · ForeignCessna 310F · Puerto Vallarta, MexicoDec 27, 2022 · N541DWNTSB DCA23WA102OccurrenceClass 5 · ForeignBoeing 737 · Dunavecse, HungaryDec 27, 2022 · EI-DCZ · No damageNTSB GAA23WA112Incident · No injuriesClass 5 · ForeignBeecraft 200GT · Akureyri, IcelandDec 22, 2022 · TF-MYB · Substantial damageNTSB ENG23WA011IncidentClass 5 · ForeignCessna 525C · Geneva, SwitzerlandDec 20, 2022 · M-KNOXNTSB DCA23WA097Accident · Serious injuriesClass 5 · ForeignBoeing 737-824 · Chiacam, GuatemalaDec 18, 2022 · N87531 · No damageNTSB GAA22WA311Accident · 1 fatalClass 5 · ForeignRobinson Helicopter R44 II · Kildare, IrelandDec 11, 2022 · N999RL · DestroyedNTSB DCA23WA100Incident · No injuriesClass 5 · ForeignBoeing 737-800 · Bangkok, ThailandDec 5, 2022 · HS-LUZ · No damageNTSB DCA23WA087Incident · No injuriesClass 5 · ForeignAirbus A319-115 · Barranquilla, ColombiaDec 2, 2022 · N3014R · No damageNTSB DCA23WA391IncidentClass 5 · ForeignAirbus A330 · Ciudad de la Costa, UruguayDec 1, 2022 · EC-MLP · No damageNTSB DCA23WA083OccurrenceClass 5 · ForeignBoeing 777 · Rosario, Santa Fe, ArgentinaNov 30, 2022 · C-FNNU · Minor damageNTSB GAA23WA035Accident · 1 fatalClass 5 · ForeignRotorway unk · Drummondville, CanadaNov 29, 2022 · unknown · DestroyedNTSB DCA23WA074Incident · No injuriesClass 5 · ForeignBoeing 737 · Maturin, VenezuelaNov 21, 2022 · YV2792 · No damageNTSB GAA23WA034Accident · No injuriesClass 5 · ForeignCirrus Design SR22 · Ronselarestraat, BelgiumNov 16, 2022 · N821CC · Substantial damageNTSB GAA23WA028Incident · No injuriesClass 5 · ForeignBeech 200 · Oxfordshire, United KingdomNov 15, 2022 · GTXRNTSB DCA23WA064Occurrence · No injuriesClass 5 · ForeignBoeing 747-44AF · Almaty, KazakhstanNov 11, 2022 · N573UPNTSB DCA23WA048IncidentClass 5 · ForeignBoeing 737 · Winnipeg, CanadaNov 8, 2022 · C-GEKZ · No damageNTSB ENG23WA004Accident · 7 fatalClass 5 · ForeignAgusta A109 · Apricena, ItalyNov 5, 2022 · I-PIKI · DestroyedNTSB GAA23WA024Accident · 2 fatalClass 5 · ForeignPiper PA32 · Jersey, United KingdomNov 3, 2022 · G-WINS · DestroyedNTSB DCA23WA035Incident · No injuriesClass 4 · ForeignBoeing 737 · Shiraz, IranOct 27, 2022 · A6-FED · No damageNTSB DCA23WA047IncidentClass 5 · ForeignBoeing 777 · Batam, SingaporeOct 25, 2022 · 9V-SWH · No damageNTSB GAA23WA013AccidentClass 5 · ForeignPiper PA30 · Quebec, CanadaOct 22, 2022 · C-FFOWNTSB DCA23WA019IncidentClass 5 · ForeignBoeing 787-9 · Keflavík, IcelandOct 14, 2022 · N823AN · Minor damageNTSB GAA23WA004Accident · Minor injuriesClass 5 · ForeignPilatus BN2A-21 · Kubin, AustraliaOct 3, 2022 · VH-WQA · Substantial damageNTSB DCA23WA116Incident · No injuriesClass 5 · ForeignBoeing 737 · Frankfurt, GermanyOct 3, 2022 · PH-HXB · No damageNTSB DCA23WA012Accident · Minor injuriesClass 5 · ForeignBoeing 737 · Komatsu, Ishikawa, JapanOct 3, 2022 · JA07RK · No damageNTSB GAA22WA291Accident · 1 fatalClass 5 · ForeignChallenger II · Rideau-Ontario, CanadaSep 24, 2022 · C-IYDD · DestroyedNTSB ENG22WA046OccurrenceClass 5 · ForeignATR ATR72 · Vicinity of Sárvár, HungarySep 23, 2022 · YU-ALY · No damageNTSB GAA22WA300Accident · 1 fatalClass 5 · ForeignEmbraer EMB720 · Santa Cruz, BoliviaSep 21, 2022 · CP-2420 · DestroyedNTSB GAA22WA288Incident · No injuriesClass 5 · ForeignCessna 172 · Donji Proložac, CroatiaSep 19, 2022 · 9A-BDMNTSB GAA22WA289Accident · 2 fatalClass 5 · ForeignEvektor EV97 · Sesso, Reggio Emilia, ItalySep 17, 2022 · I-8821 · Substantial damageNTSB DCA22WA204IncidentClass 5 · ForeignBoeing 787 · Mumbai, IndiaSep 14, 2022 · VT-ANM · 2 aircraft · No damageNTSB GAA22WA281AccidentClass 5 · ForeignCessna A188B · Santa Helena de Goias, BrazilSep 9, 2022 · PT-WQN · Substantial damageNTSB GAA22WA268Accident · 4 fatalClass 5 · ForeignCessna 551 · Baltic Sea, LatviaSep 4, 2022 · OE-FGR · DestroyedNTSB GAA22WA275Accident · 3 fatalClass 5 · ForeignCessna R182 · Amberly, AustraliaAug 29, 2022 · VH-EHM · DestroyedNTSB DCA22WA194AccidentClass 5 · ForeignUvify IFO · Darwin, AustraliaAug 18, 2022 · UNREGNTSB GAA22WA250Accident · No injuriesClass 5 · ForeignCessna 172H · Assens, DenmarkAug 11, 2022 · OY-AHY · No damageNTSB GAA22WA246Accident · No injuriesClass 5 · ForeignRobinson R22 · Lotus Vale, AustraliaAug 6, 2022 · VH-NKV · Substantial damageNTSB DCA22WA165AccidentClass 5 · Foreigndrone Viper Pro · Felthorpe, United KingdomJul 30, 2022 · UNREGNTSB ENG22WA035Incident · No injuriesClass 4 · ForeignAirbus A320-214 · Bogota, ColombiaJul 25, 2022 · N562AV · No damageNTSB GAA22WA253Accident · No injuriesClass 5 · ForeignEnstrom F28 · Nurnberg, GermanyJul 19, 2022 · G-ERDW · Substantial damageNTSB GAA22WA234Accident · No injuriesClass 5 · ForeignCessna F150 · Gödöllo, HungaryJul 19, 2022 · HA-BIF · Substantial damageNTSB DCA22WA154IncidentClass 5 · ForeignBoeing 737 · Wave Rock, AustraliaJul 18, 2022 · VH-VZO · No damageNTSB GAA22WA232Accident · 1 fatalClass 5 · ForeignChampion 7GCBC · Trois Riviere, Quebec, CanadaJul 17, 2022 · C-GOQZ · Substantial damageNTSB DCA22WA152Accident · Serious injuriesClass 5 · ForeignBoeing 737 · Naha, JapanJul 16, 2022 · JA807X · No damageNTSB ENG22WA033IncidentClass 4 · ForeignAirbus A320 · Shymkent, KazakhstanJul 9, 2022 · EI-KBJ · No damageNTSB DCA22WA150OccurrenceClass 5 · ForeignBoeing 737 · Athens, GreeceJul 8, 2022 · PH-CDF · No damageNTSB GAA22WA249Accident · No injuriesClass 5 · ForeignPiper PA-32R-301T · Tamaulipas, MexicoJul 6, 2022 · N3577D · Substantial damageNTSB GAA22WA217IncidentClass 5 · ForeignPiper PA28 · Blackpool, United KingdomJun 29, 2022 · G-BORL · No damageNTSB GAA22WA212AccidentClass 5 · ForeignSikorsky S76D · Mumbai, IndiaJun 28, 2022 · VT-PWI · Substantial damage