# NTSB investigations, TN: Takeoff

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 3 · 150 cases

## Latest cases

- [NTSB ERA26LA306](https://openairdocs.org/ntsb/ERA26LA306.md): Powrachute Pegasus · Humboldt, TN · Accident · Serious injuries · Class 4 · Limited · Investigation open · Aug 16, 2026 · N2541Z · Substantial damage
- [NTSB ERA26LA255](https://openairdocs.org/ntsb/ERA26LA255.md): Cessna 172M · Lafayette, TN · Accident · Minor injuries · Class 4 · Limited · Final report · Jun 30, 2026 · N6814H · Substantial damage
  > The passenger’s abrupt manipulation of the flight controls during takeoff, which resulted in a loss of directional control and collision with a fence.
- [NTSB ERA26FA241](https://openairdocs.org/ntsb/ERA26FA241.md): Cessna 177RG · Morrison, TN · Accident · 2 fatal · Class 3 · Field · Preliminary report · Jun 17, 2026 · N7637V · Substantial damage
  > On June 17, 2026, about 1215 central daylight time, a Cessna 177RG, N7637V, was substantially damaged when it was involved in an accident near Morrison, Tennessee. The pilot and pilot-rated passenger were fatally injured. The airplane was operated as a Title…
- [NTSB ERA25LA371](https://openairdocs.org/ntsb/ERA25LA371.md): North American T-6G · Rossville, TN · Accident · Minor injuries · Class 4 · Limited · Final report · Sep 28, 2025 · N888WV · Substantial damage
  > The pilot’s failure to adequately monitor the airplane’s path during takeoff toward the setting sun. Contributing was the undetected worn and fractured tailwheel locking pin.
- [NTSB ERA25LA291](https://openairdocs.org/ntsb/ERA25LA291.md): Beech 35-C33 · Kingston, TN · Accident · Minor injuries · Class 4 · Limited · Final report · Aug 6, 2025 · N500HT · Substantial damage
  > The pilot’s failure to maintain directional control during takeoff roll, which resulted in a runway excursion and collision with haybales.
- [NTSB ERA25LA290](https://openairdocs.org/ntsb/ERA25LA290.md): Gary W Lewinski Sonex · Tellico Plains, TN · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Aug 5, 2025 · N67BG · Substantial damage
  > On August 5, 2025, about 1131 eastern daylight time, a Lewinski Sonex, N67BG, was substantially damaged when it was involved in an accident near Tellico Plains, Tennessee. The private pilot was seriously injured. The airplane was operated as a Title 14?Code…
- [NTSB ERA25LA222](https://openairdocs.org/ntsb/ERA25LA222.md): Dehavilland DHC-6 Twin Otter · Tullahoma, TN · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Jun 8, 2025 · N166DH · Substantial damage
  > On June 8, 2025, about 1220 central daylight time, a DeHavilland DHC-6 Twin Otter, N166DH, was involved in an accident near Tullahoma, Tennessee. The commercial pilot and five passengers were seriously injured, and 15 passengers were not injured. The flight…
- [NTSB ERA25LA213](https://openairdocs.org/ntsb/ERA25LA213.md): Cessna 172N · Murfreesboro, TN · Accident · No injuries · Class 4 · Limited · Final report · May 22, 2025 · N6317D · Substantial damage
  > The 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 ERA25LA022](https://openairdocs.org/ntsb/ERA25LA022.md): Textron T206H · Blountville, TN · Accident · No injuries · Class 4 · Limited · Final report · Oct 17, 2024 · N89S · Substantial damage
  > The 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 DCA24FA300](https://openairdocs.org/ntsb/DCA24FA300.md): Boeing 737-9 · Nashville, TN · Incident · No injuries · Class 3 · Field · Preliminary report · Sep 12, 2024 · N919AK · 2 aircraft · Minor damage
  > On September 12, 2024, about 0914 central daylight time (CDT), Alaska Airlines flight 369 (ASA369), a Boeing 737-900, N919AK, rejected their take-off on runway 13 at Nashville International Airport (BNA), Nashville, Tennessee, when Southwest Airlines flight…
- [NTSB ERA24LA254](https://openairdocs.org/ntsb/ERA24LA254.md): North American Navion · Tullahoma, TN · Accident · Minor injuries · Class 3 · Limited · Final report · Jun 8, 2024 · N91173 · Substantial damage
  > A total loss of engine power during takeoff as a result of fuel starvation.
- [NTSB ERA24LA234](https://openairdocs.org/ntsb/ERA24LA234.md): Cessna 150 · Fayetteville, TN · Accident · No injuries · Class 4 · Limited · Final report · May 31, 2024 · N8536G · Substantial damage
  > A collision with a deer during the takeoff roll.
- [NTSB ERA24LA032](https://openairdocs.org/ntsb/ERA24LA032.md): Taylorcraft BC12-65 · Columbia, TN · Accident · Minor injuries · Class 3 · Limited · Final report · Nov 11, 2023 · N29868 · Substantial damage
  > A partial loss of engine power due to an accumulation of carburetor ice, resulting in an off-airport landing and substantial damage to the airplane.
- [NTSB ERA23LA347](https://openairdocs.org/ntsb/ERA23LA347.md): Piper PA28 · Knoxville, TN · Accident · No injuries · Class 3 · Limited · Final report · Jul 27, 2023 · N15417 · Substantial damage
  > An 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 ERA23LA271](https://openairdocs.org/ntsb/ERA23LA271.md): Cessna 172 · Seymore, TN · Accident · Minor injuries · Class 4 · Limited · Final report · Jun 18, 2023 · N12395 · Substantial damage
  > The flight instructor’s failure to properly configure the wing flaps for a soft-field takeoff on a short runway, which resulted in a runway overrun and collision with trees.
- [NTSB ERA23LA227](https://openairdocs.org/ntsb/ERA23LA227.md): Gulfstream American AA-5A · Knoxville, TN · Accident · No injuries · Class 4 · Limited · Final report · May 4, 2023 · N26941 · Substantial damage
  > The pilot’s failure to maintain directional control during takeoff in gusting wind conditions.
- [NTSB ERA23LA145](https://openairdocs.org/ntsb/ERA23LA145.md): Cirrus Design SR22T · Knoxville, TN · Accident · No injuries · Class 4 · Limited · Final report · Mar 7, 2023 · N320CA · Substantial damage
  > The pilot's failure to maintain directional control during the takeoff roll where a gusting and shifting crosswind prevailed.
- [NTSB ERA22LA295](https://openairdocs.org/ntsb/ERA22LA295.md): Piper PA-24-260 · Lewisburg, TN · Accident · No injuries · Class 4 · Limited · Final report · Jun 27, 2022 · N9077P · Substantial damage
  > The pilot’s loss of control during the takeoff roll, which resulted in a runway excursion.
- [NTSB ERA21LA314](https://openairdocs.org/ntsb/ERA21LA314.md): Cessna 172S · Clarksville, TN · Accident · No injuries · Class 4 · Limited · Final report · Jun 17, 2021 · N35585 · Substantial damage
  > The flight instructor’s inadequate remedial action during takeoff, which resulted in a runway excursion.
- [NTSB ERA21LA173](https://openairdocs.org/ntsb/ERA21LA173.md): Piper PA-23-250 · Springfield, TN · Accident · Serious injuries · Class 3 · Limited · Final report · Apr 5, 2021 · N5018Y · Substantial damage
  > The flight instructor’s failure to abort the takeoff following a loss of left engine power due to fuel starvation. Also causal was the inadequate maintenance of the left fuel cap by unknown maintenance personnel, which resulted in a blockage of the fuel…
- [NTSB ERA21LA121](https://openairdocs.org/ntsb/ERA21LA121.md): Robinson Helicopter R66 · Knoxville, TN · Accident · No injuries · Class 4 · Limited · Final report · Jan 30, 2021 · N660TN · Substantial damage
  > The pilot’s failure to maintain directional control of the helicopter, which resulted in rear portion of the right skid contacting the ground and a subsequent dynamic rollover.
- [NTSB ERA20LA284](https://openairdocs.org/ntsb/ERA20LA284.md): Rotorsport UK MTOsport 2017 · Springfield, TN · Accident · No injuries · Class 3 · Limited · Final report · Aug 11, 2020 · N615MW · Substantial damage
  > The pilot’s decision to continue the takeoff when the gyroplane’s actual performance failed to match that predicted in his performance planning. Contributing to the accident was the gyrocopter’s insufficient performance for reasons that could not be…
- [NTSB ERA20LA121](https://openairdocs.org/ntsb/ERA20LA121.md): Piper PA28 · Mount Pleasant, TN · Accident · No injuries · Class 3 · Limited · Final report · Feb 28, 2020 · N79HA · Substantial damage
  > A partial loss of engine power during initial climb due to carburetor icing that formed while idling on the ground for an extended amount of time. Contributing was the flight instructor's failure to perform the recommended ground checks before takeoff.
- [NTSB GAA20CA042](https://openairdocs.org/ntsb/GAA20CA042.md): Beech 19 · Somerville, TN · Accident · No injuries · Data collection · Final report · Oct 9, 2019 · N2177W · Substantial damage
  > The pilot's failure to move the fuel selector position to the "on" position before takeoff, which resulted in a total loss of engine power and necessitated a forced landing to a field shortly after takeoff, and his subsequent improper decision to take off…
- [NTSB GAA19CA456](https://openairdocs.org/ntsb/GAA19CA456.md): Piper PA46 · Sparta, TN · Accident · No injuries · Data collection · Final report · Jul 27, 2019 · N12KW · Substantial damage
  > The pilot's failure to maintain the runway heading during an aborted takeoff, which resulted in a runway excursion and collision with a sign and terrain. Contributing to the need to abort the takeoff was the pilot's improper decision to take off with the…
- [NTSB WPR18FA053](https://openairdocs.org/ntsb/WPR18FA053.md): Browning Gregory S Zodiac 601XL · Thompson's Station, TN · Accident · 1 fatal · Field investigation · Final report · Dec 21, 2017 · N929GB · Substantial damage
  > The sport pilot's decision to depart in and continue flight in instrument meteorological conditions, which resulted in controlled flight into terrain.
- [NTSB ERA16LA191](https://openairdocs.org/ntsb/ERA16LA191.md): Sikes Zenith CH750 Stol · Lawrenceburg, TN · Accident · Minor injuries · Limited investigation · Final report · May 22, 2016 · N925PS · Substantial damage
  > The pilot's failure to perform an adequate preflight inspection, which resulted in a loss of control due to an improperly-rigged rudder. Contributing to the accident was the pilot's failure to implement and follow proper flight-testing plans.
- [NTSB ERA16LA019](https://openairdocs.org/ntsb/ERA16LA019.md): Beech 23 · Humboldt, TN · Accident · No injuries · Limited investigation · Final report · Oct 18, 2015 · N2339J · Substantial damage
  > A partial loss of engine power due to low No. 2 cylinder compression and an inoperative right magneto.
- [NTSB ERA15CA229](https://openairdocs.org/ntsb/ERA15CA229.md): Wilson Michael A Challenger II · Lebanon, TN · Accident · Minor injuries · Data collection · Final report · May 22, 2015 · N8547W · Substantial damage
  > The non-certificated pilot's failure to maintain airspeed during takeoff, which resulted in an aerodynamic stall, uncontrolled descent, and collision with terrain. Contributing to the accident was the pilot's lack of training and flight experience in the…
- [NTSB ERA15LA138](https://openairdocs.org/ntsb/ERA15LA138.md): Bell 206 · Sevierville, TN · Accident · No injuries · Limited investigation · Final report · Feb 15, 2015 · N3176L · Substantial damage
  > An uncontained engine failure, which resulted from insufficient lubrication of the No. 4 bearing due to carbon buildup on the filter screen of the bearing's oil supply nozzle.
- [NTSB ERA15FA066](https://openairdocs.org/ntsb/ERA15FA066.md): Piper PA28 · Sommerville, TN · Accident · 1 fatal · Field investigation · Final report · Dec 2, 2014 · N8607W · Destroyed
  > The noninstrument-rated pilot's improper decision to attempt visual flight in instrument meteorological conditions, which resulted in an in-flight loss of airplane control due to spatial disorientation. Contributing to the accident was the pilot’s impaired…
- [NTSB ERA14CA169](https://openairdocs.org/ntsb/ERA14CA169.md): Cessna 172M · Knoxville, TN · Accident · No injuries · Data collection · Final report · Mar 23, 2014 · N8893V · Substantial damage
  > The student pilot's failure to maintain directional control during the takeoff roll, which resulted in a collision with an obstacle.
- [NTSB ERA14CA040](https://openairdocs.org/ntsb/ERA14CA040.md): Beech E 55 · Blountville, TN · Accident · No injuries · Data collection · Final report · Nov 5, 2013 · N1908L · Substantial damage
  > The pilot's delayed reaction and loss of directional control while performing a simulated engine failure during the takeoff roll. A factor in the accident was the CFI's delayed reaction to the loss of directional control.
- [NTSB ERA13LA320](https://openairdocs.org/ntsb/ERA13LA320.md): Thompson Bruce D Sonerai II · Pulaski, TN · Accident · 1 fatal · Limited investigation · Final report · Jul 16, 2013 · N788T · Destroyed
  > The pilot's failure to maintain airspeed during a near-vertical climb after takeoff, which resulted in an aerodynamic stall and subsequent collision with terrain.
- [NTSB ERA13CA086](https://openairdocs.org/ntsb/ERA13CA086.md): Cessna 172P · Murfreesboro, TN · Accident · Serious injuries · Data collection · Final report · Dec 13, 2012 · N54500 · Substantial damage
  > The student pilot’s failure to maintain directional control during takeoff, which resulted in a runway excursion.
- [NTSB ERA13FA017](https://openairdocs.org/ntsb/ERA13FA017.md): Arion Lightning · Chuckey, TN · Accident · Serious injuries · Field investigation · Final report · Oct 11, 2012 · N290AL · Substantial damage
  > The pilot’s inadequate preflight planning, which resulted in an attempted takeoff at a high gross weight, near the limit of its aft center of gravity, and with the airplane incorrectly configured with fully extended flaps. Contributing to the accident was the…
- [NTSB ERA12CA585](https://openairdocs.org/ntsb/ERA12CA585.md): Piper PA-28-140 · Maryville, TN · Accident · No injuries · Data collection · Final report · Sep 22, 2012 · N56796 · Substantial damage
  > The pilot’s failure to plan and execute a takeoff that assured obstacle clearance at the departure end of the runway, which resulted in a collision with trees.
- [NTSB ERA12CA232](https://openairdocs.org/ntsb/ERA12CA232.md): Piper PA-28R-180 · Dover, TN · Accident · No injuries · Data collection · Final report · Mar 15, 2012 · N3779T · Substantial damage
  > The pilot's failure to maintain directional control during takeoff in gusty wind conditions, which resulted in a collision with an object and a landing gear collapse during the subsequent landing.
- [NTSB ERA12FA107](https://openairdocs.org/ntsb/ERA12FA107.md): Shaw Douglas Wayne Rans S 7 · Somerville, TN · Accident · 1 fatal · Field investigation · Final report · Dec 11, 2011 · N347DS · Substantial damage
  > The pilot's incapacitation due to a ruptured berry aneurysm during takeoff.
- [NTSB ERA12CA022](https://openairdocs.org/ntsb/ERA12CA022.md): Aeronca 0-58A · Westmoreland, TN · Accident · No injuries · Data collection · Final report · Oct 9, 2011 · N46513 · Substantial damage
  > The pilot's inadequate visual lookout and failure to maintain clearance from an obstacle during takeoff.
- [NTSB ERA12CA013](https://openairdocs.org/ntsb/ERA12CA013.md): Loehle Loehle P-40 · Tullahoma, TN · Accident · Minor injuries · Data collection · Final report · Oct 3, 2011 · N414L · Substantial damage
  > The pilot's delayed decision to abort the takeoff.
- [NTSB ERA11CA478](https://openairdocs.org/ntsb/ERA11CA478.md): Cano Dave Avid Flyer Mkiv · Smithville, TN · Accident · No injuries · Data collection · Final report · Aug 20, 2011 · N52CH · Substantial damage
  > The pilot's failure to maintain directional control during the takeoff roll due to his distraction by an open door.
- [NTSB ERA11CA375](https://openairdocs.org/ntsb/ERA11CA375.md): Temco GC-1B · Sparta, TN · Accident · No injuries · Data collection · Final report · Jul 2, 2011 · N106S · Substantial damage
  > The improper installation of the right rudder control cable by maintenance personnel, which resulted in the pilot's inability to maintain directional control during takeoff.
- [NTSB ERA11LA149](https://openairdocs.org/ntsb/ERA11LA149.md): Cessna 150H · Jonesborough, TN · Accident · No injuries · Limited investigation · Final report · Feb 17, 2011 · N7237S · Substantial damage
  > A partial loss of engine power during initial climb for undetermined reasons.
- [NTSB ERA11CA115](https://openairdocs.org/ntsb/ERA11CA115.md): Cessna 172N · Lebanon, TN · Accident · No injuries · Data collection · Final report · Jan 15, 2011 · N1946F · Substantial damage
  > The student pilot´s failure to maintain directional control during an aborted takeoff, resulting in a runway excursion.
- [NTSB ERA10LA131](https://openairdocs.org/ntsb/ERA10LA131.md): Cessna 172 · Jackson, TN · Accident · No injuries · Limited investigation · Final report · Feb 3, 2010 · N97075 · Substantial damage
  > The student pilot's loss of directional control during the takeoff roll, which resulted in a collision with a snow bank.
- [NTSB ERA10CA061](https://openairdocs.org/ntsb/ERA10CA061.md): American Champion 8GCBC · Clarksville, TN · Accident · No injuries · Data collection · Final report · Nov 12, 2009 · N315AC · Substantial damage
  > The pilot’s failure to maintain directional control during the takeoff roll. Contributing to the accident was his decision to take off with a left quartering tailwind.
- [NTSB NYC08CA191](https://openairdocs.org/ntsb/NYC08CA191.md): Cessna 172M · Chuckey, TN · Accident · Minor injuries · Data collection · Final report · May 22, 2008 · N74WC · Substantial damage
  > The pilot's failure to maintain directional control of the airplane during the takeoff roll. Contributing to the accident was his failure to abort the takeoff.
- [NTSB MIA08CA064](https://openairdocs.org/ntsb/MIA08CA064.md): Clutton Eric Fred S1 · Tullahoma, TN · Accident · No injuries · Data collection · Final report · Feb 16, 2008 · N4499Y · Substantial damage
  > The pilot's failure to maintain control of the airplane during takeoff.
- [NTSB OPS08IA001](https://openairdocs.org/ntsb/OPS08IA001.md): Cessna C 525 · Memphis, TN · Incident · No injuries · Incident investigation · Final report · Oct 12, 2007 · N241EP · No damage
  > The probable cause of this incident was the pilot's inadvertent departure from a taxiway instead of a runway.

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

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