# NTSB investigations: Cessna 310Q, 2008

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 DFW08FA153](https://openairdocs.org/ntsb/DFW08FA153.md): Cessna 310Q · Steamboat, CO · Accident · 2 fatal · Field investigation · Final report · May 25, 2008 · N8187Q · Destroyed
  > The pilot's failure to maintain clearance from mountainous terrain in day visual conditions. Contributing to the accident was the pilot's impairment due to marijuana and inadequate medical oversight of the pilot by the Federal Aviation Administration.
- [NTSB LAX08FA101](https://openairdocs.org/ntsb/LAX08FA101.md): Cessna 310Q · Compton, CA · Accident · Serious injuries · Field investigation · Final report · Apr 12, 2008 · N6231Q · Substantial damage
  > The loss of both engines' power during approach due to fuel exhaustion that resulted from the pilot's inadequate preflight inspection and failure to verify the quantity of fuel on board the airplane.
- [NTSB DFW08CA099](https://openairdocs.org/ntsb/DFW08CA099.md): Cessna 310Q · Roswell, NM · Accident · No injuries · Data collection · Final report · Apr 11, 2008 · N7935Q · Substantial damage
  > The airframe and powerplant mechanic's incorrect reassembly of the landing gear.

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

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

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