NTSB investigations, 1966, 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\") = 1966
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") = 1966 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 CHI67F0358Accident · No injuriesClosedBeech F35 · Erlanger, KYNTSB CHI67D0394Accident · No injuriesClosedPiper PA-24 · Greensburg, KYNTSB CHI67A0060Accident · 4 fatalClosedBeech G35 · Cadiz, KYNTSB CHI67A0057Accident · 1 fatalClosedHughes 269B · Lexington, KYNTSB CHI67D0408Accident · No injuriesClosedMooney M20C · Pikeville, KYNTSB CHI67D0342Accident · Minor injuriesClosedCessna 150D · London, KYNTSB CHI67D0308Accident · No injuriesClosedPiper PA-24 · Danville, KYNTSB CHI67F0307Accident · No injuriesClosedPiper PA-22 · Somerset, KYNTSB CHI67F0151Accident · No injuriesClosedPiper PA-30 · Louisville, KYNTSB CHI67D0227Accident · No injuriesClosedBeech A23 · Columbia, KYNTSB CHI67F0150Accident · No injuriesClosedBeech D35 · Hazard, KYNTSB CHI67F0177Accident · Serious injuriesClosedPiper PA-28 · Williamstown, KYNTSB CHI67A0023Accident · No injuriesClosedHawker-Sdly DH-125 · Paducah, KYNTSB CHI67A0021Accident · 1 fatalClosedCessna 172 · Chavies, KYNTSB CHI67F0119Accident · Minor injuriesClosedCessna 172 · Shelbyville, KYNTSB CHI67D0246Accident · No injuriesClosedPiper PA-24 · Lancaster, KYNTSB CHI67D0074Accident · No injuriesClosedPiper J-3 · Columbia, KYNTSB CHI67A0005Accident · No injuriesClosedBell 47G-2A · Slemp, KYNTSB CHI67I0003Incident · No injuriesClosedNord 262 · Erlanger, KYNTSB CHI67D0149Accident · No injuriesClosedCessna 210 · Glasgow, KYNTSB CHI66F0776Accident · No injuriesClosedPiper PA23 · Louisville, KYNTSB CHI66A0093Accident · 1 fatalClosedBoeing B75N1 · Franklin, KYNTSB CHI66D0737Accident · No injuriesClosedPiper PA-22 · Flemingsburg, KYNTSB CHI66D0710Accident · No injuriesClosedCessna 310 · Lexington, KYNTSB CHI66D0713Accident · Minor injuriesClosedCessna 172E · Albany, KYNTSB CHI66D0655Accident · No injuriesClosedBeech V35 · Mt Sterling, KYNTSB CHI66A0071Accident · 2 fatalClosedBeech J35 · Corinth, KYNTSB CHI66A0069Accident · 2 fatalClosedPiper PA-22 · London, KYNTSB CHI66F0564Accident · No injuriesClosedBeechcraft G35 · Manchester, KYNTSB CHI66D0525Accident · No injuriesClosedBeechcraft A35 · Cynthiana, KYNTSB CHI66D0519Accident · No injuriesClosedCessna 150 · Russelville, KYNTSB CHI66A0061Accident · 2 fatalClosedCessna 182G · Maysville, KY