NTSB investigations, 1973, KY
180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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\") = 1973
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") = 1973 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 IAD74AI037Accident · 1 fatalClosedBellanca 7KCAB · Munfordville, KYNTSB IAD74DLQ20Accident · No injuriesClosedCessna 172 · Moreland, KYNTSB IAD74FLQ17Accident · No injuriesClosedCessna 177 · Dycusburg, KYNTSB IAD74AI033Accident · Minor injuriesClosedBeech D18 · Covington, KYNTSB IAD74AI027Accident · 2 fatalClosedCessna 170 · Glasgow, KYNTSB IAD74FLQ15Accident · Minor injuriesClosedPiper PA-23 · Albany, KYNTSB IAD74AI025Accident · 2 fatalClosedMooney M20C · Cromwell, KYNTSB IAD74DLQ13Accident · No injuriesClosedBeech 35-A33 · Paducah, KYNTSB IAD74FLQ12Accident · No injuriesClosedCessna 172K · Williamsburg, KYNTSB IAD74FLQ11Accident · No injuriesClosedPiper PA-28 · Louisville, KYNTSB IAD74DLQ10Accident · No injuriesClosedBeech E55 · Hazard, KYNTSB IAD74FLQ09Accident · No injuriesClosedCessna 337C · Murray, KYNTSB IAD74FLQ08Accident · Minor injuriesClosedPiper PA-36 · Russellville, KYNTSB IAD74DLQ07Accident · No injuriesClosedBeech A23 · Owensboro, KYNTSB IAD74AI018Accident · 4 fatalClosedCessna 310H · Paintsville, KYNTSB IAD74AI014Accident · 1 fatalClosedCessna 150 · Eddyville, KYNTSB IAD74FLQ06Accident · No injuriesClosedAeronca 7AC · Cromwell, KYNTSB IAD74FLQ04Accident · No injuriesClosedSiai-Marche S.205 · Bardstown, KYNTSB IAD74AI008Accident · 1 fatalClosedCessna 172 · Loretto, KYNTSB IAD74DLQ03Accident · No injuriesClosedMooney M20C · Paducah, KYNTSB IAD74FLQ02Accident · 1 fatalClosedCessna 182C · Mt.Sterling, KYNTSB IAD74AI004Accident · 2 fatalClosedNavion A · Henderson, KYNTSB IAD74FLQ01Accident · No injuriesClosedPiper PA-24 · Louisville, KYNTSB IAD74DLQ05Accident · Minor injuriesClosedCessna 150 · Campbellsville, KYNTSB IAD73FIQ35Accident · No injuriesClosedGreat Lakes 2T-1R · Louisville, KYNTSB IAD73FLQ36Accident · Serious injuriesClosedAeronca 7AC · Paris, KYNTSB IAD73AI018Accident · No injuriesClosedBeech E18S · Covington, KYNTSB IAD73FLQ34Accident · Minor injuriesClosedCessna 150H · Park City, KYNTSB IAD73FLQ33Accident · No injuriesClosedBeech J35 · Lexington, KYNTSB IAD73FLQ31Accident · No injuriesClosedPine Air SV · Richmond, KYNTSB IAD73FLQ32Accident · Serious injuriesClosedBeech B23 · Middlesboro, KYNTSB IAD73FLQ30Accident · Minor injuriesClosedAeronca 7AC · Murray, KYNTSB IAD73FLQ29Accident · No injuriesClosedCessna 172 · Falmouth, KYNTSB IAD73FLQ27Accident · No injuriesClosedPiper PA-28 · Mayfield, KYNTSB IAD73FLQ28Accident · No injuriesClosedCessna 172 · Kona, KYNTSB IAD73ILQ26Accident · Serious injuriesClosedFly Baby 1-A · Greenville, KYNTSB IAD73DLQ25Accident · No injuriesClosedCessna 305A · Bowling Green, KYNTSB IAD73FLQ24Accident · Minor injuriesClosedSmith DSA-1 · Elizabethtown, KYNTSB IAD73FLQ23Accident · No injuriesClosedCessna 210 · Henderson, KYNTSB IAD73DLQ22Accident · No injuriesClosedErcoupe 415-C · Bardwell, KYNTSB CHI73FCQ21Accident · No injuriesClosedMooney M-10 · Springfield, KYNTSB CHI73ALQ20Accident · No injuriesClosedCessna 177RG · Lexington, KYNTSB CHI73AC065Accident · No injuriesClosedBeech C-45H · Louisville, KY