# NTSB investigations: Cessna 210A: Loss of engine power(total) - mech failure/malf

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 LAX88LA039](https://openairdocs.org/ntsb/LAX88LA039.md): Cessna 210A · San Luis Obispo, CA · Accident · No injuries · Limited investigation · Final report · Nov 12, 1987 · N9505X · Substantial damage
  > While approaching the arpt the plt stated that he slipped the acft from 1800 feet to 1400 feet, leveled the wings, still descending, and entered the pattern at 1200 feet. While on final approach the engine quit. Unable to land on the rwy, the plt landed in a…
- [NTSB ATL84FA061](https://openairdocs.org/ntsb/ATL84FA061.md): Cessna 210A · Columbia, SC · Accident · Serious injuries · Field investigation · Final report · Dec 4, 1983 · N9491X · Destroyed
  > The acft collided with a wall during a downwind forced landing. The engine had quit at 200 ft after takeoff. The plt turned right with the gear up. He landed on a football field and bounced down a track field into a fence and wall. When the engine was…

## 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 ('2073408')
    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" = 351))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=2073408&occurrence=351

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