NTSB investigations, IL
901 cases where the phase of flight was Enroute.
Cases, newest first
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 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 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 CHI91LA185Accident · Serious injuriesLimited investigationFinal reportRyan Navion A · Kankakee, ILThe pilot's poor in flight planning/decision making and misjudged fuel supply. A related factor is the inadequate emergency procedure.NTSB CHI91FA135Accident · Serious injuriesField investigationFinal reportPiper PA-24-250 · Wadsworth, ILThe pilot in command's failure to select the proper fuel tank and not performing emergency procedures when the engine ceased to run. A factor related to this accident was power transmissions wires located on the pilot's approach path to landing.NTSB CHI91DEE04Accident · No injuriesFinal reportBeech 35-A33 · Vernon Hills, ILWater contamination of the fuel, and the pilot's inadequate preflight inspection.NTSB CHI91LA070Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-260 · Marshall, ILFlight into known adverse weather by the pilot(s) and subsequent icing of the Piper PA-32'S air induction system. Factors related to the accident were: the adverse weather conditions and a perceived sense of urgency to make the flight.NTSB CHI91DEE02Accident · Minor injuriesFinal reportMaule M-4-220C · Romeoville, ILThe pilot's inadequate preflight inspection resulting in power loss from fuel contamination. A factor in the accident was the owner's failure to accomplish airworthiness directive 84-9-7 which provided direct, convenient access to sample and purge the main…NTSB CHI91LA043Accident · No injuriesLimited investigationFinal reportCessna 152 · Joliet, ILInadequate visual lookout by the pilots of both aircraft, which resulted in their failure to see-and-avoid each other's aircraft.NTSB CHI90DEV10Accident · 1 fatalFinal reportCarlson Commander Elite · Jerseyville, ILThe pilot's failure to maintain control of the gyroplane.NTSB CHI90LA276Accident · No injuriesLimited investigationFinal reportMooney M20E · Morrison, ILImproper maintenance of the propeller blade by unknown persons and the subsequent failure of the blade in fatigue during cruise flight. A factor was: unsuitable terrain.NTSB CHI90LA256Accident · Serious injuriesLimited investigationFinal reportBoeing B75N1 · Marseilles, ILThe pilot-in-command's failure to maintain adequate visual outlook to avoid collision with a wire while conducting intentional low level flight.NTSB CHI90FA233Accident · No injuriesField investigationFinal reportPiper PA-23-160 · Odell, ILA loss of left engine power due to oil accumulation in the right magneto and a non-usable spark lead from the left magneto. In addition, the right engine was unable to provide adequate power to maintain altitude due to a partial blockage in the carburetor by…NTSB CHI90FA174Accident · 2 fatalField investigationFinal reportPiper PA-32R-301T · Ashton, ILA loss of aircraft control for an unknown reason, while en route in instrument meteorological conditions (IMC) on a dark night, and the pilot exceeding the design stress limits of the aircraft while attempting to recover from uncontrolled flight. Factors…NTSB CHI90LA169Accident · No injuriesLimited investigationFinal reportPiper PA28-151 · Aurora, ILFuel exhaustion. A factor in the accident was inaccurate fuel consumption calculations by the pilot.NTSB CHI90IA166Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-9-32 · Chicago, ILThe pilot-in-command's inadequate weather evaluation. Factors in the incident were the weather and artcc's failure to issue a weather advisory.NTSB CHI90DEE06Accident · No injuriesFinal reportPiper PA 28 140 · Savanna, ILThe pilot's misjudgement of the airplane's fuel supply, resulting in fuel exhaustion.NTSB CHI90DEV06Accident · Minor injuriesFinal reportCessna 210 · Salem, ILImproper positioning of the fuel selector by the pilot, which resulted in fuel starvation, and the pilot's improper emergency procedure.NTSB CHI90LA101Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Monee, ILEngine failure due to oil starvation resulting from improper maintenance and directive compliance associated with the failed part.NTSB CHI90FA096Accident · 2 fatalField investigationFinal reportPiper PA-60-601P · Bartonville, ILThe pilot allowed the aircraft to exceed its design stress limits after encountering adverse weather. Factors related to the accident were: the pilot's improper evaluation of the weather and the adverse weather condtions.NTSB CHI90FA087Accident · 3 fatalField investigationFinal reportPiper PA-32RT-300 · Lostant, ILFlight into known adverse weather conditions by the pilot and structural (wing) icing. Factors related to the accident were: the adverse weather conditions and the pilot's overconfidence in the aircraft's ability.NTSB CHI90LA079Accident · No injuriesLimited investigationFinal reportCessna 177B · Raleigh, ILInadequate preflight by the pilot and fuel exhaustion due to an inadequate supply of fuel. The unreliable fuel quantity gauge was a related factor.NTSB CHI90DEV01Accident · Minor injuriesFinal reportCessna 210D · Jerseyville, ILA total loss of engine power for an undetermined reason. A factor in the accident was the rough uneven terrain in the forced landing area.NTSB CHI90FA029Accident · 3 fatalField investigationFinal reportPiper PA-28-235 · Monroe Center, ILIn-flight fire initiated by an inadequately installed wiring harness and propagated by an existing fuel leak which was not repaired.NTSB CHI90LA039Accident · No injuriesLimited investigationFinal reportBeech V35B · Momence, ILGradual total failure of the powerplant due to oil exhaustion during a night cross country operation, and the subsequent gear-up forced landing on a frozen field.NTSB CHI90LA017Accident · No injuriesLimited investigationFinal reportDe Havilland DH82A · Mascoutah, ILAn undetermined powerplant problem, which resulted in a severe vibration. The soft/uneven terrain was considered to be a contributing factor.NTSB CHI89LA191Accident · No injuriesLimited investigationFinal reportBell 206B-3 · Chicago, ILA hard landing caused by the pilot not being able to judge his altitude above or his closure rate to terrain because of high vegetation in the area available for a forced landing. An engine faulure caused by material failure of the compressor section is a…NTSB CHI89FA183Accident · Minor injuriesField investigationFinal reportMcDonnell Douglas MD-80 · Chicago, ILA loss of hydraulic system pressure due to the operator's failure to replace a system component that had a known history of failures, and the pilot's improper use powerplant controls resulting in a degradation of rudder effectiveness. A contributing factor…NTSB CHI89LA156Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Kankakee, ILFailure of the student pilot to use carburetor heat, which resulted in loss of engine power, due to carburetor ice. A factor related to the accident was: carburetor icing conditions.NTSB CHI89DEE05Accident · No injuriesFinal reportCessna 152 · Romeoville, ILThe pilot's misjudgement of the fuel supply.NTSB CHI89IA144Incident · No injuriesIncident investigationFinal reportDornier DO-228 · Chicago, ILPoor lookout by the crew of the Dornier and the baron.NTSB CHI89IA143Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-9-32 · Chicago, ILPoor lookout by the crew of the DC-9 and the Cessna pilot.NTSB CHI89LA070Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Bunker Hill, ILImproper preflight by the student pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel. A factor related to the accident was: soft terrain.NTSB CHI89LA065Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Monee, ILInadequate maintenance/inspection of the aircraft after metal fragments were found in the oil, and worn cam lobes/followers/piston pin plugs, which resulted in oil contamination, restriction (blockage) in the oil system, oil starvation, and subsequent engine…NTSB CHI89FA062Accident · Serious injuriesField investigationFinal reportHughes 269C · De Kalb, ILFatigue failure of the number four connecting rod which resulted in an engine failure. Factors in the accident were the broken ring in the number one piston and a deteriorated center main bearing.NTSB CHI89FA039Accident · 2 fatalField investigationFinal reportCessna 210D · Alvin, ILContinued flight by the non-instrument rated pilot into instrument meteorological conditions (IMC), and his failure to maintain sufficient altitude. Factors related to the accident were: darkness, adverse weather conditions, the pilot's lack of instrument…NTSB CHI89DEE01Accident · No injuriesFinal reportCessna 210L · Bannock Burn, ILFuel starvation caused by ice blocked fuel lines.NTSB CHI89LA031Accident · No injuriesLimited investigationFinal reportCessna 150 · Varna, ILThe student pilot was cruising at 2000' MSL on a solo flight, when the engine lost power. Emergency procedures were initiated and a forced landing was made in an open field. During the landing roll, the aircraft struck a dirt bank and was damaged. A…NTSB CHI89DEV04Accident · 1 fatalFinal reportTesori Regionne 2002 · Urbana, ILThe plt transmitted on an advisory frequency 'clear the area I have engine trouble'. While turning from downwind to the base leg of his emergency approach to the airport, witnesses observed the airplane in a steep right bank when it suddenly banked left and…NTSB CHI89LA010Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Fairview Hts., ILFuel exhaustion due inaccurate fuel consumption calculations.NTSB CHI89LA012Accident · No injuriesLimited investigationFinal reportCessna 182 · Sparta, ILNTSB CHI89FA005Accident · Minor injuriesField investigationFinal reportPiper PA-28 · Schaumburg, ILEngine failure due to oil starvation and the pilot's misjudged emergency landing, during which the aircraft collided with trees and a swimming pool, before coming to rest on the ground and a chain link fence.NTSB CHI88FA214Accident · 3 fatalField investigationFinal reportHughes 269B · Hampton, ILNTSB CHI88LA199Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Crestwood, ILNTSB CHI88LA170Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Chicago, ILDuring climbout after takeoff, the pilot experienced an engine fire and diverted to Chicago's midway airport for an emergency landing. The pilot executed emergency procedures, shut down the engine, the fuel supply, and all electrical load. When the pilot knew…NTSB CHI88DEE06Accident · No injuriesFinal reportPiper PA-25 · Chebanse, ILThe acft had been refueled with pilot's stated quantity of 20 gals of fuel. After completing his spray operation and returning to base he stated 'ran out of gas'. Acft had been airborne 1 + 15 plus taxi and engine runup.NTSB CHI88LA099Accident · No injuriesLimited investigationFinal reportCessna 150M · Zeigler, ILUpon completion of a practice emergency landing procedure during an instructional flight, the engine started to run rough and then quit. The instructor was able to regain partial power, and made forced landing in freshly plowed field. The aircraft nosed over…NTSB CHI88IA097Incident · Minor injuriesIncident investigationFinal reportFairchild SA-226-TC · Bloomington, ILPhysical incapacitation due to an organic pathogen. Contributing factors are anxiety and self-induced pressure.NTSB CHI88DEE03Accident · No injuriesFinal reportPiper PA-22-150 · West Chicago, ILThe plt rprtd that just after leveling off, the eng started to sputter. He initiated emergency procedures, but was unable to restore power. During an emergency landing at dusk, the acft hit a ditch & nosed over. An investigation revealed the #3 exhaust valve…NTSB CHI88LA053Accident · No injuriesLimited investigationFinal reportCessna T310R · Urbana, ILAfter the aircraft experienced a complete electrical failure the gear was extended manually and a precautionary landing was made. On roll out the landing gear collapsed. Subsequent investigation revealed that 10 turns remained on the manual gear extension…NTSB CHI88FA048Accident · Serious injuriesField investigationFinal reportBoeing 767-200 · Chicago, ILA flight attendant and a passenger received serious and minor injuries respectively during an inflight encounter with severe turbulence during an enroute descent. Greater than moderate turbulence was forecast to be in the area and severe turbulence had been…NTSB CHI88FA035Accident · 1 fatalField investigationFinal reportBeech 58 · Wedron, ILThe airplane struck trees and descended uncontrolled into a river while attempting a night forced landing after running out of fuel during a cargo flight. The airplane was found under water on the fifth day of a search conducted by the cap after two boys…NTSB CHI88DEV01Accident · 1 fatalFinal reportCessna 150L · Marion, ILPilot in command suffered a fatal heart attack. His wife, a private pilot, attempted to land the aircraft, lost control on landing roll and struck a runway light.