Fatal NTSB investigations, IL
13 cases where the first occurrence was “Airframe/component/system failure/malfunction”.
Cases per year
| 1983 | 3 |
|---|---|
| 1987 | 2 |
| 1988 | 1 |
| 1993 | 2 |
| 1994 | 1 |
| 1996 | 1 |
| 2001 | 1 |
| 2005 | 1 |
| 2007 | 1 |
Where
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.
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
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 CHI07LA080Accident · 1 fatalLimited investigationFinal reportWood Quickie Q-2 · Edwardsville, ILThe loss of engine power during cruise due to loose cylinder head bolts/loose cylinders.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB CHI93FA329Accident · 2 fatalField investigationFinal reportCessna 310N · Rockford, ILan arcing electrical relay (solenoid) and subsequent overheating/fire of the starter wiring and adjacent fuel lines.NTSB 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.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 CHI87FA176Accident · 1 fatalField investigationFinal reportCessna 402B · Chicago, ILFailure of maintenance personnel to perform proper installation of the left throttle linkage.NTSB 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…NTSB 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…NTSB 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…NTSB 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…