# NTSB investigations, GA: Taxi

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 3 · 107 cases

## Latest cases

- [NTSB ERA25LA073](https://openairdocs.org/ntsb/ERA25LA073.md): Cessna 560 · Atlanta, GA · Accident · No injuries · Class 4 · Limited · Final report · Dec 11, 2024 · N981AG · Substantial damage
  > The vehicle driver’s inadequate visual lookout while driving on a non-licensed vehicle roadway in restricted visibility conditions, which resulted in a collision with a taxiing airplane.
- [NTSB DCA24FA299](https://openairdocs.org/ntsb/DCA24FA299.md): Airbus A350-941 · College Park, GA · Accident · Minor injuries · Class 3 · Field · Final report · Sep 10, 2024 · N503DN · 2 aircraft · Minor damage
  > Delta Air Lines flight crew’s loss of situation awareness of the clearance between their right wingtip and the empennage of an Endeavor Air airplane holding on a perpendicular taxiway, resulting in their wingtip colliding with the other airplane’s empennage.…
- [NTSB DCA24LA295](https://openairdocs.org/ntsb/DCA24LA295.md): Airbus A330-323 · Atlanta, GA · Accident · No injuries · Class 4 · Limited · Final report · Aug 31, 2024 · N808NW · 2 aircraft · Minor damage
  > Delta Air Lines flight crew’s incorrect evaluation of the clearance between their airplane and the airplane directly ahead of them as they made a 90 degree right turn onto an adjacent taxiway.
- [NTSB ERA23LA386](https://openairdocs.org/ntsb/ERA23LA386.md): Cessna 172 · Greensboro, GA · Accident · No injuries · Class 4 · Limited · Final report · Sep 30, 2023 · N9522L · Substantial damage
  > The pilot’s failure to maintain clearance from a light pole during taxi.
- [NTSB GAA20CA080](https://openairdocs.org/ntsb/GAA20CA080.md): Symphony Aircraft Ind SA · Fitzgerald, GA · Accident · No injuries · Data collection · Final report · Nov 12, 2019 · N844SA · Substantial damage
  > The airplane’s impact with a deer while landing.
- [NTSB ERA20LA016](https://openairdocs.org/ntsb/ERA20LA016.md): Bombardier BD 700 1A10 · Augusta, GA · Accident · Serious injuries · Class 3 · Limited · Final report · Oct 16, 2019 · N307KP · No damage
  > The first officer's failure to maintain a safe distance from a large turbine-powered airplane while escorting passengers, resulting in a passenger encounter with jet blast.
- [NTSB GAA20CA021](https://openairdocs.org/ntsb/GAA20CA021.md): Wingtip To Wingtip Panzl S-330 · Cedartown, GA · Accident · No injuries · Data collection · Final report · Oct 11, 2019 · N540ML · 2 aircraft · Substantial damage
  > ***This report was modified on June 4, 2020. Please see the docket for this accident to view the original report.*** The departing pilot's failure to see and avoid the arriving airplane as it was turning off the runway from which the departing pilot was…
- [NTSB DCA19CA146](https://openairdocs.org/ntsb/DCA19CA146.md): Mcdonnell Douglas MD88 · Atlanta, GA · Accident · Minor injuries · Data collection · Final report · Apr 5, 2019 · N977DL · Substantial damage
  > failure of the tug driver to give way to the taxiing airplane.
- [NTSB DCA19CA105](https://openairdocs.org/ntsb/DCA19CA105.md): Boeing 737 · Atlanta, GA · Accident · No injuries · Class 4 · Data collection · Final report · Mar 11, 2019 · N3756 · 2 aircraft · Minor damage
  > failure of the B737 captain to maintain separation with the airplane stopped on the taxiway.
- [NTSB GAA18CA198](https://openairdocs.org/ntsb/GAA18CA198.md): Cessna 172 · Brunswick, GA · Accident · No injuries · Data collection · Final report · Feb 22, 2018 · N410ER · 2 aircraft · Substantial damage
  > The pilot receiving instruction’s failure to see and avoid an airplane holding short of the runway on the taxiway and the flight instructor’s lack of situational awareness.
- [NTSB ERA17LA253](https://openairdocs.org/ntsb/ERA17LA253.md): Waco UPF 7 · Brunswick, GA · Accident · No injuries · Limited investigation · Final report · Jul 3, 2017 · N134Q · Substantial damage
  > The failure of the right main landing gear strut brace for reasons that could not be determined based on the available evidence.
- [NTSB ERA16LA004](https://openairdocs.org/ntsb/ERA16LA004.md): Beech 58 · Albany, GA · Accident · No injuries · Limited investigation · Final report · Oct 6, 2015 · N25734 · Substantial damage
  > The mechanic's inadequate inspection of the brake system during the most recent annual inspection, which resulted in the failure of both left and right main landing gear torque plates and a subsequent loss of braking action.
- [NTSB ERA13LA299](https://openairdocs.org/ntsb/ERA13LA299.md): Aerotek Pitts S-2B · Cleveland, GA · Accident · No injuries · Limited investigation · Final report · Jun 19, 2013 · N5314Y · 2 aircraft · Minor damage
  > The taxiing pilot's inadequate visual lookout, which resulted in his airplane's collision with a stopped airplane.
- [NTSB ERA13CA155](https://openairdocs.org/ntsb/ERA13CA155.md): Engineering & Research Ercoupe 415-C · Newnan, GA · Accident · No injuries · Data collection · Final report · Mar 5, 2013 · N87172 · Substantial damage
  > The pilot's failure to maintain proper visual lookout during taxi operations, which resulted in a collision with a parked airplane.
- [NTSB ERA12CA382](https://openairdocs.org/ntsb/ERA12CA382.md): Beech B90 · Savannah, GA · Accident · No injuries · Data collection · Final report · May 12, 2012 · N275LE · Substantial damage
  > The pilot's failure to maintain adequate visual lookout while taxiing near a hangar, which resulted in airplane's right wingtip impacting the hangar door.
- [NTSB ERA11CA296](https://openairdocs.org/ntsb/ERA11CA296.md): Boeing 737-732 · Atlanta, GA · Accident · No injuries · Data collection · Final report · May 12, 2011 · N308DE · 2 aircraft · Minor damage
  > The B737-700 pilot did not maintain adequate wing tip clearance while taxiing around the stopped B-737-800.
- [NTSB ERA11CA131](https://openairdocs.org/ntsb/ERA11CA131.md): Piper PA-28-161 · Atlanta, GA · Accident · No injuries · Data collection · Final report · Jan 29, 2011 · N9127F · Substantial damage
  > The pilot's wrong turn while taxiing resulting in a collision with a sign.
- [NTSB ERA10CA402](https://openairdocs.org/ntsb/ERA10CA402.md): Cessna 172N · Perry, GA · Accident · No injuries · Data collection · Final report · Jul 30, 2010 · N1351E · Substantial damage
  > The pilot's failure to maintain clearance from a pole while taxiing.
- [NTSB ERA09CA216](https://openairdocs.org/ntsb/ERA09CA216.md): Cirrus Design SR22 · Atlanta, GA · Accident · No injuries · Data collection · Final report · Mar 18, 2009 · N748CD · Substantial damage
  > The failure of the pilot to maintain clearance with a parked airplane.
- [NTSB LAX08CA148](https://openairdocs.org/ntsb/LAX08CA148.md): Cessna 150H · Augusta, GA · Accident · No injuries · Data collection · Final report · May 20, 2008 · N7050S · Substantial damage
  > The pilot's inadequate decision to taxi during thunderstorm activity and his failure to maintain aircraft control. Contributing to the accident were thunderstorms and wind gusts.
- [NTSB ATL07CA058](https://openairdocs.org/ntsb/ATL07CA058.md): Cessna 172K · Cornelia, GA · Accident · No injuries · Data collection · Final report · Mar 22, 2007 · N46567 · Substantial damage
  > The failure of the owner/operator to repair or replace a known leaking brake system components resulting in a total loss of brakes while taxing and an on-ground collision with trees.
- [NTSB ATL04LA110](https://openairdocs.org/ntsb/ATL04LA110.md): Cessna 150K · Monticello, GA · Accident · No injuries · Limited investigation · Final report · Apr 29, 2004 · N5656G · Substantial damage
  > The pilot's failure to maintain clearance from trees during taxi from landing.
- [NTSB ATL03LA022](https://openairdocs.org/ntsb/ATL03LA022.md): Piper PA-28-161 · Eastman, GA · Accident · No injuries · Limited investigation · Final report · Dec 3, 2002 · N289HG · Substantial damage
  > The pilots failure to maintain a visual lookout resulting in the subsequent on ground collision with a hangar.
- [NTSB MIA01LA009](https://openairdocs.org/ntsb/MIA01LA009.md): Piper PA-28-161 · Jesup, GA · Accident · Minor injuries · Limited investigation · Final report · Oct 18, 2000 · N47881 · Substantial damage
  > A total failure of the wheel braking system due to the pilot's improper use of braking in downwind, downhill conditions, resulting in overheated brakes, and subsequent encounter with a downslope and terrain collision.
- [NTSB MIA00LA091](https://openairdocs.org/ntsb/MIA00LA091.md): Beech F90 · Monroe, GA · Accident · No injuries · Limited investigation · Final report · Feb 9, 2000 · N101ET · Substantial damage
  > chafed wiring that resulted in an electrical short which initiated the landing gear retraction cycle when cabin heat was activated, resulting in the main landing gear retracting during taxi.
- [NTSB MIA99LA013](https://openairdocs.org/ntsb/MIA99LA013.md): Cessna 172N · Lawrenceville, GA · Accident · No injuries · Limited investigation · Final report · Oct 23, 1998 · N5918E · Destroyed
  > A fire from an undetermined origin.
- [NTSB ATL98LA101](https://openairdocs.org/ntsb/ATL98LA101.md): Waco WMF · Chamblee, GA · Accident · No injuries · Limited investigation · Final report · Aug 6, 1998 · N723SR · Substantial damage
  > The pilot's excessive taxi speed and excessive braking action that resulted in a nose over.
- [NTSB MIA97LA247](https://openairdocs.org/ntsb/MIA97LA247.md): Piper PA-18A-150 · Bainbridge, GA · Accident · No injuries · Limited investigation · Final report · Sep 17, 1997 · N3985P · Substantial damage
  > the failure of the pilot to see and avoid the tractor resulting in an on ground collision. A factor in this accident was the limited forward visibility from the cockpit of the airplane.
- [NTSB ATL95LA114](https://openairdocs.org/ntsb/ATL95LA114.md): Cessna 172 · Peachtree City, GA · Accident · No injuries · Limited investigation · Final report · Jun 10, 1995 · N73785 · Substantial damage
  > The pilot's failure to maintain an adequate lookout while maneuvering on the ramp which resulted in his misjudging the clearance between his airplane and parked aircraft.
- [NTSB ATL95LA029](https://openairdocs.org/ntsb/ATL95LA029.md): Cessna 172F · Carrollton, GA · Accident · No injuries · Limited investigation · Final report · Dec 18, 1994 · N5440R · Substantial damage
  > The pilot's inadvertent collision with trees, adjacent to the taxiway, while attempting to avoid a deer that crossed the taxiway.
- [NTSB ATL94IA055](https://openairdocs.org/ntsb/ATL94IA055.md): Cessna 421B · Lagrange, GA · Incident · No injuries · Incident investigation · Final report · Feb 28, 1994 · N421HA · Minor damage
  > The pilot's intentional swerve off the taxiway to avoid a ground collision. A factor in the incident was an undetermined malfunction of the airplane's normal brake system.
- [NTSB ATL92LA117](https://openairdocs.org/ntsb/ATL92LA117.md): Piper PA-16 · Williamson, GA · Accident · Serious injuries · Limited investigation · Final report · Jun 6, 1992 · N6810K · 2 aircraft · Substantial damage
  > The failure of the pilot of N46RB (the sonerai) to maintain proper runway alignment during the takeoff roll, and his inadequate visual lookout. A factor was the lack of runway edge markings at this airport.
- [NTSB ATL92LA070](https://openairdocs.org/ntsb/ATL92LA070.md): Beech C-23 · Dalton, GA · Accident · No injuries · Limited investigation · Final report · Mar 28, 1992 · N6003Z · Substantial damage
  > The pilot's inadequate compensation for gusting winds while taxiing for takeoff which resulted in a lost of control. A factor was gusting quartering tail winds.
- [NTSB ATL91FA090](https://openairdocs.org/ntsb/ATL91FA090.md): Mcdonnell Douglas MD-88 · Atlanta, GA · Accident · Serious injuries · Field investigation · Final report · May 6, 1991 · N938DL · Substantial damage
  > The van driver's inadequate visual lookout and poor division of attention.
- [NTSB ATL91LA071](https://openairdocs.org/ntsb/ATL91LA071.md): Beech F33A · Chamblee, GA · Accident · No injuries · Limited investigation · Final report · Mar 26, 1991 · N7224L · Substantial damage
  > The hole in the airport taxiway, which was created by the erosion of soil beneath the taxiway, and the failure of the airport to inspect and maintain ditches which run beneath the runways and taxiways.
- [NTSB ATL91LA023](https://openairdocs.org/ntsb/ATL91LA023.md): Cessna 172N · Chamblee, GA · Accident · No injuries · Limited investigation · Final report · Nov 29, 1990 · N6168F · Substantial damage
  > Pilot's failure to maintain adequate wingtip clearance during taxi.
- [NTSB ATL90IA154](https://openairdocs.org/ntsb/ATL90IA154.md): Dassault DA20F · Chamblee, GA · Incident · No injuries · Incident investigation · Final report · Aug 3, 1990 · N457F · Minor damage
  > The right fuel control unit malfunctioned and allowed the engine speed to decrease below idle speed (45%) which resulted in an engine fire. Factors in the incident were: the improper rigging of the fuel control unit during installation, and the flight crew's…
- [NTSB ATL90LA026](https://openairdocs.org/ntsb/ATL90LA026.md): Learjet 24 · Atlanta, GA · Accident · No injuries · Limited investigation · Final report · Nov 13, 1989 · N500P · Substantial damage
  > The pilot in command's failure to insure his airplane was clear of a parked aircraft while maneuvering to park.
- [NTSB ATL90LA021](https://openairdocs.org/ntsb/ATL90LA021.md): Piper PA-38 · Lafayette, GA · Accident · No injuries · Limited investigation · Final report · Oct 28, 1989 · N2412N · Substantial damage
  > The pilot's failure to abort the takeoff, when the airplane began to veer left during the takeoff roll. Contributing to the accident was the pilot's failure to inspect the airplane wheel for damage after it dropped off the runway during taxi.
- [NTSB ATL88IA226](https://openairdocs.org/ntsb/ATL88IA226.md): Douglas DC-9-51 · Atlanta, GA · Incident · No injuries · Incident investigation · Final report · Aug 5, 1988 · N421EA · 2 aircraft · Minor damage
  > The eastern DC-9 collided with the delta DC-9 during taxi. Ground personnel had cleared the eastern flight forward after the pilot had completed a powerback which left the airplane perpendicular to the delta flight. Due to the long fuselage and the relative…
- [NTSB ATL88LA188](https://openairdocs.org/ntsb/ATL88LA188.md): Mooney M-20 · Hartwell, GA · Accident · No injuries · Limited investigation · Final report · Jun 4, 1988 · N5705Q · Substantial damage
  > The nose gear collapsed while taxiing at a speed of about 5 mph after landing. The annual inspection failed to disclose a material problem with the gear truss. Examination of the fractured component disclosed that the tubular material had rusted from the…
- [NTSB ATL88LA133](https://openairdocs.org/ntsb/ATL88LA133.md): Cessna 152 · Macon, GA · Accident · No injuries · Limited investigation · Final report · Apr 7, 1988 · N49409 · Substantial damage
  > The acft was taxiing for departure when a gust of wind lifted the left wing and the acft overturned. The surface winds were reported at 16 knots with gusts to 27 knots. The plt stated that proper flight control inputs were used for taxiing in windy conditions.
- [NTSB ATL88LA122](https://openairdocs.org/ntsb/ATL88LA122.md): Cessna 310Q · Donalsonville, GA · Accident · No injuries · Limited investigation · Final report · Mar 20, 1988 · N7765Q · Destroyed
  > The pilot stated that he had experienced prior brake problems and had repeated maintenance performed. He further stated that not all of the brake problems had been corrected. After landing the pilot noticed that the right brake seemed 'spongy'. He continued…
- [NTSB ATL88IA107](https://openairdocs.org/ntsb/ATL88IA107.md): Boeing 737-232 · Atlanta, GA · Incident · No injuries · Incident investigation · Final report · Mar 10, 1988 · N310DA · Minor damage
- [NTSB ATL87FA250](https://openairdocs.org/ntsb/ATL87FA250.md): British Aerospace 3101 · Atlanta, GA · Accident · Minor injuries · Field investigation · Final report · Sep 8, 1987 · N407MX · Substantial damage
  > The airplane was struck by an eastbound, airline employee bus while taxiing south on the ramp to the assigned gate. The bus impacted the acft rt wing tip. A pax in the bus reported that she warned the bus driver to watch out for the airplane prior to the…
- [NTSB ATL87FA161](https://openairdocs.org/ntsb/ATL87FA161.md): Cessna 208B · Atlanta, GA · Accident · No injuries · Field investigation · Final report · Jun 5, 1987 · N917FE · 2 aircraft · Substantial damage
  > The two acft collided on a ramp while each was taxiing to rwy 8L for t/o. both acft were authorized by ATC to taxi to the rwy; the Cessna was instructed by ATC to follow the Beech. The two acft were hdg in the same general direction on converging paths when…
- [NTSB ATL85FKG05](https://openairdocs.org/ntsb/ATL85FKG05.md): Piper PA-31 · Atlanta, GA · Accident · No injuries · Final report · May 2, 1985 · N902BH · Substantial damage
  > On may 2, 1985, at 0714 EDT, a Piper PA-31, N902BH, regisered to paul m. furnee, was struck by a ground vehicle while taxiing for take off at hartsfield international airport, Atlanta, Georgia on an airtaxi cargo flight. Instrument meteorological conditions…
- [NTSB ATL84LA128](https://openairdocs.org/ntsb/ATL84LA128.md): Cessna 337E · Tifton, GA · Accident · Minor injuries · Limited investigation · Final report · Mar 26, 1984 · N86520 · Substantial damage
  > The acft reportedly was not tied down. The plt was hand propping the aft engine while the forward engine was running. In an attempt to board the acft the pilot was run over by the right main gear. The acft continued to travel until it collided with trees.
- [NTSB ATL84FA057](https://openairdocs.org/ntsb/ATL84FA057.md): Piper PA-28R-200 · Atlanta, GA · Accident · No injuries · Field investigation · Final report · Nov 29, 1983 · N16AK · Substantial damage
  > After gompleting a preflt, the plt entered the acft & attempted to start the eng with the starter & on board battery. He stated that the eng turned slowly & would not start. After several attempts to make a normal start, the plt exited the acft, chocked the…
- [NTSB ATL83LA323](https://openairdocs.org/ntsb/ATL83LA323.md): Bellanca 8-KCAB-150 · Kennesaw, GA · Accident · No injuries · Limited investigation · Final report · Aug 12, 1983 · N5500C · 2 aircraft · Substantial damage
  > Both aircraft were taxiing simultaneously, in opposite directions on the single parallel taxiway. N5500C was east bound for takeoff. N69113 was westbound on the taxiway after landing on runway 27 and a turn onto the taxiway. The pilot of N5500C stated that…

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

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