NTSB investigations, 2001, 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\") = 2001
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") = 2001 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 NYC02LA043Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Falmouth, KYThe pilot's continued flight into known adverse weather. A factor was the snow.NTSB NYC02TA026Accident · Serious injuriesFinal reportBell 407 · Whitley City, KYThe pilots decision to operate the helicopter at an airspeed in excess of the maximum demonstrated stable airspeed for the water bucket. A factor in the accident was the pilot did not follow the published emergency procedure.NTSB NYC01LA231Accident · No injuriesLimited investigationFinal reportLet 33 · Bardstown, KYThe pilot's improper flare, which resulted in a nose-first, hard touchdown.NTSB NYC01LA216Accident · No injuriesLimited investigationFinal reportCessna 182R · Elizabethtown, KYThe pilot's improper decision to fly the airplane with a known deficiency, and his inflight decision to land with a quartering tailwind. A factor was the wing maintenance officer's concurrence to fly the airplane with the known deficiency.NTSB NYC01FA145Accident · 2 fatalField investigationFinal reportAeronca 7DC · Fulton, KYThe pilot's failure to maintain control of the airplane, which resulted in an inadvertent stall/spin to the ground. A factor was the pilot's decision to fly from the rear seat, which reduced his visibility of critical flight instruments, including the…NTSB IAD01LA063Accident · No injuriesLimited investigationFinal reportGrumman AA-5A · Louisville, KYThe flight instructor's failure to maintain directional control after landing.NTSB NYC01LA131Accident · Minor injuriesLimited investigationFinal reportHughes 269C · Fairfield, KYThe pilot's inadequate visual lookout during takeoff, and his inadequate reconnoiter of the area prior to takeoff.NTSB NYC01LA124Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Elizabethtown, KYThe pilot's failure to maintain directional control during the takeoff roll.NTSB NYC01LA112Accident · No injuriesLimited investigationFinal reportCessna 182Q · Paintsville, KYThe pilot's inadequate preflight inspection of the aircraft, which resulted in fuel exhaustion during cruise flight.NTSB NYC01LA113Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Hodgenville, KYThe pilot's failure to maintain runway alignment during landing. A factor in the accident was the pilot's lack of experience in conducting soft field landings.NTSB IAD01TA051Accident · Minor injuriesFinal reportHughes 369D · Taylorsville, KYthe flight instructor's inadequate aircraft control during a practice autorotation which resulted in a hard landing.NTSB NYC01FA102Accident · 1 fatalField investigationFinal reportCessna 152 · La Grange, KYThe student pilot's failure to maintain adequate airspeed while maneuvering the airplane at low altitude. A factor was the pilot's overconfidence in his abilities.NTSB NYC01FA089Accident · 1 fatalField investigationFinal reportCessna 182Q · Dixon, KYThe pilot's failure to maintain adequate clearance while maneuvering, which resulted in an in-flight collision with trees.NTSB NYC01IA072Incident · No injuriesIncident investigationFinal reportBombardier CL-600-2B19 · Covington, KYMissing exhaust nozzle bolts for undetermined reasons. A factor was inadequate maintenance inspection of the affected area.