# NTSB investigations, GA: 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 18 · 865 cases

## Latest cases

- [NTSB WPR26LA362](https://openairdocs.org/ntsb/WPR26LA362.md): Smith Pitts Special S-1 · Madison, GA · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Sep 29, 2026 · N292Y · Substantial damage
  > On September 29, 2026, at about 1347 eastern daylight time, a Smith Pitts Special S-1, N292Y, was substantially damaged when it was involved in an accident near Madison, Georgia. The pilot was seriously injured. The airplane was operated as a Title 14 Code of…
- [NTSB ERA26LA337](https://openairdocs.org/ntsb/ERA26LA337.md): Air Tractor AT-602 · Morven, GA · Accident · No injuries · Class 4 · Limited · Investigation open · Sep 13, 2026 · N686LA · Substantial damage
- [NTSB ERA26LA296](https://openairdocs.org/ntsb/ERA26LA296.md): Piper PA32 · Dawsonville, GA · Accident · Serious injuries · Class 3 · Limited · Investigation open · Aug 9, 2026 · N3011X
- [NTSB ERA26LA109](https://openairdocs.org/ntsb/ERA26LA109.md): Hawker Beechcraft G36 · Gainesville, GA · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Feb 9, 2026 · N229TT · Substantial damage
  > On February 09, 2026, about 1732 eastern standard time, a Beechcraft G36, N229TT, was substantially damaged when it was involved in an accident near Gainesville, Georgia. The pilot and flight instructor were uninjured, and two occupants of separate…
- [NTSB ERA26LA040](https://openairdocs.org/ntsb/ERA26LA040.md): Piper PA-32R-301T · Woodfin Mill, GA · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Nov 16, 2025 · N327HP · Substantial damage
  > On November 16, 2025, about 0845 eastern standard time, a Piper Pa-32R-301T, N327HP, was substantially damaged when it was involved in an accident near Woodfin Mill, Georgia. The commercial pilot sustained minor injuries. The airplane was operated as a Title…
- [NTSB ERA26LA055](https://openairdocs.org/ntsb/ERA26LA055.md): Perry William Lancair IV P · Savannah, GA · Accident · No injuries · Class 3 · Limited · Preliminary report · Nov 14, 2025 · N163BR · Substantial damage
  > On November 13, 2025, at 1949 eastern standard time, an experimental amateur-built Lancair IV-P, N163BR, was substantially damaged when it was involved in an accident near Savannah, Georgia. The pilot and passenger were uninjured. The airplane was operated as…
- [NTSB DCA25LA269](https://openairdocs.org/ntsb/DCA25LA269.md): Embraer-Empresa Brasileira De ERJ 170-200 LR · Jacksonville, GA · Accident · Serious injuries · Class 4 · Limited · Final report · Jul 21, 2025 · N229JQ · No damage
  > The airplane’s encounter with unanticipated moderate turbulence.
- [NTSB ERA25LA064](https://openairdocs.org/ntsb/ERA25LA064.md): AMS Flight D O O Carat A · Centralhatchee, GA · Accident · Serious injuries · Class 3 · Limited · Final report · Nov 20, 2024 · N17GF · Substantial damage
  > Maintenance personnel’s failure to comply with the engine manufacturer’s guidance, which resulted in improper valvetrain clearances, unseating of the intake valve keepers, and a total loss of engine power.
- [NTSB ERA25LA010](https://openairdocs.org/ntsb/ERA25LA010.md): Ditsler Paul A Dakota Hawk · Nicklesville, GA · Accident · No injuries · Class 4 · Limited · Final report · Oct 11, 2024 · N357PC · Substantial damage
  > The pilot’s inadequate preflight inspection, fuel planning, and improper fuel management during flight, which resulted in a total loss of engine power due to fuel exhaustion and a subsequent off-airport hard landing.
- [NTSB DCA24LA255](https://openairdocs.org/ntsb/DCA24LA255.md): Airbus A321-231 · Waycross, GA · Accident · Serious injuries · Class 4 · Limited · Final report · Aug 8, 2024 · N542UW · No damage
  > The aircraft’s encounter with convectively induced turbulence.
- [NTSB ERA24LA303](https://openairdocs.org/ntsb/ERA24LA303.md): Jones LONG-EZ · Thomasville, GA · Accident · No injuries · Class 3 · Limited · Final report · Jul 10, 2024 · N4JZ · Substantial damage
  > The pilot reported that he was maneuvering around weather at 11,500 ft mean sea level (msl) when he made a rapid descent to 3,500 ft msl to remain clear of clouds. He reported that he did not exceed the airplane’s maneuvering speed during the descent, and…
- [NTSB ERA24LA258](https://openairdocs.org/ntsb/ERA24LA258.md): Clapp Saberwing · Valdosta, GA · Accident · Serious injuries · Class 3 · Limited · Final report · Jun 11, 2024 · N120SW · Substantial damage
  > The total loss of engine power due to the shearing of the woodruff key that indexed the crankshaft gear and hub assembly to the crankshaft, which resulted in the gear and hub rotating from their indexed position and caused the crankshaft-to-camshaft timing to…
- [NTSB ERA24LA251](https://openairdocs.org/ntsb/ERA24LA251.md): William Loren Noggle JA30 Superstol · Tennille, GA · Accident · Minor injuries · Class 4 · Limited · Final report · Jun 8, 2024 · N719LN · Substantial damage
  > The loss of elevator control during flight due to the elevator control rod and its hardware disconnecting from its installation area, which resulted in an uncontrolled descent into trees and terrain. Contributing to the accident was the pilot’s inadequate…
- [NTSB DCA24LA174](https://openairdocs.org/ntsb/DCA24LA174.md): Boeing 757 · Hogansville, GA · Accident · Serious injuries · Class 4 · Limited · Final report · Apr 26, 2024 · N6703D · No damage
  > An encounter with convectively induced turbulence during descent.
- [NTSB ERA24LA158](https://openairdocs.org/ntsb/ERA24LA158.md): Jmmt Vans RV9A · Jasper, GA · Accident · Serious injuries · Class 3 · Limited · Final report · Mar 29, 2024 · N387E · Substantial damage
  > The total loss of engine power due to fuel starvation for reasons that could not be determined due to impact-related damage.
- [NTSB DCA24LA135](https://openairdocs.org/ntsb/DCA24LA135.md): Boeing 757-232 · Lakeland, GA · Accident · Serious injuries · Class 4 · Limited · Final report · Mar 28, 2024 · N6705Y · No damage
  > An inadvertent encounter with convective turbulence that resulted in a serious injury to a flight attendant.
- [NTSB ERA24LA143](https://openairdocs.org/ntsb/ERA24LA143.md): Beech A36 · Blackshear, GA · Accident · No injuries · Class 3 · Limited · Final report · Mar 17, 2024 · N729CW · Substantial damage
  > A catastrophic engine failure due to oil starvation, which resulted in a total loss of engine power.
- [NTSB ERA24LA141](https://openairdocs.org/ntsb/ERA24LA141.md): Cirrus Design SR22 · Winokur, GA · Accident · No injuries · Class 3 · Limited · Final report · Mar 16, 2024 · N469GB · Substantial damage
  > A total loss of engine power due to the unseating and subsequent failure of the No. 4 piston connection rod bushing.
- [NTSB ERA24FA072](https://openairdocs.org/ntsb/ERA24FA072.md): Hawker Beechcraft G36 · Buford, GA · Accident · 1 fatal · Class 3 · Field · Final report · Dec 21, 2023 · N23VS · Destroyed
  > A loss of engine power for reasons that could not be determined due to significant thermal damage from postimpact fire.
- [NTSB ERA24LA006](https://openairdocs.org/ntsb/ERA24LA006.md): Piper PA28 · Jonesboro, GA · Accident · Serious injuries · Class 3 · Limited · Final report · Oct 11, 2023 · N55162 · Substantial damage
  > Both pilots’ inadequate preflight inspection and inadequate fuel monitoring during the flight, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB ERA24LA023](https://openairdocs.org/ntsb/ERA24LA023.md): Champion 7FC · Hawkinsville, GA · Accident · No injuries · Class 3 · Limited · Final report · Oct 3, 2023 · N4878E · Substantial damage
  > The failure of the carburetor fuel line, which resulted in fuel starvation.
- [NTSB ERA23FA330](https://openairdocs.org/ntsb/ERA23FA330.md): Cessna P210 · Junction City, GA · Accident · 1 fatal · Class 3 · Field · Final report · Aug 10, 2023 · N210JT · Destroyed
  > The pilot’s continued flight into a known area of adverse weather, which resulted in the penetration of a severe thunderstorm, the pilot’s loss of airplane control, and the airplane’s subsequent in-flight breakup.
- [NTSB ERA23LA305](https://openairdocs.org/ntsb/ERA23LA305.md): Piper PA-28 · Gray, GA · Accident · No injuries · Class 4 · Limited · Final report · Jul 11, 2023 · N271MG · Substantial damage
  > An in-flight collision with a bird.
- [NTSB ERA23LA253](https://openairdocs.org/ntsb/ERA23LA253.md): Beech V35A · Statesboro, GA · Accident · Minor injuries · Class 3 · Limited · Final report · Jun 1, 2023 · N8074R · Substantial damage
  > Maintenance personnel’s improper installation of the pitch servo bridle cable clamp, which led to binding in the elevator control system that restricted aft yoke movement during the landing approach.
- [NTSB ERA23FA109](https://openairdocs.org/ntsb/ERA23FA109.md): Piper PA-28-180 · Dawsonville, GA · Accident · 1 fatal · Class 3 · Field · Final report · Jan 13, 2023 · N4254T · Destroyed
  > The pilot’s decision to initiate a visual flight rules flight into night instrument meteorological conditions, resulting in a loss of control in-flight due to spatial disorientation. Contributing to the accident was the pilot’s lack of qualifications and…
- [NTSB ERA23LA097](https://openairdocs.org/ntsb/ERA23LA097.md): Piper PA24 · Athens, GA · Accident · Minor injuries · Class 3 · Limited · Final report · Dec 29, 2022 · N9026P · Substantial damage
  > The pilot’s failure to detect water in the fuel during the preflight inspection, which resulted in a loss of engine power.
- [NTSB ERA23LA083](https://openairdocs.org/ntsb/ERA23LA083.md): Piper PA-44 · Hawkinsville, GA · Accident · Minor injuries · Class 4 · Limited · Final report · Dec 9, 2022 · N160PT · Substantial damage
  > The pilot’s inadequate in-flight decision-making, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB ERA23LA086](https://openairdocs.org/ntsb/ERA23LA086.md): Beech A36 · Covington, GA · Accident · No injuries · Class 3 · Limited · Final report · Dec 8, 2022 · N900AW · Substantial damage
  > A total loss of engine power due to oil starvation as a result of engine operation with low oil pressure. Contributing to the accident was the failure of two separate maintenance facilities to comply with guidance from the engine manufacturer to disassemble…
- [NTSB ERA23LA063](https://openairdocs.org/ntsb/ERA23LA063.md): Hagerty Glasair Super IIS-TD · Jasper, GA · Accident · No injuries · Class 3 · Limited · Final report · Nov 4, 2022 · N430JV · Substantial damage
  > The loss of engine power due to the failure of the engine-driven fuel pump and the pilot’s failure to use the electric fuel pump, which resulted in a forced, hard landing.
- [NTSB ERA23LA064](https://openairdocs.org/ntsb/ERA23LA064.md): Beech 95-B55 (T42A) · Athens, GA · Accident · No injuries · Class 3 · Limited · Final report · Nov 3, 2022 · N101DC · Substantial damage
  > The operator’s and the pilot’s continued operation of the airplane with a known electrical problem, resulting in a loss of electrical power and a gear-up landing.
- [NTSB ERA23LA053](https://openairdocs.org/ntsb/ERA23LA053.md): Schmidt Randall M Bushby Mustang II · Statesboro, GA · Accident · Minor injuries · Class 4 · Limited · Final report · Nov 2, 2022 · N30RK · Substantial damage
  > A total loss of engine power due to fuel exhaustion. Contributing to the fuel exhaustion was the likely inaccurate right fuel quantity indicating system.
- [NTSB ERA23LA005](https://openairdocs.org/ntsb/ERA23LA005.md): Piper PA-30 · Milan, GA · Accident · No injuries · Class 4 · Limited · Final report · Oct 4, 2022 · N7494Y · Substantial damage
  > The pilot's inadequate preflight inspection, which resulted in a total loss of engine power during cruise flight due to fuel contamination.
- [NTSB ERA22LA291](https://openairdocs.org/ntsb/ERA22LA291.md): Piper PA-24-250 · Warm Springs, GA · Accident · Serious injuries · Class 3 · Limited · Final report · Jun 26, 2022 · N14FC · Substantial damage
  > The loss of engine power due to fuel starvation as the result of the pilot’s inadequate preflight inspection of the fuel supply before flight and the mismanagement of fuel during flight.
- [NTSB ERA22LA220](https://openairdocs.org/ntsb/ERA22LA220.md): Cirrus Design SR22 · Tybee Island, GA · Accident · 1 fatal · Class 3 · Limited · Final report · May 6, 2022 · N24LA · Substantial damage
  > A loss of airplane control due to pilot incapacitation, which resulted in an overflight of his destination and subsequent descent into water.
- [NTSB ERA22LA146](https://openairdocs.org/ntsb/ERA22LA146.md): Beech A35 · Waco, GA · Accident · No injuries · Class 3 · Limited · Final report · Mar 6, 2022 · N764B · Substantial damage
  > The failure of the fuel pressure indicator line due to corrosion that was not detected during the last annual inspection, which resulted in a total loss of engine power.
- [NTSB ERA22LA045](https://openairdocs.org/ntsb/ERA22LA045.md): Cessna 172 · Decatur, GA · Accident · Minor injuries · Class 3 · Limited · Final report · Nov 4, 2021 · N172XX · Substantial damage
  > Oil exhaustion due to an oil leak that resulted in a total loss of engine power.
- [NTSB ERA21LA386](https://openairdocs.org/ntsb/ERA21LA386.md): Hiller UH-12E · Millen, GA · Accident · Minor injuries · Class 3 · Limited · Final report · Sep 29, 2021 · N430NR · Substantial damage
  > The improper reassembly of the tail rotor gearbox following maintenance, which resulted in fatigue failure of the input pinion gear shaft, and the subsequent loss of tail rotor drive.
- [NTSB ERA21LA392](https://openairdocs.org/ntsb/ERA21LA392.md): Piper PA-16 · Greensboro, GA · Accident · No injuries · Class 4 · Limited · Final report · Sep 25, 2021 · N5656H · Substantial damage
  > The pilot’s inadequate preflight planning and fuel system inspection, which resulted in fuel exhaustion.
- [NTSB ERA21LA376](https://openairdocs.org/ntsb/ERA21LA376.md): Piper PA-44-180 · Unadilla, GA · Accident · No injuries · Class 4 · Limited · Final report · Sep 21, 2021 · N442HG · Substantial damage
  > The airplane's impact by a bird during the enroute portion of the flight.
- [NTSB ERA21FA362](https://openairdocs.org/ntsb/ERA21FA362.md): Robinson Helicopter R66 · Monticello, GA · Accident · 3 fatal · Class 3 · Field · Final report · Sep 16, 2021 · N888DV · Destroyed
  > The pilot’s decision to continue the visual flight rules flight into deteriorating weather conditions during a dark night and over unlit terrain, which resulted in spatial disorientation and a subsequent loss of helicopter control.
- [NTSB ERA21LA222](https://openairdocs.org/ntsb/ERA21LA222.md): Mooney M20K · Dawson, GA · Accident · Serious injuries · Class 3 · Limited · Final report · May 20, 2021 · N9514R · Substantial damage
  > Maintenance personnel’s failure to properly secure the No. 4 connecting rod bolt nut with a cotter pin, resulting in a total loss of engine power.
- [NTSB ERA21LA155](https://openairdocs.org/ntsb/ERA21LA155.md): Socata MS894A · Monroe, GA · Accident · Minor injuries · Class 3 · Limited · Final report · Mar 15, 2021 · N42BF · Substantial damage
  > Maintenance personnel’s failure to properly inspect and maintain the airplane’s engine cowling latches, which resulted in the in-flight separation of the engine cowling and a subsequent forced landing.
- [NTSB DCA21LA094](https://openairdocs.org/ntsb/DCA21LA094.md): Bell APT70 · Fort Benning, GA · Accident · Class 4 · Limited · Final report · Mar 1, 2021 · N314AQ · Substantial damage
  > failure of an electronic speed controller that resulted in a descent and impact with trees.
- [NTSB ERA21LA105](https://openairdocs.org/ntsb/ERA21LA105.md): Cessna 177RG · Richmond Hill, GA · Accident · No injuries · Class 3 · Limited · Final report · Jan 17, 2021 · N919DC · Substantial damage
  > The pilot’s mismanagement of the fuel supply, which resulted in fuel starvation.
- [NTSB ERA21LA085](https://openairdocs.org/ntsb/ERA21LA085.md): Cessna 210L · Midway, GA · Accident · 1 fatal · Class 3 · Limited · Final report · Dec 21, 2020 · N2246S · Substantial damage
  > The pilot's intentional visual flight rules flight into instrument meteorological conditions, which resulted in controlled flight into terrain. Contributing to the accident was the pressure to complete the flight to work in an emergency room.
- [NTSB ERA20LA328](https://openairdocs.org/ntsb/ERA20LA328.md): Rockwell S2R · Hamilton, GA · Accident · No injuries · Class 3 · Limited · Final report · Sep 21, 2020 · N7900V · Substantial damage
  > The pilot’s inadequate preflight planning and improper operation of the engine beyond its indicated maximum cruise power setting, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB ERA20LA206](https://openairdocs.org/ntsb/ERA20LA206.md): Piper PA 31T · Eatonton, GA · Accident · 5 fatal · Class 3 · Limited · Final report · Jun 5, 2020 · N135VE · Destroyed
  > The pilot’s failure to maintain control of the airplane while maneuvering in instrument meteorological conditions, which placed the airplane in an unusual attitude from which the pilot could not recover. Contributing to the accident was the convective and…
- [NTSB ERA20LA123](https://openairdocs.org/ntsb/ERA20LA123.md): Mooney M20C · McIntyre, GA · Accident · No injuries · Class 3 · Limited · Final report · Mar 7, 2020 · N9281M · Substantial damage
  > A total loss of engine power for reasons that could not be determined.
- [NTSB ERA20FA118](https://openairdocs.org/ntsb/ERA20FA118.md): Piper PA46 · Bishop, GA · Accident · 3 fatal · Class 3 · Field · Final report · Mar 3, 2020 · N43368 · Destroyed
  > The pilot’s encounter with a rain shower updraft and severe turbulence, which resulted in a loss of airplane control and an inflight breakup. Contributing to the accident was the pilot’s reliance on outdated weather information on his in-cockpit weather…
- [NTSB ERA20FA096](https://openairdocs.org/ntsb/ERA20FA096.md): Cessna 501 · Fairmount, GA · Accident · 4 fatal · Class 3 · Field · Final report · Feb 8, 2020 · N501RG · Substantial damage
  > The pilots’ loss of control in flight in freezing instrument meteorological conditions due to spatial disorientation and the cumulative effects of task saturation.

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

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