NTSB investigations, 1985, IL
14 cases where the phase of flight was Enroute.
Cases per year
| 1963 | 2 |
|---|---|
| 1964 | 20 |
| 1965 | 21 |
| 1966 | 26 |
| 1967 | 31 |
| 1968 | 20 |
| 1969 | 24 |
| 1970 | 38 |
| 1971 | 28 |
| 1972 | 21 |
| 1973 | 26 |
| 1974 | 27 |
| 1975 | 34 |
| 1976 | 29 |
| 1977 | 23 |
| 1978 | 24 |
| 1979 | 22 |
| 1980 | 17 |
| 1981 | 24 |
| 1982 | 19 |
| 1983 | 22 |
| 1984 | 16 |
| 1985 | 14 |
| 1986 | 11 |
| 1987 | 14 |
| 1988 | 15 |
| 1989 | 14 |
| 1990 | 15 |
| 1991 | 11 |
| 1992 | 17 |
| 1993 | 22 |
| 1994 | 19 |
| 1995 | 13 |
| 1996 | 12 |
| 1997 | 10 |
| 1998 | 10 |
| 1999 | 12 |
| 2000 | 11 |
| 2001 | 11 |
| 2002 | 12 |
| 2003 | 9 |
| 2004 | 8 |
| 2005 | 10 |
| 2006 | 9 |
| 2007 | 12 |
| 2008 | 9 |
| 2009 | 5 |
| 2010 | 6 |
| 2011 | 9 |
| 2012 | 7 |
| 2013 | 2 |
| 2014 | 8 |
| 2015 | 5 |
| 2016 | 10 |
| 2017 | 2 |
| 2018 | 3 |
| 2019 | 5 |
| 2020 | 5 |
| 2021 | 2 |
| 2022 | 5 |
| 2023 | 5 |
| 2025 | 3 |
| 2026 | 5 |
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\") = 1985
AND c.\"eventStateOrRegion\" = 'IL' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT case_mkey FROM case_phases WHERE main = 400)
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") = 1985
AND c."eventStateOrRegion" = 'IL' AND c."eventCountry" = 'USA'
AND c."mKey" IN (SELECT case_mkey FROM case_phases WHERE main = 400)
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 CHI86FA111Accident · No injuriesField investigationFinal reportPiper PA-46-310P · Evanston, ILThe aircraft was on climbout on an IFR flight plan in VMC conditions when the engine failed. A restart was attempted and the engine ran for a minute or less. Subsequent attempts were unsuccessful. The aircraft was over lake Michigan and had insufficient…NTSB CHI86FA035Accident · 2 fatalField investigationFinal reportBeech BE 36 · Odell, ILThe plt departed on an IFR flight into known icing conditions after receiving three complete weather briefings clearly indicating the icing conditions with numerous plt reports of icing. Aprx 40 minutes after departure the plt reported he had about an inch of…NTSB CHI86IA034Incident · No injuriesIncident investigationFinal reportBoeing 747-251F · Glen Ellyn, ILDuring climb a bang was heard and the aircraft shuddered. The crew stated that the number three engine oil pressure and oil quantity indicated low. The fire warning light and bell activvated. The engine was shut down and the aircraft landed without further…NTSB CHI86LA032Accident · Minor injuriesLimited investigationFinal reportRockwell 112 · Pekin, ILFollowing a top overhaul of the engine a test flight was planned to break in the cylinders and rings. Prior to this flight the engine was operated for a short period on the ground then shut down and checked for oil leaks with negative results. The takeoff and…NTSB CHI86FA006Accident · No injuriesField investigationFinal reportCessna P210N · Grayslake, ILDuring descent the engine stopped running. The aircraft was landed in a soft field & nosed over. Only 4 gallons of fuel was found in the left fuel system with no evidence of leakage. The pilot only used the left system during the 2 hour flight. Fuel tanks…NTSB CHI85FEV04Accident · No injuriesFinal reportHiller UH-12D · Breese, ILThe plt reported that the eng began losing power while he was en route at an alt of aprx 200 ft AGL. He turned & initiated an autorotation to a road construction site. The helicopter landed tail low. Subsequently, the tail boom was chopped off & the…NTSB CHI85FA370Accident · 1 fatalField investigationFinal reportGlobe GC-1B · Romeoville, ILThe pilot was reportly departing on a xcountry flt. During climbout, in the traffic pattern, upon reaching base leg area the acft was observed to turn back towards the arpt descend and strike the ground. Witnesses reported no sound of engine was heard. The…NTSB CHI85LA364Accident · No injuriesLimited investigationFinal reportThornhill Replica TS-1 · Marengo, ILThis aircraft is powered by a rotary engine. Thrust is varied by shorting out one magneto and varying the firing order of the cylinders via an electrical cam arrangement. The mixture control is limited to only a few settings. One of which is level flight.…NTSB CHI85FEV02Accident · Serious injuriesFinal reportde Havilland DH-82A · Elmore, ILWhile on a x-country flt, the eng lost power & the prop continued to windmill. Subsequently, the acft crashed during an emerg landing. During the crash landing, the plt's shoulder harness failed at the upper attachment point & he received head & back…NTSB CHI85LA329Accident · No injuriesLimited investigationFinal reportCessna 152 · Rockford, ILThe student plt originally planned a x-country flt from janesville, WI, to champaign, IL, to galesburg, IL & back to janesville. The total route of flt was aprx 390 mi. The plt had calculated that he needed 3-3/4 hrs of fuel. At champaign, he purchased an…NTSB CHI85LA201Accident · No injuriesLimited investigationFinal reportCessna 150 · Durand, ILWhile on a night flight the acft experienced a complete loss of engine power. An emergency landing was made to a road. During the landing the right wing of the acft strucka street sign & power pole. The plt stated to the authorities that the acft had…NTSB CHI85IA145Incident · 1 fatalIncident investigationFinal reportCessna T210L · Peoria, ILWhile in cruise flight the commercial rated pilot suffered a fatal heart attack. The non-rated passenger landed the aircraft safely.NTSB CHI85LA141Accident · No injuriesLimited investigationFinal reportCessna T210L · Sauk Village, ILDuring a night preflight the fuel quantity was visually checked and the plt estimated each tank contained 35 gals. The left fuel guage indicated 220 pounds and the right guage was inop. After aprx 1 hour 50 minutes of flt time a total loss of power occurred.…NTSB CHI85LA127Accident · No injuriesLimited investigationFinal reportCessna 152 II · Wayne City, ILWhile en route on a night x-country flt the acft experienced fuel exhaustion. An emergency lndg was attempted to a road. The acft struck a power pole that was not visible in the darkness and then hung up in the wires. The acft was destroyed when it was…