NTSB investigations, 1965, 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.
Cases per year
| 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
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\") = 1965
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") = 1965 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 CHI66F0502Accident · No injuriesClosedBeechcraft B55 · Paducah, KYNTSB CHI66A0057Accident · 2 fatalClosedCessna 172 · Stone, KYNTSB CHI66A0056Accident · 6 fatalClosedAero CDR 680 · Kite, KYNTSB CHI66F0489Accident · No injuriesClosedBeechcraft B-95 · Gilbertsville, KYNTSB CHI66F0404Accident · No injuriesClosedBeech C35 · Georgetown, KYNTSB DCA66A0003Accident · 58 fatalClosedBoeing B-727 · Constance, KYNTSB CHI66F0396Accident · No injuriesClosedCessna 172 · Lexington, KYNTSB CHI66A0043Accident · 3 fatalClosedBeech 35 · Reed, KYNTSB CHI66D0393Accident · No injuriesClosedCessna 182 · Golden Pond, KYNTSB CHI66F0326Accident · No injuriesClosedPiper PA-28 · Fulton, KYNTSB CHI66F0383Accident · No injuriesClosedBeechcraft 95 · Louisville, KYNTSB CHI66F0335Accident · Minor injuriesClosedAeronca 7AC · Poplar Plains, KYNTSB CHI66D0320Accident · No injuriesClosedCessna 210 · Munfordville, KYNTSB CHI66A0025Accident · 1 fatalClosedDouglas DC3 · Louisville, KYNTSB CHI66F0210Accident · No injuriesClosedTaylorcraft BC12-D · Richardville, KYNTSB CHI66F0302Accident · No injuriesClosedMooney M20C · Owensboro, KYNTSB CHI66F0200Accident · No injuriesClosedCessna 175 · Somerset, KYNTSB CHI66F0148Accident · No injuriesClosedPiper PA-28 · Georgetown, KYNTSB CHI66F0139Accident · Serious injuriesClosedPiper PA-22 · Golden Pond, KYNTSB CHI66F0100Accident · No injuriesClosedPiper PA-25 · Melber, KYNTSB CHI66A0010Accident · No injuriesClosedHughes 269A-1 · Lynch, KYNTSB CHI66D0084Accident · No injuriesClosedCessna 182 · Greenville, KYNTSB CHI66F0083Accident · No injuriesClosedPiper PA-24 · Winchester, KYNTSB UNK65X1514Accident · No injuriesClosedCessna 170 · West Liberty, KYNTSB CHI66F0044Accident · Serious injuriesClosedCessna 170B · Herndon, KYNTSB CHI66A0004Accident · 1 fatalClosedAeronca 7AC · Pulaski, KYNTSB CHI66F0079Accident · No injuriesClosedPiper PA-22 · Columbia, KYNTSB CHI66F0063Accident · No injuriesClosedMooney M20C · Paintsville, KYNTSB CHI66F0001Accident · No injuriesClosedPiper PA-24 · Louisville, KYNTSB CHI66F0024Accident · No injuriesClosedPiper PA-28B · Murray, KYNTSB CHI66F0039Accident · No injuriesClosedAeronca 7AC · Water Valley, KYNTSB CHI65A0099Accident · 2 fatalClosedBeechcraft K35 · Whitesburg, KYNTSB CHI66F0066Accident · No injuriesClosedMooney M20C · Pikeville, KYNTSB CHI66F0019Accident · No injuriesClosedCessna 172 · Georgetown, KYNTSB CHI65F0204Accident · No injuriesClosedCessna 120 · Monticello, KYNTSB CHI65F0125Accident · No injuriesClosedAeronca 7AC · Buffalo, KYNTSB CHI65F0126Accident · No injuriesClosedPiper PA-22 · Paducah, KYNTSB CHI65D0103Accident · No injuriesClosedCessna 182C · Pikeville, KYNTSB CHI65F0096Accident · No injuriesClosedPiper PA-24 · Monticello, KYNTSB CHI65F0097Accident · No injuriesClosedPiper PA-25 · Berlin, KYNTSB CHI65F0086Accident · No injuriesClosedAeronca 7AC · Cynthiana, KYNTSB CHI65D0065Accident · No injuriesClosedCessna 172 · Winchester, KYNTSB CHI65D0045Accident · No injuriesClosedCessna 150 · Arrollton, KYNTSB CHI65F0075Accident · Serious injuriesClosedBeechcraft M-35 · Smithland, KYNTSB CHI65F0050Accident · No injuriesClosedPiper PA-28 · Paducah, KYNTSB CHI65I0072Incident · No injuriesClosedBoeing B-727 · Covington, KYNTSB CHI65F0015Accident · Serious injuriesClosedMooney M20A · Versailles, KYNTSB CHI65F0017Accident · Minor injuriesClosedCessna 182 · Lexington, KYNTSB UNK65X1306Accident · No injuriesClosedCessna 172 · Manchester, KYNTSB CHI65F0024Accident · No injuriesClosedMooney M20E · Louisville, KY