# NTSB investigations: Continental IO-550-N, VA

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 ERA19FA251](https://openairdocs.org/ntsb/ERA19FA251.md): Cirrus SR22 · Tappahannock, VA · Accident · Serious injuries · Field investigation · Final report · Aug 19, 2019 · N621JE · Substantial damage
  > The pilot's inability to land on the runway in dark night conditions with reported smoke in the cockpit, which necessitated the deployment of the airplane's parachute system.
- [NTSB ERA13LA328](https://openairdocs.org/ntsb/ERA13LA328.md): Cirrus Design SR22 · Tappahannock, VA · Accident · No injuries · Limited investigation · Final report · Jul 21, 2013 · N223SS · Substantial damage
  > A failure of the engine crankshaft top rear trailing forward counterweight retaining plate, which resulted in a total loss of engine power. The reason for the retaining plate’s failure could not be determined during postaccident examination.
- [NTSB ERA12CA110](https://openairdocs.org/ntsb/ERA12CA110.md): Cirrus Design SR22 · Farmville, VA · Accident · No injuries · Data collection · Final report · Dec 16, 2011 · N788SR · Substantial damage
  > The pilot did not maintain the proper approach path, which resulted in a runway undershoot.
- [NTSB NYC08FA138](https://openairdocs.org/ntsb/NYC08FA138.md): Cirrus Design SR22 · Front Royal, VA · Accident · 2 fatal · Field investigation · Final report · Mar 15, 2008 · N141SR · Destroyed
  > The pilot's failure to maintain clearance from rising mountainous terrain, and his failure to turn toward his assigned course during initial climb. Contributing to the accident were the low ceiling, reduced visibility, dark night conditions, and rising…

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

This list as a web page: https://openairdocs.org/ntsb?engine=17215&state=VA

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