NTSB investigations, 1995, 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\") = 1995
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") = 1995 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 ATL96LA025Accident · 1 fatalLimited investigationFinal reportMoravan Zlin Z50 LA · Springfield, TNthe pilot's failure to maintain control of the aircraft.NTSB MIA96FA048Accident · 2 fatalField investigationFinal reportPiper PA-32-301 · Memphis, TNthe pilot's continued flight into known forecast icing conditions which resulted in the aircraft developing an ice buildup, and the pilot's failure to maintain control of the aircraft. The icing conditions was a factor.NTSB MIA96LA038Accident · No injuriesLimited investigationFinal reportAero Commander 112 · Memphis, TNThe pilot's and ground personnel's improper starting procedure. Contributing to the accident were the communications being not understood and inadequate training for both the pilot and ground personnel.NTSB MIA96LA031Accident · Serious injuriesLimited investigationFinal reportCessna 414 · Cleveland, TNThe pilot's inaccurate weight and balance calculations which resulted in an over maximum allowable gross weight takeoff. Contributing to the accident was the wet, downsloping condition of the runway.NTSB MIA96LA012Accident · 1 fatalLimited investigationFinal reportGlasflugel Mosquito · Dunlap, TNthe failure of the pilot to maintain airspeed resulting in a spin at an altitude insufficient for recovery.NTSB ATL95LA170Accident · No injuriesLimited investigationFinal reportBeech A35 · Knoxville, TNThe pilot's failure to use the carburetor heat during the approach. The factors were: failure to obtain a weather briefing, and weather conditions favorable for the formation of carburetor icing.NTSB MIA95LA233Accident · No injuriesLimited investigationFinal reportAir Tractor 301 · Dyer, TNThe pilot-in-command's failure to properly manage the fuel required for the flight, resulting in a total loss of engine power due to fuel exhaustion and subsequent in flight collision with trees and terrain.NTSB MIA95FA226Accident · Serious injuriesField investigationFinal reportMitsubishi MU-2B-35 · Smyrna, TNFailure of the pilot to maintain a proper climb rate after takeoff, and his inadvertent entry in a descending spiral, which he failed to correct. Factors relating to the accident were: darkness, and the pilot becoming spatially disoriented during the initial…NTSB ATL95LA171Accident · No injuriesLimited investigationFinal reportBell 47G · Union City, TNFailure of a #4 connecting rod bolt, which resulted in engine stoppage and a forced landing.NTSB ATL95LA165Accident · 2 fatalLimited investigationFinal reportAllen Mustang II · Jasper, TNThe pilot's failure to maintain flying speed which resulted in an aerodynamic stall.NTSB ATL95FA159Accident · 1 fatalField investigationFinal reportWSK PZL Mielec M-26 · Jonesborough, TNa blocked fuel injector nozzle, which increased the engine fuel consumption; failure of the pilot to adequately monitor fuel consumption, which resulted in fuel exhaustion before the airplane reached the destination; and the passenger's interference with the…NTSB ATL95LA158Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Bolivar, TNThe student pilot's failure to maintain directional control and his improper use of the throttle.NTSB ATL95LA156Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Mckenzie, TNThe pilot's failure to comply with the performance data for the aircraft in his attempt to takeoff, downwind, from the short sod runway, with high density altitude, and with the aircraft weight in excess of the maximum gross weight allowed.NTSB ATL95LA154Accident · Minor injuriesLimited investigationFinal reportPiper PA-46 · Dayton, TNThe pilot's failure to maintain control of the aircraft during landing.NTSB MIA95FA200Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Pulaski, TNFailure of the pilot to perform the before-takeoff checklist, and his failure to abort the takeoff due to inadequate acceleration. Contributing to the accident was an inadequate annual inspection by maintenance personnel for failure to safety the carburetor…NTSB ATL95LA149Accident · Serious injuriesLimited investigationFinal reportFantasy Sky Promotions Fantasy 6 · Kingsport, TNThe pilot's inadequate visual lookout.NTSB ATL95LA137Accident · Serious injuriesLimited investigationFinal reportCessna 172D · Stanton, TNThe pilot's failure to properly plan enough fuel for the intended flight which resulted in fuel exhaustion. Factors related to the accident were: the pilot became lost/disorientated, and high vegetation in the emergency landing area.NTSB ATL95LA127Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Fairview, TNThe pilot's failure to maintain flying speed during climbout. A factor was the wind gust.NTSB ATL95LA120Accident · No injuriesLimited investigationFinal reportPierce Kitfox III · Arlington, TNThe pilot's premature rotation on takeoff that resulted in low airspeed and an inadvertent stall.NTSB ATL95LA113Accident · No injuriesLimited investigationFinal reportCessna 172 · Brownsville, TNThe pilot's improper in-flight decision to land on the wet, sod runway, and his failure to use all of the available runway for landing.NTSB ATL95LA097Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Franklin, TNThe pilot's improper use of the throttle which resulted in the loss of engine power. The pilot also failed to follow emergency procedures to restart the engine.NTSB ATL95LA094Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-160 · Dayton, TNInstallation of an improper crankshaft oil seal which eventually separated from its seat resulting in excessive oil loss, and the pilot's improper inflight planning in that he did not allow sufficient time to lower the landing gear.NTSB ATL95LA084Accident · No injuriesLimited investigationFinal reportSwant Varieze · Tullahoma, TNThe pilot's inadequate preflight, which resulted in a takeoff with an unsecured canopy, and his failure to maintain aircraft control during the initial climb.NTSB ATL95LA083Accident · Minor injuriesLimited investigationFinal reportKirkpatrick Super GT 400 · Pleasant Hill, TNThe pilot's inadequate compensation for wind conditions, and his failure to maintain aircraft control during the initial climb. Factors were the crosswind conditions, the perimeter trees, and the pilot's lack of total flying experience.NTSB ATL95FA078Accident · 2 fatalField investigationFinal reportPiper PA-34-200T · Covington, TNThe pilot exceeded the design stress limits of the aircraft and subsequent overload failures of the stabilator and wing spars.NTSB ATL95LA072Accident · No injuriesLimited investigationFinal reportCessna 172N · Paris, TNThe failure of the pilots of both aircraft to maintain proper visual lookout during landing at the uncontrolled airport.NTSB ATL95LA068Accident · Minor injuriesLimited investigationFinal reportPiper PA-60 · Linden, TNThe pilot's failure to attain a proper touchdown point resulting in the aircraft overrunning the runway. Gusty weather conditions and the wet runway were also contributing factors.NTSB ATL95LA066Accident · Serious injuriesLimited investigationFinal reportCessna 210L · Cleveland, TNThe pilot's inaccurate fuel consumption calculations which resulted in fuel exhaustion during the final approach for landing.NTSB ATL95LA064Accident · No injuriesLimited investigationFinal reportCessna 182 · Nashville, TNThe pilot's improper use of the flight controls during takeoff which resulted in the inflight collision with the ground.NTSB ATL95LA061Accident · Serious injuriesLimited investigationFinal reportCessna 177B · Collegedale, TNThe mechanic's failure to follow approved engine overhaul procedures which resulted in the separation of the oil return line, and the complete loss of engine power.NTSB ATL95LA063Accident · Serious injuriesLimited investigationFinal reportCessna 172L · Smyrna, TNThe flight instructor's failure to ensure that the magnetos were not energized prior to positioning the propeller, and the dual student's failure to place the ignition switch in the off position after the first start attempt.NTSB ATL95LA051Accident · No injuriesLimited investigationFinal reportTaylorcraft F19 · Tullahoma, TNA lack of lubricant to the starter/roller clutch, seizure of the starter, and failure of the four crankshaft gear capscrews (bolts), which resulted in disengagement of the crankshaft (accessory) gear and subsequent loss of engine power.NTSB ATL95FA050Accident · 1 fatalField investigationFinal reportBeech B60 · Gatlinburg, TNThe pilot's continued visual flight into instrument weather conditions that resulted in a collision with rising terrain.NTSB ATL95LA048Accident · Minor injuriesLimited investigationFinal reportCessna T210G · Covington, TNThe pilot's inadequate preflight inspection of the aircraft, in that he did not adequately drain water from the fuel system, resulting in water ingestion into the engine.NTSB ATL95FA044Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Spring City, TNThe pilot's inadequate preflight planning, and his continued VFR flight into instrument weather conditions which resulted in the collision with the mountain. A factor was low ceilings.NTSB ATL95LA038Accident · No injuriesLimited investigationFinal reportDouglas DC-9-32 · Memphis, TNThe ground personnel's improper handling of the aircraft while in tow, and the operator's failure to provide sufficient requirements for this situation.NTSB ATL95LA034Accident · No injuriesLimited investigationFinal reportCessna 150H · Fayetteville, TNThe pilot's improper use of carburetor heat.NTSB ATL95LA032Accident · Serious injuriesLimited investigationFinal reportBeech V35B · Union City, TNThe improper preflight planning by the pilot which resulted in the exhaustion of the aircraft's fuel. The rough terrain condition was a factor.