NTSB investigations, 1965, 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, 1965, 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\") = 1965
    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 CHI66F0509Accident · No injuriesClosedMooney M20B · Springfield, ILDec 31, 1965 · N74707 · Substantial damageNTSB CHI66F0552Accident · No injuriesClosedCessna 150 · West Chicago, ILDec 29, 1965 · N4119U · Substantial damageNTSB CHI66D0499Accident · No injuriesClosedCessna 150 · Farmington, ILDec 27, 1965 · N5939T · Substantial damageNTSB CHI66F0511Accident · No injuriesClosedCessna 172G · Streator, ILDec 26, 1965 · N3605L · Substantial damageNTSB CHI66D0503Accident · No injuriesClosedCessna 150 · East Alton, ILDec 26, 1965 · N8302G · Substantial damageNTSB CHI66F0533Accident · No injuriesClosedBeechcraft K35 · Chicago, ILDec 18, 1965 · N635Q · Substantial damageNTSB CHI66F0485Accident · Serious injuriesClosedPiper PA28 · Urbana, ILDec 18, 1965 · N8208W · DestroyedNTSB CHI66D0553Accident · No injuriesClosedMooney M20 · Polo, ILDec 18, 1965 · N6455U · Substantial damageNTSB CHI66F0528Accident · Minor injuriesClosedCessna 172 · Granite City, ILDec 16, 1965 · N5435T · DestroyedNTSB CHI66D0618Accident · No injuriesClosedCessna 182 · Meyer, ILDec 16, 1965 · N3419S · Substantial damageNTSB CHI66F0482Accident · No injuriesClosedPiper PA-28 · Lombard, ILDec 6, 1965 · N6774W · Substantial damageNTSB CHI66F0531Accident · Serious injuriesClosedBeechcraft 23 · Wheeling, ILDec 5, 1965 · N2323Q · 2 aircraft · Substantial damageNTSB CHI66F0479Accident · No injuriesClosedPiper PA-22 · Granite City, ILDec 4, 1965 · N8875D · Substantial damageNTSB CHI66F0462Accident · No injuriesClosedCessna 310 · Chicago, ILDec 4, 1965 · N4890B · Substantial damageNTSB CHI66F0506Accident · No injuriesClosedCessna 172 · Moline, ILDec 3, 1965 · N5766T · Substantial damageNTSB CHI66D0440Accident · No injuriesClosedLuscombe 8E · Collinsville, ILNov 27, 1965 · N1573B · Substantial damageNTSB CHI66I0052Incident · No injuriesClosedDouglas DC-8 · Chicago, ILNov 23, 1965 · N811E · Minor damageNTSB CHI66F0478Accident · No injuriesClosedPiper PA-23 · East St Louis, ILNov 22, 1965 · N3205P · Substantial damageNTSB CHI66A0051Accident · 4 fatalClosedCessna 172F · Chicago Hgts, ILNov 21, 1965 · N5582R · DestroyedNTSB CHI66F0463Accident · No injuriesClosedCessna 310J · Northbrook, ILNov 20, 1965 · N3108L · Substantial damageNTSB CHI66A0050Accident · No injuriesClosedCessna 310D · Peoria, ILNov 19, 1965 · N6777T · Substantial damageNTSB CHI66D0464Accident · No injuriesClosedBeechcraft 95-55 · Des Plaines, ILNov 18, 1965 · N7970K · Substantial damageNTSB CHI66D0417Accident · No injuriesClosedPiper J-3 · Half Day, ILNov 11, 1965 · N98608 · Substantial damageNTSB CHI66F0470Accident · No injuriesClosedMooney M20E · Sullivan, ILNov 7, 1965 · N5721Q · Substantial damageNTSB CHI66D0409Accident · No injuriesClosedBeechcraft 35-C33 · Wheeling, ILNov 3, 1965 · N8928U · Substantial damageNTSB CHI66F0398Accident · No injuriesClosedPiper PA-22 · Shelbyville, ILNov 2, 1965 · N5430Z · Substantial damageNTSB CHI66F0437Accident · No injuriesClosedCessna 182A · Effingham, ILOct 23, 1965 · N3833D · Substantial damageNTSB CHI66A0040Accident · No injuriesClosedBell 47H1 · Niles, ILOct 19, 1965 · N8696E · DestroyedNTSB CHI66F0349Accident · No injuriesClosedCessna 150F · Scott Afb, ILOct 17, 1965 · N8279S · Substantial damageNTSB CHI66D0390Accident · No injuriesClosedPiper PA-28 · Lombard, ILOct 17, 1965 · N6762W · Substantial damageNTSB CHI66F0360Accident · Serious injuriesClosedCessna 172F · Chicago, ILOct 10, 1965 · N8540U · DestroyedNTSB CHI66D0643Accident · No injuriesClosedCessna 180 · Aurora, ILOct 10, 1965 · N3179D · Substantial damageNTSB CHI66F0382Accident · 1 fatalClosedPiper PA-22 · Coffeen, ILOct 6, 1965 · N9238D · Substantial damageNTSB CHI66F0359Accident · No injuriesClosedFairchild 24G · Joliet, ILOct 3, 1965 · N16900 · Substantial damageNTSB CHI66D0323Accident · No injuriesClosedMooney M20D · Downers Grove, ILSep 26, 1965 · N6828U · Substantial damageNTSB CHI66F0324Accident · No injuriesClosedCessna 320C · Chicago, ILSep 24, 1965 · N3005T · Substantial damageNTSB CHI66A0029Accident · No injuriesClosedAir & Space 18A · Vandalia, ILSep 24, 1965 · N6121 · Substantial damageNTSB CHI66F0327Accident · No injuriesClosedNavion G · Peoria, ILSep 23, 1965 · N2424T · Substantial damageNTSB CHI66F0310Accident · Minor injuriesClosedTaylorcraft BC-12D · Stauton, ILSep 11, 1965 · N43946 · Substantial damageNTSB CHI66D0357Accident · No injuriesClosedCessna 180 · Pontiac, ILSep 9, 1965 · N9181C · Substantial damageNTSB CHI66D0317Accident · No injuriesClosedCessna 182E · Chicago, ILSep 9, 1965 · N2865Y · Substantial damageNTSB CHI66F0217Accident · No injuriesClosedPiper PA-22 · Lacon, ILSep 8, 1965 · N9971D · Substantial damageNTSB CHI66F0219Accident · No injuriesClosedCessna 120 · Sparta, ILSep 5, 1965 · N4075N · Substantial damageNTSB CHI66F0306Accident · Serious injuriesClosedCessna 195A · Frankfort, ILSep 4, 1965 · N1052D · DestroyedNTSB CHI66F0226Accident · No injuriesClosedPiper PA-24 · Joliet, ILSep 4, 1965 · N7833P · Substantial damageNTSB CHI66D0199Accident · No injuriesClosedCessna 172 · Rockford, ILSep 2, 1965 · N8654U · Substantial damageNTSB CHI66F0386Accident · No injuriesClosedCessna 170B · Half Day, ILAug 29, 1965 · N4550C · Substantial damageNTSB CHI66F0314Accident · No injuriesClosedCessna 150 · Northbrook, ILAug 29, 1965 · N4429U · 2 aircraft · Substantial damageNTSB CHI66D0334Accident · No injuriesClosedCessna 172 · Jerseyville, ILAug 29, 1965 · N5673T · Substantial damageNTSB CHI66F0307Accident · No injuriesClosedPiper PA-22 · Lombard, ILAug 28, 1965 · N4957E · Substantial damage