NTSB investigations, 1990, 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\") = 1990
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") = 1990 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 ATL91LA028Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Humboldt, TNThe student pilot's failure to maintain directional control during landing. A factor was the student's lack of recent experience.NTSB ATL91LA027Accident · No injuriesLimited investigationFinal reportBeech 23C · Dunlap, TNThe pilot's failure to use the carburetor heat properly, which resulted in the formation of carburetor ice, followed by a complete loss of engine power. Factors to this accident were carburetor icing conditions and the rough and uneven terrain at the crash…NTSB ATL91FA025Accident · 1 fatalField investigationFinal reportCessna 150J · Ripley, TNPerforming a stall maneuver at an altitude below prescribed minimums, and his failure to apply correct flight control inputs to recover from the stall and spin.NTSB ATL91LA021Accident · No injuriesLimited investigationFinal reportCessna 150 · Arlington, TNThe student pilot's failure to maintain directional control during landing. A factor in this accident was gusty winds.NTSB ATL91IA016Incident · No injuriesIncident investigationFinal reportSaab-Scania 340A · Memphis, TNThe pilot's failure to follow approved procedures for troubleshooting inflight maintenance problems and improperly used the flight and engine controls.NTSB ATL91IA014Incident · No injuriesIncident investigationFinal reportBell 412 · Knoxville, TNThe pilot's failure to see and avoid the wires prior to the collision. Factors in the incident were the failure of the ground personnel to adequately inspect the landing zone, the presence of high intensity lights at the lz, and the dark lighting conditions.NTSB ATL91FA013Accident · Serious injuriesField investigationFinal reportBell 47J-2 · Gatlinburg, TNThe accident was inadequate maintenance of the helicopter, allowing a tail rotor drive shaft bearing to exceed wear limits. This resulted in high loads on the tail rotor drive shaft, and the resulting fatigue failure of the drive shaft.NTSB ATL91LA011Accident · No injuriesLimited investigationFinal reportCessna 152 · Centerville, TNThe propable cause of the accident was the runway incursion by the deer during the pilot's takeoff roll.NTSB ATL91FA006Accident · 1 fatalField investigationFinal reportOlsen-Gordon Veri EZE · Hohenwald, TNThe failure of the left rudder control cable which rendered the airplane uncontrollable.NTSB ATL91LA004Accident · Serious injuriesLimited investigationFinal reportE TN Plts Starduster Starduster II · Knoxville, TNPilot's inadvertent closing of the fuel shutoff valve, which totally or partially restricted fuel flow to the engine.NTSB ATL90FA183Accident · 2 fatalField investigationFinal reportGrumman AA5B · Gallatin, TNThe pilot's failure to maintain the proper altitude which resulted in the inadvertent descent into the ground, and his diverted attention to another airplane. Factors in the accident were fog, dark night, fatigue from lack of sleep, and a lack of recent night…NTSB ATL90LA180Accident · No injuriesLimited investigationFinal reportBeech 35-B33 · Fayetteville, TNThe pilot's premature flare which resulted in a loss of directional control at touchdown.NTSB ATL90LA168Accident · Serious injuriesLimited investigationFinal reportSchleicher ASK-21 · Memphis, TNAn inflight collision with a tree due to misjudging his glidepath.NTSB ATL90FA163Accident · 1 fatalField investigationFinal reportMitsubishi MU-2B-36 · Nashville, TNThe company/operator management's decision to operate the aircraft with a known deficiency without further maintenance, the pilot's improper planning/decision and the pilot's failure to abort the takeoff (while there was sufficient runway remaining). Factors…NTSB ATL90LA162Accident · Serious injuriesLimited investigationFinal reportI.C.A. Brasov IS-28B2 · Savannah, TNThe pilot's failure to maintain aircraft control during the landing phase of the flight. Factors were: gusting wind conditions and turbulence.NTSB ATL90LA156Accident · No injuriesLimited investigationFinal reportCessna 152 · Cleveland, TNThe pilot's failure to properly judge the stopping distance of the airplane and his subsequent failure to perform a go around. Factors in the accident were the tailwind condition at the airport.NTSB ATL90LA151Accident · Minor injuriesLimited investigationFinal reportCessna 172B · Midway, TNTotal failure of the number four exhaust valve, resulting in engine power loss and the subsequent forced landing of the airplane.NTSB ATL90LA142Accident · No injuriesLimited investigationFinal reportCessna T210L · Memphis, TNFuel mismanagement by the pilot which resulted in fuel starvation during final approach.NTSB ATL90LA137Accident · No injuriesLimited investigationFinal reportCessna 150L · Blountville, TNThe pilot's inaccurate fuel consumption calculations which resulted in fuel exhaustion.NTSB ATL90LA133Accident · No injuriesLimited investigationFinal reportCessna 150M · Knoxville, TNPilot's failure to maintain directional control upon landing and subsequent premature rotation of the airplane during the go-around attempt. Contributing to the accident was the pilot's lack of total experience.NTSB ATL90LA102Accident · No injuriesLimited investigationFinal reportCessna 170 · Johnson City, TNThe pilot/mechanic's inadequate preflight inspection of the aircraft fuel system.NTSB ATL90DLT01Accident · No injuriesFinal reportGrumman G-164B · Tiptonville, TNA loss of engine power for undetermined reasons. A factor in the accident was the rough terrain.NTSB ATL90FA089Accident · 1 fatalField investigationFinal reportHiller UH-12D · Soddy-Daisy, TNFatigue induced failure of the collective pitch push rod (adjustable) during flight, and the failure of the pilot to provide routine maintenance. The pilot's lack of expereince and his failure to obtain required training and certification were factors in the…NTSB ATL90LA088Accident · No injuriesLimited investigationFinal reportMooney M20F · Murfreesboro, TNFatigue failure of the propeller blade which resulted in a forced off-airport landing.NTSB ATL90LA086Accident · Minor injuriesLimited investigationFinal reportPiper PA-32 · Bolivar, TNThe pilot failed to properly select a tank with sufficient fuel prior to takeoff.NTSB ATL90FA074Accident · 1 fatalField investigationFinal reportPiper PA-30 · Dayton, TNThe pilot's intentional use of an autopilot with known deficiencies. The pilot knowingly relied on this autopilot which malfunctioned in flight and resulted in his becoming spatially disorientated.NTSB ATL90FA061Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Norris, TNThe student pilot's misjudged descent which resulted in a collision with trees and the ground. A factor was that the pilot was buzzing when the accident occurred.NTSB ATL90LA053Accident · No injuriesLimited investigationFinal reportMitsubishi MU2B-20 · Nashville, TNInadequate maintenance adjustment of the landing gear system which resulted in the jamming of the left gear door.NTSB ATL90LA052Accident · Serious injuriesLimited investigationFinal reportAero Commander 680E · Knoxville, TNThe pilot's excessive airspeed and delay in initiating a go-around during the landing. Factors related to the accident were: the wet runway condition, the pilot's failure to attain the proper touchdown point for the landing, and his lack of flying experience…