# NTSB investigations, GA: Unknown

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.

## Latest cases

- [NTSB ERA26FA350](https://openairdocs.org/ntsb/ERA26FA350.md): Aero Commander 112 · Chatsworth, GA · Accident · 1 fatal · Class 3 · Field · Preliminary report · Sep 26, 2026 · N1102J · Substantial damage
  > On September 26, 2026, about 1120 eastern daylight time, an Aero Commander 112, N1102J, was substantially damaged when it was involved in an accident near Chatsworth, Georgia. The pilot was fatally injured. The airplane was operated as a Title 14 Code of…
- [NTSB CEN26FA147](https://openairdocs.org/ntsb/CEN26FA147.md): Experimental Homebuilt Airshark · Statesboro, GA · Accident · 1 fatal · Class 3 · Field · Preliminary report · Mar 25, 2026 · N220AS · Substantial damage
  > On March 25, 2026, about 1453 eastern daylight time, an experimental homebuilt Airshark airplane, N220AS, was substantially damaged when it was involved in an accident near Statesboro, Georgia. The pilot was fatally injured. The airplane was operated as a…
- [NTSB ERA14FA455](https://openairdocs.org/ntsb/ERA14FA455.md): Piper J3C-65 · Fort Gaines, GA · Accident · 2 fatal · Field investigation · Final report · Sep 16, 2014 · N95480 · Substantial damage
  > The pilot’s failure to maintain airplane control during flight, which resulted in a collision with a river.
- [NTSB ERA13FA349](https://openairdocs.org/ntsb/ERA13FA349.md): Beech A36 · Alma, GA · Accident · 2 fatal · Field investigation · Final report · Aug 4, 2013 · N1831W · Destroyed
  > Descent from cruise flight until impact with trees and the ground for reasons that could not be determined because postaccident examination of the wreckage did not reveal any anomalies that would have precluded normal operation and the pilot's autopsy and…
- [NTSB MIA08LA096](https://openairdocs.org/ntsb/MIA08LA096.md): Garrett Gerald P Cozy Mark IV · Jekyll Island, GA · Accident · 1 fatal · Limited investigation · Final report · May 4, 2008 · N14GG · Substantial damage
  > Controlled flight into water for undetermined reasons.
- [NTSB ATL04LA143](https://openairdocs.org/ntsb/ATL04LA143.md): Cessna 172S · Winder, GA · Accident · No injuries · Limited investigation · Final report · Jul 20, 2004 · N2069S · Substantial damage
  > The improper maintenance (over-pressurization) of the nose gear strut, which resulted in an overload failure of the nose gear upper torque link bolt. The airplane subsequently nosed over during an uncontrollable landing roll.
- [NTSB MIA98LA242](https://openairdocs.org/ntsb/MIA98LA242.md): Cessna 177RG · Covington, GA · Accident · No injuries · Limited investigation · Final report · Sep 5, 1998 · N2679V · Substantial damage
  > slippage of the No. 3 connecting rod bearing resulting in blockage of the oil port, oil starvation, and subsequent connecting rod failure. A factor was the fence.
- [NTSB ATL95FA023](https://openairdocs.org/ntsb/ATL95FA023.md): Beech C23 · Statesboro, GA · Accident · 1 fatal · Field investigation · Final report · Dec 4, 1994 · N9790L · Substantial damage
  > The pilot's impairment of judgment and performance due to alcohol, improper planning/decision, flight into adverse weather conditions, and failure to maintain proper altitude/clearance from wooded terrain. Factors related to the accident were: darkness and…
- [NTSB ATL85LA103](https://openairdocs.org/ntsb/ATL85LA103.md): Piper PA-23-250 · Reidsville, GA · Accident · Minor injuries · Limited investigation · Final report · Feb 28, 1985 · N4565P · Destroyed
  > The acft was found burning in the woods by the foresty service. No persons or baggage were found. The date, time & cause of the accident is unknown. Suspected drug related activity. According to FAA records, the acft was not officially registered. It had been…
- [NTSB ATL84FA168](https://openairdocs.org/ntsb/ATL84FA168.md): Cessna 172RG · Dallas, GA · Accident · 2 fatal · Field investigation · Final report · May 6, 1984 · N6293V · Destroyed
  > Approximately one-half hour after takeoff, the aircraft collided with rising terrain and was destroyed. The flight was unauthorized and no witnesses observed the crash. Weather at the time of the crash is unknown. The private pilot on board probably had not…
- [NTSB ATL81FKJ15](https://openairdocs.org/ntsb/ATL81FKJ15.md): Piper PA-32 · Mobile, GA · Accident · 1 fatal · Closed · Feb 19, 1981 · N3898W · Destroyed
- [NTSB ATL81FKG05](https://openairdocs.org/ntsb/ATL81FKG05-201166.md): Beech 200 · Alma, GA · Accident · No injuries · Closed · Dec 16, 1980 · N300CP · Substantial damage
- [NTSB MIA73FKGO7](https://openairdocs.org/ntsb/MIA73FKGO7.md): Starduster SA300 · Peachtree City, GA · Accident · 2 fatal · Closed · Jul 20, 1972 · N4706 · Destroyed
- [NTSB MIA70A0033](https://openairdocs.org/ntsb/MIA70A0033.md): Beech V35 · Fort Gaines, GA · Accident · 1 fatal · Closed · Oct 18, 1969 · N7944M · Destroyed
- [NTSB NYC70A0008](https://openairdocs.org/ntsb/NYC70A0008.md): Piper PA-23 · Savannah, GA · Accident · 5 fatal · Closed · Jul 9, 1969 · N4310Y · Destroyed
- [NTSB UNK65X0745](https://openairdocs.org/ntsb/UNK65X0745.md): Beechcraft A35 · Chatsworth, GA · Accident · 6 fatal · Closed · Nov 16, 1964 · N730B · Destroyed

## 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 = 990)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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