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 CHI90LA091Accident · No injuriesLimited investigationFinal reportCessna 152 · New Lenox, ILPilot's inability to maintain directional control of the aircraft during the touchdown and landing roll phases of flight, due to deposits of slush frozen on the left landing gear brake.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 CHI90IA084Incident · No injuriesIncident investigationFinal reportShort Brothers SD3-60 · Chicago, ILFatigue failure of a first stage power turbine blade.NTSB CHI90LA082Accident · No injuriesLimited investigationFinal reportCessna T310R · Wheeling, ILPilot's inability to maintain directional during the landing phase of flight. The slippery, snow covered runway, and a twelve knot direct crosswind contributed to the accident.NTSB CHI90LA080Accident · No injuriesLimited investigationFinal reportBeech V35 · West Chicago, ILFailure of the pilot to extend the gear, which resulted in an inadvertent wheels-up landing.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 CHI90LA063Accident · No injuriesLimited investigationFinal reportCessna 172 · Newark, ILImproper planning/decision by the pilot. The wet condition of the grass runway was a related factor.NTSB CHI90DEE04Accident · No injuriesFinal reportCessna 172RG · Romeoville, ILDual student's inadequate compensation for wind conditions and remedial action not attained by the CFI. A factor related to the accident was: a snow bank adjacent the runway.NTSB CHI90IA044Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-9-31 · Chicago, ILInadequate snow removal by airport personnel.NTSB CHI90LA069Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · West Chicago, ILFailure of the solo student pilot to maintain directional control of the aircraft, which resulted in an inadvertent ground swerve. Factors related to the accident were: the crosswind, the student pilot's lack of total inexperience, and the runway lights.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 CHI90LA037Accident · No injuriesLimited investigationFinal reportCessna 172G · Savoy, ILImproper planning/decision by the pilot, which resulted in his inability to maintain control of the aircraft. A factor related to the accident was: the adverse wind condition.NTSB CHI90DEE02Accident · Serious injuriesFinal reportEdward Avid Flyer C · Lansing Arpt, ILPilot's failure to attain proper runway alignment prior to touchdown. A factor in the accident was the builder's improper modification of the carburetors.NTSB CHI90DEE03Accident · 1 fatalFinal reportNelsen-David Sonerai II/EV · Huntley, ILPilot-in-command's failure to maintain airspeed during a turn at low altitude, resulting in an inadvertent stall and impact with terrain, lack of recent total experience and lack of total experience in type of aircraft.NTSB CHI90LA034Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Freeport, ILThe pilot-in-command's failure to properly judge the clearance between his airplane and a parked vehicle.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 CHI90FA026Accident · 1 fatalField investigationFinal reportCessna 172D · Mt Morris, ILVFR flight into IMC and spatial disorientation of the pilot. Contributing to the accident were the meteorological conditions and the overconfidence and lack of experience of the pilot.NTSB CHI90LA025Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Mcleansboro, ILThe pilot-in-command's failure to maintain control of the aircraft while recovering from a bounced landing.NTSB CHI90LA022Accident · No injuriesLimited investigationFinal reportCessna 172 · Lansing, ILThe pilot's inadvertent selection of unsuitable terrain (taxiway/construction area). The steel marker poles contributed to the aircraft damage.NTSB CHI90LA018Accident · No injuriesLimited investigationFinal reportBeech A36 · Lansing, ILPilot's poor judgement in electing to taxi across an unmarked area in dark night conditions, at an airport with known construction in progress and the airport management's failure to assure the initial repairs were sufficient to correct the holes made during…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 CHI90LA014Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Lincoln, ILImproper planning/decision by the pilot, which resulted in his failure to attain sufficient airspeed. Factors related to the accident were: the runway condition & obstructions.NTSB CHI90LA016Accident · No injuriesLimited investigationFinal reportCessna 172 · New Lenox, ILFailure of the pilot to attain wind information, which resulted in his selection of an unfavorable (wrong) runway. A factor related to the accident was: the crosswind condition.NTSB CHI90LA008Accident · No injuriesLimited investigationFinal reportBeech C23 · Rock Falls, ILImproper flare by the pilot, which resulted in a hard landing.NTSB CHI90LA007Accident · No injuriesLimited investigationFinal reportCessna 140A · Peoria, ILInadequate compensation for wind conditions by the pilot. The tailwind, the pilot's improper use of brakes, and his lack of recent experience in the type of aircraft were considered to be contributing factors.NTSB CHI90DEE01Accident · Serious injuriesFinal reportBaker/Santiago Pitts S-1S · Dekalb, ILImproper planning/decision by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel.NTSB CHI89LA197Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Lebanon, ILFailure of the pilot to use all available runway and his misjudgement of the available distance (runway length) for landing. Contributing factors were: inadequate preflight planning/preparation, and the runway and terrain conditions.NTSB CHI89LA195Accident · No injuriesLimited investigationFinal reportBeech 36 · Princeton, ILThe pilot had excessive airspeed, misjudged the landing distance, and did not go around. The high obstructions (trees),wet runway, ditch, and uneven terrain (roadway) were contributing factors.NTSB CHI89DEE06Accident · Minor injuriesFinal reportHowe Quickie Q2 · Lakeinthehills, ILThe pilot failed to maintain directional control of the airplane during a bounced landing. A factor related to the accident was the pilot's evasive maneuver to avoid rolling into a stone quarry.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 CHI89LA189Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Newark, ILThe pilot landed long and failed to make a go around.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 CHI89LA182Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Newark, ILInadequate supervision by the flight instructor (CFI) and his delay in aborting the takeoff. Factors related to the accident were: malfunction of the flap system, which resulted in an improper flap setting for takeoff, and the soft runway condition.NTSB CHI89IA180Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas MD-80 · Chicago, ILThe failure of the controller to clarify the confusing communications, to correct the pilot's misinterpretation of the instructions being given, and the failure of the supervisor to properly monitor the situation. Factors related to the incident were the…NTSB CHI89FA173Accident · Serious injuriesField investigationFinal reportCessna 150M · Plainfield, ILThe pilot-in-command lost control of the aircraft following a premature lift-off resulting in an uncontrolled descent into the terrain.NTSB CHI89LA170Accident · No injuriesLimited investigationFinal reportBeech A33 · Bloomington, ILA loss of engine power due to contamination (water, debris, and rust-like particles) in the fuel and the pilot's failure to detect the contamination during the pre-flight inspection.NTSB CHI89LA163Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Putnam, ILImproper use of carburetor heat by the pilot which resulted in reduced power for takeoff. The obstructions (hangar & trees) and weather conditions were contributing factors.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 CHI89LA142Accident · No injuriesLimited investigationFinal reportGlobe GC-1B · Metropolis, ILPilot's failure to adhere to procedures and ensure the aircraft had sufficient airspeed before attempting rotation and climbout. Airspeed was inadequate to maintain flight, and just after the landing gear was retracted the aircraft settledto the ground.NTSB CHI89IA140Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-10-10 · Chicago, ILHydroplaning attributed to the physical condition of the runway, and the airport personnel's failure to adequately maintain the runway. Contributing factors were: the rain and the wet runway.NTSB CHI89LA139Accident · No injuriesLimited investigationFinal reportPiper PA-32-301 · Grayslake, ILThe pilot's improper flare and recovery from a bounced landing, and his failure to go around (when there was sufficient speed and runway remaining). A contributing factor was his lack of recent experience in type of aircraft.NTSB CHI89FA135Accident · 3 fatalField investigationFinal reportCessna 177 · Lockport, ILThe pilot's inadequate preflight planning/preparation, and his failure to attain adequate airspeed, which resulted in a stall or mush. A factor related to the accident was: the aircraft's excessive gross weight.NTSB CHI89IA145Incident · No injuriesIncident investigationFinal reportDornier DO-228 · Chicago, ILPoor lookout by the crew of the Dornier and the citabria.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 CHI89FA124Accident · 1 fatalField investigationFinal reportCessna 150L · Sugar Grove, ILFailure to maintain airspeed above stall speed, and a stall/spin encountered with inadequate altitude for recovery. Factors related to the accident were: thunderstorm, pre-flight briefing not obtained and poor weather evaluation by the pilot.NTSB CHI89DEE04Accident · No injuriesFinal reportRenninger Mustang II · Kirkland, ILFuel starvation (possibly from vapor lock), which resulted in loss of engine power, and the pilot's misjudgement of ground clearance during a final turn to land.NTSB CHI89FA112Accident · Minor injuriesField investigationFinal reportHughes 269C · Lockport, ILImproper flight technique by the PIC during a takeoff from a confined area.