NTSB investigations, 1994, KY
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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\") = 1994
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") = 1994 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 BFO95LA012Accident · No injuriesLimited investigationFinal reportBeech A23 · Campbellsville, KYthe mechanic's improper maintenance adjustment, which involved the misalignment of the fuel selector handle with the fuel selector valve. Related factors are the pilot's inadequate fuel management, and the rough/uneven terrain.NTSB NYC95LA022Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Dawson Springs, KYThe pilot's failure to maintain adequate obstacle clearance. Other related factors are night conditions and the pilot's improper inflight planning/decision.NTSB BFO95LA009Accident · No injuriesLimited investigationFinal reportCessna 150D · Paducah, KYThe student pilot's failure to maintain proper alignment and the certified flight instructor's inadequate supervision of the flight.NTSB BFO94LA162Accident · No injuriesLimited investigationFinal reportChampion 7FC · Sacramento, KYThe pilot's failure to maintain adequate obstacle clearance.NTSB NYC94LA163Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Vine Grove, KYThe pilot's (1) inadequate compensation for wind conditions and (2) failure to align with the runway during landing touch down.NTSB BFO94LA139Accident · No injuriesLimited investigationFinal reportCessna 182L · Hopkinsville, KYThe pilot's failure to maintain proper alignment and adequate obstacle clearance.NTSB BFO94LA136Accident · No injuriesLimited investigationFinal reportCessna 172 · Fisherville, KYThe pilot's failure to maintain airspeed, which resulted in a stall and inflight loss of control.NTSB BFO94LA105Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Elizabethtown, KYThe pilot's failure to maintain directional control. A factor related to the accident was: the helicopter was outside the height-velocity envelope (for a successful autorotation), when loss of directional control occurred.NTSB NYC94LA094Accident · 1 fatalLimited investigationFinal reportBradford Seahawk · Richmond, KYwas the loss of engine power for undetermined reasons, and the collision with an object during the subsequent forced landing.NTSB BFO94LA078Accident · Minor injuriesLimited investigationFinal reportCameron ET-90 · Louisville, KYThe pilot-in-command's failure to maintain clearance from wires during the landing approach. A factor related to the accident is a downdraft that exceeded the balloon's available climb capability.NTSB BFO94LA057Accident · Serious injuriesLimited investigationFinal reportCessna 182A · Berea, KYThe pilot-in-command's failure to maintain adequate airspeed during the takeoff. A factor related to the accident is the gusty wind conditions.NTSB NYC94LA062Accident · Serious injuriesLimited investigationFinal reportDouglas DC-8-61 · Covington, KYThe captain's improper decision to conduct flight at high altitude in an unpressurized airplane, which resulted in his incapacition from depressurization sickness. A factor related to the accident was: maintenance personnel failed to properly secure the…NTSB NYC94LA054Accident · Minor injuriesLimited investigationFinal reportCessna 172L · Mt. Sterling, KYInadequate maintenance which resulted in the disconnection of the throttle cable from the carburetor and the subsequent loss of engine power. Factors were the annual inspection not performed, and complacency.NTSB NYC94LA051Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Falls Of Rough, KYThe pilot's inadequate tiedown and starting procedure which resulted in a runaway aircraft, which subsequently collided with a building.NTSB BFO94LA027Accident · Serious injuriesLimited investigationFinal reportCessna 425 · London, KYLoss of engine power due to fuel contamination.