# NTSB investigations: Cessna 310Q, 2005

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 CHI06CA042](https://openairdocs.org/ntsb/CHI06CA042.md): Cessna 310Q · Pierre, SD · Accident · No injuries · Data collection · Final report · Dec 7, 2005 · N8403F · Substantial damage
  > The pilot's failure to maintain control of the airplane during the landing roll due to the icy runway. Factors were the compacted snow and ice along the edges of the runway and at the taxiway intersection, and the snow banks adjacent to the runway and taxiway.
- [NTSB CHI05CA262](https://openairdocs.org/ntsb/CHI05CA262.md): Cessna 310Q · Boscobel, WI · Accident · No injuries · Data collection · Final report · Sep 9, 2005 · N75SM · Substantial damage
  > The pilot's misjudged distance/altitude which resulted in an undershoot. A related factor was the pilot's diverted attention due to the open cabin door.
- [NTSB DFW05FA188](https://openairdocs.org/ntsb/DFW05FA188.md): Cessna 310Q · Ada, OK · Accident · 3 fatal · Field investigation · Final report · Jul 24, 2005 · N1971W · Destroyed
  > The loss of engine power as a result of a fatigue fracture in one of the crankshaft gear teeth for undetermined reasons. Also causal was the pilot's failure to maintain control of the twin-engine airplane after the power loss, which resulted in an inadvertent…

## 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") = 2005
  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=2005

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