# Fatal NTSB investigations: Piper PA-28-180, SC

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 MIA02FA144](https://openairdocs.org/ntsb/MIA02FA144.md): Piper PA-28-180 · Cheraw, SC · Accident · 1 fatal · Field investigation · Final report · Aug 3, 2002 · N3450R · Substantial damage
  > The misrouting of the fuel lines to the fuel selector, which resulted in the use of a fuel tank with inadequate fuel supply, fuel starvation, and the loss of engine power. Contributing was the pilot's inadequate remedial action for conducting an emergency…
- [NTSB ATL85FA242](https://openairdocs.org/ntsb/ATL85FA242.md): Piper PA-28-180 · Abbeville, SC · Accident · 1 fatal · Field investigation · Final report · Aug 9, 1985 · N7475W · Destroyed
  > The acft crashed into trees & the ground after going into a left turn during a go-around initiated after a bouncy landing. After power was added for the go-around the acft seemed to be uncontrolled so that the CFI on the ground, who had just exited the acft…
- [NTSB ATL83LA078](https://openairdocs.org/ntsb/ATL83LA078.md): Piper PA-28-180 · Daufuskie Islan, SC · Accident · 1 fatal · Limited investigation · Final report · Dec 30, 1982 · N9305J · Destroyed
  > The pilot's wife stated her husband had departed tampa, FL and could not recall if he had indicated a destination. She further stated her husband had a "charter". Investigation by law enforcement and drug enforcement personnel located cocaine in the aircraft…
- [NTSB MIA79FA126](https://openairdocs.org/ntsb/MIA79FA126.md): Piper PA-28 · Hartsville, SC · Accident · 2 fatal · Closed · Sep 20, 1979 · N5137S · Destroyed
- [NTSB MIA78FA049](https://openairdocs.org/ntsb/MIA78FA049.md): Piper PA-28 · Bishopville, SC · Accident · 1 fatal · Closed · Mar 5, 1978 · N8827J · Destroyed

## 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."highestInjuryLevel" = 'Fatal'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102808'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?fatal=1&model=7102808&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, except the copies of manufacturers’ service documents, which belong to their rights holders.
