NTSB investigations, IL
180,611 investigations by the National Transportation Safety Board since 1962: 174,590 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
Cases, newest first
Query with SQL
duckdb -csv -c "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' 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.
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' ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run 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 CHI93LA187Accident · Serious injuriesLimited investigationFinal reportRobinson R22 · Sandwich, ILThe fixed-wing student pilot's poor judgement in attempting to fly a rotary wing aircraft, and the subsequent loss of control in-flight. The pilot's inadequate training in rotary wing aircraft was a factor.NTSB CHI93LA183Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Flora, ILthe delayed remedial action by the flight instructor. A factor related to the accident was the lack of total experience in this type operation by the flight instructor.NTSB CHI93LA172Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · West Chicago, ILThe pilot-in-command's inadequate compensation for the wind conditions he encountered during the landing approach and touchdown and not maintaining a proper descent rateNTSB CHI93IA167Incident · No injuriesIncident investigationFinal reportCessna 550 · West Chicago, ILInadequate control tower service by the local air traffic controller by providing conflicting clearances to the pilots of two aircraft.NTSB CHI93FA153Accident · 2 fatalField investigationFinal reportCessna 150L · De Kalb, ILThe failure of the pilot flying the airplane to maintain an airspeed above stall speed.NTSB CHI93LA136Accident · No injuriesLimited investigationFinal reportCessna T210 · Philadelphia, ILThe pilot's failure to ensure an adequate fuel supply to complete the flight.NTSB CHI93FA129Accident · 1 fatalField investigationFinal reportAerospatiale ATR-42-300 · Chicago, ILthe unqualified baggage handler's attempting to load an unfamiliar airplane and inadequate training by the airline which employed the baggage handler.NTSB CHI93IA124Incident · No injuriesIncident investigationFinal reportAerospatiale ATR-42-300 · Moline, ILThe passenger's failure to extinguish a cigarette before placing it into the lavatory waste bin. Factors related to the incident were: an inoperative smoke detector in the lavatory, the manufacturer's inadequate maintenance program, and inadequate review of…NTSB CHI93IA127Incident · No injuriesIncident investigationFinal reportde Havilland SHD-6 · Chicago, ILThe local controller's failure to maintain 3 miles radar separation between two airplanes. A factor related to the incident was the local controller's delay in remedial action.NTSB CHI93IA126Incident · No injuriesIncident investigationFinal reportATR ATR 42 · Chicago, ILAn improper clearance by the north local controller, which resulted in a failure to maintain proper IFR separation. A factor related to the incident was: inadequate coordination among the tower personnel.NTSB CHI93IA110Incident · No injuriesIncident investigationFinal reportFokker 100 · Chicago, ILFailure of the company station manager to follow proper dispatch procedures, and ice accumulation on the nose gear locking mechanism. Factors related to the incident were: wet snow (slush) on the runway at the departure airport, and inadequate design which…NTSB CHI93LA107Accident · No injuriesLimited investigationFinal reportBeech B90 · Chicago, ILThe pilot's misjudging distance from the parked vehicle.NTSB CHI93IA125Incident · No injuriesIncident investigationFinal reportATR ATR 72 · Chicago, ILthe local controller's failure to issue a proper heading clearance which resulted in a loss of radar separation between two departing airplanes.NTSB CHI93IA115Incident · No injuriesIncident investigationFinal reportde Havilland SHD-6 · Chicago, ILFailure of the approach and local controllers to maintain IFR separation standards between all the airplanes on the approach.NTSB CHI93LA083Accident · No injuriesLimited investigationFinal reportCessna 177 · Barrington, ILLoss of engine power due to fuel contamination.NTSB CHI93LA076Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201 · Streator, ILThe pilot's failure to perform a go-around. The tailwind and the pilot's selection of the downwind runway were factor.NTSB CHI93IA069Incident · No injuriesIncident investigationFinal reportde Havilland DHC-8-311 · Savoy, ILThe total failure of the inboard right main landing gear wheel axle during the initial climb.NTSB CHI93LA064Accident · No injuriesLimited investigationFinal reportCessna T210K · Metropolis, ILThe fatigue failure of the exhaust valve.NTSB CHI93LA058Accident · No injuriesLimited investigationFinal reportBeech 90 · Dixon, ILThe instructor pilot not maintaining directional control following engine shut down and not performing remedial action of a power reduction to regain directional control, as prescribed by his company's training manual, once the airplane began to yaw/turn to…NTSB CHI93LA059Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Lake In The Hls, ILThe student pilot's failure to maintain directional control.NTSB CHI93LA047Accident · No injuriesLimited investigationFinal reportBeech A36 · Frankfort, ILFailure of the pilot in command to maintain an airspeed above stall during a landing flare.NTSB CHI93LA043Accident · Serious injuriesLimited investigationFinal reportBoeing 727-232 · Chicago, ILThe captain's inadequate coordination with the ground and flight crew. Factors related to the accident were: the passenger's perception that the APU exhaust was a fire, which resulted in action that initiated an evacuation.NTSB CHI93LA039Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Manhattan, ILInadequate compensation for wind conditions by the pilot.NTSB CHI93LA032Accident · No injuriesLimited investigationFinal reportCessna 170B · Kankakee, ILThe pilot-in-command not obtaining directional control prior to landing touch down in a crosswind condition.NTSB CHI93LA031Accident · Serious injuriesLimited investigationFinal reportCessna 172D · Marshall, ILAn inadequate preflight inspection of the airplane by the pilot.NTSB CHI93IA035Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-8-71 · Chicago, ILAn improper repair of the retract pin boss area by the overhaul facility.NTSB CHI93FA029Accident · 2 fatalField investigationFinal reportCessna 150L · Elwood, ILThe pilot-in-command's failure to maintain a proper adequate altitude to avoid obstructions. Factors contributing to the accident was the pilot's impairment of efficiency and judgement due to alcohol, and the dark night condition.NTSB CHI93IA019Incident · No injuriesIncident investigationFinal reportPiper PA-28-181 · Chicago, ILThe failure of the midway arsa controller to coordinate use of the airspace with the Chicago north local controller which resulted in an operational deviation. A factor related to the incident was the pilot's failure to follow his assigned heading.NTSB CHI92LA288Accident · No injuriesLimited investigationFinal reportBoeing B75N1 · Belvidere, ILThe pilot's failure to maintain adequate clearance from obstacles during the aborted landing. Related factors are the failure to maintain directional control, and the pilot's lack of total experience in the type of operation.NTSB CHI92LA287Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Peoria, ILThe private pilot's misjudged touchdown. Related factors are the reduced visibility due to sunglare, ongoing runway construction, and the pilot's inattention to atc/communications/information.NTSB CHI92FA290Accident · No injuriesField investigationFinal reportBeech B55 · Joliet, ILThe pilot's inadvertent wheels up landing.NTSB CHI92FA282Accident · 1 fatalField investigationFinal reportCessna 152 · Ottawa, ILPilot did not maintain a proper airspeed which led to an inadvertent stall/spin at a low altitude where the pilot could not perform a recovery.NTSB CHI92FA279Accident · 4 fatalField investigationFinal reportCessna 177 · Manlius, ILThe pilot-in-command's failure to maintain control of the airplane during a forced landing, and his inadequate preflight which resulted in fuel exhaustion and power loss.NTSB CHI92LA277Accident · No injuriesLimited investigationFinal reportCessna 172N · Geneseo, ILThe pilot's attempted operation of the airplane with a known defficiency in the equipment.NTSB CHI92LA286Accident · No injuriesLimited investigationFinal reportCessna 210C · Peoria, ILThe pilot-in-command's not compensating for wind conditions and his not maintaining directional control.NTSB CHI92LA272Accident · No injuriesLimited investigationFinal reportBoeing A-75 · Ottawa, ILThe pilot-in-command's failure to adequately compensate for wind conditions, and his not maintaining directional control. Factors were the crosswind and wind gusts.NTSB CHI92LA268Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Harvard, ILFailure of the pilot in command to align the accident airplane with the centerline of the runway during landing.NTSB DCA92MA048Accident · 12 fatalMajor investigationFinal reportBeech C-45H · Hinckley, ILInadequate maintenance and inspection by the operator which resulted in an engine power loss during the critical takeoff phase of flight. In addition, the pilot did not, or was unable to, attain a full-feather position on the left engine propeller, which…NTSB CHI92LA281Accident · No injuriesLimited investigationFinal reportCessna 172RG · Wheeling, ILMain landing gear collapse as a result of the failure of a landing gear hydraulic pump seal.NTSB CHI92DEE04Accident · No injuriesFinal reportWeatherly 201B · Chana, ILFracture of a connecting rod resulting in loss of engine power.NTSB CHI92LA259Accident · No injuriesLimited investigationFinal reportMooney 20F · Lacon, ILThe pilot's failure to recognize that the runway he selected for landing was closed. Factors which contributed to the accident were: the pilot's anxiety following the near-collision, and his limited ability to detect the orange-colored marking.NTSB CHI92LA258Accident · Minor injuriesLimited investigationFinal reportChristen Industries S2B · Alton, ILThe pilot's failure to accomplish refueling.NTSB CHI92IA260Incident · No injuriesIncident investigationFinal reportDouglas DC-8-61 · Morton Grove, ILFailure of the right main landing gear door actuator.NTSB CHI92LA255Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Marseilles, ILThe pilot-in-command's failure to abort the takeoff. A factor was the partial loss of engine power.NTSB CHI92LA250Accident · 1 fatalLimited investigationFinal reportBoeing 747-300 · Chicago, ILAn unsafe/hazardous condition that was not identified by the vehicle driver, and an inadequate distance between the airplane and vehicle as the driver drove the vehicle behind the airplane.NTSB CHI92LA248Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Lincoln, ILA premature liftoff and failure to maintain directional control during a takeoff ground run by the pilot in command. A delay in taking remedial action by the designated pilot examiner is an additional cause.NTSB CHI92LA252Accident · Serious injuriesLimited investigationFinal reportCameron N-90 · Centralia, ILAbrupt touchdown.NTSB CHI92LA227Accident · No injuriesLimited investigationFinal reportCessna 152 · Xenia, ILImproper engine overhaul and noncompliance with an airworthiness directive by other maintenance personnel.NTSB CHI92LA222Accident · No injuriesLimited investigationFinal reportHughes 269C · Aurora, ILFatigue fracture of the engine crankshaft resulting in loss of power. Factors were the pilot's excessive descent and his lack of total experience.NTSB CHI92LA212Accident · No injuriesLimited investigationFinal reportCessna 172H · Chenoa, ILInadequate preflight planning and preparation on the part of the pilot. Factors associated with this accident were a lack of recent experience in the type of operation the pilot was undertaking, a proper climb rate not obtained by the pilot and remedial…