NTSB investigations, IL
180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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 CHI89FA109Accident · No injuriesField investigationFinal reportPiper PA-28R-200 · Saint Charles, ILThe failure of the mechanic to properly inspect the alternate air door during annual inspection. This failure led to air starvation, loss of power, and a forced landing by the pilot onto rough terrain.NTSB CHI89DEV06Accident · No injuriesFinal reportHughes 269C · Millersville, ILLoss of rotor RPM for an undetermined reason during a turn to reverse direction while applying agricultural chemicals.NTSB CHI89LA098Accident · No injuriesLimited investigationFinal reportCessna P210N · Wheeling, ILFailure of the pilot to extend the landing gear, which resulted in a wheels-up landing.NTSB CHI89LA096Accident · Minor injuriesLimited investigationFinal reportPiper PA28R-180 · Frankfort, ILPilot's failure to maintain directional control while attempting to land in cross/tailwind conditions.NTSB CHI89MA095Accident · 3 fatalMajor investigationFinal reportDouglas DC3C-S13CG · Waterman, ILThe pilot-in-command (PIC) failed to provide adequate supervision while training the copilot and allowed the aircraft to enter a stall/spin, then did not provide adequate remedial action to properly recover from the spin. Factors related to the accident were:…NTSB CHI89DEE03Accident · 2 fatalFinal reportRuschke Starduster TOO · Mc Henry, ILThe flying pilots failure to maintain airspeed during an ostentatious display resulting in an inadvertent stall and subsequent collision with terrain.NTSB CHI89DCA01Accident · Minor injuriesFinal reportZengel RV-4 · Columbia, ILThe improper routing of engine fuel lines resulting in over temperature of the lines which resulted in the fuel flow to carburetor to fluctuate and cause over rich condition and loss of engine power.NTSB CHI89FA092Accident · No injuriesField investigationFinal reportSwearingen SA226TC · Marion, ILFailure of the pilot to maintain directional control of the aircraft. Contributing to the accident was lack of crew coordination and inappropriate remedial action on the part of the aircrew, and improper maintenance modification by the operator.NTSB CHI89IA084Incident · No injuriesIncident investigationFinal reportFokker F-27 MK500 · Moline, ILMaterial failure of the landing gear retraction and extension assembly. Inadequate maintenance and troubleshooting procedures in company directives were factors in this incident.NTSB CHI89FA078Accident · Minor injuriesField investigationFinal reportCessna 208A · Mt. Zion, ILThe pilot's intentional flight into known adverse weather. Contributing factors were the pilot's poor evaluation of the weather information given him by the air traffic controllers.NTSB CHI89LA081Accident · No injuriesLimited investigationFinal reportCessna 172D · Ottawa, ILStudent pilot's continuing an approach to landing beyond the point where she could bring the aircraft to a controlled stop on the remaining runway surface.NTSB CHI89LA077Accident · No injuriesLimited investigationFinal reportCessna 152 · Cahokia, ILInadequate compensation for wind conditions by the student pilot and his failure to maintain directional control. The crosswind and the student's lack of total experience were contributing factors.NTSB CHI89DEE02Accident · Minor injuriesFinal reportAeronca 7AC · Marseilles, ILPic's overconfidence in the accident aircraft's climb performance as he attempted to take off up hill and over wires.NTSB BFO89FA027Accident · 1 fatalField investigationFinal reportCessna 152 · West Chicago, ILImproper instruction by the student's flight instructor regarding the execution of s-turns on final approach to increase spacing and the retraction of flaps fully when executing a go-around and the failure of the student pilot to maintain adequate flying…NTSB CHI89LA070Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Bunker Hill, ILImproper preflight by the student pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel. A factor related to the accident was: soft terrain.NTSB CHI89FA069Accident · 2 fatalField investigationFinal reportCessna 150M · Kankakee, ILFailure of the instructor pilot (CFI) to maintain control of the aircraft and his failure to maintain sufficient altitude above the ground.NTSB CHI89LA068Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Chicago, ILThe pilot's failure to compensate for the crosswind condition which existed during the landing. Contributing to the accident was the gusty, crosswind which existed and the failure of the aircraft manufacturer to provide crosswind performance data for the…NTSB CHI89LA065Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Monee, ILInadequate maintenance/inspection of the aircraft after metal fragments were found in the oil, and worn cam lobes/followers/piston pin plugs, which resulted in oil contamination, restriction (blockage) in the oil system, oil starvation, and subsequent engine…NTSB CHI89FA062Accident · Serious injuriesField investigationFinal reportHughes 269C · De Kalb, ILFatigue failure of the number four connecting rod which resulted in an engine failure. Factors in the accident were the broken ring in the number one piston and a deteriorated center main bearing.NTSB CHI89FA058Accident · No injuriesField investigationFinal reportCessna 177RG · Rockford, ILThe inadequate servicing of the hydraulic fluid by maintenance personnel and the pilot's failure to extend the landing gear manually.NTSB CHI89LA060Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · West Chicago, ILImproper flare by the pilot. The crosswind (quartering headwind) was considered to be a factor.NTSB CHI89LA056Accident · No injuriesLimited investigationFinal reportCessna TR182 II · Sandwich, ILThe pilot's poor handling of the aircraft, improper flare and inadequate recovery from a bounced landing.NTSB CHI89IA054Incident · No injuriesIncident investigationFinal reportShort Brothers SD360 · Chicago, ILThe PIC followed a clearance intended for another airplane.NTSB CHI89DEV05Accident · No injuriesFinal reportCessna 182A · Sparta, ILPoor and improper maintenance which resulted in the carburetor venturi being blocked by the duct tape. Contributing to the accident was the soft terrain on which the forced landing was made.NTSB CHI89LA052Accident · No injuriesLimited investigationFinal reportCessna 172M · Quincy, ILThe pilot's failure to achieve a proper touchdown point and to maintain adequate visual lookout during the landing.NTSB CHI89GA048Accident · 2 fatalFinal reportPiper PA-28-180 · Chicago, ILInadequate preflight of the aircraft by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel. Factors related to the accident were: high obstructions and retaining wall in the emergency landing area.NTSB CHI89MA046Accident · No injuriesMajor investigationFinal reportBoeing 737-201 · Chicago, ILPrevious damage to the aft cone (engine mounting) bolt, which resulted in mismatched surfaces between the bolt and isolation mount, loss of torque during cyclic loading of the mounting bolt, and subsequent fatigue failure of the bolt.NTSB CHI89FA039Accident · 2 fatalField investigationFinal reportCessna 210D · Alvin, ILContinued flight by the non-instrument rated pilot into instrument meteorological conditions (IMC), and his failure to maintain sufficient altitude. Factors related to the accident were: darkness, adverse weather conditions, the pilot's lack of instrument…NTSB CHI89FA038Accident · 2 fatalField investigationFinal reportCessna T210N · Springfield, ILThe pilot's improper IFR procedure during an ILS approach in below minimum conditions, and the pilot's failure to proceed to an alternate destination. Contributing factors were the adverse weather conditions.NTSB CHI89LA042Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Plainfield, ILNTSB CHI89DEE01Accident · No injuriesFinal reportCessna 210L · Bannock Burn, ILFuel starvation caused by ice blocked fuel lines.NTSB CHI89LA032Accident · No injuriesLimited investigationFinal reportCessna 152II · Lake In The Hls, ILThe pilot in command failed to maintain directional control of the aircraft while correcting for a crosswind. Contributing to the cause is the pilot's lack of experience.NTSB CHI89LA031Accident · No injuriesLimited investigationFinal reportCessna 150 · Varna, ILThe student pilot was cruising at 2000' MSL on a solo flight, when the engine lost power. Emergency procedures were initiated and a forced landing was made in an open field. During the landing roll, the aircraft struck a dirt bank and was damaged. A…NTSB CHI89FA030Accident · 2 fatalField investigationFinal reportMooney M20J · Vermillion, ILNTSB CHI89DEV04Accident · 1 fatalFinal reportTesori Regionne 2002 · Urbana, ILThe plt transmitted on an advisory frequency 'clear the area I have engine trouble'. While turning from downwind to the base leg of his emergency approach to the airport, witnesses observed the airplane in a steep right bank when it suddenly banked left and…NTSB CHI89LA029Accident · Minor injuriesLimited investigationFinal reportMcdonnell Douglas 269C · Frankfort, ILThe helicopter experienced a tree strike with the main rotor blades and then rolled over when it struck the ground during a precautionary landing attempt. The helicopter had been conducting contract power line patrol when the PIC noted an apparent partial…NTSB CHI89FA026Accident · 1 fatalField investigationFinal reportMitsubishi MU-2B-60 · Chicago, ILThe first takeoff was aborted due to a perceived engine problem. Six minutes later on second takeoff, the aircraft climbed to 50 feet, drifted to the right, rolled right and impacted in the infield. This was a single pilot operation in a complex aircraft.…NTSB CHI89DEV03Accident · No injuriesFinal reportRyan Navion · Lane, ILAirplane landed in a plowed field after losing power during initial climb. The flight purpose was to accomplish a biennial flight review. The landing gear failed after digging into the soft dirt of the plowed field. During the investigation the acft owner…NTSB CHI89DEV02Accident · 1 fatalFinal reportAir Command 503 · Sullivan, ILThe pilot failed to maintain control of the aircraft.NTSB CHI89DEV01Accident · No injuriesFinal reportCessna 152 · Vandalia, ILThe eng began running rough aprx 5 min after the plt took off from an en route arpt drg a night, x-country training flt. He reversed course back toward the departure arpt with the eng providing partial power. While maneuvering to land on rwy 18, the eng…NTSB CHI89LA021Accident · No injuriesLimited investigationFinal reportCessna 170A · Springfield, ILThe conventional landing gear equipped airplane was substantially damaged when it nosed down after ground looping during a landing attempt. VMC prevailed and a 90 degree right crosswind, blowing at 12 knots, was present. The pilot relates in his statement…NTSB CHI89IA018Incident · No injuriesIncident investigationFinal reportBoeing B-727-200A · Chicago, ILOn departure from Chicago, Illinois, o'hare airport the aircraft experienced a loss of the inboard left main wheel. The aircraft diverted to detroit, Michigan, where it was landed with no damage to the aircraft and no injuries to the crew or passengers.…NTSB CHI89LA019Accident · No injuriesLimited investigationFinal reportCessna 182 · Pekin, ILThe pilot reported that he attempted to make a 'wheels' landing in the Cessna 182 (tricycle gear), and made a hard landing on the turf runway. The pilot aborted the landing, requested emergency equipment and circled the airport until the emergency equipment…NTSB CHI89LA010Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Fairview Hts., ILFuel exhaustion due inaccurate fuel consumption calculations.NTSB CHI89LA012Accident · No injuriesLimited investigationFinal reportCessna 182 · Sparta, ILNTSB CHI89LA007Accident · No injuriesLimited investigationFinal reportCessna 172 · Carbondale, ILThe student pilot, while on the takeoff roll on his first solo flight, experienced a loss of directional control which he failed to correct. The aircraft swerved to the left and departed the runway, striking a VASI installation before coming to a stop. The…NTSB CHI89LA006Accident · No injuriesLimited investigationFinal reportBeech 55B · Quincy, ILThe pilot in command's failure to maintain control of the aircraft and to take appropriate action to correct the porpoise.NTSB CHI89FA005Accident · Minor injuriesField investigationFinal reportPiper PA-28 · Schaumburg, ILEngine failure due to oil starvation and the pilot's misjudged emergency landing, during which the aircraft collided with trees and a swimming pool, before coming to rest on the ground and a chain link fence.NTSB CHI88FA240Accident · 1 fatalField investigationFinal reportBellanca 8KCAB · Oswego, ILInadequate design inthe manufacture of the pilot's seat which failed during intentional aerobatic maneuvers for which the aircraft including the seat were intended.NTSB CHI88LA236Accident · Serious injuriesLimited investigationFinal reportSchweizer 2-33A · Hinckley, ILDuring the initial climbout on the dual instructional flight, as the glider was towed through approximately 50-100' AGL, the tow rope failed. The instructor pilot executed a hard forced landing at the edge of a cornfield located to the right side of the…