# NTSB investigations: Cessna T210N, VA

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 BFO88FA014](https://openairdocs.org/ntsb/BFO88FA014.md): Cessna T210N · Sterling, VA · Accident · No injuries · Field investigation · Final report · Jan 24, 1988 · N5350A · Substantial damage
  > Abt 2.7 hrs after takeoff, the student plt & instructor (CFI) were practicing instrument apchs when the eng lost pwr. The CFI took control of the acft & made a forced lndg, but the acft was damaged on rough terrain. An exam of the acft revealed the right &…
- [NTSB BFO87LA017](https://openairdocs.org/ntsb/BFO87LA017.md): Cessna T210N · West Point, VA · Accident · No injuries · Limited investigation · Final report · Jan 29, 1987 · N244MB · Substantial damage
  > The plt stated that the left main gear collided with a snowbank when the acft touched down on the rwy about 100 ft from the apch end and 10 ft left of the rwy centerline. Afterwards the left main gear folded into the wheel well.
- [NTSB IAD80FA004](https://openairdocs.org/ntsb/IAD80FA004.md): Cessna T210N · Lawrenceville, VA · Accident · 2 fatal · Closed · Oct 5, 1979 · N6483N · Destroyed

## 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."eventStateOrRegion" = 'VA' 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
```

This list as a web page: https://openairdocs.org/ntsb?model=2073456&state=VA

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