NTSB investigations, 1965, Outside the U.S.
37 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\") = 1965
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") = 1965
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 UNK66X0114Accident · No injuriesClosedCessna 210 · Ft Williams, CanadaNTSB FTW66S0002Accident · 2 fatalClosedErco 415-C · Saltillo, MexicoNTSB MIA66D0356Accident · No injuriesClosedCessna 150 · West End, Burkina FasoNTSB UNK66X0108Accident · No injuriesClosedBeech 65 · Franfurt, GeorgiaNTSB UNK66X0107Accident · No injuriesClosedDehaviland DHC-2 · El Adem, LibyaNTSB CAN65C0038Accident · No injuriesClosedBeech 35 · Dryden Ont., CanadaNTSB UNK66X0104Accident · No injuriesClosedGrumman G-164 · Wad Ek Mansi, RussiaNTSB FTW66D0401Accident · No injuriesClosedBeechcraft 35 · Mazatlan, MexicoNTSB UNK66X0100Accident · No injuriesClosedCessna 210 · Sinaloa, MexicoNTSB UNK65X1538Accident · No injuriesClosedBeech A23 · Wallacebrg, CanadaNTSB OAK66D0112Accident · No injuriesClosedTaylorcraft BC-12D · Yomitan Okinawa, JANTSB FTW66A0028Accident · No injuriesClosedBoeing B-720 · Mexico City, MexicoNTSB UNK65X1524Accident · No injuriesClosedGrumman JRF-5 · Hay River, CanadaNTSB UNK65X1521Accident · No injuriesClosedBeechcraft P-35 · Chihuahua, MexicoNTSB UNK65X1520Accident · No injuriesClosedBeechcraft F-35 · Walkers Cay, Burkina FasoNTSB UNK65X1515Accident · No injuriesClosedPiper PA-28 · Tascha Lake, CanadaNTSB UNK65X1513Accident · No injuriesClosedMooney M20A · Scum Lake Bc, CanadaNTSB DEN66D0047Accident · No injuriesClosedPiper PA-28 · Bahia Kino, MexicoNTSB UNK65X1511Accident · No injuriesClosedPiper PA-28 · Coyame Chuaha, MexicoNTSB UNK65X1506Accident · No injuriesClosedCessna 182 · Ensenada, MexicoNTSB UNK65X1501Accident · No injuriesClosedCessna 337 · Nuevo Laredo, MexicoNTSB UNK65X1500Incident · No injuriesClosedDouglas DC-8 · Santiago Chile Sa, Côte d’IvoireNTSB UNK65X1499Accident · No injuriesClosedCessna 180 · Mexicali, MexicoNTSB MKC66D0122Accident · Minor injuriesClosedLake LA-4 · Lac La Croix, CanadaNTSB UNK65X1491Accident · No injuriesClosedPiper PA-28 · Mulege, MexicoNTSB UNK65X1490Accident · No injuriesClosedMooney M21 · Freeport, Burkina FasoNTSB UNK65X1489Accident · Minor injuriesClosedCessna 182 · De Los Angels, MexicoNTSB MIA66S0007Accident · No injuriesClosedBoeing 707 · Merida, MexicoNTSB LAX66D0084Accident · No injuriesClosedCessna 182 · Mulege, MexicoNTSB OAK65A0061Accident · No injuriesClosedBoeing 707 321 · Saigon, VMNTSB UNK65X1476Accident · No injuriesClosedMooney M20 · Mulege, MexicoNTSB UNK65X1475Accident · No injuriesClosedCessna 210 · Kitchener, CanadaNTSB UNK65X1466Accident · No injuriesClosedMooney M21 · Tesapoco, MexicoNTSB UNK65X1452Accident · No injuriesClosedBeechcraft E18S · San Lucas, MexicoNTSB UNK65X1451Accident · No injuriesClosedPiper PA-18 · Kitaka Afri, KenyaNTSB UNK65X1443Accident · Minor injuriesClosedCessna 120 · Kalarskona Lk, CanadaNTSB UNK65X1409Accident · No injuriesClosedBeechcraft A-35 · Caicos Is, Burkina Faso