NTSB investigations, 2000, 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\") = 2000
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") = 2000 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 ATL01LA017Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Cleveland, TNA loss of engine power during takeoff due to carburetor ice. A factor was unsuitable terrain.NTSB MIA01LA013Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Knoxville, TNThe pilot's failure to maintain Vs during takeoff/initial climb, which resulted in an inadvertent stall/mush, an uncontrolled descent, and an impact with the ground. Factors in the accident were the pilot's improper preflightplanning/preparation and failure…NTSB ATL01FA008Accident · 1 fatalField investigationFinal reportPiper PA-32RT · Selmer, TNThe pilots inadequate preflight planning and preparation, that resulted in exceeding the designed weight and balance of the airplane. Factors were the pilot's use of inappropriate medications and the collision with trees.NTSB MIA00LA247Accident · No injuriesLimited investigationFinal reportCessna 182Q · Fayetteville, TNthe pilot's failure to maintain adequate airspeed during the takeoff/initial climb, which resulted in an inadvertent stall/mush and collision with the runway that resulted in substantial damage to the airplane.NTSB MIA00LA235Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Crossville, TNThe pilot's inadequate compensation for wind and his failure to maintain obstacle clearance. The crosswind was a contributing factor.NTSB ATL00LA074Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Clarksville, TNThe pilot's failure to follow published instrument approach procedures, and collided with a tree while executing a missed approach. Factors were low clouds, fog and a tree.NTSB MIA00LA222Accident · No injuriesLimited investigationFinal reportBell 47G-2A · Covington, TNthe pilot allowed the helicopter to get too low while hovering, which resulted in the tail rotor striking the ground, the separation of the blade, and subsequent force landing.NTSB MIA00LA212Accident · No injuriesLimited investigationFinal reportCessna 560 XL · Nashville, TNthe flight crew's failure to activate the normal brake system, and failure to follow published aircraft procedures/directives for a hard brake or no braking condition and use the emergency brake system after recognizing a normal brake system failure, which…NTSB MIA00LA216Accident · No injuriesLimited investigationFinal reportAviat Husky · Dayton, TNThe pilot's failure to maintain directional control of the airplane during landing flare into a crosswind, resulting in a runway excursion off the runway edge and collision of the wingtip with the terrain.NTSB MIA00FA201Accident · 1 fatalField investigationFinal reportCessna 152 · Murfreesboro, TNthe flight instructor's failure to maintain an airspeed above the aircraft's stall speed, which resulted in a stall/mush, and an inflight loss of control while maneuvering to return to a landing area during an emergency, resulting in an uncontrolled descent…NTSB ATL00LA068Accident · No injuriesLimited investigationFinal reportDouble D Enterprises Rans S-12 · Baneberry, TNThe pilot's inadequate compensation for wind conditions. Factors were the trees, and gusting winds.NTSB MIA00FA177Accident · 2 fatalField investigationFinal reportBeech C23 · Smyrna, TNThe failure of the dual student to maintain airspeed following total loss of engine power resulting in an inadvertent stall and subsequent uncontrolled descent. Also, inadequate supervision by the CFI for her failure to note the position of the fuel selector…NTSB MIA00LA183Accident · No injuriesLimited investigationFinal reportHayes LONG-EZ · Collegedale, TNThe pilot's failure to maintain the proper glide path on final approach to insure arrival at the proper runway touchdown point. A factor in the accident is the pilot's unfamiliarity with the cockpit spoiler control's location and operation.NTSB MIA00LA169Accident · Serious injuriesLimited investigationFinal reportBoeing 737-500 · Nashville, TNThe passenger's onboard disturbance and self-evacuation from the parked aircraft, resulting in injuries. A factor in the accident was the lack of backup electrical power to the terminal which necessitated a lengthy ground hold.NTSB ATL00LA052Accident · No injuriesLimited investigationFinal reportCessna 172M · Clinton, TNThe pilot's inadequate in-flight planning necessitating an intentional ground loop maneuver on landing. Contributing factors were the pilot's misjudgment of distance/airspeed, the high terrain surrounding the runway, and the tailwind condition.NTSB ATL00LA046Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401-B · Lawrenceburg, TNThe loss of engine power due to a stuck exhaust valve that resulted in the collision with a tree while maneuvering for the forced landing.NTSB MIA00LA127Accident · No injuriesLimited investigationFinal reportCessna 152 · Murfreesboro, TNA loss of engine power during takeoff climb for undetermined reasons resulting in an attempted emergency landing to unsuitable terrain and collision with a tree and transmission wires.NTSB MIA00IA104Incident · No injuriesIncident investigationFinal reportBeech 58 · Memphis, TNfailure of the right main landing gear's dynamic brake relay, that resulted in the motor driving the gearbox past prescribed limits, resulting in a bent connecting rod, and failure of the gear to extend.NTSB ATL00LA037Accident · Minor injuriesLimited investigationFinal reportTitan Tornado · Springfield, TNThe loss of engine power for undetermined reasons, and the unqualified person attempted to fly the airplane.NTSB MIA00LA100Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Dandridge, TNthe student pilot's improper preflight that resulted in his operating an aircraft with contaminated fuel that resulted in a loss of engine power and a forced landing in the trees and damage to the aircraft. Contributing to the accident were the student's…NTSB MIA00LA098Accident · No injuriesLimited investigationFinal reportBell 412 · Karns, TNThe pilot's failure to maintain a visual lookout while repo sitioning the helicopter at a road side landing zone resulting in an in-flight (hover) collision with a tree.NTSB ATL00LA028Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Nashville, TNThe pilot's failure to maintain directional control during the landing roll.NTSB MIA00FA090Accident · 1 fatalField investigationFinal reportBeech 35-P35 · Dayton, TNthe non-instrumented rated pilot elected to takeoff into known adverse weather conditions, which resulted in impact with rising terrain. Factors in this accident were, clouds and low ceilings.NTSB MIA00LA068Accident · No injuriesLimited investigationFinal reportDana A. Moore Danamite · Smyrna, TNthe pilot's excessive taxiing speed and failure to maintain adequate clearance from objects, resulting in the gyroplane's main rotor colliding with a fence and subsequent damage to the aircraft.NTSB MIA00FA069Accident · 1 fatalField investigationFinal reportBeech P-35 · Rogersville, TNthe pilot's improper in-flight planning/decision and continued visual flight into instrument meteorological conditions (IMC) that resulted in an in-flight collision with terrain and subsequent damage to the aircraft.NTSB ATL00FA019Accident · 2 fatalField investigationFinal reportBellanca BL-17-30A · Monteagle, TNThe pilot's failure to adequately evaluate weather conditions that resulted in the continuation of visual flight into instrument weather conditions and the subsequent collision with trees.