NTSB investigations, 2024, Outside the U.S.

152 cases where the phase of flight was Enroute.

Cases per year

19622026
NTSB investigations, 2024, 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\") = 2024
    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 DCA25WA079Accident · 1 fatalClass 3 · ForeignAirbus Canada A220 · Graz, AustriaDec 23, 2024 · HB-JCD · Minor damageNTSB GAA25WA203Accident · 7 fatalClass 5 · ForeignCessna C207 · Nayarit, MexicoDec 22, 2024 · XB-MLO · DestroyedNTSB GAA25WA043Accident · Minor injuriesClass 5 · ForeignRobinson R44 · Los Lagos, ChileDec 14, 2024 · CC-AHA · Substantial damageNTSB GAA25WA059Accident · 1 fatalClass 4 · ForeignPiper PA25 · Nova Monte, BrazilDec 12, 2024 · PR-BMJ · Substantial damageNTSB ENG25WA058IncidentClass 5 · ForeignATR ATR72 · Zagreb, CroatiaDec 12, 2024 · SP-SPG · No damageNTSB GAA25WA040AccidentClass 5 · ForeignCessna 172 · Örebro, SwedenDec 11, 2024 · SE-LGL · Minor damageNTSB GAA25WA060Accident · Minor injuriesClass 5 · ForeignCessna 182 · Paranagua, BrazilDec 10, 2024 · PR-SDC · Substantial damageNTSB ENG25WA014IncidentClass 5 · ForeignHawker Hawker 900 · Abuja, NigeriaDec 6, 2024 · 5N-KAL · Minor damageNTSB ENG25WA013OccurrenceClass 5 · ForeignBoeing 737-9 · Cancún, MexicoDec 3, 2024 · N115AM · No damageNTSB DCA25LA055Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 787-9 · Pacific Ocean, Hong Kong SAR ChinaAn encounter with unexpected turbulence during descent.Dec 3, 2024 · N29975 · No damageNTSB GAA25WA036Accident · Serious injuriesClass 5 · ForeignCessna 340A · Magny-lès-Villers, FranceDec 2, 2024 · N340GJ · DestroyedNTSB DCA25WA050IncidentClass 5 · ForeignBoeing 737-700 · Windhoek, NamibiaDec 2, 2024 · D2-TBG · No damageNTSB ENG25WA010IncidentClass 5 · ForeignAirbus A320 · Aukland, New ZealandDec 1, 2024 · ZK-NHA · No damageNTSB GAA25WA032Accident · 5 fatalClass 5 · ForeignCessna U206 · Cantón Central San José y Distrito de Pavas, Costa RicaNov 25, 2024 · TI-GER · Substantial damageNTSB DCA25LA047Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 777-223 · Brasilia, BrazilThe airplane’s encounter with unanticipated turbulence during cruise flight, which resulted in serious injury to one passenger who was not seated.Nov 24, 2024 · N753AN · No damageNTSB GAA25WA033Accident · 2 fatalClass 5 · ForeignPiper PA-28-140 · Cimanes del Tejar, SpainNov 22, 2024 · EC-CAZ · DestroyedNTSB GAA25WA034Accident · 1 fatalClass 5 · ForeignCessna 188 · Quirinopolis, BrazilNov 20, 2024 · PT-DRB · Substantial damageNTSB DCA25LA044Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 787-9 · Tokyo, JapanAn encounter with turbulence while in cruise flight, resulting in serious injuries to two flight attendants.Nov 15, 2024 · N833AA · No damageNTSB GAA25WA289Accident · No injuriesClass 4 · ForeignBombardier N/A · Hannover, GermanyNov 13, 2024 · VT-TUS · No damageNTSB DCA25WA043OccurrenceClass 5 · ForeignBoeing 737 · Brisbaine, AustraliaNov 13, 2024 · VH-VXC · No damageNTSB DCA25WA033Incident · No injuriesClass 5 · ForeignAirbus A320-214 · Monteria, ColombiaNov 9, 2024 · N957AV · No damageNTSB GAA25WA026Accident · Minor injuriesClass 5 · ForeignPiper PA31 · Puebla, MexicoNov 7, 2024 · XB-FVF · Substantial damageNTSB ENG25WA008Incident · No injuriesClass 5 · ForeignPilatus PC12 · Geneva, SwitzerlandNov 3, 2024 · 9H-EHA · No damageNTSB DCA25LA023Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 767-322 · Kingston, JamaicaAn inadvertent encounter with convective turbulence while in enroute cruise flight.Nov 3, 2024 · N651UA · No damageNTSB DCA25WA035IncidentClass 5 · ForeignBoeing 787 · Jeddah, Saudi ArabiaNov 2, 2024 · F-OLRC · No damageNTSB DCA25WA019IncidentClass 5 · ForeignAirbus A330 · International Waters, South AfricaOct 27, 2024 · ZS-SXJ · No damageNTSB GAA25WA075OccurrenceClass 5 · ForeignBeech 200 · Pillanesburg, South AfricaOct 24, 2024 · SZ-SSPNTSB ENG25WA007IncidentClass 5 · ForeignBombardier Global 7500 · Amsterdam, NetherlandsOct 15, 2024 · 9H-VISTA · Minor damageNTSB GAA25WA013Accident · 1 fatalClass 5 · ForeignAir Tractor AT502 · Ouro Preto - Minas Gerais, BrazilOct 11, 2024 · PS-SLR · DestroyedNTSB GAA25WA011Accident · No injuriesClass 5 · ForeignBeech 200 · Qld, AustraliaOct 9, 2024 · VH-ZMW · Substantial damageNTSB GAA25WA009Accident · Minor injuriesClass 5 · ForeignCessna U206 · Barinas, VenezuelaOct 8, 2024 · YV1993 · DestroyedNTSB GAA25WA021Accident · No injuriesClass 5 · ForeignEmbraer 500 · Centerline, FranceOct 7, 2024 · G-HARG · Minor damageNTSB GAA25WA010Accident · Minor injuriesClass 4 · ForeignPiper PA25 · Itariri, BrazilOct 7, 2024 · PT-OSQ · Substantial damageNTSB GAA25WA006Accident · No injuriesClass 5 · ForeignCessna 172RG · Ejido de Treinta y Tres, UruguayOct 6, 2024 · CX-PAFNTSB GAA25WA004Incident · No injuriesClass 4 · ForeignCessna T188 · Sector Payo, EcuadorOct 3, 2024 · HCBRN · Minor damageNTSB DCA24WA327IncidentClass 4 · ForeignEmbraer ERJ190 · MexicoSep 27, 2024 · XA-ACCNTSB GAA24WA305Incident · No injuriesClass 5 · ForeignRobinson R44 · Warsaw, PolandSep 22, 2024 · SP-CBW · No damageNTSB DCA24WA326Incident · No injuriesClass 5 · ForeignAirbus A330 · Algiers, AlgeriaSep 22, 2024 · 9H-HFHNTSB GAA24WA295Accident · No injuriesClass 5 · ForeignPilatus PC12 · Thunder Bay, CanadaSep 21, 2024 · C-GFKA · Substantial damageNTSB DCA24WA331IncidentClass 5 · ForeignAirbus A320 · Bordeaux-Merignac, FranceSep 20, 2024 · EI-NSF · No damageNTSB DCA24WA310IncidentClass 5 · ForeignMcdonnell Douglas MD83 · Nueva Esparta, VenezuelaSep 20, 2024 · YV647T · No damageNTSB DCA24WA313IncidentClass 5 · ForeignDouglas DC9 · Maiquetia, VenezuelaSep 16, 2024 · YV1240 · No damageNTSB GAA24WA286Accident · No injuriesClass 5 · ForeignCessna 152 · Buntingford, United KingdomSep 15, 2024 · G-CMAH · Substantial damageNTSB GAA24WA290Incident · No injuriesClass 5 · ForeignEmbraer EMB550 · Bromma, SwedenSep 11, 2024 · 9H-MFX · No damageNTSB GAA24WA287Accident · No injuriesClass 5 · ForeignKawasaki KH4 · Tindal, AustraliaSep 11, 2024 · VH-BEU · Substantial damageNTSB ENG24WA036AccidentClass 5 · ForeignBeech 200 · Egedesminde, GreenlandSep 9, 2024 · TF-NLA · Substantial damageNTSB GAA24WA293Accident · 2 fatalClass 5 · ForeignCessna 172 · Soest, GermanySep 7, 2024 · D-ECHF · DestroyedNTSB DCA24WA297AccidentClass 5 · ForeignBoeing 787-9 · Guangzhou, ChinaSep 6, 2024 · 9V-OJD · Minor damageNTSB DCA24WA298Accident · Serious injuriesClass 5 · ForeignBoeing 787 · Tokyo, JapanSep 4, 2024 · JA863J · Minor damageNTSB GAA24WA272Accident · 1 fatalClass 5 · ForeignBeech 58 · Amatschonjoch, AustriaAug 26, 2024 · N558AB · Destroyed