NTSB investigations, 1973, KY

180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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

19642026
NTSB investigations, 1973, KY per year, 1964–2026: 1,465 cases
196446
196551
196632
196736
196854
196946
197039
197150
197251
197343
197440
197535
197642
197735
197851
197939
198043
198130
198239
198331
198422
198531
198620
198728
198822
19899
199017
199111
199224
199319
199415
19959
199618
199712
199812
199914
200015
200114
200214
200321
200419
200515
200616
200711
200816
200914
201020
20119
201214
201311
20145
201513
201611
201711
20185
201913
20207
202111
202215
202313
202413
202515
20268

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\" = 'KY' 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 IAD74AI037Accident · 1 fatalClosedBellanca 7KCAB · Munfordville, KYDec 29, 1973 · N711RD · DestroyedNTSB IAD74DLQ20Accident · No injuriesClosedCessna 172 · Moreland, KYDec 26, 1973 · N20351 · Substantial damageNTSB IAD74FLQ17Accident · No injuriesClosedCessna 177 · Dycusburg, KYDec 11, 1973 · N3250T · Substantial damageNTSB IAD74AI033Accident · Minor injuriesClosedBeech D18 · Covington, KYDec 7, 1973 · N199L · Substantial damageNTSB IAD74AI027Accident · 2 fatalClosedCessna 170 · Glasgow, KYNov 18, 1973 · N3556C · DestroyedNTSB IAD74FLQ15Accident · Minor injuriesClosedPiper PA-23 · Albany, KYNov 5, 1973 · N345E · Substantial damageNTSB IAD74AI025Accident · 2 fatalClosedMooney M20C · Cromwell, KYNov 4, 1973 · N3361X · DestroyedNTSB IAD74DLQ13Accident · No injuriesClosedBeech 35-A33 · Paducah, KYOct 24, 1973 · N975B · Substantial damageNTSB IAD74FLQ12Accident · No injuriesClosedCessna 172K · Williamsburg, KYOct 10, 1973 · N7042G · Substantial damageNTSB IAD74FLQ11Accident · No injuriesClosedPiper PA-28 · Louisville, KYOct 10, 1973 · N5253W · Substantial damageNTSB IAD74DLQ10Accident · No injuriesClosedBeech E55 · Hazard, KYSep 26, 1973 · N1792W · Substantial damageNTSB IAD74FLQ09Accident · No injuriesClosedCessna 337C · Murray, KYSep 24, 1973 · N2531S · Substantial damageNTSB IAD74FLQ08Accident · Minor injuriesClosedPiper PA-36 · Russellville, KYSep 16, 1973 · N56444 · Substantial damageNTSB IAD74DLQ07Accident · No injuriesClosedBeech A23 · Owensboro, KYSep 9, 1973 · N3524R · Substantial damageNTSB IAD74AI018Accident · 4 fatalClosedCessna 310H · Paintsville, KYSep 9, 1973 · N1834H · DestroyedNTSB IAD74AI014Accident · 1 fatalClosedCessna 150 · Eddyville, KYAug 31, 1973 · N8052F · DestroyedNTSB IAD74FLQ06Accident · No injuriesClosedAeronca 7AC · Cromwell, KYAug 21, 1973 · N84156 · Substantial damageNTSB IAD74FLQ04Accident · No injuriesClosedSiai-Marche S.205 · Bardstown, KYAug 19, 1973 · N986WA · Substantial damageNTSB IAD74AI008Accident · 1 fatalClosedCessna 172 · Loretto, KYAug 1, 1973 · N6853A · DestroyedNTSB IAD74DLQ03Accident · No injuriesClosedMooney M20C · Paducah, KYJul 30, 1973 · N6600U · Substantial damageNTSB IAD74FLQ02Accident · 1 fatalClosedCessna 182C · Mt.Sterling, KYJul 20, 1973 · N8901T · Substantial damageNTSB IAD74AI004Accident · 2 fatalClosedNavion A · Henderson, KYJul 14, 1973 · N8620H · DestroyedNTSB IAD74FLQ01Accident · No injuriesClosedPiper PA-24 · Louisville, KYJul 10, 1973 · N5186P · Substantial damageNTSB IAD74DLQ05Accident · Minor injuriesClosedCessna 150 · Campbellsville, KYJul 7, 1973 · N4746X · Substantial damageNTSB IAD73FIQ35Accident · No injuriesClosedGreat Lakes 2T-1R · Louisville, KYJun 24, 1973 · N3290 · Substantial damageNTSB IAD73FLQ36Accident · Serious injuriesClosedAeronca 7AC · Paris, KYJun 18, 1973 · N3060E · Substantial damageNTSB IAD73AI018Accident · No injuriesClosedBeech E18S · Covington, KYJun 14, 1973 · N136C · 2 aircraft · Minor damageNTSB IAD73FLQ34Accident · Minor injuriesClosedCessna 150H · Park City, KYJun 9, 1973 · N23168 · DestroyedNTSB IAD73FLQ33Accident · No injuriesClosedBeech J35 · Lexington, KYJun 9, 1973 · N593B · Substantial damageNTSB IAD73FLQ31Accident · No injuriesClosedPine Air SV · Richmond, KYMay 22, 1973 · N4530V · Substantial damageNTSB IAD73FLQ32Accident · Serious injuriesClosedBeech B23 · Middlesboro, KYMay 18, 1973 · N7634R · Substantial damageNTSB IAD73FLQ30Accident · Minor injuriesClosedAeronca 7AC · Murray, KYMay 13, 1973 · N81941 · Substantial damageNTSB IAD73FLQ29Accident · No injuriesClosedCessna 172 · Falmouth, KYMay 13, 1973 · N7922G · Substantial damageNTSB IAD73FLQ27Accident · No injuriesClosedPiper PA-28 · Mayfield, KYMay 10, 1973 · N9923W · Substantial damageNTSB IAD73FLQ28Accident · No injuriesClosedCessna 172 · Kona, KYMay 3, 1973 · N7873G · Substantial damageNTSB IAD73ILQ26Accident · Serious injuriesClosedFly Baby 1-A · Greenville, KYApr 17, 1973 · N2207 · Substantial damageNTSB IAD73DLQ25Accident · No injuriesClosedCessna 305A · Bowling Green, KYApr 14, 1973 · N5314G · Substantial damageNTSB IAD73FLQ24Accident · Minor injuriesClosedSmith DSA-1 · Elizabethtown, KYApr 8, 1973 · N8890 · Substantial damageNTSB IAD73FLQ23Accident · No injuriesClosedCessna 210 · Henderson, KYMar 23, 1973 · N2216R · Substantial damageNTSB IAD73DLQ22Accident · No injuriesClosedErcoupe 415-C · Bardwell, KYFeb 23, 1973 · N93986 · Substantial damageNTSB CHI73FCQ21Accident · No injuriesClosedMooney M-10 · Springfield, KYFeb 18, 1973 · N9535V · Substantial damageNTSB CHI73ALQ20Accident · No injuriesClosedCessna 177RG · Lexington, KYFeb 11, 1973 · N1874Q · 2 aircraft · Minor damageNTSB CHI73AC065Accident · No injuriesClosedBeech C-45H · Louisville, KYJan 25, 1973 · N9863Z · Substantial damage