# NTSB investigations, SC: 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 5 · 235 cases

## Latest cases

- [NTSB ERA26LA234](https://openairdocs.org/ntsb/ERA26LA234.md): Robinson Helicopter R44 · Mayesville, SC · Accident · Serious injuries · Class 4 · Limited · Final report · Jun 8, 2026 · N144CD · Substantial damage
  > The pilot’s failure to remain clear of a power line during an aerial application flight.
- [NTSB ERA26LA097](https://openairdocs.org/ntsb/ERA26LA097.md): Hughes 369 · North Augusta, SC · Accident · No injuries · Class 3 · Limited · Preliminary report · Jan 22, 2026 · N105AC · Substantial damage
  > On January 22, 2026, at 1600 eastern standard time, a Hughes 369D, N105AC, was substantially damaged when it was involved in an accident near North Augusta, South Carolina. The pilot was not injured. The helicopter was operated as a Title 14 Code of Federal…
- [NTSB ERA25LA336](https://openairdocs.org/ntsb/ERA25LA336.md): Let L-23 Super Blanik · Ridgeland, SC · Accident · Serious injuries · Class 4 · Limited · Final report · Sep 6, 2025 · N231LS · Substantial damage
  > The pilot’s exceedance of the glider’s critical angle of attack which resulted in a loss of control while maneuvering to return for landing after a runway overshoot.
- [NTSB ERA24LA393](https://openairdocs.org/ntsb/ERA24LA393.md): Robinson Helicopter R44 II · Ravenel, SC · Accident · No injuries · Class 4 · Limited · Final report · Sep 23, 2024 · N153LA · Substantial damage
  > The pilot’s failure to maintain clearance from terrain, which resulted in the right skid contacting the ground and a subsequent rollover.
- [NTSB ERA22FA243](https://openairdocs.org/ntsb/ERA22FA243.md): Piper PA-12 · North Myrtle Beach, SC · Accident · 1 fatal · Class 3 · Field · Final report · May 28, 2022 · N4421M · Substantial damage
  > The pilot's exceedance of the airplane's critical angle of attack, which resulted in a subsequent aerodynamic stall at an altitude that was too low for recovery.
- [NTSB ERA22LA256](https://openairdocs.org/ntsb/ERA22LA256.md): Robinson Helicopter R44 · North Myrtle Beach, SC · Accident · No injuries · Class 3 · Limited · Final report · May 26, 2022 · N132TC · Substantial damage
  > The fractured attachment lug on the forward clutch shaft yoke due to fatigue failure with multiple origins.
- [NTSB ERA21LA344](https://openairdocs.org/ntsb/ERA21LA344.md): Piper PA32 · Spartanburg, SC · Accident · Serious injuries · Class 3 · Limited · Final report · Aug 28, 2021 · N3862W · Substantial damage
  > The flight instructor’s improper fuel management, which resulted in fuel starvation and a total loss of engine power.
- [NTSB ERA21LA192](https://openairdocs.org/ntsb/ERA21LA192.md): Meyeres F L/Meyeres M M Skystar Ktfox Clsc 4 · Mountain Rest, SC · Accident · Serious injuries · Class 3 · Limited · Final report · Apr 25, 2021 · N90KF · Substantial damage
  > A partial loss of engine power due to carburetor icing. Contributing to the accident was the engine’s lack of carburetor heat.
- [NTSB ERA21LA395](https://openairdocs.org/ntsb/ERA21LA395.md): Schempp Hirth Ventus C · Wagener, SC · Accident · Serious injuries · Class 4 · Limited · Final report · Apr 22, 2021 · N571RD · Substantial damage
  > Impact with trees during a forced landing in atmospheric lift conditions that were insufficient to maintain flight. Contributing was the pilot’s delayed decision to return to the airport.
- [NTSB ERA20LA335](https://openairdocs.org/ntsb/ERA20LA335.md): Piper PA28 · Union, SC · Accident · Serious injuries · Class 3 · Limited · Final report · Sep 27, 2020 · N33859 · Destroyed
  > A total loss of engine power due to carburetor icing. Contributing to the accident was the pilot’s failure to use carburetor heat in conditions conducive to the development of carburetor icing.
- [NTSB ERA20LA270](https://openairdocs.org/ntsb/ERA20LA270.md): Piper PA31 · Sumter, SC · Accident · Minor injuries · Class 3 · Limited · Final report · Aug 1, 2020 · C-GXKS · Substantial damage
  > The pilot’s fuel mismanagement during flight, which resulted in a total loss of engine power from both engines due to fuel starvation.
- [NTSB GAA20CA066](https://openairdocs.org/ntsb/GAA20CA066.md): American AA 5 · Gilbert, SC · Accident · No injuries · Data collection · Final report · Nov 2, 2019 · N24AU · Substantial damage
  > The pilot's improper approach path, which resulted in impact with a tree.
- [NTSB GAA19CA403](https://openairdocs.org/ntsb/GAA19CA403.md): Md Helicopter 369 · Summersville, SC · Accident · Minor injuries · Data collection · Final report · Jun 26, 2019 · N500SC · Substantial damage
  > The copilot’s disabling of the flight controls of an operating helicopter without telling the pilot on the controls, which resulted in a subsequent loss of control and collision with terrain.
- [NTSB ERA18LA258](https://openairdocs.org/ntsb/ERA18LA258.md): Beech 35 · Georgetown, SC · Accident · Minor injuries · Class 3 · Limited · Final report · Sep 22, 2018 · N435RB · Substantial damage
  > A loss of directional control during landing due to overstress failure of the left seat’s left rudder pedal arm clevis, which occurred as a result of manufacturing defects.
- [NTSB ERA18LA249](https://openairdocs.org/ntsb/ERA18LA249.md): Edward R. Sugg Sonex · Marion, SC · Accident · 1 fatal · Limited investigation · Final report · Sep 12, 2018 · N75SX · Destroyed
  > Impact with terrain for reasons that could not be determined based on the available information.
- [NTSB GAA18LA131](https://openairdocs.org/ntsb/GAA18LA131.md): Robinson Helicopter R22 · Charleston, SC · Accident · No injuries · Limited investigation · Final report · Feb 14, 2018 · N337H · Substantial damage
  > The flight instructor’s abrupt evasive maneuver to avoid a reported unmanned aerial system, which resulted in a loss of forward airspeed and settling with power and a subsequent collision with trees and terrain.
- [NTSB ERA18FA004](https://openairdocs.org/ntsb/ERA18FA004.md): Cessna 401 · Salters, SC · Accident · 2 fatal · Field investigation · Final report · Oct 4, 2017 · N401HH · Destroyed
  > The pilot's decision to attempt a low-altitude aerobatic maneuver in a non-aerobatic airplane, and his subsequent failure to maintain control of the airplane during the maneuver. Contributing to the accident was the pilot's impairment by the effects of…
- [NTSB ERA17LA235](https://openairdocs.org/ntsb/ERA17LA235.md): Cessna T337 · Greenwood, SC · Accident · Minor injuries · Limited investigation · Final report · Jul 7, 2017 · N337J · Substantial damage
  > The pilots' inadequate preflight inspection, during which they failed to adequately verify the quantity of fuel, which resulted in fuel exhaustion, a subsequent total loss of power to both engines, and a forced landing into trees. Contributing to the accident…
- [NTSB ERA17FA164](https://openairdocs.org/ntsb/ERA17FA164.md): Bell-Carson 47G Super C 4 · Timmonsville, SC · Accident · 1 fatal · Field investigation · Final report · Apr 21, 2017 · N865Z · Destroyed
  > The pilot's decision to maneuver the helicopter at a low altitude near trees, which resulted in collision with the trees.
- [NTSB ERA16LA139](https://openairdocs.org/ntsb/ERA16LA139.md): Hall, Wendall W Harmon Rocket II · Cheraw, SC · Accident · 1 fatal · Limited investigation · Final report · Mar 24, 2016 · N729PS · Substantial damage
  > The pilot's decision to fly at low altitude, which resulted in a collision with power lines.
- [NTSB GAA15CA081](https://openairdocs.org/ntsb/GAA15CA081.md): Citabria 7GCBC · Winnsboro, SC · Accident · Serious injuries · Data collection · Final report · May 20, 2015 · N50595 · Substantial damage
  > The pilot's execution of a steep left turn at low altitude during an aborted landing, which resulted in an aerodynamic stall, and a collision with terrain.
- [NTSB ERA14FA144](https://openairdocs.org/ntsb/ERA14FA144.md): Rogers George T Lancair IVP · Hartsville, SC · Accident · 3 fatal · Field investigation · Final report · Mar 8, 2014 · N724HP · Substantial damage
  > Failure of the flying pilot to maintain control of the airplane while maneuvering at a low altitude, which resulted in the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall. Contributing to the accident were the…
- [NTSB ERA13LA410](https://openairdocs.org/ntsb/ERA13LA410.md): Cessna 188B · Woodrow, SC · Accident · Minor injuries · Limited investigation · Final report · Sep 4, 2013 · N59JK · Substantial damage
  > A failure of the right rudder pedal arm due to corrosion as a result of inadequate maintenance and inspection of the rudder pedal assembly.
- [NTSB ERA13FA340](https://openairdocs.org/ntsb/ERA13FA340.md): Folland Gnat T 1 · Georgetown, SC · Accident · 1 fatal · Field investigation · Final report · Jul 29, 2013 · N18GT · Destroyed
  > The loss of airplane control for reasons that could not be determined due to postcrash fire damage. Contributing to the accident was the pilot’s decision to perform an aerobatic maneuver at low altitude, which did not allow sufficient time for him to regain…
- [NTSB ERA13CA324](https://openairdocs.org/ntsb/ERA13CA324.md): Boeing B75N1 · Woodruff, SC · Accident · Minor injuries · Data collection · Final report · Jul 17, 2013 · N5815V · Substantial damage
  > The pilot’s decision to initiate a stall maneuver at a low altitude, which resulted in an uncontrolled descent and inadvertent collision with trees and terrain.
- [NTSB ERA13FA295](https://openairdocs.org/ntsb/ERA13FA295.md): Rockwell International 690B · McClellanville, SC · Accident · 2 fatal · Field investigation · Final report · Jun 20, 2013 · N727JA · Destroyed
  > The pilot’s loss of airplane control during high-altitude maneuvering and his subsequent failure to recover airplane control. Contributing to the accident was the flight instructor’s inadequate supervision of the pilot and his failure to perform remedial…
- [NTSB ERA12LA500](https://openairdocs.org/ntsb/ERA12LA500.md): Beech V35B · Effingham, SC · Accident · No injuries · Limited investigation · Final report · Aug 11, 2012 · N11JK · Substantial damage
  > The pilot's failure to avoid an encounter with known adverse weather conditions, which resulted in an in-flight upset, temporary loss of control, and loading of the airframe, engine, and propeller that led to the in-flight separation of the propeller and the…
- [NTSB ERA12LA468](https://openairdocs.org/ntsb/ERA12LA468.md): Piper PA-18-150 · North Myrtle Beach, SC · Accident · Minor injuries · Limited investigation · Final report · Jul 18, 2012 · N2991Z · Substantial damage
  > A total loss of engine power due to carburetor icing.
- [NTSB ERA12LA453](https://openairdocs.org/ntsb/ERA12LA453.md): Piper PA-18-150 · North Myrtle Beach, SC · Accident · No injuries · Limited investigation · Final report · Jul 15, 2012 · N8048D · Substantial damage
  > The pilot's inadequate use of carburetor heat during cruise flight, which resulted in a partial loss of engine power and subsequent forced landing.
- [NTSB ERA12LA400](https://openairdocs.org/ntsb/ERA12LA400.md): Barney Oldfield Baby Lakes · Anderson, SC · Accident · No injuries · Limited investigation · Final report · Jun 16, 2012 · N10XB · Substantial damage
  > A total loss of engine power as a result of an inadequate amount of lubricating oil in the engine. Contributing to the accident was the pilot's improper preflight inspection.
- [NTSB ERA11LA415](https://openairdocs.org/ntsb/ERA11LA415.md): Polaris Polar Star · Dewees Island, SC · Accident · 2 fatal · Limited investigation · Final report · Jul 20, 2011 · UNREG · Substantial damage
  > The non-certificated pilot’s operation of the unregistered airplane while impaired by alcohol. Contributing to the accident was the pilot’s performance of aerobatic maneuvers that exceeded the structural limits of the aircraft, which resulted in failure of…
- [NTSB ERA11FA151](https://openairdocs.org/ntsb/ERA11FA151.md): Cessna 150E · Ware Shoals, SC · Accident · 1 fatal · Field investigation · Final report · Feb 19, 2011 · N3022J · Substantial damage
  > The non-certificated pilot's impairment due to alcohol and a sedating antihistamine, which resulted in his failure to maintain airspeed and the subsequent aerodynamic stall and ground impact.
- [NTSB ERA10LA383](https://openairdocs.org/ntsb/ERA10LA383.md): Hiller UH-12E · Holly Hill, SC · Accident · Serious injuries · Limited investigation · Final report · Jul 29, 2010 · N104HH · Substantial damage
  > Maintenance personnel's improper inspection and cleaning of the fuel nozzle, which resulted in a total loss of engine power.
- [NTSB ERA10FA359](https://openairdocs.org/ntsb/ERA10FA359.md): Piper PA-28RT-201 · North Myrtle Beach, SC · Accident · 3 fatal · Field investigation · Final report · Jul 15, 2010 · N2825A · Substantial damage
  > The pilot's failure to maintain aircraft control while maneuvering in instrument meteorological conditions around a thunderstorm. Contributing to the accident was the pilot's lack of recent actual instrument experience.
- [NTSB ERA10CA309](https://openairdocs.org/ntsb/ERA10CA309.md): Air Tractor AT-402B · Alcolu, SC · Accident · No injuries · Data collection · Final report · Jun 10, 2010 · N5085Q · Substantial damage
  > The pilot’s failure to maintain clearance from a tree. Contributing to the accident was the sunglare.
- [NTSB ERA09FA515](https://openairdocs.org/ntsb/ERA09FA515.md): Cirrus SR-22 · Rock Hill, SC · Accident · 1 fatal · Field investigation · Final report · Sep 11, 2009 · N922XX · Destroyed
  > The pilot's failure to maintain aircraft control and altitude while maneuvering after takeoff.
- [NTSB ERA09CA319](https://openairdocs.org/ntsb/ERA09CA319.md): Cessna A188B · Kingstree, SC · Accident · No injuries · Data collection · Final report · Jun 3, 2009 · N9364R · Substantial damage
  > The pilot's failure to maintain adequate airspeed while maneuvering, which resulted in an aerodynamic stall.
- [NTSB ERA09LA272](https://openairdocs.org/ntsb/ERA09LA272.md): Cessna 172 · Chesterfield, SC · Accident · Minor injuries · Limited investigation · Final report · Apr 27, 2009 · N9884Q · Substantial damage
  > The partial loss of engine power due to a broken exhaust valve. Contributing to the accident was the operator's exceedance of the engine manufacturer's recommended time before overhaul.
- [NTSB ERA09LA107](https://openairdocs.org/ntsb/ERA09LA107.md): Moore David DM-1 · Salters, SC · Accident · Minor injuries · Limited investigation · Final report · Dec 25, 2008 · N75EW · Substantial damage
  > A hard landing following an autorotation that resulted from the separation of the red main rotor blade cap that led to the uncontrolled movement of the cyclic, autorotation and a hard landing.
- [NTSB NYC08LA249](https://openairdocs.org/ntsb/NYC08LA249.md): Piper PA-18-150 · Surfside Beach, SC · Accident · Minor injuries · Limited investigation · Final report · Jul 15, 2008 · N4287Z · Substantial damage
  > A loss of engine power due to carburetor icing. Contributing to the accident was the obstruction of the carburetor heat flapper by a mud dauber's nest.
- [NTSB MIA08LA135](https://openairdocs.org/ntsb/MIA08LA135.md): Piper PA-18-150 · N Myrtle Beach, SC · Accident · Minor injuries · Limited investigation · Final report · Jul 3, 2008 · N6851Z · Substantial damage
  > The failure of the banner tow operator to inspect banners for deterioration, resulting in a portion of a banner separating in-flight from another banner tow airplane, and colliding with the accident banner tow airplane.
- [NTSB NYC07LA124](https://openairdocs.org/ntsb/NYC07LA124.md): Boeing Stearman A75N1 · Charleston, SC · Accident · 2 fatal · Limited investigation · Final report · May 23, 2007 · N55718 · Substantial damage
  > An in-flight collision with water for undetermined reasons.
- [NTSB ATL05LA110](https://openairdocs.org/ntsb/ATL05LA110.md): Casten Rans S-10 · Perry, SC · Accident · 1 fatal · Limited investigation · Final report · Jun 23, 2005 · N327AN · Substantial damage
  > A loss of engine power due to fuel starvation as a result of the pilot mismanagement. Contributing to the accident was the pilot's failure to maintain adequate airspeed resulting in a stall during the forced landing.
- [NTSB ATL05FA086](https://openairdocs.org/ntsb/ATL05FA086.md): Piper PA-18-135 · Conway, SC · Accident · 2 fatal · Field investigation · Final report · May 23, 2005 · N9951Q · Destroyed
  > The pilot's failure to maintain airspeed while maneuvering after releasing a banner aerial sign, resulting in an inadvertent stall and collision with the ground. A factor in the accident was the flight instructor's improper supervision of the pilot receiving…
- [NTSB ATL05LA073](https://openairdocs.org/ntsb/ATL05LA073.md): Anderson Mini Mustang · Mullins, SC · Accident · 1 fatal · Limited investigation · Final report · Apr 17, 2005 · N416A · Substantial damage
  > The pilot's inadequate visual lookout and the pilot's failure to maintain clearance from trees while maneuvering.
- [NTSB ATL04CA163](https://openairdocs.org/ntsb/ATL04CA163.md): Cessna 172 · Inman, SC · Accident · Minor injuries · Data collection · Final report · Jul 29, 2004 · N3967F · Substantial damage
  > The pilot's failure to maintain clearance from the ground while maneuvering for a visual approach to land.
- [NTSB ATL03LA094](https://openairdocs.org/ntsb/ATL03LA094.md): Kerner Lancair IV · Allendale, SC · Accident · 4 fatal · Limited investigation · Final report · May 16, 2003 · N29ME · Destroyed
  > The pilot's inadvertent flight into adverse weather,thunderstorms, that resulted in the design limits of the airplane being exceeded.
- [NTSB ATL02LA122](https://openairdocs.org/ntsb/ATL02LA122.md): Cessna 172R · N Myrtle Beach, SC · Accident · No injuries · Limited investigation · Final report · Jun 15, 2002 · N9857F · Substantial damage
  > The pilot's failure to maintain airspeed during a banner tow pickup resulting in an inadvertent stall and uncontrolled descent and collision with terrain.
- [NTSB ATL02TA021](https://openairdocs.org/ntsb/ATL02TA021.md): Bell 206 · Awendaw, SC · Accident · No injuries · Final report · Dec 21, 2001 · N206HE · Substantial damage
  > The pilot's failure to maintain clearance from the bambi bucket suspension assembly during dip operation.
- [NTSB ATL00LA087](https://openairdocs.org/ntsb/ATL00LA087.md): Grumman G164A · Dillon, SC · Accident · No injuries · Limited investigation · Final report · Sep 9, 2000 · N7955 · Substantial damage
  > A total loss of engine power due to a cracked cylinder head. A factor was the emergency landing into unsuitable terrain, and the subsequent nose over.

Next page: https://openairdocs.org/ntsb-phases/450/cases.md?state=SC&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" = 'SC' 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=SC

---
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.