# NTSB investigations: Cessna P210N: 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 LAX97FA142](https://openairdocs.org/ntsb/LAX97FA142.md): Cessna P210N · Corona, CA · Accident · 2 fatal · Field investigation · Final report · Mar 31, 1997 · N3894P · Destroyed
  > The pilot's failure to maintain adequate terrain clearance during a nighttime flight at low altitude through a mountainous area. Factors in the accident were the conditions of low clouds and dark light conditions.
- [NTSB SEA97FA027](https://openairdocs.org/ntsb/SEA97FA027.md): Cessna P210N · Boring, OR · Accident · 1 fatal · Field investigation · Final report · Nov 15, 1996 · N7823K · Destroyed
  > The pilot's attempt to conduct visual flight into instrument meteorological conditions. A factor contributing to the accident was the presence of thick fog.
- [NTSB ATL96FA074](https://openairdocs.org/ntsb/ATL96FA074.md): Cessna P210N · Marathon, FL · Accident · 2 fatal · Field investigation · Final report · Apr 1, 1996 · N6427W · Substantial damage
  > failure of the pilot to maintain sufficient altitude during an over-water approach at night. Factors relating to the accident were darkness and pilot fatigue.
- [NTSB NYC93FA118](https://openairdocs.org/ntsb/NYC93FA118.md): Cessna P210 · Marthas Vineyrd, MA · Accident · 3 fatal · Field investigation · Final report · Jun 18, 1993 · N73CE · Destroyed
  > The pilot's failure to maintain control of the airplane.
- [NTSB DEN85FA120](https://openairdocs.org/ntsb/DEN85FA120.md): Cessna P210N · Laporte, CO · Accident · 1 fatal · Field investigation · Final report · Apr 22, 1985 · N6208W · Destroyed
  > The plt was a business man, involved in building/construction work. On the morning of the acdnt, he had breakfast with friends who said he was in good spirits & was going to fly before going to work. Witnesses near the acdnt site saw the acft flying in the…
- [NTSB SEA83FA044](https://openairdocs.org/ntsb/SEA83FA044.md): Cessna P210N · Burns, OR · Accident · 1 fatal · Field investigation · Final report · Jan 22, 1983 · N5162W · Destroyed
  > The plt was on a bank-check courier flt from troutdale to portland, with en route stops at Burns & redmond, OR. Routinely, the acft would depart troutdale between 0900 & 0930 & arrive at Burns at 1130 to 1200 local time. After a ground time of aprx 8 hrs, it…
- [NTSB DEN83FA027](https://openairdocs.org/ntsb/DEN83FA027.md): Cessna P210 · Sioux Falls, SD · Accident · 2 fatal · Field investigation · Final report · Dec 1, 1982 · N4721P · Destroyed
  > At 1915 while enroute the plt was advised that the destination wx was 100 ft obscured, 3/8 mi in fog. At 2140 the plt contacted approach control & was advised the wx was 100 ft obscured & 1/8 mi with an RVR for rwy 3 of 2,400 ft. he was cleared for an ILS rwy…
- [NTSB LAX82FA230](https://openairdocs.org/ntsb/LAX82FA230.md): Cessna P210N · Jamul, CA · Accident · 1 fatal · Field investigation · Final report · Jun 21, 1982 · N6690P · Destroyed
  > The plt was being vectored for another approach after executing a missed approach. At 1642 the plt was cleared for 5,000 ft. at 1643 the plt was given a heading of 090, vector for the final approach course. At 1647 the plt was given a heading of 340. 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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073454', '2073462')
    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=2073454&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.