# NTSB investigations, GA: Maneuvering

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 12 · 557 cases

## Latest cases

- [NTSB CEN26FA207](https://openairdocs.org/ntsb/CEN26FA207.md): Robinson Helicopter R66 · Dawsonville, GA · Accident · 2 fatal · Class 3 · Field · Preliminary report · May 30, 2026 · N4488H · Substantial damage
  > On May 29, 2026, about 2150 eastern daylight time, a Robinson R66 helicopter, N4488H, was substantially damaged when it was involved in an accident near Dawsonville, Georgia. The commercial pilot and one passenger were fatally injured. The other passenger had…
- [NTSB ERA26LA111](https://openairdocs.org/ntsb/ERA26LA111.md): Cirrus Design SR22T · Thomson, GA · Accident · No injuries · Class 4 · Limited · Final report · Feb 6, 2026 · N322MC · Substantial damage
  > An in-flight collision with a bird while maneuvering.
- [NTSB ERA26LA036](https://openairdocs.org/ntsb/ERA26LA036.md): Czech Sport Aircraft A S Sportcruiser · Cuthbert, GA · Accident · Minor injuries · Class 4 · Limited · Final report · Nov 7, 2025 · N549PS · Substantial damage
  > The pilot’s failure to maintain clearance from trees and terrain while maneuvering for a precautionary landing, at low altitude and at night.
- [NTSB ERA25LA338](https://openairdocs.org/ntsb/ERA25LA338.md): Bell 206 · Monroe, GA · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Sep 10, 2025 · N992MR · Destroyed
  > On September 10, 2025, about 1100 eastern daylight time, a Bell 206, N992MR, was destroyed when it was involved in an accident near Monroe, Geogia. The flight instructor and student pilot were seriously injured. The helicopter was operated as a Title 14 Code…
- [NTSB ERA25LA040](https://openairdocs.org/ntsb/ERA25LA040.md): Hughes 369D · Waycross, GA · Accident · Minor injuries · Class 4 · Limited · Final report · Nov 5, 2024 · N11AS · Substantial damage
  > An encounter with a foreign object, which resulted in a loss of control and collision with terrain.
- [NTSB ERA24LA297](https://openairdocs.org/ntsb/ERA24LA297.md): Buckeye Dream Machine · Bainbridge, GA · Accident · 1 fatal · Class 4 · Limited · Final report · Jul 4, 2024 · UNREG · Destroyed
  > The non-certificated pilot’s failure to maintain adequate clearance from powerlines while maneuvering at low altitude. Contributing to the accident was the pilot’s impairment due to alcohol and methamphetamine use.
- [NTSB ERA24LA267](https://openairdocs.org/ntsb/ERA24LA267.md): Garlick Helicopters OH-58A+ · Cisco, GA · Accident · Minor injuries · Class 3 · Limited · Final report · Jun 18, 2024 · N72BM · Substantial damage
  > A reported total loss of engine power for reasons that could not be determined.
- [NTSB ERA24LA099](https://openairdocs.org/ntsb/ERA24LA099.md): Swissdrones Operating SDO 50 V2 · Antioch, GA · Accident · No injuries · Class 3 · Limited · Final report · Jan 18, 2024 · N780PA · Substantial damage
  > A partial loss of engine power due to a reduction of fuel flow for undetermined reasons. Contributing to the accident was the UAS manufacturer’s lack of instructions for a partial loss of engine power landing.
- [NTSB ERA24LA057](https://openairdocs.org/ntsb/ERA24LA057.md): Textron 172S · Social Circle, GA · Accident · No injuries · Class 4 · Limited · Final report · Dec 5, 2023 · N53AA · Substantial damage
  > An encounter with a downdraft while maneuvering at low altitude, which resulted in a collision with a fence.
- [NTSB ERA23LA369](https://openairdocs.org/ntsb/ERA23LA369.md): Eurocopter Deutschland EC135T2 · Fargo, GA · Accident · No injuries · Class 3 · Limited · Final report · Sep 13, 2023 · N273AM · Substantial damage
  > The separation of the outer span of a tail rotor blade during flight as a result of localized intergranular corrosion due to a diminished protective coating at a critical location on the tail rotor blade surface that, combined with cyclic loading, resulted in…
- [NTSB ERA23FA163](https://openairdocs.org/ntsb/ERA23FA163.md): Larry F Preiss AR-1 · Gainesville, GA · Accident · 1 fatal · Class 3 · Field · Final report · Mar 25, 2023 · N47AR · Substantial damage
  > The pilot's inadequate preflight inspection and his failure to detect water-contaminated fuel that resulted in a loss of engine power and subsequent impact with a wire and terrain during an attempted forced landing.
- [NTSB ERA23LA117](https://openairdocs.org/ntsb/ERA23LA117.md): Piper PA-28-140 · Buford, GA · Accident · No injuries · Class 3 · Limited · Final report · Jan 24, 2023 · N7470R · Substantial damage
  > Water contamination in the fuel system that was not observed during the preflight inspection, resulting in a total loss of engine power and forced landing.
- [NTSB ERA22FA199](https://openairdocs.org/ntsb/ERA22FA199.md): Cessna 340 · Covington, GA · Accident · 2 fatal · Class 3 · Field · Final report · Apr 21, 2022 · N84GR · Destroyed
  > The private pilot’s loss of control in flight, which resulted in a collision with terrain. Contributing to the accident was the student pilot’s decision to obtain flight instruction from the private pilot and the private pilot's insufficient qualifications to…
- [NTSB ERA22LA178](https://openairdocs.org/ntsb/ERA22LA178.md): Extra 300 · Rome, GA · Accident · No injuries · Class 4 · Limited · Final report · Mar 29, 2022 · N808YF · Substantial damage
  > An inflight collision with a bird while conducting low level aerobatics.
- [NTSB ERA22LA144](https://openairdocs.org/ntsb/ERA22LA144.md): Piper PA-28-150 · Savannah, GA · Accident · No injuries · Class 3 · Limited · Final report · Feb 26, 2022 · N5208W · Substantial damage
  > The student pilot’s improper fuel management, which resulted in a total loss of engine power due to fuel starvation.
- [NTSB ERA22FA050](https://openairdocs.org/ntsb/ERA22FA050.md): Mooney M20F · Villa Rica, GA · Accident · 1 fatal · Class 3 · Field · Final report · Nov 8, 2021 · N3284F · Substantial damage
  > The pilot’s failure to maintain proper airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall and spin.
- [NTSB ERA22LA031](https://openairdocs.org/ntsb/ERA22LA031.md): Vans RV-12 · Folkston, GA · Accident · 1 fatal · Class 3 · Limited · Final report · Oct 26, 2021 · N525AT · Destroyed
  > The pilot’s low altitude maneuvering, which resulted in a collision with a utility pole.
- [NTSB ERA21FA355](https://openairdocs.org/ntsb/ERA21FA355.md): American Champion 8KCAB · Rhine, GA · Accident · 1 fatal · Class 3 · Field · Final report · Sep 12, 2021 · N390PE · Substantial damage
  > A collision with trees during a low-altitude aerobatic maneuver for unknown reasons.
- [NTSB ERA21FA184](https://openairdocs.org/ntsb/ERA21FA184.md): Cessna A188 · Pineview, GA · Accident · 1 fatal · Class 3 · Field · Final report · Apr 13, 2021 · N4912Q · Destroyed
  > The pilot’s inadequate visual lookout, which resulted in collision with powerlines during an aerial application flight.
- [NTSB ERA21FA165](https://openairdocs.org/ntsb/ERA21FA165.md): Aviat A-1 · Cave Spring, GA · Accident · 1 fatal · Class 3 · Field · Final report · Mar 29, 2021 · N800MH · Substantial damage
  > The pilot's inadequate visual lookout and failure to maintain clearance from a power line.
- [NTSB ERA21LA088](https://openairdocs.org/ntsb/ERA21LA088.md): Piper PA-22-150 · Cleveland, GA · Accident · Minor injuries · Class 3 · Limited · Final report · Dec 27, 2020 · N5939D · Substantial damage
  > A total loss of engine power due to carburetor icing.
- [NTSB ERA21LA046](https://openairdocs.org/ntsb/ERA21LA046.md): Robinson R44 · Austell, GA · Accident · No injuries · Class 4 · Limited · Final report · Nov 18, 2020 · N442JP · Substantial damage
  > The flight instructor’s failure to maintain adequate clearance above the gravel surface in a hover, which resulted in a dynamic rollover.
- [NTSB ENG20LA046](https://openairdocs.org/ntsb/ENG20LA046.md): Thrush S2R-H80 · Donalsonville, GA · Incident · No injuries · Class 3 · Limited · Final report · Sep 28, 2020 · N6216K · Minor damage
  > A total loss of engine power due to a loose torque meter attachment nut in the reduction gearbox that jammed the planetary gearset causing the power turbine shaft to separate from the power turbine disk, resulting in the power turbine overspeeding and…
- [NTSB ERA20LA329](https://openairdocs.org/ntsb/ERA20LA329.md): Cessna 182 · Lincolnton, GA · Accident · 1 fatal · Class 3 · Limited · Final report · Sep 22, 2020 · N2601Q · Substantial damage
  > The pilot's loss of airplane control while maneuvering at a low altitude.
- [NTSB ERA20LA306](https://openairdocs.org/ntsb/ERA20LA306.md): Thrush S2R-H80 · Hawkinsville, GA · Accident · Serious injuries · Class 4 · Limited · Final report · Sep 3, 2020 · N30529 · Substantial damage
  > The pilot's failure to maintain clearance from an antenna tower while maneuvering during an agricultural application flight while flying directly toward the sun.
- [NTSB ERA20CA131](https://openairdocs.org/ntsb/ERA20CA131.md): American Legand AL18 · Social Circle, GA · Accident · No injuries · Data collection · Final report · Mar 10, 2020 · N23TN · Substantial damage
  > The pilot's failure to maintain airplane control while maneuvering at low altitude, which resulted in the collision with terrain.
- [NTSB ERA20CA128](https://openairdocs.org/ntsb/ERA20CA128.md): Stolp Starduster Acroduster II SA750 · Senoia, GA · Accident · Minor injuries · Data collection · Final report · Mar 7, 2020 · N529FM · Substantial damage
  > The pilot's failure to see and avoid trees while maneuvering at low altitude, which resulted in a loss of airplane control.
- [NTSB ERA20FA086](https://openairdocs.org/ntsb/ERA20FA086.md): Mustang II · Senoia, GA · Accident · 2 fatal · Class 3 · Field · Final report · Jan 25, 2020 · UNREG · Destroyed
  > The pilot’s exceedance of the airplane’s structural limitations while conducting previous aerobatic maneuvers, which resulted in an in-flight breakup of the airplane.
- [NTSB ERA20LA071](https://openairdocs.org/ntsb/ERA20LA071.md): Hughes OH 6A · Preston, GA · Accident · Minor injuries · Class 3 · Limited · Final report · Jan 8, 2020 · N6186U · Substantial damage
  > A partial loss of engine power for reasons that could not be determined based on the available information.
- [NTSB ERA20FA029](https://openairdocs.org/ntsb/ERA20FA029.md): Pavel Tango2 · Cedartown, GA · Accident · 1 fatal · Class 3 · Field · Final report · Nov 4, 2019 · N875FV · Substantial damage
  > The pilot's loss of control of the gyroplane for reasons that could not be determined based on available evidence.
- [NTSB GAA20CA020](https://openairdocs.org/ntsb/GAA20CA020.md): Ayres S2R · Willacoochee, GA · Accident · Minor injuries · Data collection · Final report · Oct 11, 2019 · N3090C · Substantial damage
  > The pilot's failure to maintain clearance from power lines while maneuvering at low altitude.
- [NTSB ERA19LA286](https://openairdocs.org/ntsb/ERA19LA286.md): Solo Wings Windlass · Dalton, GA · Accident · 1 fatal · Limited investigation · Final report · Sep 28, 2019 · UNREG · Substantial damage
  > The pilot's exceedance of the aircraft's critical angle of attack during a turn shortly after takeoff, which resulted in an aerodynamic stall and subsequent impact with terrain. Contributing was the pilot's lack of experience in the accident aircraft.
- [NTSB ERA19LA273](https://openairdocs.org/ntsb/ERA19LA273.md): Robinson R44 · Sardis, GA · Accident · Serious injuries · Class 3 · Limited · Final report · Sep 17, 2019 · N827JE · Substantial damage
  > Fatigue failure of the fasteners on the engine crankshaft, which resulted in a partial loss of engine power and a subsequent forced landing.
- [NTSB ERA19LA221](https://openairdocs.org/ntsb/ERA19LA221.md): Team Mini-Max Hi-Max · Monroe, GA · Accident · 1 fatal · Class 3 · Limited · Final report · Jul 9, 2019 · UNREG · Destroyed
  > A collision with terrain for undetermined reasons.
- [NTSB GAA19CA382](https://openairdocs.org/ntsb/GAA19CA382.md): Piper PA24 · Brunswick, GA · Accident · No injuries · Data collection · Final report · Jun 29, 2019 · N8294P · Substantial damage
  > The pilot's failure to properly lean the fuel mixture in flight, which resulted in fuel exhaustion, a subsequent total loss of engine power, and a forced landing with the landing gear retracted.
- [NTSB ERA19FA118](https://openairdocs.org/ntsb/ERA19FA118.md): Hughes 369 · Talking Rock, GA · Accident · 1 fatal · Class 3 · Field · Final report · Mar 5, 2019 · N89ZC · Substantial damage
  > A fatigue failure of the overrunning clutch subassembly due to abnormal bending loads due to cracks on the center engine mount, which resulted in an inflight loss of power. Contributing to the accident was the helicopter's low altitude and airspeed when the…
- [NTSB ERA19FA068](https://openairdocs.org/ntsb/ERA19FA068.md): Saberwing Saberwing · Adel, GA · Accident · 1 fatal · Class 2 · Field · Final report · Dec 18, 2018 · N203SW · Substantial damage
  > The in-flight failure of the fuselage, as a result of the pilot conducting maneuvers that exceeded the structural capabilities of the airplane.
- [NTSB GAA19CA078](https://openairdocs.org/ntsb/GAA19CA078.md): Air Tractor AT 502 · Americus, GA · Accident · No injuries · Data collection · Final report · Nov 28, 2018 · N843WA · Substantial damage
  > The pilot's failure to see and avoid a power line during an agricultural application flight.
- [NTSB ERA18LA168](https://openairdocs.org/ntsb/ERA18LA168.md): Stinson L 5 · Thomson, GA · Accident · No injuries · Class 3 · Limited · Final report · Jun 14, 2018 · N45TX · Substantial damage
  > Failure of maintenance personnel to inspect the crankshaft after two previous propeller strikes, which resulted in failure of the crankshaft and a total loss of engine power. Contributing to the crankshaft failure was insufficient torque applied to the thrust…
- [NTSB ERA17FA135](https://openairdocs.org/ntsb/ERA17FA135.md): Cessna 500 · Marietta, GA · Accident · 1 fatal · Field investigation · Final report · Mar 24, 2017 · N8DX · Destroyed
  > The pilot's failure to maintain adequate airspeed while manually flying the airplane, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. Contributing to the accident was the pilot's inability control…
- [NTSB ERA17FA107](https://openairdocs.org/ntsb/ERA17FA107.md): Beech A45 · Climax, GA · Accident · 1 fatal · Field investigation · Final report · Feb 16, 2017 · N3434G · Substantial damage
  > The failure of maintenance personnel to ensure that the throttle and fuel metering unit AN "B" nut was secured, which resulted in a total loss of engine power in flight and a subsequent collision with trees while attempting to land after sunset.
- [NTSB ERA17FA066](https://openairdocs.org/ntsb/ERA17FA066.md): Fairchild SA227 · Camilla, GA · Accident · 1 fatal · Field investigation · Final report · Dec 6, 2016 · N765FA · Destroyed
  > The pilot's decision to initiate and continue the flight into known adverse weather conditions, which resulted spatial disorientation, a loss of airplane control, and a subsequent in-flight breakup.
- [NTSB ERA17FA027](https://openairdocs.org/ntsb/ERA17FA027.md): Nanchang CJ6 · Blackshear, GA · Accident · 1 fatal · Field investigation · Final report · Oct 21, 2016 · N10EB · 2 aircraft · Substantial damage
  > The Bama 3 pilot's failure to properly conduct an overshoot maneuver and his premature climb before he was clear of the lead airplane, Bama 1, which lead to a midair collision
- [NTSB ERA16FA316](https://openairdocs.org/ntsb/ERA16FA316.md): Cessna A188 · Alapaha, GA · Accident · 1 fatal · Field investigation · Final report · Sep 16, 2016 · N3547Q · Destroyed
  > The pilot's failure to maintain adequate airspeed while maneuvering at low altitude during aerial application operations, which resulted in the airplane exceeding its critical angle-of-attack and entering an aerodynamic stall and spin.
- [NTSB ERA16CA314](https://openairdocs.org/ntsb/ERA16CA314.md): Quicksilver Manufacturing Sport 2S · Cleveland, GA · Accident · Minor injuries · Data collection · Final report · Sep 9, 2016 · N396DF · Substantial damage
  > The pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.
- [NTSB ERA16FA182](https://openairdocs.org/ntsb/ERA16FA182.md): Greg Connell Pitts S-2SW · Atlanta, GA · Accident · 1 fatal · Field investigation · Final report · May 14, 2016 · N24CD · Destroyed
  > The pilot's failure to maintain proper positioning during performance of an aerobatic maneuver and his subsequent failure to discontinue maneuvering when unable to reestablish proper positioning during a steep descent toward the ground.
- [NTSB ERA15FA359](https://openairdocs.org/ntsb/ERA15FA359.md): Boatright Waylon RV10 · Alma, GA · Accident · 5 fatal · Field investigation · Final report · Sep 16, 2015 · N122WK · Destroyed
  > The noncertificated pilot's decision to perform aerobatic maneuvers in his overweight, improperly-loaded airplane in dark night conditions at low altitude, which resulted in a loss of airplane control and collision with terrain. Contributing to the accident…
- [NTSB ERA15LA156](https://openairdocs.org/ntsb/ERA15LA156.md): Kolb Twinstar · Reynolds, GA · Accident · 1 fatal · Limited investigation · Final report · Mar 15, 2015 · N193Y · Substantial damage
  > The student pilot’s failure to maintain adequate airspeed while maneuvering, which resulted in the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall. Contributing to the accident was the student pilot's decision to operate…
- [NTSB ERA15LA052](https://openairdocs.org/ntsb/ERA15LA052.md): Dehavilland Tiger Moth DH 82A · Williamson, GA · Accident · Serious injuries · Limited investigation · Final report · Nov 15, 2014 · N28681 · Destroyed
  > The pilot’s failure to maintain airspeed while maneuvering, which led to the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall at an insufficient altitude to fully recover before collision with obstacles and terrain.
- [NTSB ERA14LA360](https://openairdocs.org/ntsb/ERA14LA360.md): Ryan Aeronautical ST3KR · Newnan, GA · Accident · Serious injuries · Limited investigation · Final report · Jul 26, 2014 · N59418 · Substantial damage
  > A total loss of engine power for reasons that could not be determined based on the available information.

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

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