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 CHI70F0387Accident · Serious injuriesClosedCessna 150 · Lebanon, KYDec 8, 1969 · N3669J · Destroyed NTSB CHI70F0378Accident · Serious injuriesClosedCessna 172 · Ford, KYNov 20, 1969 · N84173 · Destroyed NTSB MKC70A0026Accident · 1 fatalClosedCessna 182 · Elizabethtown, KYNov 9, 1969 · N6475A · Destroyed NTSB CHI70F0329Accident · No injuriesClosedCessna 150 · Cherokee Sta, KYNov 8, 1969 · N22664 · Substantial damage NTSB CHI70A0031Accident · 6 fatalClosedPiper PA-32 · Jonestown, KYNov 8, 1969 · N3668W · Destroyed NTSB CHI70D0269Accident · No injuriesClosedPiper PA-22 · Walsh, KYOct 4, 1969 · N4677Z · Substantial damage NTSB CHI70D0277Accident · No injuriesClosedCessna 177 · Columbia, KYOct 3, 1969 · N3248T · Substantial damage NTSB CHI70D0327Accident · Serious injuriesClosedCessna 150 · Columbia, KYSep 28, 1969 · N7771F · Destroyed NTSB CHI70D0268Accident · No injuriesClosedPiper PA-25 · Lynnville, KYSep 25, 1969 · N7260Z · Substantial damage NTSB CHI70D0024Accident · No injuriesClosedCessna 150 · Louisville, KYSep 15, 1969 · N5747G · Substantial damage NTSB CHI70D0216Accident · No injuriesClosedPiper PA-28 · Georgetown, KYSep 5, 1969 · N8477W · Substantial damage NTSB CHI70F0239Accident · Minor injuriesClosedPiper PA-28 · Frankfort, KYSep 3, 1969 · N1514J · Substantial damage NTSB CHI70F0245Accident · No injuriesClosedErco 415-C · Berea, KYSep 2, 1969 · N2806H · Substantial damage NTSB CHI70F0189Accident · Minor injuriesClosedCessna 175A · Columbia, KYAug 17, 1969 · N6940E · Substantial damage NTSB CHI70F0169Accident · Minor injuriesClosedDehavilland DHC1B2 · Henderson, KYAug 15, 1969 · N280S · Substantial damage NTSB CHI70F0166Accident · Minor injuriesClosedCassutt HL-1 · Henderson, KYAug 15, 1969 · N4651T · Substantial damage NTSB CHI70D0172Accident · No injuriesClosedHughes 269B · Paint Lick, KYAug 10, 1969 · N9467F · Substantial damage NTSB CHI70D0178Accident · No injuriesClosedCessna 150 · Owensboro, KYAug 7, 1969 · N6367S · Substantial damage NTSB CHI70D0180Accident · No injuriesClosedPiper PA-28R · Denniston, KYAug 3, 1969 · N7483J · Substantial damage NTSB CHI70D0165Accident · No injuriesClosedCessna 210 · Lexington, KYJul 29, 1969 · N9578T · Substantial damage NTSB CHI70F0199Accident · Minor injuriesClosedCessna 177 · Shelbyville, KYJul 28, 1969 · N29557 · Destroyed NTSB CHI70F0171Accident · Serious injuriesClosedPiper PA-23 · Corbin, KYJul 22, 1969 · N4754P · Substantial damage NTSB CHI70F0181Accident · No injuriesClosedPiper PA-25 · Harrodsburg, KYJul 12, 1969 · XB-VUU · Substantial damage NTSB CHI70D0068Accident · No injuriesClosedRyan ST-3KR · Bowling Green, KYJul 6, 1969 · N54403 · Substantial damage NTSB CHI70D0124Accident · No injuriesClosedCessna 182 · Fulton, KYJul 4, 1969 · N2922F · Substantial damage NTSB CHI70A0001Accident · 2 fatalClosedPiper PA-18 · Lagrange, KYJul 3, 1969 · N5976Z · Destroyed NTSB CHI70F0081Accident · No injuriesClosedPiper PA-30 · Owensboro, KYJun 19, 1969 · N8760Y · Substantial damage NTSB CHI70D0056Accident · No injuriesClosedBell 47G-4A · Cumberland, KYJun 19, 1969 · N520PA · Substantial damage NTSB CHI70D0010Accident · No injuriesClosedRepublic RC-3 · Albany, KYJun 8, 1969 · N6011K · Substantial damage NTSB CHI70D0023Accident · No injuriesClosedPiper PA-28 · Hardinsburg, KYJun 7, 1969 · N1520J · Substantial damage NTSB CHI70D0021Accident · No injuriesClosedPiper J3C-65 · Shepherdsville, KYJun 4, 1969 · N6719H · Substantial damage NTSB CHI70F0008Accident · Serious injuriesClosedCessna 150 · Lexington, KYMay 28, 1969 · N50829 · Destroyed NTSB CHI69D0669Accident · Minor injuriesClosedCessna 150H · Middletown, KYMay 13, 1969 · N22373 · Substantial damage NTSB CHI70F0002Accident · No injuriesClosedMooney M20F · Waddy, KYMay 12, 1969 · N3292F · Substantial damage NTSB CHI69F0658Accident · Minor injuriesClosedCessna 210-5 · Fort Knox, KYMay 10, 1969 · N8342Z · Destroyed NTSB CHI69I0093Incident · No injuriesClosedFairchild FH-227 · Ashland, KYMay 9, 1969 · N708U · Minor damage NTSB CHI70F0004Accident · No injuriesClosedCallair A-9 · Cayce, KYMay 5, 1969 · N3583G · Substantial damage NTSB CHI69I0091Incident · No injuriesClosedBeech D18S · Lexington, KYMay 5, 1969 · N57CC · Minor damage NTSB CHI70D0001Accident · No injuriesClosedCessna 140 · Shepherdsville, KYMay 4, 1969 · N3598V · Substantial damage NTSB CHI69A0089Accident · 1 fatalClosedCessna 150 · Prospect, KYApr 30, 1969 · N8498G · Destroyed NTSB CHI69F0592Accident · No injuriesClosedCessna 172 · Somerset, KYApr 25, 1969 · N3943S · Substantial damage NTSB CHI69D0644Accident · No injuriesClosedPiper PA-18 · Henderson, KYApr 16, 1969 · N3294Z · Substantial damage NTSB CHI69F0583Accident · Minor injuriesClosedCessna 140 · West Paducah, KYApr 12, 1969 · N72616 · Destroyed NTSB CHI69F0561Accident · Minor injuriesClosedCessna 172I · Florence, KYApr 11, 1969 · N35582 · Substantial damage NTSB CHI69A0080Accident · 1 fatalClosedPiper PA-23 · Bowling Green, KYMar 12, 1969 · N3017P · Destroyed NTSB CHI69F0553Accident · No injuriesClosedBeech 65-80 · Louisville, KYMar 5, 1969 · N503SB · Substantial damage NTSB CHI69F0380Accident · Minor injuriesClosedAero Comdr 500-A · Paducah, KYNov 27, 1968 · N9381R · Destroyed NTSB CHI69D0478Accident · No injuriesClosedCessna 150 · Pikeville, KYNov 26, 1968 · N2981S · Substantial damage NTSB CHI69F0361Accident · No injuriesClosedMooney M20E · Louisville, KYNov 17, 1968 · N5731Q · Substantial damage NTSB CHI69D0352Accident · Minor injuriesClosedBensen B8M · Gilbertsville, KYNov 10, 1968 · N336Y · Destroyed