# NTSB investigations, TN: Enroute

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 11 · 522 cases

## Latest cases

- [NTSB ERA26LA257](https://openairdocs.org/ntsb/ERA26LA257.md): Cirrus Design SR22 · Lafayette, TN · Accident · No injuries · Class 3 · Limited · Preliminary report · Jul 2, 2026 · N127DC · Substantial damage
  > On July 2, 2026, at 1032 central daylight time, a Cirrus Design Corp SR22, N127DC, was substantially damaged when it was involved in an accident near Lafayette, Tennessee. The pilot and passenger sustained no injuries. The airplane was operated as a Title 14…
- [NTSB ERA26LA127](https://openairdocs.org/ntsb/ERA26LA127.md): Piper PA-28-151 · Arno, TN · Accident · No injuries · Class 3 · Limited · Preliminary report · Feb 24, 2026 · N85RW · Substantial damage
  > On February 24, 2026, about 1107 central standard time, a Piper PA-28-151, N85RW, was substantially damaged when it was involved in an accident near Arno, Tennessee. The pilot was not injured. The airplane was operated as a 14 Code of Federal Regulations Part…
- [NTSB ERA26LA093](https://openairdocs.org/ntsb/ERA26LA093.md): Cessna 177 · Ocoee, TN · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Jan 13, 2026 · N34959 · Substantial damage
  > On January 13, 2026, about 1530 eastern standard time, a Cessna 177B, N34959, was substantially damaged when it was involved in an accident near Ocoee, Tennessee. The pilot received minor injuries. The airplane was operated as a Title 14 Code of Federal…
- [NTSB ERA25LA346](https://openairdocs.org/ntsb/ERA25LA346.md): Piper PA-24-180 · Ashland City, TN · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Sep 5, 2025 · N5759P · Substantial damage
  > On September 5, 2025, at 1645 central daylight time, N5759P, a Piper Cherokee PA-24-180, sustained substantial damage when it was involved in an accident near Ashland City, Tennessee. The private pilot sustained minor injuries. The flight was conducted as a…
- [NTSB ERA25FA253](https://openairdocs.org/ntsb/ERA25FA253.md): Ercoupe 415 · Gallatin, TN · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jul 2, 2025 · N93985 · Substantial damage
  > On July 2, 2025, about 1300 central daylight time, an Ercoupe 415-C, N93985, was substantially damaged when it was involved in an accident near Gallatin, Tennessee. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal…
- [NTSB DCA25LA239](https://openairdocs.org/ntsb/DCA25LA239.md): Airbus A320 · Nashville, TN · Accident · Serious injuries · Class 4 · Limited · Final report · Jun 22, 2025 · N616NK · No damage
  > The airplane’s encounter with moderate convective turbulence during descent.
- [NTSB ERA25LA227](https://openairdocs.org/ntsb/ERA25LA227.md): Cirrus Design SR22 · Hartsville, TN · Accident · No injuries · Class 3 · Limited · Preliminary report · Jun 12, 2025 · N312DA · Substantial damage
  > On June 12, 2025, about 1750 central daylight time, a Cirrus SR22, N312DA, was substantially damaged when it was involved in an accident near Hartsville, Tennessee. The private pilot was not injured. The airplane was operated as a Title 14 Code of Federal…
- [NTSB DCA25LA197](https://openairdocs.org/ntsb/DCA25LA197.md): Boeing 737 · Centerville, TN · Accident · No injuries · Class 4 · Limited · Final report · May 2, 2025 · N247WN · Substantial damage
  > An encounter with hail during descent.
- [NTSB WPR25FA126](https://openairdocs.org/ntsb/WPR25FA126.md): Mooney M20F · Reliance, TN · Accident · 3 fatal · Class 3 · Field · Preliminary report · Apr 11, 2025 · N7026V · Substantial damage
  > On April 11, 2025, about 1402 eastern daylight time, a Mooney M20F, N7026V, sustained substantial damage when it was involved in an accident near Reliance, Tennessee. The pilot, pilot-rated passenger and passenger were fatally injured. The airplane was…
- [NTSB ERA25LA114](https://openairdocs.org/ntsb/ERA25LA114.md): Cessna 172P · Clarksville, TN · Accident · No injuries · Class 3 · Limited · Final report · Feb 3, 2025 · N62112 · Substantial damage
  > The flight instructor’s inadequate preflight inspection of the airplane, which allowed the partially secured engine cowl to separate in flight.
- [NTSB ERA25FA037](https://openairdocs.org/ntsb/ERA25FA037.md): Cessna 150F · Wilder, TN · Accident · 1 fatal · Class 3 · Field · Final report · Oct 31, 2024 · N8110S · Destroyed
  > The student pilot’s decision to continue the visual flight rules flight into instrument meteorological conditions at night, which resulted in controlled flight into terrain.
- [NTSB ERA24FA217](https://openairdocs.org/ntsb/ERA24FA217.md): Beech V35 · Franklin, TN · Accident · 3 fatal · Class 3 · Field · Final report · May 15, 2024 · N47WT · Destroyed
  > The pilot’s flight into convective weather, which resulted in a loss of control due to spatial disorientation and a subsequent inflight breakup of the airplane. Contributing to the accident was the lack of accurate weather intensity depiction on the…
- [NTSB ERA24FA176](https://openairdocs.org/ntsb/ERA24FA176.md): Piper PA-32R-301 · Knoxville, TN · Accident · 1 fatal · Class 3 · Field · Final report · Apr 12, 2024 · N9236J · Destroyed
  > The 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 DCA24LA130](https://openairdocs.org/ntsb/DCA24LA130.md): Boeing 737-800 · Paris, TN · Accident · Serious injuries · Class 4 · Limited · Final report · Mar 15, 2024 · N8520Q · No damage
  > An encounter with convective turbulence.
- [NTSB ERA24LA095](https://openairdocs.org/ntsb/ERA24LA095.md): Cessna 210D · Paris, TN · Accident · No injuries · Class 3 · Limited · Final report · Jan 22, 2024 · N3857Y · Substantial damage
  > The disruption of torque to the No 4 connecting rod journals, which resulted in a spun bearing and the subsequent total loss of engine power.
- [NTSB ERA24LA087](https://openairdocs.org/ntsb/ERA24LA087.md): Cessna 150 · Hohenwald, TN · Accident · No injuries · Class 3 · Limited · Final report · Jan 10, 2024 · N7UT · Substantial damage
  > The 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 ERA24LA082](https://openairdocs.org/ntsb/ERA24LA082.md): Mooney M20K · Tullahoma, TN · Accident · No injuries · Class 3 · Limited · Final report · Jan 3, 2024 · N231GG · Substantial damage
  > A total loss of engine power for undetermined reasons.
- [NTSB ERA24LA076](https://openairdocs.org/ntsb/ERA24LA076.md): Bell Helicopter Textron 206L-1 · Walland, TN · Accident · No injuries · Class 3 · Limited · Final report · Dec 28, 2023 · N571CJ · Substantial damage
  > The 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 ERA24FA058](https://openairdocs.org/ntsb/ERA24FA058.md): Beech 35-C33 · Pulaski, TN · Accident · 2 fatal · Class 3 · Field · Final report · Dec 7, 2023 · N5891J · Destroyed
  > The pilot’s failure to maintain airplane control, which resulted in pilot-induced oscillations and a subsequent loss of control and impact with terrain.
- [NTSB ERA23LA372](https://openairdocs.org/ntsb/ERA23LA372.md): Cessna 182P · Prospect, TN · Accident · Minor injuries · Class 3 · Limited · Final report · Sep 14, 2023 · N8443M · Substantial damage
  > A loss of engine power due to the fatigue failure of the No. 6 cylinder exhaust valve rocker boss.
- [NTSB ERA23LA361](https://openairdocs.org/ntsb/ERA23LA361.md): Beech V35 · Rutledge, TN · Accident · No injuries · Class 3 · Limited · Final report · Sep 2, 2023 · N5431U · Substantial damage
  > A total loss of engine power due to the fatigue failure of a retaining circlip in one of the No. 2 crankshaft cheek counterweights, which resulted in liberation of the counterweight.
- [NTSB ERA23LA264](https://openairdocs.org/ntsb/ERA23LA264.md): Piper PA28 · Lancaster, TN · Accident · Minor injuries · Class 3 · Limited · Final report · May 21, 2023 · N9139J · Substantial damage
  > The fatigue failure of an exhaust valve, resulting in a partial loss of engine power.
- [NTSB ERA23FA219](https://openairdocs.org/ntsb/ERA23FA219.md): Cessna 182 · Reliance, TN · Accident · 1 fatal · Class 3 · Field · Final report · May 7, 2023 · N725AS · Substantial damage
  > The 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 ERA23LA059](https://openairdocs.org/ntsb/ERA23LA059.md): American AA-1A · Sparta, TN · Accident · No injuries · Class 3 · Limited · Final report · Nov 4, 2022 · N7254L · Substantial damage
  > A 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 ERA23FA025](https://openairdocs.org/ntsb/ERA23FA025.md): Piper PA-32-300 · Brentwood, TN · Accident · 1 fatal · Class 3 · Field · Final report · Oct 18, 2022 · N600JG · Destroyed
  > A 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 CEN22FA406](https://openairdocs.org/ntsb/CEN22FA406.md): Cessna 182 · Cleveland, TN · Accident · 2 fatal · Class 3 · Field · Final report · Sep 5, 2022 · N58807 · Destroyed
  > The pilot’s loss of airplane control while operating in instrument meteorological conditions.
- [NTSB CEN22FA217](https://openairdocs.org/ntsb/CEN22FA217.md): Cessna 162 · Memphis, TN · Accident · 1 fatal · Class 3 · Field · Final report · May 31, 2022 · N162KG · Substantial damage
  > Pilot incapacitation due to an acute cardiac event.
- [NTSB ERA22LA249](https://openairdocs.org/ntsb/ERA22LA249.md): Aeronca 7AC · Melrose, TN · Accident · Minor injuries · Class 3 · Limited · Final report · May 29, 2022 · N1294E · Substantial damage
  > A total loss of engine power due to carburetor icing.
- [NTSB ERA22LA139](https://openairdocs.org/ntsb/ERA22LA139.md): Cessna 152 · Madisonville, TN · Accident · Minor injuries · Class 3 · Limited · Final report · Feb 28, 2022 · N68218 · Substantial damage
  > A partial loss of engine power for undetermined reasons.
- [NTSB ERA22FA096](https://openairdocs.org/ntsb/ERA22FA096.md): Robinson Helicopter R44 II · Cosby, TN · Accident · 1 fatal · Class 3 · Field · Final report · Dec 29, 2021 · N544SC · Substantial damage
  > The pilot’s intentional, continued flight into instrument meteorological conditions in a helicopter that was not certified for instrument conditions, which resulted in a loss of helicopter control and a collision with trees and terrain.
- [NTSB ERA22LA037](https://openairdocs.org/ntsb/ERA22LA037.md): Piper PA-30 · Waverly, TN · Accident · No injuries · Class 3 · Limited · Final report · Oct 29, 2021 · N30SH · Substantial damage
  > The pilot’s improper pre-flight fuel planning, which resulted in a total loss of engine power to both engines due to fuel exhaustion.
- [NTSB ERA21FA263](https://openairdocs.org/ntsb/ERA21FA263.md): Cirrus SR22 · Mercer, TN · Accident · 1 fatal · Class 3 · Field · Final report · Jun 21, 2021 · N333LZ · Substantial damage
  > A partial loss of engine power due to foreign object debris contamination of the left turbocharger wastegate. Contributing to the accident was the pilot’s failure to divert to the nearest airport.
- [NTSB ERA21FA232](https://openairdocs.org/ntsb/ERA21FA232.md): Gulfstream American AA-5A · Crossville, TN · Accident · 1 fatal · Class 3 · Field · Final report · May 25, 2021 · N26889 · Destroyed
  > A partial loss of engine power due to carburetor icing, which resulted in a descent and impact with terrain. Contributing to the accident was the pilot’s failure to apply carburetor heat following the initial loss of engine power.
- [NTSB ERA21FA189](https://openairdocs.org/ntsb/ERA21FA189.md): Piper PA-28RT-201T · Brownsville, TN · Accident · 2 fatal · Class 3 · Field · Final report · Apr 21, 2021 · N4303G · Destroyed
  > The student pilot’s continued visual flight rules flight into night instrument meteorological conditions, which resulted in spatial disorientation and a rapid uncontrolled descent into terrain. Contributing to the accident were the self-induced and external…
- [NTSB ERA20LA313](https://openairdocs.org/ntsb/ERA20LA313.md): Beech A36 · Jackson, TN · Accident · 1 fatal · Class 3 · Limited · Final report · Sep 11, 2020 · N74HS · Substantial damage
  > The pilot’s inadequate preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot's impairment due to alcohol.
- [NTSB ERA20CA222](https://openairdocs.org/ntsb/ERA20CA222.md): Beech 77 · Elizabethton, TN · Accident · No injuries · Class 4 · Data collection · Final report · Jun 20, 2020 · N3815Z · Substantial damage
  > The student pilot's decision to continue from visual flight into instrument meteorological conditions, which resulted in a collision with trees and mountainous terrain.
- [NTSB ERA20CA090](https://openairdocs.org/ntsb/ERA20CA090.md): Pitts A · Hickory Valley, TN · Accident · No injuries · Class 4 · Data collection · Final report · Dec 19, 2019 · N113A · Substantial damage
  > The pilot’s improper fuel planning which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB ANC19LA036](https://openairdocs.org/ntsb/ANC19LA036.md): Stoddard Hamilton Glasair II · Chattanooga, TN · Accident · Serious injuries · Class 3 · Limited · Final report · Jul 17, 2019 · C-GAFT · Substantial damage
  > The pilot's failure to switch to the secondary electrical system after the primary electrical system failed for unknown reasons.
- [NTSB ERA19LA228](https://openairdocs.org/ntsb/ERA19LA228.md): Pietenpol BIG Piet · Gainesboro, TN · Accident · No injuries · Class 3 · Limited · Final report · Jul 16, 2019 · N973BP · Substantial damage
  > Separation of the spinner cap for reasons that could not be determined based on available evidence, which resulted in contact and subsequent separation of the wooden propeller blade tip.
- [NTSB CEN19LA175](https://openairdocs.org/ntsb/CEN19LA175.md): Flightstar FC-II · Knoxville, TN · Accident · Minor injuries · Class 3 · Limited · Final report · Jun 18, 2019 · N354AR · Destroyed
  > A total loss of engine power for reasons that could not be determined based on available evidence.
- [NTSB ERA19LA177](https://openairdocs.org/ntsb/ERA19LA177.md): Zenith CH750 · Savannah, TN · Accident · No injuries · Class 3 · Limited · Final report · May 16, 2019 · N750GZ · Substantial damage
  > The total loss of engine power due to a loss of all electrical power. Contributing to the accident was the inaccessible placement of the alternator circuit breaker and the construction of the airplane without a backup electrical source.
- [NTSB DCA19CA091](https://openairdocs.org/ntsb/DCA19CA091.md): Boeing 737 · Franklin, TN · Accident · Serious injuries · Class 4 · Data collection · Final report · Feb 18, 2019 · N3730B · No damage
  > an encounter with convective turbulence during descent.
- [NTSB DCA19CA005](https://openairdocs.org/ntsb/DCA19CA005.md): Boeing 737 · Nashville, TN · Accident · Serious injuries · Class 4 · Data collection · Final report · Oct 10, 2018 · N287WN · No damage
  > flight attendant tripping over a passenger's knee that resulted in hot liquid splashing on the flight attendant.
- [NTSB ERA18LA113](https://openairdocs.org/ntsb/ERA18LA113.md): Fairchild Funk M62C F 23A · Columbia, TN · Accident · No injuries · Limited investigation · Final report · Mar 23, 2018 · N1131Z · Substantial damage
  > The pilot's inadvertent selection of the fuel selector handle to the off position, which resulted in fuel starvation and a total loss of engine power.
- [NTSB ANC18FA022](https://openairdocs.org/ntsb/ANC18FA022.md): Beech 35 A33 · Helenwood, TN · Accident · 1 fatal · Field investigation · Final report · Jan 30, 2018 · N9378Y · Substantial damage
  > The pilot's mismanagement of the available fuel, which resulted in a total loss of engine power due to fuel starvation. Contributing to the accident was the pilot's failure to follow the air start checklist.
- [NTSB ERA17LA326](https://openairdocs.org/ntsb/ERA17LA326.md): Air Tractor AT 502 · Union City, TN · Accident · No injuries · Limited investigation · Final report · Sep 15, 2017 · N4531K · Substantial damage
  > The catastrophic failure of the compressor turbine blades, which resulted in a total loss of engine power. Contributing to the accident was the installation of undocumented, time-limited engine components of indeterminate age.
- [NTSB DCA17LA183](https://openairdocs.org/ntsb/DCA17LA183.md): Bombardier CL 600 2C10 · McKellar, TN · Accident · Serious injuries · Class 3 · Limited · Final report · Aug 22, 2017 · N745SK · No damage
  > An encounter with convective turbulence while maneuvering to avoid conflicting traffic.
- [NTSB ERA17FA073](https://openairdocs.org/ntsb/ERA17FA073.md): Cessna 182 · Gatlinburg, TN · Accident · 3 fatal · Field investigation · Final report · Dec 26, 2016 · N1839X · Destroyed
  > The non-instrument-rated pilot's intentional visual flight rules flight into instrument meteorological conditions, which resulted in controlled flight into terrain. Contributing to the accident was the pilot's established anti-authority attitude.
- [NTSB ERA17CA012](https://openairdocs.org/ntsb/ERA17CA012.md): Bellanca 8KCAB · Knoxville, TN · Accident · Minor injuries · Data collection · Final report · Oct 11, 2016 · N2504Z · Substantial damage
  > The pilot's intentional low-altitude operation, which resulted in his failure to maintain clearance from unmarked utility wires.
- [NTSB ERA17LA019](https://openairdocs.org/ntsb/ERA17LA019.md): Cessna 182 · Toone, TN · Accident · No injuries · Limited investigation · Final report · Oct 9, 2016 · N65903 · Substantial damage
  > A stuck No. 3 cylinder exhaust valve, which resulted in failure of the cylinder's valvetrain components, breach of the cylinder's rocker box cover, and partial loss of engine power due to oil starvation.

Next page: https://openairdocs.org/ntsb-phases/400/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 = 400)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/400/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.