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 IAD76AI022Accident · 1 fatalClosedPiper PA-32 · Hindman, KYSep 24, 1975 · N15292 · Destroyed NTSB IAD76DLQ08Accident · Serious injuriesClosedOsprey 1-V · Paducah, KYSep 13, 1975 · N12JV · Destroyed NTSB IAD76DLQ07Accident · No injuriesClosedHughes 269C · Campton, KYAug 22, 1975 · N9605 · Destroyed NTSB IAD76DLQ06Accident · Minor injuriesClosedPiper PA-28 · Lake City, KYAug 4, 1975 · N9621W · Substantial damage NTSB IAD76FLQ04Accident · Minor injuriesClosedStinson V-77 · Cave City, KYAug 2, 1975 · N9360H · Destroyed NTSB IAD76FLQ03Accident · Serious injuriesClosedBellanca 17-31 · Louisville, KYJul 13, 1975 · N100BV · Substantial damage NTSB IAD7LFLQ02Accident · No injuriesClosedAero Comdr 100 · Franklin, KYJul 6, 1975 · N3762X · Substantial damage NTSB IAD76AI001Accident · 2 fatalClosedAeronca 058B · Pikeville, KYJul 5, 1975 · N52354 · Destroyed NTSB IAD76FLQ01Accident · No injuriesClosedBeech J35 · Sparta, KYJul 1, 1975 · N3066C · Substantial damage NTSB IAD75FLQ25Accident · Serious injuriesClosedCessna 170A · California, KYJun 29, 1975 · N9288A · Substantial damage NTSB IAD75AI063Accident · No injuriesClosedCessna 320B · Bowling Green, KYJun 6, 1975 · N551X · Substantial damage NTSB IAD7KDLQ26Accident · No injuriesClosedCessna 150 · Versailles, KYMay 18, 1975 · N10770 · Substantial damage NTSB IAD75DLQ24Accident · No injuriesClosedCessna 182 · Russell Spgs, KYMay 14, 1975 · N71773 · Substantial damage NTSB IAD75FLQ22Accident · Serious injuriesClosedPiper PA-28 · Berea, KYMay 13, 1975 · N32519 · Substantial damage NTSB IAD75DLQ23Accident · No injuriesClosedBeech A23 · Mannington, KYMay 5, 1975 · N3666Q · Substantial damage NTSB IAD75FLQ21Accident · No injuriesClosedPiper PA-25 · Skylight, KYApr 26, 1975 · N6062Z · Substantial damage NTSB IAD75FLQ20Accident · Serious injuriesClosedVolksplane VP-1 · Utica, KYApr 22, 1975 · N39WA · Substantial damage NTSB IAD75FLQ19Accident · Serious injuriesClosedHughes 369 · Allen, KYMar 21, 1975 · N9007F · Destroyed NTSB IAD75FLQ18Accident · No injuriesClosedHughes 369HS · Mt Sterling, KYMar 10, 1975 · N9114F · Substantial damage NTSB IAD75FLQ17Accident · No injuriesClosedAero Comdr 500B · Louisville, KYMar 3, 1975 · N6399U · Substantial damage NTSB IAD75AI049Accident · 1 fatalClosedAero Comdr 500S · S Portsmouth, KYFeb 21, 1975 · N9179N · Destroyed NTSB IAD75DLQ14Accident · Minor injuriesClosedMooney M20 · Pine Knot, KYFeb 8, 1975 · N9653M · Substantial damage NTSB IAD75FLQ16Accident · No injuriesClosedCessna 150 · Georgetown, KYFeb 7, 1975 · N6557S · Substantial damage NTSB IAD75II046Incident · No injuriesClosedBeech 55 · Hazard, KYJan 29, 1975 · N77RR · Minor damage NTSB IAD75DLQ13Accident · No injuriesClosedCessna 172 · Albany, KYJan 17, 1975 · N2315U · Substantial damage NTSB IAD75AI041Accident · 3 fatalClosedPiper PA-28R · Paintsville, KYJan 12, 1975 · N2699R · Destroyed NTSB IAD75DLQ12Accident · No injuriesClosedBeech 23 · Gilbertsville, KYJan 9, 1975 · N9771L · Substantial damage NTSB IAD75FLQ11Accident · Serious injuriesClosedAero Comdr 500B · Paducah, KYDec 29, 1974 · N553HH · Substantial damage NTSB IAD75DLQ10Accident · No injuriesClosedCessna 150 · Paducah, KYDec 14, 1974 · N60391 · Substantial damage NTSB IAD75FLQ09Accident · Minor injuriesClosedCessna 150J · Owensboro, KYNov 28, 1974 · N50969 · Substantial damage NTSB IAD75DLQ08Accident · No injuriesClosedCessna 180 · Sandy Hook, KYOct 9, 1974 · N2428C · Substantial damage NTSB IAD75AI019Accident · 1 fatalClosedCessna 182 · Relief, KYOct 6, 1974 · N84311 · Substantial damage NTSB IAD75FLQ05Accident · Minor injuriesClosedCessna 210K · Joy, KYAug 18, 1974 · N8213M · Destroyed NTSB IAD75DLQ06Accident · No injuriesClosedCessna 188 · Owensboro, KYAug 10, 1974 · N5689J · Substantial damage NTSB IAD75FLQ04Accident · Minor injuriesClosedCessna 182A · Bowling Green, KYAug 6, 1974 · N2196G · Substantial damage NTSB IAD75ALQ03Accident · Minor injuriesClosedBell 47D1 · Clinton, KYJul 19, 1974 · N8282E · Substantial damage NTSB IAD75FLQ02Accident · No injuriesClosedHughes 269B · Dreyfus, KYJul 7, 1974 · N9467F · Destroyed NTSB IAD75FLQ01Accident · No injuriesClosedCessna 140 · Symsonia, KYJul 6, 1974 · N73052 · Destroyed NTSB IAD74FLQ40Accident · Minor injuriesClosedPiper PA-22 · Elizabethtown, KYJun 29, 1974 · N1928P · Substantial damage NTSB IAD74FLQ42Accident · 1 fatalClosedAeronca 7GCA · Allensville, KYJun 26, 1974 · N268S · Destroyed NTSB IAD74FL043Accident · No injuriesClosedPiper PA-28 · Cynthiana, KYJun 22, 1974 · N563FL · Substantial damage NTSB NYC74AN111Accident · 1 fatalClosedAmer Avco AA1-B · Prospect, KYJun 19, 1974 · N6274L · Destroyed NTSB IAD74FLQ39Accident · No injuriesClosedCessna 180 · Bowling Green, KYJun 12, 1974 · N3196C · Substantial damage NTSB IAD74FLQ38Accident · Minor injuriesClosedMooney M20C · Clarkson, KYJun 10, 1974 · N7173U · Substantial damage NTSB NYC74AN102Accident · 3 fatalClosedBeech 35 · Hopkinsville, KYJun 5, 1974 · N2939V · Destroyed NTSB NYC74AN099Accident · 1 fatalClosedBeech P35 · Verne, KYJun 1, 1974 · N1547S · Destroyed NTSB IAD74DLQ41Accident · No injuriesClosedCessna 150 · Richmond, KYMay 30, 1974 · N51218 · Substantial damage NTSB IAD74FLQ35Accident · No injuriesClosedAmer Avco AA-5 · Louisville, KYMay 29, 1974 · N5442L · Substantial damage NTSB IAD74DLQ36Accident · Minor injuriesClosedErco 415-C · Centertown, KYMay 29, 1974 · N3474H · Substantial damage NTSB IAD74DLQ37Accident · No injuriesClosedPiper PA-28 · Monticello, KYMay 27, 1974 · N55605 · Substantial damage