NTSB investigations, 1999, 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\") = 1999
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") = 1999 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 MIA00LA053Accident · 1 fatalLimited investigationFinal reportSwertfeger Velocity 173 Elite · Murfreesboro, TNThe failure of an unknown maintenance person to comply with an Airworthiness Directive (replace center body bellows seal assembly and tube bushings) and Service Bulletin (replace fuel diaphragm) resulting in an in-flight power loss due to an over rich…NTSB MIA00LA037Accident · No injuriesLimited investigationFinal reportCessna 150M · Morristown, TNThe pilot's failure to maintain directional control during the takeoff phase of a touch and go landing, and the subsequent skid off the runway and collapsed nose landing gear during the attempt to abort the takeoff.NTSB MIA00LA008Accident · 2 fatalLimited investigationFinal reportEddie A. Smith KR-2 · Bell Buckle, TNThe poor in-flight planning decision by the pilot-in-command for continuing the flight with inadequate fuel supply and the inadvertent stall by the pilot-in-command following total loss of engine power due to fuel exhaustion. Findings in the accident were the…NTSB MIA00LA007Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Lebanon, TNThe inadequate annual inspection of the airplane by the mechanic for his failure to note that the threaded portion of the bail wire had 2 1/2 failed threads which resulted in the inability to keep the gascolator bowl tightly secured. Also his failure to note…NTSB ATL99FA135Accident · 2 fatalField investigationFinal reportNorth American T-6-SNJ-5 · Nashville, TNThe pilot's failure to maintain flying speed which resulted in a stall and the loss of control. A factor was pilot impairment due to the use of drugs.NTSB MIA99IA249Incident · Minor injuriesIncident investigationFinal reportDouglas DC-9-31 · Nashville, TNA preexisting crack on the left main landing gear outer cylinder housing and the first officer's failure to maintain the proper rate of descent resulting in a hard landing on touchdown, and subsequent total failure and separation of the left main landing gear…NTSB ATL99LA128Accident · No injuriesLimited investigationFinal reportCessna 182P · Collegedale, TNThe pilot's failure to secure the fuel cap which resulted in fuel exhaustion and the loss of engine power. A factor was the collision with a fence post.NTSB ATL99LA119Accident · Serious injuriesLimited investigationFinal reportCessna 175 · Mountain City, TNA blocked fuel system vent that resulted in fuel starvation and the complete loss of engine power.NTSB MIA99LA234Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Robbins, TNThe total loss of engine power due to failure of maintenance personnel to assure that the thru bolt nut at the Nos. 2 and 3 cylinders was adequately torqued following removal and replacement of the No. 3 cylinder approximately 328 hours earlier. Also, the…NTSB MIA99LA236Accident · Minor injuriesLimited investigationFinal reportMichael L. Luckey Sportsman 2 + 2 · Grand Junction, TNThe improper spoiler extension by the passenger following the bounced landing, which resulted in the hard landing and collapse of the left main landing gear.NTSB MIA99LA218Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Greeneville, TNThe pilot's failure to remain clear of clouds while operating under visual flight rules resulting in the aircraft colliding with trees on rising terrain as he flew in the clouds.NTSB MIA99LA220Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas DC-10-10F · Memphis, TNThe inadequate design by the airplane manufacturer for using bolts to secure the inboard trailing edge flap that are susceptible to stress corrosion cracking. Also, the stress corrosion cracking failure of the four H-11 bolts that secure the left inboard…NTSB ATL99LA115Accident · No injuriesLimited investigationFinal reportBeech 55 · Nashville, TNThe total failure of the nose gear extension and retraction assembly that resulted in the collapse of the nose gear during landing.NTSB ATL99LA104Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Chuckey, TNThe loss of engine power for undetermined reasons.NTSB MIA99LA182Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Seymour, TNThe failure of the pilot to perform a go-around earlier resulting in a long landing, insufficient runway remaining to stop, and subsequent in flight collision with a marked power line during an aborted landing.NTSB MIA99LA173Accident · Minor injuriesLimited investigationFinal reportCessna 182R · Sevierville, TNA loss of propeller governor control due to oil contamination.NTSB MIA99LA181Accident · No injuriesLimited investigationFinal reportRobinson R-44 · Sevierville, TNThe induced fatigue fracture of a component in the engine-to-transmission rotor drive system resulting in a disconnection of the drive system during cruise flight caused by inadequate inspection processes by the manufacturer and the subsequent autorotative…NTSB ATL99LA094Accident · Minor injuriesLimited investigationFinal reportCessna 172E · Millington, TNLoss of engine power due to undetermined reasons. Factors were weather conditions favorable to carburetor ice and the terrain condition at the forced landing site.NTSB ATL99LA088Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Dickson, TNThe loss of engine power due to undetermined reasons. A factor was uneven terrain.NTSB MIA99LA152Accident · No injuriesLimited investigationFinal reportChristen Industries S-2B · Knoxville, TNa total loss of engine power caused by the failure of the number 6 connecting rod, due to oil starvation for an undetermined reason.NTSB MIA99LA148Accident · No injuriesLimited investigationFinal reportCessna 172N · Eagleville, TNThe dual's student failure to maintain adequate altitude/clearance from the wire during takeoff/initial climb. Also causal was the certified flight instructor's inadequate supervision.NTSB MIA99LA146Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Chattanooga, TNThe failure of the student pilot to maintain directional control during the flare/touchdown.NTSB ATL99LA080Accident · No injuriesLimited investigationFinal reportCessna 182 · Murfreesboro, TNThe pilot's misjudgment of altitude and distance to the runway.NTSB MIA99LA134Accident · Serious injuriesLimited investigationFinal reportDurrwachter Wittman Tailwind · Dover, TNA loss of engine power for undetermined reasonsNTSB ATL99LA069Accident · Minor injuriesLimited investigationFinal reportBeech 58 · Nashville, TNThe pilot's inflight decision to land on a runway with a strong cross wind, rather then on a runway into the wind. A factor was the strong cross wind conditions.NTSB ATL99LA054Accident · No injuriesLimited investigationFinal reportMitsubishi MU-2B-20 · Knoxville, TNA loss of engine power for undetermined reasons. Contributing to the accident was the failure of the landing gear to extend for undetermined reasons.NTSB ATL99LA051Accident · No injuriesLimited investigationFinal reportAir Tractor 301 · Finley, TNThe pilot's inadequate compensation for wind and his failure to maintain directional control. A factor was the gusting winds.NTSB ATL99LA137Accident · No injuriesLimited investigationFinal reportGettis H. Hudson Corban Baby ACE · Pleasant View, TNThe failure of owner of sod runway to properly maintain the runway, the pilots failure to properly preflight the takeoff area before departure.