# NTSB investigations: Cessna T210M, 1992

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 LAX93FA055](https://openairdocs.org/ntsb/LAX93FA055.md): Cessna T210M · Thornton, CA · Accident · 5 fatal · Field investigation · Final report · Nov 29, 1992 · N784RF · 2 aircraft · Destroyed
  > The failure of the pilots of both airplanes to see and avoid each other. Contributing to the accident was the failure of the sacramento controller to advise the stockton controller of the impending unsafe situation, and the failure of the stockton controller…
- [NTSB CHI92LA094](https://openairdocs.org/ntsb/CHI92LA094.md): Cessna T210M · Washington, IN · Accident · No injuries · Limited investigation · Final report · Feb 21, 1992 · N732TR · Substantial damage
  > The total loss of engine power due to a fatigue-fractured crankshaft.
- [NTSB LAX92LA098](https://openairdocs.org/ntsb/LAX92LA098.md): Mooney M20J · Bullhead City, AZ · Accident · No injuries · Limited investigation · Final report · Jan 11, 1992 · N7000L · 2 aircraft · Substantial damage
  > The pilot of the other aircraft inadvertently landing on the taxiway instead of the active runway.

## 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 year(c."eventDate") = 1992
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073451', '2073452'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=2073451&year=1992

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