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 CHI02LA161Accident · No injuriesLimited investigationFinal reportCessna R182 · Harvard, ILThe pilot's failure to verify the extension of the landing gear. Factors were the alternator failure, and the main landing gear down locks not engaged.NTSB NYC02LA110Accident · Serious injuriesLimited investigationFinal reportBoeing 757-232 · Fairfield, ILThe first officer's abrupt level off.NTSB CHI02LA150Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Sparta, ILThe total loss of engine power due to a separated cylinder and the failure of the pilot to perform a precautionary landing at the nearest suitable airport when the engine had a partial loss of engine power. The failure of the aircraft owners to perform an…NTSB CHI02LA136Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Lake in Hills, ILIt was not possible for the pilot to land the airplane at a proper touchdown point during the aborted takeoff and unsuitable terrain was encountered off the end of the runway. Factors associated with the accident were a proper climb rate was not achieved…NTSB CHI02LA128Accident · No injuriesLimited investigationFinal reportBoeing 757-33N · Chicago, ILThe ground personnel handled the aircraft improperly during pushback from the gate by failing to maintain clearance with the other parked aircraft. The light rain and the parked airplane that was contacted were factors.NTSB CHI02LA131Accident · Serious injuriesLimited investigationFinal reportGlaser-Dirks-Flugzeubau DG-100G · Union, ILThe pilot not maintaining aircraft control during the aero-tow takeoff. Factors to the accident were the high wind velocity and the gusting wind condition.NTSB CHI02LA126Accident · No injuriesLimited investigationFinal reportPiper PA 28-181 · Sandwich, ILThe driver of the automobile improperly drove his automobile on the active runway and did not maintain visual lookout for landing aircraft.NTSB CHI04LA124Accident · No injuriesLimited investigationFinal reportBeech 58 · Lansing, ILThe flight crew's failure to follow the checklist resulting in a landing without the landing gear extended.NTSB CHI02LA119Accident · No injuriesLimited investigationFinal reportCessna 560 · Lake In The Hil, ILThe flightcrew's delay in executing a go-around..NTSB CHI02LA115Accident · No injuriesLimited investigationFinal reportCessna 551 · Lake in Hills, ILThe deer on the runway.NTSB CHI02LA092Accident · No injuriesLimited investigationFinal reportCessna 152 · Christopher, ILThe in-flight collision with a Canadian goose, which caused substantial damage to the airplane's right wing. A factor to the accident was the dark night light condition.NTSB CHI02LA090Accident · No injuriesLimited investigationFinal reportCessna 182J · Springfield, ILThe pilot not maintaining clearance from a fence while taxiing. The fence was a factor.NTSB CHI02LA077Accident · No injuriesLimited investigationFinal reportCessna 172 · Manito, ILThe pilot's improper planning and decision and his failure to maintain adequate airspeed, which resulted in a stall and hard landing. The gusting crosswind conditions were a contributing factor.NTSB CHI02LA066Accident · No injuriesLimited investigationFinal reportCessna T210N · Chicago, ILthe pilot's failure to maintain aircraft control after takeoff. Factors relating to the accident were the pilot excessive rotation during takeoff and the crosswind.NTSB CHI02LA063Accident · No injuriesLimited investigationFinal reportBeech V35B · Mattoon, ILA loss of engine power for undetermined reasons. Factor to the accident was the unsuitable rough/uneven terrain encountered during the forced landing.NTSB CHI02IA058Incident · No injuriesIncident investigationFinal reportBoeing 737-522 · Chicago, ILThe wake turbulence encounter.NTSB CHI02IA050Incident · No injuriesIncident investigationFinal reportBoeing 737-322 · Chicago, ILReason for occurrence is undetermined.NTSB CHI02FAMS1Accident · 4 fatalMissing aircraftFinal reportCessna R182 · Lake Michigan, ILThe uncontrolled descent for undetermined reasons.NTSB CHI02LA022Accident · No injuriesLimited investigationFinal reportSmith Aerostar 601 · Danville, ILThe separation of the main landing gear scissor assembly during landing for undetermined reasons, resulting in the directional control of the airplane not being possible.NTSB CHI02LA032Accident · No injuriesLimited investigationFinal reportPiper PA-15 · Decatur, ILThe excessive braking performed by the flight instructor.NTSB CHI02LA018Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Peoria, ILThe gear collapse for undetermined reasons during the landing roll. A factor was the pilot not using a proper touchdown point by landing long.NTSB CHI02LA016Accident · No injuriesLimited investigationFinal reportCessna T210M · Salem, ILThe ruptured hydraulic hose.NTSB CHI02LA007Accident · 1 fatalLimited investigationFinal reportWoodrow Stolp-Adams Starduster SA-100 · Millstadt, ILThe pilot not maintaining altitude/clearance from the tree line. Factors to the accident were the pilot attempting the low altitude flight/maneuver and the presence of the tree line.NTSB CHI02FA006Accident · 1 fatalField investigationFinal reportCessna 150L · Union, ILThe pilot not maintaining appropriate airspeed which resulted in an inadvertent stall.NTSB CHI01LA321Accident · No injuriesLimited investigationFinal reportBoeing Stearman B75N1 · Carbondale, ILThe pilot misjudged the proper alignment with the landing area. Contributing to the accident was the light conditions.NTSB CHI01LA314Accident · No injuriesLimited investigationFinal reportBeech 76 · Wheeling, ILThe failure of the hydraulic power pack,and the false landing gear position indication.NTSB CHI01FA312Accident · Serious injuriesField investigationFinal reportPiper PA-32R-301T · Downers Grove, ILthe improper preflight planning/preparation and the short field take off/procedure not followed by the pilot. Contributing factors were the airplane's forward center of gravity, the variable gusting wind and improper weight and balance calculations by…NTSB CHI01FA298Accident · 1 fatalField investigationFinal reportSpears RV-6 · Grayslake, ILThe pilot inadvertently stalled the airplane. A factor was the impairment due to marihuana.NTSB CHI01LA302Accident · No injuriesLimited investigationFinal reportSwearingen SA226-T · West Chicago, ILthe checklist not followed and the directional control not maintained by the pilot. A contributing factor was the left propeller’s start locks being engaged.NTSB CHI01LA282Accident · No injuriesLimited investigationFinal reportHoskins Quickie Q2 · Carbondale, ILThe failure of the tailwheel spring. A factor was the directional control not possible by the pilot.NTSB CHI01LA284Accident · Minor injuriesLimited investigationFinal reportCameron Balloons Shuttle 90 · Centralia, ILThe balloon envelope fire. A contributing factor was the flammability of the envelope.NTSB CHI01LA274Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Union, ILThe total failure of the crankshaft as a result of fatigue and the unsuitable terrain encountered during the forced landing. Factors associated with the accident were the soft terrain on which the forced landing was made and the subsequent gear collapse.NTSB CHI01FA270Accident · No injuriesField investigationFinal reportBoeing 717-200 · Mascoutah, ILThe malfunction of the nose gear extension system, which resulted from a previous ground collision with a wheel chock. A factor was the wheel chock.NTSB CHI01LA272Accident · No injuriesLimited investigationFinal reportCessna 152 · Peru, ILThe pilot's inadequate recovery from a bounced landing. Factors associated with the accident were improper touchdown point, rough terrain, and the nose gear collapse.NTSB CHI01LA255Accident · No injuriesLimited investigationFinal reportBeech A36 · Sugar Grove, ILthe inadequate maintenance inspection and the unsuitable terrain encountered by the pilot mechanic. The fuel system leak was a contributing factor.NTSB CHI01LA223Accident · Minor injuriesLimited investigationFinal reportHughes 269A · Jacksonville, ILThe helicopter's loss of engine power for undetermined reasons while maneuvering close to the ground, and the low altitude and low airspeed. A factor relating to this accident was the pilot not being able to get into autorotation.NTSB CHI01FA234Accident · 3 fatalField investigationFinal reportCessna 177 · Benton, ILThe pilot's failure to maintain adequate airspeed, resulting in a stall.NTSB CHI01FA233Accident · 2 fatalField investigationFinal reportPiper PA-32-260 · Chenoa, ILThe inadvertent stall the pilot encountered during his turn with an in-flight loss of engine power due to fuel starvation on initial climbout and the improper in-flight decision he made to continue the turn. Factors were the fuel starvation and the incorrect…NTSB CHI01FA232Accident · 2 fatalField investigationFinal reportSmith Kelly-D · Poplar Grove, ILThe right upper wing failed due to overload. A factor was the pilot performing aerobatic manuevers.NTSB CHI01LA205Accident · No injuriesLimited investigationFinal reportCessna 172S · Lake in the Hil, ILThe student pilot misjudging the flare during that landing. Factors were the wrong runway selected by the student pilot, the tailwinds encountered during that landing and the flight instructor's inadequate supervision during that landing.NTSB CHI01LA202Accident · No injuriesLimited investigationFinal reportCessna 172N · West Chicago, ILThe instructor pilot's inadequate recovery from the bounced landing and inadequate supervision of the dual students alignment with the runway. A factor was the student pilot not maintaining proper alignment with the runway during landing.NTSB CHI01LA308Accident · No injuriesLimited investigationFinal reportCessna 182K · Mattoon, ILThe pilot improperly flared the airplane which resulted in a hard landing.NTSB CHI01LA193Accident · No injuriesLimited investigationFinal reportCessna 182 · Taylorville, ILThe pilot's improper procedure and the unsuitable terrain encountered during the forced landing. Additional factors included the carburetor icing and the corn crop.NTSB CHI01LA199Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Albion, ILthe maintenance performed on the airplane by the unqualified pilot The unsuitable takeoff area selected by the pilot was an additional cause. The ditch was a contributing factor.NTSB CHI01FA186Accident · No injuriesField investigationFinal reportBowman Renegade Spirit · Lynn Center, ILthe in-flight deformation of the left wing.NTSB CHI01LA175Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Morris, ILthe directional control not maintained by the pilot. The crosswind was a contributing factor.NTSB CHI01LA168Accident · No injuriesLimited investigationFinal reportSchleicher ASW-20 · HIghland, ILThe pilot's failure to extend the spoilers during landing approach, which resulted in a touchdown at a higher than normal airspeed. An additional cause was the intentional ground loop/swerve maneuver performed by the pilot to avoid overrunning the end of the…NTSB CHI01LA167Accident · Serious injuriesLimited investigationFinal reportde Havilland DHC-6 Twin Otter · Ottawa, ILthe failure of the passenger to maintain clearance from the windmilling propeller after exiting the airplane.NTSB CHI01LA166Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Bloomington, ILThe pilot's failure to maintain aircraft control during the visual approach for landing.NTSB CHI01FA165Accident · Serious injuriesField investigationFinal reportVanderBeek Christen Eagle II · Plainfield, ILthe improper in-flight planning/decision and the aircraft control not maintained by the pilot. The thunderstorm outflow was a contributing factor.