# NTSB investigations: Cessna 310H, 1985

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 FTW85FA211](https://openairdocs.org/ntsb/FTW85FA211.md): Cessna 310H · Avinger, TX · Accident · 1 fatal · Field investigation · Final report · May 8, 1985 · N1013Q · Substantial damage
  > The pilot stated he was flying low over the lake surface. He felt a decelaration to the right and the next thing he was in the water. Witnesses saw the aircraft over the lake at a low altitude and saw the right wing impact the water and cartwheel to the right…
- [NTSB NYC85FA098](https://openairdocs.org/ntsb/NYC85FA098.md): Cessna 310H · Ronkonkoma, NY · Accident · 1 fatal · Field investigation · Final report · Apr 4, 1985 · N1022Q · Destroyed
  > The aircraft deeparted runway 33L and climbed to about 500 feet AGL with the landing gear down. Near the departure end of runway 33L the aircraft banked right and spiraled to the ground and crashed.

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

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

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