NTSB investigations, 2000, 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\") = 2000
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") = 2000 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 MIA01IA051Incident · No injuriesIncident investigationFinal reportCanadair CL-600-2B19 · Hebron, KYThe inadequate design of the flight compartment windshield by the windshield manufacturer resulting in cracking of the center ply.NTSB NYC01LA055Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Mount Sterling, KYThe student pilot's inadequate recovery from a bounced landing.NTSB NYC01FA053Accident · 3 fatalField investigationFinal reportRobinson R-44A · Sandgap, KYthe pilot's improper weather evaluation, and his failure to maintain terrain clearance while operating over unlighted terrain at night. Factors were the isolated areas of fog, and night conditions.NTSB NYC01IA046Incident · Minor injuriesIncident investigationFinal reportMooney M20C · Hazard, KYThe incorrect routing of the cabin air scat tubing by an unknown person, which resulted in a carbon monoxide leak into the cabin, and subsequent pilot incapacitation.NTSB NYC01IA024Incident · No injuriesIncident investigationFinal reportBombardier CL-600 · Falmouth, KYThe wake turbulence of another heavy airplane.NTSB NYC01LA022Accident · Serious injuriesLimited investigationFinal reportHoward Weedhopper · Fordsville, KYAn engine failure for undetermined reasons and the pilot's low altitude flight.NTSB IAD00LA085Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Owingsville, KYA loss of engine power due to water contamination of the fuel. Also causal in the accident was the pilot/owner's failure to repair the inoperative fuel cap.NTSB NYC00FA229Accident · 2 fatalField investigationFinal reportCessna 182RG · Princeton, KYThe pilot's failure to clear trees, for undetermined reasons.NTSB NYC00LA164Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Louisville, KYThe pilot's improper operation of the fuel selector.NTSB NYC00IA159Incident · No injuriesIncident investigationFinal reportBritish Aerospace BAE Jetstream 3201 · Lexington, KYA misalignment between the bull gear and high speed pinion gearshaft, which resulted in fatigue and a subsequent failure of the bull gear.NTSB NYC00LA128Accident · Minor injuriesLimited investigationFinal reportCessna P210N · Elizabethtown, KYThe pilot's loss of control due to his improper application of power and rudder, in order to arrest a swerve during the landing roll.NTSB NYC00IA116Incident · No injuriesIncident investigationFinal reportIsrael Aircraft Industries 1125 · Pine Knot, KYThe partial failure of an inverter and the inadequate design of the electrical circuit breaker system.NTSB NYC00FA079Accident · 4 fatalField investigationFinal reportBeech 58 · Cynthiana, KYThe pilot's failure to maintain airspeed during a climb, which resulted in a loss of aircraft control.NTSB NYC00FA068Accident · 1 fatalField investigationFinal reportCessna 195 · Willard, KYThe pilot's continued VFR flight into IMC conditions. Factors were the pilot's inadequate preflight planning and snow showers.NTSB NYC00FA067Accident · 4 fatalField investigationFinal reportBeech C-90 · Somerset, KYthe failure of the pilot to follow his approach clearance, and subsequent descent into unprotected airspace which resulted in a collision with the guy wire. Factors were the failure of the air traffic controller to verify the approach he cleared the pilot to…