# NTSB investigations: Cessna T210K, CA

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 LAX88LA291](https://openairdocs.org/ntsb/LAX88LA291.md): Cessna T210K · Huntington Bch, CA · Accident · No injuries · Limited investigation · Final report · Jul 25, 1988 · N8273M · Substantial damage
  > During the landing roll, the pilot heard a loud bang on the right side of the airplane. When the pilot applied brakes and the speed dissipated, directional control was lost. The airplane veered of the runway and collided with a runway light. During an…
- [NTSB OAK78FVD39](https://openairdocs.org/ntsb/OAK78FVD39.md): Cessna T210 · Santa Rosa, CA · Accident · No injuries · Closed · Jun 16, 1978 · N8256M · Substantial damage
- [NTSB OAK78FVG08](https://openairdocs.org/ntsb/OAK78FVG08.md): Cessna 210 · Willows, CA · Accident · No injuries · Closed · Oct 30, 1977 · N8231M · Substantial damage
- [NTSB LAX77FUG50](https://openairdocs.org/ntsb/LAX77FUG50.md): Cessna T210 · La Verne, CA · Accident · No injuries · Closed · Jun 30, 1977 · N8132G · Substantial damage
- [NTSB OAK76DVD50](https://openairdocs.org/ntsb/OAK76DVD50.md): Cessna T210 · Novato, CA · Accident · No injuries · Closed · Aug 8, 1976 · N81PC · Substantial damage
- [NTSB OAK76FVG65](https://openairdocs.org/ntsb/OAK76FVG65.md): Cessna T210 · Grass Valley, CA · Accident · No injuries · Closed · Apr 2, 1976 · N8231M · Substantial damage
- [NTSB OAK74DVG11](https://openairdocs.org/ntsb/OAK74DVG11.md): Cessna 210K · Jackson, CA · Accident · No injuries · Closed · Sep 4, 1973 · N8231M · Substantial damage
- [NTSB OAK71AP041](https://openairdocs.org/ntsb/OAK71AP041.md): Cessna T210K · Laytonville, CA · Accident · 1 fatal · Closed · Apr 30, 1971 · N8247M · Destroyed
- [NTSB LAX71FUA58](https://openairdocs.org/ntsb/LAX71FUA58.md): Cessna T210K · Lakewood, CA · Accident · No injuries · Closed · Apr 26, 1971 · N8091M · Substantial damage
- [NTSB LAX71FUD13](https://openairdocs.org/ntsb/LAX71FUD13.md): Cessna T210K · Hntngtn Prk, CA · Accident · Serious injuries · Closed · Mar 14, 1971 · N8295M · Destroyed

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

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

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