NTSB investigations, 2002, KY
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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\") = 2002
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") = 2002 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 NYC03LA023Accident · No injuriesLimited investigationFinal reportCessna 172K · Prestonsburg, KYThe loss of oil pressure for undetermined reasons, which resulted in a failure of connecting rod end bolts, due to an over temperature condition.NTSB IAD03LA015Accident · No injuriesLimited investigationFinal reportBell 206L1 · Albany, KYThe pilot's inadequate in-flight planning, which resulted in an angle of approach in relative wind conditions conducive to a loss of helicopter tail rotor effectiveness. A factor was the obstacles surrounding the landing field.NTSB IAD03LA008Accident · Serious injuriesLimited investigationFinal reportPiper PA-30 · Middlesboro, KYThe pilot's operation of the airplane with a known deficiency. Factors related to the accident were the loss of engine power of the left engine due to a failure of the left engine-driven and electric fuel pumps, and inadequate maintenance.NTSB IAD03FA005Accident · 2 fatalField investigationFinal reportCessna 172N · Mount Sterling, KYThe failure of the pilot to follow the published instrument approach procedure, which resulted in an early descent into an antenna tower. A factor was the low ceiling.NTSB NYC02LA186Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Jamestown, KYThe pilot's failure to maintain the proper descent rate, which resulted in low rotor rpm and a collision with water.NTSB NYC02LA183Accident · 1 fatalLimited investigationFinal reportRoyse Glasair · Flemingsburg, KYThe pilot's improper recovery from a bounced landing, which resulted in a loss of control on the ground. A factor was the pilot's lack of experience in the type of aircraft.NTSB NYC02FA177Accident · 1 fatalField investigationFinal reportGates Learjet 25C · Lexington, KYThe captain's addition of forward thrust during the landing rollout, which resulted in a lack of braking effectiveness and a subsequent runway overrun. A factor was the captain's inability to deploy the thrust reversers for undetermined reasons.NTSB NYC02LA140Accident · Minor injuriesLimited investigationFinal reportBoeing Stearman A75N1 · Bardstown, KYThe pilot's inadequate preflight inspection, which resulted in fuel contamination and subsequent loss of engine power. A factor in this accident was that the wing tank fuel drains were wire closed and could not be used.NTSB NYC02TA123Accident · No injuriesFinal reportHughes 369D · Jeffersontown, KYThe flight instructor's loss of lateral control when his foot slipped off the rudder pedal during a power-off, running landing.NTSB NYC02IA097Incident · No injuriesIncident investigationFinal reportBombardier CL600-2B19 · Covington, KYThe manufacturer's failure to provide inspection criteria for the BPSU compartment aileron control pulleys, which resulted in eventual pulley corrosion, and subsequent control stiffness when seized pulleys and water-soaked aileron cables froze together at…NTSB IAD02LA044Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · Louisville, KYThe pilot's inadvertent selection of an empty fuel tank, which resulted in fuel starvation of the engine.NTSB NYC02LA071Accident · Minor injuriesLimited investigationFinal reportCirrus Design SR-20 · Lexington, KYThe pilot's failure to maintain aircraft control. Factors in this accident were the undetermined failure of the turn coordinator, as reported by the pilot, and the instrument meteorological conditions.NTSB NYC02LA049Accident · 1 fatalLimited investigationFinal reportStiles Choctaw · Danville, KYFailure of a connecting rod bearing, which resulted in a loss of engine power during climb.NTSB NYC02LA047Accident · Minor injuriesLimited investigationFinal reportSwearingen SA-227-AT · Covington, KYthe tug driver's inadequate visual lookout which resulted in his failure to see the airplane in time to prevent the collision.