NTSB investigations, 1993, 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\") = 1993
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") = 1993 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 ATL94LA031Accident · 2 fatalLimited investigationFinal reportCarson Piel Emeraude CP305 · Morrison, TNThe pilot's inadvertent flight into instrument meteorological conditions (IMC), and failure to maintain aircraft control after becoming spatially disoriented. Factors related to the accident were: the adverse weather conditions, and the pilot's improper…NTSB ATL94LA020Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Maryville, TNThe pilot's inadequate inflight planning, which resulted in fuel exhaustion prior to reaching the planned destination.NTSB ATL94FA012Accident · 2 fatalField investigationFinal reportMooney M20L · Hohenwald, TNThe pilot's impaired judgement and performance by flying while under the influence of drugs, that resulted in his continuation of VFR flight at night in instrument meteorological conditions (IMC) and his failure to maintain proper altitude (or clearance) from…NTSB ATL94FA006Accident · 2 fatalField investigationFinal reportMooney M20B · Bethpage, TNThe pilot's VFR flight into IMC, and his failure to maintain aircraft control. Factors were the pilot's failure to use a preflight briefing service, and the low ceilings and fog at the accident site.NTSB ATL94LA005Accident · Minor injuriesLimited investigationFinal reportMooney M20E · Maryville, TNFailure of the pilot to maintain airspeed control, which resulted in a low altitude stall.NTSB ATL94LA004Accident · No injuriesLimited investigationFinal reportCessna 172 · Blountville, TNImproper planning/decision by the pilot, which resulted in inadequate fuel and fuel exhaustion.NTSB ATL93LA164Accident · No injuriesLimited investigationFinal reportCessna 210 · Smyrna, TNThe inadequate maintenance of the taxiway.NTSB ATL93LA160Accident · 1 fatalLimited investigationFinal reportCornwell KR-2 · Covington, TNThe pilot's misjudged obstacle clearance on final approach. Factors were, the dark night, and the pilot's defective distant vision.NTSB ATL93FA155Accident · 2 fatalField investigationFinal reportBeech F35 · Jackson, TNThe improper use of old auto fuel for the refueling of the aircraft. Factors in the accident were the deterioration of the octane in the auto fuel being used in the aircraft and the delayed decision by the pilot to choose a suitable area and execute a forced…NTSB ATL93LA148Accident · Minor injuriesLimited investigationFinal reportBeech V35A · Knoxville, TNInadequate annual inspection procedures for the fuel system, which resulted in fuel starvation due to blockage of the fuel floscan transducer. A factor was insufficient FAA inspection standards/requirements.NTSB ATL93LA144Accident · No injuriesLimited investigationFinal reportCessna 152 · Cleveland, TNThe pilot's failure to maintain directional control of the airplane while taxiing.NTSB ATL93LA137Accident · 1 fatalLimited investigationFinal reportWard Long EZE · Murfreesboro, TNThe pilot's failure to properly use the carburetor heat control which resulted in the formation of carburetor ice.NTSB ATL93LA123Accident · 1 fatalLimited investigationFinal reportGulfstream G-164B · Selmer, TNThe pilot's failure to maintain adequate clearance from the power lines.NTSB ATL93LA114Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Smyrna, TNThe improper flare and the improper go around procedures used by the pilotNTSB ATL93LA095Accident · No injuriesLimited investigationFinal reportCessna 172 · Athens, TNFailure of the aircraft engine to produce power for unknown reasons.NTSB ATL93LA093Accident · No injuriesLimited investigationFinal reportCessna 152 · Grandview, TNFailure of the aircraft battery.NTSB ATL93LA089Accident · No injuriesLimited investigationFinal reportFairchild 24G · Athens, TNThe pilot's failure to use carburetor heat in weather conditions which were conducive to the formation of carburetor iceNTSB ATL93LA078Accident · 2 fatalLimited investigationFinal reportDobbs VAN'S Aircraft RV-6 · Kingston, TNThe pilot's inadequate compensation for gusty wind conditions. A factor was the wind gust of 20-25 knots.NTSB ATL93LA075Accident · Minor injuriesLimited investigationFinal reportBell UH1F · Gatlinburg, TNThe loss of engine power for unknown reasons.NTSB ATL93LA073Accident · No injuriesLimited investigationFinal reportCessna 172 · Greenville, TNThe pilot's improper procedures in that he landed with excessive flap extension, and his inadequate compensation for the gusting crosswind.NTSB ATL93LA072Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · Elizabethton, TNA loss of engine power on one engine for undetermined reasons.NTSB ATL93MA068Accident · 4 fatalMajor investigationFinal reportFairchild SA227-TT · Blountville, TNFailure of the pilot to follow procedures concerning use of the engine inlet anti-ice system and/or continuous ignition while operating in icing conditions, which resulted in probable ice ingestion and loss of engine power; and the pilot's failure to maintain…NTSB ATL93LA063Accident · No injuriesLimited investigationFinal reportBeech 58 · Blountville, TNThe intentional operation of the aircraft with a partial failure of the brake system and the failure of the pilot to attain the proper touchdown point. Factors in the accident were the sunglare and the partial loss of the aircraft brake system.NTSB ATL93FA062Accident · 1 fatalField investigationFinal reportCessna 402B · Tullahoma, TNThe pilot's failure to maintain control of the airplane during takeoff. Factors which contributed to the accident were: the pilot's failure to ensure that the airplane maximum gross takeoff weight was not exceeded, the dark night, and rain.NTSB ATL93FA060Accident · Serious injuriesField investigationFinal reportCessna 337D · Nashville, TNThe pilot's failure to ensure an adequate fuel supply for the flight, which resulted in fuel exhaustion.NTSB ATL93LA049Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Crossville, TNThe pilot's failure to follow checklist procedures in that he did not utilize the alternate gear extension method when electrical power was lost. A factor was his failure to follow the checklist when he failed to turn on the generators prior to flight, which…