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 CHI04CA206Accident · No injuriesData collectionFinal reportTjerrild Rotorway Exec · Eureka, ILThe in-flight loss of engine power due to the disconnection of the high tension wire from its ignition coil during cruise flight and the unsuitable terrain the pilot encountered during his forced landing. A factor was the low altitude the helicopter was…NTSB CHI04FA198Accident · 2 fatalField investigationFinal reportMooney M20J · Fox Lake, ILThe flight crew's failure to maintain airspeed which led to an inadvertent stall/spin. An additional cause was the flight instructor's unsuccessful remedial action during the course of the accident sequence. The slow flight performed was a factor.NTSB CHI04LA196Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas DC-9-82 · Sheridan, ILThe convection induced turbulence and the flight attendant not being restrained.NTSB CHI04CA179Accident · No injuriesData collectionFinal reportWaco YMF-FSC · Lansing, ILThe pilot's inadequate compensation for wind conditions and his failure to maintain directional control. The crosswind and the ditch were contributing factors.NTSB CHI04CA164Accident · No injuriesData collectionFinal reportCessna 401 · Mt. Vernon, ILThe pilot's misjudgment of the landing flare. Contributing factors were the pilot's failure to execute a stabilized approach for landing. An additional factor was the presence of the runway lights.NTSB CHI04CA160Accident · Minor injuriesData collectionFinal reportChampion 7FC · Carmi, ILThe pilot's failure to maintain directional control during the takeoff roll, his decision to continue the takeoff when the aircraft had left the runway surface, and his selection of unsuitable terrain for the continued takeoff. An additional cause was the…NTSB CHI04LA155Accident · No injuriesLimited investigationFinal reportMitsubishi MU-2B-40 · Waukegan, ILThe pilot's misjudgment of the landing flare which resulted in a hard landing. Contributing factors were the subsequent overload and collapse of the nose landing gear.NTSB CHI04CA153Accident · Minor injuriesData collectionFinal reportLuscombe 8E · Joliet, ILThe pilot's selection of unsuitable terrain for takeoff and the subsequent failure to maintain aircraft control during the encounter with the standing water. Contributing factors were the standing water and the soft runway condition.NTSB CHI04LA131Accident · 1 fatalLimited investigationFinal reportZorn EAA Sport Bi-Plane · Mazon, ILThe pilot's failure to maintain airspeed while maneuvering which resulted in a stall. A factor associated with the accident was the pilot's unfamiliarity with the handling characteristics of the airplane.NTSB CHI04GA130Accident · 1 fatalFinal reportCessna T206H · Homer Glen, ILThe seized turbocharger, the altitude/clearance not maintained/obtained during approach to a forced landing on an agricultural field, and the unsuitable landing area encountered by the pilot. Contributing factors were the inadequate emergency procedures by…NTSB CHI04CA117Accident · No injuriesData collectionFinal reportPiper PA-28RT-201 · DeKalb, ILThe failure of the pilot and his flight instructor to identify the location of the relocated threshold and proper touchdown point, which resulted in the airplane striking the construction barricade while on approach. A factor to the accident was the…NTSB CHI04CA114Accident · No injuriesData collectionFinal reportCessna 172P · Schaumburg, ILThe student pilot not maintaining directional control during the takeoff roll and his inadequate remedial action.NTSB CHI04CA095Accident · No injuriesData collectionFinal reportBeech C23 · Lake in the Hil, ILThe dual student pilot not maintaining airplane control during the go-around and the flight instructor pilot's inadequate remedial action resulting in the airplane's uncontrolled descent.NTSB CHI04LA087Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Peru, ILThe inadvertent landing gear retraction by the dual student during the landing roll.NTSB CHI04LA070Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · Casey, ILThe pilot not maintaining aircraft control during the loss of engine power and his improper remedial action during the encountered uncommanded roll (VMC roll). An additional cause was the pilot's failure to obtain a maintenance inspection by a qualified…NTSB CHI04LA063Accident · No injuriesLimited investigationFinal reportPiper PA 28-161 · Lansing, ILThe improper flare by the pilot due to his diverted attention during landing. Factors were the pilot's failure to execute a go-around, the overload of the right main landing gear, and the snowbank.NTSB CHI04CA067Accident · No injuriesData collectionFinal reportCessna 172N · Cahokia, ILThe inadequate supervision by the certified flight instructor which lead to the student pilot's failure to maintain clearance from the snowbank during the landing. The snowbank was a factor.NTSB CHI04LA053Accident · No injuriesLimited investigationFinal reportBeech E-90 · Galesburg, ILThe pilot's inadequate preflight by not complying with the airplane's before takeoff checklist to verify that the cabin door was secured leading to its in-flight separation from the airplane. A factor was that the door was not secured.NTSB CHI04LA050Accident · No injuriesLimited investigationFinal reportCessna 182A · West Chicago, ILThe inadequate starting and flooded engine procedure used by certified flight instructor while providing instruction to the dual student.NTSB CHI04FA029Accident · Minor injuriesField investigationFinal reportLearjet 24D · Belleville, ILThe total loss of power to the right engine and the partial loss of power to the left engine after the airplane encountered a flock of birds during initial climb out, resulting in impeded ram induction airflow.NTSB CHI04FA031Accident · No injuriesField investigationFinal reportCessna 560XL · Wheeling, ILThe flight crew's intentional operation with know deficiencies in the aircraft and their delay in aborting the takeoff when a no-takeoff warning was presented. An additional cause was the crew's failure to comply with flight manual procedures concerning…NTSB CHI04LA016Accident · Serious injuriesLimited investigationFinal reportOostdik M-18-X · Pana, ILThe pilot's attention was diverted to a person on the ground which resulted in his failure to maintain altitude/clearance with trees . A contributing factor to the accident were trees.NTSB CHI04LA013Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 · Schaumburg, ILThe commercial pilot not maintaining directional control of the helicopter and the improper flare initiated before landing.NTSB CHI04LA010Accident · No injuriesLimited investigationFinal reportWright Redux Association 1903 Wright Flyer · Bolingbrook, ILThe inadequate planning/decision by the pilot to begin a flight in gusting wind conditions, the pilot's lack of experience in the airplane, and the stall encountered by the pilot during takeoff. The wind gusts were a contributing factor.NTSB CHI04LA008Accident · No injuriesLimited investigationFinal reportErcoupe 415-D · Harvard, ILThe pilot misjudged his altitude and distance from the approach end of the airstrip, along with his decision to land at an unlit airstrip at night. Factors involved in the accident were the the night lighting conditions, the unlit airstrip, and the corn crop…NTSB CHI04LA002Accident · Minor injuriesLimited investigationFinal reportGoldman Dragonfly · Peoria, ILThe loss of power for undetermined reasons and the inadvertent stall of the canard by the pilot on the turn to final during the forced landing, as well as the excessive descent rate causing the aircraft to "pancake" into the ground.NTSB CHI03LA314Accident · No injuriesLimited investigationFinal reportCessna 182S · Joliet, ILThe pilot not performing a go-around when the other airplane taxied onto the landing runway, which resulted in the pilot not attaining the proper touchdown point. Factors to the accident include the failure of the alternator, the complete loss of electrical…NTSB CHI03LA317Accident · No injuriesLimited investigationFinal reportBurkhart Grob G102 Club Astir Iiib · Highland, ILThe pilot encountering unsuitable terrain during an off-airport landing. A factor to the accident was the high vegetation.NTSB CHI03LA304Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Atwood, ILThe pilot's failure to correctly identify the location of the airport. Factors to the accident include the pilot flying while fatigued, which contributed to his misidentification of the runway, and the rough/uneven soybean field.NTSB CHI03LA318Accident · Minor injuriesLimited investigationFinal reportDixon Glasair II · Columbia, ILThe pilot's failure to maintain directional control during an aborted takeoff. Contributing factors were the open cabin door, the grass runway and the soft terrain adjacent to the runway.NTSB CHI03LA306Accident · No injuriesLimited investigationFinal reportBellanca 14-13-2 · Moline, ILThe partial failure of the engine driven fuel pump and fuel starvation. An additional cause was the pilot misjudging the proper glidepath and his improper in-flight decision during the precautionary landing to pull back the power and lower the flaps prior to…NTSB CHI03LA288Accident · No injuriesLimited investigationFinal reportBeech M35 · Avon, ILThe pilot's inadequate fuel managemant leading to fuel starvation during cruise flight and the unsuitable terrain she encountered during the forced landing. A factor was her lack of total time in the airplane make and model.NTSB CHI03LA283Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Deer Grove, ILThe pilot's failure to attain the proper touchdown point, and his failure to execute a go-around.NTSB CHI03LA327Accident · No injuriesLimited investigationFinal reportExtra Flugzeugbau EA200 · Sugar Grove, ILA loss of engine power due to the pilot's inadvertent deactivation of the magnetos, and the pilot's selection of the wrong runway for the forced landing. Factors were the low altitude and the unsuitable terrain encountered during the forced landing.NTSB CHI03LA209Accident · No injuriesLimited investigationFinal reportYoung Cozy MkIV · Quincy, ILThe pilot's improper flare.NTSB CHI03IA293Incident · No injuriesIncident investigationFinal reportBell 230 · Wilmington, ILThe material defect during the manufacture of the tail rotor counterweight bellcrank and the bellcrank's subsequent failure due to a fatigue fracture.NTSB CHI03LA328Accident · No injuriesLimited investigationFinal reportLet L-13 Blanik · Highland, ILThe pilot's failure to extend the spoilers and his inadvertent use of the flaps during final approach, which resulted in the proper touchdown point being exceeded due to excessive airspeed. A factor to the accident was the dirt mound.NTSB CHI03LA270Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Hudson, ILThe pilot failed to abort the takeoff. A factor was the soybean crop.NTSB CHI03LA260Accident · No injuriesLimited investigationFinal reportCessna 172L · Harvard, ILThe pilot's improper flare which led to a hard landing.NTSB CHI03LA258Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Litchfield, ILAn animal wandered onto the runway and collided with the airplane. A factor was the night light condition.NTSB CHI03LA247Accident · Minor injuriesLimited investigationFinal reportTexas Helicopter OH-13E · Byron, ILThe pilot not attaining translational lift during the takeoff. A factor was the high gross weight.NTSB CHI03LA240Accident · Minor injuriesLimited investigationFinal reportEnstrom F-28C · Kankakee, ILThe pilot misjudged flare which led to a hard landing. Contributing to the accident was the pilot's failure to follow procedures/directives when he exceeded the airplane's weight and balance.NTSB CHI03LA221Accident · Minor injuriesLimited investigationFinal reportNavion L-17A · Canton, ILA complete loss of engine power during landing approach for undetermined reasons, as well as the unsuitable terrain for a forced landing encountered by the pilot. Contributing factors were the berm and the crops.NTSB CHI03LA237Accident · Serious injuriesLimited investigationFinal reportBoeing B777-222 · Chicago, ILThe turbulence encountered during the descent which seriously injured a passenger returning to her seat after the seat belt sign was activated. A factor was that it was not possible for the returning passenger to comply with the lit seat belt sign.NTSB CHI03LA212Accident · No injuriesLimited investigationFinal reportCessna 172P · Pinckneyville, ILThe planned approach not maintained by the pilot and the delayed remedial action by the certified flight instructor. A contributing factor to the accident was the approach light.NTSB CHI03FA202Accident · 1 fatalField investigationFinal reportCessna 150L · Schaumburg, ILThe pilot not maintaining airplane control and the inadvertent stall he encountered during initial climb.NTSB CHI03LA196Accident · No injuriesLimited investigationFinal reportBell 206B3 · Lansing, ILThe dynamic rollover encountered by the pilot. Factors were the inadequate remedial action by the pilot due to his failure to prevent the rollover, and the inadequate facility with regard to the design of the landing platform.NTSB CHI03FA181Accident · 3 fatalField investigationFinal reportRobinson R44 II · Coleta, ILThe pilot not maintaining main rotor RPM during cruise flight. The factor in the two passenger's fatal injuries was the pilot not following directives concerning the prohibition of carrying passengers while a student pilot. Other factors were the pilot's use…NTSB CHI03LA167Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Atwood, ILThe pilot's selection of an unsuitable landing area and his improper decision to continue the approach without the airport and runway clearly in-sight. Factors contributing to the accident were the pilot's disorientation, the transmission wires, and the road…NTSB CHI03LA161Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Gridley, ILThe checklist not followed by the pilot and the fuel starvation of the engine. The incorrect fuel tank selector position by the pilot,, and the lack of recurrent training were contributing factors.