NTSB investigations, 2003, 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
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\") = 2003
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") = 2003 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 NYC04CA049Accident · No injuriesData collectionFinal reportBell B407 · Morehead, KYThe ground personnel's failure to identify the hazardous condition. Factors were blowing snow and night conditions.NTSB IAD04CA006Accident · No injuriesData collectionFinal reportPiper PA-30 · Louisville, KYThe pilot's improper flare, which resulted a hard landing. A factor was the glare from the setting sun.NTSB NYC04LA050Accident · No injuriesLimited investigationFinal reportCessna 208B · Covington, KYThe pilot's inadequate pre-flight inspection, which resulted in a decrease in airplane performance due to ice, and a subsequent hard landing.NTSB NYC04LA043Accident · 1 fatalLimited investigationFinal reportBarness Pulsar I · Bardstown, KYThe pilot's loss of aircraft control, resulting in a subsequent impact with terrain. A factor related to the accident was the pilot's unfamiliarity with the airplane.NTSB IAD04LA003Accident · No injuriesLimited investigationFinal reportCessna C172R · Lexington, KYThe ground controller's failure to advise the relieving controller information regarding an engine run-up, which subsequently resulted in the flight instructor's inadvertent encounter with jet blast during ground taxi.NTSB NYC04FA036Accident · 3 fatalField investigationFinal reportBeech J35 · Somerset, KYA total loss of engine power during takeoff for undetermined reasons. A factor was the impairment of the pilot in command due to an over-the-counter antihistamine.NTSB CHI04LA030Accident · Minor injuriesLimited investigationFinal reportHughes 269B · Louisville, KYThe pilot's improper in-flight decision to allow the passenger to manipulate the aircraft flight controls, his failure to maintain altitude/clearance from the river, and his inadequate remedial action. A related factor was the low altitude.NTSB NYC04CA020Accident · Minor injuriesData collectionFinal reportPiper PA-22-150 · Franklin, KYThe pilot's failure to maintain aircraft control during takeoff.NTSB NYC04LA011Accident · 2 fatalLimited investigationFinal reportCessna 150M · Wax, KYThe pilot's failure to maintain obstacle clearance. Low altitude flight is a contributing factor.NTSB NYC03FA206Accident · 2 fatalField investigationFinal reportPiper PA-18-180 · Bardstown, KYThe pilot-in-command's failure to maintain aircraft control for undetermined reasons.NTSB NYC03CA189Accident · Serious injuriesData collectionFinal reportFairchild Dornier 328-300 · Hebron, KYThe passenger's inadvertent fall while attempting to board. A factor was the lack of a company requirement for a person to assist passengers in boarding the airplane.NTSB IAD03CA068Accident · Minor injuriesData collectionFinal reportAero Commander 100 · Fulton, KYThe malfunction of the brake system and the pilot's delay in aborting the landing.NTSB NYC03LA165Accident · No injuriesLimited investigationFinal reportBeltram Glasair-TD · London, KYThe pilot's failure to follow published procedures, which resulted in fuel starvation during approach.NTSB NYC03FA148Accident · 2 fatalField investigationFinal reportBeech F-35 · Middlesboro, KYThe pilot's improper decision to descend into clouds, and his exceeding the maximum speed and design stress limits of the airplane, which resulted in an in-flight breakup and subsequent collision with terrain.NTSB NYC03FA136Accident · 2 fatalField investigationFinal reportBeech 35-B33 · Harned, KYThe airplane's in-flight collision with terrain for undetermined reasons.NTSB NYC03LA126Accident · No injuriesLimited investigationFinal reportAmerican Champion 7EC · Louisville, KYThe pilots inadequate compensation for the crosswind conditions, and his failure to maintain directional control. A factor related to the accident was the crosswind.NTSB NYC03LA090Accident · 1 fatalLimited investigationFinal reportStarnes Quickie Q-200 · Henderson, KYThe pilot's improper recovery from a bounced landing and his failure to maintain directional control, after experiencing an in-flight loss of control for undetermined reasons.NTSB IAD03LA042Accident · No injuriesLimited investigationFinal reportBell BHT-47-G3B2A · Lexington, KYThe pilot's failure to maintain directional control while maneuvering to land after a loss of engine power. A factor was the loss of engine power.NTSB IAD03FA032Accident · 3 fatalField investigationFinal reportCessna 421 · Ferguson, KYThe pilot's failure to follow the instrument approach procedure, which resulted in an early descent into trees and terrain. Factors included the low ceiling and the night lighting conditions.NTSB NYC03LA051Accident · Minor injuriesLimited investigationFinal reportPiper PA-31-350 · Taylor Mill, KYThe pilot's inaccurate in-flight planning and fuel consumption calculations, and his improper decision not to land and refuel.NTSB IAD03LA031Accident · No injuriesLimited investigationFinal reportRobinson R-44 · Russellville, KYThe total loss of engine power due to carburetor ice.