NTSB investigations, 1980, 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\") = 1980
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") = 1980 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 ATL81DLQ08Accident · No injuriesClosedAmer Avco AA-5A · Murry, KYNTSB ATL81FLQ07Accident · Minor injuriesClosedPiper PA-23 · Louisville, KYNTSB ATL81FA022Accident · 3 fatalClosedSwearigen SA26AT · Albany, KYNTSB ATL81FLQ06Accident · Minor injuriesClosedCessna 182 · Hazard, KYNTSB ATL81FLQ05Accident · No injuriesClosedHelio Acft HT-295 · Mt Sterling, KYNTSB ATL81FA018Accident · 2 fatalClosedPiper PA-28 · Corbin, KYNTSB ATL81FA016Accident · 3 fatalClosedBell 206B · Liberty, KYNTSB ATL81DLQ04Accident · No injuriesClosedGreat Lakes Baby · Burnside, KYNTSB ATL81DLQ03Accident · Serious injuriesClosedCessna 172M · Waddy, KYNTSB ATL81DLQ02Accident · No injuriesClosedBell 47G-2A · South Shore, KYNTSB ATL80DLQ01Accident · No injuriesClosedPiper PA-25 · Paducah, KYNTSB ATL80FLQ29Accident · No injuriesClosedPiper PA-31 · Paducah, KYNTSB ATL80FLQ28Accident · Minor injuriesClosedPiper PA-28 · Morehead, KYNTSB ATL80DLQ27Accident · No injuriesClosedCessna 150M · Somerset, KYNTSB ATL80DLQ25Accident · Serious injuriesClosedSchweizer SGS233 · Frankfort, KYNTSB ATL80FA083Accident · 1 fatalClosedCessna 150 · Henderson, KYNTSB ATL80FLQ26Accident · No injuriesClosedCessna P210N · Lexington, KYNTSB ATL80FLQ24Accident · Serious injuriesClosedPiper PA-28 · Louisville, KYNTSB ATL80FA079Accident · No injuriesClosedLear Jet 25 · Paducah, KYNTSB ATL80FA078Accident · 3 fatalClosedPiper PA-28 · Pikeville, KYNTSB ATL80FLQ22Accident · No injuriesClosedGrumman G-164A · Garfield, KYNTSB ATL80DLQ21Accident · No injuriesClosedCessna 172 · Morgantown, KYNTSB ATL80FA058Accident · 4 fatalClosedCessna 172N · West Liberty, KYNTSB ATL80FLQ20Accident · No injuriesClosedPiper PA-32 · Louisville, KYNTSB ATL80FLQ19Accident · Serious injuriesClosedErco 415-C · Shepherdstown, KYNTSB ATL80DLQ23Accident · No injuriesClosedGrumman G-164B · Scottsville, KYNTSB IAD80DLQ18Accident · Minor injuriesClosedCessna 150L · Bowling Green, KYNTSB ATL80IA046Incident · No injuriesClosedAerospatle SA341G · Greasy Creek, KYNTSB ATL80FA045Accident · 1 fatalClosedCessna 150 · Pikeville, KYNTSB IAD80FA042Accident · 1 fatalClosedPiper PA-28 · Bowling Green, KYNTSB IAD80FLQ17Accident · No injuriesClosedPiper PA-28 · Anchorage, KYNTSB IAD80FA040Accident · 4 fatalClosedPiper PA-28 · Falmouth, KYNTSB IAD80FLQ16Accident · Minor injuriesClosedBellanca 7ECA · Lexington, KYNTSB IAD80FLQ15Accident · Minor injuriesClosedBell 206L · Pikeville, KYNTSB IAD80FLQ14Accident · Serious injuriesClosedPiper PA-24 · Lexington, KYNTSB IAD80FA028Accident · No injuriesClosedCessna 404 · Lexington, KYNTSB IAD80FA027Accident · 1 fatalClosedCessna 150 · Reidland, KYNTSB IAD80DLQ13Accident · Serious injuriesClosedCessna 177 · Albany, KYNTSB IAD80FLQ12Accident · No injuriesClosedCessna 150 · Louisville, KYNTSB IAD80DLQ11Accident · No injuriesClosedMooney M20F · Albany, KYNTSB IAD80FLQ10Accident · Serious injuriesClosedHughes 500D · Dione, KYNTSB IAD80FLQ08Accident · Minor injuriesClosedBell 206B · Shelbyville, KYNTSB IAD80DLQ09Accident · Minor injuriesClosedCessna 172M · Gilbertsville, KY