# NTSB investigations: Continental IO-470 series, 2005

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 CHI06CA042](https://openairdocs.org/ntsb/CHI06CA042.md): Cessna 310Q · Pierre, SD · Accident · No injuries · Data collection · Final report · Dec 7, 2005 · N8403F · Substantial damage
  > The pilot's failure to maintain control of the airplane during the landing roll due to the icy runway. Factors were the compacted snow and ice along the edges of the runway and at the taxiway intersection, and the snow banks adjacent to the runway and taxiway.
- [NTSB CHI05CA268](https://openairdocs.org/ntsb/CHI05CA268.md): Cessna 180A · Lodi, WI · Accident · Minor injuries · Data collection · Final report · Sep 15, 2005 · N392PT · Substantial damage
  > The pilot's failure to maintain directional control of the airplane during landing resulting in a nose-over.
- [NTSB DFW05FA188](https://openairdocs.org/ntsb/DFW05FA188.md): Cessna 310Q · Ada, OK · Accident · 3 fatal · Field investigation · Final report · Jul 24, 2005 · N1971W · Destroyed
  > The loss of engine power as a result of a fatigue fracture in one of the crankshaft gear teeth for undetermined reasons. Also causal was the pilot's failure to maintain control of the twin-engine airplane after the power loss, which resulted in an inadvertent…
- [NTSB DFW05FA145](https://openairdocs.org/ntsb/DFW05FA145.md): Beech 95-B55 · Jeanerette, LA · Accident · 2 fatal · Field investigation · Final report · Jun 3, 2005 · N656RS · Substantial damage
  > The pilot's failure to obtain/maintain sufficient airspeed to maintain control. A contributing factor was the loss of engine power for undetermined reason.

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

This list as a web page: https://openairdocs.org/ntsb?engine=17044&year=2005

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