NTSB investigations, 1966, Outside the U.S.
40 cases where the phase of flight was Landing.
Cases per year
| 1962 | 1 |
|---|---|
| 1963 | 1 |
| 1964 | 38 |
| 1965 | 37 |
| 1966 | 40 |
| 1967 | 35 |
| 1968 | 24 |
| 1969 | 20 |
| 1970 | 21 |
| 1971 | 18 |
| 1972 | 26 |
| 1973 | 18 |
| 1974 | 22 |
| 1975 | 18 |
| 1976 | 4 |
| 1977 | 6 |
| 1978 | 12 |
| 1979 | 4 |
| 1980 | 2 |
| 1982 | 1 |
| 1991 | 1 |
| 1993 | 1 |
| 1994 | 1 |
| 1996 | 1 |
| 1997 | 4 |
| 1999 | 1 |
| 2000 | 1 |
| 2008 | 1 |
| 2009 | 10 |
| 2010 | 21 |
| 2011 | 23 |
| 2012 | 27 |
| 2013 | 22 |
| 2014 | 21 |
| 2015 | 34 |
| 2016 | 55 |
| 2017 | 51 |
| 2018 | 60 |
| 2019 | 39 |
| 2020 | 48 |
| 2021 | 72 |
| 2022 | 75 |
| 2023 | 83 |
| 2024 | 83 |
| 2025 | 63 |
| 2026 | 24 |
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\") = 1966
AND c.\"eventCountry\" <> 'USA'
AND c.\"mKey\" IN (SELECT case_mkey FROM case_phases WHERE main = 550)
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") = 1966
AND c."eventCountry" <> 'USA'
AND c."mKey" IN (SELECT case_mkey FROM case_phases WHERE main = 550)
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 MIA67D0367Accident · No injuriesClosedCessna 172 · Duncan Town, Burkina FasoNTSB MIA67D0371Accident · No injuriesClosedBeech C-18S · Tortola Br., U.S. Virgin IslandsNTSB FTW67D0350Accident · Minor injuriesClosedMooney M20E · Chihuahua, MexicoNTSB FTW67D0283Accident · No injuriesClosedCessna 310 · San Pedro, MexicoNTSB UNK67X0103Accident · No injuriesClosedCessna 185 · Spout Lake, CanadaNTSB OAK67D0097Accident · No injuriesClosedPiper PA-28 · Mulege, MexicoNTSB MIA67D0234Accident · No injuriesClosedPiper PA-24 · Bimini, Burkina FasoNTSB UNK66X0174Accident · No injuriesClosedBeech S35 · Cananea, MexicoNTSB UNK66X0167Accident · No injuriesClosedCessna 182 · Williams Lak, CanadaNTSB FTW67D0206Accident · No injuriesClosedCessna 210B · Tamaulipas, MexicoNTSB DCA67S0001Accident · No injuriesClosedLockheed 749A · Tachikawa, JANTSB LAX67D0131Accident · No injuriesClosedCessna 120 · Guaymas, MexicoNTSB UNK66X0162Accident · No injuriesClosedCessna 172 · Suffolk, United KingdomNTSB UNK66X0160Accident · No injuriesClosedCessna 180 · Simunjan Sarawak, MalaysiaNTSB FTW67D0165Accident · No injuriesClosedCessna 210 · Zacatecas, MexicoNTSB CAN F0406Accident · No injuriesClosedEssna 182 · Tsuniah Lake, CanadaNTSB UNK66X0155Accident · No injuriesClosedCessna 310 · Eagle River, CanadaNTSB UNK66X0154Accident · No injuriesClosedCessna 185A · Benghazi, LibyaNTSB FTW67D0102Accident · No injuriesClosedBeech D35 · Muleje, MexicoNTSB FTW67D0082Accident · No injuriesClosedPiper PA-23 · Baboragama, MexicoNTSB UNK66X0152Accident · No injuriesClosedBellanca 14-132 · Scum Lake, CanadaNTSB UNK66X0151Accident · No injuriesClosedCessna 172 · Parrsboro, CanadaNTSB UNK66X0144Accident · No injuriesClosedBeech V35 · Tsuniah Lodge, CanadaNTSB UNK66X0143Accident · No injuriesClosedPiper PA-28 · Clark Air Base, RPNTSB CAN F0393Accident · No injuriesClosedCessna 120 · Yukon Territy, CanadaNTSB FTW67D0003Accident · No injuriesClosedCessna 182 · El Pilar, MexicoNTSB UNK66X0140Accident · Minor injuriesClosedBeech M35 · Chlkoot Ps, CanadaNTSB UNK66X0138Accident · No injuriesClosedCessna 182 · Mulege Baja Calif, MexicoNTSB FTW67D0420Accident · Minor injuriesClosedCessna 206 · Merida, MexicoNTSB MIA67D0360Accident · No injuriesClosedCessna 310C · Nassau, Burkina FasoNTSB FTW66D0689Accident · No injuriesClosedCessna 172 · Prto Lobos, MexicoNTSB UNK66X0135Accident · No injuriesClosedBeech 35 · Baja Calif, MexicoNTSB UNK66X0134Accident · No injuriesClosedCessna 182 · Tiburon Is., MexicoNTSB UNK66X0127Accident · No injuriesClosedCessna 180 · El Socorro, MexicoNTSB MIA66D0497Accident · No injuriesClosedBeech D-18S · St Maarten Na, NTNTSB UNK66X0123Accident · No injuriesClosedCessna 337 · Monterrey, MexicoNTSB DEN66D0262Accident · No injuriesClosedCessna 180 · Llano, MexicoNTSB NYC66I0090Incident · No injuriesClosedBoeing B-720B · Merida, MexicoNTSB UNK66X0121Accident · No injuriesClosedPiper PA-28 · San Felipe, MexicoNTSB UNK66X0120Accident · No injuriesClosedCessna 182 · Mulege, Mexico