# NTSB investigations, SC: Approach

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 · 253 cases

## Latest cases

- [NTSB ERA25LA316](https://openairdocs.org/ntsb/ERA25LA316.md): Piper PA-28-140 · Seneca, SC · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Aug 26, 2025 · N1684J · Substantial damage
  > On August 26, 2025, at 0831 eastern standard time, a Piper PA28-140, N1684J, was substantially damaged when it was involved in an accident near Seneca, South Carolina. The sole occupant, a student pilot, received minor injuries. The airplane was operated as a…
- [NTSB ERA25LA097](https://openairdocs.org/ntsb/ERA25LA097.md): Jonathan C Eggers Challenger II · Conway, SC · Accident · No injuries · Class 4 · Limited · Final report · Jan 14, 2025 · N938SE · Substantial damage
  > The pilot's inadequate fuel planning, which resulted in a total total loss of engine power due to fuel exhaustion.
- [NTSB ERA24LA284](https://openairdocs.org/ntsb/ERA24LA284.md): Corella Neil RV9A · Saluda, SC · Accident · Serious injuries · Class 4 · Limited · Final report · Jun 30, 2024 · N94NF · Substantial damage
  > The pilot’s failure to maintain an appropriate glide path during the landing approach in variable wind conditions, which resulted in collision with trees.
- [NTSB ERA23LA319](https://openairdocs.org/ntsb/ERA23LA319.md): Bell Helicopter Textron Canada 407 · North Charleston, SC · Accident · Minor injuries · Class 3 · Limited · Final report · Aug 1, 2023 · N31PB · Substantial damage
  > A failure of the tail rotor pitch change lever assembly due to incorrectly installed bolts and maintenance personnel’s inadequate inspection of the tail rotor control system.
- [NTSB ERA23LA132](https://openairdocs.org/ntsb/ERA23LA132.md): Stilp Tanner E Savannah S · Trenton, SC · Accident · Serious injuries · Class 3 · Limited · Final report · Feb 28, 2023 · N945HS · Substantial damage
  > The loss of control during the base turn to final due to the impingement of the Y-stick control by a notepad.
- [NTSB ERA23LA049](https://openairdocs.org/ntsb/ERA23LA049.md): Cessna 172 · Greenville, SC · Accident · Serious injuries · Class 4 · Limited · Final report · Nov 2, 2022 · N65615 · Substantial damage
  > The pilot’s improper fuel management, which resulted in a total loss of engine power due to fuel starvation. Contributing was the pilot’s failure to use the checklist aboard the airplane during her attempts to restore engine power.
- [NTSB ERA22LA319](https://openairdocs.org/ntsb/ERA22LA319.md): Mooney M20J · Charleston, SC · Accident · No injuries · Class 4 · Limited · Final report · Jun 12, 2022 · N9158D · Substantial damage
  > The failure of the torsion spring inside the drive clutch assembly of the landing gear actuator which prevented normal and manual extension of the landing gear.
- [NTSB ERA21LA280](https://openairdocs.org/ntsb/ERA21LA280.md): Piper PA28 · Bishopville, SC · Accident · No injuries · Class 4 · Limited · Final report · Jul 7, 2021 · N1592J · Substantial damage
  > The flight instructor’s inadequate supervision of the student during a go-around, which resulted in a loss of lift and a subsequent collision with the VASI lights.
- [NTSB ERA21FA224](https://openairdocs.org/ntsb/ERA21FA224.md): Piper PA-31P · Myrtle Beach, SC · Accident · 1 fatal · Class 3 · Field · Final report · May 21, 2021 · N575BC · Destroyed
  > The mechanic’s inadvertent installation of the elevator trim tabs in reverse, which resulted in the pitch trim system operating opposite of the pilot’s input and the pilot’s subsequent loss of control.
- [NTSB ERA21LA172](https://openairdocs.org/ntsb/ERA21LA172.md): Phantom Aeronautics Phantom II · McBee, SC · Accident · Minor injuries · Class 4 · Limited · Final report · Apr 4, 2021 · UNREG · Substantial damage
  > The pilot's failure to maintain adequate clearance from trees while maneuvering in the traffic pattern.
- [NTSB ERA21LA101](https://openairdocs.org/ntsb/ERA21LA101.md): Beech F33 · Columbia, SC · Accident · 1 fatal · Class 3 · Limited · Final report · Jan 13, 2021 · N266DC · Destroyed
  > The pilot's in-flight loss of airplane control due to spatial disorientation during a missed approach in instrument meteorological conditions.
- [NTSB ERA21LA054](https://openairdocs.org/ntsb/ERA21LA054.md): Piper PA32 · Greenville, SC · Accident · Serious injuries · Class 3 · Limited · Final report · Nov 24, 2020 · N5566J · Substantial damage
  > A partial loss of engine power due to the pilot’s delayed application of carburetor heat, which resulted in carburetor icing.
- [NTSB ERA20LA278](https://openairdocs.org/ntsb/ERA20LA278.md): Cessna P210 · Allendale, SC · Accident · Serious injuries · Class 3 · Limited · Final report · Aug 7, 2020 · N6300W · Destroyed
  > A total loss of engine power as a result of fuel starvation due to contamination from a thermoplastic polymer used in the fuel system. Contributing to the accident was the pilot’s failure to report debris observed in the fuel system during previous preflight…
- [NTSB ERA20LA129](https://openairdocs.org/ntsb/ERA20LA129.md): Cirrus SR22 · Conway, SC · Accident · No injuries · Class 3 · Limited · Final report · Mar 17, 2020 · N150X · Substantial damage
  > The pilot’s incorrect use of the autopilot while approaching the initial approach fix and his subsequent improper primary pitch control input while a pitch mode of the autopilot was engaged, which resulted in pitch excursions and subsequent departure from…
- [NTSB ERA19LA043](https://openairdocs.org/ntsb/ERA19LA043.md): Aero Commander 690 · Myrtle Beach, SC · Accident · Serious injuries · Class 3 · Limited · Final report · Nov 12, 2018 · N840JC · Substantial damage
  > An encounter with low-level windshear and turbulence during the landing approach, which resulted in a loss of airplane control.
- [NTSB ERA18LA095](https://openairdocs.org/ntsb/ERA18LA095.md): Robert Snyder Autogyro Calidus · Beaufort, SC · Accident · 1 fatal · Limited investigation · Final report · Mar 5, 2018 · N221YT · Substantial damage
  > The gyroplane pilot's failure to maintain rotor speed and aircraft control as he was attempting to return to the runway during a low-altitude simulated engine-out maneuver.
- [NTSB GAA17CA322](https://openairdocs.org/ntsb/GAA17CA322.md): Piper PA28 · Gilbert, SC · Accident · No injuries · Data collection · Final report · May 27, 2017 · N5544J · Substantial damage
  > The pilot's improper glidepath in variable wind conditions, which resulted in the airplane impacting terrain short of the runway threshold.
- [NTSB ERA16FA168](https://openairdocs.org/ntsb/ERA16FA168.md): Ryskamp Bruce A Acroduster · Belton, SC · Accident · 1 fatal · Field investigation · Final report · Apr 24, 2016 · N380JA · Destroyed
  > A loss of engine power for reasons that could not be determined due to extensive postcrash fire damage. Also causal was the pilot's loss of airplane control, resulting in an aerodynamic stall and subsequent impact with terrain.
- [NTSB ERA16LA148](https://openairdocs.org/ntsb/ERA16LA148.md): Flight Design Ctsw · Hilton Head Island, SC · Accident · No injuries · Limited investigation · Final report · Apr 6, 2016 · N466CT · Substantial damage
  > The pilot's failure to apply carburetor heat following a loss of engine power due to carburetor icing.
- [NTSB ERA15LA174](https://openairdocs.org/ntsb/ERA15LA174.md): G-Dawg Just Acft Highlander · Walhalla, SC · Accident · Serious injuries · Limited investigation · Final report · Mar 31, 2015 · N376CG · Substantial damage
  > The pilot's failure to maintain airplane control during a go-around in gusting tailwind conditions, which resulted in a collision with trees.
- [NTSB ERA15CA065](https://openairdocs.org/ntsb/ERA15CA065.md): Socata TB 20 Trinidad · Hilton Head Island, SC · Accident · No injuries · Data collection · Final report · Nov 26, 2014 · N85AV · Substantial damage
  > The pilot's inadvertent selection of an incorrect frequency, which resulted in his inability to activate the airport lighting, and his subsequent decision to continue the approach in dark night conditions despite having not positively identified the runway…
- [NTSB ERA14CA210](https://openairdocs.org/ntsb/ERA14CA210.md): Jerome A Baak CH 601XL · Sumter, SC · Accident · Minor injuries · Data collection · Final report · Apr 27, 2014 · N121JN · Substantial damage
  > The total loss of engine power due to fuel exhaustion. Contributing to the fuel exhaustion was the pilot's failure during the building process to properly determine the unusable quantity of fuel.
- [NTSB ERA14LA059](https://openairdocs.org/ntsb/ERA14LA059.md): Moffitt Oscar/ Kit Prostar A/C PT2 · Trenton, SC · Accident · Minor injuries · Limited investigation · Final report · Dec 2, 2013 · N355PT · Substantial damage
  > The airplane owner/pilot ‘s failure to follow the gascolator manufacturer’s recommendations for installing and safety wiring the gascolator strainer bowl, which resulted in the bowl separating and a total loss of engine power due to fuel starvation.
- [NTSB ERA13FA348](https://openairdocs.org/ntsb/ERA13FA348.md): Beech D55 · Conway, SC · Accident · 3 fatal · Field investigation · Final report · Aug 3, 2013 · N7641N · Destroyed
  > The pilot's loss of airplane control, which resulted from his failure to follow the loss of single engine power checklist procedures after a total loss of right engine power due to fuel starvation. Contributing to the accident was the pilot's improper…
- [NTSB ERA13CA255](https://openairdocs.org/ntsb/ERA13CA255.md): Flightstar Sportplanes Flightstar II · York, SC · Accident · Minor injuries · Data collection · Final report · May 25, 2013 · N677NC · Substantial damage
  > The pilot’s failure to maintain aircraft control while landing in gusty wind conditions.
- [NTSB ERA13CA208](https://openairdocs.org/ntsb/ERA13CA208.md): Cessna 140 · Lancaster, SC · Accident · No injuries · Data collection · Final report · Apr 18, 2013 · N76688 · Substantial damage
  > The pilot’s decision to land with a tailwind and his failure to turn off the carburetor heat during a go-around, which resulted in degraded engine performance and the airplane’s subsequent collision with trees at the end of the runway.
- [NTSB ERA13CA161](https://openairdocs.org/ntsb/ERA13CA161.md): Rainbow Aircraft PTY Cobra · Camden, SC · Accident · Minor injuries · Data collection · Final report · Mar 9, 2013 · N78DK · Substantial damage
  > The pilot's failure to maintain airplane control during the approach to land.
- [NTSB ERA12CA333](https://openairdocs.org/ntsb/ERA12CA333.md): Luttenbacher Kurt Bushby Mustang 2 · Kingstree, SC · Accident · Minor injuries · Data collection · Final report · May 12, 2012 · N58RS · Substantial damage
  > The pilot’s failure to maintain airplane control during the approach to landing, which resulted in a collision with terrain short of the runway. Contributing to the accident was the pilot's lack of experience in the airplane.
- [NTSB ERA11FA118](https://openairdocs.org/ntsb/ERA11FA118.md): Cessna 172S · North Myrtle Beach, SC · Accident · 2 fatal · Field investigation · Final report · Jan 18, 2011 · N2100V · Substantial damage
  > The pilot's loss of airplane control during a missed approach due to spatial disorientation.
- [NTSB ERA10LA365](https://openairdocs.org/ntsb/ERA10LA365.md): Texas Air Ventures Comp AIR 8 · Mount Pleasant, SC · Accident · 1 fatal · Limited investigation · Final report · Jul 19, 2010 · N882X · Substantial damage
  > The pilot's failure to retrim the airplane and maintain aircraft control during an aborted landing, which resulted in an inadvertent stall. Contributing to the accident was the pilot's lack of experience in the accident airplane make and model.
- [NTSB ERA10CA300](https://openairdocs.org/ntsb/ERA10CA300.md): Piper PA-18-135 · North Myrtle Beach, SC · Accident · Minor injuries · Data collection · Final report · Jun 6, 2010 · N2150A · Substantial damage
  > The pilot’s failure to maintain adequate airspeed during a climbing turn, which resulted in an aerodynamic stall.
- [NTSB ERA10LA199](https://openairdocs.org/ntsb/ERA10LA199.md): Ratcliffe John A Kolb MARK3X · Charleston, SC · Accident · 1 fatal · Limited investigation · Final report · Apr 1, 2010 · N3181L · Substantial damage
  > The pilot's failure to maintain adequate airspeed which resulted in an aerodynamic stall and subsequent loss of control. Contributing to the accident was the pilot's lack of experience in the make and model airplane.
- [NTSB ERA10LA056](https://openairdocs.org/ntsb/ERA10LA056.md): Hawker Beechcraft B200 · Greer, SC · Accident · Serious injuries · Limited investigation · Final report · Nov 9, 2009 · N337MT · Substantial damage
  > A loss of engine power due to fuel exhaustion as a result of the pilot’s failure to visually verify that sufficient fuel was onboard prior to flight.
- [NTSB ERA09LA501](https://openairdocs.org/ntsb/ERA09LA501.md): Keithley Thomas E Starduster Too · St. Matthews, SC · Accident · 2 fatal · Limited investigation · Final report · Sep 7, 2009 · N26TK · Substantial damage
  > A loss of airplane control during approach for undetermined reasons.
- [NTSB ERA09LA378](https://openairdocs.org/ntsb/ERA09LA378.md): Eurocopter AS 350 B2 · Loris, SC · Accident · No injuries · Limited investigation · Final report · Jul 3, 2009 · N53963 · Substantial damage
  > The crew's failure to see and avoid a steel pole during a nighttime approach to the helipad.
- [NTSB ERA09IA315](https://openairdocs.org/ntsb/ERA09IA315.md): Cirrus Design SR22 · Greenville, SC · Incident · No injuries · Incident investigation · Final report · Jun 1, 2009 · N695CD · No damage
  > A pitch control malfunction for undetermined reasons.
- [NTSB ERA09FA148](https://openairdocs.org/ntsb/ERA09FA148.md): Cirrus Design SR22 · Moncks Corner, SC · Accident · 1 fatal · Field investigation · Final report · Jan 29, 2009 · N224SB · Substantial damage
  > A loss of aircraft control during the landing approach for undetermined reasons.
- [NTSB LAX08CA219](https://openairdocs.org/ntsb/LAX08CA219.md): Tallent, Chris M. Putts Special · Sumter, SC · Accident · No injuries · Data collection · Final report · Jul 7, 2008 · N1959C · Substantial damage
  > the pilot's failure to maintain the proper glideslope and clearance from obstacles. Contributing to the accident was the pilot's limited experience in the airplane type.
- [NTSB CHI08LA125](https://openairdocs.org/ntsb/CHI08LA125.md): Rans S-12 XL · Pelion, SC · Accident · Serious injuries · Limited investigation · Final report · May 4, 2008 · N9148Y · Substantial damage
  > A loss of engine power due to the improper actions of the instructor pilot and the low experience level of the instructor pilot in this make and model of aircraft.
- [NTSB NYC08LA061](https://openairdocs.org/ntsb/NYC08LA061.md): Cessna 310J · Hilton Head Island, SC · Accident · No injuries · Limited investigation · Final report · Dec 13, 2007 · N310RV · Substantial damage
  > The pilot's failure to maintain aircraft control during a go-around.
- [NTSB NYC07CA218](https://openairdocs.org/ntsb/NYC07CA218.md): Piper PA-28-181 · N Myrtle Beach, SC · Accident · No injuries · Data collection · Final report · Sep 7, 2007 · N3063Y · Substantial damage
  > The pilot's failure to maintain aircraft control during a go-around, which resulted in a collision with water. A factor in this accident was the crosswind conditions.
- [NTSB SEA07LA190](https://openairdocs.org/ntsb/SEA07LA190.md): Champion 7KCAB · Orangeburg, SC · Accident · Serious injuries · Limited investigation · Final report · Jun 29, 2007 · N827BM · Substantial damage
  > The pilot's failure to maintain airspeed during go-around which resulted in a stall. The tailwind was a factor.
- [NTSB ATL07FA031](https://openairdocs.org/ntsb/ATL07FA031.md): Cessna 182P · Columbia, SC · Accident · 3 fatal · Field investigation · Final report · Jan 5, 2007 · N55YS · Destroyed
  > The pilot's failure to follow approach procedures by descending below the prescribed descision height altitude resulting in an in-flight collision with trees and the ground. This report was modified on January 25, 2008.
- [NTSB ATL07FA029](https://openairdocs.org/ntsb/ATL07FA029.md): Cessna 340A · Charleston, SC · Accident · 4 fatal · Field investigation · Final report · Dec 22, 2006 · N808RA · Substantial damage
  > The pilot's failure to maintain airspeed during a turn from base to final, resulting in an inadvertent stall/spin. Contributing to the accident was the impairment of the pilot due to the combination of drugs found in his toxicological report.
- [NTSB DEN06CA125](https://openairdocs.org/ntsb/DEN06CA125.md): Thomas Velocity · Conway, SC · Accident · Minor injuries · Data collection · Final report · Sep 9, 2006 · N31756 · Destroyed
  > the loss of engine power due to fuel starvation. The cause of the fuel starvation was not determined. Contributing to the accident was the lack of suitable terrain for a forced landing.
- [NTSB ATL06FA122](https://openairdocs.org/ntsb/ATL06FA122.md): Piper PA-32RT-300 · Hartsville, SC · Accident · 2 fatal · Field investigation · Final report · Aug 18, 2006 · N31911 · Substantial damage
  > The pilot's loss of control of the airplane due to spatial disorientation.
- [NTSB ATL06LA086](https://openairdocs.org/ntsb/ATL06LA086.md): Cessna 150M · Bishopville, SC · Accident · No injuries · Limited investigation · Final report · May 27, 2006 · N66058 · Substantial damage
  > The loss of engine power for undetermined reasons during the approach to land, which resulted in an off-airport emergency landing.
- [NTSB ATL06CA055](https://openairdocs.org/ntsb/ATL06CA055.md): Urban Air UFM-10 · Lancaster, SC · Accident · No injuries · Data collection · Final report · Mar 19, 2006 · N107NK · Substantial damage
  > The pilot's excessive climb angle during a go-around from a bounced landing which resulted in an inadvertent stall and subsequent in-flight collision with trees.
- [NTSB ATL06FA044](https://openairdocs.org/ntsb/ATL06FA044.md): Beech 200 · N Myrtle Beach, SC · Accident · 6 fatal · Field investigation · Final report · Feb 4, 2006 · N266EB · Destroyed
  > The pilot's failure to maintain control during landing approach for undetermined reasons.
- [NTSB ATL06LA022](https://openairdocs.org/ntsb/ATL06LA022.md): Embraer EMB-110P1 · Orangeburg, SC · Accident · Serious injuries · Limited investigation · Final report · Dec 10, 2005 · N790RA · Substantial damage
  > The pilot's inadequate preflight inspection and her failure to refuel the airplane which resulted in total loss of engine power due to fuel exhaustion, and subsequent in-flight collision with trees.

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

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