NTSB investigations, 1970, 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
Open the mapLatest 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\") = 1970
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") = 1970 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 CHI71DLQ19Accident · No injuriesClosedPiper PA-24 · Frankfort, KYNTSB CHI71DGJ13Accident · No injuriesClosedCessna 182 · Brandenburg, KYNTSB CHI71AC038Accident · 1 fatalClosedCessna 150F · Gray, KYNTSB CHI71A0033Accident · 2 fatalClosedAero Comdr 1121 · Lexington, KYNTSB CHI71DGJ09Accident · No injuriesClosedCessna 337 · Sandy Hook, KYNTSB CHI71DGA10Accident · No injuriesClosedCessna 172 · Ashland, KYNTSB CHI71AC019Accident · Minor injuriesClosedDouglas DC-9 · Louisville, KYNTSB CHI71DGJ04Accident · No injuriesClosedPiper PA-22 · Somerset, KYNTSB CHI71DGJ06Accident · No injuriesClosedBoeing A75 · Lebanon, KYNTSB CHI71DGJ05Accident · No injuriesClosedPiper PA-23 · Madisonville, KYNTSB CHI71DGJ10Accident · No injuriesClosedPiper PA-18 · Ft.Knox, KYNTSB CHI71FGJ03Accident · Serious injuriesClosedPiper PA-28 · Okolona, KYNTSB CHI71DGJ08Accident · No injuriesClosedCessna 182 · Bowling Green, KYNTSB CHI71AC007Accident · 3 fatalClosedBeech A-35 · Carrolton, KYNTSB CHI71FGA04Accident · No injuriesClosedPiper PA-24 · Denton, KYNTSB CHI71DGJ02Accident · Minor injuriesClosedPiper PA-22 · Georgetown, KYNTSB CHI71DGJ07Accident · No injuriesClosedPiper PA-28 · Hebbardsville, KYNTSB CHI71DGJ01Accident · No injuriesClosedCessna 150 · Murray, KYNTSB CHI70DGJ18Accident · Serious injuriesClosedPiper J-3 · Whitesburg, KYNTSB CHI70AC093Accident · 2 fatalClosedPiper PA-12 · Somerset, KYNTSB CHI70DGJ16Accident · No injuriesClosedAero Comdr 100 · Albany, KYNTSB CHI70FGJ15Accident · Serious injuriesClosedAeronca 65-TAC · Lebanon, KYNTSB CHI70DGJ14Accident · No injuriesClosedCessna 150 · Elizabethtown, KYNTSB CHI70DGJ12Accident · No injuriesClosedLuscombe 8E · Monticello, KYNTSB CHI70DGJ10Accident · No injuriesClosedCessna 150 · Adairville, KYNTSB CHI70FGJ17Accident · No injuriesClosedCessna A188 · Philpot, KYNTSB CHI70DGJ11Accident · No injuriesClosedErco 415-C · Artemus, KYNTSB CHI70DGJ13Accident · Minor injuriesClosedBell 47G-5 · Inez, KYNTSB CHI70FGJ08Accident · No injuriesClosedBeech A23-19 · Cherokee, KYNTSB CHI70DGJ09Accident · Minor injuriesClosedAeronca 7FC · Elkhorn City, KYNTSB CHI70AC068Accident · 1 fatalClosedAeronca 7AC · Whitesburg, KYNTSB CHI70DGJ07Accident · No injuriesClosedCessna 182 · Campton, KYNTSB CHI70AC055Accident · 6 fatalClosedBeech 95-B55 · Pineville, KYNTSB CHI70AC051Accident · 3 fatalClosedBeech A35 · Hebron, KYNTSB CHI70DGJ06Accident · No injuriesClosedPiper PA-22 · Georgetown, KYNTSB CHI70FGJ04Accident · No injuriesClosedMooney M20F · Madisonville, KYNTSB CHI70DGJ05Accident · No injuriesClosedPiper PA-28 · Glasgow, KYNTSB CHI70DGJ03Accident · No injuriesClosedPiper PA-22 · Georgetown, KYNTSB CHI70FGA02Accident · No injuriesClosedPiper PA-24 · Erlanger, KY