NTSB investigations, 1966, 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, 1966, 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\") = 1966
    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 CHI67D0508Accident · No injuriesClosedCessna 150 · Lombard, ILDec 26, 1966 · N8002F · Substantial damageNTSB CHI67F0422Accident · No injuriesClosedBeech 35 · Roselle, ILDec 25, 1966 · N3745N · Substantial damageNTSB CHI67F0431Accident · No injuriesClosedCessna 150D · Deerfield, ILDec 22, 1966 · N4429U · Substantial damageNTSB CHI67A0077Accident · Serious injuriesClosedPiper PA-30B · Bloomington, ILDec 16, 1966 · N8162Y · Substantial damageNTSB CHI67A0076Accident · 2 fatalClosedErco 415C · Pekin, ILDec 16, 1966 · N3725H · DestroyedNTSB CHI67A0075Accident · No injuriesClosedPiper PA-24 · Quincy, ILDec 16, 1966 · N5578P · Substantial damageNTSB CHI67F0402Accident · No injuriesClosedCessna 175 · St.Charles, ILDec 12, 1966 · N7005M · Substantial damageNTSB CHI67D0412Accident · No injuriesClosedCessna 172G · Mt.Carroll, ILDec 6, 1966 · N6088R · Substantial damageNTSB CHI67A0071Accident · No injuriesClosedViscount V-700 · Chicago, ILDec 4, 1966 · N7450 · Substantial damageNTSB CHI67F0426Accident · No injuriesClosedPiper PA-28 · Geneva, ILDec 3, 1966 · N8178W · Substantial damageNTSB CHI67F0372Accident · Serious injuriesClosedBeech G35 · Warrenville, ILNov 28, 1966 · N4422D · Substantial damageNTSB CHI67D0361Accident · No injuriesClosedCessna 172 · Waukegan, ILNov 28, 1966 · N6663A · Substantial damageNTSB CHI67D0418Accident · Minor injuriesClosedCessna 172 · Kasbeer, ILNov 26, 1966 · N3588S · Substantial damageNTSB CHI67A0068Accident · 1 fatalClosedBeech M35 · Rollg Meadows, ILNov 26, 1966 · N9762R · DestroyedNTSB CHI67F0374Accident · Serious injuriesClosedCessna 180 · Half Day, ILNov 21, 1966 · N9300C · DestroyedNTSB CHI67F0359Accident · No injuriesClosedPiper PA-22 · Seymour, ILNov 20, 1966 · N4858Z · Substantial damageNTSB CHI67A0065Accident · Minor injuriesClosedLockheed L-18 · Chicago, ILNov 17, 1966 · N339 · Substantial damageNTSB CHI67D0363Accident · No injuriesClosedCessna 210 · Wheeling, ILNov 16, 1966 · N3836Y · Substantial damageNTSB CHI67A0063Accident · Minor injuriesClosedFairchild F-27 · Chicago, ILNov 14, 1966 · N4300F · Substantial damageNTSB CHI67F0328Accident · No injuriesClosedBeech 23 · Lacon, ILNov 13, 1966 · N2348J · Substantial damageNTSB CHI67D0488Accident · No injuriesClosedCessna 170B · Sandwich, ILNov 5, 1966 · N2272D · Substantial damageNTSB CHI67A0061Accident · No injuriesClosedN.American NA-265 · Chicago, ILNov 5, 1966 · N360J · Substantial damageNTSB CHI67F0376Accident · No injuriesClosedCessna 210 · Northbrook, ILOct 30, 1966 · N6558X · Substantial damageNTSB CHI67F0353Accident · Minor injuriesClosedCessna 120 · Oswego, ILOct 29, 1966 · N2607N · Substantial damageNTSB CHI67D0370Accident · No injuriesClosedPiper PA-23 · Sparta, ILOct 28, 1966 · N903AR · Substantial damageNTSB CHI67F0030Accident · No injuriesClosedPiper PA30 · Decatur, ILOct 24, 1966 · N7160Y · Substantial damageNTSB CHI67D0636Accident · No injuriesClosedCessna 172 · Pittsfield, ILOct 20, 1966 · N3891L · Substantial damageNTSB CHI67F0377Accident · No injuriesClosedPiper PA-28 · Elgin, ILOct 19, 1966 · N9056J · Substantial damageNTSB CHI67D0362Accident · No injuriesClosedCessna 120 · Wheeling, ILOct 16, 1966 · N1772V · Substantial damageNTSB CHI67F0269Accident · No injuriesClosedPiper PA-28 · Sycamore, ILOct 11, 1966 · N5103W · Substantial damageNTSB CHI67F0310Accident · No injuriesClosedBeech D50A · Waukegan, ILOct 10, 1966 · N660M · Substantial damageNTSB CHI67F0258Accident · No injuriesClosedTaylorcraft BC12-D · Lombard, ILOct 8, 1966 · N43826 · Substantial damageNTSB CHI67D0298Accident · No injuriesClosedCessna 150G · Rockford, ILOct 8, 1966 · N3728J · Substantial damageNTSB CHI67D0270Accident · No injuriesClosedPiper PA-24 · Northbrook, ILOct 8, 1966 · N7083P · Substantial damageNTSB CHI67A0048Accident · 1 fatalClosedChampion 7GCAA · Olney, ILOct 8, 1966 · N8347V · DestroyedNTSB CHI67F0331Accident · No injuriesClosedGlobe GC-1B · Wheeling, ILOct 5, 1966 · N80605 · 2 aircraft · Substantial damageNTSB CHI67F0282Accident · No injuriesClosedBellanca 14-19 · Belleville, ILOct 4, 1966 · N8506R · Substantial damageNTSB CHI67F0334Accident · No injuriesClosedCessna 150 · Northbrook, ILOct 2, 1966 · N3514J · 2 aircraft · Substantial damageNTSB CHI67D0646Accident · No injuriesClosedPiper PA-30 · Benton, ILSep 25, 1966 · N7124Y · Substantial damageNTSB CHI67A0043Accident · 1 fatalClosedCessna 172 · Sailor Sprngs, ILSep 25, 1966 · N5194A · DestroyedNTSB CHI67D0371Accident · No injuriesClosedCessna 182 · Macomb, ILSep 22, 1966 · N2412Q · Substantial damageNTSB CHI67A0011Accident · 1 fatalClosedBeech F35 · Orland Park, ILSep 21, 1966 · N3825B · DestroyedNTSB CHI67D0259Accident · No injuriesClosedErcoupe 415-C · Grayslake, ILSep 16, 1966 · N93776 · Substantial damageNTSB CHI67D0241Accident · No injuriesClosedPiper PA-28 · Joliet, ILSep 15, 1966 · N6342W · Substantial damageNTSB CHI67F0289Accident · No injuriesClosedBeech B95 · Roselle, ILSep 13, 1966 · N2049C · Substantial damageNTSB CHI67F0262Accident · No injuriesClosedPiper PA-28 · Rockford, ILSep 13, 1966 · N6271W · Substantial damageNTSB CHI67D0182Accident · No injuriesClosedCessna 310J · Bloomington, ILSep 12, 1966 · N309FS · Substantial damageNTSB CHI67A0040Accident · 1 fatalClosedPiper J-3 · Columbia, ILSep 11, 1966 · N98494 · DestroyedNTSB CHI67A0039Accident · No injuriesClosedBrantly B2-B · Northbrook, ILSep 11, 1966 · N2172U · DestroyedNTSB CHI67D0312Accident · Serious injuriesClosedCessna 172 · Frankfort, ILSep 10, 1966 · N7279A · No damage