# NTSB investigations: Cessna 210N: 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 CHI92LA041](https://openairdocs.org/ntsb/CHI92LA041.md): Cessna 210N · Frankfort, IL · Accident · No injuries · Limited investigation · Final report · Dec 3, 1991 · N5281A · Substantial damage
  > The failure of the fss to notify ATC that the ariport was closed, atc's subsequent approach clearance to the closed airport, and the pilot's inability to maintain directional control on the icy runway. A factor in the accident was the icy runway conditions.
- [NTSB MIA85LA226](https://openairdocs.org/ntsb/MIA85LA226.md): Cessna 210N · Melbourne, FL · Accident · No injuries · Limited investigation · Final report · Aug 4, 1985 · N4744C · Substantial damage
  > Act swerved left after landing and crashed at drainage ditc h appx 50 ft north of rwy. The pilot stated he was unable to effect a timely recovery from the left swerve and that 'a more consistent training effort could sharpen my reactions to this sort of…

## 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.aircraft_model_code IN ('2073453')
    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?model=2073453&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.