NTSB investigations, 1971, 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, 1971, 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\") = 1971
    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 CHI72DEV20Accident · No injuriesClosedTaylorcraft BC12-D · Jacksonville, ILDec 31, 1971 · N95057 · Substantial damageNTSB CHI72AC056Accident · 2 fatalClosedPiper PA-24 · Rockford, ILDec 30, 1971 · N5518P · DestroyedNTSB CHI72IC055Incident · 1 fatalClosedLockheed Ga 382 · Chicago, ILDec 26, 1971 · N9258R · No damageNTSB CHI72FEE51Accident · No injuriesClosedBeech 18 · Chicago, ILDec 24, 1971 · N588K · Substantial damageNTSB CHI72AC051Accident · 2 fatalClosedCessna 320D · Springfield, ILDec 12, 1971 · N777K · DestroyedNTSB CHI72FEE48Accident · No injuriesClosedNavion B · Harvard, ILDec 11, 1971 · N5327K · Substantial damageNTSB CHI72FEE46Accident · No injuriesClosedCessna 150L · Libertyville, ILNov 30, 1971 · N6835G · Substantial damageNTSB CHI72FEE47Accident · No injuriesClosedPiper PA-12 · Elgin, ILNov 27, 1971 · N3847M · Substantial damageNTSB CHI72DEV18Accident · No injuriesClosedPiper PA-16 · Lawrenceville, ILNov 20, 1971 · N5899H · Substantial damageNTSB CHI72DEE45Accident · No injuriesClosedMooney M20B · Rockford, ILNov 13, 1971 · N74578 · Substantial damageNTSB CHI72FEE43Accident · No injuriesClosedCessna 310H · Elgin, ILNov 7, 1971 · N7171L · DestroyedNTSB CHI72DEE39Accident · No injuriesClosedPiper PA-23 · Streator, ILNov 2, 1971 · N5511Y · Substantial damageNTSB CHI72DEE44Accident · No injuriesClosedPiper PA-32 · Rockford, ILOct 30, 1971 · N757UG · Substantial damageNTSB CHI72FEE42Accident · No injuriesClosedBeech V35A · Kankakee, ILOct 29, 1971 · N7935R · Substantial damageNTSB DCA72AZ004Accident · 16 fatalClosedBeech E18S · Peoria, ILOct 21, 1971 · N51CS · DestroyedNTSB CHI72DEE40Accident · No injuriesClosedCessna 170B · Moline, ILOct 21, 1971 · N3532C · Substantial damageNTSB CHI72FEE41Accident · No injuriesClosedCessna 150 · Seneca, ILOct 20, 1971 · N5696G · Substantial damageNTSB CHI72DEE38Accident · No injuriesClosedCessna 150 · Sandwich, ILOct 18, 1971 · N5944G · Substantial damageNTSB CHI72DEV17Accident · No injuriesClosedPiper PA-25 · Ware, ILOct 15, 1971 · N4552Y · Substantial damageNTSB CHI72FEV16Accident · No injuriesClosedPiper PA-28 · Carlinville, ILOct 14, 1971 · N5889W · Substantial damageNTSB CHI72FEE35Accident · No injuriesClosedPiper PA-24 · Rockford, ILOct 12, 1971 · N8702P · Substantial damageNTSB CHI72FEE32Accident · No injuriesClosedBeech 95-B55 · Lockport, ILOct 9, 1971 · N7515N · Substantial damageNTSB CHI72AC034Accident · No injuriesClosedDouglas DC-9 · Chicago, ILOct 9, 1971 · N3308L · Minor damageNTSB CHI72AC033Accident · Minor injuriesClosedPiper PA-28 · Urbana, ILOct 9, 1971 · N6597W · 2 aircraft · Substantial damageNTSB CHI72FEE37Accident · No injuriesClosedCessna 150 · Chicago, ILOct 6, 1971 · N8405M · DestroyedNTSB CHI72FEE29Accident · No injuriesClosedKnight OW-1 · Maple Park, ILOct 4, 1971 · N1013Z · Substantial damageNTSB CHI72FEE30Accident · Serious injuriesClosedPiper PA-12 · Gardner, ILOct 3, 1971 · N3445M · DestroyedNTSB CHI72FCA01Accident · No injuriesClosedPiper PA-24 · E St Louis, ILOct 3, 1971 · N6886P · Substantial damageNTSB CHI72FEE33Accident · No injuriesClosedMooney M20E · Caledonia, ILOct 2, 1971 · N5979Q · Substantial damageNTSB CHI72FEE31Accident · No injuriesClosedPiper PA-22 · Mchenry, ILSep 29, 1971 · N4660Z · DestroyedNTSB CHI72AC029Accident · 4 fatalClosedCessna 177 · Hanna City, ILSep 27, 1971 · N3417T · Substantial damageNTSB CHI72DEE36Accident · No injuriesClosedChampion 7EC · Lasalle, ILSep 24, 1971 · N7459B · Substantial damageNTSB CHI72FEE28Accident · Serious injuriesClosedBell 47G-4A · Chicago, ILSep 22, 1971 · N4033G · Substantial damageNTSB CHI72FEE26Incident · No injuriesClosedPiper PA-24 · Rock Falls, ILSep 20, 1971 · N9065P · Minor damageNTSB CHI72DEE34Accident · No injuriesClosedCessna 310B · Rockford, ILSep 17, 1971 · N125ET · Substantial damageNTSB CHI72DEE27Accident · No injuriesClosedPiper PA-24 · Waukegan, ILSep 13, 1971 · N7232P · Substantial damageNTSB CHI72FEE22Accident · No injuriesClosedStinson 108 · West Chicago, ILSep 7, 1971 · N26448 · Substantial damageNTSB CHI72AC023Accident · Serious injuriesClosedDouglas DC-3 · Peotone, ILSep 6, 1971 · N44992 · Minor damageNTSB CHI72DEE23Accident · No injuriesClosedBeech C35 · Dekalb, ILSep 3, 1971 · N654D · Substantial damageNTSB CHI72DEE24Accident · No injuriesClosedPiper PA-28 · Clearing, ILSep 1, 1971 · N5875U · Substantial damageNTSB CHI72DEE25Accident · No injuriesClosedSiai-Marche S205 · Northbrook, ILAug 30, 1971 · N2832W · Substantial damageNTSB CHI72DEE21Accident · No injuriesClosedCessna 180 · Wheeling, ILAug 29, 1971 · N3868C · Substantial damageNTSB CHI72FEV14Accident · No injuriesClosedPiper PA-25 · Fisher, ILAug 24, 1971 · N4772Y · Substantial damageNTSB CHI72FEE18Accident · Minor injuriesClosedPiper PA-28 · Grayslake, ILAug 22, 1971 · N6652W · Substantial damageNTSB CHI72FEE17Accident · Minor injuriesClosedPiper PA-28 · Grayslake, ILAug 22, 1971 · N8415R · Substantial damageNTSB CHI72FEE16Accident · Minor injuriesClosedErco 415-C · Plainfield, ILAug 21, 1971 · N3088H · Substantial damageNTSB CHI72DEE20Accident · Minor injuriesClosedBeech V35 · Plainfield, ILAug 20, 1971 · N8452J · Substantial damageNTSB CHI72DEV15Accident · No injuriesClosedPiper PA-28 · Cropsey, ILAug 18, 1971 · N5233L · Substantial damageNTSB CHI72FEV13Accident · No injuriesClosedCessna 150 · Manito, ILAug 16, 1971 · N6510S · Substantial damageNTSB CHI72FEE15Accident · No injuriesClosedPiper PA-28 · Grayslake, ILAug 16, 1971 · N5691U · Substantial damage