# NTSB investigations, TN: Approach

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

Page 1 of 6 · 291 cases

## Latest cases

- [NTSB ERA25LA226](https://openairdocs.org/ntsb/ERA25LA226.md): Beech A36 · Murfreesboro, TN · Accident · Serious injuries · Class 3 · Limited · Final report · Jun 10, 2025 · N15PM · Substantial damage
  > The pilot’s mismanagement of available fuel, which resulted in fuel starvation and a subsequent loss of total engine power.
- [NTSB ERA25FA187](https://openairdocs.org/ntsb/ERA25FA187.md): Mooney M20TN · Sparta, TN · Accident · 3 fatal · Class 3 · Field · Preliminary report · Apr 26, 2025 · N242RE · Substantial damage
  > On April 26, 2025, about 1147 central daylight time, a Mooney M20TN, N242RE, was substantially damaged when it was involved in an accident near Sparta, Tennessee. The private pilot and two passengers were fatally injured. The airplane was operated as a Title…
- [NTSB ERA25LA104](https://openairdocs.org/ntsb/ERA25LA104.md): Cessna 182 · Smyrna, TN · Accident · No injuries · Class 4 · Limited · Final report · Jan 17, 2025 · N21254 · Substantial damage
  > The pilot’s failure to maintain an appropriate approach path, resulting in the airplane contacting a tree during a landing approach at night.
- [NTSB ERA24LA296](https://openairdocs.org/ntsb/ERA24LA296.md): Missoula Super Drifter · Lafayette, TN · Accident · Serious injuries · Class 4 · Limited · Final report · Jul 7, 2024 · N692BS · Substantial damage
  > The pilot's failure to maintain control of the airplane during a go-around in gusting wind conditions.
- [NTSB ERA24LA252](https://openairdocs.org/ntsb/ERA24LA252.md): Cessna 182 · Telford, TN · Accident · Serious injuries · Class 4 · Limited · Final report · Jun 8, 2024 · N3304R · Substantial damage
  > The pilot’s failure to maintain control of the airplane while performing a go-around, which resulted in an inflight collision with trees.
- [NTSB ERA24FA127](https://openairdocs.org/ntsb/ERA24FA127.md): Piper PA32RT · Nashville, TN · Accident · 5 fatal · Class 3 · Field · Final report · Mar 5, 2024 · C-FBWH · Substantial damage
  > The 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 ERA24LA054](https://openairdocs.org/ntsb/ERA24LA054.md): Piper PA-32-260 · Millington, TN · Accident · Minor injuries · Class 3 · Limited · Final report · Dec 4, 2023 · N7748J · Substantial damage
  > The pilots’ fuel mismanagement during the cross-country flight and incorrect fuel tank selection for the landing approach, which resulted in fuel starvation, a momentary loss of engine power, and collision with terrain short of the runway.
- [NTSB ERA23LA111](https://openairdocs.org/ntsb/ERA23LA111.md): Piper PA-28-160 · Somerville, TN · Accident · No injuries · Class 4 · Limited · Final report · Jan 10, 2023 · N5841W · Substantial damage
  > Based on available evidence, the reason for the damage to the airplane’s propeller and engine cowling could not be determined.
- [NTSB ERA22LA424](https://openairdocs.org/ntsb/ERA22LA424.md): Rockwell International 700 · Sevierville, TN · Accident · Minor injuries · Class 3 · Limited · Final report · Sep 17, 2022 · N700AK · Substantial damage
  > The 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 ERA21LA124](https://openairdocs.org/ntsb/ERA21LA124.md): Cessna 441 · Belvidere, TN · Accident · 2 fatal · Class 3 · Limited · Final report · Feb 7, 2021 · N44776 · Destroyed
  > The pilot’s failure to follow the published instrument approach procedure by prematurely descending the airplane below the final approach fix altitude to fly under the low ceiling conditions, which resulted in controlled flight into terrain.
- [NTSB ERA21LA070](https://openairdocs.org/ntsb/ERA21LA070.md): Piper PA24 · Nashville, TN · Accident · Minor injuries · Class 3 · Limited · Final report · Dec 12, 2020 · N7639P · Substantial damage
  > The pilot’s failure to use carburetor heat during the approach, which resulted in a loss of engine power due to carburetor icing.
- [NTSB ERA20LA273](https://openairdocs.org/ntsb/ERA20LA273.md): Eurocopter EC130 · Knoxville, TN · Accident · 1 fatal · Class 3 · Limited · Final report · Aug 3, 2020 · N55GJ · Substantial damage
  > The pilot's entry into vortex ring state and his inability to arrest the helicopter's descent while maneuvering for landing.
- [NTSB ERA20LA188](https://openairdocs.org/ntsb/ERA20LA188.md): Vaughn Challenger · Clarksville, TN · Accident · Minor injuries · Class 3 · Limited · Final report · May 16, 2020 · N97KV · Substantial damage
  > The loss of engine power due to carburetor ice.
- [NTSB ERA20LA183](https://openairdocs.org/ntsb/ERA20LA183.md): Ercoupe 415 · Rogersville, TN · Accident · 1 fatal · Class 3 · Limited · Final report · May 15, 2020 · N3956H · Destroyed
  > The pilot's failure to maintain a proper glidepath on approach, which resulted in an inflight collision with trees and terrain. Contributing to the accident was the pilot’s use of an impairing medication.
- [NTSB ERA20LA018](https://openairdocs.org/ntsb/ERA20LA018.md): Beech N35 · Madisonville, TN · Accident · No injuries · Class 3 · Limited · Final report · Oct 18, 2019 · N564T · Substantial damage
  > The pilot's unstable approach and delayed decision to go-around. Contributing to the accident was the unporting of the fuel supply following a forward slip maneuver during the approach, which resulted in the loss of engine power during the go-around.
- [NTSB DCA19CA130](https://openairdocs.org/ntsb/DCA19CA130.md): Boeing 737 · Nashville, TN · Accident · No injuries · Data collection · Final report · Mar 28, 2019 · N249WN · Substantial damage
  > a collision with a bird.
- [NTSB ERA18TA255](https://openairdocs.org/ntsb/ERA18TA255.md): Calvin Nate H Velocity STD RG E · Kingsport, TN · Accident · Serious injuries · Final report · Sep 20, 2018 · N67WR · Substantial damage
  > The pilot's failure to use carburetor heat in conditions conducive to serious carburetor icing at glide power, which resulted in a partial loss of power and an aerodynamic stall.
- [NTSB ERA18LA241](https://openairdocs.org/ntsb/ERA18LA241.md): Diamond DA40 · Mount Pleasant, TN · Accident · Minor injuries · Limited investigation · Final report · Sep 1, 2018 · N388MA · Substantial damage
  > A total loss of engine power for reasons that could not be determined because postaccident examination of the airplane did not reveal any evidence of preimpact mechanical malfunctions or failures that would have precluded normal operation.
- [NTSB ANC18LA016](https://openairdocs.org/ntsb/ANC18LA016.md): Piper PA 23-250 · Knoxville, TN · Accident · Serious injuries · Limited investigation · Final report · Dec 19, 2017 · N40285 · Substantial damage
  > The flight instructor’s failure to comply with published engine-out procedures and recommended airspeeds, which resulted in a lack of directional control, collision with trees, and impact with the ground; the left engine lost total power due to fuel…
- [NTSB ERA18FA016](https://openairdocs.org/ntsb/ERA18FA016.md): Piper PA 32 · Morrison, TN · Accident · 2 fatal · Field investigation · Final report · Nov 8, 2017 · N47831 · Destroyed
  > The pilots' loss of control during a missed approach in night instrument meteorological conditions as a result of spatial disorientation.
- [NTSB ERA17FA299](https://openairdocs.org/ntsb/ERA17FA299.md): Grumman AA1 · Portland, TN · Accident · 2 fatal · Field investigation · Final report · Aug 30, 2017 · N8866L · Substantial damage
  > The pilot's improper fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB ERA17LA048](https://openairdocs.org/ntsb/ERA17LA048.md): Schweizer SGS126 · Moscow, TN · Accident · Serious injuries · Limited investigation · Final report · Nov 17, 2016 · N65968 · Substantial damage
  > The pilot's failure to maintain adequate airspeed and his exceedance of the glider’s critical angle of attack while maneuvering at low altitude, which resulted in an aerodynamic stall/spin.
- [NTSB ERA16FA208](https://openairdocs.org/ntsb/ERA16FA208.md): Mooney M20E · Collegedale, TN · Accident · 3 fatal · Field investigation · Final report · Jun 11, 2016 · N7830V · Substantial damage
  > The pilot's failure to maintain adequate airspeed and his exceedance of the airplane's critical angle of attack while maneuvering after a go-around, which resulted in an aerodynamic stall.
- [NTSB GAA16CA157](https://openairdocs.org/ntsb/GAA16CA157.md): Cessna 172 · Nashville, TN · Accident · No injuries · Data collection · Final report · Mar 20, 2016 · N118ET · Substantial damage
  > The pilot's excessive pitch up and incorrect action of selecting flaps to zero degrees, which resulted in a tail strike during a go-around in crosswind conditions.
- [NTSB ERA16LA090](https://openairdocs.org/ntsb/ERA16LA090.md): Beech A23 · Kingston, TN · Accident · No injuries · Limited investigation · Final report · Jan 16, 2016 · N3680Q · Substantial damage
  > The pilot's inadequate preflight inspection and fuel planning and his improper in-flight fuel management, which resulted in a total loss of engine power due to fuel starvation.
- [NTSB ERA15CA007](https://openairdocs.org/ntsb/ERA15CA007.md): Aeronca 7AC · Maryville, TN · Accident · Minor injuries · Data collection · Final report · Oct 4, 2014 · N85707 · Substantial damage
  > The pilot/owner's failure to maintain a stabilized approach during the final leg of the traffic pattern. Contributing to the accident was both pilot's lack of aeronautical decision making.
- [NTSB ERA14CA357](https://openairdocs.org/ntsb/ERA14CA357.md): Cirrus Design SR22 · Lafollette, TN · Accident · No injuries · Data collection · Final report · Jul 24, 2014 · N8159Z · Substantial damage
  > The pilot's failure to maintain directional control during a go-around in gusty crosswind conditions.
- [NTSB ERA14FA112](https://openairdocs.org/ntsb/ERA14FA112.md): Gulfstream AM Corp Comm Div 690 · Bellevue, TN · Accident · 4 fatal · Field investigation · Final report · Feb 3, 2014 · N840V · Destroyed
  > The pilot's failure to maintain airspeed with one engine inoperative, which resulted in a loss of control while on approach. Contributing to the accident were airframe ice accumulation due to conditions conducive to icing and the loss of engine power on one…
- [NTSB ERA14FA027](https://openairdocs.org/ntsb/ERA14FA027.md): Cessna 172R · Nashville, TN · Accident · 1 fatal · Field investigation · Final report · Oct 29, 2013 · C-GRJH · Destroyed
  > The noninstrument-rated pilot’s continued visual flight into night instrument flight rules conditions, which resulted in a collision with the runway during an attempted approach to land. Contributing to the accident was the pilot’s mental state, his…
- [NTSB ERA13CA310](https://openairdocs.org/ntsb/ERA13CA310.md): Schleicher Alexander ASH 26 E · Tullahoma, TN · Accident · No injuries · Data collection · Final report · Apr 12, 2013 · N26EL · Substantial damage
  > The pilot's improper use of wing spoilers during approach resulting in an altitude loss and collision with a tree.
- [NTSB ERA13LA076](https://openairdocs.org/ntsb/ERA13LA076.md): Cassutt Sport Racer · Collegedale, TN · Accident · 1 fatal · Limited investigation · Final report · Dec 2, 2012 · N9CA · Substantial damage
  > Impact with trees and terrain during the landing approach likely due to the physiological incapacitation of the pilot.
- [NTSB ERA12LA422](https://openairdocs.org/ntsb/ERA12LA422.md): Mooney M20J · Mc Kinnon, TN · Accident · Serious injuries · Limited investigation · Final report · Jun 28, 2012 · N174JB · Substantial damage
  > The separation of the piston connecting rod from the crankshaft due to inadequate installation from a mechanic, resulting in a total loss of engine power.
- [NTSB ERA12LA368](https://openairdocs.org/ntsb/ERA12LA368.md): Schweizer 269C · Piney Flats, TN · Accident · No injuries · Limited investigation · Final report · May 24, 2012 · N760DA · Substantial damage
  > The mechanic’s improper maintenance of the main transmission aft pinion nut and belt drive system, which resulted in the uncoupling of the tail rotor driveshaft and the subsequent loss of helicopter control.
- [NTSB ERA12CA321](https://openairdocs.org/ntsb/ERA12CA321.md): Eiriavion PIK 20D · Eagleville, TN · Accident · Serious injuries · Data collection · Final report · May 6, 2012 · N39RB · Substantial damage
  > The glider’s encounter with atmospheric lift conditions not sufficient to maintain flight, which resulted in an aerodynamic stall.
- [NTSB ERA12LA299](https://openairdocs.org/ntsb/ERA12LA299.md): Cessna 210 · Gatlinburg, TN · Accident · No injuries · Limited investigation · Final report · Apr 19, 2012 · N96050 · Substantial damage
  > Failure of the nose landing gear down pressure hose, which resulted in the main landing gear being unable to lock and collapse of the main landing gear during the landing roll.
- [NTSB ERA12LA148](https://openairdocs.org/ntsb/ERA12LA148.md): Cessna 172I · Springfield, TN · Accident · No injuries · Limited investigation · Final report · Jan 19, 2012 · N35571 · Substantial damage
  > The pilot did not apply carburetor heat during approach to landing, which resulted in a total loss of engine power due to carburetor icing.
- [NTSB ERA12CA027](https://openairdocs.org/ntsb/ERA12CA027.md): Ica Brasov IS-29D2 · Benton, TN · Accident · No injuries · Data collection · Final report · Oct 14, 2011 · N1339X · Substantial damage
  > The pilot's improper in-flight planning, which resulted in a low-altitude traffic pattern entry and subsequent collision with telephone wires.
- [NTSB ERA11FA435](https://openairdocs.org/ntsb/ERA11FA435.md): Rans S18 · Fayetteville, TN · Accident · 1 fatal · Field investigation · Final report · Aug 2, 2011 · UNREG · Substantial damage
  > The pilot's failure to maintain adequate airspeed, which resulted in an inadvertent stall/spin. Contributing to the accident was the pilot's lack of recent flight experience.
- [NTSB ERA11CA430](https://openairdocs.org/ntsb/ERA11CA430.md): Cessna 182 · Dandrige, TN · Accident · No injuries · Data collection · Final report · Jul 30, 2011 · N5813B · Substantial damage
  > The loss of engine power due to fuel exhaustion as a result of poor planning.
- [NTSB ERA10CA117](https://openairdocs.org/ntsb/ERA10CA117.md): Luscombe 8 · Springfield, TN · Accident · Serious injuries · Data collection · Final report · Jan 18, 2010 · N2111K · Substantial damage
  > The student pilot's failure to maintain control of the airplane during a go-around after a bounced landing.
- [NTSB ERA10LA082](https://openairdocs.org/ntsb/ERA10LA082.md): Piper PA-32RT-300 · Memphis, TN · Accident · 1 fatal · Limited investigation · Final report · Nov 29, 2009 · N9243C · Substantial damage
  > The pilot's failure to execute a timely missed approach and subsequent failure to maintain aircraft control, after he was unable to establish the airplane on the instrument approach. Contributing to the accident was the pilot's possible impairment due to his…
- [NTSB ERA09CA255](https://openairdocs.org/ntsb/ERA09CA255.md): Martin Edward H Fire Star II · Church Hill, TN · Accident · Serious injuries · Data collection · Final report · Apr 18, 2009 · N582EF · Substantial damage
  > The pilot's failure to maintain adequate airspeed to avoid an aerodynamic stall during final approach.
- [NTSB ERA09FA068](https://openairdocs.org/ntsb/ERA09FA068.md): Beech 95-B55 (T4 · Whites Creek, TN · Accident · 3 fatal · Field investigation · Final report · Nov 24, 2008 · N412ES · Destroyed
  > The pilot's failure to feather the left propeller and secure the left engine following the total loss of left engine power, and his subsequent failure to maintain airspeed, lateral, and directional control of the airplane. Contributing to the accident was the…
- [NTSB NYC08LA306](https://openairdocs.org/ntsb/NYC08LA306.md): Beech G35 · Knoxville, TN · Accident · No injuries · Limited investigation · Final report · Sep 6, 2008 · N4403D · Substantial damage
  > The pilot's improper fuel consumption calculations which resulted in total loss of engine power due to fuel exhaustion.
- [NTSB NYC08CA278](https://openairdocs.org/ntsb/NYC08CA278.md): Piper PA-28-235 · Dresden, TN · Accident · No injuries · Data collection · Final report · Aug 9, 2008 · N9365W · Substantial damage
  > The pilot's failure to maintain the proper altitude/clearance while on final approach.
- [NTSB NYC07LA243](https://openairdocs.org/ntsb/NYC07LA243.md): Fokker VI · Morristown, TN · Accident · Serious injuries · Limited investigation · Final report · Sep 30, 2007 · UNREG · Substantial damage
  > A loss of engine power for undetermined reasons during approach.
- [NTSB ATL07LA128](https://openairdocs.org/ntsb/ATL07LA128.md): Beech B90 · Chattanooga, TN · Accident · Minor injuries · Limited investigation · Final report · Sep 20, 2007 · N10TM · Substantial damage
  > The pilot's inadequate preflight planning, which resulted in fuel exhaustion during the landing approach.
- [NTSB ATL07CA050](https://openairdocs.org/ntsb/ATL07CA050.md): Cessna 172K · Paris, TN · Accident · Minor injuries · Data collection · Final report · Mar 12, 2007 · N46588 · Substantial damage
  > The pilot's improper fuel management resulting in a total loss of engine power due to fuel exhaustion.
- [NTSB ANC07LA009](https://openairdocs.org/ntsb/ANC07LA009.md): Gates Learjet 35A · Nashville, TN · Accident · No injuries · Limited investigation · Final report · Dec 26, 2006 · N136WE · Substantial damage
  > The pilot's inadequate compensation for gusty crosswind conditions during landing, which resulted in a loss of control and collision with the runway. Factors contributing to the accident were the failure of the aileron augmentation (spoiler) flight control…
- [NTSB CHI07FA045](https://openairdocs.org/ntsb/CHI07FA045.md): Beech A36 · Chattanooga, TN · Accident · 4 fatal · Field investigation · Final report · Dec 23, 2006 · N3704B · Destroyed
  > The pilot's reported spatial disorientation which lead to not maintaining altitude/clearance from terrain and not obtaining/maintaining a proper climb rate during the missed approach. Factors were the night, the clouds encountered on approach, and trees.

Next page: https://openairdocs.org/ntsb-phases/500/cases.md?state=TN&page=2

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
WITH phase_names(main, name) AS (VALUES (100, 'Prior to flight'), (150, 'Standing'), (200, 'Pushback/towing'), (250, 'Taxi'), (300, 'Takeoff'), (350, 'Initial climb'), (400, 'Enroute'), (450, 'Maneuvering'), (500, 'Approach'), (550, 'Landing'), (600, 'Emergency descent'), (650, 'Uncontrolled descent'), (700, 'Post-impact'), (750, 'After landing'), (800, 'Other'), (990, 'Unknown')),
  crosswalk(code, main, name) AS (VALUES (500, 150, 'Standing'), (501, 150, 'Standing - pre-flight'), (502, 150, 'Standing - starting engine(s)'), (503, 150, 'Standing - engine(s) operating'), (504, 150, 'Standing - engine(s) not operating'), (505, 150, 'Standing - idling rotors'), (510, 250, 'Taxi'), (511, 200, 'Taxi - pushback/tow'), (512, 250, 'Taxi - to takeoff'), (513, 250, 'Taxi - from landing'), (514, 250, 'Taxi - aerial'), (520, 300, 'Takeoff'), (521, 300, 'Takeoff - roll/run'), (522, 350, 'Takeoff - initial climb'), (523, 300, 'Takeoff - aborted'), (530, 400, 'Climb'), (531, 400, 'Climb - to cruise'), (540, 400, 'Cruise'), (541, 400, 'Cruise - normal'), (542, 400, 'Maneuvering - holding (IFR)'), (550, 400, 'Descent'), (551, 400, 'Descent - normal'), (552, 600, 'Descent - emergency'), (553, 650, 'Descent - uncontrolled'), (560, 500, 'Approach'), (561, 500, 'Approach - VFR pattern - downwind'), (562, 500, 'Approach - VFR pattern - base turn'), (563, 500, 'Approach - VFR pattern - base leg/base to final'), (564, 500, 'Approach - VFR pattern - final approach'), (565, 500, 'Go-around (VFR)'), (566, 500, 'Approach - IAF to FAF/outer marker (IFR)'), (567, 500, 'Approach - FAF/outer marker to threshold (IFR)'), (568, 500, 'Circling (IFR)'), (569, 500, 'Missed approach (IFR)'), (570, 550, 'Landing'), (571, 550, 'Landing - flare/touchdown'), (572, 550, 'Landing - roll'), (573, 550, 'Landing - aborted'), (574, 550, 'Emergency landing'), (575, 550, 'Emergency landing after takeoff'), (576, 600, 'Emergency descent/landing'), (580, 450, 'Maneuvering'), (581, 450, 'Maneuvering - aerial application'), (582, 450, 'Maneuvering - turn to reverse direction'), (583, 450, 'Maneuvering - turn to landing area (emergency)'), (590, 450, 'Hover'), (591, 450, 'Hover - in ground effect'), (592, 450, 'Hover - out of ground effect'), (600, 800, 'Other'), (610, 990, 'Unknown')),
  current_codes AS (
    SELECT e.case_mkey, TRY_CAST(e."tier1Number" AS INTEGER) AS code,
      row_number() OVER (PARTITION BY e.case_mkey ORDER BY coalesce(e."isDefiningEvent", false) DESC, e.position) AS n
    FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e
    WHERE e.aircrafts_position = 1 AND e."tier1Number" GLOB '[1-9][0-9]*'
      AND (e."isDefiningEvent" OR e.case_mkey IN (SELECT "mKey" FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' WHERE "isPre1982"))
  ),
  phases AS (
    SELECT case_mkey, 'current' AS scheme, code, CASE WHEN code >= 990 THEN 990 ELSE code // 50 * 50 END AS main
    FROM current_codes WHERE n = 1
    UNION ALL
    SELECT o.case_mkey, 'older', o."phaseOfFlightCode", w.main
    FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o JOIN crosswalk w ON w.code = o."phaseOfFlightCode"
    WHERE o.aircrafts_position = 1 AND o."occurrenceNumber" = 1 AND o.case_mkey NOT IN (SELECT case_mkey FROM current_codes)
  ),
  case_phases AS (
    SELECT p.*, c."eventDate", c."highestInjuryLevel" = 'Fatal' AS fatal, a.aircraft_model_code
    FROM phases p JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = p.case_mkey
    LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = p.case_mkey AND a.position = 1
    WHERE c."eventDate" >= DATE '1962-01-01' AND p.main IN (SELECT main FROM phase_names)
  )
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 case_mkey FROM case_phases WHERE main = 500)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/500/cases?state=TN

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.