NTSB investigations, 1979, 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, 1979, 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\") = 1979
    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 CHI80FA019Accident · 2 fatalClosedPiper PA-28R · Kankakee, ILDec 28, 1979 · N7644J · DestroyedNTSB CHI80FA016Accident · 2 fatalClosedCessna 172K · Edwardsville, ILDec 21, 1979 · N736UL · DestroyedNTSB CHI80DA018Accident · 2 fatalClosedBeech B58 · Taylorville, ILDec 21, 1979 · N2058X · DestroyedNTSB CHI80DEE12Accident · No injuriesClosedCessna 172N · Schaumburg, ILDec 14, 1979 · N4870D · Substantial damageNTSB CHI80FEE11Accident · No injuriesClosedPiper PA-30 · Chicago, ILDec 6, 1979 · N7119Y · Substantial damageNTSB CHI80FEV11Accident · No injuriesClosedCessna 150H · Springfield, ILDec 3, 1979 · N22931 · Substantial damageNTSB CHI80FEV10Accident · No injuriesClosedMooney M20K · Lacon, ILNov 25, 1979 · N231FD · Substantial damageNTSB CHI80FEE08Accident · Minor injuriesClosedBeech 76 · West Chicago, ILNov 25, 1979 · N6038Y · Substantial damageNTSB CHI80DEV09Accident · No injuriesClosedBeech A23-19 · Pittsfield, ILNov 25, 1979 · N3618Q · Substantial damageNTSB CHI80FA009Accident · Minor injuriesClosedCessna T210L · Galesburg, ILNov 23, 1979 · N22434 · Substantial damageNTSB CHI80FEV07Accident · 1 fatalClosedAmerican AA-1B · Charleston, ILNov 22, 1979 · N6245L · DestroyedNTSB CHI80FEV08Accident · No injuriesClosedPiper PA-28R · Girard, ILNov 19, 1979 · N853 · Substantial damageNTSB CHI80FEE07Accident · No injuriesClosedPiper PA-24 · Chicago, ILNov 16, 1979 · N7058P · Substantial damageNTSB CHI80DEE05Accident · Minor injuriesClosedCessna 150L · Freeport, ILNov 12, 1979 · N10056 · Substantial damageNTSB CHI80DEE06Accident · No injuriesClosedCessna 152 · Rock City, ILOct 30, 1979 · N67392 · Substantial damageNTSB CHI80FEV06Accident · No injuriesClosedBellanca 7KCAB · Makanda, ILOct 24, 1979 · N4210Y · Substantial damageNTSB CHI80DEE04Accident · Minor injuriesClosedPiper PA-28 · Chicago, ILOct 21, 1979 · N1741T · Substantial damageNTSB CHI80FEV05Accident · Minor injuriesClosedErco 415-C · Grafton, ILOct 19, 1979 · N2676H · Substantial damageNTSB CHI80DA004Accident · 1 fatalClosedCessna A150L · Spring Valley, ILOct 15, 1979 · N5936J · DestroyedNTSB CHI80DEE03Accident · No injuriesClosedCessna 182J · Wheeling, ILOct 13, 1979 · N3596F · Substantial damageNTSB CHI80FEE02Accident · No injuriesClosedCessna 172N · New Lenox, ILOct 12, 1979 · N733QH · Substantial damageNTSB CHI80FEV03Accident · No injuriesClosedAeronca 7AC · Brookport, ILOct 11, 1979 · N3504E · Substantial damageNTSB CHI80DEV02Accident · No injuriesClosedBeech B19 · Sidney, ILOct 10, 1979 · N5104R · Substantial damageNTSB CHI80DEV01Accident · Serious injuriesClosedSchweizer SGU222 · Moweaqua, ILOct 7, 1979 · N9917J · Substantial damageNTSB CHI79FA002Accident · 3 fatalClosedPiper PA-32R · Elgin, ILOct 5, 1979 · N61424 · DestroyedNTSB CHI80FEE01Accident · Serious injuriesClosedPiper PA-28 · Kankakee, ILOct 4, 1979 · N54386 · DestroyedNTSB CHI79FEV35Accident · 1 fatalClosedBellanca 8KCAB · Alma, ILSep 30, 1979 · N499AC · Substantial damageNTSB CHI79FEE85Accident · No injuriesClosedBeech F35 · Utica, ILSep 30, 1979 · N3386C · Substantial damageNTSB CHI79FEE86Accident · 1 fatalClosedVolksplane VP-1 · Plainfield, ILSep 29, 1979 · N655 · Substantial damageNTSB CHI79DEE84Accident · No injuriesClosedCessna 172 · Elgin, ILSep 28, 1979 · N9347E · Substantial damageNTSB CHI79DEE82Accident · No injuriesClosedCessna 337 · Peru, ILSep 27, 1979 · N110RL · Substantial damageNTSB CHI79DEE83Accident · No injuriesClosedBeech 35-B33 · Joliet, ILSep 25, 1979 · N8621M · Substantial damageNTSB CHI79DEV34Accident · No injuriesClosedPiper PA-38 · Mt Sterling, ILSep 23, 1979 · N4306E · Substantial damageNTSB CHI79DEV33Accident · No injuriesClosedBoeing A-75 · Champaign, ILSep 23, 1979 · N49999 · Substantial damageNTSB CHI79DEE81Accident · No injuriesClosedBlanik L-13 · Freeport, ILSep 22, 1979 · N99943 · Substantial damageNTSB CHI79DEE79Accident · No injuriesClosedBeech A36 · Schaumburg, ILSep 21, 1979 · N9451Q · Substantial damageNTSB CHI79DEE88Accident · No injuriesClosedPiper PA-25 · La Moille, ILSep 20, 1979 · N8816L · Substantial damageNTSB CHI79FEV32Accident · No injuriesClosedPiper PA-38 · Jerseyville, ILSep 18, 1979 · N2388T · Substantial damageNTSB CHI79FA079Accident · No injuriesClosedCessna 402C · Chicago, ILSep 18, 1979 · N2713R · Substantial damageNTSB CHI79FA078Accident · 2 fatalClosedCessna 172G · Brownstown, ILSep 18, 1979 · N3623L · DestroyedNTSB CHI79FA077Accident · No injuriesClosedBoeing 707 · Palatine, ILSep 18, 1979 · N7566 · Substantial damageNTSB CHI79DEV31Accident · No injuriesClosedCessna 152 · Galesburg, ILSep 13, 1979 · N68988 · Substantial damageNTSB CHI79DA074Accident · No injuriesClosedPiper PA-28R · Moline, ILSep 9, 1979 · N56373 · Substantial damageNTSB CHI79FEE76Accident · Serious injuriesClosedBrown V-EZE · Plainfield, ILSep 8, 1979 · N67BB · DestroyedNTSB CHI79FEE74Accident · Minor injuriesClosedCessna 182P · Sandwich, ILSep 2, 1979 · N6065F · Substantial damageNTSB CHI79FEV30Accident · Minor injuriesClosedCessna 182A · Hillsboro, ILSep 1, 1979 · N4890D · Substantial damageNTSB CHI79FI070Incident · No injuriesClosedDouglas DC-9 · Chicago, ILAug 30, 1979 · N772NC · Minor damageNTSB CHI79DEE77Accident · No injuriesClosedBeech C35 · Chicago, ILAug 22, 1979 · N692D · Substantial damageNTSB CHI79FEV29Accident · No injuriesClosedPiper PA-23 · Champaign, ILAug 3, 1979 · N105EB · Substantial damageNTSB CHI79FEE78Accident · Minor injuriesClosedPiper PA-32R · West Chicago, ILAug 2, 1979 · N2654Q · Substantial damage