Fatal NTSB investigations, IL

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

Cases per year

19832026
Fatal NTSB investigations, IL per year, 1983–2026: 13 cases
19833
19872
19881
19932
19941
19961
20011
20051
20071

Latest cases

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.\"highestInjuryLevel\" = 'Fatal'
    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 CHI07LA080Accident · 1 fatalLimited investigationFinal reportWood Quickie Q-2 · Edwardsville, ILThe loss of engine power during cruise due to loose cylinder head bolts/loose cylinders.Mar 5, 2007 · N89WW · Substantial damageNTSB CHI05LA243Accident · 1 fatalLimited investigationFinal reportAllensworth Baby Belle · El Dara, ILThe manufacturer failed to specify a relief radius on the tail rotor spindle drawings, which resulted in the spindle being manufactured with an inadequate relief radius at the point of fatigue failure.Aug 28, 2005 · N9094P · DestroyedNTSB 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.Jul 21, 2001 · N303SM · DestroyedNTSB CHI96FA264Accident · 1 fatalField investigationFinal reportHoffman, Wolf, Flugzeugbau H-36 · Waukegan, ILfailure of the pilot to maintain adequate airspeed, while maneuvering to land, which resulted in an inadvertent stalled and collision with the terrain. A factor relating to the accident was: the loose engine cowling.Jul 31, 1996 · N86PS · DestroyedNTSB CHI94FA140Accident · 1 fatalField investigationFinal reportVavra, Martin A. Rebel 300 · Wonderlake, ILFatigue and catastrophic failure of the main wing spar resulting from the designer's excessive, unverified estimate of the strength of the spar cap material and the manufacturer's failure to attain the specified strength during the production process.Apr 23, 1994 · N12MV · DestroyedNTSB 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 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 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 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 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 DCA84AA002Accident · 10 fatalFinal reportHawker Siddeley HS-748-2A · Pinckneyville, ILAbout 1.5 min after departing springfield, IL, the fltcrew reported a slight electrical problem, but they continued on course. About 33 min later & a few min before the acft should have reached its destination, the acft crashed. Impact occurred while the acft…Oct 12, 1983 · N748LL · DestroyedNTSB CHI83FU009Accident · 1 fatalFinal reportWeedhopper B · St. Joseph, ILThe ultralight vehicle collided with the ground after the left wing folded up at about 1000 ft AGL. Witnesses said the ultralight was traveling east when the wing collapsed or folded back. Reportedly, it pitched up & the right wing tip went up. The vehicle…Aug 21, 1983 · UNREG · DestroyedNTSB CHI83FA148Accident · 1 fatalField investigationFinal reportPiper PA-32R-300 · Rochester, ILThe acft experienced an in-flt break-up during descent. The pilot had reported on the radio to Kansas city ARTCC that hewas having severe chest pains and shortness of breath. Radar contact with the plane was lost at 1425 CST. The pilot had reported he was…Mar 21, 1983 · N1057Q · Destroyed