# NTSB investigations: Cessna 210B: In flight collision with terrain/water

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 LAX00LA005](https://openairdocs.org/ntsb/LAX00LA005.md): Cessna 210B · Tonopah, NV · Accident · Serious injuries · Limited investigation · Final report · Oct 6, 1999 · N9609X · Substantial damage
  > The pilot's failure to monitor his altitude and maintain an adequate terrain clearance during the approach. The dark night lighting conditions and the visual illusion created by the lack of ground reference lights were factors in the accident.
- [NTSB CHI94LA045](https://openairdocs.org/ntsb/CHI94LA045.md): Cessna 210B · Dubuque, IA · Accident · Serious injuries · Limited investigation · Final report · Dec 6, 1993 · N9684X · Substantial damage
  > Flight by the pilot into known icing conditions, which resulted in airframe icing and an inability of the aircraft to maintain altitude on the ILS glidepath, once the landing gear was lowered. The weather conditions were related factors.
- [NTSB LAX84LA021](https://openairdocs.org/ntsb/LAX84LA021.md): Cessna 210B · Bakersfield, CA · Accident · No injuries · Limited investigation · Final report · Oct 20, 1983 · N9626X · Substantial damage
  > The plt was unable to lower all three gear using normal & emergency proceduces. The acft landed with only the nose & left main gear extended. The right main landing gear actuator assembly was found cracked & ruputred, resulting in a lossof hydraulic pressure.
- [NTSB DEN82FA016](https://openairdocs.org/ntsb/DEN82FA016.md): Cessna 210 · Helena, MT · Accident · 2 fatal · Field investigation · Final report · Jan 7, 1982 · N9763X · Destroyed
  > The aircraft crashed into a mountain at the 9300 foot level. The pilot was on course for his destination. The minimum obstacle clearance altitude for his location was 10,800 feet. Weather was not a problem but the accident did occur during hours of darkness.…

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

This list as a web page: https://openairdocs.org/ntsb?model=2073410&occurrence=230

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