# NTSB investigations, SC: Initial climb

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 4 · 193 cases

## Latest cases

- [NTSB WPR26FA160](https://openairdocs.org/ntsb/WPR26FA160.md): Mooney M20J · Union, SC · Accident · 4 fatal · Class 3 · Field · Preliminary report · Apr 17, 2026 · N1151H · Substantial damage
  > On April 17, 2026, about 1750 eastern daylight time, a Mooney M20J, N1151H, was destroyed when it was involved in an accident near Union, South Carolina. The pilot and 3 passengers were fatally injured. The airplane was operated as a Title 14 Code of Federal…
- [NTSB ERA26LA022](https://openairdocs.org/ntsb/ERA26LA022.md): Rans Employee Flying Club Rans S-6ES Coyote II · Williston, SC · Accident · No injuries · Class 4 · Limited · Final report · Oct 24, 2025 · N43822 · Substantial damage
  > The pilot’s failure to maintain directional control of the airplane during the initial climb in gusting crosswind conditions.
- [NTSB ERA25LA177](https://openairdocs.org/ntsb/ERA25LA177.md): Beech A24 · Greenville, SC · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Apr 17, 2025 · N8060R · Substantial damage
  > On April 17, 2025, about 1540 eastern daylight time, a Beech A24 airplane, N8060R, was substantially damaged when it was involved in an accident at the Greenville Downtown Airport (GMU), Greenville, South Carolina. The pilot sustained minor injuries. The…
- [NTSB ERA24LA388](https://openairdocs.org/ntsb/ERA24LA388.md): Cessna 172K · Spartanburg, SC · Accident · Minor injuries · Class 3 · Limited · Final report · Sep 20, 2024 · N7037G · Substantial damage
  > Maintenance personnel’s failure to follow the engine manufacturer’s maintenance guidance, which resulted in the assembly of the engine with an obstructed oil passage, a subsequent lack of lubrication to the front main bearing, and a total loss of engine power.
- [NTSB ERA23LA342](https://openairdocs.org/ntsb/ERA23LA342.md): Beech C23 · Greer, SC · Accident · 2 fatal · Class 3 · Limited · Final report · Aug 20, 2023 · N9360S · Substantial damage
  > A partial loss of engine power during the initial climb due to the formation of carburetor ice, resulting in reduced climb capability. Contributing to the accident was the pilot’s failure to maintain proper airspeed during the emergency descent, which…
- [NTSB ERA23LA329](https://openairdocs.org/ntsb/ERA23LA329.md): Eipper Formance Mxii · Holy Hill, SC · Accident · Serious injuries · Class 4 · Limited · Final report · Aug 9, 2023 · N1624Z · Substantial damage
  > The pilot’s exceedance of the critical angle of attack during the initial climb, which resulted in an aerodynamic stall at low altitude and a collision with a hangar. Contributing to the accident was the pilot’s lack of experience in the accident make and…
- [NTSB ERA23FA280](https://openairdocs.org/ntsb/ERA23FA280.md): Piper PA-32R-300 · North Myrtle Beach, SC · Accident · 5 fatal · Class 3 · Field · Final report · Jul 2, 2023 · N5524F · Destroyed
  > The pilot’s loss of control during initial climb, which resulted in an aerodynamic stall and impact with terrain. Contributing to the accident was the pilot’s operation of the airplane above its maximum gross weight and near its aft center of gravity limit,…
- [NTSB ERA23LA037](https://openairdocs.org/ntsb/ERA23LA037.md): Piper PA-28-235 · Spartanburg, SC · Accident · No injuries · Class 3 · Limited · Final report · Oct 23, 2022 · N8580N · Substantial damage
  > A partial separation of the crankshaft gear/bolt, which resulted in a total loss of engine power.
- [NTSB CEN22FA419](https://openairdocs.org/ntsb/CEN22FA419.md): Piper PA-28R-201 · Conway, SC · Accident · 2 fatal · Class 3 · Field · Final report · Sep 14, 2022 · N62FC · Destroyed
  > The mechanic’s failure to install the required gasket on the vacuum pump drive pad in accordance with the maintenance manual, which resulted in oil exhaustion and the subsequent loss of engine power. Contributing to the accident was the Director of…
- [NTSB ERA22LA216](https://openairdocs.org/ntsb/ERA22LA216.md): Grumman AA1 · Seneca, SC · Accident · Serious injuries · Class 3 · Limited · Final report · May 2, 2022 · N15LM · Substantial damage
  > A dislodged air filter element, which restricted airflow to the carburetor resulting in a loss of engine power.
- [NTSB ERA22LA168](https://openairdocs.org/ntsb/ERA22LA168.md): Robinson Helicopter R44 · Myrtle Beach, SC · Accident · No injuries · Class 3 · Limited · Final report · Mar 26, 2022 · N288L · Substantial damage
  > Vibration in the airframe and flight controls for reasons that could not be determined based on the available evidence.
- [NTSB ERA22LA155](https://openairdocs.org/ntsb/ERA22LA155.md): Aircraft Designs Stallion · Ridgeland, SC · Accident · No injuries · Class 3 · Limited · Final report · Mar 13, 2022 · N262KT · Substantial damage
  > A loss of sufficient electrical power to the engine’s electronic fuel injection/ignition system for undetermined reasons, which resulted in a total loss of engine power.
- [NTSB ERA22LA136](https://openairdocs.org/ntsb/ERA22LA136.md): Flightstar Flightstar II · Holly Hill, SC · Accident · Serious injuries · Class 3 · Limited · Final report · Feb 24, 2022 · N194PG · Substantial damage
  > A loss of control during takeoff for reasons that could not be determined based on the available information, which resulted in a collision with a hangar and trees.
- [NTSB ERA20LA286](https://openairdocs.org/ntsb/ERA20LA286.md): Just JA 30 Superstol · Clover, SC · Accident · Minor injuries · Class 3 · Limited · Final report · Aug 15, 2020 · N146BB · Substantial damage
  > The separation of a spark plug lead, resulting in a partial loss of engine power and collision with trees.
- [NTSB ERA20LA150](https://openairdocs.org/ntsb/ERA20LA150.md): Arion Lightning LS-1 · Mount Pleasant, SC · Accident · 2 fatal · Class 3 · Limited · Final report · Apr 10, 2020 · N81DJ · Destroyed
  > The pilot's failure to maintain clearance from trees at the end of the runway due to spatial disorientation during initial climb in dark night conditions. Also causal was the flight instructor’s inadequate monitoring, which did not identify and prevent the…
- [NTSB ERA19LA226](https://openairdocs.org/ntsb/ERA19LA226.md): Cessna 120 · Summit, SC · Accident · No injuries · Class 3 · Limited · Final report · Jul 13, 2019 · N3886V · Substantial damage
  > A total loss of engine power during initial climb due to carburetor ice formation.
- [NTSB GAA19CA429](https://openairdocs.org/ntsb/GAA19CA429.md): Flightstar Sportplanes Flightstar II · Coward, SC · Accident · Minor injuries · Data collection · Final report · Jun 28, 2019 · UNREG · Substantial damage
  > The noncertificated pilot's exceedance of the airplane's critical angle of attack during the initial climb, which resulted in an aerodynamic stall.
- [NTSB ERA17LA334](https://openairdocs.org/ntsb/ERA17LA334.md): Mcmillan Joel L Avid SW 65 · Darlington, SC · Accident · Serious injuries · Limited investigation · Final report · Sep 24, 2017 · N65SW · Substantial damage
  > A total loss of engine power due to fuel starvation as a result of a clogged fuel filter.
- [NTSB ERA17LA175](https://openairdocs.org/ntsb/ERA17LA175.md): Mooney M20R · Myrtle Beach, SC · Accident · No injuries · Limited investigation · Final report · May 9, 2017 · N20835 · Substantial damage
  > A total loss of engine power during initial climb for reasons that could not be determined because the airplane sank in the ocean and was not recovered.
- [NTSB ERA16LA135](https://openairdocs.org/ntsb/ERA16LA135.md): Cessna 210L · Myrtle Beach, SC · Accident · No injuries · Limited investigation · Final report · Mar 19, 2016 · N59196 · Substantial damage
  > A complete loss of electrical power, which resulted from the separation of an alternator wire due to corrosion. Contributing to the accident was the failure of the emergency landing gear extension system due to a lack of hydraulic fluid, which resulted in…
- [NTSB ERA15FA221](https://openairdocs.org/ntsb/ERA15FA221.md): BR Legend Turbine Legend · West Columbia, SC · Accident · 1 fatal · Field investigation · Final report · May 23, 2015 · N42BR · Destroyed
  > An engine flame-out due to fuel starvation as the result of an improperly-installed auxiliary fuel pump fitting, and the pilot's failure to promptly feather the propeller following the engine-flame out, which resulted in decreased glide capability and impact…
- [NTSB ERA15LA219](https://openairdocs.org/ntsb/ERA15LA219.md): Rainbow Aerotrike · Chesnee, SC · Accident · 1 fatal · Limited investigation · Final report · Mar 9, 2015 · UNREG · Substantial damage
  > The pilot’s failure to maintain lateral or bank control during takeoff, which resulted in collision with, and subsequent suspension from, a tree. Contributing to the pilot’s fatal injuries was his attempt to jump out of the trike to a nearby tree limb.
- [NTSB ERA14FA387](https://openairdocs.org/ntsb/ERA14FA387.md): Cessna 150 · Mount Pleasant, SC · Accident · 2 fatal · Field investigation · Final report · Aug 14, 2014 · N66241 · Substantial damage
  > The commercial pilot’s exceedance of the airplane’s critical angle-of-attack during the initial climb, which resulted in an aerodynamic stall and impact with terrain. Contributing to the commercial pilot’s failure to recognize and remediate the stall were his…
- [NTSB ERA14FA289](https://openairdocs.org/ntsb/ERA14FA289.md): Meyer Clair O 2/3 P 51B/C Mustang · Marion, SC · Accident · 1 fatal · Field investigation · Final report · Jun 13, 2014 · N51BM · Substantial damage
  > The airplane's impact with terrain shortly after takeoff due to a physiological incapacitation of the pilot.
- [NTSB ERA14FA049](https://openairdocs.org/ntsb/ERA14FA049.md): Piper PA-23-160 · Graniteville, SC · Accident · 1 fatal · Field investigation · Final report · Nov 25, 2013 · N4016P · Substantial damage
  > The pilot's improper maintenance of the airplane's fuel system, which resulted a loss of power in the left engine due to fuel starvation. Also causal was the pilot's failure to maintain minimum controllable airspeed following the loss of engine power, which…
- [NTSB ERA13LA264](https://openairdocs.org/ntsb/ERA13LA264.md): Globe GC-1B · Williamson, SC · Accident · Serious injuries · Limited investigation · Final report · Jun 1, 2013 · N3715K · Substantial damage
  > The pilot’s decision to takeoff with a quartering tailwind at high density altitude, close to gross takeoff weight, on a short turf runway with trees at the departure end.
- [NTSB ERA12LA260](https://openairdocs.org/ntsb/ERA12LA260.md): Hughes 369D · McCormick, SC · Accident · Minor injuries · Limited investigation · Final report · Mar 30, 2012 · N868W · Substantial damage
  > The pilot's decision to use automotive fuel instead of the approved alternate fuel, which resulted in a total loss of engine power.
- [NTSB ERA12FA051](https://openairdocs.org/ntsb/ERA12FA051.md): Cessna 150F · Moncks Corner, SC · Accident · 1 fatal · Field investigation · Final report · Oct 13, 2011 · N3086X · Substantial damage
  > The debilitating effects of ethylene glycol poisoning, which resulted in the pilot’s inability to maintain control of the airplane.
- [NTSB ERA11LA009](https://openairdocs.org/ntsb/ERA11LA009.md): Cessna 182P · Columbia, SC · Accident · Minor injuries · Limited investigation · Final report · Oct 5, 2010 · N21415 · Substantial damage
  > A total loss of engine power due to a loss of lubrication after the engine experienced a piston ring failure for undetermined reasons.
- [NTSB ERA10LA486](https://openairdocs.org/ntsb/ERA10LA486.md): Piper PA-28R-200 · Barnwell, SC · Accident · No injuries · Limited investigation · Final report · Sep 19, 2010 · N799SQ · Substantial damage
  > The failure of the No. 1 connecting rod end cap for undetermined reasons, which resulted in a total loss of engine power.
- [NTSB ERA10FA024](https://openairdocs.org/ntsb/ERA10FA024.md): Piper PA-23-250 · Summerville, SC · Accident · 4 fatal · Field investigation · Final report · Oct 21, 2009 · N62635 · Substantial damage
  > Flight into terrain for undetermined reasons.
- [NTSB ERA09LA544](https://openairdocs.org/ntsb/ERA09LA544.md): Celier Xenon RST · Mount Pleasant, SC · Accident · No injuries · Limited investigation · Final report · Sep 25, 2009 · N4462J · Substantial damage
  > The gyroplane's inadequate climb performance for undetermined reasons.
- [NTSB ERA09LA281](https://openairdocs.org/ntsb/ERA09LA281.md): Polaris Motors 582 FIB · Lexington, SC · Accident · Serious injuries · Limited investigation · Final report · May 4, 2009 · N171MB · Substantial damage
  > The non-certificated pilot's failure to maintain airspeed during initial climb, which resulted in an aerodynamic stall. Contributing to the accident was the non-certificated pilot’s lack of experience in the make and model airplane.
- [NTSB CHI08LA162](https://openairdocs.org/ntsb/CHI08LA162.md): Cessna 150L · Summerville, SC · Accident · No injuries · Limited investigation · Final report · Jun 13, 2008 · N5471Q · Substantial damage
  > A total loss of engine power for undetermined reasons.
- [NTSB MIA07CA144](https://openairdocs.org/ntsb/MIA07CA144.md): Cessna 177 · Columbia, SC · Accident · Minor injuries · Data collection · Final report · Sep 9, 2007 · N2353Y · Substantial damage
  > The loss of engine power as a result of the fuel mixture cable failure for undetermined reasons.
- [NTSB MIA07LA131](https://openairdocs.org/ntsb/MIA07LA131.md): MBB BK-117 A-4 · Ridgeville, SC · Accident · No injuries · Limited investigation · Final report · Aug 9, 2007 · N171MU · Substantial damage
  > The EMS helicopter pilot's failure to ensure adequate obstacle clearance which resulted in the tail rotor impacting a tree during the takeoff.
- [NTSB MIA07CA112](https://openairdocs.org/ntsb/MIA07CA112.md): Evektor-Aerotechnik Sportstar · Greenville, SC · Accident · No injuries · Data collection · Final report · Jun 27, 2007 · N812EV · Substantial damage
  > The pilot's inadvertent use of the wrong rudder during initial climb which resulted in a loss of control and collision with the ground.
- [NTSB ATL06LA060](https://openairdocs.org/ntsb/ATL06LA060.md): Just Highlander · Walhalla, SC · Accident · Serious injuries · Limited investigation · Final report · Apr 2, 2006 · N9085N · Substantial damage
  > The pilot and owner/builders failure to determine the reason for partial loss of engine power resulting in loss of engine power due to fuel system contamination on a subsequent flight.
- [NTSB ATL05FA043](https://openairdocs.org/ntsb/ATL05FA043.md): Piper PA-30 · Charleston, SC · Accident · 1 fatal · Field investigation · Final report · Jan 11, 2005 · N7654Y · Substantial damage
  > The pilot's inadequate preflight and mismanagement of the fuel supply, which resulted in fuel exhaustion.
- [NTSB CHI04MA182](https://openairdocs.org/ntsb/CHI04MA182.md): Bell 407 · Newberry, SC · Accident · 4 fatal · Major investigation · Final report · Jul 13, 2004 · N503MT · Destroyed
  > The pilot's failure to maintain terrain clearance as a result of fog conditions. A contributing factor was inadequate weather and dispatch information relayed to the pilot.
- [NTSB ATL04FA096](https://openairdocs.org/ntsb/ATL04FA096.md): Cirrus Design SR20 · Greenwood, SC · Accident · 4 fatal · Field investigation · Final report · Apr 19, 2004 · N8157J · Destroyed
  > The pilot's failure to maintain airspeed during initial climb that resulted in an inadvertent stall and the subsequent collision with trees. A factor was the inadequate preflight planning/preparation when he failed to lower the wing flaps.
- [NTSB ATL04FA090](https://openairdocs.org/ntsb/ATL04FA090.md): Smith Aerostar 601P · Johns Island, SC · Accident · 2 fatal · Field investigation · Final report · Apr 5, 2004 · N869CC · Substantial damage
  > The pilot's failure to maintain airspeed during emergency descent, which resulted in an inadvertent stall/spin and uncontrolled descent into trees and terrain. A factor was the loss of engine power in one engine due to pre-ignition/detonation.
- [NTSB ATL03FA133](https://openairdocs.org/ntsb/ATL03FA133.md): Piper PA-46-310P · Hilton Head Is, SC · Accident · 2 fatal · Field investigation · Final report · Aug 31, 2003 · N70DL · Destroyed
  > The pilot's failure to maintain control of the airplane during a VFR pattern for a precautionary landing, which resulted in an uncontrolled descent and subsequent collision with terrain. Also causal was the pilot's inadequate preflight inspection of the…
- [NTSB ATL03TA078](https://openairdocs.org/ntsb/ATL03TA078.md): Aero Commander 500S · Mount Pleasant, SC · Accident · Serious injuries · Final report · Apr 14, 2003 · N19WL · Destroyed
  > The improper refueling of the airplane by airport personnel with the incorrect fuel grade that resulted in a total loss in engine power on both engines during initial climb. A factor was the inadequate preflight inspection by the pilot in command.
- [NTSB ATL03LA066](https://openairdocs.org/ntsb/ATL03LA066.md): Daigneault EAA BI-PLANE · Easley, SC · Accident · Serious injuries · Limited investigation · Final report · Mar 23, 2003 · N22PJ · Substantial damage
  > The pilots failure to maintain clearance while maneuvering on initial climb out resulting in an in-flight collision with a residence.
- [NTSB MIA03LA049](https://openairdocs.org/ntsb/MIA03LA049.md): Mooney M20K · Myrtle Beach, SC · Accident · Minor injuries · Limited investigation · Final report · Jan 28, 2003 · N231NT · Substantial damage
  > A loss of engine power for undetermined reasons.
- [NTSB ATL02FA150](https://openairdocs.org/ntsb/ATL02FA150.md): Piper PA-28-140 · Spartanburg, SC · Accident · 2 fatal · Field investigation · Final report · Aug 3, 2002 · N7362J · Destroyed
  > The pilot's failure to maintain airspeed during the takeoff initial climb which resulted in an inadvertent stall and subsequent collision with an embankment.
- [NTSB MIA02LA064](https://openairdocs.org/ntsb/MIA02LA064.md): Cessna 172 · Marion, SC · Accident · Minor injuries · Limited investigation · Final report · Feb 28, 2002 · N1915V · Substantial damage
  > The loss of engine power during takeoff/initial climb due to undetermined reasons, resulting in a landing on unsuitable terrain.
- [NTSB MIA02LA006](https://openairdocs.org/ntsb/MIA02LA006.md): Cessna 170 · Bennettsville, SC · Accident · No injuries · Limited investigation · Final report · Oct 5, 2001 · N4180V · Substantial damage
  > The blockage of the fuel vent and also the collapsed fuel supply line resulting in the total loss of engine power due to fuel starvation.
- [NTSB MIA01FA192](https://openairdocs.org/ntsb/MIA01FA192.md): Beech BE-35-F35 · Bamberg, SC · Accident · 1 fatal · Field investigation · Final report · Jul 21, 2001 · N5058S · Destroyed
  > the failure of the pilot to maintain airspeed, while attempting a forced landing following a loss of engine power for undetermined reasons, which resulted in an inadvertent stall/spin, and subsequent impact with the terrain. A factor in this accident was…

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

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