Skip to content

NTSB investigations: Cessna P210N, NV

11 cases on aircraft the registry lists as Cessna P210N. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19812026

Where

Latest cases

Query with 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" = 'NV' 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 ('2073454', '2073462')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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.\"eventStateOrRegion\" = 'NV' 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 ('2073454', '2073462'))
  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.

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" = 'NV' 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 ('2073454', '2073462'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

NTSB WPR24LA230Accident · No injuriesClass 3 · LimitedFinal reportCessna P210N · Reno, NVA loss of electrical power for undetermined reasons, which resulted in a partial extension of the landing gear and subsequent landing gear collapse during landing. Contributing to the accident was fuel starvation that resulted in a total loss of engine power.Jun 13, 2024 · N36RW · Substantial damage NTSB LAX05CA031Accident · Minor injuriesData collectionFinal reportCessna P210N · North Las Vegas, NVthe pilot's inadequate in-flight planning/decision which resulted in fuel exhaustion. Also causal was the pilot's inadequate preflight planning/preparation which failed to assure an adequate fuel supply.Nov 11, 2004 · N6663P · Substantial damage NTSB ANC04FA015Accident · 2 fatalField investigationFinal reportCessna P210N · Tonopah, NVThe pilot's failure to follow approved instrument flight procedures, and his failure to maintain clearance from obstacles/terrain, which resulted in an in-flight collision with terrain. Factors associated with the accident are snow and low clouds.Dec 14, 2003 · N4674A · Destroyed NTSB LAX02FA018Accident · 1 fatalField investigationFinal reportCessna P210N · Mt. Charleston, NVthe pilot's failure to maintain an adequate airspeed after continuing flight into forecast adverse meteorological conditions consisting of turbulence, icing, and downdrafts, which resulted in a stall/spin.Oct 30, 2001 · N734VM · Destroyed NTSB LAX99LA289Accident · Minor injuriesLimited investigationFinal reportCessna P210N · North Las Vegas, NVThe pilot's improper procedure in that he failed to follow the flight manual, resulting in a loss of engine power and subsequent collision with the ground.Aug 29, 1999 · N40RP · Substantial damage NTSB LAX99LA203Accident · Serious injuriesLimited investigationFinal reportCessna P210N · Reno, NVFuel starvation resulting from the pilot's inattentive monitoring and management of the fuel system.May 31, 1999 · N37MJ · Substantial damage NTSB SEA87LA191Accident · Minor injuriesLimited investigationFinal reportCessna P210N · Las Vegas, NVThe aircraft was on descent for landing at 6500 feet MSL about 5 miles from the airport when a total loss of power occurred due to fuel exhaustion. At 5000 feet AGL the pilot lowered the landing gear and at about 2000 feet AGL landing flaps were added. The…Sep 21, 1987 · N4500K · Substantial damage NTSB SEA85LA058Accident · No injuriesLimited investigationFinal reportCessna P210 · Las Vegas, NVThe hydraulic power pack reservoir was depleted from a leak in the hand pump suction line, which had been chafed through by interference with the right rudder cable. Apparently, there was sufficient back pressure remaining to lower and lock the nose gear, but…Feb 17, 1985 · N731EZ · Substantial damage NTSB LAX82DA251Accident · No injuriesFinal reportCessna P-210N · Reno, NVThe aircraft veered off the runway during landing. The weather was VMC and no flight plan was filed. The landing was on runway 16 and the wind was from 300 degrees at 14 knots. The pilot did not file an accident report.Jul 10, 1982 · N732XH · Substantial damage NTSB LAX81FVW14Accident · Minor injuriesClosedCessna P210N · Tonopah, NVJun 28, 1981 · N6631P · Substantial damage NTSB LAX81FA051Accident · 2 fatalClosedCessna T210N · Fallon, NVMar 2, 1981 · N77FB · Destroyed