# NTSB investigations: Cessna 210D: 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 LAX03LA216](https://openairdocs.org/ntsb/LAX03LA216.md): Cessna 210D · Carefree, AZ · Accident · Serious injuries · Limited investigation · Final report · Jun 29, 2003 · N3826Y · Substantial damage
  > fuel exhaustion due to a crack on the elbow fitting to the gascolator resulted in a fuel leak.
- [NTSB LAX99LA140](https://openairdocs.org/ntsb/LAX99LA140.md): Cessna 210D · El Monte, CA · Accident · Minor injuries · Limited investigation · Final report · Apr 5, 1999 · N2340F · Substantial damage
  > A loss of engine power due to the fatigue failure of the mixture control cable, which was due to the improper installation and adjustment of the cable 99 hours prior to the accident.

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