# NTSB investigations: Cessna T210M, NC

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 ATL90LA009](https://openairdocs.org/ntsb/ATL90LA009.md): Cessna 210 · Kernersville, NC · Accident · No injuries · Limited investigation · Final report · Oct 19, 1989 · N1155M · Substantial damage
  > Improper fuel consumption calculations by the pilot, which resulted in fuel exhaustion from lack of fuel. Adverse weather conditions were related to the accident.
- [NTSB ATL84FA038](https://openairdocs.org/ntsb/ATL84FA038.md): Cessna T210M · Banner Elk, NC · Accident · 5 fatal · Field investigation · Final report · Nov 5, 1983 · N761VK · No damage
  > Before takeoff, the plt obtained wx for ashville & hickory, NC & for the tri-city arpt, all of which were 30 to 54 mi from Banner Elk, NC. At that time, he told the briefer that there were clouds at Banner Elk, but he thought he could get out all right. The…

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

This list as a web page: https://openairdocs.org/ntsb?model=2073451&state=NC

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