# NTSB investigations: Cessna T310R, 2004

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 LAX05FA045](https://openairdocs.org/ntsb/LAX05FA045.md): Cessna T310R · Flagstaff, AZ · Accident · 1 fatal · Field investigation · Final report · Dec 8, 2004 · N592DM · Destroyed
  > The pilot's decision to attempt flight into known adverse weather conditions beyond the capability of the airplane and his failure to ensure that the airplane's wings were free of ice and/or snow contamination that accumulated while the airplane was on the…
- [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 NYC04WA098](https://openairdocs.org/ntsb/NYC04WA098.md): Cessna T310R · Lancashire, United Kingdom · Accident · 1 fatal · Foreign investigation · Mar 30, 2004 · N6834L · Substantial damage
- [NTSB DEN04CA054](https://openairdocs.org/ntsb/DEN04CA054.md): Cessna T310R · Broomfield, CO · Accident · No injuries · Data collection · Final report · Mar 21, 2004 · N3465G · Substantial damage
  > the pilot's improper in-flight planning/decision and his failure to verify the landing gear position. Factors contributing to the accident were the pilot's diverted attention due to the electrical failure.

## 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") = 2004
  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&year=2004

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