Skip to content

NTSB investigations, 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases, newest first

Query with SQL

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 c."eventStateOrRegion" = 'KY' AND c."eventCountry" = 'USA' ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 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.

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 c."eventStateOrRegion" = 'KY' AND c."eventCountry" = 'USA'
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

NTSB IAD77DLQ04Accident · Minor injuriesClosedCessna 150 · Trenton, KYDec 22, 1976 · N11269 · Destroyed NTSB IAD77DLQ03Accident · Minor injuriesClosedCessna 175 · Middlesboro, KYDec 14, 1976 · N7244M · Substantial damage NTSB IAD77FA014Accident · 4 fatalClosedPiper PA-23 · Lexington, KYNov 28, 1976 · N4423P · Destroyed NTSB IAD77FLQ02Accident · No injuriesClosedCessna 150 · Hopkinsville, KYOct 16, 1976 · N23270 · Substantial damage NTSB IAD77FA001Accident · 1 fatalClosedCessna 182 · Hudson, KYOct 2, 1976 · N2907Y · Destroyed NTSB IAD76FLQ01Accident · No injuriesClosedGrumman G-164A · Elkton, KYOct 1, 1976 · N5401 · Destroyed NTSB IAD76FLQ36Accident · No injuriesClosedMitsubishi MU-2B · Louisville, KYSep 29, 1976 · N122G · Substantial damage NTSB IAD76DLQ33Accident · Minor injuriesClosedDehavilland MK23 · Chavies, KYSep 29, 1976 · N31105 · Substantial damage NTSB IAD76AI101Accident · Minor injuriesClosedRepublic RC-3 · Danville, KYSep 25, 1976 · N6468K · Destroyed NTSB IAD76DLQ35Accident · No injuriesClosedGrumman G-164 · Elkton, KYSep 14, 1976 · N463Y · Destroyed NTSB IAD76DLQ32Accident · No injuriesClosedAmerican AA-1 · Murray, KYAug 28, 1976 · N5745L · Substantial damage NTSB IAD76DIJ17Accident · Minor injuriesClosedCessna 182 · Kimball, KYAug 25, 1976 · N91688 · Destroyed NTSB IAD76DLQ31Accident · No injuriesClosedPiper PA-28 · Frakes, KYAug 21, 1976 · N7709W · Substantial damage NTSB IAD76II093Incident · No injuriesClosedBeech B99 · Owensboro, KYAug 13, 1976 · N12AK · No damage NTSB IAD76FLQ34Accident · Minor injuriesClosedCessna 175 · Bedford, KYAug 11, 1976 · N8152T · Substantial damage NTSB IAD76DLQ30Accident · No injuriesClosedCessna 182 · Covington, KYAug 10, 1976 · N2766F · Substantial damage NTSB IAD76FLQ37Accident · 1 fatalClosedPitts S-1S · Owensboro, KYJul 30, 1976 · N7PJ · Destroyed NTSB IAD76AI085Accident · 1 fatalClosedGrum Amer AA-5A · Lexington, KYJul 22, 1976 · N9778U · Destroyed NTSB IAD76DLQ29Accident · No injuriesClosedPiper PA-25 · Smithland, KYJul 12, 1976 · N8641L · Substantial damage NTSB IAD76DLQ27Accident · No injuriesClosedPiper PA-28 · Williamsburg, KYJul 8, 1976 · N44534 · Substantial damage NTSB IAD76AI081Accident · 3 fatalClosedCessna 150 · Elkhorn City, KYJul 4, 1976 · N9238U · Substantial damage NTSB IAD76DLQ25Accident · No injuriesClosedCessna 150 · Hodgenville, KYJul 3, 1976 · N10660 · Substantial damage NTSB IAD76FLQ26Accident · Serious injuriesClosedPiper PA-18A · Albany, KYJul 1, 1976 · N3589A · Substantial damage NTSB IAD76DLQ28Accident · No injuriesClosedCessna 150 · Cynthiana, KYJun 26, 1976 · N8621J · 2 aircraft · Minor damage NTSB IAD76FLQ24Accident · Serious injuriesClosedPiper PA-24 · Cold Springs, KYJun 20, 1976 · N6232P · Substantial damage NTSB IAD76AI076Accident · 2 fatalClosedPiper PA-23 · West Liberty, KYJun 12, 1976 · N852PS · Destroyed NTSB IAD76FLQ23Accident · No injuriesClosedPiper PA-28 · Richmond, KYJun 5, 1976 · N32219 · Substantial damage NTSB IAD76DLQ22Accident · No injuriesClosedBeech C35 · Bronston, KYMay 24, 1976 · N631Z · Substantial damage NTSB IAD76AI074Accident · 2 fatalClosedCassutt IIM · Sturgis, KYMay 23, 1976 · N18PM · 2 aircraft · Destroyed NTSB IAD76AI072Accident · 2 fatalClosedAerostar 600 · Morganfield, KYMay 8, 1976 · N7549S · Destroyed NTSB IAD76AI071Accident · 1 fatalClosedPiper PA-24 · Farmers, KYMay 6, 1976 · N6026P · Destroyed NTSB IAD76FLQ21Accident · No injuriesClosedPiper PA-28 · Jeffersontown, KYMay 1, 1976 · N7214F · Substantial damage NTSB IAD76FLQ20Accident · No injuriesClosedPiper PA-31P · Paintsville, KYApr 27, 1976 · N6845L · Substantial damage NTSB IAD76DLQ19Accident · No injuriesClosedMooney M20 · Whitesburg, KYApr 24, 1976 · N7462V · Substantial damage NTSB IAD76FLQ18Accident · No injuriesClosedPiper PA-34 · Lexington, KYApr 20, 1976 · N55322 · Substantial damage NTSB IAD76FLQ17Accident · Minor injuriesClosedPiper PA-32 · Louisville, KYApr 6, 1976 · N711PF · Substantial damage NTSB IAD76FLQ16Accident · Minor injuriesClosedCessna 140 · Bardstown, KYMar 18, 1976 · N2216N · Substantial damage NTSB IAD76AI061Accident · 1 fatalClosedBeech C23 · Owensboro, KYMar 9, 1976 · N2162W · Destroyed NTSB IAD76DLQ14Accident · No injuriesClosedMine-Copter R100 · Pikeville, KYFeb 20, 1976 · N2137 · Substantial damage NTSB IAD76FLQ13Accident · No injuriesClosedCessna 172D · Lexington, KYFeb 10, 1976 · N2765U · Substantial damage NTSB IAD76AI049Accident · Serious injuriesClosedBeech E18S · Ft Campbell, KYJan 13, 1976 · N218A · Substantial damage NTSB IAD76FLQ12Accident · No injuriesClosedPiper PA-28 · Elizabethtown, KYJan 3, 1976 · N32288 · Substantial damage NTSB IAD76AI045Accident · 1 fatalClosedMooney M20E · Mt Olivet, KYDec 28, 1975 · N1263X · Destroyed NTSB IAD76II041Incident · No injuriesClosedDouglas DC-3C · Louisville, KYDec 15, 1975 · N45 · Minor damage NTSB IAD76FLQ11Accident · No injuriesClosedCessna 172 · Paris, KYDec 7, 1975 · N5635R · Substantial damage NTSB IAD76AI025Accident · No injuriesClosedBeech E18S · Lexington, KYNov 17, 1975 · N5611D · Substantial damage NTSB IAD76FLQ10Accident · No injuriesClosedPiper PA-22 · Lagrange, KYNov 15, 1975 · N6161D · Substantial damage NTSB IAD76FLQ09Accident · No injuriesClosedCessna 150L · Olmstead, KYOct 13, 1975 · N1295Q · Substantial damage NTSB IAD76AI018Accident · 1 fatalClosedCessna 150L · Louisville, KYSep 30, 1975 · N5370Q · Destroyed NTSB IAD76FLQ05Accident · Serious injuriesClosedCessna 177A · London, KYSep 29, 1975 · N30388 · Substantial damage