# NTSB investigations, SC: Enroute

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 9 · 440 cases

## Latest cases

- [NTSB ERA26LA295](https://openairdocs.org/ntsb/ERA26LA295.md): Mooney M20E · Conway, SC · Accident · No injuries · Class 3 · Limited · Preliminary report · Aug 9, 2026 · N9257V · Substantial damage
  > On August 9, 2026 at 802 eastern daylight time, a Mooney M20E, N9257V, was substantially damaged when it was involved in an accident near Conway, South Carolina. The pilot was uninjured. The airplane was operated as a Title 14 Code of Federal Regulations Part…
- [NTSB CEN26FA241](https://openairdocs.org/ntsb/CEN26FA241.md): Beech 95-A55 · Lancaster, SC · Accident · Serious injuries · Class 3 · Field · Preliminary report · Jul 2, 2026 · N7501S · Substantial damage
  > On July 2, 2026, at 0052 eastern daylight time (EDT), a Beech model 95-A55 airplane, N7501S, was destroyed when it was involved in an accident near Lancaster, South Carolina. Both pilots received serious injuries. The accident flight was operated as a Title…
- [NTSB ERA26LA199](https://openairdocs.org/ntsb/ERA26LA199.md): Alexander Schleicher ASW 27-18 · Greenwood, SC · Accident · No injuries · Class 4 · Limited · Final report · Apr 20, 2026 · N27CU · Substantial damage
  > The glider pilot’s encounter with a strong sink/loss of lift, which resulted in a forced landing to unsuitable terrain.
- [NTSB ERA26LA155](https://openairdocs.org/ntsb/ERA26LA155.md): Piper PA-28-180 · Greenville, SC · Accident · No injuries · Class 4 · Limited · Final report · Mar 29, 2026 · N2333R · Substantial damage
  > An in-flight collision with a bird during cruise flight.
- [NTSB ERA26LA145](https://openairdocs.org/ntsb/ERA26LA145.md): Rockwell International 114 · Whitmire, SC · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Mar 10, 2026 · N4832W · Substantial damage
  > On March 10, 2026, about 1915 eastern daylight time, a Rockwell International 114 airplane, N4832W, was substantially damaged when it was involved in an accident near Whitmire, South Carolina. The flight instructor received minor injuries. The pilot receiving…
- [NTSB ERA26FA106](https://openairdocs.org/ntsb/ERA26FA106.md): Cirrus Design SR22 · Lexington, SC · Accident · 1 fatal · Class 3 · Field · Preliminary report · Feb 6, 2026 · N705CD · Substantial damage
  > On February 6, 2026, at 0921 eastern standard time, a Cirrus Design Corp SR22, N705CD, was substantially damaged when it was involved in an accident near Lexington, South Carolina. The commercial pilot sustained serious injuries and the passenger was fatally…
- [NTSB ERA26LA052](https://openairdocs.org/ntsb/ERA26LA052.md): Toomey Long EZ · Beaufort, SC · Accident · No injuries · Class 3 · Limited · Preliminary report · Nov 19, 2025 · N82MT · Substantial damage
  > On November 19, 2025, about 1630 eastern standard time, an experimental, amateur-built Long EZ, N82MT, was substantially damaged when it was involved in an accident near Beaufort, South Carolina. The private pilot was not injured. The airplane was operated as…
- [NTSB ERA25LA270](https://openairdocs.org/ntsb/ERA25LA270.md): Piper PA46 · Sunset, SC · Accident · No injuries · Class 3 · Limited · Preliminary report · Jul 17, 2025 · N460WW · Substantial damage
  > On July 17, 2025, about 1122 eastern daylight time, a Piper PA-46-310P, N460WW, was substantially damaged when it was involved in an accident near Sunset, South Carolina. The commercial pilot was not injured. The airplane was operated as a Title 14 Code of…
- [NTSB ERA25LA214](https://openairdocs.org/ntsb/ERA25LA214.md): Jernigan Zenith 750 · Greenville, SC · Accident · No injuries · Class 3 · Limited · Preliminary report · May 18, 2025 · N864AJ · Substantial damage
  > On May 18, 2025, about 1416 eastern daylight time, an experimental, amateur-built Zenith 750, N864AJ, was substantially damaged when it was involved in an accident near Greenville, South Carolina. The private pilot was not injured. The airplane was operated…
- [NTSB ERA25LA162](https://openairdocs.org/ntsb/ERA25LA162.md): Ruys Nicholas G RV-8 · Bennettsville, SC · Accident · Serious injuries · Class 4 · Limited · Final report · Mar 28, 2025 · N8EV · Substantial damage
  > The pilot's inadequate preflight inspection, which resulted in a total loss of engine power due to fuel exhaustion and a subsequent forced landing.
- [NTSB ERA24LA273](https://openairdocs.org/ntsb/ERA24LA273.md): Construzioni Aeronautiche Tecn P2004 Bravo · Laurens, SC · Accident · No injuries · Class 4 · Limited · Final report · Jun 23, 2024 · N60DF · Substantial damage
  > An in-flight collision with a bird while in cruise flight.
- [NTSB ERA24LA080](https://openairdocs.org/ntsb/ERA24LA080.md): Piper PA-28R-201 · Wiggins, SC · Accident · Serious injuries · Class 3 · Limited · Final report · Jan 2, 2024 · N125MT · Substantial damage
  > A total loss of engine power for reasons that could not be determined.
- [NTSB ERA23LA336](https://openairdocs.org/ntsb/ERA23LA336.md): Cessna 182P · North Myrtle Beach, SC · Accident · No injuries · Class 4 · Limited · Final report · Aug 13, 2023 · N22RE · Substantial damage
  > The pilot’s failure to properly secure the left wing fuel cap, which resulted in a loss of engine power due to fuel exhaustion.
- [NTSB ERA23LA356](https://openairdocs.org/ntsb/ERA23LA356.md): Piper PA-12 · Myrtle Beach, SC · Accident · Minor injuries · Class 3 · Limited · Final report · Jul 31, 2023 · N3036M · Substantial damage
  > The pilot’s inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB ERA23FA265](https://openairdocs.org/ntsb/ERA23FA265.md): Beech B35 · Orangeburg, SC · Accident · 1 fatal · Class 3 · Field · Final report · Jun 10, 2023 · N8725A · Destroyed
  > A stuck No. 3 cylinder intake valve, which resulted in a partial loss of engine power and subsequent forced landing.
- [NTSB ERA23LA221](https://openairdocs.org/ntsb/ERA23LA221.md): Aeronca 7DC-CONV · Fort Mill, SC · Accident · No injuries · Class 3 · Limited · Final report · May 5, 2023 · N3058E · Substantial damage
  > The pilot’s failure to apply carburetor heat before initiating a descent in conditions conducive to the development of carburetor icing, which resulted in a partial loss of engine power due to carburetor ice.
- [NTSB ERA23FA164](https://openairdocs.org/ntsb/ERA23FA164.md): Piper PA-28-161 · Johns Island, SC · Accident · 1 fatal · Class 3 · Field · Final report · Mar 25, 2023 · N21480 · Substantial damage
  > The pilot’s decision to continue flight under visual flight rules into instrument meteorological conditions, which resulted in the pilot’s spatial disorientation and loss of control. Contributing to the accident was the pilot’s degraded judgement and…
- [NTSB ERA23LA162](https://openairdocs.org/ntsb/ERA23LA162.md): Cessna 177 · Travelers Rest, SC · Accident · No injuries · Class 3 · Limited · Final report · Mar 23, 2023 · N13612 · Substantial damage
  > Maintenance personnel’s improper servicing of the magneto, which resulted in its accelerated wear, failure, and the total loss of engine power.
- [NTSB ERA22LA346](https://openairdocs.org/ntsb/ERA22LA346.md): Textron G36 · Ridgeland, SC · Accident · Serious injuries · Class 3 · Limited · Final report · Jul 30, 2022 · N887MJ · Substantial damage
  > A loss of engine power for reasons that could not be determined.
- [NTSB ERA22LA333](https://openairdocs.org/ntsb/ERA22LA333.md): Stinson 108 · Batesburg, SC · Accident · No injuries · Class 3 · Limited · Final report · Jul 23, 2022 · N6020M · Substantial damage
  > The fatigue failure of the crankshaft gear, resulting in a total loss of engine power.
- [NTSB ERA22LA109](https://openairdocs.org/ntsb/ERA22LA109.md): Cirrus Design SR22 · Lexington, SC · Accident · No injuries · Class 3 · Limited · Final report · Jan 13, 2022 · N879CD · Substantial damage
  > A loss of engine power due to a shift of the No. 3 main journal bearing, which resulted in blocked oil ports that restricted oil to the engine’s internal components and a subsequent catastrophic engine failure.
- [NTSB ERA22LA104](https://openairdocs.org/ntsb/ERA22LA104.md): Piper PA-32-300 · Edisto Island, SC · Accident · No injuries · Class 3 · Limited · Final report · Jan 11, 2022 · N475RT · Substantial damage
  > A loss of engine power due to the fatigue failure of the crankshaft counterweight retaining ring and the No. 6 connecting rod.
- [NTSB ERA22FA047](https://openairdocs.org/ntsb/ERA22FA047.md): Piper PA30 · Rock Hill, SC · Accident · 1 fatal · Class 3 · Field · Final report · Nov 5, 2021 · N8924Y · Substantial damage
  > The pilot’s exceedance of the airplane's critical angle of attack while troubleshooting a landing gear indication, which resulted in an aerodynamic stall at low altitude.
- [NTSB ERA22FA026](https://openairdocs.org/ntsb/ERA22FA026.md): Piper PA-32R-300 · Walterboro, SC · Accident · 1 fatal · Class 3 · Field · Final report · Oct 22, 2021 · N1652H · Destroyed
  > The pilot’s inadequate fuel planning and fuel management, which resulted in a loss of engine power due to fuel starvation.
- [NTSB ERA22LA011](https://openairdocs.org/ntsb/ERA22LA011.md): Flight Design Ctls · Greenville, SC · Accident · Minor injuries · Class 3 · Limited · Final report · Oct 10, 2021 · N121YT · Substantial damage
  > A total loss of engine power resulting from the in-flight disconnection of oil hoses from the oil thermostat.
- [NTSB ERA21LA379](https://openairdocs.org/ntsb/ERA21LA379.md): Hawker Beechcraft 400A · Charleston, SC · Accident · No injuries · Class 3 · Limited · Final report · Sep 14, 2021 · N100FN · Substantial damage
  > The in-flight separation of the left engine’s four-panel cowling for reasons that could not be determined based on the available evidence.
- [NTSB ERA21LA125](https://openairdocs.org/ntsb/ERA21LA125.md): Taylorcraft BC-65 · Columbia, SC · Accident · Minor injuries · Class 3 · Limited · Final report · Feb 7, 2021 · N24476 · Substantial damage
  > A total loss of engine power due to carburetor icing, which resulted from the student pilot’s failure to use carburetor heat.
- [NTSB ERA21LA115](https://openairdocs.org/ntsb/ERA21LA115.md): Beech 300 · Myrtle Beach, SC · Accident · Serious injuries · Class 4 · Limited · Final report · Jan 14, 2021 · N862UP · No damage
  > An encounter with severe turbulence, which resulted in serious injury to an unseated passenger.
- [NTSB ERA21LA031](https://openairdocs.org/ntsb/ERA21LA031.md): Sparrowhawk II · North Myrtle Beach, SC · Accident · No injuries · Class 4 · Limited · Final report · Oct 7, 2020 · N40380 · Substantial damage
  > A ruptured fuel line, which resulted in fuel starvation to the engine and a total loss of engine power.
- [NTSB ERA21LA002](https://openairdocs.org/ntsb/ERA21LA002.md): Beech BE-36 · Green Sea, SC · Accident · Minor injuries · Class 3 · Limited · Final report · Oct 2, 2020 · N656V · Substantial damage
  > The pilot’s inadvertent placement of the fuel selector in an intermediate position, which starved the engine of fuel and resulted in a total loss of engine power.
- [NTSB ERA20LA326](https://openairdocs.org/ntsb/ERA20LA326.md): Stearman E75 · Honea Path, SC · Accident · Serious injuries · Class 3 · Limited · Final report · Sep 21, 2020 · N1524M · Destroyed
  > The partial loss of engine power due to the fatigue failure of an engine cylinder and the pilot’s subsequent decision to overfly several suitable forced-landing sites while attempting to return to the departure airstrip.
- [NTSB ERA20LA132](https://openairdocs.org/ntsb/ERA20LA132.md): Cessna 310 · Charleston, SC · Accident · 1 fatal · Class 3 · Limited · Final report · Mar 21, 2020 · N8080M · Substantial damage
  > The pilot’s fuel mismanagement during flight, resulting in a total loss of engine power due to fuel starvation.
- [NTSB GAA20CA001](https://openairdocs.org/ntsb/GAA20CA001.md): Taylorcraft BC12 · Longs, SC · Accident · No injuries · Data collection · Final report · Oct 1, 2019 · N95131 · Substantial damage
  > The pilot's improper fuel planning, which resulted in fuel exhaustion, a total loss of engine power, an off-airport landing, and impact with trees.
- [NTSB ERA19LA143](https://openairdocs.org/ntsb/ERA19LA143.md): Cessna 175 · Edgefield, SC · Accident · No injuries · Class 3 · Limited · Final report · Apr 4, 2019 · N7622M · Substantial damage
  > The total loss of engine power due to a stuck engine exhaust valve. Contributing to the loss of engine power was the pilot’s failure to properly address the recurring stuck exhaust valve issue.
- [NTSB ERA19LA074](https://openairdocs.org/ntsb/ERA19LA074.md): Diamond DA20 · McCormick, SC · Accident · Minor injuries · Class 3 · Limited · Final report · Dec 19, 2018 · N346MA · Substantial damage
  > A partial loss of engine power due to debris obstructing the metering plug orifice in the throttle and metering unit.
- [NTSB ERA19LA029](https://openairdocs.org/ntsb/ERA19LA029.md): Diamond DA20 · Mountain Rest, SC · Accident · No injuries · Limited investigation · Final report · Oct 28, 2018 · N653DC · Substantial damage
  > A partial loss of engine power due to multiple discrepancies of the engine's ignition system.
- [NTSB ERA18LA215](https://openairdocs.org/ntsb/ERA18LA215.md): Cessna R182 · Florence, SC · Accident · No injuries · Limited investigation · Final report · Aug 9, 2018 · N1693R · Substantial damage
  > The pilot's failure to comply with emergency procedures in the pilot's operating handbook, resulting in the collapse of the main landing gear during landing. Contributing to the accident was the pilot's failure to address the low battery voltage before…
- [NTSB ERA17LA257](https://openairdocs.org/ntsb/ERA17LA257.md): Robinson Helicopter R44 · Myrtle Beach, SC · Accident · No injuries · Limited investigation · Final report · Jul 24, 2017 · N828RD · Substantial damage
  > A loss of available power to the main rotor due to a fractured exhaust pushrod and housing, which allowed engine oil to coat the V-belts. Contributing to the accident was the pilot's decision to continue the tour and his failure to maintain adequate rotor rpm…
- [NTSB ERA16LA331](https://openairdocs.org/ntsb/ERA16LA331.md): Piper PA32RT · Camden, SC · Accident · Minor injuries · Limited investigation · Final report · Sep 30, 2016 · N39686 · Substantial damage
  > A total loss of engine power due to the improper torqueing of the magneto, which led it to its malfunctioning in flight.
- [NTSB GAA16CA302](https://openairdocs.org/ntsb/GAA16CA302.md): Piper PA 28 · Rowesville, SC · Accident · No injuries · Data collection · Final report · Jun 9, 2016 · N7355W · Substantial damage
  > The fuel line failure between the fuel transducer and the carburetor, which resulted in a total loss of engine power and subsequent forced off airport landing.
- [NTSB ERA16LA030](https://openairdocs.org/ntsb/ERA16LA030.md): Hughes 369D · Marion, SC · Accident · No injuries · Limited investigation · Final report · Oct 30, 2015 · N920JP · Substantial damage
  > A momentary jam in the tail rotor control system from an undetermined source, resulting in a torsional fracture of the tail rotor control torque tube and a loss of helicopter control.
- [NTSB ERA16LA018](https://openairdocs.org/ntsb/ERA16LA018.md): Cessna 172 · Campobello, SC · Accident · Minor injuries · Limited investigation · Final report · Oct 18, 2015 · N6636A · Substantial damage
  > The pilot's inadequate preflight inspection of the fuel system, which resulted in a total loss of engine power due to water contamination.
- [NTSB ERA15MA259](https://openairdocs.org/ntsb/ERA15MA259.md): Cessna 150M · Moncks Corner, SC · Accident · 2 fatal · Class 2 · Major · Final report · Jul 7, 2015 · N3601V · 2 aircraft · Destroyed
  > The approach controller's failure to provide an appropriate resolution to the conflict between the F-16 and the Cessna. Contributing to the accident were the inherent limitations of the see-and-avoid concept, resulting in both pilots' inability to take…
- [NTSB ERA15LA062](https://openairdocs.org/ntsb/ERA15LA062.md): Cirrus Design SR22T · Hampton, SC · Accident · Serious injuries · Limited investigation · Final report · Nov 28, 2014 · N227RR · Substantial damage
  > The pilot’s improper decision to descend the airplane at an airspeed greater than the published best glide speed following an erroneous oil pressure indication, which resulted in an off-airport landing. Contributing to the erroneous oil pressure indication…
- [NTSB ERA15CA048](https://openairdocs.org/ntsb/ERA15CA048.md): Cessna 177 · Landrum, SC · Accident · No injuries · Data collection · Final report · Nov 8, 2014 · N3339T · Substantial damage
  > The pilot's improper preflight planning, which resulted in a loss of engine power due to fuel exhaustion.
- [NTSB ERA14LA425](https://openairdocs.org/ntsb/ERA14LA425.md): Navion Navion · Rock Hill, SC · Accident · Minor injuries · Limited investigation · Final report · Sep 6, 2014 · N4900K · Substantial damage
  > The pilot’s improper fuel management, which resulted in the exhaustion of the fuel supply in the selected fuel tank and a subsequent total loss of engine power.
- [NTSB ERA14FA260](https://openairdocs.org/ntsb/ERA14FA260.md): Grumman American Avn. AA1B · Chester, SC · Accident · 2 fatal · Field investigation · Final report · May 23, 2014 · N8890L · Substantial damage
  > The pilot's inadequate inflight fuel monitoring, which resulted in fuel exhaustion and the subsequent total loss of engine power. Contributing to the accident was the loose fuel cap, which allowed fuel to syphon out in flight.
- [NTSB ERA14CA062](https://openairdocs.org/ntsb/ERA14CA062.md): Anderson Andreas Rans S-6S · Traveler's Rest, SC · Accident · Minor injuries · Data collection · Final report · Dec 3, 2013 · N581TC · Substantial damage
  > The pilot's decision to continue visual flight into deteriorating weather, which resulted in an encounter with instrument meteorological conditions and subsequent inability to maintain clearance with terrain.
- [NTSB ERA12LA498](https://openairdocs.org/ntsb/ERA12LA498.md): Embraer ERJ 170-200 LR · Hilton Head, SC · Accident · Serious injuries · Limited investigation · Final report · Aug 5, 2012 · N134HQ · No damage
  > The passenger’s failure to adhere to flight and cabin crewmembers’ instructions to remain seated in anticipation of adverse weather and turbulence along the airplane’s flight path.
- [NTSB ERA12LA473](https://openairdocs.org/ntsb/ERA12LA473.md): Cirrus Design SR-22 · Pickens, SC · Accident · No injuries · Limited investigation · Final report · Jul 22, 2012 · N138CK · Substantial damage
  > A total loss of engine power due to the failure of the crankshaft, which resulted from the application of insufficient torque on the cylinder through-bolts by maintenance personnel.

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

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