NTSB investigations, 2023, Outside the U.S.
112 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\") = 2023
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") = 2023
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 GAA24WA077Accident · No injuriesClass 5 · ForeignVans RV6 · Smaalandsfarvandet, DenmarkNTSB GAA24WA059Accident · No injuriesClass 5 · ForeignPiper PA28 · Carmo da Cachoeira, BrazilNTSB ENG24WA007Incident · Minor injuriesClass 5 · ForeignGrumman G21 · Bella Bella, CanadaNTSB GAA24WA056Accident · No injuriesClass 5 · ForeignCessna F150 · Budapest, HungaryNTSB DCA24WA149Accident · 1 fatalClass 5 · ForeignRobinson R22 · Tindal, AustraliaNTSB GAA24WA050Accident · Serious injuriesClass 5 · ForeignPiper PA30 · Villejuif, FranceNTSB GAA24WA041Accident · No injuriesClass 4 · ForeignPiper 32 · Mhlambanyatsi, WZNTSB DCA24WA027Incident · No injuriesClass 5 · ForeignBoeing 737 · Surat Thani, ThailandNTSB GAA24WA035AccidentClass 5 · ForeignCessna 152 · Licab Zaragosa, PhilippinesNTSB ENG24LA009IncidentClass 3 · LimitedPreliminary reportAirbus A319 · Schiphol, NetherlandsOn November 10, 2023 at 0713 UTC, a Lufthansa Airbus A319, registration D-AIBG, experienced the loss of both electrical generators during approach to Amsterdam Airport Schiphol, Netherlands. The airplane’s ram air turbine deployed automatically. The airplane…NTSB ENG24WA004IncidentClass 5 · ForeignBoeing 787 · Addis Ababa, EthiopiaNTSB GAA24WA028Accident · 3 fatalClass 5 · ForeignGulfstream 695A · Cloncurry, AustraliaNTSB GAA24WA125Accident · No injuriesClass 5 · Foreignreims F406 · Farm Erindi, NamibiaNTSB ENG24WA005Accident · No injuriesClass 5 · ForeignSikorsky S76 · Sidney, CanadaNTSB DCA24WA013IncidentClass 5 · ForeignBoeing 737 · Stocksbridge, United KingdomNTSB GAA24WA010Accident · 2 fatalClass 4 · ForeignBell 206 · Bondeno, ItalyNTSB GAA24WA009Accident · 2 fatalClass 5 · ForeignDiamond DA20 · Almeria, SpainNTSB GAA24WA018Accident · 3 fatalClass 5 · ForeignPiper PA 34 · Chilliwack BC, CanadaNTSB DCA24WA012Accident · No injuriesClass 5 · ForeignAirbus A321 · Essex, United KingdomNTSB GAA23WA273Accident · 1 fatalClass 5 · ForeignCessna 172 · Uk, GermanyNTSB DCA23WA463Incident · No injuriesClass 5 · ForeignBoeing 737 · Guayaquil, EcuadorNTSB GAA23WA278Accident · No injuriesClass 3 · ForeignDe Havilland DHC2 · Campbel River, CanadaNTSB ENG23WA041IncidentClass 3 · ForeignAirbus A320 · Almaty, KazakhstanNTSB ENG23WA042Incident · No injuriesClass 5 · ForeignAirbus A320 · Enroute Bogota - Barranquilla, ColombiaNTSB GAA23WA255Accident · 1 fatalClass 5 · ForeignRobinson R44 · Vologda Oblast, RussiaNTSB ENG23WA037IncidentClass 5 · ForeignAirbus A321 · Changi, Singapore, SingaporeNTSB DCA23WA455IncidentClass 5 · ForeignBoeing 737 · Ballina, AustraliaNTSB ENG23WA044Accident · 2 fatalClass 5 · ForeignChristen Eagle II · Raufoss, NorwayNTSB DCA23WA429IncidentClass 4 · ForeignBoeing 737 · Palma de Mallorca, SpainNTSB DCA23WA423Incident · No injuriesClass 5 · ForeignDouglas DC9 · Maturin, VenezuelaNTSB GAA23WA243Accident · 2 fatalClass 5 · ForeignGulfstream 690C · Las Velas, VenezuelaNTSB GAA23WA245Accident · 1 fatalClass 5 · ForeignSupermarine Spitfire MK26 · Enstone-, United KingdomNTSB ENG23WA035OccurrenceClass 5 · ForeignAirbus A321 · Jeddah, Saudi ArabiaNTSB DCA23WA438IncidentClass 5 · ForeignEmbraer 190 · Armidale, AustraliaNTSB GAA23WA239AccidentClass 3 · ForeignCessna 402 · BahamasNTSB DCA23WA456IncidentClass 5 · ForeignBoeing 787 · Santiago, ChileNTSB DCA23WA414Incident · No injuriesClass 5 · ForeignBoeing 737 · Barcelona, VenezuelaNTSB GAA23WA231Accident · 2 fatalClass 5 · ForeignHawker Beechcraft G58 · Vilhena, BrazilNTSB ENG23WA043Incident · No injuriesClass 5 · ForeignATR ATR72 · Brazzavillec, Congo - KinshasaNTSB DCA23WA385Incident · Minor injuriesClass 5 · ForeignAirbus A330-941 · Seoul, South KoreaNTSB DCA23WA394Accident · No injuriesClass 5 · ForeignBoeing 767-332 · Fuimicino, ItalyNTSB DCA23WA377OccurrenceClass 5 · ForeignBoeing 737 · Le Mans, FranceNTSB GAA23WA211Accident · 6 fatalClass 5 · ForeignCessna 210 · San Luis Gaceno, ColombiaNTSB GAA23WA213Accident · 1 fatalClass 5 · ForeignCessna FR182 · Ferrara di Monte Baldo, ItalyNTSB GAA23WA218Accident · Minor injuriesClass 4 · ForeignCessna 152 · União da Vitória, BrazilNTSB GAA23WA277Accident · Serious injuriesClass 5 · ForeignCessna 172 · Novosibirsk,, RussiaNTSB DCA23WA386IncidentClass 5 · ForeignBoeing 737 · Antalya, JordanNTSB DCA23WA472Incident · No injuriesClass 5 · ForeignAirbus A330 · overflying English Channel, United KingdomNTSB GAA23WA210Incident · No injuriesClass 5 · ForeignCessna 206 · Esrum Sø, DenmarkNTSB GAA23WA205Accident · 3 fatalClass 5 · ForeignPiper PA28R · GUaratuba, Brazil