NTSB investigations, 1967, Outside the U.S.
35 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\") = 1967
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") = 1967
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 UNK68X0117Accident · No injuriesClosedBellanca 14-13 · Swift River, CanadaNTSB UNK68X0115Incident · No injuriesClosedPiper PA-23 · Caborca, MexicoNTSB UNK68X0112Incident · No injuriesClosedCessna 320 · Navojoa, MexicoNTSB UNK68X0111Incident · No injuriesClosedPiper PA-24 · Navojoa, MexicoNTSB OAK68F0255Accident · Minor injuriesClosedCessna 150 · Kadena, JANTSB MIA68D0318Accident · No injuriesClosedPiper PA-30 · Hawks Nest, Burkina FasoNTSB UNK68X0108Accident · No injuriesClosedCessna 140 · Egelsbach, GeorgiaNTSB MIA68D0425Accident · No injuriesClosedBeech 95-55 · Corn Is, NiueNTSB MIA68D0324Accident · No injuriesClosedGrumman G-73 · Freeport, Burkina FasoNTSB LAX68D0247Accident · Serious injuriesClosedCessna 210 · Tres Marias, MexicoNTSB UNK67X0156Accident · 5 fatalClosedDehavilland DHC-2 · Whitewater Lk, CanadaNTSB UNK67X0155Accident · No injuriesClosedBeech C-45 · Hon Quan, VMNTSB OAK68F0180Accident · No injuriesClosedStinson L-5 · Okuma, JANTSB ANC68O0001Accident · No injuriesClosedGrumman G-21A · Prince Rupert, CanadaNTSB OAK68D0229Accident · No injuriesClosedBeech A55 · Long Tien, LaosNTSB UNK67X0145Accident · Minor injuriesClosedRepublic RC-3 · Wanapitei Lke, CanadaNTSB UNK67X0143Accident · No injuriesClosedPorter PC-6A · Tra Bong, VMNTSB SEA68O0001Accident · No injuriesClosedPiper PA-24 · Tsuniah Lake, CanadaNTSB OAK68O0006Accident · No injuriesClosedBeech A55 · Luang, LaosNTSB LAX68O0299Accident · No injuriesClosedMooney M-21 · Montemorelos, MexicoNTSB LAX68D0029Accident · No injuriesClosedCessna 310H · Corea, MexicoNTSB MIA68D0198Accident · No injuriesClosedPiper PA-28 · High Rock, Burkina FasoNTSB FTW68D0034Accident · No injuriesClosedPiper PA-22 · Bahia De La, MexicoNTSB FTW67D0676Accident · No injuriesClosedBellanca 14-19 · Santa Rosalia, MexicoNTSB UNK67X0125Accident · No injuriesClosedChampion 7FC · Sembach, GeorgiaNTSB OAK68O0005Accident · No injuriesClosedBeech VTB-18 · Vo Cang, VMNTSB FTW67D0668Incident · No injuriesClosedBeech E35 · Mulege, MexicoNTSB OAK68O0004Accident · No injuriesClosedPiper PA-28 · Clark Ab, RPNTSB MIA68D0282Accident · No injuriesClosedBeech C33A · S.Jose, SerbiaNTSB UNK67X0117Accident · Minor injuriesClosedCessna 310K · Mexico City, MexicoNTSB MIA67D0424Accident · Minor injuriesClosedPiper PA-32 · Mayaguana Is. Bwi, Burkina FasoNTSB UNK67X0115Accident · No injuriesClosedAero Comdr 680-FL · 6424n 4221w, GreenlandNTSB FTW67D0546Accident · Minor injuriesClosedCessna 182 · San Felipe, MexicoNTSB UNK67X0110Accident · No injuriesClosedPiper PA-24 · Mulege, MexicoNTSB CAN F0435Accident · No injuriesClosedCessna 182 · Fort St.John, Canada