NTSB investigations, 1989, TN
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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\") = 1989
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") = 1989 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 ATL90LA046Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Selmer, TNThe failure of the instructor to place the engine mixture control in the rich position prior to beginning traffic pattern maneuvers. As a result, the engine quit because of the lean fuel mixture at the high power setting required for the go-around and…NTSB ATL90LA034Accident · No injuriesLimited investigationFinal reportPiper PA-23-150 · Jackson, TNLoss of power in both engines (probable fuel starvation) due to improper planning/decision by the pilot(s), and lack of supervision by the instructor. Soft terrain in the emergency landing area was considered to be a factor.NTSB MIA90FA031Accident · 2 fatalField investigationFinal reportCessna 170A · Rogersville, TNContinued flight into instrument meteorological conditions by a non-instrument rated pilot resulting in spatial disorientation and a loss of aircraft control. Factors contributing to the accident were: the pilot's overconfidence in his ability to fly in…NTSB ATL90LA025Accident · No injuriesLimited investigationFinal reportCessna 152 · Dyersburg, TNPilot's temporary physical condition (possible hyperventilation or anxiety attack). Soft terrain in the emergency landing area was considered to be a related factor.NTSB MIA90FA014Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · Athens, TNLoss of control of the airplane in instrument flight conditions due to spatial disorientation, which resulted in an inadvertent descending spiral. Lack of total experience in the type of operation (actual instrument conditions) was considered to be a…NTSB ATL89LA216Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Cleveland, TNThe improper handling of the airplane by the pilot in command; a delayed go-around, and the premature retractions of the flaps.NTSB ATL89FA207Accident · 2 fatalField investigationFinal reportCessna 152 · Tiptonville, TNThe pilot's failure to maintain a proper climb rate after takeoff. Factors related to the accident were: darkness, the pilot's lack of visual cues, his habit of making shallow climbs after takeoff, his lack of recent night flying experience, and the trees.NTSB ATL89LA204Accident · Serious injuriesLimited investigationFinal reportBeech A23-19 · Gallatin, TNThe pilot used an unsuitable runway area (terrain) for takeoff. Related factors were: inadequate maintenance of the runway, runway conditions (uneven surface & tall grass), and the fence.NTSB ATL89LA195Accident · Minor injuriesLimited investigationFinal reportCessna 210C · Millington, TNA loss of engine power, due to contamination in the fuel flow manifold. The contamination in the fuel system was due to inadequate maintenance.NTSB ATL89DLT05Accident · 1 fatalFinal reportBratton RB-1 · Springfield, TNImproper planning/decision by the pilot, which resulted in fuel exhaustion at a low altitude, due to an inadequate supply of fuel; and his failure to maintain airspeed, which resulted in an inadvertent stall/spin. Factors related to the accident were: the…NTSB ATL89FA177Accident · Serious injuriesField investigationFinal reportCessna 172 · Townsend, TNImproper in-flight planning/decision by the pilot and his delay in initiating remedial action, when he encountered low ceilings over mountainous terrain, which resulted in his inability to maintain sufficient altitude. Contributing factors were: the pilot's…NTSB ATL89DLT04Accident · Minor injuriesFinal reportPitts S-1 · Butler, TNThe failure of the pilot to maintain clearance from the surface during an impromptu acrobatic maneuver.NTSB ATL89FA174Accident · 1 fatalField investigationFinal reportPiper PA-30 · Springfield, TNThe pilot's decision to continue flight into an area of known adverse weather which resulted in his ability to maintain control of the airplane. Contributing factor(s) was: the adverse weather conditions.NTSB ATL89FA173Accident · 4 fatalField investigationFinal reportCessna 210H · Piney Flats, TNThe pilot's failure to maintain control of the aircraft after becoming spatially disoriented, and his exceeding the design stress limits of the aircraft while attempting to recover from an uncontrolled descent. Factors related to the accident were: darkness,…NTSB ATL89LA162Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Knoxville, TNThe pilot's failure to recognize that the engine was not developing full power and the delay in performing remedial action until it was too late to stop the airplane on the runway.NTSB ATL89FA161Accident · Serious injuriesField investigationFinal reportLockheed L1011-385-1 · Jacks Creek, TNFailure of the passengers to remain seated with their seat belts fastened as the airplane encountered unforecast severe clear air turbulence.NTSB ATL89LA159Accident · No injuriesLimited investigationFinal reportCessna 152 · Jackson, TNThe separation of the mixture cable from the carburetor. Contributing factor(s) was: inadequate maintenance and inspection of the airplane and the soft terrain encountered during the forced landing.NTSB ATL89FA150Accident · 2 fatalField investigationFinal reportTaylorcraft BC12-D · Jamestown, TNThe pilot failed to maintain adequate airspeed to avoid an inadvertent stall. The stall occurred at an altitude which precluded recovery prior to ground impact. Contributing to the accident was the pilot's lack of proficiency in the airplane.NTSB ATL89DLT03Accident · No injuriesFinal reportBell 47 · Shelbyville, TNFailure in the rotor drive system for unknown reasons. Contributing to the accident was the pilot's inability to perform an autorotation.NTSB ATL89FA142Accident · 1 fatalField investigationFinal reportEmbraer EMB-110-P1 · Mt. Pleasant, TNPilot attempted to make a VFR landing in instrument conditions that were below minimums for the published instrument approach and collided with trees and the ground after allowing the airplane to descend below the proper altitude.NTSB ATL89LA119Accident · No injuriesLimited investigationFinal reportCessna 152 · Bolivar, TNThe pilot's failure to properly plan required fuel for this flight which resulting in fuel exhaustion and a forced landing in a field.NTSB ATL89FA106Accident · 2 fatalField investigationFinal reportBeech H35 · Knoxville, TNThe pilot's continued operation of the airplane with a known mechanical defect in the engine carburetor/fuel supply system as evidenced by the past history of engine stoppage during ground operation. Contributing to the accident was the pilot's performance of…NTSB ATL89LA096Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Blountville, TNCarburetor ice. The pilot failed to apply carburetor heat in a timely and adequate manner. This failure resulted in the accumulation of ice to a point of failure of the engine which eliminated the heat necessary to remove the ice.NTSB ATL89LA091Accident · No injuriesLimited investigationFinal reportCessna 170B · Cleveland, TNFlight into known adverse weather by the pilot and his delay in diverting to an alternate airport which led to a partial power loss and an emergency landing. The weather conditions and soft terrain were contributing factors.NTSB ATL89FA086Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Jasper, TNThe pilot's improper handling of the airplane flight controls at low altitude which resulted in an excessive rate of descent and collision with a tree.NTSB ATL89FA081Accident · 2 fatalField investigationFinal reportCessna 172 · Hartsville, TNThe pilot allowing the aircraft to lift-off prematurly at a slow airspeed and his failure to maintain directional control before inadvertently entering a stall. Contributing to the accident was the pilot's experience level and lack of qualifications.