NTSB investigations, 2001, 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\") = 2001
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") = 2001 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 ATL02LA027Accident · No injuriesLimited investigationFinal reportFlugzeugbau DG-200 · Benton, TNThe pilot's inadvertent encounter with a downdraft while maneuvering in a ridge lift during a turn resulting in an in-flight collision with trees.NTSB MIA02FA039Accident · 1 fatalField investigationFinal reportBeech BE-55-T42A · Johnson City, TNThe pilot's failure to maintain altitude clearance above the tree resulting in a collision with the tree, subsequent collision with a building, and the ground.NTSB MIA02LA023Accident · No injuriesLimited investigationFinal reportBoeing 727-233 · Memphis, TNThe inadvertent collision with birds while on final approach to land resulting in substantial damage to the airplane.NTSB ATL02FA008Accident · 3 fatalField investigationFinal reportPiper PA-28-181 · McEwen, TNThe pilot initiated a VFR flight into known IMC conditions which resulted in a loss of control of the airplane due to spatial disorientation. Factors were the low ceilings.NTSB ATL02LA015Accident · No injuriesLimited investigationFinal reportCessna 188B · Whiteville, TNThe failure of the engine driven fuel pump that contaminated the fuel system and restricted fuel flow to the engine.. A factor is rough/uneven terrain.NTSB MIA02LA009Accident · No injuriesLimited investigationFinal reportCessna 172P · Knoxville, TNThe pilot's inattentive preflight inspection, non-compliance with the prestart checklist, decision to leave the cockpit unattended with engine running, and his inadvertent deactivation of the parking brake as he exited to remove a wheel chock, resulting in…NTSB MIA02LA003Accident · Minor injuriesLimited investigationFinal reportPiper PA-30B-160 · Clarksville, TNThe failure of the CFI/check pilot to insure Vmc was maintained during a go-around following a simulated failed engine approach, resulting in an in-flight loss of control, uncontrolled descent, and collision with the terrain. A factor in the accident was the…NTSB MIA01LA231Accident · No injuriesLimited investigationFinal reportBell OH-58A · Sevierville, TNThe failure of the pilot to maintain control of the helicopter while approach to land resulting in a hard landing, a tail rotor ground strike, and the main rotor striking the tail boom.NTSB ATL01LA098Accident · No injuriesLimited investigationFinal reportSchleicher ASK-21 · Eagleville, TNThe loss of thermals during the glider flight that resulted in the collision with high vegetation while maneuvering for an emergency landing. A factor was high vegetation.NTSB MIA01LA220Accident · 1 fatalLimited investigationFinal reportPiper J-4A · Mosheim, TNThe failure of the student pilot to maintain altitude clearance during a balked landing go-around resulting in the collision with a utility pole, transmission wires, and a ground borne vehicle.NTSB ATL01LA091Accident · Serious injuriesLimited investigationFinal reportMitchell T-10 · Ashland City, TNThe restricted movement of the rudder cable, resulting in a loss of control and collision with trees.NTSB ATL01LA090Accident · No injuriesLimited investigationFinal reportSchleicher ASW-20C · Etowah, TNThe loss of thermal lift which resulted in a forced landing and subsequent in-flight collision with static wires.NTSB ATL01IA083Incident · No injuriesIncident investigationFinal reportBoeing B-727-100 · Memphis, TNThe failure of the #3 engine starter turbine.NTSB MIA01LA166Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-301 · Finley, TNThe failure of the pilot to maintain aircraft altitude control while on downwind leg of the landing pattern, resulting in an uncontrolled descent and in-flight collision with the terrain.NTSB MIA01FA152Accident · 5 fatalField investigationFinal reportPiper PA-31-T2 · Jackson, TNThe pilot's shutting down the left engine following loss of control of the left propeller resulting in an in-flight loss of control of the airplane due to the windmilling propeller. Factors in the accident were the failure of the propeller control bracket…NTSB MIA01LA148Accident · No injuriesLimited investigationFinal reportCessna A188B · Humboldt, TNthe pilot's failure to maintain directional control of the aircraft during the landing rollout, resulting in a ground loop/ground swerve and substantial damage to the aircraft.NTSB ATL01LA055Accident · No injuriesLimited investigationFinal reportAir Tractor AT-602 · Dunlap, TNThe pilot's failure to obtain liftoff airspeed for undetermined reasons. A factor was tree stumps on the departure end of the takeoff area.NTSB ATL01FA059Accident · 1 fatalField investigationFinal reportCessna 150 G · Dunlap, TNThe pilot's failure to maintain flying speed that resulted in a stall and subsequent loss of control in flight.NTSB ATL01LA052Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Maryville, TNThe pilot's inadequate preflight planning that resulted in the in-flight collision with a fence during an attempted takeoff from a grass strip.NTSB MIA01IA129Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-8-71F · Nashville, TNThe failure of company maintenance personnel to install the correct hydraulic landing gear extension component, and the failure of company maintenance inspection personnel to comply with proper post maintenance test procedures, resulting in the impossibility…NTSB MIA01LA128Accident · No injuriesLimited investigationFinal reportSteen Aero Lab Skybolt I · Germantown, TNThe pilot's failure to conduct proper preflight planning and preparation, resulting in fuel exhaustion during cruise flight, and the subsequent emergency descent and forced landing to a residential street colliding with a vehicle, utility pole, mail box, and…NTSB MIA01LA105Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Dyer, TNThe improper installation of the main landing gear tire (pinched tube) by company maintenance personnel resulting in a total loss of air pressure in-flight, loss of directional control on landing roll, and subsequent nose down.NTSB ATL01LA041Accident · Serious injuriesLimited investigationFinal reportBoeing 727-200 · Memphis, TNThe Powerback Coordinator's failure to follow powerback procedures which resulted in jet blast injuries to the wing walker. A factor was the stuck wheel chock.NTSB ATL01FA027Accident · 4 fatalField investigationFinal reportBeech F90-42 · Nashville, TNThe pilot's failure to follow loss of engine power emergency procedures by not feathering the propeller following the loss of engine power for undetermined reasons, resulting in a descent and collision with trees and the ground.NTSB MIA01LA055Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Cleveland, TNThe PIC's failure to follow safe operating procedures for the maintenance of the rotorcraft's external aerial application equipment, resulting in inadvertent activation of collective as he egressed the rotorcraft, causing unmanned flight, in-flight break-up,…