NTSB investigations, 1978, IL

180,604 investigations by the National Transportation Safety Board since 1962: 174,583 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, 1978, 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\") = 1978
    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 CHI79FCA02Accident · No injuriesClosedMooney M20J · Belleville, ILDec 28, 1978 · N201RY · Substantial damageNTSB CHI79DEE24Accident · No injuriesClosedSchuster WAS2 · Ottawa, ILDec 28, 1978 · N9120 · Substantial damageNTSB CHI79DEE22Accident · No injuriesClosedCessna 150 · Naperville, ILDec 26, 1978 · N1294Q · Substantial damageNTSB CHI79FEE20Accident · No injuriesClosedBeech 65 · Wheeling, ILDec 22, 1978 · N836Q · Substantial damageNTSB CHI79FEE19Accident · No injuriesClosedBeech D-50 · S.Barrington, ILDec 22, 1978 · N150V · Substantial damageNTSB CHI79FA021Accident · 2 fatalClosedCessna 210L · Morton, ILDec 19, 1978 · N4638Q · DestroyedNTSB CHI79DEV08Accident · No injuriesClosedBellanca 7G · Meredosia, ILDec 19, 1978 · N53815 · Substantial damageNTSB CHI79DEE25Accident · No injuriesClosedPiper PA-38 · Schaumburg, ILDec 19, 1978 · N2560A · Substantial damageNTSB CHI79FEE21Accident · No injuriesClosedCessna 150 · Mendota, ILDec 17, 1978 · N23JR · Substantial damageNTSB CHI79FEE17Accident · 1 fatalClosedHawker TMK20 · Waukegan, ILDec 16, 1978 · N20SF · DestroyedNTSB CHI79FEE16Accident · No injuriesClosedPiper PA-30 · Kankakee, ILDec 16, 1978 · N8143Y · Substantial damageNTSB CHI79DEV09Accident · No injuriesClosedCessna 150 · Danville, ILDec 16, 1978 · N10739 · Substantial damageNTSB CHI79DEE33Accident · No injuriesClosedPiper PA-28 · Elgin, ILDec 15, 1978 · N44105 · Substantial damageNTSB CHI79DEE27Accident · Minor injuriesClosedCessna 172-K · Lansing, ILDec 12, 1978 · N79035 · Substantial damageNTSB CHI79FEV07Accident · No injuriesClosedCessna U206G · Casey, ILDec 9, 1978 · N9544M · Substantial damageNTSB CHI79DEV06Accident · No injuriesClosedCessna 150 · Monmouth, ILDec 9, 1978 · N704PT · Substantial damageNTSB CHI79DEV05Accident · No injuriesClosedCessna 152 · Peoria, ILDec 9, 1978 · N24792 · Substantial damageNTSB CHI79FEE18Accident · No injuriesClosedPiper PA-32 · West Chicago, ILDec 7, 1978 · N4175R · Substantial damageNTSB CHI79FA019Accident · Minor injuriesClosedCessna 401A · Rockford, ILDec 7, 1978 · N6247Q · Substantial damageNTSB CHI79DEE14Accident · No injuriesClosedCessna 401A · Chicago, ILDec 6, 1978 · N622DG · Substantial damageNTSB CHI79FEE15Accident · No injuriesClosedCessna 411A · West Chicago, ILDec 4, 1978 · N3262R · Substantial damageNTSB CHI79FA018Accident · 3 fatalClosedBeech V35A · Wheeling, ILDec 3, 1978 · N6DF · DestroyedNTSB CHI79DEE28Accident · No injuriesClosedCessna 152 · Sugar Grove, ILDec 2, 1978 · N68750 · Substantial damageNTSB CHI79DEV04Accident · No injuriesClosedCessna 310 · Peoria, ILNov 20, 1978 · N7872Q · Substantial damageNTSB CHI79DEE12Accident · No injuriesClosedGrumman AA-5A · Morris, ILNov 15, 1978 · N9748U · Substantial damageNTSB CHI79FEE09Accident · Minor injuriesClosedCessna 140 · Waukegan, ILNov 11, 1978 · N701F · Substantial damageNTSB CHI79FEE10Accident · No injuriesClosedBeech B19 · Gurnee, ILNov 9, 1978 · N1922W · Substantial damageNTSB CHI79IA015Incident · No injuriesClosedBoeing 747 · Chicago, ILNov 7, 1978 · N4710U · 2 aircraft · Minor damageNTSB CHI79FA014Accident · 4 fatalClosedCessna 210A · Chicago, ILNov 5, 1978 · N695HP · DestroyedNTSB CHI79DEE11Accident · No injuriesClosedBeech A-55 · Ottawa, ILNov 5, 1978 · N323E · Substantial damageNTSB CHI79FEV03Accident · 1 fatalClosedStarduster TOO · Nhenderson, ILNov 4, 1978 · N762RD · DestroyedNTSB CHI79FEE68Accident · No injuriesClosedPiper PA-28 · Elgin, ILOct 25, 1978 · N5163L · Substantial damageNTSB CHI79FA011Accident · 1 fatalClosedPiper PA-24 · Ashton, ILOct 25, 1978 · N8666P · Substantial damageNTSB CHI79FEE06Accident · No injuriesClosedHughes 269C · West Chicago, ILOct 24, 1978 · N7415F · Substantial damageNTSB CHI79DEE23Accident · No injuriesClosedRaven S60A · Fox River Grve, ILOct 24, 1978 · N1918R · Substantial damageNTSB CHI79DEE07Accident · No injuriesClosedBalloon WKS FF7 · Grayslake, ILOct 24, 1978 · N2313H · Substantial damageNTSB CHI79FEE08Accident · No injuriesClosedCessna 182 · Hinckley, ILOct 21, 1978 · N6258A · Substantial damageNTSB CHI79DEE05Accident · No injuriesClosedPiper PA-28 · West Chicago, ILOct 19, 1978 · N5749F · Substantial damageNTSB CHI79FEV02Accident · No injuriesClosedCessna 152 · Jacksonville, ILOct 18, 1978 · N757UJ · Substantial damageNTSB CHI79FEE03Accident · No injuriesClosedBeech 58 · Moline, ILOct 18, 1978 · N9367Q · Substantial damageNTSB CHI79FEE04Accident · No injuriesClosedErco 415-D · Savanna, ILOct 15, 1978 · N99698 · Substantial damageNTSB CHI79DEE13Accident · No injuriesClosedCessna 150 · Lanark, ILOct 10, 1978 · N5896G · Substantial damageNTSB CHI79FEV01Accident · No injuriesClosedPiper PA-36 · Metropolis, ILOct 9, 1978 · N57760 · Substantial damageNTSB CHI79FEE02Accident · Minor injuriesClosedBeechcraft C24R · Sugar Grove, ILOct 4, 1978 · N24023 · Substantial damageNTSB CHI79FA004Accident · Serious injuriesClosedBoeing 727 · Chicago, ILOct 4, 1978 · N1979 · Substantial damageNTSB CHI79FA003Accident · No injuriesClosedPiper PA-32 · Chicago, ILOct 4, 1978 · N5909V · Substantial damageNTSB CHI79FEE01Accident · No injuriesClosedPiper PA-28 · Elgin, ILOct 3, 1978 · N44553 · Substantial damageNTSB CHI79FCA01Accident · 2 fatalClosedReplica 1 · Pierron, ILOct 1, 1978 · N1912G · DestroyedNTSB CHI78FEE70Accident · Minor injuriesClosedBeech 95-B55 · Elgin, ILSep 30, 1978 · N2AC · DestroyedNTSB CHI78FCA04Accident · No injuriesClosedCessna 172M · Cahokia, ILSep 26, 1978 · N20471 · Substantial damage