NTSB investigations, 2025, Outside the U.S.
138 cases where the phase of flight was Enroute.
Cases per year
| 1962 | 3 |
|---|---|
| 1963 | 2 |
| 1964 | 23 |
| 1965 | 21 |
| 1966 | 18 |
| 1967 | 26 |
| 1968 | 9 |
| 1969 | 22 |
| 1970 | 15 |
| 1971 | 11 |
| 1972 | 19 |
| 1973 | 16 |
| 1974 | 14 |
| 1975 | 19 |
| 1976 | 3 |
| 1977 | 8 |
| 1978 | 8 |
| 1979 | 4 |
| 1981 | 2 |
| 1982 | 3 |
| 1984 | 3 |
| 1986 | 1 |
| 1987 | 1 |
| 1988 | 6 |
| 1989 | 1 |
| 1990 | 1 |
| 1991 | 2 |
| 1994 | 1 |
| 1997 | 2 |
| 1998 | 1 |
| 2000 | 1 |
| 2002 | 2 |
| 2003 | 2 |
| 2004 | 1 |
| 2007 | 1 |
| 2008 | 10 |
| 2009 | 30 |
| 2010 | 31 |
| 2011 | 39 |
| 2012 | 53 |
| 2013 | 57 |
| 2014 | 51 |
| 2015 | 71 |
| 2016 | 89 |
| 2017 | 77 |
| 2018 | 100 |
| 2019 | 124 |
| 2020 | 71 |
| 2021 | 119 |
| 2022 | 106 |
| 2023 | 112 |
| 2024 | 152 |
| 2025 | 138 |
| 2026 | 72 |
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.
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" DESCRun it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB GAA26WA055Accident · No injuriesClass 5 · ForeignCessna A188 · Chuy, UruguayNTSB DCA26WA078Accident · Serious injuriesClass 5 · ForeignBoeing 787 · Chiba, JapanNTSB GAA26WA058Accident · No injuriesClass 5 · ForeignBeech B200 · Porto Vehlo, BrazilNTSB GAA26WA057Accident · 1 fatalClass 5 · ForeignLancair 360 · Mazarambroz, SpainNTSB GAA26WA062IncidentClass 5 · ForeignLockheed Martin C-130H · Katanning, AustraliaNTSB GAA26WA051Accident · 2 fatalClass 5 · ForeignBell 206 · Ranana, New ZealandNTSB GAA26WA048Accident · Minor injuriesClass 5 · ForeignCessna 172N · Serakseevo township, RussiaNTSB GAA26WA047Accident · Minor injuriesClass 5 · ForeignCessna 172 · Trinidad, BoliviaNTSB DCA26WA138Incident · No injuriesClass 5 · ForeignATR ATR42 · Hakodate, JapanNTSB DCA26WA075IncidentClass 5 · ForeignBoeing 737 · Balice, PolandNTSB GAA26WA042Accident · No injuriesClass 5 · ForeignPiper PA32RT · Maracaibo, VenezuelaNTSB DCA26WA057Incident · No injuriesClass 5 · ForeignBoeing 767 · Nan Ning Shi, ChinaNTSB GAA26WA035Accident · No injuriesClass 5 · ForeignRobinson R22 · Chillagoe, AustraliaNTSB GAA26WA031Accident · No injuriesClass 5 · ForeignBell 206 · Uruyen, VenezuelaNTSB DCA26WA043AccidentClass 5 · ForeignBoeing 737 · Tomakomai, JapanNTSB ENG26WA008IncidentClass 5 · ForeignAirbus A340 · Sakaka, Saudi ArabiaNTSB DCA26WA038OccurrenceClass 5 · ForeignEmbraer ERJ170 · Toronto, CanadaNTSB ENG26WA010OccurrenceClass 5 · ForeignDe Havilland DHC3 · Lake Rotorua, New ZealandNTSB ENG26WA007OccurrenceClass 5 · ForeignAirbus A321 · Mexico City, MexicoNTSB GAA26WA020Accident · No injuriesClass 5 · ForeignCessna 172 · Trinidad, BoliviaNTSB DCA26WA029Incident · No injuriesClass 5 · ForeignMcdonnell Douglas MD88 · Mashhad, IranNTSB GAA26WA019Accident · 1 fatalClass 4 · ForeignRans S9 · San Felipe, ChileNTSB GAA26WA046Incident · No injuriesClass 5 · ForeignCirrus SF50 · Oberweningen, SwitzerlandNTSB GAA26WA013Incident · No injuriesClass 5 · ForeignCessna 210 · Ilopango, El SalvadorNTSB GAA26WA200Accident · 1 fatalClass 5 · ForeignBRM Aero Bristell NG5 · Bacani, Vaslui, RomaniaNTSB DCA26WA020Incident · No injuriesClass 5 · ForeignBoeing 737 · Bintulu, MalaysiaNTSB ENG26WA003Incident · No injuriesClass 4 · ForeignSikorsky S92 · Rio De Janeiro, BrazilNTSB DCA26WA056Incident · No injuriesClass 3 · ForeignBoeing 737 · Buenos Aires, ArgentinaNTSB GAA26WA010Accident · 3 fatalClass 5 · ForeignCessna TU206 · Tecpan, GuatemalaNTSB DCA26WA004IncidentClass 5 · ForeignBoeing 777 · Nassau, BahamasNTSB DCA26WA011Incident · No injuriesClass 5 · ForeignBoeing 767 · Ochiltree, United KingdomNTSB GAA26WA005AccidentClass 5 · ForeignRobinson R44 · Horn Island, AustraliaNTSB GAA26WA004Accident · 2 fatalClass 5 · ForeignCessna 172 · Santa Ana del Yacuma, BoliviaNTSB GAA26WA001Incident · No injuriesClass 5 · ForeignCessna F172 · Durup, DenmarkNTSB DCA25WA346IncidentClass 5 · ForeignBoeing 737 · Smuka, SloveniaNTSB GAA25WA291Accident · 1 fatalClass 5 · ForeignPilatus PC6 · Moruya, AustraliaNTSB GAA25WA269AccidentClass 5 · ForeignBeech 58 · Balkova, CzechiaNTSB GAA25WA263Accident · 2 fatalClass 5 · ForeignBell 412 · Talpa de Allende, MexicoNTSB DCA26WA006Incident · No injuriesClass 5 · ForeignBoeing 737 · Cape Town, South AfricaNTSB GAA25WA257Accident · No injuriesClass 5 · ForeignVulcanair P68 · Antofagasta, ChileNTSB DCA25WA324Incident · Minor injuriesClass 5 · ForeignBoeing 737-824 · Osaka, JapanNTSB GAA25WA256Accident · No injuriesClass 5 · ForeignCessna 150 · Montevideo, UruguayNTSB DCA25WA345Incident · No injuriesClass 5 · ForeignBoeing 777-222 · Ezeiza, ArgentinaNTSB GAA25WA258Occurrence · No injuriesClass 4 · ForeignSukhoi SU31 · Lvivuk, UkraineNTSB GAA25WA259Accident · No injuriesClass 5 · ForeignCessna U206 · Alto Alegre, BrazilNTSB DCA25WA325IncidentClass 5 · ForeignAirbus A320 · Chennai, IndiaNTSB ENG25WA051IncidentClass 5 · ForeignBoeing 727 · Caracas, VenezuelaNTSB GAA25WA243Accident · 4 fatalClass 3 · ForeignCessna TU206 · Mitu, ColombiaNTSB GAA25WA245Accident · No injuriesClass 5 · ForeignEmbraer EMB721 · Cano Negro, BoliviaNTSB GAA25WA260Accident · 1 fatalClass 4 · ForeignAerospool WT9 Dynamic LSA · Orbe, Switzerland