NTSB investigations, 2022, Outside the U.S.
41 cases where the phase of flight was Takeoff.
Cases per year
| 1962 | 1 |
|---|---|
| 1964 | 9 |
| 1965 | 8 |
| 1966 | 6 |
| 1967 | 5 |
| 1968 | 9 |
| 1969 | 6 |
| 1970 | 5 |
| 1971 | 4 |
| 1972 | 5 |
| 1973 | 4 |
| 1974 | 7 |
| 1975 | 5 |
| 1976 | 2 |
| 1977 | 2 |
| 1978 | 1 |
| 1979 | 2 |
| 1980 | 1 |
| 1995 | 1 |
| 1996 | 1 |
| 2007 | 1 |
| 2008 | 9 |
| 2009 | 7 |
| 2010 | 8 |
| 2011 | 15 |
| 2012 | 11 |
| 2013 | 9 |
| 2014 | 18 |
| 2015 | 29 |
| 2016 | 29 |
| 2017 | 42 |
| 2018 | 29 |
| 2019 | 32 |
| 2020 | 30 |
| 2021 | 39 |
| 2022 | 41 |
| 2023 | 61 |
| 2024 | 71 |
| 2025 | 55 |
| 2026 | 26 |
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 = 300)
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") = 2022
AND c."eventCountry" <> 'USA'
AND c."mKey" IN (SELECT case_mkey FROM case_phases WHERE main = 300)
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 ENG23WA007Incident · No injuriesClass 4 · ForeignBoeing 737 · Mogadishu, SomaliaNTSB ENG23WA006Incident · No injuriesClass 4 · ForeignBoeing 737 · Mogadishu, SomaliaNTSB ENG23WA008IncidentClass 3 · ForeignAirbus A320 · Guadalajara, MexicoNTSB GAA23WA074Accident · No injuriesClass 5 · ForeignThrush S2R · Gunung Mas Regency, IndonesiaNTSB GAA23WA044AccidentClass 4 · ForeignCessna 188 · InaciolâNdia, BrazilNTSB DCA23WA088IncidentClass 5 · ForeignBoeing 737 · Brisbane, AustraliaNTSB GAA23WA031Accident · 2 fatalClass 5 · ForeignRobinson R66 · Kesova Gora, RussiaNTSB DCA23WA076Incident · No injuriesClass 5 · ForeignBoeing 737 · Maiquetía, VenezuelaNTSB DCA23WA066Accident · 2 fatalClass 5 · ForeignAirbus A320 · Lima, PeruNTSB DCA23WA049Incident · Minor injuriesClass 5 · ForeignSaab 340 · Canberra, AustraliaNTSB DCA23WA054IncidentClass 5 · ForeignSaab 340 · Whitemark, AustraliaNTSB ENG23WA002IncidentClass 5 · ForeignAirbus A320 · Delhi, IndiaNTSB DCA23WA037Incident · No injuriesClass 5 · ForeignBoeing 777-223 · Buenos Aires, ArgentinaNTSB GAA23WA007Accident · 1 fatalClass 3 · ForeignCirrus SF50 · Santa Marta, ColombiaNTSB GAA23WA002Accident · 1 fatalClass 5 · ForeignCessna 172 · Curatone, ItalyNTSB DCA23WA002Incident · No injuriesClass 5 · ForeignBoeing 777 · Manila, PhilippinesNTSB DCA22WA208Accident · 1 fatalClass 5 · ForeignBAE 3201EP · San Antonio del Estrecho, PeruNTSB DCA23WA014IncidentClass 5 · ForeignBoeing 777-222 · Schiphol, NetherlandsNTSB GAA22WA271Accident · No injuriesClass 5 · ForeignAyres S2R · Trangie, AustraliaNTSB GAA22WA283Accident · 5 fatalClass 5 · ForeignCessna 210 · Impalia, NamibiaNTSB DCA22WA187IncidentClass 5 · ForeignMcdonnell Douglas DC-9-83 · Maiquetia, VenezuelaNTSB GAA22WA255Accident · 2 fatalClass 5 · ForeignPiper PA28 · Nipigon, CanadaNTSB GAA22WA256Accident · No injuriesClass 5 · ForeignPiper PA46 · High Wycombe, United KingdomNTSB GAA22WA218Accident · 4 fatalClass 3 · ForeignLearjet 35 · Tierra del Fuego, ArgentinaNTSB GAA22WA210Accident · No injuriesClass 5 · ForeignRobinson R44 · East Sussex, United KingdomNTSB GAA22WA208Accident · 1 fatalClass 5 · ForeignCessna 182 · Itaituba, BrazilNTSB GAA22WA197Accident · 1 fatalClass 3 · ForeignPiper PA31 · Deadman's Cay, BahamasNTSB GAA22WA202Accident · Serious injuriesClass 5 · ForeignSorrel SNS8 · Madrid, SpainNTSB GAA22WA189Incident · No injuriesClass 5 · ForeignCessna 560 · Schwäbisch Hall, GermanyNTSB DCA22WA123Incident · No injuriesClass 5 · ForeignBoeing 737 · Kathmandu, NepalNTSB GAA22WA120Accident · 2 fatalClass 5 · ForeignBeech A36 · Ie, JapanNTSB DCA22WA095Incident · No injuriesClass 5 · ForeignBoeing 737 · Manchester, United KingdomNTSB DCA22WA093IncidentClass 5 · ForeignMcdonnell Douglas MD82 · Maiquetia, VenezuelaNTSB DCA22WA090Incident · No injuriesClass 5 · ForeignBoeing 737 · Karachi, PakistanNTSB ENG22WA011IncidentClass 5 · ForeignAirbus A319 · Mexico City, MexicoNTSB GAA22WA091Accident · 7 fatalClass 5 · ForeignCessna 207 · Ica, PeruNTSB ENG22WA008IncidentClass 5 · ForeignBoeing 737 · Brazzaville, Congo - KinshasaNTSB GAA22WA086AccidentClass 5 · ForeignAir Tractor AT602 · Luís Eduardo Magalhães,, BrazilNTSB DCA22WA071Incident · No injuriesClass 5 · ForeignBoeing 737 · Barcelona, VenezuelaNTSB GAA22WA314Accident · No injuriesClass 4 · ForeignAir Tractor AT602 · Santo Tome, Corrientes, ArgentinaNTSB GAA22WA116Accident · No injuriesClass 5 · ForeignCruiser PS-28 · Casarrubios, Spain