# NTSB investigations: Cessna 172D, 2010

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 CEN11LA001](https://openairdocs.org/ntsb/CEN11LA001.md): Cessna 172D · Durango, CO · Accident · Minor injuries · Limited investigation · Final report · Oct 3, 2010 · N2593 · Substantial damage
  > A total loss of engine power due to the pilot inadvertently moving the fuel selector to the OFF position. Contributing to the accident was the pilot's unfamiliarity with this model accident airplane.
- [NTSB CEN10LA282](https://openairdocs.org/ntsb/CEN10LA282.md): Cessna 172 · Las Cruces, NM · Accident · Serious injuries · Limited investigation · Final report · May 30, 2010 · N2723U · Destroyed
  > A loss of engine power due to fuel starvation as a result of water contamination in the fuel, and the pilot's inadequate preflight inspection. Contributing the accident was an inoperative number 5 cylinder exhaust valve.
- [NTSB CEN10FA181](https://openairdocs.org/ntsb/CEN10FA181.md): Cessna 172D · Hillsboro, OH · Accident · 1 fatal · Field investigation · Final report · Apr 2, 2010 · N2190Y · Destroyed
  > Impact with the runway pavement for unknown reasons.

## 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 year(c."eventDate") = 2010
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072410'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=2072410&year=2010

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