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

## Latest cases

- [NTSB ERA26LA344](https://openairdocs.org/ntsb/ERA26LA344.md): Aerospatiale SA 315 · Workmore, GA · Accident · No injuries · Class 3 · Limited · Preliminary report · Sep 18, 2026 · N238HA · Substantial damage
  > On September 18, 2026, at 1604 eastern daylight time, an Aerospatiale SA315B helicopter, N238HA was substantially damaged when it was involved in an accident near Workmore, Georgia. The pilot was not injured. The helicopter was operated as a Title 14 Code of…
- [NTSB ANC26LA103](https://openairdocs.org/ntsb/ANC26LA103.md): Robinson Helicopter R44 II · Colquitt, GA · Accident · No injuries · Class 3 · Limited · Preliminary report · Sep 11, 2026 · N4026E · Substantial damage
  > On September 11, 2026 about 0830 eastern daylight time, a Robinson R44 helicopter, N4026E, was substantially damaged when it was involved in an accident near Colquitt, Georgia. The pilot was not injured. The helicopter was operated as a Title 14 Code of…
- [NTSB ERA26LA272](https://openairdocs.org/ntsb/ERA26LA272.md): Cessna 170B · Hartwell, GA · Accident · Minor injuries · Class 4 · Limited · Final report · Jul 10, 2026 · N1838C · Substantial damage
  > The pilot’s failure to compensate for the gusty and variable wind conditions, which resulted in a loss of control and collision with trees during takeoff.
- [NTSB ERA26LA216](https://openairdocs.org/ntsb/ERA26LA216.md): Cessna A188B · Doerun, GA · Accident · No injuries · Class 3 · Limited · Preliminary report · May 23, 2026 · N8288G · Substantial damage
  > On May 23, 2026, about 1500 eastern daylight time, a Cessna A188B, N8288G, was substantially damaged when it was involved in an accident near Doerun, Georgia. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal Regulations Part…
- [NTSB ERA26LA210](https://openairdocs.org/ntsb/ERA26LA210.md): John Bradley Vans RV-7 · Athens, GA · Accident · No injuries · Class 4 · Limited · Final report · May 15, 2026 · N519JS · Substantial damage
  > Contamination of the left wheel brake system with debris, which resulted in a loss of directional control during takeoff.
- [NTSB ERA26LA012](https://openairdocs.org/ntsb/ERA26LA012.md): Cessna 172 · Sandersville, GA · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Oct 11, 2025 · N4390L · Substantial damage
  > On October 10, 2025, about 2015 eastern daylight time, a Cessna 172G, N4390L, was substantially damaged when it was involved in an accident near Sandersville, Geogia. The pilot was not injured and the passenger sustained minor injuries. The airplane was…
- [NTSB DCA25LA139](https://openairdocs.org/ntsb/DCA25LA139.md): Boeing 717 · Atlanta, GA · Incident · Minor injuries · Class 3 · Limited · Preliminary report · Feb 24, 2025 · N942AT · Minor damage
  > On February 24, 2025, at 0848 eastern standard time, Delta Air Lines flight 876, a Boeing 717-200, N942AT, experienced smoke in the cabin and cockpit during takeoff from Atlanta Hartsfield/Jackson International Airport (ATL), Atlanta Georgia. The airplane…
- [NTSB ERA25FA120](https://openairdocs.org/ntsb/ERA25FA120.md): Rockwell 112 · Covington, GA · Accident · 2 fatal · Class 3 · Field · Preliminary report · Feb 16, 2025 · N1423J · Destroyed
  > On February 15, 2025, about 2300, a Rockwell 112, N1423J, was destroyed when it was involved in an accident near Covington, Georgia. The private pilot and one passenger were fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations…
- [NTSB ERA24FA221](https://openairdocs.org/ntsb/ERA24FA221.md): Radley Vincent Quicksilver Sport 2S · Cleveland, GA · Accident · 1 fatal · Class 3 · Field · Final report · May 20, 2024 · N960B · Substantial damage
  > The pilot’s failure to maintain control of the airplane during the takeoff and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall and spin at low altitude. Contributing to the accident was the pilot’s lack of…
- [NTSB ERA24LA183](https://openairdocs.org/ntsb/ERA24LA183.md): Aeronca 11AC · Conyers, GA · Accident · Minor injuries · Class 4 · Limited · Final report · Mar 31, 2024 · N3420E · Substantial damage
  > An encounter with shifting wind conditions, which resulted in the airplane using more runway than anticipated, an aborted takeoff, and subsequent runway excursion. Contributing to the accident was the pilot’s failure account for the potential of variable and…
- [NTSB ERA23LA297](https://openairdocs.org/ntsb/ERA23LA297.md): Cessna 150L · Elberton, GA · Accident · Minor injuries · Class 3 · Limited · Final report · Jul 12, 2023 · N16071 · Substantial damage
  > The pilot’s decision to take off with a known engine issue, which resulted in a partial loss of power on the initial climb due to the No. 1 cylinder’s exhaust valve becoming stuck. Contributing to the outcome, was the pilot’s delay in aborting the takeoff.
- [NTSB ERA23LA279](https://openairdocs.org/ntsb/ERA23LA279.md): Edmisten Robert Eugene SR Rans S-14 Airaile · Bonaire, GA · Accident · Serious injuries · Class 4 · Limited · Final report · Jun 25, 2023 · N528RE · Substantial damage
  > The pilot’s failure to properly adjust the propeller’s pitch angle, which resulted in a loss of thrust and an inability to maintain altitude.
- [NTSB ERA23LA268](https://openairdocs.org/ntsb/ERA23LA268.md): Jabiru J250 · Louisville, GA · Accident · Minor injuries · Class 3 · Limited · Final report · Jun 3, 2023 · N828WD · Substantial damage
  > The pilot’s decision to take off in wind conditions that exceeded his ability to maintain directional control, resulting in a runway excursion and substantial damage to the airplane.
- [NTSB ERA22LA419](https://openairdocs.org/ntsb/ERA22LA419.md): Autogyro USA Calidus · Jasper, GA · Accident · No injuries · Class 4 · Limited · Final report · Sep 11, 2022 · N451AG · Substantial damage
  > The pilot’s failure to maintain control of the gyroplane during a touch-and-go landing.
- [NTSB ERA22LA265](https://openairdocs.org/ntsb/ERA22LA265.md): Piper PA-23 · Stockbridge, GA · Accident · Serious injuries · Class 3 · Limited · Final report · Jun 11, 2022 · N3477P · Substantial damage
  > A total loss of right engine power during initial climb for reasons that could not be determined.
- [NTSB ERA22LA188](https://openairdocs.org/ntsb/ERA22LA188.md): Robinson Helicopter R44 II · Calhoun, GA · Accident · Minor injuries · Class 4 · Limited · Final report · Apr 12, 2022 · N426DB · Substantial damage
  > The pilot’s failure to maintain clearance from wires during takeoff.
- [NTSB ERA21LA181](https://openairdocs.org/ntsb/ERA21LA181.md): Piper PA-32R-300 · Stockbridge, GA · Accident · No injuries · Class 4 · Limited · Final report · Apr 9, 2021 · N1664H · Substantial damage
  > The flying pilot’s failure to configure the flaps for a short field takeoff and delayed decision to abort the takeoff, which resulted in a runway overrun.
- [NTSB ERA21LA167](https://openairdocs.org/ntsb/ERA21LA167.md): Ayres S2R-G6 · Vienna, GA · Accident · No injuries · Class 4 · Limited · Final report · Mar 31, 2021 · N3299X · Destroyed
  > The pilot’s improper decision to attempt a takeoff with a quartering tailwind and his failure to reject the takeoff in a timely manner, which resulted in a runway excursion.
- [NTSB ERA20LA311](https://openairdocs.org/ntsb/ERA20LA311.md): Zenith CH650LS · Villa Rica, GA · Accident · No injuries · Class 4 · Limited · Final report · Sep 5, 2020 · N232PA · Substantial damage
  > A loss of directional control during the landing roll.
- [NTSB ERA20CA232](https://openairdocs.org/ntsb/ERA20CA232.md): Ayres S2R · Perry, GA · Accident · No injuries · Class 4 · Data collection · Final report · Jun 27, 2020 · N4032L · Substantial damage
  > The reported malfunction of the aileron flight control system during takeoff for reasons that could not be determined.
- [NTSB ERA20LA035](https://openairdocs.org/ntsb/ERA20LA035.md): Beech 55 · Griffin, GA · Accident · No injuries · Class 3 · Limited · Final report · Nov 9, 2019 · N686DR · Substantial damage
  > The pilot’s failure to ensure that the airplane was properly configured for takeoff, which resulted in the inadvertent retraction of the landing gear during the takeoff roll and the airplane’s subsequent runway excursion.
- [NTSB ERA19LA219](https://openairdocs.org/ntsb/ERA19LA219.md): Vans RV 4 · Williamson, GA · Accident · Serious injuries · Class 3 · Limited · Final report · Jun 27, 2019 · N102GL · Substantial damage
  > The pilot's inadvertent misplacement of the fuel selector, which resulted in a total loss of engine power due to fuel starvation.
- [NTSB ERA19LA152](https://openairdocs.org/ntsb/ERA19LA152.md): Bell 206 · Dublin, GA · Accident · No injuries · Class 3 · Limited · Final report · Apr 15, 2019 · N395AE · Substantial damage
  > A partial loss of engine power on takeoff due to separation of the diffuser assembly as a result of incomplete braze joint surfaces on the vane airfoils.
- [NTSB GAA19CA088](https://openairdocs.org/ntsb/GAA19CA088.md): Piper PA28 · Cornelia, GA · Accident · No injuries · Data collection · Final report · Dec 5, 2018 · N839AL · Substantial damage
  > The flight instructor's failure to maintain the runway heading during an attempted takeoff in gusting crosswind conditions, which resulted in a collision with trees.
- [NTSB GAA18CA282](https://openairdocs.org/ntsb/GAA18CA282.md): Diamond Aircraft Ind DA 20 · LaGrange, GA · Accident · No injuries · Data collection · Final report · May 13, 2018 · N143MA · Substantial damage
  > The student pilot’s failure to maintain lateral control during a soft-field takeoff.
- [NTSB GAA18CA047](https://openairdocs.org/ntsb/GAA18CA047.md): Cessna 140 · Macon, GA · Accident · No injuries · Data collection · Final report · Nov 8, 2017 · N76238 · Substantial damage
  > The pilot's incorrect pitch control during takeoff, which resulted in a nose-over.
- [NTSB ERA17LA324](https://openairdocs.org/ntsb/ERA17LA324.md): Cessna 195 · Newman, GA · Accident · No injuries · Limited investigation · Final report · Aug 10, 2017 · N2100C · Substantial damage
  > The improper rigging of the tailwheel assembly, which resulted in a loss of directional control during takeoff. Contributing to accident was the pilot’s decision to operate the airplane despite knowing it required excessive right rudder inputs for it to move…
- [NTSB ERA17LA217](https://openairdocs.org/ntsb/ERA17LA217.md): Barnes Richard B/Howe Michael Vans RV 10 · Blairsville, GA · Accident · No injuries · Limited investigation · Final report · Jun 26, 2017 · N865HB · Substantial damage
  > The pilot’s loss of directional control upon landing.
- [NTSB GAA17CA283](https://openairdocs.org/ntsb/GAA17CA283.md): Cessna 172 · Atlanta, GA · Accident · No injuries · Data collection · Final report · May 2, 2017 · N704RB · Substantial damage
  > The student’s incorrect use of the go-around procedure, which resulted in an aerodynamic stall, and the flight instructor’s delayed remedial action.
- [NTSB ERA17LA020](https://openairdocs.org/ntsb/ERA17LA020.md): Taylorcraft BC12 D · Vaughn, GA · Accident · Minor injuries · Limited investigation · Final report · Oct 17, 2016 · N94919 · Substantial damage
  > A total loss of engine power for reasons that could not be determined because postaccident examination of the airplane and engine did not reveal any evidence of preimpact malfunctions or failures that would have precluded normal operation.
- [NTSB GAA16CA497](https://openairdocs.org/ntsb/GAA16CA497.md): Cirrus Design SR20 · Brunswick, GA · Accident · No injuries · Data collection · Final report · Aug 22, 2016 · N204AK · Substantial damage
  > The total loss of engine power during takeoff due to a loose B-nut on the fuel flow divider input fuel line fitting, which resulted in a fuel leak and fuel starvation.
- [NTSB GAA16CA240](https://openairdocs.org/ntsb/GAA16CA240.md): Mills Gregory T AIR Commander LRT · Tybee Island, GA · Accident · No injuries · Data collection · Final report · May 14, 2016 · N962GT · Substantial damage
  > The pilot's decision to perform a touch-and-go on unsuitable terrain, which resulted in a loss of directional control and a rollover.
- [NTSB ERA16LA120](https://openairdocs.org/ntsb/ERA16LA120.md): Czech Aircraft Works Spol Sro Sportcruiser · Atlanta, GA · Accident · No injuries · Limited investigation · Final report · Feb 28, 2016 · N187SF · Substantial damage
  > A total loss of engine power due to fuel vapor lock. Contributing to the accident was the absence of a fuel return line.
- [NTSB GAA16CA129](https://openairdocs.org/ntsb/GAA16CA129.md): Pilatus PC12 · Lawrenceville, GA · Accident · No injuries · Data collection · Final report · Jan 27, 2016 · N338PC · Substantial damage
  > An unintentional collision with a white-tailed deer during the takeoff roll in night visual conditions.
- [NTSB GAA15CA216](https://openairdocs.org/ntsb/GAA15CA216.md): Cessna 150M · Ellijay, GA · Accident · No injuries · Data collection · Final report · Aug 5, 2015 · N3568V · Substantial damage
  > The pilot's failure to attain and maintain sufficient airspeed during takeoff which resulted in a descent, loss of directional control, and a runway excursion.
- [NTSB ERA15LA270](https://openairdocs.org/ntsb/ERA15LA270.md): Ayres S2R T34 · Climax, GA · Accident · No injuries · Limited investigation · Final report · Jul 9, 2015 · N524SL · Substantial damage
  > A loss of thrust on takeoff for reasons that could not be determined, because postaccident examination of the engine and propeller assembly did not reveal any mechanical anomalies that would have precluded normal operation.
- [NTSB GAA15CA047](https://openairdocs.org/ntsb/GAA15CA047.md): Piper PA 16 · Hartwell, GA · Accident · Minor injuries · Data collection · Final report · Apr 22, 2015 · N5616H · Substantial damage
  > The pilot's failure to maintain directional control during the takeoff roll.
- [NTSB ERA15CA152](https://openairdocs.org/ntsb/ERA15CA152.md): Cessna 182L · Waycross, GA · Accident · No injuries · Data collection · Final report · Mar 10, 2015 · N42667 · Substantial damage
  > The pilot's failure to use any airport guidance while taxiing, which resulted in geographic disorientation and a takeoff attempt from an inadequate length and unsuitable surface.
- [NTSB ERA15LA075](https://openairdocs.org/ntsb/ERA15LA075.md): Johnson David Earl Renegade Spirit · Brunswick, GA · Accident · 1 fatal · Limited investigation · Final report · Dec 13, 2014 · N955R · Substantial damage
  > The pilot's decision to fly the airplane with known engine deficiencies and his subsequent exceedance of the airplane's critical angle of attack following a loss of engine power, which resulted in an aerodynamic stall and loss of control after takeoff.
- [NTSB ERA14LA422](https://openairdocs.org/ntsb/ERA14LA422.md): Ackland Jeffrey Dean SH 3R · Columbus, GA · Accident · No injuries · Limited investigation · Final report · Sep 3, 2014 · N333AW · Substantial damage
  > The mechanic’s improper installation of the landing gear extend/retract switch, which resulted in the retraction of the landing gear during the aborted takeoff.
- [NTSB ERA14CA365](https://openairdocs.org/ntsb/ERA14CA365.md): Cessna 182B · Clayton, GA · Accident · No injuries · Data collection · Final report · Jul 27, 2014 · N2275G · Substantial damage
  > The pilot's failure to maintain directional control during takeoff, which resulted in a collision with a tree and then obstacles during the subsequent aborted takeoff.
- [NTSB ERA14LA105](https://openairdocs.org/ntsb/ERA14LA105.md): Piper PA-32RT-300 · Millen, GA · Accident · Minor injuries · Limited investigation · Final report · Jan 26, 2014 · N36086 · Substantial damage
  > The pilot's failure to fully seat the fuel selector in the left tank position before takeoff, which resulted in fuel starvation and a subsequent loss of engine power.
- [NTSB ERA13LA337](https://openairdocs.org/ntsb/ERA13LA337.md): Piper PA-28-181 · Columbus, GA · Accident · No injuries · Limited investigation · Final report · Jul 27, 2013 · N371JB · Substantial damage
  > The pilot's delayed decision to abort the takeoff. Contributing to the accident was the airplane's perceived lack of performance for reasons that could not be determined due to insufficient information.
- [NTSB ERA12CA424](https://openairdocs.org/ntsb/ERA12CA424.md): Beech 58 · Atlanta, GA · Accident · No injuries · Data collection · Final report · Jul 1, 2012 · N827EB · Substantial damage
  > The pilot's inadvertent retraction of the landing gear during the landing.
- [NTSB ERA12CA369](https://openairdocs.org/ntsb/ERA12CA369.md): Cessna 172 · Gainesville, GA · Accident · No injuries · Data collection · Final report · May 27, 2012 · N787LF · Substantial damage
  > The student pilot's improper use of the flight controls during the takeoff and the flight instructor's delayed remedial action. Contributing to the accident was the student pilot’s interference with the flight instructor’s attempted remedial actions.
- [NTSB ERA12LA315](https://openairdocs.org/ntsb/ERA12LA315.md): Berry Dean Glasair I · Columbus, GA · Accident · No injuries · Limited investigation · Final report · May 2, 2012 · N540GZ · Substantial damage
  > The pilot’s failure to maintain directional control during takeoff, which resulted in a runway excursion and collision with a runway sign. Contributing to the accident was the pilot’s lack of experience in the airplane make and model, resulting in and his…
- [NTSB ERA12CA283](https://openairdocs.org/ntsb/ERA12CA283.md): Cessna 150M · Cedartown, GA · Accident · No injuries · Data collection · Final report · Apr 14, 2012 · N714JJ · Substantial damage
  > The pilot’s failure to maintain directional control during takeoff.
- [NTSB ENG12IA001](https://openairdocs.org/ntsb/ENG12IA001.md): Boeing 757-251 · Atlanta, GA · Incident · No injuries · Incident investigation · Final report · Oct 10, 2011 · N553NW · Minor damage
  > the return to service of overhauled airplane engine parts with undetected fatigue cracks, resulting in complete loss of engine power and uncontained engine failure. A contributing factor was the inadequate diffuser and HPT case inspection procedure.
- [NTSB ENG11IA043](https://openairdocs.org/ntsb/ENG11IA043.md): Mcdonnell Douglas DC-9-51 · Atlanta, GA · Incident · No injuries · Incident investigation · Final report · Aug 6, 2011 · N676MC · Minor damage
  > The probable cause of the No. 2 engine failure and subsequent aborted takeoff was the high cycle fatigue failure of a fan blade near the blade root that resulted in extensive low pressure compressor damage and compressor case breach.
- [NTSB ENG11IA035](https://openairdocs.org/ntsb/ENG11IA035.md): Boeing 757-232 · Atlanta, GA · Incident · Minor injuries · Incident investigation · Final report · Jun 21, 2011 · N6714Q · No damage
  > Fuel leaking from the fuel flow transmitter that ignited on contact with the engine’s hot cases which resulted in an engine undercowl fire. The fuel leak resulted from the fuel flow transmitter end housing backing off from the main housing, creating a gap…

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

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