NTSB investigations, 1969, 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\") = 1969
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") = 1969 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 CHI70F0387Accident · Serious injuriesClosedCessna 150 · Lebanon, KYNTSB CHI70F0378Accident · Serious injuriesClosedCessna 172 · Ford, KYNTSB MKC70A0026Accident · 1 fatalClosedCessna 182 · Elizabethtown, KYNTSB CHI70F0329Accident · No injuriesClosedCessna 150 · Cherokee Sta, KYNTSB CHI70A0031Accident · 6 fatalClosedPiper PA-32 · Jonestown, KYNTSB CHI70D0269Accident · No injuriesClosedPiper PA-22 · Walsh, KYNTSB CHI70D0277Accident · No injuriesClosedCessna 177 · Columbia, KYNTSB CHI70D0327Accident · Serious injuriesClosedCessna 150 · Columbia, KYNTSB CHI70D0268Accident · No injuriesClosedPiper PA-25 · Lynnville, KYNTSB CHI70D0024Accident · No injuriesClosedCessna 150 · Louisville, KYNTSB CHI70D0216Accident · No injuriesClosedPiper PA-28 · Georgetown, KYNTSB CHI70F0239Accident · Minor injuriesClosedPiper PA-28 · Frankfort, KYNTSB CHI70F0245Accident · No injuriesClosedErco 415-C · Berea, KYNTSB CHI70F0189Accident · Minor injuriesClosedCessna 175A · Columbia, KYNTSB CHI70F0169Accident · Minor injuriesClosedDehavilland DHC1B2 · Henderson, KYNTSB CHI70F0166Accident · Minor injuriesClosedCassutt HL-1 · Henderson, KYNTSB CHI70D0172Accident · No injuriesClosedHughes 269B · Paint Lick, KYNTSB CHI70D0178Accident · No injuriesClosedCessna 150 · Owensboro, KYNTSB CHI70D0180Accident · No injuriesClosedPiper PA-28R · Denniston, KYNTSB CHI70D0165Accident · No injuriesClosedCessna 210 · Lexington, KYNTSB CHI70F0199Accident · Minor injuriesClosedCessna 177 · Shelbyville, KYNTSB CHI70F0171Accident · Serious injuriesClosedPiper PA-23 · Corbin, KYNTSB CHI70F0181Accident · No injuriesClosedPiper PA-25 · Harrodsburg, KYNTSB CHI70D0068Accident · No injuriesClosedRyan ST-3KR · Bowling Green, KYNTSB CHI70D0124Accident · No injuriesClosedCessna 182 · Fulton, KYNTSB CHI70A0001Accident · 2 fatalClosedPiper PA-18 · Lagrange, KYNTSB CHI70F0081Accident · No injuriesClosedPiper PA-30 · Owensboro, KYNTSB CHI70D0056Accident · No injuriesClosedBell 47G-4A · Cumberland, KYNTSB CHI70D0010Accident · No injuriesClosedRepublic RC-3 · Albany, KYNTSB CHI70D0023Accident · No injuriesClosedPiper PA-28 · Hardinsburg, KYNTSB CHI70D0021Accident · No injuriesClosedPiper J3C-65 · Shepherdsville, KYNTSB CHI70F0008Accident · Serious injuriesClosedCessna 150 · Lexington, KYNTSB CHI69D0669Accident · Minor injuriesClosedCessna 150H · Middletown, KYNTSB CHI70F0002Accident · No injuriesClosedMooney M20F · Waddy, KYNTSB CHI69F0658Accident · Minor injuriesClosedCessna 210-5 · Fort Knox, KYNTSB CHI69I0093Incident · No injuriesClosedFairchild FH-227 · Ashland, KYNTSB CHI70F0004Accident · No injuriesClosedCallair A-9 · Cayce, KYNTSB CHI69I0091Incident · No injuriesClosedBeech D18S · Lexington, KYNTSB CHI70D0001Accident · No injuriesClosedCessna 140 · Shepherdsville, KYNTSB CHI69A0089Accident · 1 fatalClosedCessna 150 · Prospect, KYNTSB CHI69F0592Accident · No injuriesClosedCessna 172 · Somerset, KYNTSB CHI69D0644Accident · No injuriesClosedPiper PA-18 · Henderson, KYNTSB CHI69F0583Accident · Minor injuriesClosedCessna 140 · West Paducah, KYNTSB CHI69F0561Accident · Minor injuriesClosedCessna 172I · Florence, KYNTSB CHI69A0080Accident · 1 fatalClosedPiper PA-23 · Bowling Green, KYNTSB CHI69F0553Accident · No injuriesClosedBeech 65-80 · Louisville, KY