# NTSB investigations: Cessna T310R, MN

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 CHI06LA036](https://openairdocs.org/ntsb/CHI06LA036.md): Cessna T310R · Fergus Falls, MN · Accident · No injuries · Limited investigation · Final report · Nov 15, 2005 · N5094C · Substantial damage
  > The presence of wing ice during landing. Contributing factors were the icing conditions and flight into known adverse weather by the pilot.
- [NTSB CHI04CA252](https://openairdocs.org/ntsb/CHI04CA252.md): Cessna T310R · Marshall, MN · Accident · No injuries · Data collection · Final report · Sep 4, 2004 · N5005J · Substantial damage
  > The pilot rated passenger selecting an improper fuel selector position, and the pilot in command not verifying the fuel selector position which resulted in fuel starvation. Contributing factors were the pilot's failure to feather the right engine propeller…
- [NTSB CHI03LA046](https://openairdocs.org/ntsb/CHI03LA046.md): Cessna 310R · Ada, MN · Accident · Serious injuries · Limited investigation · Final report · Jan 5, 2003 · N37221 · Destroyed
  > The pilot's failure to maintain the minimum descent altitude and his failure to maintain obstacle clearance. A low ceiling was a factor.

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

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

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