OpenAirDocs.org

NTSB investigations: Cessna P210N

8 cases on aircraft the registry lists as Cessna P210N, where the first occurrence was “In flight collision with terrain/water”. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.

Cases per year

19822026

Where

Open the map

Latest cases

Query with SQL
duckdb -csv -c "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"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

NTSB LAX97FA142Accident · 2 fatalField investigationFinal reportCessna P210N · Corona, CAThe 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.Mar 31, 1997 · N3894P · DestroyedNTSB SEA97FA027Accident · 1 fatalField investigationFinal reportCessna P210N · Boring, ORThe pilot's attempt to conduct visual flight into instrument meteorological conditions. A factor contributing to the accident was the presence of thick fog.Nov 15, 1996 · N7823K · DestroyedNTSB ATL96FA074Accident · 2 fatalField investigationFinal reportCessna P210N · Marathon, FLfailure of the pilot to maintain sufficient altitude during an over-water approach at night. Factors relating to the accident were darkness and pilot fatigue.Apr 1, 1996 · N6427W · Substantial damageNTSB NYC93FA118Accident · 3 fatalField investigationFinal reportCessna P210 · Marthas Vineyrd, MAThe pilot's failure to maintain control of the airplane.Jun 18, 1993 · N73CE · DestroyedNTSB DEN85FA120Accident · 1 fatalField investigationFinal reportCessna P210N · Laporte, COThe 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…Apr 22, 1985 · N6208W · DestroyedNTSB SEA83FA044Accident · 1 fatalField investigationFinal reportCessna P210N · Burns, ORThe 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…Jan 22, 1983 · N5162W · DestroyedNTSB DEN83FA027Accident · 2 fatalField investigationFinal reportCessna P210 · Sioux Falls, SDAt 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…Dec 1, 1982 · N4721P · DestroyedNTSB LAX82FA230Accident · 1 fatalField investigationFinal reportCessna P210N · Jamul, CAThe 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…Jun 21, 1982 · N6690P · Destroyed