Fatal NTSB investigations, 2001, IL

180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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 per year

19642026
Fatal NTSB investigations, 2001, IL per year, 1964–2026: 626 cases
196413
196511
196621
196712
196815
196910
197012
197114
197219
197320
197416
197526
197627
197720
197819
197925
198014
198121
19828
198316
19847
198512
198612
198715
198811
198912
199010
19917
199211
19938
199410
19959
199614
19979
19987
19997
20006
20019
20024
20037
20045
20054
20066
20078
20083
20095
20108
20117
20126
20132
20146
20155
20167
20181
20191
20209
20224
20232
20241
20256
20264

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 year(c.\"eventDate\") = 2001
    AND c.\"eventStateOrRegion\" = 'IL' AND c.\"eventCountry\" = 'USA'
    AND c.\"highestInjuryLevel\" = 'Fatal'
  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 CHI02FAMS1Accident · 4 fatalMissing aircraftFinal reportCessna R182 · Lake Michigan, ILThe uncontrolled descent for undetermined reasons.Dec 10, 2001 · N2359C · DestroyedNTSB CHI02LA007Accident · 1 fatalLimited investigationFinal reportWoodrow Stolp-Adams Starduster SA-100 · Millstadt, ILThe pilot not maintaining altitude/clearance from the tree line. Factors to the accident were the pilot attempting the low altitude flight/maneuver and the presence of the tree line.Oct 21, 2001 · N64HW · DestroyedNTSB CHI02FA006Accident · 1 fatalField investigationFinal reportCessna 150L · Union, ILThe pilot not maintaining appropriate airspeed which resulted in an inadvertent stall.Oct 20, 2001 · N6609G · DestroyedNTSB CHI01FA298Accident · 1 fatalField investigationFinal reportSpears RV-6 · Grayslake, ILThe pilot inadvertently stalled the airplane. A factor was the impairment due to marihuana.Aug 31, 2001 · N910RS · DestroyedNTSB CHI01FA234Accident · 3 fatalField investigationFinal reportCessna 177 · Benton, ILThe pilot's failure to maintain adequate airspeed, resulting in a stall.Jul 22, 2001 · N235LA · DestroyedNTSB CHI01FA233Accident · 2 fatalField investigationFinal reportPiper PA-32-260 · Chenoa, ILThe inadvertent stall the pilot encountered during his turn with an in-flight loss of engine power due to fuel starvation on initial climbout and the improper in-flight decision he made to continue the turn. Factors were the fuel starvation and the incorrect…Jul 21, 2001 · N27AP · Substantial damageNTSB 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 CHI01LA149Accident · 1 fatalLimited investigationFinal reportGeertz Zenith CH 200 · Kankakee, ILThe loss of control on initial climbout for undetermined reasons.May 27, 2001 · N77VZ · DestroyedNTSB CHI01FA093Accident · 2 fatalField investigationFinal reportCessna 172H · Centralia, ILThe student pilot allowed the airspeed to get too low and inadvertently stalled the airplane, and the CFI delayed in taking remedial action.Feb 21, 2001 · N733SS · Destroyed