# NTSB investigations: Continental O-200A: 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 SEA07CA192](https://openairdocs.org/ntsb/SEA07CA192.md): Cub Crafters CC11-100 · Palm Springs, CA · Accident · No injuries · Data collection · Final report · Jun 30, 2007 · N475CC · Substantial damage
  > The pilot's failure to maintain directional control during landing which resulted in an inadvertent ground loop.
- [NTSB MIA99LA167](https://openairdocs.org/ntsb/MIA99LA167.md): Cessna 150M · St. Augustine, FL · Accident · Minor injuries · Limited investigation · Final report · Jun 7, 1999 · N704KK · Substantial damage
  > The student pilot's inadequate compensation for the crosswind condition. A factor associated with the accident was the crosswind.
- [NTSB CHI85LA093](https://openairdocs.org/ntsb/CHI85LA093.md): Saabye Cassutt Sport Racer · Lake Village, IN · Accident · Minor injuries · Limited investigation · Final report · Jan 22, 1985 · N12SG · Substantial damage
  > The acft nosed over after colliding with a snow bank during landing. A snow covered driveway, which parallels the rwy was used for landing. The driveway measures 2600'X 25' and the landing was made to the north. The acft was blown to the right during the…
- [NTSB LAX82DA107](https://openairdocs.org/ntsb/LAX82DA107.md): Cessna 120 · San Andreas, CA · Accident · Minor injuries · Final report · Mar 13, 1982 · N1746N · Destroyed
  > During a three point landing the aircraft started to ground loop. The pilot used rudder and power to recover but the aircraft ran off the side of the runway and struck a tree.

## 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 ('17404')
    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=17404&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.