NTSB investigations, IL

127 cases where the first occurrence was “Airframe/component/system failure/malfunction”.

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'
    AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 130)
  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.

NTSB CHI93LA353Accident · No injuriesLimited investigationFinal reportBurkhart Grob G-103 Twin Astir · New Douglas, ILFailure of the glider tow attachment. Factors related to the accident were the improper emergency procedure by the student, and the flight instructor's delayed remedial action..Sep 4, 1993 · N153SS · Substantial damageNTSB CHI93LA334Accident · Minor injuriesLimited investigationFinal reportBurkhart Grob G103 · Hinckley, ILthe failure of the cockpit canopy.Aug 22, 1993 · N422BG · Substantial damageNTSB CHI93FA329Accident · 2 fatalField investigationFinal reportCessna 310N · Rockford, ILan arcing electrical relay (solenoid) and subsequent overheating/fire of the starter wiring and adjacent fuel lines.Aug 20, 1993 · N5005Q · DestroyedNTSB CHI93IA312Incident · No injuriesIncident investigationFinal reportBritish Aerospace 146-300A · Chicago, ILwas a crack in the fuel system fuel flow distribution manifold which resulted from an inadequate design by the manufacturer.Jul 21, 1993 · N611AW · Minor damageNTSB CHI93FA129Accident · 1 fatalField investigationFinal reportAerospatiale ATR-42-300 · Chicago, ILthe unqualified baggage handler's attempting to load an unfamiliar airplane and inadequate training by the airline which employed the baggage handler.Apr 5, 1993 · N422MQ · Minor damageNTSB CHI93IA069Incident · No injuriesIncident investigationFinal reportde Havilland DHC-8-311 · Savoy, ILThe total failure of the inboard right main landing gear wheel axle during the initial climb.Jan 9, 1993 · N433AW · Minor damageNTSB CHI92LA281Accident · No injuriesLimited investigationFinal reportCessna 172RG · Wheeling, ILMain landing gear collapse as a result of the failure of a landing gear hydraulic pump seal.Sep 5, 1992 · N9578B · Substantial damageNTSB CHI92IA260Incident · No injuriesIncident investigationFinal reportDouglas DC-8-61 · Morton Grove, ILFailure of the right main landing gear door actuator.Aug 28, 1992 · N845AX · Minor damageNTSB CHI92LA160Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-300 · Round Lake, ILThe pilot-in-command's failure to follow emergency procedures, and the fire in the electrical system for reasons undetermined.Jun 1, 1992 · N812PC · DestroyedNTSB CHI92LA118Accident · Minor injuriesLimited investigationFinal reportCessna TR182 · Joliet, ILThe pilot-in-command's failure to follow emergency procedures, and the failure of the electrical system. Factors contributing to the accident were electrical arcing, and the lack of total experience in the type of aircraft by the pilot-in-command.Mar 28, 1992 · N4822R · DestroyedNTSB CHI92IA101Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-10-10 · Chicago, ILContaminated anti-skid braking system electrical connectors which resulted in a partial loss of the anti-skid system and locking up of the brakes on the left main gear.Mar 3, 1992 · N1820U · Minor damageNTSB CHI91DEV05Accident · No injuriesFinal reportUllman Vari Viggen · Greenville, ILImproper maintenance installation of the propeller.Sep 29, 1991 · N22VV · Substantial damageNTSB CHI91LA303Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Newark, ILA sheared oleo piston retaining pin which allowed the wheel to fall out.Sep 25, 1991 · N5164T · Substantial damageNTSB CHI91LA278Accident · No injuriesLimited investigationFinal reportCessna 310J · Sugar Grove, ILThe buckled nose landing gear retraction/extension gear drive tube. A factor in the accident was the pilot in command not having the landing gear inspected at the interval recommended by the manufacturer.Sep 20, 1991 · N300RA · Substantial damageNTSB CHI91FA152Accident · No injuriesField investigationFinal reportShort Brothers SD3-60 · Chicago, ILThe failure of the nose wheel steering hydraulic line during after landing ground operations. A related factor is the manufacturer's inadequate inspection and/or replacement standards.May 11, 1991 · N715NC · Substantial damageNTSB CHI91IA120Incident · No injuriesIncident investigationFinal reportCessna 172RG · West Chicago, ILFailure of the splined shaft on the right main landing gear pivot assembly. A factor related to the incident was inadequate design of the landing gear pivot assembly.Apr 2, 1991 · N9592B · Minor damageNTSB CHI91LA046Accident · Minor injuriesLimited investigationFinal reportLuscombe 8E · Mundelein, ILLanding gear tire failure and directional control not maintained by the pic/cfi.Dec 13, 1990 · N71207 · Substantial damageNTSB CHI90LA276Accident · No injuriesLimited investigationFinal reportMooney M20E · Morrison, ILImproper maintenance of the propeller blade by unknown persons and the subsequent failure of the blade in fatigue during cruise flight. A factor was: unsuitable terrain.Sep 27, 1990 · N7197U · Substantial damageNTSB CHI90LA017Accident · No injuriesLimited investigationFinal reportDe Havilland DH82A · Mascoutah, ILAn undetermined powerplant problem, which resulted in a severe vibration. The soft/uneven terrain was considered to be a contributing factor.Oct 22, 1989 · N100MH · Substantial damageNTSB CHI89FA183Accident · Minor injuriesField investigationFinal reportMcDonnell Douglas MD-80 · Chicago, ILA loss of hydraulic system pressure due to the operator's failure to replace a system component that had a known history of failures, and the pilot's improper use powerplant controls resulting in a degradation of rudder effectiveness. A contributing factor…Sep 12, 1989 · N244AA · Substantial damageNTSB CHI89LA182Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Newark, ILInadequate supervision by the flight instructor (CFI) and his delay in aborting the takeoff. Factors related to the accident were: malfunction of the flap system, which resulted in an improper flap setting for takeoff, and the soft runway condition.Sep 11, 1989 · N4841P · Substantial damageNTSB 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.May 19, 1989 · N232AM · Substantial damageNTSB 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.Jan 20, 1989 · N242US · Substantial damageNTSB 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.…Oct 24, 1988 · N277US · Minor damageNTSB 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.Sep 20, 1988 · N50702 · DestroyedNTSB 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…Sep 4, 1988 · N3613F · Substantial damageNTSB CHI88FA223Accident · Minor injuriesField investigationFinal reportBoeing 727-31 · Chicago, ILImproper procedural checklist in which a critical step was not listed.Aug 27, 1988 · N852TW · Substantial damageNTSB CHI88IA200Incident · No injuriesIncident investigationFinal reportAerospatiale ATR-42-300 · Chicago, ILAug 12, 1988 · N426MQ · No damageNTSB CHI88LA170Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Chicago, ILDuring climbout after takeoff, the pilot experienced an engine fire and diverted to Chicago's midway airport for an emergency landing. The pilot executed emergency procedures, shut down the engine, the fuel supply, and all electrical load. When the pilot knew…Jul 20, 1988 · N8069S · Substantial damageNTSB CHI88IA141Incident · No injuriesIncident investigationFinal reportSwearingen SA226-TC · Chicago, ILFailure of the front motor bearing in the sas servo motor assembly, and the resultant 'jamming' of the elevator control cables. The pilot aborted the takeoff as a result of the vibration in the yoke.Jun 22, 1988 · N329BA · No damageNTSB CHI88FA110Accident · No injuriesField investigationFinal reportBoeing 747-136 · Chicago, ILFailure of the number three flap track due to stress corrosion cracking. Factors contributing to this failure are insufficient design of the member and inadequate inspection and maintenance procedures to detect cracks before they propagate to a critical…May 9, 1988 · GAWND · Substantial damageNTSB CHI88LA076Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Dixon, ILMar 10, 1988 · N4072D · Substantial damageNTSB CHI88LA053Accident · No injuriesLimited investigationFinal reportCessna T310R · Urbana, ILAfter the aircraft experienced a complete electrical failure the gear was extended manually and a precautionary landing was made. On roll out the landing gear collapsed. Subsequent investigation revealed that 10 turns remained on the manual gear extension…Jan 26, 1988 · N5120J · Substantial damageNTSB CHI88IA011Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-10-10 · Chicago, ILA wing panel separated from the airplane while in cruise flight. Crew declared an emergency and landed without further incident. Examination revealed that maintenance personnel did not fasten 4 of the 5 rod end assembilies used to secure the panel to the top…Oct 28, 1987 · N1813U · Minor damageNTSB CHI87IA201Incident · Minor injuriesIncident investigationFinal reportMcdonnell Douglas DC-8-71 · Chicago, ILSmoke detected in the cabin resulted in an evacuation of the aircraft just after being pushed back from the jet-way. Subsequent investigation established that a malfunctioning pack valve had caused the air-conditioning system to overheat causing the smoke.…Sep 3, 1987 · N8078U · No damageNTSB CHI87NA194Incident · Minor injuriesFinal reportBoeing 767-231ER · Belleville, ILAug 22, 1987 · N609TW · Minor damageNTSB CHI87DEV03Accident · No injuriesFinal reportPiper PA-22 · Roanoke, ILAfter developing an oil leak the pilot elected to make a precautionary landing. The aircraft encountered rough terrain on touchdown and collapsed the nose gear and nosed over. The pilot and one passenger reported no injuries, however the aircraft was…Aug 2, 1987 · N7958A · Substantial damageNTSB CHI87FA176Accident · 1 fatalField investigationFinal reportCessna 402B · Chicago, ILFailure of maintenance personnel to perform proper installation of the left throttle linkage.Jul 21, 1987 · N3742C · DestroyedNTSB CHI87IA148Incident · No injuriesIncident investigationFinal reportDornier DO-228-201 · Springfield, ILThe flightcrew experienced inflight opening of the aft baggage door and inflight separation of the cabin stairway door. The copilot checked the doors on three occasions before takeoff because the door warning light was illuminated. The captain initiated the…Jun 13, 1987 · N88FB · Minor damageNTSB CHI87MA101Accident · Serious injuriesMajor investigationFinal reportMcdonnell Douglas DC-10-10 · Chicago, ILAfter arriving at the gate in Chicago, fumes & smoke were noted in zone c of the cabin, then the cabin lgtg went out & the emerg lgtg came on. Maint psnl fnd the #2 APU had an auto-shutdown due to a malfunction. The APU was placarded as inop & the acft was…Mar 25, 1987 · N128AA · No damageNTSB CHI87FA069Accident · 1 fatalField investigationFinal reportCessna 210N · Bedford Park, ILJust bfr tkof fm rwy 22L on a ngt IFR flt, the plt was clrd to clb & maint 2000' & to contact chicago dep ctl (TRACON). About 1 min later, he called TRACON & rprtd he was clbg thru 900' for 2000'. This call was in a normal tone of voice & was the last…Jan 30, 1987 · N4968C · DestroyedNTSB CHI87LA020Accident · No injuriesLimited investigationFinal reportCessna 310R · Belvidere, ILDuring takeoff roll, the acft door popped open at a point too late to abort the takeoff. The PIC tried to hold the door closed while the second plt flew the acft around the traffic pattern. Just prior to touchdown, the door opened wider and the PIC reached to…Nov 8, 1986 · N6096C · Substantial damageNTSB CHI86LA185Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Morris, ILDuring cruise flight, the engine stopped and the pilot attempted to glide to an airport, but was forced to land in a cornfield, aprx one mile short of the airfield. A post-crash inspection revealed the flange of the left intermediate exhaust pipe (pn…Jul 29, 1986 · N81753 · Substantial damageNTSB CHI86FEE05Accident · Serious injuriesFinal reportEipper Mxii · Aurora, ILDuring cruise flight the ultralight experienced an inadvertent deployment of the drag chute accompanied by a failure of the drag chute to inflate. This resulted in an uncontrolled descent and subsequent impact with the terrain.Jul 4, 1986 · N4976X · Substantial damageNTSB CHI86FEV02Accident · Serious injuriesFinal reportJerry Cox Goldwing · Mattoon, ILThe acft was circling a racetrack at a relatively low alt, described as between 800-1500 ft AGL, with the eng throttled back. During a subsequent steep bank to the left while accelerating the left wing failed and the acft crashed into the trees.May 24, 1986 · N85JC · Substantial damageNTSB CHI86IA083Incident · Minor injuriesIncident investigationFinal reportBoeing 727-22 · Chicago, ILThe flight crew was unable to lower the nose wheel landing gear through either the normal or backup systems. The airplane subsquently made a nose gear up landing resulting in minor damage to the airplane. An examination of the nose gear drag brace assembly…Feb 6, 1986 · N7059U · Minor damageNTSB CHI86LA048Accident · No injuriesLimited investigationFinal reportCessna 152 II · Aurora, ILDuring initial climbout the student plt saw his IAS drop 10 KTS. He aborted the takeoff and land hard on the nose gear. Gear collapsed.Dec 14, 1985 · N4655P · Substantial damageNTSB CHI86IA034Incident · No injuriesIncident investigationFinal reportBoeing 747-251F · Glen Ellyn, ILDuring climb a bang was heard and the aircraft shuddered. The crew stated that the number three engine oil pressure and oil quantity indicated low. The fire warning light and bell activvated. The engine was shut down and the aircraft landed without further…Nov 28, 1985 · N619US · Minor damageNTSB CHI86LA032Accident · Minor injuriesLimited investigationFinal reportRockwell 112 · Pekin, ILFollowing a top overhaul of the engine a test flight was planned to break in the cylinders and rings. Prior to this flight the engine was operated for a short period on the ground then shut down and checked for oil leaks with negative results. The takeoff and…Nov 21, 1985 · N10285 · Substantial damageNTSB CHI85IA369Incident · No injuriesIncident investigationFinal reportFokker F27-500 · Chicago, ILAt about the time full power was obtained the heard a loud bang followed by a fire warning for the left engine. The takeoff was aborted and the crew shut down the engine. The passengers were deplaned on the taxiway after it was determined the fire was out &…Sep 9, 1985 · N242MA · Minor damage