NTSB investigations, 1972, 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, 1972, 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\") = 1972
    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 CHI73FEV19Accident · Minor injuriesClosedCessna 150H · Albion, ILDec 29, 1972 · N50344 · Substantial damageNTSB CHI73FEE38Accident · No injuriesClosedCessna 150J · West Chicago, ILDec 28, 1972 · N106DP · Substantial damageNTSB CHI73FEE37Accident · No injuriesClosedBellanca 17-31 · Northbrook, ILDec 27, 1972 · N8830V · Substantial damageNTSB CHI73AC059Accident · 2 fatalClosedBeech H18S · Bloominton, ILDec 21, 1972 · N800G · DestroyedNTSB DCA73AZ004Accident · 10 fatalClosedConvair 880 · Chicago, ILDec 20, 1972 · N8807E · 2 aircraft · Substantial damageNTSB CHI73FEV18Accident · No injuriesClosedBeech D55 · Champaign, ILDec 19, 1972 · N7731R · Substantial damageNTSB CHI73FEE36Accident · No injuriesClosedCessna 500 · Chicago, ILDec 19, 1972 · N522JD · Substantial damageNTSB CHI73FEE35Accident · No injuriesClosedPiper PA-28 · Northbrook, ILDec 14, 1972 · N5393S · Substantial damageNTSB NYC73AN081Accident · 4 fatalClosedPiper PA-28 · Grand Tower, ILDec 8, 1972 · N4235T · DestroyedNTSB DCA73A0003Accident · 43 fatalClosedBoeing 737 · Chicago, ILDec 8, 1972 · N9031U · DestroyedNTSB CHI73FEE34Accident · No injuriesClosedPiper PA-23 · Joliet, ILDec 7, 1972 · N6500D · Substantial damageNTSB CHI73FEV17Accident · No injuriesClosedPiper PA-28R · Fairfield, ILNov 27, 1972 · N4663J · Substantial damageNTSB CHI73FEE32Accident · No injuriesClosedBeech 65-B80 · Rockford, ILNov 27, 1972 · N7813L · Substantial damageNTSB CHI73FEV16Accident · No injuriesClosedPiper PA-24 · Burnt Prairie, ILNov 26, 1972 · N5186P · Substantial damageNTSB CHI73ICO61Incident · No injuriesClosedConvair 580 · Chicago, ILNov 24, 1972 · N4810C · 2 aircraft · Minor damageNTSB CHI73DEE33Accident · No injuriesClosedPiper PA-22 · Lockport, ILNov 23, 1972 · N1170C · Substantial damageNTSB CHI73FEE31Accident · Minor injuriesClosedPiper PA-28 · Northbrook, ILNov 21, 1972 · N1790T · Substantial damageNTSB CHI73AC049Accident · 2 fatalClosedCessna 182E · Willisville, ILNov 21, 1972 · N9346X · DestroyedNTSB CHI73DCA02Accident · No injuriesClosedCessna 150H · Cahokia, ILNov 12, 1972 · N22473 · Substantial damageNTSB CHI73DEE30Accident · No injuriesClosedCessna 172K · Moline, ILNov 9, 1972 · N7409G · Substantial damageNTSB CHI73FEV15Accident · No injuriesClosedBeech 35 · Quincy, ILNov 5, 1972 · N3956N · Substantial damageNTSB CHI73FEE29Accident · Minor injuriesClosedPiper PA-22 · Barrington, ILNov 5, 1972 · N5751D · Substantial damageNTSB CHI73FEE28Accident · No injuriesClosedCessna 190 · Morris, ILNov 5, 1972 · N4361V · DestroyedNTSB CHI73FEE27Accident · No injuriesClosedCessna 150 · Geneva, ILOct 30, 1972 · N5356Q · Substantial damageNTSB CHI73FEV14Accident · No injuriesClosedPiper PA-30 · Robinson, ILOct 23, 1972 · N7939 · Substantial damageNTSB CHI73AC043Accident · 6 fatalClosedAero Comdr 500-A · Pekin, ILOct 23, 1972 · N78376 · DestroyedNTSB CHI73DEE26Accident · No injuriesClosedPiper PA-28 · New Lenox, ILOct 15, 1972 · N4408J · Substantial damageNTSB CHI73AC040Accident · 2 fatalClosedPiper PA-28R · Bloomington, ILOct 14, 1972 · N2831R · DestroyedNTSB CHI73ACO39Accident · 1 fatalClosedN. American SNJ-6 · Woodstock, ILOct 9, 1972 · N7984C · Substantial damageNTSB CHI73ACO37Accident · No injuriesClosedBeech SNB-5 · Chicago, ILOct 5, 1972 · N3787A · Substantial damageNTSB CHI73FCA01Accident · Serious injuriesClosedPiper PA-25 · Dorsey, ILSep 30, 1972 · N7247Z · Substantial damageNTSB CHI73A0023Accident · No injuriesClosedDouglas DC9-32 · Chicago, ILSep 28, 1972 · N3329L · Substantial damageNTSB CHI73DEV12Accident · No injuriesClosedCessna 310G · Fairfield, ILSep 25, 1972 · N8900Z · Substantial damageNTSB CHI73FET06Accident · Minor injuriesClosedAlon A2 · Ligonier, ILSep 24, 1972 · N5686F · Substantial damageNTSB CHI73FEE24Accident · Serious injuriesClosedCessna 172 · Morrison, ILSep 24, 1972 · N6361E · DestroyedNTSB CHI73DEE25Accident · No injuriesClosedRyan PT-22 · Stockton, ILSep 24, 1972 · N60170 · Substantial damageNTSB CHI73AC033Accident · 4 fatalClosedCessna 337B · Chicago, ILSep 17, 1972 · N528N · Substantial damageNTSB CHI73FEV11Accident · No injuriesClosedPiper PA-24 · Jacksonville, ILSep 11, 1972 · N8793P · Substantial damageNTSB CHI72FEV33Accident · Serious injuriesClosedPiper PA-22 · Warsaw, ILSep 9, 1972 · N601A · DestroyedNTSB CHI73FEV10Accident · No injuriesClosedChampion 7ECA · Pittsfield, ILSep 4, 1972 · N5169X · Substantial damageNTSB CHI73FEV09Accident · Minor injuriesClosedStinson 108-1 · Virginia, ILSep 4, 1972 · N9009K · Substantial damageNTSB CHI73DEV13Accident · No injuriesClosedAero Comdr A-9B · Jacksonville, ILSep 4, 1972 · N7965V · Substantial damageNTSB CHI73FEE22Accident · Minor injuriesClosedPiper PA-28 · Rockford, ILSep 3, 1972 · N5677U · Substantial damageNTSB CHI73DEE21Accident · No injuriesClosedCessna 177A · Moline, ILAug 28, 1972 · N30475 · Substantial damageNTSB CHI73FEE19Accident · No injuriesClosedCessna 150H · Deerfield, ILAug 25, 1972 · N7287S · Substantial damageNTSB CHI73FEV08Accident · No injuriesClosedPiper PA-25 · Browns, ILAug 23, 1972 · N8807L · Substantial damageNTSB CHI73DEE20Accident · Minor injuriesClosedPiper PA-28 · Park Forest, ILAug 20, 1972 · N5858W · Substantial damageNTSB CHI73FEE18Accident · No injuriesClosedCessna 150G · Shannon, ILAug 14, 1972 · N2823S · Substantial damageNTSB CHI73AC017Accident · No injuriesClosedFairchild FH227B · Chicago, ILAug 14, 1972 · N4226 · Substantial damageNTSB CHI73FEV07Accident · Serious injuriesClosedPiper PA-25 · Brookport, ILAug 13, 1972 · N4552Y · Destroyed