# NTSB investigations: Cessna 210, 2020

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 CEN21LA030](https://openairdocs.org/ntsb/CEN21LA030.md): Cessna 210 · Lubbock, TX · Accident · 1 fatal · Class 3 · Limited · Final report · Oct 26, 2020 · N9622T · Destroyed
  > The pilot’s improper decision to fly into icing conditions with an airplane that was not equipped for icing, which led to structural icing and a subsequent loss of airplane control, and the pilot’s impairment from carbon monoxide poisoning due to a cracked…
- [NTSB WPR20LA288](https://openairdocs.org/ntsb/WPR20LA288.md): Cessna 210 · Chino, CA · Accident · No injuries · Class 3 · Limited · Final report · Aug 26, 2020 · N9540T · Substantial damage
  > The failure of the engine-driven hydraulic pump, which resulted in the main landing gear not fully extending and locking into place during landing. Contributing to the accident was the failure of the emergency gear extension system for reasons that could not…

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

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

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