NTSB investigations, 1971, 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\") = 1971
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") = 1971 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 CHI72FLQ22Accident · No injuriesClosedHughes 269B · Louisville, KYNTSB CHI72DLQ23Accident · No injuriesClosedMitsubishi MU-2F · Bardstown, KYNTSB CHI72FLQ21Accident · No injuriesClosedPiper PA-22 · Albany, KYNTSB CHI72FLQ24Accident · 1 fatalClosedCessna 150H · Louisville, KYNTSB CHI72FLQ20Accident · No injuriesClosedPiper PA-28 · Elizabethtown, KYNTSB CHI72AC044Accident · No injuriesClosedAero Comdr 200-D · Louisville, KYNTSB CHI72FLQ19Accident · No injuriesClosedCessna 150 · Hawesville, KYNTSB CHI71AC025Accident · 2 fatalClosedLuscombe 8A · Hickman, KYNTSB CHI72FLQ17Accident · No injuriesClosedCessna 172 · Sturgis, KYNTSB CHI72FLQ16Accident · Minor injuriesClosedChampion 7GCBC · Independence, KYNTSB CHI72FLQ18Accident · Serious injuriesClosedCessna 182B · Frankfort, KYNTSB CHI72FLQ15Accident · Serious injuriesClosedCessna A188 · Utica, KYNTSB CHI72AC028Accident · 1 fatalClosedPiper PA-28 · Adolphus, KYNTSB CHI72DLQ14Accident · No injuriesClosedPiper PA-18 · Fort Knox, KYNTSB CHI72FLQ13Accident · No injuriesClosedCessna 310N · Danville, KYNTSB CHI72FLQ05Accident · No injuriesClosedGraham SM51 · Bardstown, KYNTSB CHI72FLQ10Accident · Serious injuriesClosedCessna 150H · Hazard, KYNTSB CHI72FLQ08Accident · Minor injuriesClosedBell 47G4A · Shelbyville, KYNTSB CHI72FLQ09Accident · No injuriesClosedLuscombe 8E · Frankfort, KYNTSB CHI72FLQ03Accident · No injuriesClosedCessna 120 · Shepherdsville, KYNTSB CHI72FLQ04Accident · No injuriesClosedPiper PA-28 · Somerset, KYNTSB CHI72DLQ11Accident · No injuriesClosedCessna A188 · Owensboro, KYNTSB CHI72DLQ12Accident · Serious injuriesClosedAeronca 7AC · Baxter, KYNTSB CHI72DLQ06Accident · No injuriesClosedCessna 182E · Rockport, KYNTSB CHI72AC014Accident · 2 fatalClosedPiper PA-24 · Bardstown, KYNTSB CHI72FLQ01Accident · No injuriesClosedBeech 65-88 · Louisville, KYNTSB CHI72AC011Accident · 4 fatalClosedPiper PA-24 · Richardson, KYNTSB CHI72DLQ02Accident · No injuriesClosedPiper PA-22 · Russell Sprgs, KYNTSB CHI72DLQ07Accident · No injuriesClosedPiper PA-30 · Cave City, KYNTSB CHI71FLQ31Accident · Minor injuriesClosedPiper PA-28R · Carrollton, KYNTSB CHI71FLQ29Accident · No injuriesClosedBell 47G4A · Utica, KYNTSB CHI71FLQ25Accident · No injuriesClosedCessna 150K · New Haven, KYNTSB CHI71FLQ27Accident · Minor injuriesClosedNavion 4 · Berea, KYNTSB CHI71FLQ26Accident · No injuriesClosedBeech T-34A · Louisville, KYNTSB CHI71FLQ30Accident · No injuriesClosedCessna 175 · Junction City, KYNTSB CHI72AC085Accident · 2 fatalClosedBeech P35 · Chaplin, KYNTSB CHI71FLQ24Accident · No injuriesClosedAero Comdr A-9 · Morganfield, KYNTSB CHI71AC084Accident · Serious injuriesClosedBoeing 727 · York, KYNTSB MIA71DLT15Accident · No injuriesClosedCessna 150 · Whitesville, KYNTSB CHI71FLQ22Accident · No injuriesClosedCessna 150 · Lexington, KYNTSB CHI71FLQ23Accident · No injuriesClosedVolksplane VP-1 · Louisville, KYNTSB CHI71AC077Accident · 2 fatalClosedBeech 95-B55 · Bledsoe, KYNTSB CHI71FLQ21Accident · No injuriesClosedBede BD-4 · Louisville, KYNTSB CHI71AC069Accident · No injuriesClosedPiper PA-28 · Louisville, KYNTSB CHI71FLQ20Accident · No injuriesClosedPiper PA-28 · Fort Knox, KYNTSB CHI71FLQ17Accident · Minor injuriesClosedAeronca 7AC · Stanton, KYNTSB CHI71FLQ16Accident · Minor injuriesClosedBeech C50 · Litchfield, KYNTSB CHI71FLQ18Accident · No injuriesClosedCessna 172K · Edmonton, KYNTSB CHI71AC056Accident · 1 fatalClosedCessna 172G · Chevrolet, KYNTSB NYC71DFA37Accident · No injuriesClosedCessna 172K · Louisville, KY