# Fatal NTSB investigations, SC: Fuel related

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 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 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 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…

## 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '190' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent"))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-events/190/sequence?fatal=1&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.