NTSB investigations, 1995, 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\") = 1995
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") = 1995 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 BFO96FA034Accident · 1 fatalField investigationFinal reportPiper PA-28R-180 · Louisville, KYfailure of the pilot to maintain adequate airspeed, while maneuvering at low altitude, which resulted in an inadvertent stall, loss of altitude, and subsequent collision with obstructions (utility pole and supporting cable).NTSB BFO96LA028Accident · No injuriesLimited investigationFinal reportCessna 152 · Stanton, KYwas the student pilot's failure to maintain directional control of the aircraft. The student pilot's lack of experience was a related factor.NTSB BFO95LA079Accident · 1 fatalLimited investigationFinal reportHughlett Challenger II · Madisonville, KYan intermittent short of the ignition system, due to improper maintenance/modification of the engine, which resulted in partial loss of engine power; and failure of the pilot to maintain adequate airspeed, which resulted in an inadvertent stall and collision…NTSB NYC95LA134Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Morehead, KYThe pilot's failure to assure that an inadequate oil supply was available fot the flight.NTSB NYC95LA117Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Louisville, KYThe pilot's inadequate planning which resulted in his failure to attain adequate airspeed for takeoff.NTSB NYC95IA106Incident · No injuriesIncident investigationFinal reportDouglas DC-8-71 · Louisville, KYpreexisting crack(s) on the inside surface of the right main landing gear cylinder, and the subsequent fracture of the cylinder, which resulted in a collapse of the right main landing gear.NTSB BFO95LA049Accident · No injuriesLimited investigationFinal reportMaule M-7-235 · Mount Sterling, KYthe pilot's failure to maintain aircraft control during landing. The gusty, crosswind condition and the pilot's inadequate compensation for the wind condition were factors.NTSB NYC95LA078Accident · Serious injuriesLimited investigationFinal reportBeech 1900C · Covington, KYa lack of procedures by the tug operator to prevent inadvertent movement of an unoccupied tug, which resulted in an airplane being struck by an unoccupied tug which moved on its own.NTSB MIA95FA070Accident · 2 fatalField investigationFinal reportCessna 172N · Mintonville, KYThe flightcrew's intentional VFR flight into known instrument meteorological conditions. A factor was the inadequate altitude to prevent an inadvertent collision with an obstruction.