# NTSB investigations, GA: Initial climb

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 10 · 494 cases

## Latest cases

- [NTSB ERA26LA328](https://openairdocs.org/ntsb/ERA26LA328.md): Piper PA-28-180 · Dallas, GA · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Sep 4, 2026 · N7635W · Substantial damage
  > On September 3, 2026, at 2004 eastern daylight time, a Piper PA-28-180, N7635W, was substantially damaged when it was involved in an accident near Dallas, Georgia. The flight instructor and student pilot were seriously injured. The airplane was operated as a…
- [NTSB ENG26LA029](https://openairdocs.org/ntsb/ENG26LA029.md): Boeing 757 · Atlanta, GA · Incident · No injuries · Class 3 · Limited · Preliminary report · Jul 24, 2026 · N662DN · No damage
  > On July 24, 2026, about 14:32 Coordinated Universal Time, a Delta Air Lines Boeing 757-200, N662DN, powered by two Pratt & Whitney PW2037 turbofan engines, experienced a No. 1 (left) engine fire during initial climb from Hartsfield-Jackson Atlanta…
- [NTSB ERA26FA270](https://openairdocs.org/ntsb/ERA26FA270.md): Beech 95-B55 (T42A) · Metter, GA · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jul 13, 2026 · N55FD · Destroyed
  > On July 13, 2026, about 1114 eastern daylight time, a Beechcraft 95-B55, twin-engine airplane, N55FD, was destroyed when it was involved in an accident near Metter, Georgia. The commercial pilot was fatally injured. The airplane was operated as a Title 14…
- [NTSB ERA26LA251](https://openairdocs.org/ntsb/ERA26LA251.md): Jones Peter M Boeing/Jones 75 · Cleveland, GA · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Jun 26, 2026 · N3993C · Substantial damage
  > On June 26, 2026, about 1045 eastern daylight time, a Boeing/Jones 75, N3993C, was substantially damaged when it was involved in an accident near Cleveland, Georgia. The pilot and passenger sustained minor injuries. The airplane was operated as a Title 14…
- [NTSB ENG26LA026](https://openairdocs.org/ntsb/ENG26LA026.md): Cirrus SF50 · Athens, GA · Incident · No injuries · Class 3 · Limited · Preliminary report · Jun 2, 2026 · N129KA · Minor damage
  > On June 2, 2026, at 0945 eastern daylight time, a Cirrus SF50, N129KA, powered by a Williams International FJ33-5A turbofan engine, experienced an uncontained engine failure during climb from Greene County Regional Airport (KCPP), Greensboro, Georgia. There…
- [NTSB ERA26LA092](https://openairdocs.org/ntsb/ERA26LA092.md): Cessna 172P · Flemington, GA · Accident · No injuries · Class 4 · Limited · Final report · Jan 9, 2026 · N96493 · Substantial damage
  > The pilot’s inadvertent manipulation of the mixture control, which resulted in a total loss of engine power during initial climb and a subsequent forced lading.
- [NTSB ERA25LA294](https://openairdocs.org/ntsb/ERA25LA294.md): Piper PA-28-151 · Chamblee, GA · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Aug 9, 2025 · N1080H · Substantial damage
  > On August 9, 2025, about 0033 eastern daylight time, a Piper PA-28-151, N1080H, was substantially damaged when it was involved in an accident near DeKalb-Peachtree Airport (PDK), Chamblee, Georgia. The flight instructor and student pilot were seriously…
- [NTSB ERA25LA016](https://openairdocs.org/ntsb/ERA25LA016.md): Piper PA-28-151 · Newnan, GA · Accident · No injuries · Class 3 · Limited · Final report · Oct 16, 2024 · N41370 · Substantial damage
  > The pilot’s inadequate use of carburetor heat during the engine run-up, which resulted in a partial loss of power due to carburetor icing during takeoff.
- [NTSB ERA24LA392](https://openairdocs.org/ntsb/ERA24LA392.md): Piper PA28 · LaGrange, GA · Accident · Minor injuries · Class 3 · Limited · Final report · Sep 23, 2024 · N4298V · Substantial damage
  > Improper manufacture of a cylinder exhaust valve guide by the engine manufacturer, which resulted in a stuck exhaust valve and a partial loss of engine power during initial climb.
- [NTSB ERA24LA248](https://openairdocs.org/ntsb/ERA24LA248.md): Piper PA-25-235 · Colquitt, GA · Accident · Minor injuries · Class 3 · Limited · Final report · Jun 5, 2024 · N8715L · Substantial damage
  > The failure of the fuel shutoff valve from corrosion, which allowed the valve stem to obstruct the internal fuel port, resulting in a restriction of fuel flow to the engine.
- [NTSB ERA24FA206](https://openairdocs.org/ntsb/ERA24FA206.md): Raytheon A36 · Augusta, GA · Accident · 1 fatal · Class 3 · Field · Final report · May 2, 2024 · N629BE · Destroyed
  > The pilot’s excessive turn rate and bank angle while at low airspeed and altitude, resulting in an accelerated aerodynamic stall, loss of airplane control, and collision with terrain.
- [NTSB ERA23FA370](https://openairdocs.org/ntsb/ERA23FA370.md): Ercoupe 415 · Fitzgerald, GA · Accident · 1 fatal · Class 3 · Field · Final report · Sep 13, 2023 · N2796H · Substantial damage
  > The pilot’s failure to perform pre-takeoff engine runup and carburetor heat check procedures, which resulted in rotation with inadequate climb performance, and his subsequent failure to maintain adequate airspeed and exceedance of the airplane’s critical…
- [NTSB ERA23LA320](https://openairdocs.org/ntsb/ERA23LA320.md): Mesnard Velocity Twin · Sandersville, GA · Accident · 1 fatal · Class 3 · Limited · Final report · Aug 1, 2023 · N106VT · Substantial damage
  > A total loss of power in the right engine due to the right ECU injector wires being severed by the main landing gear actuator piston teeter bar as a result of a lack of clearance and protection of the wiring bundle.
- [NTSB ERA23FA274](https://openairdocs.org/ntsb/ERA23FA274.md): Piper PA-30 · Claxton, GA · Accident · 3 fatal · Class 3 · Field · Final report · Jun 25, 2023 · N7240Y · Substantial damage
  > The flight crew’s improper fuel management, which resulted in the airplane’s right engine being starved of fuel and its subsequent total loss of power.
- [NTSB ERA23FA136](https://openairdocs.org/ntsb/ERA23FA136.md): Piper PA-22-150 · Blue Ridge, GA · Accident · 1 fatal · Class 3 · Field · Final report · Mar 5, 2023 · N3410Z · Substantial damage
  > A loss of engine power due to fuel starvation due to the improper positioning of the fuel selector.
- [NTSB ERA23LA127](https://openairdocs.org/ntsb/ERA23LA127.md): Piper PA-28-181 · Atlanta, GA · Accident · Serious injuries · Class 3 · Limited · Final report · Feb 16, 2023 · N103AV · Substantial damage
  > The flight instructor’s failure to effectively utilize carburetor heat, which resulted in a total loss of engine power during initial climb due to carburetor ice that formed during the engine run-up and taxi.
- [NTSB ERA23LA120](https://openairdocs.org/ntsb/ERA23LA120.md): Mooney M20C · Calhoun, GA · Accident · Serious injuries · Class 3 · Limited · Final report · Jan 28, 2023 · N5587Q · Destroyed
  > A partial loss of engine power during the initial climb due to an improperly installed spark plug.
- [NTSB ERA23LA072](https://openairdocs.org/ntsb/ERA23LA072.md): Daniel Anthony Proctor M24 Orion Plus · Suches, GA · Accident · Serious injuries · Class 4 · Limited · Final report · Nov 26, 2022 · N728RJ · Substantial damage
  > The pilot's decision to take off from the runway midpoint with a tailwind, which resulted in impact with terrain.
- [NTSB ERA22LA325](https://openairdocs.org/ntsb/ERA22LA325.md): Raytheon 400A · Brunswick, GA · Accident · No injuries · Class 4 · Limited · Final report · Jul 15, 2022 · N400MX · Substantial damage
  > An in-flight collision with a bird.
- [NTSB ERA22LA301](https://openairdocs.org/ntsb/ERA22LA301.md): Kolb Firestar · Cleveland, GA · Accident · 1 fatal · Class 3 · Limited · Final report · Jul 8, 2022 · N6136Y · Substantial damage
  > The pilot’s failure to maintain control of the airplane on takeoff for unknown reasons.
- [NTSB ERA22LA239](https://openairdocs.org/ntsb/ERA22LA239.md): Thrush S2R · Hawkinsville, GA · Accident · No injuries · Class 3 · Limited · Final report · May 5, 2022 · N6216M · Substantial damage
  > A failure of the electric main fuel pump due to the carbon brushes having completely worn away.
- [NTSB ERA22LA204](https://openairdocs.org/ntsb/ERA22LA204.md): Cessna 172A · Stockbridge, GA · Accident · Minor injuries · Class 4 · Limited · Final report · Apr 25, 2022 · N7572T · Substantial damage
  > The flight instructor’s delayed remedial action during an unstabilized approach, which resulted in an impact with powerlines and a subsequent loss of control
- [NTSB ERA22LA182](https://openairdocs.org/ntsb/ERA22LA182.md): American AA-1 · Kennesaw, GA · Accident · Minor injuries · Class 3 · Limited · Final report · Apr 7, 2022 · N623W · Substantial damage
  > A loss of engine power due to the formation of carburetor ice.
- [NTSB ERA22FA161](https://openairdocs.org/ntsb/ERA22FA161.md): Cessna 172 · Dahlonega, GA · Accident · 1 fatal · Class 3 · Field · Final report · Mar 19, 2022 · N1410F · Substantial damage
  > The pilot’s delay in initiating a go-around and his failure to maintain airplane control during the initial climb, which resulted in the exceedance of the airplane’s critical angle of attack and an aerodynamic stall.
- [NTSB ERA22FA083](https://openairdocs.org/ntsb/ERA22FA083.md): Cessna 182 · Statesboro, GA · Accident · 1 fatal · Class 3 · Field · Final report · Dec 8, 2021 · N5776B · Destroyed
  > The pilot’s decision to initiate a visual flight rules flight into dark night instrument meteorological conditions, which resulted in spatial disorientation and subsequent loss of control shortly after takeoff.
- [NTSB ERA22FA014](https://openairdocs.org/ntsb/ERA22FA014.md): Piper PA-24-260 · Blairsville, GA · Accident · 1 fatal · Class 3 · Field · Final report · Oct 13, 2021 · N9126P · Destroyed
  > The pilot’s decision to commence the flight in low IFR weather conditions, and making immediate turns after takeoff in IMC, resulting in spatial disorientation and a loss of airplane control.
- [NTSB ERA22FA009](https://openairdocs.org/ntsb/ERA22FA009.md): Cessna P210 · Atlanta, GA · Accident · 4 fatal · Class 3 · Field · Final report · Oct 8, 2021 · N128EE · Destroyed
  > The pilot’s failure to ensure that his seat was properly secured before initiating the takeoff, which resulted in a loss of control during the initial climb. Contributing to the accident was the lack of an installed secondary seat stop, and the airplane’s aft…
- [NTSB ERA21FA140](https://openairdocs.org/ntsb/ERA21FA140.md): Cessna R182 · Gainesville, GA · Accident · 3 fatal · Class 3 · Field · Final report · Feb 26, 2021 · N3652C · Destroyed
  > The pilot’s loss of control due to spatial disorientation. Contributing to the accident was the pilot’s decision to depart into low instrument meteorological conditions.
- [NTSB ERA21LA030](https://openairdocs.org/ntsb/ERA21LA030.md): Grumman AA5 · Baxley, GA · Accident · Minor injuries · Class 3 · Limited · Final report · Oct 25, 2020 · N920JL · Substantial damage
  > A partial loss of engine power for undetermined reasons.
- [NTSB ERA21LA019](https://openairdocs.org/ntsb/ERA21LA019.md): Piper PA32 · Atlanta, GA · Accident · No injuries · Class 3 · Limited · Final report · Oct 11, 2020 · N3595W · Substantial damage
  > A partial loss of engine power during takeoff due to a right magneto anomaly, which resulted in the pilot’s decision to abort the takeoff and the subsequent runway excursion.
- [NTSB ERA20LA213](https://openairdocs.org/ntsb/ERA20LA213.md): Vans RV8 · Hampton, GA · Accident · Serious injuries · Class 3 · Limited · Final report · Jun 12, 2020 · N553KM · Substantial damage
  > The pilot’s excessive maneuvering at low altitude following a partial loss of engine power which resulted in an aerodynamic stall and collision with terrain.
- [NTSB DCA20IA014](https://openairdocs.org/ntsb/DCA20IA014.md): Embraer ERJ170 · Atlanta, GA · Incident · No injuries · Class 3 · Incident · Final report · Nov 7, 2019 · N117HQ · No damage
  > The captain’s use of his pitch trim switch, which had been placarded inoperative but not deactivated, resulting in the airplane pitching up when the captain was trying to trim down. The trim commands were reversed due to maintenance personnel’s incorrect…
- [NTSB ERA20FA021](https://openairdocs.org/ntsb/ERA20FA021.md): Piper PA28R · Atlanta, GA · Accident · 2 fatal · Class 3 · Field · Final report · Oct 30, 2019 · N56258 · Destroyed
  > The pilot's loss of control due to spatial disorientation while flying in instrument meteorological conditions. Contributing to the accident was the failure of the vacuum pump and its associated instruments.
- [NTSB ERA19FA234](https://openairdocs.org/ntsb/ERA19FA234.md): Cirrus SR22 · Americus, GA · Accident · 2 fatal · Class 2 · Field · Final report · Jul 24, 2019 · N921CD · Destroyed
  > The pilot’s decision to depart in dark instrument meteorological conditions, which resulted in spatial disorientation and subsequent loss of airplane control. Contributing to the accident was the pilot’s and pilot-rated passenger’s self-induced pressure to…
- [NTSB ERA19FA071](https://openairdocs.org/ntsb/ERA19FA071.md): Cessna 560 · Atlanta, GA · Accident · 4 fatal · Field investigation · Final report · Dec 20, 2018 · N188CW · Destroyed
  > The pilot's loss of airplane control due to spatial disorientation during initial climb in instrument meteorological conditions.
- [NTSB ERA19LA052](https://openairdocs.org/ntsb/ERA19LA052.md): Piper PA28 · Barnesville, GA · Accident · Minor injuries · Limited investigation · Final report · Nov 17, 2018 · N111TA · Substantial damage
  > The student pilot’s failure to maintain airplane control during takeoff and the flight instructor’s delayed remedial action, which resulted in an off-runway landing and subsequent collision with trees.
- [NTSB ERA19LA037](https://openairdocs.org/ntsb/ERA19LA037.md): Cessna 150 · Woodstock, GA · Accident · 1 fatal · Limited investigation · Final report · Nov 4, 2018 · N3515J · Substantial damage
  > The pilot's failure to maintain airspeed during the initial climb in gusting wind conditions, which resulted in an aerodynamic stall and loss of control. Contributing to the accident was the pilot's lack of recent flight experience.
- [NTSB ENG18IA036](https://openairdocs.org/ntsb/ENG18IA036.md): Boeing 757 · Atlanta, GA · Incident · Class 3 · Incident · Final report · Sep 6, 2018 · N668DN · Minor damage
  > A right engine turbine uncontainment resulting from failure of the high pressure turbine (HPT) lenticular seal due to a fatigue crack originating from an overheated region at a knife edge tip. Contributing to the failure was Pratt & Whitney’s decision to…
- [NTSB ERA18FA231](https://openairdocs.org/ntsb/ERA18FA231.md): Cessna 182 · Swainsboro, GA · Accident · 4 fatal · Field investigation · Final report · Aug 25, 2018 · N4785D · Destroyed
  > The total loss of engine power for reasons that could not be determined based on available information.
- [NTSB ERA18FA149](https://openairdocs.org/ntsb/ERA18FA149.md): Taylorcraft BC12 · Commerce, GA · Accident · 1 fatal · Field investigation · Final report · May 21, 2018 · N94909 · Substantial damage
  > The pilot's failure to effectively mitigate an accumulation of carburetor ice, which resulted in an undetected partial loss of engine power and an aerodynamic stall during takeoff.
- [NTSB DCA18LA163](https://openairdocs.org/ntsb/DCA18LA163.md): Airbus A330 323 · Atlanta, GA · Accident · No injuries · Class 3 · Limited · Final report · Apr 18, 2018 · N806NW · Substantial damage
  > The flight crew’s delayed landing after an in-flight engine fire, which reignited after both fire bottles were discharged and resulted in substantial damage to an engine pylon. Contributing to the delayed landing was likely the flight crew’s perception that…
- [NTSB ERA17LA336](https://openairdocs.org/ntsb/ERA17LA336.md): Cessna 152 · Winder, GA · Accident · No injuries · Limited investigation · Final report · Sep 27, 2017 · N53393 · Substantial damage
  > The pilot's inadequate preflight inspection, which resulted in undetected water in the fuel system and a total loss of engine power during the initial climb.
- [NTSB ERA17FA330](https://openairdocs.org/ntsb/ERA17FA330.md): Cessna 150G · Rhine, GA · Accident · 1 fatal · Field investigation · Final report · Sep 20, 2017 · N3875J · Substantial damage
  > The student pilot's decision to take off from a partially-lit grass runway in dark night, marginal visual flight rules conditions, which resulted in spatial disorientation, an exceedance of the airplane's critical angle of attack, and an aerodynamic stall.
- [NTSB ERA17LA277](https://openairdocs.org/ntsb/ERA17LA277.md): Piper PA28 · Canton, GA · Accident · Minor injuries · Limited investigation · Final report · Aug 15, 2017 · N2804T · Substantial damage
  > Maintenance personnel's failure to ensure the proper throttle linkage travel clearance after the installation of an exhaust system.
- [NTSB ERA17LA078](https://openairdocs.org/ntsb/ERA17LA078.md): Aircraft Mfg & Development CH 2000 · Atlanta, GA · Accident · Serious injuries · Limited investigation · Final report · Jan 5, 2017 · N683AM · Substantial damage
  > The pilot's exceedance of the airplane's critical angle of attack while attempting a short-field takeoff, which resulted in an aerodynamic stall.
- [NTSB ERA17LA057](https://openairdocs.org/ntsb/ERA17LA057.md): Piper PA28 · Columbus, GA · Accident · No injuries · Limited investigation · Final report · Nov 23, 2016 · N41565 · Substantial damage
  > A total loss of engine power during initial climb for reasons that could not be determined because postaccident examination of the airframe and engine revealed no evidence of any anomalies that would have precluded normal operation.
- [NTSB ERA17FA050](https://openairdocs.org/ntsb/ERA17FA050.md): Curtiss JN4 · Williamson, GA · Accident · 2 fatal · Field investigation · Final report · Nov 17, 2016 · N1662 · Destroyed
  > The in-flight failure of the propeller due to excessive engine vibration loads and the use of an incorrectly-sized propeller, which resulted in a fatigue crack of the leading edge strip. Contributing to the accident was the inadequate repair of the propeller…
- [NTSB ERA17LA015](https://openairdocs.org/ntsb/ERA17LA015.md): Cessna 150 · Stockbridge, GA · Accident · Serious injuries · Limited investigation · Final report · Oct 16, 2016 · N7948F · Substantial damage
  > A partial loss of engine power due to a stuck exhaust valve and the pilot's exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.
- [NTSB ERA16LA235](https://openairdocs.org/ntsb/ERA16LA235.md): Cessna 150 · Peachtree City, GA · Accident · No injuries · Limited investigation · Final report · Jun 29, 2016 · N1567Q · Substantial damage
  > The fatigue failure of the No. 3 cylinder exhaust valve, which resulted in a total loss of engine power at low altitude after takeoff.
- [NTSB ERA16FA097](https://openairdocs.org/ntsb/ERA16FA097.md): Brook Aaron D Lancair IV P · Albany, GA · Accident · 3 fatal · Field investigation · Final report · Jan 30, 2016 · N401PT · Destroyed
  > The pilots' failure to maintain control during a takeoff attempt in a high-performance airplane. Contributing to the accident were the pilots' decision to operate the airplane above its maximum gross weight and with an aft center of gravity and their lack of…

Next page: https://openairdocs.org/ntsb-phases/350/cases.md?state=GA&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" = 'GA' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT case_mkey FROM case_phases WHERE main = 350)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

---
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.