# Fatal NTSB investigations: Continental IO-360 series, 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 ERA16FA168](https://openairdocs.org/ntsb/ERA16FA168.md): Ryskamp Bruce A Acroduster · Belton, SC · Accident · 1 fatal · Field investigation · Final report · Apr 24, 2016 · N380JA · Destroyed
  > A loss of engine power for reasons that could not be determined due to extensive postcrash fire damage. Also causal was the pilot's loss of airplane control, resulting in an aerodynamic stall and subsequent impact with terrain.
- [NTSB ATL05FA034](https://openairdocs.org/ntsb/ATL05FA034.md): Diamond DA40-180 · Pelzer, SC · Accident · 3 fatal · Field investigation · Final report · Dec 9, 2004 · N42SE · Substantial damage
  > The pilot's failure to follow IFR procedures and to maintain assigned altitude resulting in a collision with a transmission wire and trees.
- [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.

## 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.engine_model_code IN ('17025', '17045'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?engine=17025&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.
