NTSB investigations, 2025, Outside the U.S.

138 cases where the phase of flight was Enroute.

Cases per year

19622026
NTSB investigations, 2025, 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\") = 2025
    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 GAA26WA055Accident · No injuriesClass 5 · ForeignCessna A188 · Chuy, UruguayDec 23, 2025 · N · Substantial damageNTSB DCA26WA078Accident · Serious injuriesClass 5 · ForeignBoeing 787 · Chiba, JapanDec 22, 2025 · JA865J · No damageNTSB GAA26WA058Accident · No injuriesClass 5 · ForeignBeech B200 · Porto Vehlo, BrazilDec 20, 2025 · PS-GAC · Substantial damageNTSB GAA26WA057Accident · 1 fatalClass 5 · ForeignLancair 360 · Mazarambroz, SpainDec 17, 2025 · EC-XXD · Substantial damageNTSB GAA26WA062IncidentClass 5 · ForeignLockheed Martin C-130H · Katanning, AustraliaDec 16, 2025 · N382CG · No damageNTSB GAA26WA051Accident · 2 fatalClass 5 · ForeignBell 206 · Ranana, New ZealandDec 13, 2025 · ZK-IWZ · Substantial damageNTSB GAA26WA048Accident · Minor injuriesClass 5 · ForeignCessna 172N · Serakseevo township, RussiaDec 13, 2025 · RA-67438 · DestroyedNTSB GAA26WA047Accident · Minor injuriesClass 5 · ForeignCessna 172 · Trinidad, BoliviaDec 11, 2025 · CP-2959 · Substantial damageNTSB DCA26WA138Incident · No injuriesClass 5 · ForeignATR ATR42 · Hakodate, JapanDec 11, 2025 · JA14HC · No damageNTSB DCA26WA075IncidentClass 5 · ForeignBoeing 737 · Balice, PolandDec 8, 2025 · 9H-VUE · No damageNTSB GAA26WA042Accident · No injuriesClass 5 · ForeignPiper PA32RT · Maracaibo, VenezuelaDec 6, 2025 · YV1560 · Substantial damageNTSB DCA26WA057Incident · No injuriesClass 5 · ForeignBoeing 767 · Nan Ning Shi, ChinaDec 3, 2025 · 9M-RXE · No damageNTSB GAA26WA035Accident · No injuriesClass 5 · ForeignRobinson R22 · Chillagoe, AustraliaDec 2, 2025 · VH-HFQ · DestroyedNTSB GAA26WA031Accident · No injuriesClass 5 · ForeignBell 206 · Uruyen, VenezuelaNov 24, 2025 · YV3004 · Substantial damageNTSB DCA26WA043AccidentClass 5 · ForeignBoeing 737 · Tomakomai, JapanNov 22, 2025 · JA737X · Substantial damageNTSB ENG26WA008IncidentClass 5 · ForeignAirbus A340 · Sakaka, Saudi ArabiaNov 11, 2025 · HB-JMF · Minor damageNTSB DCA26WA038OccurrenceClass 5 · ForeignEmbraer ERJ170 · Toronto, CanadaNov 8, 2025 · C-FEKJ · No damageNTSB ENG26WA010OccurrenceClass 5 · ForeignDe Havilland DHC3 · Lake Rotorua, New ZealandNov 6, 2025 · ZK-VAS · No damageNTSB ENG26WA007OccurrenceClass 5 · ForeignAirbus A321 · Mexico City, MexicoNov 6, 2025 · XA-VUK · No damageNTSB GAA26WA020Accident · No injuriesClass 5 · ForeignCessna 172 · Trinidad, BoliviaNov 4, 2025 · CP-2719 · Substantial damageNTSB DCA26WA029Incident · No injuriesClass 5 · ForeignMcdonnell Douglas MD88 · Mashhad, IranNov 4, 2025 · EP-TBF · Minor damageNTSB GAA26WA019Accident · 1 fatalClass 4 · ForeignRans S9 · San Felipe, ChileOct 29, 2025 · ULM-200 · DestroyedNTSB GAA26WA046Incident · No injuriesClass 5 · ForeignCirrus SF50 · Oberweningen, SwitzerlandOct 28, 2025 · SP-SGW · No damageNTSB GAA26WA013Incident · No injuriesClass 5 · ForeignCessna 210 · Ilopango, El SalvadorOct 25, 2025 · N9417TNTSB GAA26WA200Accident · 1 fatalClass 5 · ForeignBRM Aero Bristell NG5 · Bacani, Vaslui, RomaniaOct 23, 2025 · YR-5439 · DestroyedNTSB DCA26WA020Incident · No injuriesClass 5 · ForeignBoeing 737 · Bintulu, MalaysiaOct 21, 2025 · 9M-MXR · No damageNTSB ENG26WA003Incident · No injuriesClass 4 · ForeignSikorsky S92 · Rio De Janeiro, BrazilOct 15, 2025 · PR-BGM · Minor damageNTSB DCA26WA056Incident · No injuriesClass 3 · ForeignBoeing 737 · Buenos Aires, ArgentinaOct 15, 2025 · LV-FSK · No damageNTSB GAA26WA010Accident · 3 fatalClass 5 · ForeignCessna TU206 · Tecpan, GuatemalaOct 14, 2025 · TG-DJE · Substantial damageNTSB DCA26WA004IncidentClass 5 · ForeignBoeing 777 · Nassau, BahamasOct 10, 2025 · G-VIIGNTSB DCA26WA011Incident · No injuriesClass 5 · ForeignBoeing 767 · Ochiltree, United KingdomOct 9, 2025 · G-DHLS · No damageNTSB GAA26WA005AccidentClass 5 · ForeignRobinson R44 · Horn Island, AustraliaOct 8, 2025 · VH-XSO · Substantial damageNTSB GAA26WA004Accident · 2 fatalClass 5 · ForeignCessna 172 · Santa Ana del Yacuma, BoliviaOct 4, 2025 · CP-3062 · 2 aircraftNTSB GAA26WA001Incident · No injuriesClass 5 · ForeignCessna F172 · Durup, DenmarkOct 1, 2025 · OY-JEP · No damageNTSB DCA25WA346IncidentClass 5 · ForeignBoeing 737 · Smuka, SloveniaSep 29, 2025 · G-DRTJ · No damageNTSB GAA25WA291Accident · 1 fatalClass 5 · ForeignPilatus PC6 · Moruya, AustraliaSep 27, 2025 · VH-XAA · DestroyedNTSB GAA25WA269AccidentClass 5 · ForeignBeech 58 · Balkova, CzechiaSep 22, 2025 · OK-PHR · DestroyedNTSB GAA25WA263Accident · 2 fatalClass 5 · ForeignBell 412 · Talpa de Allende, MexicoSep 22, 2025 · XA-BND · Substantial damageNTSB DCA26WA006Incident · No injuriesClass 5 · ForeignBoeing 737 · Cape Town, South AfricaSep 22, 2025 · ZS-SJUNTSB GAA25WA257Accident · No injuriesClass 5 · ForeignVulcanair P68 · Antofagasta, ChileSep 15, 2025 · CC-DEP · No damageNTSB DCA25WA324Incident · Minor injuriesClass 5 · ForeignBoeing 737-824 · Osaka, JapanSep 12, 2025 · N39297 · No damageNTSB GAA25WA256Accident · No injuriesClass 5 · ForeignCessna 150 · Montevideo, UruguaySep 11, 2025 · CX-CBJ · Substantial damageNTSB DCA25WA345Incident · No injuriesClass 5 · ForeignBoeing 777-222 · Ezeiza, ArgentinaSep 9, 2025 · N796UA · No damageNTSB GAA25WA258Occurrence · No injuriesClass 4 · ForeignSukhoi SU31 · Lvivuk, UkraineSep 5, 2025 · N131GT · No damageNTSB GAA25WA259Accident · No injuriesClass 5 · ForeignCessna U206 · Alto Alegre, BrazilSep 3, 2025 · PS-SLM · Substantial damageNTSB DCA25WA325IncidentClass 5 · ForeignAirbus A320 · Chennai, IndiaSep 1, 2025 · VT-ATF · No damageNTSB ENG25WA051IncidentClass 5 · ForeignBoeing 727 · Caracas, VenezuelaAug 26, 2025 · YV665T · No damageNTSB GAA25WA243Accident · 4 fatalClass 3 · ForeignCessna TU206 · Mitu, ColombiaAug 24, 2025 · HK1833 · DestroyedNTSB GAA25WA245Accident · No injuriesClass 5 · ForeignEmbraer EMB721 · Cano Negro, BoliviaAug 18, 2025 · CP-2003 · Substantial damageNTSB GAA25WA260Accident · 1 fatalClass 4 · ForeignAerospool WT9 Dynamic LSA · Orbe, SwitzerlandAug 16, 2025 · HB-WZN · Substantial damage