NTSB investigations, IL
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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 CHI99LA122Accident · Serious injuriesLimited investigationFinal reportMooney M20J · Vienna, ILThe worn ignition points/cam follower assembly, and uneven landing terrain.NTSB CHI99FA120Accident · No injuriesField investigationFinal reportExtra Flugzeugbau 300S · Dow, ILa fatigue failure of the upper left longeron and adjacent diagonal cross member near the horizontal stabilizer attach point. A factor related to the accident was that the manufacturer informed the operator that they were already in compliance with the latest…NTSB CHI99LA116Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Bloomington, ILThe pilot's misjudged flare and inadvertent stall during landing. A factor was the pilot's inadequate remedial action.NTSB CHI99LA110Accident · Serious injuriesLimited investigationFinal reportSocata TB-9C · Cahokia, ILthe in-flight loss of control by the student pilot due to wind turbulence. Additional causes were the flight instructor's inadequate supervision of the flight and the flight instructor's decision to continue the touch and go after encountering turbulence on…NTSB CHI99LA104Accident · No injuriesLimited investigationFinal reportCessna 172P · Plainfield, ILthe pilot's inadequate directional control during landing roll. A factor was the snow bank.NTSB CHI99IA096Incident · No injuriesIncident investigationFinal reportCessna T210R · Tinley Park, ILthe improper installation of the pressure oil line 'B' nut by maintenance personnel. Contributing to the incident were the loose pressure oil line 'B' nut and separation of the propeller from the aircraft.NTSB CHI99LA092Accident · No injuriesLimited investigationFinal reportCessna 172RG · Lawrenceville, ILthe fatigue fracture of the landing gear actuator.NTSB CHI99LA087Accident · No injuriesLimited investigationFinal reportSocata TB 9 Tampico · Cahokia, ILthe pilot's improper decision to initiate the takeoff with insufficient runway remaining. A factor associated with the accident was pilot's failure to obtain clarification from the controller regarding the clearance.NTSB CHI99LA081Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Paxton, ILthe inadequate preflight planning by the pilot in command and the exhaustion of usable fuel. Factors were the tailwind landing condition and the rough terrain at the landing site.NTSB CHI99LA078Accident · No injuriesLimited investigationFinal reportGates Learjet 35 · Chicago, ILthe second pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall mush.NTSB CHI99LA073Accident · Serious injuriesLimited investigationFinal reportPiper PA-46-350P · Rockford, ILthe failure of the pilot to maintain flying speed and ground clearance while on a night circling approach. Factors were existing icing conditions and the airframe and windshield icing.NTSB CHI99LA070Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Schaumburg, ILthe pilot's failure to maintain directional control of the airplane. A factor associated with the accident was the snowbank which the airplane contacted.NTSB CHI99LA065Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · St. Charles, ILA loss of engine power due to fuel exhaustion. Also causal was the pilot's inadequate preflight/planning preparation which led to inadvertent flight into instrument meteorological conditions and him becoming lost/disoriented. Contributing to the accident were…NTSB CHI99LA066Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · Creal Springs, ILwas the pilot having the fuel tank selector in the improper position and not following the airplane manufacturer's emergency procedures to restore a loss of power. A factor in this accident was fuel starvation.NTSB CHI99LA064Accident · No injuriesLimited investigationFinal reportGulfstream 695A · Wheeling, ILThe pilot-in-command (CFI)'s poor in-flight planning and decision making, and his inadequate supervision of the dual student. Factors were the tailwind condition, icing conditions, and the dual student's improper flare.NTSB CHI99LA062Accident · No injuriesLimited investigationFinal reportCessna 152 · Lansing, ILthe pilot's failure to maintain proper runway alignment during the landing flare. A factor related to the accident was the snowbank which the airplane contacted.NTSB CHI99LA054Accident · No injuriesLimited investigationFinal reportCessna 152 · Urbana, ILthe student pilot not maintaining the proper descent rate on final approach, and the certified flight instructor's delayed remedial action.NTSB CHI99LA043Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · East St. Louis, ILThe student pilot's failure to maintain directional control.NTSB CHI99LA033Accident · No injuriesLimited investigationFinal reportBrantly Helicopter B2B · Salem, ILThe simulated emergency procedure by the pilot-in-command. Additional causes were the directional control not obtained/maintained by the pilot-in-command and the inadequate supervision by the Federal Aviation Administration (FAA) Inspector. A contributing…NTSB CHI99LA028Accident · No injuriesLimited investigationFinal reportCessna 172I · Jacksonville, ILthe student pilot's failure to maintain directional control of the airplane. Factors associated with the accident were the student's lack of experience and the road which the airplane contacted.NTSB CHI99LA022Accident · No injuriesLimited investigationFinal reportMooney M20J · Cahokia, ILthe pilot's failure to maintain directional control of the airplane during the landing roll. Factors associated with the accident were the quartering tailwind and the ditch that the airplane contacted.NTSB CHI98FA353Accident · 1 fatalField investigationFinal reportBarklage Revolution Mini 500 · Cahokia, ILA loss of engine power due to cold seizure of the power-takeoff cylinder. A factor contributing to the accident was the power lines.NTSB CHI98LA351Accident · Serious injuriesLimited investigationFinal reportAerospatiale ATR-42-300 · Chicago, ILthe wake turbulence encountered by Flight 146.NTSB CHI98LA335Accident · No injuriesLimited investigationFinal reportCessna 172 · Harrisburg, ILthe loss of engine power for undetermined reasons.NTSB CHI98LA321Accident · No injuriesLimited investigationFinal reportCessna 152 · Beecher, ILFuel exhaustion due to fuel mismanagement by the pilot-in-command. The rough terrain was a contributing factor.NTSB CHI98LA318Accident · Minor injuriesLimited investigationFinal reportWhetzel Thorpe T-18 · Rantoul, ILthe pilot not maintaining directional control. Factors were crops and encounter with unsuitable terrain.NTSB CHI98LA295Accident · Minor injuriesLimited investigationFinal reportNorth American SNJ-6B · Quincy, ILthe right main landing gear collapsed for undetermined reasons.NTSB CHI98FA296Accident · 1 fatalField investigationFinal reportCessna 340A · Chicago, ILthe pilot's improper use of the throttle in not using full power for takeoff, the pilot's failure to use proper aborted takeoff procedures, and the inadvertant stall/mush. A factor associated with the accident was inadequate preflight/planning by the pilot.NTSB CHI98LA255Accident · Minor injuriesLimited investigationFinal reportCessna 172N · New Lenox, ILLoss of engine power for undetermined reasons.NTSB CHI98LA269Accident · Serious injuriesLimited investigationFinal reportBoeing 767-223 · Peotone, ILIn-flight encounter with turbulence.NTSB CHI98LA267Accident · No injuriesLimited investigationFinal reportCessna 150M · Litchfield, ILLoss of engine power due to an open exhaust valve and low cylinder compression. A related factor was the tailwind.NTSB CHI98LA310Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Leland, ILControl interference between the pilot-in-command and the student. An excessive descent rate and inadequate flare by the student during landing are contributing factors. The inadequate supervision by the pilot-in-command is an additional factor.NTSB CHI98LA251Accident · No injuriesLimited investigationFinal reportGrumman G-164B · New Haven, ILWater contamination of the fuel system. A related factor was the swampy terrain.NTSB CHI98LA282Accident · No injuriesLimited investigationFinal reportCessna 310R · Cahokia, ILThe collapse of the left main landing gear during landing roll for undetermined reasons.NTSB CHI98LA221Accident · No injuriesLimited investigationFinal reportCessna T310R · Wheeling, ILthe pilot's inadequate compensation for the wind conditions which resulted in a lack of directional control of the aircraft. Factors to the accident were the two airport signs and the crosswind.NTSB CHI98LA215Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Grays Lake, ILthe pilot's not performing a recovery from a bounced landing and his not maintaining directional control. A factor was soft terrain.NTSB CHI98LA192Accident · No injuriesLimited investigationFinal reportGrumman G164 · Somonauk, ILthe pilot's misjudgment of distance. Factors were wind gusts and crops.NTSB CHI98FA172Accident · 1 fatalField investigationFinal reportPiper J-3C · Morris, ILThe pilot's failure to maintain aircraft control during low altitude flight.NTSB CHI98LA174Accident · No injuriesLimited investigationFinal reportCessna 310L · Wheeling, ILthe collapse of the left main landing gear for undetermined reasons.NTSB CHI98FA159Accident · 4 fatalField investigationFinal reportBell 206L-1 · Arlington Hgts, ILLoss of helicopter control for unknown reasons.NTSB CHI98LA166Accident · No injuriesLimited investigationFinal reportEnstrom F28 · West Chicago, ILthe student pilot attempting a tailwind landing and improper compensation for the wind resulting in too high of a sink rate and the hard landing.NTSB CHI98LA139Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · East Hannibal, ILthe pilot's inadequate preflight planning/preparation, and his improper in-flight planning/decision. A factor was fuel exhaustion.NTSB CHI98LA127Accident · Serious injuriesLimited investigationFinal reportBoeing 727-227 · Chicago, ILthe passenger initiated evacuation of the airplane. A factor was the auxiliary power unit fire.NTSB CHI98LA122Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Barrington Hill, ILThe pilot's failure to maintain adequate airspeed which resulted in a stall/mush and subsequent in-flight collision with trees.NTSB CHI98LA121Accident · Serious injuriesLimited investigationFinal reportExtra Flugzeugbau EA-300 · Chenoa, ILthe pilot experienced GLOC (G induced loss of consciousness) while performing an aerobatic maneuver. Fatigue was a factor.NTSB CHI98LA097Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Peoria, ILan improper preflight inspection of the airplane by the pilot and the inadvertant stall/mush which was encountered. A factor associated with this accident was the pilot's decision to continue to use the emergency hydraulic hand pump rather than the CO2 bottle…NTSB CHI98FA096Accident · 2 fatalField investigationFinal reportWasielak Sonerai II L · Malta, ILThe pilot's failed to maintain adequate clearance from the other aircraft.NTSB DCA98MA023Accident · Minor injuriesClass 1 · MajorFinal reportBoeing 727-223 · Chicago, ILthe failure of the flight crew to maintain a proper pitch attitude for a successful landing or go-around. Contributing to the accident were the divergent pitch oscillations of the airplane, which occurred during the final approach and were the result of an…NTSB CHI98LA091Accident · No injuriesLimited investigationFinal reportCessna 210G · Springfield, ILThe failure of left main landing gear saddle resulting in the pilot's inability to extend the left gear. A factor was maintenance personnel's failure to comply with the related airworthiness directive.NTSB CHI98LA089Accident · No injuriesLimited investigationFinal reportChinese A/F Aero Ind Dev CTR PL-1B · Sugar Grove, ILinadequate design of the carburetor heat system by the manufacturer, and subsequent carburetor ice, which resulted in loss of engine power and a forced landing. Factors relating to the accident were: carburetor icing (weather) conditions, and obstructions and…