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 CHI68D0527Accident · No injuriesClosedPiper PA-28 · Georgetown, KYDec 24, 1967 · N5873W · Substantial damage NTSB DCA68A0002Accident · 69 fatalClosedConvair 880 · Constance, KYNov 20, 1967 · N821TW · Destroyed NTSB CHI68F0494Accident · No injuriesClosedBeech C-18 · Cynthiana, KYNov 19, 1967 · N75595 · Substantial damage NTSB CHI68A0046Accident · 3 fatalClosedCessna 172E · Jamestown, KYNov 19, 1967 · N5460T · Destroyed NTSB CHI68A0043Accident · 1 fatalClosedBoeing 707 · Erlanger, KYNov 6, 1967 · N742TW · Destroyed NTSB CHI68F0376Accident · No injuriesClosedBeech D18S · Erlanger, KYOct 5, 1967 · N117J · Substantial damage NTSB CHI68F0330Accident · No injuriesClosedNavion A · Louisville, KYSep 30, 1967 · N4222K · Destroyed NTSB CHI68F0323Accident · Minor injuriesClosedBeech 35 · Mentor, KYSep 24, 1967 · N9662H · Substantial damage NTSB CHI68D0299Accident · No injuriesClosedPiper PA-22 · Worthington, KYSep 24, 1967 · N4882Z · Substantial damage NTSB CHI68D0261Accident · No injuriesClosedAero Comdr 500-U · Bowling Green, KYSep 5, 1967 · N213RC · Substantial damage NTSB CHI68F0301Accident · No injuriesClosedMooney M20C · Hazard, KYSep 1, 1967 · N2553W · Substantial damage NTSB CHI68F0244Accident · No injuriesClosedBeech 95C-55 · Lexington, KYAug 13, 1967 · N3738Q · Substantial damage NTSB CHI68F0212Accident · No injuriesClosedBeech A23 · Lexington, KYJul 23, 1967 · N2323W · Substantial damage NTSB CHI68F0203Accident · No injuriesClosedGrumman G-164A · Golden Pond, KYJul 18, 1967 · N632U · Destroyed NTSB CHI68A0016Accident · 1 fatalClosedBeech S35 · Cubage, KYJul 6, 1967 · N7923K · Destroyed NTSB CHI68F0159Accident · No injuriesClosedPiper PA-24 · Sonora, KYJul 3, 1967 · N7502P · Substantial damage NTSB CHI68D0015Accident · No injuriesClosedPiper PA-23 · Lexington, KYJul 2, 1967 · N5935Y · Substantial damage NTSB CHI68A0139Accident · 2 fatalClosedBeech 35-B33 · Smith Mills, KYJun 24, 1967 · N8659M · Destroyed NTSB CHI68F0085Accident · Serious injuriesClosedPiper PA-28 · Campbellsburg, KYJun 18, 1967 · N5902W · Substantial damage NTSB CHI67A0135Accident · 4 fatalClosedBeech 35 · Louisville, KYJun 18, 1967 · N3296V · Destroyed NTSB CHI67I0134Incident · No injuriesClosedDouglas DC-8 · Convington, KYJun 17, 1967 · N807E · Substantial damage NTSB CHI67A0130Accident · Serious injuriesClosedPiper PA-22 · Barrier, KYJun 12, 1967 · N1782P · Destroyed NTSB CHI68F0109Accident · Serious injuriesClosedCessna 150 · Murray, KYJun 11, 1967 · N2599J · Substantial damage NTSB CHI68D0164Accident · No injuriesClosedGrumman G-164 · Central City, KYJun 5, 1967 · N10258 · Destroyed NTSB CHI68F0066Accident · No injuriesClosedBeech A23 · Junction City, KYMay 29, 1967 · N2311W · Substantial damage NTSB CHI68D0077Accident · No injuriesClosedCessna 172H · Franklin, KYMay 29, 1967 · N3801R · Substantial damage NTSB CHI68D0009Accident · No injuriesClosedCessna 182 · Somerset, KYMay 26, 1967 · N3032Y · Substantial damage NTSB CHI67D0620Accident · No injuriesClosedPiper PA-24 · London, KYApr 30, 1967 · N6407P · Substantial damage NTSB CHI67F0677Accident · No injuriesClosedCessna 172G · Edmonton, KYApr 26, 1967 · N3609L · Substantial damage NTSB CHI67D0579Accident · No injuriesClosedLuscombe 8A · Hazel Green, KYApr 9, 1967 · CF-VMF · Substantial damage NTSB CHI67D0610Accident · No injuriesClosedPiper PA-28 · West Liberty, KYApr 8, 1967 · N5894W · Substantial damage NTSB CHI67A0112Accident · 9 fatalClosedBeech C-45H · Lexington, KYApr 3, 1967 · N3727G · Destroyed NTSB CHI67D0531Accident · No injuriesClosedChampion 7GCA · Campbellsville, KYMar 14, 1967 · N9537S · Substantial damage NTSB CHI67F0542Accident · Serious injuriesClosedCessna 140 · Pine Top, KYFeb 22, 1967 · N89499 · Destroyed NTSB CHI67A0100Accident · 3 fatalClosedAero Comdr 520 · Jetson, KYFeb 22, 1967 · N2628B · Destroyed NTSB CHI67F0475Accident · No injuriesClosedCessna 172C · Paducah, KYFeb 14, 1967 · N1807Y · Substantial damage NTSB CHI67F0358Accident · No injuriesClosedBeech F35 · Erlanger, KYNov 28, 1966 · N5057B · Substantial damage NTSB CHI67D0394Accident · No injuriesClosedPiper PA-24 · Greensburg, KYNov 6, 1966 · N6311P · Substantial damage NTSB CHI67A0060Accident · 4 fatalClosedBeech G35 · Cadiz, KYNov 5, 1966 · N4674D · Destroyed NTSB CHI67A0057Accident · 1 fatalClosedHughes 269B · Lexington, KYOct 28, 1966 · N9461F · Destroyed NTSB CHI67D0408Accident · No injuriesClosedMooney M20C · Pikeville, KYOct 25, 1966 · N6064Q · Substantial damage NTSB CHI67D0342Accident · Minor injuriesClosedCessna 150D · London, KYOct 21, 1966 · N4145U · Substantial damage NTSB CHI67D0308Accident · No injuriesClosedPiper PA-24 · Danville, KYOct 21, 1966 · N6176P · Substantial damage NTSB CHI67F0307Accident · No injuriesClosedPiper PA-22 · Somerset, KYOct 5, 1966 · N4751A · Substantial damage NTSB CHI67F0151Accident · No injuriesClosedPiper PA-30 · Louisville, KYSep 14, 1966 · N7727Y · Substantial damage NTSB CHI67D0227Accident · No injuriesClosedBeech A23 · Columbia, KYSep 1, 1966 · N5789V · Substantial damage NTSB CHI67F0150Accident · No injuriesClosedBeech D35 · Hazard, KYAug 27, 1966 · N3442B · Substantial damage NTSB CHI67F0177Accident · Serious injuriesClosedPiper PA-28 · Williamstown, KYAug 21, 1966 · N9401J · Destroyed NTSB CHI67A0023Accident · No injuriesClosedHawker-Sdly DH-125 · Paducah, KYAug 15, 1966 · N926G · Substantial damage NTSB CHI67A0021Accident · 1 fatalClosedCessna 172 · Chavies, KYAug 8, 1966 · N3894L · Destroyed