NTSB investigations, TN
216 cases where NTSB found Task performance.
Cases per year
| 2008 | 7 |
|---|---|
| 2009 | 10 |
| 2010 | 12 |
| 2011 | 5 |
| 2012 | 14 |
| 2013 | 9 |
| 2014 | 14 |
| 2015 | 14 |
| 2016 | 15 |
| 2017 | 15 |
| 2018 | 9 |
| 2019 | 14 |
| 2020 | 13 |
| 2021 | 9 |
| 2022 | 19 |
| 2023 | 11 |
| 2024 | 14 |
| 2025 | 9 |
| 2026 | 3 |
Where
Latest 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 c.\"eventStateOrRegion\" = 'TN' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '0206'))
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 c."eventStateOrRegion" = 'TN' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '0206')) 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 ERA26LA327Accident · Serious injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · McMinnville, TNThe flight instructor’s delayed remedial action during a practice autorotation, which resulted in a hard landing.NTSB ERA26LA128Accident · Minor injuriesClass 4 · LimitedFinal reportBeech C23 · Knoxville, TNThe pilot’s failure to maintain directional control of the airplane during the landing roll, which resulted in a runway excursion and collision with a ditch.NTSB ERA26LA099Accident · No injuriesClass 4 · LimitedFinal reportFrankewich Walter S-21 Outbound · Madisonville, TNThe pilot’s failure to compensate for gusty crosswind conditions during the landing roll, which resulted in a loss of control and subsequent runway excursion.NTSB ERA26LA048Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 · Cookeville, TNThe pilot’s failure to maintain an appropriate decent rate during approach, resulting in a hard landing.NTSB ERA25LA317Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Knoxville, TNThe pilot’s failure to maintain directional control during landing roll in a crosswind, which resulted in a runway excursion and a subsequent ground loop.NTSB ERA25LA295Accident · No injuriesClass 4 · LimitedFinal reportCessna 195 · Memphis, TNFailure of the left main landing gear due to the loss of the protective paint coating and a change in the local surface finish from impermissible grinding, which resulted in fatigue cracking.NTSB ERA25LA291Accident · Minor injuriesClass 4 · LimitedFinal reportBeech 35-C33 · Kingston, TNThe pilot’s failure to maintain directional control during takeoff roll, which resulted in a runway excursion and collision with haybales.NTSB ERA25LA238Accident · No injuriesClass 3 · LimitedFinal reportCessna 310 · Fayetteville, TNThe pilot’s decision to operate the airplane with known discrepancies.NTSB ERA25LA226Accident · Serious injuriesClass 3 · LimitedFinal reportBeech A36 · Murfreesboro, TNThe pilot’s mismanagement of available fuel, which resulted in fuel starvation and a subsequent loss of total engine power.NTSB ERA25LA213Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Murfreesboro, TNThe pilot’s failure to maintain directional control of the airplane while attempting to take off in a gusty crosswind, which resulted in a runway excursion.NTSB ERA25LA135Accident · Minor injuriesClass 4 · LimitedFinal reportIcon A5 · Smithville, TNThe pilot’s failure to retract the landing gear prior to landing in water. Contributing to the accident was the pilot’s failure to use the manufacturer’s provided checklist.NTSB ERA25LA114Accident · No injuriesClass 3 · LimitedFinal reportCessna 172P · Clarksville, TNThe flight instructor’s inadequate preflight inspection of the airplane, which allowed the partially secured engine cowl to separate in flight.NTSB ERA25LA052Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172S · Chattanooga, TNA partial loss of engine power due to a fouled spark plug in engine’s the No. 4 cylinder. Contributing was the flight instructor’s failure to maintain aircraft control during an attempted go-around following an unsuccessful landing approach in IMC, which…NTSB ERA25LA046Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Mariner · Parrottsville, TNThe pilot’s failure to maintain control of the helicopter during a precautionary, off-airport landing to sloping terrain.NTSB ERA25LA022Accident · No injuriesClass 4 · LimitedFinal reportTextron T206H · Blountville, TNThe pilot’s failure to maintain directional control during takeoff and subsequent rejected takeoff, which resulted in a runway excursion. Contributing to the accident was the pilot’s failure to verify rudder trim setting prior to takeoff.NTSB ERA24FA391Accident · 1 fatalClass 3 · FieldFinal reportAviat S-1-11B · Chapmansboro, TNThe pilot’s loss of airplane control while performing an aerobatic maneuver, which resulted in the airplane entering an inverted flat spin at an altitude too low for recovery.NTSB ERA24LA375Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT-802 · Hickory Valley, TNA partial loss of engine power due to a leak in the fuel control unit bellows, which resulted in the fuel valve moving to minimum fuel flow.NTSB ERA24LA296Accident · Serious injuriesClass 4 · LimitedFinal reportMissoula Super Drifter · Lafayette, TNThe pilot's failure to maintain control of the airplane during a go-around in gusting wind conditions.NTSB ERA24LA254Accident · Minor injuriesClass 3 · LimitedFinal reportNorth American Navion · Tullahoma, TNA total loss of engine power during takeoff as a result of fuel starvation.NTSB ERA24LA253Accident · No injuriesClass 4 · LimitedFinal reportDavis Lightning · Jamestown, TNThe non-certificated pilot’s failure to maintain control of the airplane during landing, which resulted in an aerodynamic stall and subsequent hard landing.NTSB ERA24LA252Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 182 · Telford, TNThe pilot’s failure to maintain control of the airplane while performing a go-around, which resulted in an inflight collision with trees.NTSB ERA24LA181Accident · No injuriesClass 4 · LimitedFinal reportCessna 172M · Shelbyville, TNThe student pilot’s improper recovery from a bounced landing, which resulted in a loss of directional control and subsequent runway excursion.NTSB ERA24FA176Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-32R-301 · Knoxville, TNThe pilot’s decision to depart into an area of instrument meteorological and icing conditions, which resulted in loss of airplane control and a subsequent in-flight breakup.NTSB ERA24LA155Accident · Minor injuriesClass 4 · LimitedFinal reportSouth Central Searey · Knoxville, TNThe pilot’s failure to retract the landing gear of the amphibious airplane prior to a water landing.NTSB ERA24FA127Accident · 5 fatalClass 3 · FieldFinal reportPiper PA32RT · Nashville, TNThe pilot’s failure to ensure the proper placement of the fuel selector during the approach and landing, which resulted in fuel starvation and a subsequent total loss of engine power.NTSB ERA24LA087Accident · No injuriesClass 3 · LimitedFinal reportCessna 150 · Hohenwald, TNThe pilot’s failure to use carburetor heat in conditions conducive to the formation of carburetor ice, which resulted in a partial loss of engine power due to fuel starvation. Contributing to the outcome was her failure to attain a proper touchdown point…NTSB ERA24LA076Accident · No injuriesClass 3 · LimitedFinal reportBell Helicopter Textron 206L-1 · Walland, TNThe improper installation of the No. 8 bearing spanner nut, which resulted in the No. 8 bearing’s failure, and the subsequent total loss of engine power.NTSB ERA24FA058Accident · 2 fatalClass 3 · FieldFinal reportBeech 35-C33 · Pulaski, TNThe pilot’s failure to maintain airplane control, which resulted in pilot-induced oscillations and a subsequent loss of control and impact with terrain.NTSB ERA24FA038Accident · 2 fatalClass 3 · FieldFinal reportXtremeair XA42 · Union City, TNThe pilot receiving instruction’s loss of airplane control while performing aerobatics, which resulted in a stall/spin at an altitude too low for recovery. Contributing to the accident was the flight instructor’s inadequate supervision.NTSB ERA24LA020Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Jackson, TNThe pilot’s failure to maintain directional control during the landing roll in gusting wind conditions, which resulted in a runway excursion.NTSB ERA24LA017Accident · No injuriesClass 4 · LimitedFinal reportAviat A1 · Tellico Plains, TNThe pilot's overapplication of brakes after landing long on a constrained runway and with a tailwind, which resulted in a nose-over.NTSB CEN23LA358Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Sevierville, TNThe flight instructor’s improper flight control inputs during the practice hovering autorotation that resulted in a loss of control and impact with terrain.NTSB ERA23LA347Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Knoxville, TNAn in-flight fire that resulted from an inadequate 100-hr inspection, which failed to detect and correct improper electrical cable routing in the engine compartment.NTSB ERA23LA242Accident · Minor injuriesClass 4 · LimitedFinal reportGary R Brearley RV-9A · Kingston, TNThe pilot’s improper landing flare and subsequent improper recovery from a bounced landing which resulted in a nose over.NTSB ERA23FA219Accident · 1 fatalClass 3 · FieldFinal reportCessna 182 · Reliance, TNThe pilot’s decision to continue an instrument flight into an area of forecast weather with severe to extreme turbulence associated with a line of thunderstorms, which resulted in an in-flight breakup. Contributing was the pilot’s operation of the airplane in…NTSB ERA23LA227Accident · No injuriesClass 4 · LimitedFinal reportGulfstream American AA-5A · Knoxville, TNThe pilot’s failure to maintain directional control during takeoff in gusting wind conditions.NTSB ERA23LA145Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22T · Knoxville, TNThe pilot's failure to maintain directional control during the takeoff roll where a gusting and shifting crosswind prevailed.NTSB ERA23LA085Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Knoxville, TNThe pilot’s loss of directional control during engine start.NTSB ERA23LA059Accident · No injuriesClass 3 · LimitedFinal reportAmerican AA-1A · Sparta, TNA total loss of engine power due to an accumulation of carburetor ice, resulting in an off-airport landing and substantial damage to the airplane.NTSB ERA23FA025Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-32-300 · Brentwood, TNA total loss of engine power due to the catastrophic failure of the crankshaft resulting from the improper installation of the crankshaft for this application.NTSB ERA23LA032Accident · No injuriesClass 4 · LimitedFinal reportHoward DGA-15P · Lawrenceburg, TNThe pilot’s failure to maintain directional control during landing in gusting wind conditions.NTSB ERA23LA019Accident · No injuriesClass 4 · LimitedFinal reportGulfstream American AA-5A · Knoxville, TNThe student pilot’s loss of directional control on landing.NTSB ERA23LA016Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28 · Morristown, TNThe solo student pilot’s improper flare, which resulted in a hard landing.NTSB ERA22LA431Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R-22 Beta · Nashville, TNA loss of tail rotor effectiveness while hovering in crosswind conditions resulting in the student pilot's loss of control of the helicopter, impact with terrain, and dynamic rollover.NTSB ERA22LA424Accident · Minor injuriesClass 3 · LimitedFinal reportRockwell International 700 · Sevierville, TNThe total loss of engine power to the twin-engine airplane during final approach due to fuel exhaustion. Contributing to the accident was the pilot’s failure to maintain aircraft control during the approach to land, which resulted in a runway excursion and…NTSB ERA22LA413Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Chattanooga, TNA total loss of engine power due to of carburetor ice. Contributing to the accident was the pilot’s failure to apply carburetor heat.NTSB CEN22FA406Accident · 2 fatalClass 3 · FieldFinal reportCessna 182 · Cleveland, TNThe pilot’s loss of airplane control while operating in instrument meteorological conditions.NTSB ERA22FA391Accident · 1 fatalClass 3 · FieldFinal reportAeronca 7AC · Jacksboro, TNThe pilot's exceedance of the airplane’s critical angle of attack during takeoff, which resulted in an aerodynamic stall and loss of control.NTSB ERA22LA311Accident · No injuriesClass 4 · LimitedFinal reportBeech 95-B55 (T42A) · Livingston, TNThe pilot’s improper flare, which resulted in a hard landing.NTSB ERA22LA296Accident · No injuriesClass 4 · LimitedFinal reportAmerican Champion 8KCAB · Knoxville, TNThe inadequate maintenance of the left main landing gear through bolt, which resulted in a left main landing gear collapse and subsequent runway excursion during landing.