# NTSB investigations, SC: Physical

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.

## Latest cases

- [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 GAA19CA083](https://openairdocs.org/ntsb/GAA19CA083.md): Smith AEROSTAR601 · Rock Hill, SC · Accident · No injuries · Data collection · Final report · Nov 28, 2018 · N909CA · Substantial damage
  > The pilot's improper decision to fly with an air cast boot on his foot, which led him to rely on the passenger to apply brakes and rudder, which was performed improperly and led to a loss of directional control.
- [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 ERA16FA001](https://openairdocs.org/ntsb/ERA16FA001.md): Piper PA32R · Westminster, SC · Accident · 4 fatal · Field investigation · Final report · Oct 2, 2015 · N782TM · Destroyed
  > The pilot's loss of airplane control for reasons that could not be determined based on the available information.
- [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 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 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 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 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 ERA09LA019](https://openairdocs.org/ntsb/ERA09LA019.md): Hargett Sky Ranger II · Rock Hill, SC · Accident · 1 fatal · Limited investigation · Final report · Oct 16, 2008 · N75684 · Substantial damage
  > The non-certificated pilot's failure to maintain airspeed, which resulted in an inadvertent stall and a subsequent impact with the ground. Contributing to the accident were the pilot's lack of training and his impairment due to recent use of marijuana.

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '0201'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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