NTSB investigations, 2017, TN
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
| 1962 | 1 |
|---|---|
| 1963 | 2 |
| 1964 | 74 |
| 1965 | 56 |
| 1966 | 58 |
| 1967 | 58 |
| 1968 | 51 |
| 1969 | 57 |
| 1970 | 56 |
| 1971 | 58 |
| 1972 | 56 |
| 1973 | 62 |
| 1974 | 39 |
| 1975 | 56 |
| 1976 | 53 |
| 1977 | 43 |
| 1978 | 40 |
| 1979 | 38 |
| 1980 | 41 |
| 1981 | 43 |
| 1982 | 28 |
| 1983 | 41 |
| 1984 | 35 |
| 1985 | 34 |
| 1986 | 36 |
| 1987 | 37 |
| 1988 | 36 |
| 1989 | 26 |
| 1990 | 29 |
| 1991 | 26 |
| 1992 | 25 |
| 1993 | 26 |
| 1994 | 27 |
| 1995 | 38 |
| 1996 | 33 |
| 1997 | 34 |
| 1998 | 21 |
| 1999 | 28 |
| 2000 | 26 |
| 2001 | 25 |
| 2002 | 23 |
| 2003 | 35 |
| 2004 | 27 |
| 2005 | 22 |
| 2006 | 19 |
| 2007 | 23 |
| 2008 | 24 |
| 2009 | 21 |
| 2010 | 25 |
| 2011 | 23 |
| 2012 | 29 |
| 2013 | 17 |
| 2014 | 24 |
| 2015 | 24 |
| 2016 | 25 |
| 2017 | 20 |
| 2018 | 13 |
| 2019 | 24 |
| 2020 | 24 |
| 2021 | 20 |
| 2022 | 26 |
| 2023 | 26 |
| 2024 | 29 |
| 2025 | 29 |
| 2026 | 15 |
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\") = 2017
AND c.\"eventStateOrRegion\" = 'TN' 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") = 2017 AND c."eventStateOrRegion" = 'TN' 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 WPR18FA053Accident · 1 fatalField investigationFinal reportBrowning Gregory S Zodiac 601XL · Thompson's Station, TNThe sport pilot's decision to depart in and continue flight in instrument meteorological conditions, which resulted in controlled flight into terrain.NTSB ANC18LA016Accident · Serious injuriesLimited investigationFinal reportPiper PA 23-250 · Knoxville, TNThe flight instructor’s failure to comply with published engine-out procedures and recommended airspeeds, which resulted in a lack of directional control, collision with trees, and impact with the ground; the left engine lost total power due to fuel…NTSB ANC18LA013Accident · No injuriesLimited investigationFinal reportCessna 172R · Huntingdon, TNA total loss of engine power for reasons that could not be determined because a postaccident engine examination and testing revealed no preimpact mechanical malfunctions or failures that would have precluded normal operation.NTSB ERA18LA020Accident · Minor injuriesClass 3 · LimitedFinal reportBell 206 · Union City, TNThe pilot’s inadvertent slope landing and attempted recovery, which resulted in an incipient dynamic rollover, mast bumping, and separation of the main rotor.NTSB ERA18FA016Accident · 2 fatalField investigationFinal reportPiper PA 32 · Morrison, TNThe pilots' loss of control during a missed approach in night instrument meteorological conditions as a result of spatial disorientation.NTSB GAA18CA026Accident · No injuriesData collectionFinal reportJohn A Brewer ELA Aviacion 10 Ecli · Bristol, TNThe pilot’s failure to maintain lateral control during the landing roll.NTSB GAA17CA556Accident · No injuriesData collectionFinal reportCessna 172 · Gallatin, TNThe student pilot’s improper landing flare, which resulted in a bounced landing.NTSB ERA17LA326Accident · No injuriesLimited investigationFinal reportAir Tractor AT 502 · Union City, TNThe catastrophic failure of the compressor turbine blades, which resulted in a total loss of engine power. Contributing to the accident was the installation of undocumented, time-limited engine components of indeterminate age.NTSB ERA17FA299Accident · 2 fatalField investigationFinal reportGrumman AA1 · Portland, TNThe pilot's improper fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB DCA17LA183Accident · Serious injuriesClass 3 · LimitedFinal reportBombardier CL 600 2C10 · McKellar, TNAn encounter with convective turbulence while maneuvering to avoid conflicting traffic.NTSB GAA17CA504Accident · No injuriesData collectionFinal reportBoeing E75 · Centerville, TNThe pilot receiving instruction’s failure to maintain directional control during the landing roll and the flight instructor’s delayed remedial action.NTSB GAA17CA486Accident · No injuriesData collectionFinal reportCessna L19 · Nashville, TNThe pilot’s improper landing flare in crosswind conditions, which resulted in a bounced landing, and his subsequent failure to maintain directional control during the landing roll.NTSB GAA17CA467Accident · Serious injuriesData collectionFinal reportJames D Riggs RV-10 · Lawrenceburg, TNThe pilot’s improper landing flare and failure to maintain yaw control during a go-around in gusting wind conditions.NTSB ERA17LA243Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 8B 15 · Murfreesboro, TNThe passenger's failure to let go of the balloon's gondola when the balloon began to ascend. Contributing to the accident was the pilot's failure to maintain control of the balloon after landing, which resulted in an inadvertent takeoff.NTSB GAA17CA329Accident · No injuriesData collectionFinal reportCessna 172 · Nashville, TNThe pilot’s failure to maintain directional control during the landing roll.NTSB GAA17CA300Accident · No injuriesData collectionFinal reportCessna 172 · Clarksville, TNThe pilot’s unstabilized approach and improper landing flare, which resulted in a hard, porpoised landing.NTSB GAA17CA236Accident · Minor injuriesData collectionFinal reportZeiler Bakeng Duce 1976 CZ · Oliver Springs, TNThe pilot’s unstabilized approach and failure to go around, which resulted in impact with trees.NTSB ERA17FA144Accident · 1 fatalField investigationFinal reportBuckeye Dream Machine · Knoxville, TNThe pilot's decision to maneuver the aircraft at low altitude, towards rising terrain, which resulted in an inflight collision with trees.NTSB ERA17CA137Accident · No injuriesData collectionFinal reportCirrus Design SR20 · Cleveland, TNThe flight instructor's inadequate supervision, which resulted in a premature rotation for a no-flap takeoff and subsequent loss of airplane control during the initial climb.NTSB ERA17LA083Accident · Serious injuriesLimited investigationFinal reportMaule MX7 · Carthage, TNThe pilot's inadequate compensation for gusting tailwind conditions, which resulted in a loss of airplane control during the landing flare.