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 CHI00LA159Accident · No injuriesLimited investigationFinal reportCessna 150M · Bethalto, ILthe improper in-flight decision of the pilot to fly past the Vandalia airport onto Saint Louis Regional and the fuel exhaustion. A factor was the ditch.NTSB CHI00LA162Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Joliet, ILthe engine failure for undetermined reasons. Factors were the low altitude, remedial action not possible by the pilot, and the ditch.NTSB CHI00LA126Accident · No injuriesLimited investigationFinal reportBeech UC-45J · Urbana, ILthe pilot not maintaining directional control on the ground and the abrupt brake application during the landing roll.NTSB CHI00IA125Incident · No injuriesIncident investigationFinal reportBoeing 777-223ER · Chicago, ILthe flightcrew not detecting the runway closure NOTAM and the Air Traffic Control personnel on the metering, ground, and local positions giving an improper clearance to taxi to a closed runway. Factors were the closed runway, ATIS information not issued by…NTSB CHI00LA116Accident · No injuriesLimited investigationFinal reportBeech 58 · Decatur, ILthe failure of the pilot to extend the landing gear which resulted in the gear-up landing. A factor to the accident was the pilot's failure to complete the landing checklist.NTSB CHI00LA112Accident · Minor injuriesLimited investigationFinal reportNorth American T-28B · Kankakee, ILthe misjudged glidepath by the pilot. Factors were the failure of the impeller seal resulting in a total loss of engine oil and subsequent engine failure, the plowed farm field, and the lack of suitable terrain for the forced landing.NTSB CHI00FA110Accident · Minor injuriesField investigationFinal reportHughes 369D · Lemont, ILthe loss of engine power for undetermined reasons. A factor was the operation within the cross "hatched area" of the helicopter's height/velocity curve by the company.NTSB CHI00LA101Accident · 1 fatalLimited investigationFinal reportAerotek Pitts S-2A · Shelbyville, ILthe proper touchdown point and proper alignment not attained by the pilot. Contributing factors were the unmarked golf cart, color, and lack of a radio. Additional factors were the runway maintenance performed by the driver of the golf cart and the NOTAM(s)…NTSB CHI00LA093Accident · Serious injuriesLimited investigationFinal reportLockwood Eagle II · Marengo, ILThe pilot's failure to maintain aircraft control.NTSB CHI00LA085Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Macomb, ILthe inadequate maintenance inspection prior to the ferry flight by the pilot/mechanic rated passenger who endorsed the airplane as airworthy, the shift in the number two main bearing left half, and the fractured crankshaft. A factor was the rough/uneven…NTSB CHI00LA076Accident · Serious injuriesLimited investigationFinal reportFokker F28 MK100 · Chicago, ILthe driver of the refueling truck fell asleep which resulted in him not maintaining clearance with the parked aircraft. Factors associated with the accident were severe obstructive sleep apnea and significant hypersomnolence which resulted in chronic fatigue.NTSB CHI00LA067Accident · No injuriesLimited investigationFinal reportBeech V35 · Schaumburg, ILinadequate aircraft preflight by the pilot and fuel consumption calculations not being preformed by the pilot. Factors to the accident were fuel exhaustion, the rocks/boulders, and the high vegetation.NTSB CHI00MA066Accident · 3 fatalMajor investigationFinal reportMoravan Z242L · Zion, ILClearance not maintained by the pilot of the other airplane. A factor relating to the accident was the airport control tower's local controller's failure to provide effective sequencing.NTSB CHI00FA039Accident · 2 fatalField investigationFinal reportCessna 310N · Danville, ILAircraft control not being maintained by the flight instructor and the flight instructor's inadequate supervision of the flight. Factors to the accident were the flight instructor's VFR flight into IMC weather conditions, the inadequate preflight…NTSB CHI00IA037Incident · Minor injuriesIncident investigationFinal reportBritish Aerospace BAE 146-200A · Chicago, ILAn undetermined failure in the hydraulic system, which resulted in the airplane's entire braking system becoming temporarily inoperative. A factor associated with the incident was the airport terminal building that was contacted by the airplane.NTSB CHI00LA038Accident · No injuriesLimited investigationFinal reportCessna 310Q · Moline, ILthe landing gear locking mechanism was not properly locked. Factors relating to this accident were the improper rigging of the gear and the runway marker.NTSB CHI00FA027Accident · 3 fatalField investigationFinal reportBeech 200 · Chicago, ILOn ground collision with the lake for undetermined reasons.NTSB CHI00IA018Incident · No injuriesIncident investigationFinal reportBoeing 757-222 · Chicago, ILthe in-flight vibration of the airplane's elevator due to excessive freeplay in the elevator control system. Factors included the corrosion of the elevator PCA reaction link bearings and the elevator hinge bearings, excessive axial and radial wear of the…NTSB CHI00IA009Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-9-51 · Chicago, ILThe landing gear's wheel separation due to the improper installation of the wheel by company maintenance personnel using incomplete maintenance steps, and the maintenance steps not listed in the manufacturer's manual. Factors were the airport perimeter wall…NTSB CHI00LA007Accident · No injuriesLimited investigationFinal reportCessna 150M · Wheeling, ILaircraft control not maintained by the pilot. A factor to the accident was the windshear.NTSB CHI00FA003Accident · 1 fatalField investigationFinal reportBeech D-45 · Oswego, ILthe visual lookout not obtained by the pilot of the Beech T-34 and the inadequate procedure by the Lima Lima Flying Squadron. The delayed entry into the maneuver by the pilot of the Beech D-45 was a contributing factor.NTSB CHI99IA351Incident · No injuriesIncident investigationFinal reportCessna 402B · Chicago, ILThe failure of the pilot in command to maintain clearance with ground obstructions.NTSB CHI99LA358Accident · No injuriesLimited investigationFinal reportBosick Pulsar · Belleville, ILA loss of engine power for undetermined reasons.NTSB CHI99FA342Accident · 2 fatalField investigationFinal reportPiper PA-38-112 · Warrensburg, ILAircraft control not being maintained by the private pilot candidate and the inadequate supervision by the FAA Designated Examiner. Factors relating to the accident were the inadvertent spin, the unsuccessful remedial action attempted by the flightcrew, and…NTSB CHI99LA335Accident · No injuriesLimited investigationFinal reportBenson Sorrell SNS-7 · Mt. Vernon, ILthe pilot's inadequate compensation for the wind condition which resulted in an inadvertent ground loop. A factor associated with the accident was the gusty crosswind.NTSB CHI99LA330Accident · No injuriesLimited investigationFinal reportBoeing Stearman E75 · Sparta, ILThe pilot's decision not to use all of the available. A factor to the accident was the ditch.NTSB CHI99LA312Accident · No injuriesLimited investigationFinal reportCessna 172M · Bloomington, ILthe pilot's inadequate visual lookout and not performing a maneuver to avoid obstructions. A factor was the road signs.NTSB CHI99LA308Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Granite City, ILLoss of power for undetermined reason(s) and the rough/uneven.NTSB CHI99FA293Accident · 2 fatalField investigationFinal reportHudson Avenger · Lansing, ILthe weight and balance exceeded by the owner/builder. The inadequate preflight planning/preparation by the owner/builder.NTSB CHI99LA289Accident · Serious injuriesLimited investigationFinal reportAerospatiale ATR-42-300 · Chicago, ILthe failure of the ramp service clerk to maintain clearance with the operating propeller. A factor related to the accident the inattentiveness on the part of the clerk.NTSB CHI99LA288Accident · No injuriesLimited investigationFinal reportCessna 172G · Glenarm, ILthe pilot's selection of the wrong runway for the prevailing winds. Factors were the pilot's misunderstanding of the wind information and the tailwind.NTSB CHI99LA279Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Schaumburg, ILthe CFI's delay in taking remedial action to maintain directional control of the airplane. A factor associated with the accident was the student's improper use of the brakes.NTSB CHI99LA283Accident · No injuriesLimited investigationFinal reportCessna 172P · Waukegan, ILthe pilot's misjudged landing flare and his inadequate recovery from the bounced landing.NTSB CHI99FA278Accident · 4 fatalField investigationFinal reportPiper PA-28R-200 · Grayslake, ILthe pilot not maintaining altitude and clearance. Factors were the light condition of night, the pilot's lack of recent experience in night operations, and the transmission wire.NTSB CHI99LA268Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-401B · Edelstein, ILan inadequate fuel supply which resulted in fuel exhaustion. Factors associated with the accident were the low altitude at which the power loss occurred and the corn crop the airplane contacted.NTSB CHI99LA275Accident · No injuriesLimited investigationFinal reportFairchild 24 C8C · La Fayette, ILthe pilot's failure to obtain/maintain the proper descent rate. A factor to the accident was the partial loss of engine power as a result of the exhaust valve keeper becoming unlocked, which jammed the exhaust valve.NTSB CHI99FA238Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Yorkville, ILthe pilot continuing into known adverse weather conditions, attempting low altitude flight, and not maintaining terrain clearance. Factors to the accident were the thunderstorm and the improper weather evaluation by the pilot following pre-departure and…NTSB CHI99LA228Accident · Minor injuriesLimited investigationFinal reportMcmillan Zodiac CH 601 HD · Nauvoo, ILThe pilot's failure to follow the airplane checklist to pin the canopy before departure, resulting in the opening of the canopy on take off and the subsequent aerodynamic stall and ground collision.NTSB CHI99LA211Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Addison, ILThe pilot's improper fuel selector positioning resulting in fuel starvation during cruise.NTSB CHI99LA217Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Dongola, ILthe failure of the pilot to maintain a proper glidepath on the landing approach, and the failure of the pilot to select a proper touchdown point. Factors to the accident were the lack of runway lights, the dusk light condition, and the ditch.NTSB CHI99LA210Accident · No injuriesLimited investigationFinal reportErcoupe 415-CD · Jacksonville, ILA material defect in the sloshing compound. Factors were the blocked fuel system, inspection not identifying material defect, and the crop field.NTSB CHI99LA206Accident · No injuriesLimited investigationFinal reportBeech 58 · Wheeling, ILthe landing gear extension not performed by the pilot. A contributing factor was the checklist not followed by the pilot.NTSB CHI99IA204Incident · No injuriesIncident investigationFinal reportBoeing 767-323 · Chicago, ILthe pilot's failure to maintain clearance from the parked aircraft while taxiing. A factor in the accident was the failure of ATC to issue a traffic advisory.NTSB CHI99LA173Accident · No injuriesLimited investigationFinal reportAero Commander 500 · Effingham, ILinadvertent wheels-up landing and the checklist not followed by the pilot. The landing gear lever not engaged was an additional cause.NTSB CHI99LA153Accident · No injuriesLimited investigationFinal reportBell 222UT · Rockton, ILThe pilot's misjudged flare during landing. A factor to the accident was the dark night lighting condition.NTSB CHI99LA151Accident · No injuriesLimited investigationFinal reportEngleman Pitts S1 · Mattoon, ILThe pilot's failure to maintain directional control and inadvertent ground loop/swerve. A related factor was the crosswind.NTSB CHI99LA145Accident · Serious injuriesLimited investigationFinal reportBoeing 737-222 · Chicago, ILthe flight attendants did not follow the cockpit crews instructions to be seated because of expected turbulence. A factor associated with the accident was the turbulence encountered.NTSB CHI99LA139Accident · No injuriesLimited investigationFinal reportCessna 182C · Loraine, ILA fuel system related fire in the engine compartment.NTSB CHI99IA144Incident · No injuriesIncident investigationFinal reportCessna 206H · Wheeling, ILimproper installation of the aileron control bellcrank stop bolts and lock nuts during the manufacturing process which resulted in a binding aileron control surface.NTSB CHI99LA133Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Morris, ILthe directional control not maintained by the pilot. Contributing factors were the wind gusts, crosswind and runway light.