NTSB investigations, 1971, KY

180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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, 1971, 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\") = 1971
    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 CHI72FLQ22Accident · No injuriesClosedHughes 269B · Louisville, KYDec 4, 1971 · N9470F · Substantial damageNTSB CHI72DLQ23Accident · No injuriesClosedMitsubishi MU-2F · Bardstown, KYNov 24, 1971 · N180MA · Substantial damageNTSB CHI72FLQ21Accident · No injuriesClosedPiper PA-22 · Albany, KYNov 23, 1971 · N4440A · Substantial damageNTSB CHI72FLQ24Accident · 1 fatalClosedCessna 150H · Louisville, KYNov 16, 1971 · N7018S · Substantial damageNTSB CHI72FLQ20Accident · No injuriesClosedPiper PA-28 · Elizabethtown, KYNov 14, 1971 · N7254F · Substantial damageNTSB CHI72AC044Accident · No injuriesClosedAero Comdr 200-D · Louisville, KYNov 11, 1971 · N2913T · Substantial damageNTSB CHI72FLQ19Accident · No injuriesClosedCessna 150 · Hawesville, KYNov 10, 1971 · N1014M · Substantial damageNTSB CHI71AC025Accident · 2 fatalClosedLuscombe 8A · Hickman, KYOct 30, 1971 · N77830 · DestroyedNTSB CHI72FLQ17Accident · No injuriesClosedCessna 172 · Sturgis, KYOct 19, 1971 · N78799 · Substantial damageNTSB CHI72FLQ16Accident · Minor injuriesClosedChampion 7GCBC · Independence, KYOct 6, 1971 · N9118L · Substantial damageNTSB CHI72FLQ18Accident · Serious injuriesClosedCessna 182B · Frankfort, KYOct 4, 1971 · N2432G · DestroyedNTSB CHI72FLQ15Accident · Serious injuriesClosedCessna A188 · Utica, KYOct 2, 1971 · N3531Q · DestroyedNTSB CHI72AC028Accident · 1 fatalClosedPiper PA-28 · Adolphus, KYSep 25, 1971 · N9935W · DestroyedNTSB CHI72DLQ14Accident · No injuriesClosedPiper PA-18 · Fort Knox, KYSep 22, 1971 · N4220A · Substantial damageNTSB CHI72FLQ13Accident · No injuriesClosedCessna 310N · Danville, KYSep 14, 1971 · N5030Q · Substantial damageNTSB CHI72FLQ05Accident · No injuriesClosedGraham SM51 · Bardstown, KYSep 12, 1971 · N2793 · Substantial damageNTSB CHI72FLQ10Accident · Serious injuriesClosedCessna 150H · Hazard, KYSep 10, 1971 · N7023S · DestroyedNTSB CHI72FLQ08Accident · Minor injuriesClosedBell 47G4A · Shelbyville, KYSep 10, 1971 · N4088G · Substantial damageNTSB CHI72FLQ09Accident · No injuriesClosedLuscombe 8E · Frankfort, KYSep 6, 1971 · N1929K · Substantial damageNTSB CHI72FLQ03Accident · No injuriesClosedCessna 120 · Shepherdsville, KYAug 29, 1971 · N2224N · Substantial damageNTSB CHI72FLQ04Accident · No injuriesClosedPiper PA-28 · Somerset, KYAug 24, 1971 · N7977N · Substantial damageNTSB CHI72DLQ11Accident · No injuriesClosedCessna A188 · Owensboro, KYAug 23, 1971 · N3531Q · Substantial damageNTSB CHI72DLQ12Accident · Serious injuriesClosedAeronca 7AC · Baxter, KYAug 22, 1971 · N84852 · Substantial damageNTSB CHI72DLQ06Accident · No injuriesClosedCessna 182E · Rockport, KYAug 19, 1971 · N3068Y · Substantial damageNTSB CHI72AC014Accident · 2 fatalClosedPiper PA-24 · Bardstown, KYAug 14, 1971 · N7883P · 2 aircraft · Minor damageNTSB CHI72FLQ01Accident · No injuriesClosedBeech 65-88 · Louisville, KYAug 10, 1971 · N8833B · Substantial damageNTSB CHI72AC011Accident · 4 fatalClosedPiper PA-24 · Richardson, KYAug 1, 1971 · N8969P · DestroyedNTSB CHI72DLQ02Accident · No injuriesClosedPiper PA-22 · Russell Sprgs, KYJul 19, 1971 · N7030B · Substantial damageNTSB CHI72DLQ07Accident · No injuriesClosedPiper PA-30 · Cave City, KYJul 4, 1971 · N8410Y · Substantial damageNTSB CHI71FLQ31Accident · Minor injuriesClosedPiper PA-28R · Carrollton, KYJun 30, 1971 · N5081S · Substantial damageNTSB CHI71FLQ29Accident · No injuriesClosedBell 47G4A · Utica, KYJun 19, 1971 · N4088G · DestroyedNTSB CHI71FLQ25Accident · No injuriesClosedCessna 150K · New Haven, KYJun 12, 1971 · N6045G · Substantial damageNTSB CHI71FLQ27Accident · Minor injuriesClosedNavion 4 · Berea, KYJun 10, 1971 · N91630 · DestroyedNTSB CHI71FLQ26Accident · No injuriesClosedBeech T-34A · Louisville, KYJun 5, 1971 · N94595 · Substantial damageNTSB CHI71FLQ30Accident · No injuriesClosedCessna 175 · Junction City, KYJun 3, 1971 · N7119M · Substantial damageNTSB CHI72AC085Accident · 2 fatalClosedBeech P35 · Chaplin, KYMay 27, 1971 · N9734Y · DestroyedNTSB CHI71FLQ24Accident · No injuriesClosedAero Comdr A-9 · Morganfield, KYMay 15, 1971 · N7712V · DestroyedNTSB CHI71AC084Accident · Serious injuriesClosedBoeing 727 · York, KYMay 14, 1971 · N8131N · No damageNTSB MIA71DLT15Accident · No injuriesClosedCessna 150 · Whitesville, KYMay 9, 1971 · N6245G · Substantial damageNTSB CHI71FLQ22Accident · No injuriesClosedCessna 150 · Lexington, KYMay 2, 1971 · N8744S · Substantial damageNTSB CHI71FLQ23Accident · No injuriesClosedVolksplane VP-1 · Louisville, KYApr 24, 1971 · N33GB · DestroyedNTSB CHI71AC077Accident · 2 fatalClosedBeech 95-B55 · Bledsoe, KYApr 13, 1971 · N474RM · DestroyedNTSB CHI71FLQ21Accident · No injuriesClosedBede BD-4 · Louisville, KYMar 30, 1971 · N400BD · Substantial damageNTSB CHI71AC069Accident · No injuriesClosedPiper PA-28 · Louisville, KYMar 29, 1971 · N8878J · DestroyedNTSB CHI71FLQ20Accident · No injuriesClosedPiper PA-28 · Fort Knox, KYFeb 25, 1971 · N9452J · Substantial damageNTSB CHI71FLQ17Accident · Minor injuriesClosedAeronca 7AC · Stanton, KYFeb 14, 1971 · N82873 · Substantial damageNTSB CHI71FLQ16Accident · Minor injuriesClosedBeech C50 · Litchfield, KYFeb 8, 1971 · N3649B · DestroyedNTSB CHI71FLQ18Accident · No injuriesClosedCessna 172K · Edmonton, KYFeb 1, 1971 · N84558 · Substantial damageNTSB CHI71AC056Accident · 1 fatalClosedCessna 172G · Chevrolet, KYJan 30, 1971 · N4356L · DestroyedNTSB NYC71DFA37Accident · No injuriesClosedCessna 172K · Louisville, KYJan 16, 1971 · N7338G · Substantial damage