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

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 ERA10FAMS1](https://openairdocs.org/ntsb/ERA10FAMS1.md): Cirrus SR22 · Gulf of Mexico · Accident · 1 fatal · Missing aircraft · Final report · Dec 15, 2009 · N723LJ · Destroyed
  > Undetermined (airplane and pilot missing).
- [NTSB ERA10CA071](https://openairdocs.org/ntsb/ERA10CA071.md): Cirrus SR-22 · Everglades City, FL · Accident · No injuries · Data collection · Final report · Nov 21, 2009 · N609SR · Substantial damage
  > The pilot's failure to maintain directional control during the attempted go-around.
- [NTSB ERA09FA515](https://openairdocs.org/ntsb/ERA09FA515.md): Cirrus SR-22 · Rock Hill, SC · Accident · 1 fatal · Field investigation · Final report · Sep 11, 2009 · N922XX · Destroyed
  > The pilot's failure to maintain aircraft control and altitude while maneuvering after takeoff.
- [NTSB ERA09FA429](https://openairdocs.org/ntsb/ERA09FA429.md): Cirrus SR-22 · Ravenswood, WV · Accident · 1 fatal · Field investigation · Final report · Jul 31, 2009 · N581DS · Destroyed
  > The pilot's improper modification of the certified, on-board oxygen system, which resulted in incapacitation due to hypoxia, and the airplane's subsequent uncontrolled descent into terrain.
- [NTSB ERA09CA387](https://openairdocs.org/ntsb/ERA09CA387.md): Cirrus Design SR22 · Winder, GA · Accident · No injuries · Data collection · Final report · Jul 7, 2009 · N316SR · Substantial damage
  > The pilot's failure to obtain the proper touchdown point during a practice forced landing, and the flight instructor's delayed decision to initiate a go-around.
- [NTSB CEN09FA267](https://openairdocs.org/ntsb/CEN09FA267.md): Cirrus Design SR22 · Mayfield Village, OH · Accident · 2 fatal · Field investigation · Final report · Apr 28, 2009 · N504MD · Destroyed
  > The pilot’s failure to maintain control of the airplane while operating in instrument meteorological conditions due to spatial disorientation. Contributing to the accident was the pilot’s inattention to basic aircraft control while attempting to program the…
- [NTSB ERA09LA200](https://openairdocs.org/ntsb/ERA09LA200.md): Cirrus Design SR22 · Gaithersburg, MD · Accident · No injuries · Limited investigation · Final report · Mar 15, 2009 · N213CP · Substantial damage
  > The pilot’s spatial disorientation after the passenger door opened during flight in instrument meteorological conditions. Contributing to the accident was the pilot’s failure to properly secure the door latch.
- [NTSB ERA09LA189](https://openairdocs.org/ntsb/ERA09LA189.md): Cirrus Design SR22 · Montauk, NY · Accident · No injuries · Limited investigation · Final report · Mar 7, 2009 · N574PG · Substantial damage
  > The student pilot's failure to maintain directional control during takeoff. Contributing to the accident was the instructor's delayed remedial action.

## 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 year(c."eventDate") = 2009
  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&year=2009

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