Skip to content

NTSB investigations, KY

180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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 CHI67F0119Accident · Minor injuriesClosedCessna 172 · Shelbyville, KYAug 7, 1966 · N8590B · Substantial damage NTSB CHI67D0246Accident · No injuriesClosedPiper PA-24 · Lancaster, KYJul 16, 1966 · N5557P · Substantial damage NTSB CHI67D0074Accident · No injuriesClosedPiper J-3 · Columbia, KYJul 9, 1966 · N6104H · Substantial damage NTSB CHI67A0005Accident · No injuriesClosedBell 47G-2A · Slemp, KYJul 9, 1966 · N73219 · Substantial damage NTSB CHI67I0003Incident · No injuriesClosedNord 262 · Erlanger, KYJul 7, 1966 · N26210 · Minor damage NTSB CHI67D0149Accident · No injuriesClosedCessna 210 · Glasgow, KYJul 4, 1966 · N4907U · Substantial damage NTSB CHI66F0776Accident · No injuriesClosedPiper PA23 · Louisville, KYJun 13, 1966 · N1258P · Substantial damage NTSB CHI66A0093Accident · 1 fatalClosedBoeing B75N1 · Franklin, KYMay 28, 1966 · N4629N · Destroyed NTSB CHI66D0737Accident · No injuriesClosedPiper PA-22 · Flemingsburg, KYApr 29, 1966 · N3647Z · Substantial damage NTSB CHI66D0710Accident · No injuriesClosedCessna 310 · Lexington, KYApr 28, 1966 · N3056D · Substantial damage NTSB CHI66D0713Accident · Minor injuriesClosedCessna 172E · Albany, KYApr 7, 1966 · N5737T · Destroyed NTSB CHI66D0655Accident · No injuriesClosedBeech V35 · Mt Sterling, KYApr 1, 1966 · N2073W · Substantial damage NTSB CHI66A0071Accident · 2 fatalClosedBeech J35 · Corinth, KYMar 2, 1966 · N8354D · Destroyed NTSB CHI66A0069Accident · 2 fatalClosedPiper PA-22 · London, KYFeb 19, 1966 · N6750B · Destroyed NTSB CHI66F0564Accident · No injuriesClosedBeechcraft G35 · Manchester, KYFeb 6, 1966 · N4297D · Substantial damage NTSB CHI66D0525Accident · No injuriesClosedBeechcraft A35 · Cynthiana, KYJan 11, 1966 · N275H · Substantial damage NTSB CHI66D0519Accident · No injuriesClosedCessna 150 · Russelville, KYJan 9, 1966 · N5986E · Substantial damage NTSB CHI66A0061Accident · 2 fatalClosedCessna 182G · Maysville, KYJan 4, 1966 · N2141R · Destroyed NTSB CHI66F0502Accident · No injuriesClosedBeechcraft B55 · Paducah, KYDec 24, 1965 · N5812S · Substantial damage NTSB CHI66A0057Accident · 2 fatalClosedCessna 172 · Stone, KYDec 10, 1965 · N3947S · Destroyed NTSB CHI66A0056Accident · 6 fatalClosedAero CDR 680 · Kite, KYDec 6, 1965 · N6819S · Destroyed NTSB CHI66F0489Accident · No injuriesClosedBeechcraft B-95 · Gilbertsville, KYDec 3, 1965 · N962T · Substantial damage NTSB CHI66F0404Accident · No injuriesClosedBeech C35 · Georgetown, KYNov 13, 1965 · N1950D · Substantial damage NTSB DCA66A0003Accident · 58 fatalClosedBoeing B-727 · Constance, KYNov 8, 1965 · N1996 · Destroyed NTSB CHI66F0396Accident · No injuriesClosedCessna 172 · Lexington, KYNov 7, 1965 · N5681T · Substantial damage NTSB CHI66A0043Accident · 3 fatalClosedBeech 35 · Reed, KYOct 24, 1965 · N443B · Destroyed NTSB CHI66D0393Accident · No injuriesClosedCessna 182 · Golden Pond, KYOct 9, 1965 · N8483S · Substantial damage NTSB CHI66F0326Accident · No injuriesClosedPiper PA-28 · Fulton, KYOct 8, 1965 · N8711W · Substantial damage NTSB CHI66F0383Accident · No injuriesClosedBeechcraft 95 · Louisville, KYOct 5, 1965 · N2740Y · Substantial damage NTSB CHI66F0335Accident · Minor injuriesClosedAeronca 7AC · Poplar Plains, KYOct 3, 1965 · N84001 · Destroyed NTSB CHI66D0320Accident · No injuriesClosedCessna 210 · Munfordville, KYSep 28, 1965 · N3656Y · Substantial damage NTSB CHI66A0025Accident · 1 fatalClosedDouglas DC3 · Louisville, KYSep 10, 1965 · N272R · 2 aircraft · Substantial damage NTSB CHI66F0210Accident · No injuriesClosedTaylorcraft BC12-D · Richardville, KYSep 6, 1965 · N44133 · Substantial damage NTSB CHI66F0302Accident · No injuriesClosedMooney M20C · Owensboro, KYSep 1, 1965 · N6487U · Substantial damage NTSB CHI66F0200Accident · No injuriesClosedCessna 175 · Somerset, KYAug 15, 1965 · N7104 · Destroyed NTSB CHI66F0148Accident · No injuriesClosedPiper PA-28 · Georgetown, KYJul 31, 1965 · N5873W · Substantial damage NTSB CHI66F0139Accident · Serious injuriesClosedPiper PA-22 · Golden Pond, KYJul 30, 1965 · N9224D · Substantial damage NTSB CHI66F0100Accident · No injuriesClosedPiper PA-25 · Melber, KYJul 26, 1965 · N6251Z · Substantial damage NTSB CHI66A0010Accident · No injuriesClosedHughes 269A-1 · Lynch, KYJul 26, 1965 · N8938F · Substantial damage NTSB CHI66D0084Accident · No injuriesClosedCessna 182 · Greenville, KYJul 16, 1965 · N5155D · Substantial damage NTSB CHI66F0083Accident · No injuriesClosedPiper PA-24 · Winchester, KYJul 7, 1965 · N7522P · Substantial damage NTSB UNK65X1514Accident · No injuriesClosedCessna 170 · West Liberty, KYJul 5, 1965 · N3836V · Substantial damage NTSB CHI66F0044Accident · Serious injuriesClosedCessna 170B · Herndon, KYJul 5, 1965 · N2276D · Destroyed NTSB CHI66A0004Accident · 1 fatalClosedAeronca 7AC · Pulaski, KYJul 5, 1965 · N2009E · Destroyed NTSB CHI66F0079Accident · No injuriesClosedPiper PA-22 · Columbia, KYJul 4, 1965 · N4550A · Substantial damage NTSB CHI66F0063Accident · No injuriesClosedMooney M20C · Paintsville, KYJun 26, 1965 · N5651Q · Substantial damage NTSB CHI66F0001Accident · No injuriesClosedPiper PA-24 · Louisville, KYJun 24, 1965 · N6780P · Substantial damage NTSB CHI66F0024Accident · No injuriesClosedPiper PA-28B · Murray, KYJun 12, 1965 · N5633W · Substantial damage NTSB CHI66F0039Accident · No injuriesClosedAeronca 7AC · Water Valley, KYJun 7, 1965 · N7556E · Substantial damage NTSB CHI65A0099Accident · 2 fatalClosedBeechcraft K35 · Whitesburg, KYJun 2, 1965 · N129JD · Destroyed