NTSB investigations, 1973, 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, 1973, 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\") = 1973
    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 CHI74DEE41Accident · Minor injuriesClosedCessna 150 · Wheeling, ILDec 31, 1973 · N19277 · Substantial damageNTSB CHI74FEE44Accident · No injuriesClosedPiper PA-24 · Princeton, ILDec 30, 1973 · N6906P · Substantial damageNTSB CHI74DEE45Accident · No injuriesClosedCessna 150 · Lansing, ILDec 30, 1973 · N19240 · Substantial damageNTSB CHI74FEV31Accident · No injuriesClosedCessna P206 · Chillicothe, ILDec 29, 1973 · N2543X · Substantial damageNTSB CHI74DEV33Accident · No injuriesClosedPiper PA-28 · Decatur, ILDec 29, 1973 · N4770T · Substantial damageNTSB CHI74AC054Accident · 4 fatalClosedBeech A23A · Cabery, ILDec 28, 1973 · N2303W · DestroyedNTSB CHI74AC053Accident · No injuriesClosedBeech E18S · Chicago, ILDec 27, 1973 · N5612D · Substantial damageNTSB CHI74FEV32Accident · No injuriesClosedPiper PA-30 · Peoria, ILDec 23, 1973 · N7087Y · Substantial damageNTSB CHI74FEE42Accident · No injuriesClosedAmer Avco AA1 · Woodstock, ILDec 23, 1973 · N6152L · Substantial damageNTSB CHI74DEE38Accident · No injuriesClosedCessna 182F · Schaumberg, ILDec 23, 1973 · N3479U · Substantial damageNTSB CHI74AC052Accident · 2 fatalClosedCessna 182B · Claytonville, ILDec 23, 1973 · N7249E · DestroyedNTSB CHI74FEE37Accident · Serious injuriesClosedCessna TU206B · West Chicago, ILDec 22, 1973 · N3450L · Substantial damageNTSB CHI74DEE43Accident · No injuriesClosedStinson 108 · Kewanee, ILDec 20, 1973 · N8546K · Substantial damageNTSB CHI74DEE40Accident · No injuriesClosedCessna 150 · Rochelle, ILDec 20, 1973 · N10488 · Substantial damageNTSB CHI74AC049Accident · No injuriesClosedBeech E18S · Geneva, ILDec 13, 1973 · N503J · Substantial damageNTSB CHI74FEV30Accident · Serious injuriesClosedCessna P206 · Macomb, ILDec 12, 1973 · N2567X · DestroyedNTSB CHI74FEE36Accident · No injuriesClosedPiper PA-28 · Chicago, ILDec 12, 1973 · N5796F · Substantial damageNTSB CHI74DEE35Accident · No injuriesClosedCessna 180 · Joliet, ILDec 2, 1973 · N3196C · Substantial damageNTSB CHI74FEV29Accident · No injuriesClosedCessna 150L · Laharpe, ILDec 1, 1973 · N1545Q · Substantial damageNTSB CHI74DEE35Accident · No injuriesClosedBeech 23-19 · Moline, ILNov 18, 1973 · N6091N · Substantial damageNTSB CHI74DEV28Accident · No injuriesClosedCessna T210F · Peoria, ILNov 17, 1973 · N6191R · Substantial damageNTSB CHI74FEE33Accident · No injuriesClosedCessna 210H · Rockford, ILNov 15, 1973 · N5991F · Substantial damageNTSB CHI74AC041Accident · No injuriesClosedDassault Falcon · Galesburg, ILNov 9, 1973 · N910L · Substantial damageNTSB CHI74FEV26Accident · No injuriesClosedAeronca 7EC · Monticello, ILNov 5, 1973 · N85547 · Substantial damageNTSB CHI74AEV27Accident · Serious injuriesClosedCessna 140 · Hull, ILNov 5, 1973 · N72391 · Substantial damageNTSB CHI74AC039Accident · No injuriesClosedBeech E18E · Chicago, ILNov 1, 1973 · N251K · Substantial damageNTSB CHI74DEE32Accident · No injuriesClosedPiper PA-28 · Rockford, ILOct 27, 1973 · N9301J · Substantial damageNTSB CHI74DEE31Accident · Minor injuriesClosedCessna 182N · Polo, ILOct 27, 1973 · N9060G · Substantial damageNTSB CHI74DEV25Accident · No injuriesClosedPiper PA-28 · Rowe, ILOct 24, 1973 · N6762W · Substantial damageNTSB CHI74FEV24Accident · No injuriesClosedCessna 182H · Rushville, ILOct 21, 1973 · N8516S · Substantial damageNTSB CHI74FEE29Accident · No injuriesClosedCessna 182A · Marseilles, ILOct 21, 1973 · N5983B · Substantial damageNTSB CHI74AEE30Accident · No injuriesClosedAero Comdr 720 · Rockton, ILOct 21, 1973 · N688R · Substantial damageNTSB CHI74FEE28Accident · No injuriesClosedCessna 182 · Polo, ILOct 19, 1973 · N2093X · DestroyedNTSB CHI74FEE26Accident · 1 fatalClosedCessna 320 · Northbrook, ILOct 14, 1973 · N861W · DestroyedNTSB CHI74FEE27Accident · No injuriesClosedCessna 172K · Plainfield, ILOct 13, 1973 · N7341G · Substantial damageNTSB CHI74AC031Accident · 2 fatalClosedBellanca 7GCBC · Morris, ILOct 6, 1973 · N36034 · DestroyedNTSB CHI74FEV22Accident · No injuriesClosedMitsubishi MU-2 · Springfield, ILOct 5, 1973 · N887Q · Substantial damageNTSB CHI74FEE25Accident · No injuriesClosedPiper PA-28 · Eglin, ILOct 5, 1973 · N55707 · Substantial damageNTSB CHI74AC029Accident · 1 fatalClosedAerostar 601 · Chicago, ILOct 3, 1973 · N8MW · DestroyedNTSB CHI74FEE24Accident · No injuriesClosedPiper PA-28 · Plainfield, ILSep 30, 1973 · N8225N · Substantial damageNTSB CHI74FEE22Accident · No injuriesClosedCessna 310K · Wheeling, ILSep 24, 1973 · N7012L · Substantial damageNTSB CHI74FEE23Accident · No injuriesClosedCessna 310J · West Chicago, ILSep 22, 1973 · N3187L · Substantial damageNTSB CHI74FEE20Accident · Serious injuriesClosedBeech 35 · Streator, ILSep 18, 1973 · N3325V · DestroyedNTSB CHI74FEE19Accident · No injuriesClosedCessna 320E · Downers Grove, ILSep 16, 1973 · N2JF · Substantial damageNTSB CHI74FEE21Accident · No injuriesClosedLuscombe 8E · Grayslake, ILSep 15, 1973 · N2600K · Substantial damageNTSB CHI74AC023Accident · 3 fatalClosedBeech B23 · Carbondale, ILSep 15, 1973 · N6069N · DestroyedNTSB CHI74FEV21Accident · No injuriesClosedNavion A · Monmouth, ILSep 14, 1973 · N1105M · Substantial damageNTSB NYC74AN022Accident · 1 fatalClosedCessna 172H · Wheeling, ILSep 13, 1973 · N2665L · 2 aircraft · Minor damageNTSB CHI74FCA01Accident · Minor injuriesClosedCessna T210L · Cahokia, ILSep 13, 1973 · N30607 · Substantial damageNTSB CHI74FEE18Accident · Minor injuriesClosedPiper PA-22 · Glenwood, ILSep 10, 1973 · N5725D · Substantial damage