NTSB investigations, 1968, IL
89 cases where the phase of flight was Landing.
Cases per year
| 1964 | 91 |
|---|---|
| 1965 | 78 |
| 1966 | 103 |
| 1967 | 120 |
| 1968 | 89 |
| 1969 | 71 |
| 1970 | 73 |
| 1971 | 63 |
| 1972 | 52 |
| 1973 | 59 |
| 1974 | 53 |
| 1975 | 47 |
| 1976 | 53 |
| 1977 | 42 |
| 1978 | 60 |
| 1979 | 44 |
| 1980 | 38 |
| 1981 | 40 |
| 1982 | 38 |
| 1983 | 40 |
| 1984 | 34 |
| 1985 | 16 |
| 1986 | 22 |
| 1987 | 22 |
| 1988 | 22 |
| 1989 | 22 |
| 1990 | 21 |
| 1991 | 13 |
| 1992 | 19 |
| 1993 | 12 |
| 1994 | 13 |
| 1995 | 8 |
| 1996 | 16 |
| 1997 | 11 |
| 1998 | 12 |
| 1999 | 15 |
| 2000 | 12 |
| 2001 | 15 |
| 2002 | 10 |
| 2003 | 22 |
| 2004 | 10 |
| 2005 | 9 |
| 2006 | 8 |
| 2007 | 9 |
| 2008 | 15 |
| 2009 | 9 |
| 2010 | 14 |
| 2011 | 18 |
| 2012 | 8 |
| 2013 | 2 |
| 2014 | 6 |
| 2015 | 10 |
| 2016 | 9 |
| 2017 | 8 |
| 2018 | 8 |
| 2019 | 8 |
| 2020 | 9 |
| 2021 | 4 |
| 2022 | 10 |
| 2023 | 8 |
| 2024 | 6 |
| 2025 | 7 |
| 2026 | 2 |
Where
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\") = 1968
AND c.\"eventStateOrRegion\" = 'IL' 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") = 1968
AND c."eventStateOrRegion" = 'IL' 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 CHI69D0456Accident · No injuriesClosedPiper PA-24 · Wheeling, ILNTSB CHI69D0437Accident · No injuriesClosedCessna 150G · Streator, ILNTSB CHI69D0458Accident · No injuriesClosedBeech B-35 · Granite City, ILNTSB CHI69D0436Accident · No injuriesClosedLuscombe 8A · Waukegan, ILNTSB CHI69F0420Accident · No injuriesClosedBeech E35 · Roselle, ILNTSB CHI69I0062Incident · No injuriesClosedBoeing 720 · Chicago, ILNTSB CHI69D0505Accident · No injuriesClosedPiper PA-28 · Sheldon, ILNTSB CHI69A0060Accident · No injuriesClosedBeech C-45G · Chicago, ILNTSB CHI69A0058Accident · No injuriesClosedCessna 150E · Sandwich, ILNTSB CHI69D0388Accident · No injuriesClosedCessna P206 · Ottawa, ILNTSB CHI69D0407Accident · No injuriesClosedBeech C35 · Chicago, ILNTSB CHI69D0383Accident · No injuriesClosedBeech A23-19 · Oswego, ILNTSB CHI69D0646Accident · No injuriesClosedMooney M-20 · Carthage, ILNTSB CHI69A0057Accident · Minor injuriesClosedDouglas A-26B · Chicago, ILNTSB CHI69F0390Accident · No injuriesClosedCessna 140A · Lincoln, ILNTSB CHI69D0372Accident · No injuriesClosedPiper PA-24 · Roselle, ILNTSB CHI69D0374Accident · No injuriesClosedCessna 310C · Wheeling, ILNTSB CHI69D0394Accident · No injuriesClosedPiper PA-28 · Wheeling, ILNTSB CHI69D0366Accident · No injuriesClosedPiper PA-24 · Midlothian, ILNTSB CHI69D0325Accident · No injuriesClosedCessna 320 · Rockford, ILNTSB CHI69D0320Accident · No injuriesClosedBeech 35 · Huntley, ILNTSB CHI69D0324Accident · No injuriesClosedCessna 182 · Morris, ILNTSB CHI69D0265Accident · No injuriesClosedCessna 210D · Northbrook, ILNTSB CHI69D0312Accident · No injuriesClosedStinson 108-1 · Northbrook, ILNTSB CHI69F0246Accident · Minor injuriesClosedCessna 150 · Wheeling, ILNTSB CHI69D0305Accident · No injuriesClosedPiper PA-18 · Lansing, ILNTSB CHI69D0330Accident · No injuriesClosedPiper PA-23 · Northbrook, ILNTSB CHI69F0261Accident · No injuriesClosedCessna 320D · Rockford, ILNTSB CHI69F0288Accident · No injuriesClosedBeech J50 · Springfield, ILNTSB CHI69F0511Accident · Serious injuriesClosedPiper PA-28 · Monticello, ILNTSB CHI69F0203Accident · Minor injuriesClosedCessna 150 · Alton, ILNTSB CHI69F0315Accident · No injuriesClosedPiper PA-23 · Danville, ILNTSB CHI69F0342Accident · No injuriesClosedPiper PA-31 · Paris, ILNTSB CHI69F0194Accident · No injuriesClosedCessna 337B · Chicago, ILNTSB CHI69F0234Accident · No injuriesClosedBeech D35 · Bloomington, ILNTSB CHI69D0309Accident · No injuriesClosedLuscombe 8A · Lombard, ILNTSB CHI69D0353Accident · No injuriesClosedPiper PA-16 · Crescent City, ILNTSB CHI69F0224Accident · No injuriesClosedPiper PA-28 · Kilbourne, ILNTSB CHI69D0260Accident · No injuriesClosedNavion A · Park Forest, ILNTSB CHI69D0198Accident · No injuriesClosedBeech E33 · Kankakee, ILNTSB CHI69F0196Accident · No injuriesClosedSmith Mini · Hillsboro, ILNTSB CHI69D0187Accident · No injuriesClosedCessna 150 · Streator, ILNTSB CHI69D0173Accident · No injuriesClosedPiper PA-28 · Northbrook, ILNTSB CHI69D0145Accident · No injuriesClosedBeech A23 · Chenoa, ILNTSB CHI69F0146Accident · No injuriesClosedCessna 182D · Macomb, ILNTSB CHI69D0184Accident · No injuriesClosedCessna 150 · Wheeling, ILNTSB CHI69D0161Accident · No injuriesClosedCessna 210E · Northbrook, ILNTSB CHI69F0115Accident · No injuriesClosedBeech 95-A55 · Springfield, ILNTSB CHI69F0183Accident · No injuriesClosedCessna 150 · Rockford, ILNTSB CHI69D0137Accident · No injuriesClosedCessna 170B · Rochelle, IL