NTSB investigations: Cessna T210N, NM

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

19842026

NTSB investigations: Cessna T210N, NM per year, 1984–2026: 8 cases
1984	1
1987	1
1988	2
1994	1
1997	1
2000	1
2006	1

Where

Open the map

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" = 'NM' 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 ('2073456')) 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\" = 'NM' 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 ('2073456'))
  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" = 'NM' 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 ('2073456'))
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 DEN06CA079Accident · Serious injuriesData collectionFinal reportCessna T210N · Santa Fe, NMthe loss of engine power due to fuel exhaustion. Contributing factors were the pilot's inadequate preflight planning and failure to refuel the airplane.May 29, 2006 · N7353C · Substantial damage NTSB DEN01LA008Accident · Serious injuriesLimited investigationFinal reportCessna T210N · Santa Teresa, NMthe pilot's failure to follow procedures/directives and lower the landing gear for landing. Contributing factors were the damaged propellers making it impossible to perform a go-around, the inadvertent stall to the runway, and the pilot being in a state of…Oct 29, 2000 · N5170Y · Substantial damage NTSB FTW97LA155Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Silver City, NMThe high wind and the pilot's inadequate compensation for the crosswind conditions. Factors were the crosswind and wind gusts.Apr 5, 1997 · N4864U · Substantial damage NTSB FTW94LA199Accident · No injuriesLimited investigationFinal reportCessna T210N · Santa Teresa, NMA power loss due to engine driven fuel pump failure. A factor was the lack of suitable terrain for a forced landing.Jun 16, 1994 · N199CH · Substantial damage NTSB DEN88FA111Accident · 1 fatalField investigationFinal reportCessna T210N · Seboyeta, NMThe plt departed el paso, TX, and flew to Douglas, AZ, where three pax boarded. The plt then flew to a ranch near Seboyeta, NM, and landed on a dirt road. After conducting business, the plt and his pax took off for pagosa springs, CO. As the acft turned on a…May 27, 1988 · N5536A · Destroyed NTSB DEN88FA109Accident · 5 fatalField investigationFinal reportCessna T210N · Albuquerque, NMMay 17, 1988 · N5402Y · Destroyed NTSB DEN87LA210Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Albuquerque, NMThe private plt was returning from a business flight. The plt reported that the engine quit during the approach to landing. An emergency landing was made in an open field. The right wing hit a sign and skidded to rest across a paved road and into another open…Aug 7, 1987 · N4743Y · Substantial damage NTSB DEN84FA143Accident · 1 fatalField investigationFinal reportCessna T210N · Farmington, NMFuel exhaustion occurred in normal cruise flt after plt determined consumption precluded reaching destination and requested emergency straight-in to nearest airport. Forced landing executed on highway, wing struck a parked, occupied vehicle. Plt accustomed to…May 4, 1984 · N4774U · Substantial damage