# NTSB investigations: Cessna 310H, FL

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 ERA13FA133](https://openairdocs.org/ntsb/ERA13FA133.md): Cessna 310H · Yeehaw Junction, FL · Accident · 3 fatal · Field investigation · Final report · Feb 14, 2013 · N104DR · Substantial damage
  > The noninstrument-rated pilot's improper decision to continue visual flight rules flight into instrument meteorological conditions and his subsequent spatial disorientation. Contributing to the accident was the copilot's improper evaluation of the weather…
- [NTSB MIA79FLA11](https://openairdocs.org/ntsb/MIA79FLA11.md): Cessna 310H · Daytona Bch, FL · Accident · No injuries · Closed · Jan 25, 1979 · N1081Q · Substantial damage
- [NTSB MIA79FLD34](https://openairdocs.org/ntsb/MIA79FLD34.md): Cessna 310 · Fellsmere, FL · Accident · No injuries · Closed · Jan 21, 1979 · N222YW · Substantial damage
- [NTSB MIA73FLA13](https://openairdocs.org/ntsb/MIA73FLA13.md): Cessna 310H · Jacksonville, FL · Accident · No injuries · Closed · Aug 14, 1972 · N1135Q · Substantial damage
- [NTSB UNK69X0143](https://openairdocs.org/ntsb/UNK69X0143.md): Cessna 310H · Sanford, FL · Accident · No injuries · Closed · Aug 9, 1969 · N1056Q · Substantial damage
- [NTSB MIA65D0159](https://openairdocs.org/ntsb/MIA65D0159.md): Cessna 310H · Cape Coral, FL · Accident · No injuries · Closed · Aug 13, 1965 · N1056Q

## 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" = 'FL' 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 ('2074220'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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