NTSB investigations, 2023, Outside the U.S.
49 cases where the phase of flight was Approach.
Cases per year
| 1962 | 3 |
|---|---|
| 1964 | 9 |
| 1965 | 11 |
| 1966 | 13 |
| 1967 | 8 |
| 1968 | 10 |
| 1969 | 8 |
| 1970 | 6 |
| 1971 | 8 |
| 1972 | 13 |
| 1973 | 10 |
| 1974 | 5 |
| 1975 | 2 |
| 1976 | 3 |
| 1977 | 2 |
| 1978 | 4 |
| 1979 | 1 |
| 1980 | 2 |
| 1984 | 1 |
| 1988 | 1 |
| 1993 | 1 |
| 1995 | 1 |
| 1997 | 2 |
| 1999 | 1 |
| 2002 | 1 |
| 2004 | 1 |
| 2008 | 3 |
| 2009 | 15 |
| 2010 | 7 |
| 2011 | 15 |
| 2012 | 11 |
| 2013 | 30 |
| 2014 | 18 |
| 2015 | 16 |
| 2016 | 34 |
| 2017 | 23 |
| 2018 | 32 |
| 2019 | 30 |
| 2020 | 16 |
| 2021 | 35 |
| 2022 | 32 |
| 2023 | 49 |
| 2024 | 39 |
| 2025 | 43 |
| 2026 | 21 |
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 = 500)
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 = 500)
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 GAA24WA063AccidentClass 5 · ForeignCessna 172 · Buenos Aires, ArgentinaNTSB DCA24WA060IncidentClass 5 · ForeignBoeing 737 · Sydney, AustraliaNTSB DCA24WA052IncidentClass 5 · ForeignBoeing 737 · Billund, DenmarkNTSB DCA24WA045IncidentClass 5 · ForeignBoeing 737 · Quito, EcuadorNTSB DCA24WA036OccurrenceClass 5 · ForeignBoeing 737 Max 8-200 · London, United KingdomNTSB GAA24WA046Accident · Serious injuriesClass 5 · ForeignCessna 170 · Quebec, CanadaNTSB DCA24WA029Incident · No injuriesClass 5 · ForeignBoeing 787 · Bogotá, ColombiaNTSB DCA24WA066IncidentClass 5 · ForeignAirbus A320 · Geneva, SwitzerlandNTSB DCA24WA044OccurrenceClass 5 · ForeignDe Havilland Dash 8 · Val-d'Or, CanadaNTSB DCA23WA480IncidentClass 5 · ForeignBoeing 737 · Stuttgart, GermanyNTSB ENG24WA006Incident · No injuriesClass 5 · ForeignViking DHC-6-200 · Hulhulé Island, MaldivesNTSB GAA24WA001Accident · No injuriesClass 3 · ForeignRobinson R44 · Vamdrup, DenmarkNTSB GAA24WA007Accident · No injuriesClass 5 · ForeignCessna 210 · Campo Grande, BrazilNTSB GAA23WA258Accident · No injuriesClass 5 · ForeignCessna 205 · La Paragua, VenezuelaNTSB ENG23WA036Incident · No injuriesClass 5 · ForeignAirbus A320 · Chihuahua, MX, MexicoNTSB GAA24WA027Incident · No injuriesClass 5 · ForeignFokker F28 · Adelaide Aerodrome, AustraliaNTSB GAA23WA246Accident · Minor injuriesClass 5 · ForeignCessna 150 · Ad. Alto Paraná, El Dorado, ArgentinaNTSB DCA23WA437IncidentClass 5 · ForeignEmbraer 190 · Alice Springs, AustraliaNTSB DCA23WA416Accident · 10 fatalClass 5 · ForeignRaytheon 390 · Elmina, MalaysiaNTSB DCA23WA413Incident · No injuriesClass 5 · ForeignBoeing 737 · Belfast, United KingdomNTSB GAA23WA230Accident · 2 fatalClass 5 · ForeignCessna 172 · Trujillo, PeruNTSB DCA23WA410IncidentClass 5 · ForeignBoeing 737 · Rio De Janeiro, BrazilNTSB GAA23WA234Accident · No injuriesClass 5 · ForeignCessna 172 · Kohnan, JapanNTSB GAA23WA198Accident · 1 fatalClass 4 · ForeignPiper 23 · Thirsk, United KingdomNTSB GAA23WA175AccidentForeign investigationPiper PA28 · Bournemouth, United KingdomNTSB GAA23WA214Accident · No injuriesClass 5 · ForeignBell 206B · Thetford Mines, CanadaNTSB GAA23WA181Accident · No injuriesClass 5 · ForeignCessna 310 · Derby, AustraliaNTSB ENG24WA001IncidentClass 5 · ForeignDe Havilland DHC8 · Timaru, New ZealandNTSB DCA23WA318IncidentClass 5 · ForeignBoeing 737 · Manchester, United KingdomNTSB GAA23WA166Accident · No injuriesClass 5 · ForeignBeech A36 · Teresina, Pi, BrazilNTSB DCA23WA314Incident · No injuriesClass 5 · ForeignBoeing 717 · Cambridge, AustraliaNTSB DCA23WA419Incident · No injuriesClass 5 · ForeignEmbraer 190 · Napier, New ZealandNTSB GAA23WA162AccidentClass 5 · ForeignPiper PA18 · Oldenburg, GermanyNTSB DCA23WA291Incident · No injuriesClass 5 · ForeignAirbus A320-233 · Monterrey, MexicoNTSB GAA23WA147Accident · 2 fatalClass 5 · ForeignCessna 182 · Shell, EcuadorNTSB GAA23WA129Accident · 1 fatalClass 5 · ForeignLancair 360 · Taurages, LithuaniaNTSB GAA23WA197AccidentClass 5 · ForeignPiper PA-31-350 · Archerfield, AustraliaNTSB DCA23WA229Occurrence · No injuriesClass 5 · ForeignAirbus A320 · Sao Paulo, BrazilNTSB GAA23WA114Accident · Serious injuriesClass 5 · ForeignPiper PA-28-140 · Scottsdene, South AfricaNTSB GAA23WA105Accident · No injuriesClass 4 · ForeignPiper PA25 · Corupa, BrazilNTSB GAA23WA104Accident · 4 fatalClass 4 · ForeignRobinson R44 · Sao Paulo, BrazilNTSB DCA23WA476Incident · No injuriesClass 4 · ForeignBoeing 787 · Dubai, United Arab EmiratesNTSB DCA23WA475IncidentClass 4 · ForeignBoeing 737 · Dubai, QatarNTSB GAA23WA081AccidentClass 5 · ForeignBeech 1900 · Winnipeg, CanadaNTSB DCA23WA206IncidentClass 5 · ForeignBoeing 787 · Sydney, AustraliaNTSB GAA23WA072Accident · 2 fatalClass 4 · ForeignRobinson R44 · Vargem Alta, BrazilNTSB DCA23WA174AccidentClass 5 · ForeignATR ATR72 · Pokhara, NepalNTSB GAA23WA057Incident · No injuriesClass 5 · ForeignRobinson R44 · Hamilton Island, AustraliaNTSB DCA23WA135Accident · Serious injuriesClass 5 · ForeignBoeing 737 · Miyazaki, Japan