# NTSB investigations: Continental IO-470 series: Loss of control - on ground/water

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 ANC03LA086](https://openairdocs.org/ntsb/ANC03LA086.md): Cessna 185 · Tyonek, AK · Accident · No injuries · Limited investigation · Final report · Jul 29, 2003 · N913SM · Substantial damage
  > The pilot's failure to maintain directional control during the landing roll, which resulted in a swerve and nose down.
- [NTSB FTW85LA128](https://openairdocs.org/ntsb/FTW85LA128.md): Cessna 205 · College Station, TX · Accident · No injuries · Limited investigation · Final report · Feb 26, 1985 · N1868Z · Substantial damage
  > The acft veered to the right on touchdown. The plt was unable to regain control before the acft departed the right side of the rwy and nosed over when it entered the soft terrain. No evidence of a nose gear failure was found.

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

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

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