NTSB investigations, 1991, TN
180,641 investigations by the National Transportation Safety Board since 1962: 174,620 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\") = 1991
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") = 1991 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 ATL92LA023Accident · No injuriesLimited investigationFinal reportGeorga L. Atwood Kitfox III · Trezevant, TNThe pilot's improper handling of the airplane which resulted in a noseover.NTSB ATL92LA022Accident · Serious injuriesLimited investigationFinal reportBritish Aerospace 3101 · Memphis, TNThe failure of the ramp agent to position an additional step below the last step of the airstair door and the ground; the agent failed to follow a verbal company procedure.NTSB ATL92FA019Accident · 1 fatalField investigationFinal reportPiper PA-32R-301T · Darden, TNThe pilot's failure to maintain control of the airplane. The pilot exceeded the design limits of the airframe.NTSB ATL92LA015Accident · No injuriesLimited investigationFinal reportBellanca 8JCAB · Morristown, TNThe pilot's failure to maintain a proper altitude during a low pass. A factor in this accident was the pilot's overconfidence in his personal ability.NTSB ATL91LA184Accident · 1 fatalLimited investigationFinal reportFischer Wagabond · Rossville, TNThe loss of engine power as a result of carburetor icing.NTSB ATL91LA182Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Knoxville, TNThe pilot's failure to accurately evaluate the weather conditions before attempting a takeoff and his delay in aborting the takeoff procedure. A factor was the dark night.NTSB ATL91LA175Accident · No injuriesLimited investigationFinal reportCessna 172K · Greeneville, TNThe inadequate visual lookout by the pilot of N78239, and his failure to accurately judge the distance between the two aircraft. Factors in the accident were the dark night conditions and the resulting visual perception of aircraft lighting in dark conditions.NTSB ATL91LA172Accident · Serious injuriesLimited investigationFinal reportCessna 401 · Jackson, TNThe pilot's failure to select the main fuel tanks prior to the approach, resulting in fuel starvation and engine stoppage.NTSB ATL91LA166Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Tullahoma, TNAn engine power loss for undetermined reasons.NTSB ATL91LA156Accident · No injuriesLimited investigationFinal reportGrumman American AA-5B · Camden, TNThe student pilot's delayed decision to abort the takeoff, resulting in his inability to stop the airplane in the remaining runway. Factors were the pilot's lack of total flying experience, and the high outside air temperature at the time of the accident.NTSB ATL91LA146Accident · No injuriesLimited investigationFinal reportCessna C172M · Mc Minnville, TNThe failure of the pilot to maintain cleearance from obstacles during the final approach to landing.NTSB ATL91LA135Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-260 · Springfield, TNThe PA-24 pilot's failure to maintain proper airspeed while executing a go-around, resulting in the stalling of the airplane. A factor in the accident was the PA-24 pilot's failure to visually detect the J-3 in a timely manner.NTSB ATL91LA131Accident · No injuriesLimited investigationFinal reportCessna 152 · Benton, TNA loss of engine power for undetermined reasons.NTSB ATL91LA122Accident · No injuriesLimited investigationFinal reportLearjet 23 · Columbia, TNThe pilot's premature decision to turn off the anti-skid during landing roll. Factors to this accident were hydroplaning conditions.NTSB ATL91LA121Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Lebanon, TNThe pilot's excessive touchdown speed, his failure to maintain a proper touchdown point, and his failure to execute a go-around when a safe landing could not be made. Factors in the accident were: the wet runway conditions at the airport and the crosswind…NTSB ATL91LA115Accident · No injuriesLimited investigationFinal reportCessna 152 · Murfreesboro, TNStudent pilot's failure to maintain directional control during the landing roll.NTSB ATL91IA094Incident · No injuriesIncident investigationFinal reportBoeing 727-223 · Nashville, TNThe captain's failure to maintain a proper glide path after disconnection of the autopilot during the final approach. Factors in this accident were: the captain's failure to follow company procedures for category ii approaches, the first officer's failure to…NTSB ATL91LA091Accident · Serious injuriesLimited investigationFinal reportBoeing B767-287ER · Memphis, TNThe delayed inflight decision by the pilot to maneuver the aircraft away from thunderstorm activity.NTSB ATL91LA087Accident · No injuriesLimited investigationFinal reportCessna 150 · Copperhill, TNThe pilot's improper use of carburetor heat. A factor in the accident was the existing of carburetor icing conditions.NTSB ATL91FA084Accident · 2 fatalField investigationFinal reportCessna 172N · Dunlap, TNThe pilot-in-command's inadequate preflight planning/preparation, his attempted VFR flight into IFR conditions, and his subsequent failure to maintain a proper altitude. Factors in the accident were: the mountainous terrain, the foggy, low ceiling conditions…NTSB ATL91FA073Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Franklin, TNThe pilot's failure to select a proper fuel tank for flight, resulting in fuel starvation to the engine, and subsequent engine stoppage. Factors were the pilot's inadequate evaluation of the weather conditions along his route of flight, and his flight into…NTSB ATL91LA065Accident · No injuriesLimited investigationFinal reportHelio H-295 · Dunlap, TNFailure of the pilot to maintain control of the aircraft, which resulted in a ground loop/swerve. The crosswind was a related factor.NTSB ATL91LA063Accident · No injuriesLimited investigationFinal reportCessna 152 · Murfreesboro, TNThe inadvertent stall of the aircraft, encountered as a result of the student pilot's inability to maintain the proper compensation for wind and the lack of total experience of the student pilot.NTSB ATL91FA054Accident · 1 fatalField investigationFinal reportCessna 172 · Crossville, TNThe improper flight planning by the noninstrument rated pilot which resulted in his inadvertent flight into instrument meteorological conditions in mountainous terrain.NTSB ATL91FA041Accident · 2 fatalField investigationFinal reportBeech K35 · Lafayette, TNPartial loss of engine for an undetermined reason. The adverse weather conditions, darkness, and radio tower were related factors.NTSB ATL91LA038Accident · Serious injuriesLimited investigationFinal reportPiper PA-23 · Bolivar, TNThe interruption of fuel to the left engine due to contamination of the left fuel tank, resulting in engine stoppage.