NTSB investigations, 1964, IL

180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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

19622026
NTSB investigations, 1964, IL per year, 1962–2026: 5,040 cases
19622
19633
1964182
1965166
1966229
1967239
1968199
1969168
1970175
1971158
1972144
1973146
1974143
1975152
1976129
1977139
1978171
1979133
1980121
1981121
198297
1983109
198494
198574
198670
198768
198879
198972
199062
199163
199264
199364
199462
199547
199646
199746
199837
199953
200047
200151
200243
200354
200431
200533
200635
200746
200850
200931
201042
201149
201230
201329
201431
201530
201632
201727
201827
201922
202027
202118
202230
202330
202416
202537
202615

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\") = 1964
    AND 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.

NTSB UNK65X1174Accident · No injuriesClosedAeronca 7FC · Oswego, ILDec 28, 1964 · N7573B · Substantial damageNTSB UNK65X1146Accident · Serious injuriesClosedLuscombe 11A · Hinsdale, ILDec 26, 1964 · N1633B · DestroyedNTSB UNK65X1131Accident · No injuriesClosedCessna 180 · Sherman, ILDec 25, 1964 · N9043C · Substantial damageNTSB UNK65X1118Accident · 1 fatalClosedPiper PA-24 · Bartonville, ILDec 24, 1964 · N6406P · DestroyedNTSB UNK65X1090Accident · No injuriesClosedHoward DGA-15 · West Chicago, ILDec 22, 1964 · N75599 · Substantial damageNTSB UNK65X1089Accident · No injuriesClosedBeechraft D95 · Groveland, ILDec 22, 1964 · N8613M · Substantial damageNTSB UNK65X1081Accident · No injuriesClosedPiper PA30 · Chicago, ILDec 21, 1964 · N7495Y · Substantial damageNTSB UNK65X1068Accident · No injuriesClosedPiper PA28 · Chicago, ILDec 20, 1964 · N7677W · Substantial damageNTSB UNK65X1065Accident · 2 fatalClosedCessna 140 · Oak Brook, ILDec 19, 1964 · N72353 · DestroyedNTSB CHI66D0214Accident · No injuriesClosedPiper PA-24 · Peoria, ILDec 14, 1964 · N6237P · Substantial damageNTSB UNK65X0991Accident · 1 fatalClosedCessna 190 · Bradford, ILDec 12, 1964 · N4497C · DestroyedNTSB UNK65X0967Accident · No injuriesClosedPiper PA22 · Lockport, ILDec 10, 1964 · N5526Z · Substantial damageNTSB UNK65X0893Accident · 2 fatalClosedPiper PA-30 · Chicago, ILDec 1, 1964 · N7057Y · DestroyedNTSB UNK65X0855Accident · No injuriesClosedBeechcraft 35-A33 · Fairbury, ILNov 27, 1964 · N370Z · Substantial damageNTSB UNK65X0839Accident · No injuriesClosedCessna 195-A · Fairfield, ILNov 26, 1964 · N4479C · Substantial damageNTSB UNK65X0799Accident · No injuriesClosedPiper PA28 · Dixon, ILNov 22, 1964 · N6271W · Substantial damageNTSB UNK65X0797Accident · No injuriesClosedCessna 170B · Peoria, ILNov 22, 1964 · N4316B · Substantial damageNTSB UNK65X0706Accident · Minor injuriesClosedCessna 182 · Peoria, ILNov 14, 1964 · N3516Y · Substantial damageNTSB UNK65X0636Accident · Serious injuriesClosedConvair CV-880 · Chicago, ILNov 9, 1964 · N8805 · No damageNTSB UNK65X0613Accident · Serious injuriesClosedMooney M20A · Washington, ILNov 8, 1964 · N8303E · Substantial damageNTSB UNK65X0610Accident · No injuriesClosedAero Cmdr 520 · Chicago, ILNov 8, 1964 · N4172B · Substantial damageNTSB UNK65X0504Accident · No injuriesClosedSikorsky S58C · Joliet, ILOct 31, 1964 · N867 · No damageNTSB UNK65X0407Accident · No injuriesClosedBeechcraft 35-A33 · Marseilles, ILOct 24, 1964 · N9367Y · Substantial damageNTSB UNK65X0363Accident · No injuriesClosedBeechraft 95 · Savoy, ILOct 21, 1964 · N2742Y · Substantial damageNTSB UNK65X0350Accident · No injuriesClosedPiper PA22 · Hinsdale, ILOct 20, 1964 · N5941Z · Substantial damageNTSB UNK65X0337Accident · No injuriesClosedCessna 310 · Salem, ILOct 19, 1964 · N4825B · Substantial damageNTSB UNK65X0325Accident · No injuriesClosedPiper PA24 · Naperville, ILOct 18, 1964 · N7806P · Substantial damageNTSB UNK65X0312Accident · 3 fatalClosedMooney M20C · Antioch, ILOct 17, 1964 · N6215U · DestroyedNTSB UNK65X0286Accident · No injuriesClosedPiper PA24 · Sparta, ILOct 16, 1964 · N7144P · Substantial damageNTSB UNK65X0276Accident · No injuriesClosedMooney M18C · Pekin, ILOct 14, 1964 · N327M · Substantial damageNTSB UNK65X0191Accident · No injuriesClosedPiper PA-24 · Benton, ILOct 8, 1964 · N6723P · Substantial damageNTSB UNK65X0171Accident · No injuriesClosedPiper PA12 · Urbana, ILOct 7, 1964 · N78570 · Substantial damageNTSB UNK65X0157Accident · No injuriesClosedPiper PA-22 · Hinsdale, ILOct 5, 1964 · N5828Z · 2 aircraft · Substantial damageNTSB UNK65X0135Accident · No injuriesClosedCessna 170 · Effingham, ILOct 4, 1964 · N4413V · Substantial damageNTSB UNK65X0122Accident · No injuriesClosedCessna 310R · Wheeling, ILOct 3, 1964 · N5252A · Substantial damageNTSB UNK65X0113Accident · No injuriesClosedMaule M4 · Chicago, ILOct 2, 1964 · N4716T · Substantial damageNTSB UNK64X4173Accident · No injuriesClosedLuscombe 8F · Waukegan, ILSep 27, 1964 · N1881B · Substantial damageNTSB UNK64X4148Accident · No injuriesClosedPiper PA24 · Elgin, ILSep 25, 1964 · N6831P · 2 aircraft · DestroyedNTSB UNK64X4144Accident · No injuriesClosedCessna 182 · Chicago, ILSep 25, 1964 · N5899B · Substantial damageNTSB UNK64X4115Accident · No injuriesClosedBeechcraft 95 · Wheeling, ILSep 23, 1964 · N9901R · Substantial damageNTSB UNK64X4092Accident · No injuriesClosedPiper PA22 · Taylorville, ILSep 22, 1964 · N3402A · Substantial damageNTSB UNK64X4081Accident · Serious injuriesClosedChampion 7FC · Columbia, ILSep 20, 1964 · N9043B · DestroyedNTSB UNK64X4072Accident · No injuriesClosedNavion A · Wheeling, ILSep 20, 1964 · N8585H · Substantial damageNTSB UNK64X4053Accident · No injuriesClosedBeechcraft C35 · Decatur, ILSep 19, 1964 · N642D · Substantial damageNTSB UNK64X3986Accident · Minor injuriesClosedCessna 172 · Wheeling, ILSep 14, 1964 · N7695T · Substantial damageNTSB UNK64X3972Accident · No injuriesClosedPiper PA28 · Roselle, ILSep 13, 1964 · N5085W · Substantial damageNTSB UNK64X3959Accident · No injuriesClosedCessna 195B · Richton Park, ILSep 13, 1964 · N3025B · Substantial damageNTSB UNK64X3918Accident · No injuriesClosedCessna 140 · Chicago, ILSep 11, 1964 · N89049 · Substantial damageNTSB UNK64X3835Accident · 3 fatalClosedPiper PA23 · Markham, ILSep 6, 1964 · N1252P · DestroyedNTSB UNK64X3766Accident · No injuriesClosedPiper PA24 · Hinsdale, ILSep 4, 1964 · N7767P · Substantial damage