NTSB investigations, 1964, KY
180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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\") = 1964
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") = 1964 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 UNK65X1029Accident · No injuriesClosedCessna 172D · Louisville, KYNTSB UNK65X0828Accident · No injuriesClosedCurtiss C-46 · Covington, KYNTSB UNK65X0794Accident · No injuriesClosedChampion 116 · Ano, KYNTSB UNK65X0787Accident · 1 fatalClosedCessna 182A · Pikesville, KYNTSB UNK65X0642Accident · No injuriesClosedPiper PA23 · Bardstown, KYNTSB UNK65X0607Accident · No injuriesClosedCessna 172 · Columbus, KYNTSB UNK65X0511Accident · No injuriesClosedPiper PA23 · Cynthiana, KYNTSB UNK65X0332Accident · No injuriesClosedNavion A · Lancaster, KYNTSB UNK65X0302Accident · No injuriesClosedPiper PA18 · Ft Knox, KYNTSB UNK65X0300Accident · 1 fatalClosedBensen Gyro B8MEJ · Berea, KYNTSB UNK65X0215Accident · No injuriesClosedCulver V · Scottsville, KYNTSB UNK65X0183Accident · No injuriesClosedBellanca 1419 · Pikeville, KYNTSB UNK65X0136Accident · No injuriesClosedCessna 172D · Lynn Grove, KYNTSB UNK64X4209Accident · No injuriesClosedBeechcraft K35 · Murray, KYNTSB UNK64X4078Accident · No injuriesClosedHughes 269A · Bryantsville, KYNTSB UNK64X3281Accident · No injuriesClosedCessna 175 · Henderson, KYNTSB UNK64X3271Accident · No injuriesClosedPiper PA18 · Cynthiana, KYNTSB UNK64X3180Accident · Minor injuriesClosedPiper J3 · Berea, KYNTSB UNK64X3095Accident · 1 fatalClosedPiper PA-24 · Elizabethtown, KYNTSB UNK64X2874Accident · No injuriesClosedBeechcraft 23 · Winchester, KYNTSB UNK64X2866Accident · No injuriesClosedBrantly B2B · Hazard, KYNTSB UNK64X2789Accident · Minor injuriesClosedPiper PA28 · Golden Pond, KYNTSB UNK64X2766Accident · No injuriesClosedBeechcraft G17S · Danville, KYNTSB UNK64X2701Accident · No injuriesClosedCessna 140 · Bowling Green, KYNTSB UNK64X2677Accident · No injuriesClosedPiper PA24 · Lexington, KYNTSB UNK64X2621Accident · No injuriesClosedBoeing A75N1 · Adairville, KYNTSB UNK64X2417Accident · Minor injuriesClosedPiper J3 · Hazard, KYNTSB UNK64X2359Accident · No injuriesClosedBeechcraft H35 · Golden Pond, KYNTSB UNK64X2207Accident · Serious injuriesClosedBell 47D1 · Gilbertsville, KYNTSB UNK64X2126Accident · No injuriesClosedPiper PA24 · Jackson, KYNTSB UNK64X2022Accident · No injuriesClosedBellanca 1413 · Golden Pond, KYNTSB UNK64X1885Accident · No injuriesClosedPiper PA24 · Lexington, KYNTSB UNK64X1805Accident · No injuriesClosedCessna 170B · Tompkinsville, KYNTSB UNK64X1552Accident · No injuriesClosedAeronca 7AC · Harlan, KYNTSB UNK64X1488Accident · No injuriesClosedAero Comm 560 · Paducah, KYNTSB UNK64X1261Accident · No injuriesClosedCessna 210 · Springfield, KYNTSB UNK64X1177Accident · No injuriesClosedCessna 172 · Morehead, KYNTSB UNK64X1167Accident · No injuriesClosedCessna 172 · Russell Spgs, KYNTSB UNK64X1051Accident · No injuriesClosedCessna 205 · Erlanger, KYNTSB UNK64X0956Accident · Minor injuriesClosedBeechcraft F35 · Murray, KYNTSB UNK64X0949Accident · No injuriesClosedCessna 172 · Moorehead, KYNTSB UNK64X0913Accident · Minor injuriesClosedCessna 172 · Georgetown, KYNTSB UNK64X0894Accident · No injuriesClosedPiper PA24 · Louisville, KYNTSB UNK64X0461Accident · No injuriesClosedBeechcraft 23 · Olive Hill, KYNTSB UNK64X0193Accident · No injuriesClosedBeechcraft B35 · Covington, KYNTSB UNK64X0156Accident · No injuriesClosedBeechcraft B35 · Pikeville, KY