Skip to content

NTSB investigations, 1972, KY

180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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 per year

19642026

NTSB investigations, 1972, KY per year, 1964–2026: 1,465 cases
1964	46
1965	51
1966	32
1967	36
1968	54
1969	46
1970	39
1971	50
1972	51
1973	43
1974	40
1975	35
1976	42
1977	35
1978	51
1979	39
1980	43
1981	30
1982	39
1983	31
1984	22
1985	31
1986	20
1987	28
1988	22
1989	9
1990	17
1991	11
1992	24
1993	19
1994	15
1995	9
1996	18
1997	12
1998	12
1999	14
2000	15
2001	14
2002	14
2003	21
2004	19
2005	15
2006	16
2007	11
2008	16
2009	14
2010	20
2011	9
2012	14
2013	11
2014	5
2015	13
2016	11
2017	11
2018	5
2019	13
2020	7
2021	11
2022	15
2023	13
2024	13
2025	15
2026	8

Where

Latest cases

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 year(c."eventDate") = 1972 AND 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 year(c.\"eventDate\") = 1972
    AND 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 year(c."eventDate") = 1972
  AND 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 CHI73FLQ19Accident · No injuriesClosedCessna 310J · Lexington, KYDec 26, 1972 · N3021L · Substantial damage NTSB CHI73AC051Accident · 2 fatalClosedAeronca 7AC · Georgetown, KYNov 27, 1972 · N83459 · Destroyed NTSB CHI73FLQ18Accident · Minor injuriesClosedPiper PA-23 · Leitchfield, KYNov 26, 1972 · N2273P · Substantial damage NTSB CHI73AC050Accident · 1 fatalClosedCessna 320C · Shelbyville, KYNov 22, 1972 · N3058T · Destroyed NTSB DCA73A0002Accident · 11 fatalClosedBeech G18S · Elkton, KYNov 17, 1972 · N2700S · Destroyed NTSB CHI73ACO47Accident · No injuriesClosedEnstrom F-28A · Lexington, KYNov 7, 1972 · N4925 · Substantial damage NTSB CHI73FLQ17Accident · No injuriesClosedPiper PA-34 · Frankfurt, KYOct 7, 1972 · N1049U · Substantial damage NTSB CHI73FLQ14Accident · Minor injuriesClosedCessna 150H · Louisville, KYOct 5, 1972 · N7119S · Substantial damage NTSB CHI73DLQ16Accident · No injuriesClosedCessna 182J · Artemus, KYSep 26, 1972 · N3308F · Substantial damage NTSB CHI73FLQ11Accident · Serious injuriesClosedCessna 177 · Lexington, KYSep 20, 1972 · N3357F · Substantial damage NTSB CHI73DLQ10Accident · No injuriesClosedCessna 182 · Henderson, KYSep 15, 1972 · N92500 · Substantial damage NTSB CHI73FLQ12Accident · No injuriesClosedCessna 172 · Glencoe, KYSep 10, 1972 · N2339U · Substantial damage NTSB CHI73DLQ13Accident · No injuriesClosedCessna 150 · Danville, KYSep 2, 1972 · N5599E · Substantial damage NTSB CHI73FIQ08Accident · No injuriesClosedCessna A188A · Owensboro, KYAug 26, 1972 · N5631J · Substantial damage NTSB CHI73DIQ15Accident · Serious injuriesClosedCessna 150 · Lyonsville, KYAug 26, 1972 · N4775X · Destroyed NTSB CHI73FLQ09Accident · No injuriesClosedPiper PA-24 · Springfield, KYAug 18, 1972 · N99SP · Substantial damage NTSB CHI73FLQ06Accident · 1 fatalClosedPiper PA-18 · Hanson, KYAug 14, 1972 · N4085Z · Destroyed NTSB CHI73AC016Accident · 1 fatalClosedCessna 150H · Louisville, KYAug 13, 1972 · N23168 · 2 aircraft · Minor damage NTSB CHI73FLQ05Accident · No injuriesClosedCessna 150F · Franklin, KYJul 24, 1972 · N8864G · Substantial damage NTSB CHI73FLQ07Accident · No injuriesClosedCessna 140 · Monticello, KYJul 21, 1972 · N2466V · Substantial damage NTSB CHI73DLQ02Accident · No injuriesClosedCessna 150F · Bardwell, KYJul 16, 1972 · N8613G · Substantial damage NTSB CHI73FLQ01Accident · No injuriesClosedPiper PA-24 · Erlanger, KYJul 14, 1972 · N8656P · Substantial damage NTSB CHI73DLQ03Accident · No injuriesClosedPiper PA-22 · Hindman, KYJul 14, 1972 · N5440Z · Substantial damage NTSB CHI73FLQ04Accident · Minor injuriesClosedCessna 172K · Maysville, KYJul 1, 1972 · N7363G · Substantial damage NTSB CHI72FLQ44Accident · No injuriesClosedPiper PA-23 · Nancy, KYJun 14, 1972 · N205G · Substantial damage NTSB CHI72FLQ48Accident · Minor injuriesClosedPiper PA-24 · Winchester, KYJun 8, 1972 · N6044P · Substantial damage NTSB CHI72FLQ49Accident · Serious injuriesClosedCessna 150H · Kingston, KYJun 7, 1972 · N23451 · Substantial damage NTSB CHI72FLQ41Accident · Serious injuriesClosedCessna 150 · Corbin, KYJun 7, 1972 · N1156Y · Destroyed NTSB CHI72DLQ43Accident · No injuriesClosedPiper PA-28 · Murray, KYJun 5, 1972 · N5990U · Substantial damage NTSB CHI72FLQ40Accident · Serious injuriesClosedCessna 150H · Lexington, KYJun 4, 1972 · N6947S · Substantial damage NTSB CHI72FLQ42Accident · Serious injuriesClosedAmer Avco AA-1 · Ivel, KYJun 3, 1972 · N9352L · Substantial damage NTSB CHI72DLQ45Accident · Serious injuriesClosedDuncan JT-1 · Cynthiana, KYJun 3, 1972 · N6196 · Substantial damage NTSB CHI72FLQ46Accident · Serious injuriesClosedCessna 150D · New Castle, KYMay 28, 1972 · N4431U · Destroyed NTSB CHI72FLQ39Accident · Minor injuriesClosedCessna 182A · Elizabethtown, KYMay 20, 1972 · N4980D · Destroyed NTSB CHI72FLQ38Accident · No injuriesClosedPiper PA-28 · Georgetown, KYMay 18, 1972 · N2682T · Substantial damage NTSB CHI72FLQ37Accident · No injuriesClosedCessna 150K · Lexington, KYMay 7, 1972 · N6467G · Substantial damage NTSB CHI72FLQ36Accident · No injuriesClosedPiper PA-22 · Georgetown, KYMay 7, 1972 · N5204Z · Substantial damage NTSB CHI72FLQ35Accident · Minor injuriesClosedCessna 182 · Columbia, KYApr 27, 1972 · N9297G · Substantial damage NTSB CHI72FLQ33Accident · No injuriesClosedCessna 150 · Owenton, KYApr 13, 1972 · N23153 · Substantial damage NTSB CHI72FLQ32Accident · Serious injuriesClosedMong Sport MS-2 · Elizabethtown, KYMar 25, 1972 · N2376 · Substantial damage NTSB CHI72AC076Accident · 1 fatalClosedMooney M20E · Berea, KYMar 24, 1972 · N9238V · Destroyed NTSB CHI72DLQ34Accident · No injuriesClosedBell 47D1 · Hazard, KYMar 19, 1972 · N929B · Substantial damage NTSB CHI72FLQ28Accident · No injuriesClosedBeech H35 · Louisville, KYMar 9, 1972 · N5495D · Substantial damage NTSB CHI72DLQ27Accident · Minor injuriesClosedCessna 172D · West Liberty, KYMar 5, 1972 · N2162Y · Substantial damage NTSB MIA72DKW23Accident · Minor injuriesClosedPiper PA-23 · Middlesboro, KYMar 4, 1972 · N3342P · Substantial damage NTSB CHI72DLQ31Accident · Minor injuriesClosedCessna 172H · Sandy Hook, KYMar 4, 1972 · N2637L · Substantial damage NTSB CHI72AC069Accident · 3 fatalClosedPiper PA-28 · Walton, KYMar 4, 1972 · N98038 · Destroyed NTSB CHI72DLQ30Accident · No injuriesClosedChampion 7ECA · Creswell, KYFeb 25, 1972 · N9087L · Substantial damage NTSB CHI72AC066Accident · 1 fatalClosedPiper PA-28 · Albany, KYFeb 16, 1972 · N1754T · Destroyed NTSB CHI72FLQ29Accident · No injuriesClosedMooney M20C · Ferguson, KYJan 8, 1972 · N1348W · Substantial damage