NTSB investigations, 2004, 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\") = 2004
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") = 2004 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 NYC05LA036Accident · Minor injuriesLimited investigationFinal reportCessna 175B · Lawrenceburg, KYThe pilot's inadequate pre-flight planning and in-flight planning decision, which resulted in a loss of engine power due to fuel exhaustion, and a subsequent forced landing.NTSB NYC05LA017Accident · 1 fatalLimited investigationFinal reportLabhart Kolb Twinstar Mk III · London, KYThe pilot's inadequate preflight inspection, which resulted in a total loss of engine power due to fuel contamination. A factor was the lack of an installed fuel strainer.NTSB IAD05FA012Accident · 1 fatalField investigationFinal reportCessna P210 · Paint Lick, KYImproper alignment of a turbocharger oil line, which resulted in wear damage through the hose wall and a subsequent loss of engine oil. Contributing to the accident was the low cloud ceiling.NTSB NYC04LA204Accident · No injuriesLimited investigationFinal reportBeech BE-95-A55 · Louisville, KYThe improper refueling of the left auxiliary fuel tank, which resulted in an overflow of fuel, and a subsequent explosion in the left wing during engine start.NTSB NYC04LA221Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Cynthiana, KYThe inoperative left main landing gear brake check valve, which resulted in a loss of directional control during the takeoff.NTSB NYC04CA196Accident · No injuriesData collectionFinal reportWahl S-51D · Louisville, KYThe pilot's failure to maintain directional control on the runway during landing.NTSB IAD04LA043Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T1-A2 · Elkton, KYThe pilot's misidentification of the runway, which resulted in the airplane striking an obscured runway marker. Factors were the tailwheel airplane's reduced forward and lateral visibility during landing rollout and inadequate maintenance of the airport…NTSB IAD04LA041Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · London, KYAn undocumented, improper repair attempt, which subsequently resulted in fatigue cracking to the rib cap.NTSB DCA04MA068Accident · 1 fatalClass 1 · MajorFinal reportConvair Div. of Gen. Dynamics CV-340 (580) · Florence, KYfuel starvation resulting from the captain's decision not to follow approved fuel crossfeed procedures. Contributing to the accident were the captain's inadequate preflight planning, his subsequent distraction during the flight, and his lateinitiation of the…NTSB NYC04LA154Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Lawrenceburg, KYThe pilot's decision to perform a negative g maneuver, which resulted in a loss of engine power due to fuel starvation.NTSB NYC04CA125Accident · No injuriesData collectionFinal reportCessna 150 · Sacramento, KYThe pilot's improper decision to land with a tailwind, and his inadequate compensation for the wind conditions. A factor was the tailwind.NTSB NYC04LA111Accident · Serious injuriesLimited investigationFinal reportBlack Kitfox · Mount Sterling, KYThe loss of engine power due to blockage of the fuel filters resulting in fuel starvation. A factor in the accident was the inadequate maintenance inspection.NTSB IAD04CA015Accident · No injuriesData collectionFinal reportWaco ASO · Lexington, KYThe pilot's inadequate remedial action to wake turbulence. A factor was the pilot's failure to recognize that the takeoff conditions were conducive to wake turbulence.NTSB NYC04CA094Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Louisville, KYThe student pilot's failure to maintain directional control while landing, and the CFI's delayed remedial action. A factor related to the accident was the gusting wind conditions.NTSB NYC04FA092Accident · 6 fatalField investigationFinal reportPiper PA-32R-301 · Harlan, KYThe pilot's improper decision to continue VFR flight into IMC conditions and his failure to maintain terrain clearance, which resulted in controlled flight into terrain. Factors were night, snow and a low ceiling.NTSB NYC04LA090Accident · No injuriesLimited investigationFinal reportCessna 152 · Greenville, KYThe total loss of engine power due to a total loss of engine oil for undetermined reasons, which resulted in a forced landing and subsequent collision with trees.NTSB NYC04CA085Accident · No injuriesData collectionFinal reportDiamond Aircraft Industries DA-40 · Bardstown, KYThe pilot's failure to attain the proper touchdown point, and his failure to maintain directional control during landing.NTSB NYC04LA078Accident · 1 fatalLimited investigationFinal reportRaven Industries Rally RX7 · Nicholasville, KYThe pilot's improper decision to continue the inadvertent flight in variable wind conditions, which resulted in an impact with power lines. Factors were the variable wind conditions and the unsuitable takeoff area.NTSB NYC04LA059Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Nicholasville, KYA leak in the fuel system due to a loose fitting, which resulted in a loss of engine power, and the inadequate maintenance inspection, which failed to detect/correct the security of the fitting.