NTSB investigations, IL
180,604 investigations by the National Transportation Safety Board since 1962: 174,583 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 CEN21FA024Accident · 1 fatalClass 3 · FieldFinal reportGlasair III · Ford Heights, ILThe loss of engine power for reasons that could not be determined based on the available evidence.NTSB CEN20LA427Accident · No injuriesClass 4 · LimitedFinal reportSchleicher ASK21 · Hinckley, ILThe pilot’s improper control input during a bounced landing that resulted in the glider impacting terrain.NTSB CEN20LA400Accident · 1 fatalClass 3 · LimitedFinal reportSafari S · Red Bud, ILA loss of control for reasons that could not be determined.NTSB CEN20CA406Accident · Minor injuriesClass 4 · Data collectionFinal reportPik PIK-20D · Union, ILThe pilot’s failure to maintain directional control during takeoff that resulted in a collision with another glider that was parked close to the departure runway, and the pilot’s improper decision to attempt a takeoff without ensuring he had safe clearance…NTSB CEN20CA405Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA28 · Huntley, ILThe pilot’s decision to land at night without runway lighting, which resulted in a collision with an object.NTSB CEN20LA403Accident · No injuriesClass 3 · LimitedFinal reportCessna 177RG · Palatine, ILThe loss of partial engine power due to fuel starvation during departure which resulted in a forced landing and collision with a utility pole.NTSB CEN20LA367Accident · 1 fatalClass 3 · LimitedFinal reportCirrus SR22 · Lawrenceville, ILThe pilot’s controlled flight into terrain as a result of his failure to properly execute an instrument approach and maintain clearance from trees in night instrument meteorological conditions. Contributing to the accident was the pilot’s unfamiliarity with a…NTSB CEN20LA352Accident · 1 fatalClass 3 · LimitedFinal reportBeech 200 · Rockford, ILThe pilot’s failure to maintain airplane control following a reduction of thrust in the left engine during takeoff. The reason for the reduction in thrust could not be determined based on the available evidence.NTSB CEN20LA342Accident · Minor injuriesClass 3 · LimitedFinal reportSiebel Auriga · Rockford, ILThe total loss of engine power for reasons that could not be determined based on available information.NTSB CEN20CA333Accident · No injuriesClass 4 · Data collectionFinal reportCub Crafters Carbon CUB EX · Marion, ILThe pilot's failure to attain/maintain directional control during landing that resulted in a ground-loop and collision with terrain.NTSB CEN20CA313Accident · No injuriesClass 4 · Data collectionFinal reportRobinson R44 · Dakota, ILThe pilot’s failure to maintain main rotor clearance from a ground obstacle during a landing.NTSB CEN20CA308Accident · Serious injuriesClass 4 · Data collectionFinal reportMaule MXT7 · Hillsboro, ILThe pilot's exceedance of the airplane's critical angle of attack while attempting to avoid a deer during landing, resulting in an aerodynamic stall.NTSB CEN20CA302Accident · Minor injuriesClass 4 · Data collectionFinal reportPiper PA28 · Grayslake, ILThe pilot’s application of the left brake during landing resulting in a runway excursion.NTSB DCA20CA122Accident · Serious injuriesClass 4 · Data collectionFinal reportEmbraer ERJ170 · Plainfield, ILan encounter with convective turbulence.NTSB CEN20CA236Accident · No injuriesClass 4 · Data collectionFinal reportBellanca 1730A · Martinton, ILThe pilot's improper decision to conduct an off-field precautionary landing.NTSB CEN20LA219Accident · 1 fatalClass 3 · LimitedFinal reportFlight Design Ctls · Beecher, ILThe pilot’s decision to continue takeoff after a partial loss of engine power, and the pilot’s subsequent failure to control airplane pitch during a forced landing. Contributing to the accident was the partial loss of engine power for reasons that could not…NTSB CEN20LA201Accident · 4 fatalClass 3 · LimitedFinal reportPiper PA28 · Carlinville, ILThe pilot’s attempted recovery from a steep descent which inadvertently exceeded the ultimate load factor of the airframe and resulted in a low-level inflight breakup.NTSB CEN20CA192Accident · No injuriesClass 4 · Data collectionFinal reportChampion 7GCBC · Carbondale, ILThe pilot's excessive brake input while he attempted to maintain directional control during landing roll.NTSB CEN20CA182Accident · No injuriesClass 4 · Data collectionFinal reportCessna 120 · Chatham, ILThe pilot's decision to continue flight in instrument meteorological conditions in an airplane not equipped for instrument flight, which forced her to perform a precautionary landing to a muddy field resulting in the airplane nosing over.NTSB CEN20CA181Accident · Serious injuriesClass 4 · Data collectionFinal reportCessna 172 · Colchester, ILThe pilot's inadequate preflight of the fuel quantity which resulted in a loss of engine power due to fuel starvation during cruise flight.NTSB CEN20LA168Accident · 1 fatalClass 3 · LimitedFinal reportYakovlev YAK 52 · Palmyra, ILA loss of control during a low-altitude aerobatic maneuver.NTSB CEN20FA110Accident · 3 fatalClass 3 · FieldFinal reportCessna 172 · Lincoln, ILThe pilot's exceedance of the airplane's critical angle of attack during an aerial survey, which resulted in an aerodynamic stall at an altitude too low to recover.NTSB CEN20FA070Accident · 3 fatalClass 3 · FieldFinal reportPiper PA60 · Springfield, ILThe pilot’s failure to follow the instrument landing system (ILS) course guidance during the instrument approach.NTSB DCA20CA046Accident · Serious injuriesClass 4 · Data collectionFinal reportBoeing 737 · Chicago, ILan abrupt stop during taxi to avoid a collision with another airplane, causing a flight attendant to fall.NTSB DCA20LA013Accident · No injuriesClass 3 · LimitedFinal reportEmbraer EMB145 · Chicago, ILThe flight crew’s inability to maintain the airplane on the runway centerline after touchdown due to the reduced braking action resulting from the deteriorating weather conditions, which caused the airplane’s departure from the runway surface. Contributing to…NTSB DCA19CA223Accident · No injuriesClass 4 · Data collectionFinal reportBombardier CL 600 2C10 · Chicago OHare, ILthe tug driver's inability to maintain visual contact with the wing walkers and lack of situational awareness during pushback.NTSB DCA19CA208Accident · Serious injuriesData collectionFinal reportMcdonnell Douglas MD88 · Chicago, ILan encounter with convective turbulence during descent.NTSB GAA19CA558Accident · No injuriesData collectionFinal reportCessna 172 · Chicago, ILThe pilot's improper landing flare, which resulted in a hard, porpoised landing.NTSB GAA19CA481Accident · No injuriesData collectionFinal reportRobinson R66 · Vandalia, ILThe pilot's failure to maintain clearance from power lines during an agricultural application flight.NTSB CEN19LA251Accident · No injuriesClass 3 · LimitedFinal reportRyan Navion · Chicago, ILThe failure of the left main landing gear upper side brace assembly during landing due to reverse bending fatigue as a result of the incomplete penetration of the circumferential weld during initial production of the component.NTSB CEN19LA220Accident · No injuriesClass 3 · LimitedFinal reportIcon A5 · Wheeling, ILThe pilot’s decision to operate the engine above its maximum continuous speed for most of the flight, which led to fuel exhaustion and a subsequent total loss of engine power.NTSB CEN19LA216Accident · Minor injuriesClass 3 · LimitedFinal reportRutan Varieze · Kaneville, ILThe pilot's failure to use carburetor heat while operating at low power settings in conditions conducive to the development of carburetor ice, and the subsequent total loss of engine power due to carburetor icing.NTSB CEN19FA210Accident · 1 fatalClass 2 · FieldFinal reportBeech A36 · Chebanse, ILA total loss of engine power due to fuel starvation.NTSB GAA19CA298Accident · No injuriesData collectionFinal reportPiper PA18 · Sparta, ILThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground-loop.NTSB GAA19CA288Accident · No injuriesData collectionFinal reportLuscombe 8 · Carbondale, ILThe pilot's inadvertent left heel brake application during the landing roll, which resulted in a noseover.NTSB CEN19LA152Accident · Minor injuriesClass 3 · LimitedFinal reportRand Robinson KR2 · Poplar Grove, ILThe loss of engine power due to vapor lock of the throttle body injection system.NTSB GAA19CA279Accident · No injuriesData collectionFinal reportGuimbal Cabri · St. Louis, ILThe flight instructor's improper emergency procedure instruction to the student pilot, which resulted in the student improperly using the throttle to correct the loss of yaw control, which resulted in ground impact and a dynamic rollover.NTSB GAA19CA278Accident · Minor injuriesData collectionFinal reportBell 206 · Pittsfield, ILThe pilot's failure to maintain clearance from rising terrain during agricultural application operations.NTSB CEN19LA142Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA44 · Centralia, ILThe failure of the nose landing gear to extend for reasons that could not be determined based on the available information.NTSB GAA19CA232Accident · No injuriesData collectionFinal reportPavel Vagner TANGO2 · Cobden, ILThe pilot's failure to maintain the proper airspeed during the approach, which resulted in a hard landing.NTSB CEN19LA123Accident · Serious injuriesClass 3 · LimitedFinal reportRobinson R66 · St Jacob, ILThe pilot's in-flight collision with an unmarked wire during an aerial application flight; the wire lacked contrast with the surrounding environment.NTSB CEN19LA126Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Dwight, ILA partial loss of engine power due to a restriction in fuel flow for undetermined reasons.NTSB CEN19LA098Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA32R · Waterloo, ILThe loss of engine power due to a connecting rod failure for reasons that could not be determined due to secondary mechanical damage, which resulted in a subsequent forced landing.NTSB GAA19CA149Accident · No injuriesData collectionFinal reportZenair Zenith Stol CH 701 · Springfield, ILThe pilot's improper crosswind correction during taxi operations in gusting crosswind conditions.NTSB GAA19CA145Accident · No injuriesData collectionFinal reportPiper PA32 · Lacon, ILThe pilot's failure to maintain directional control during landing with gusting crosswind conditions, which resulted in a subsequent impact with a snowbank.NTSB DCA19CA038Accident · Serious injuriesClass 4 · Data collectionFinal reportBoeing 737 · Chicago, ILan object which fell from an overhead bin struck a flight attendant resulting in a serious injury.NTSB GAA18CA531Accident · No injuriesData collectionFinal reportPiper PA44 · Centralia, ILThe pilot receiving instruction's failure to extend the landing gear and the flight instructor's failure to verify that the landing gear was extended before landing. Contributing to the accident was the flight instructor’s delayed remedial action and…NTSB CEN18LA328Accident · Serious injuriesLimited investigationFinal reportPiper PA32R · South Beloit, ILThe pilot’s failure to maintain airspeed after being startled and distracted when the engine cowling opened during takeoff, which led to a subsequent impact with terrain.NTSB CEN18LA299Accident · Serious injuriesLimited investigationFinal reportPiper PA28 · Columbia, ILThe airplane's inability to climb due to reduced engine power as a result of insufficient compression in all cylinders and fouled spark plugs in the No. 2 cylinder while operating near its maximum gross weight.NTSB GAA18CA588Accident · No injuriesData collectionFinal reportCessna 172 · Chicago, ILThe student pilot's failure to maintain clearance from a truck while taxiing.