# NTSB investigations: Cessna 310R, IA

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 CHI06CA008](https://openairdocs.org/ntsb/CHI06CA008.md): Cessna 310R · Ottumwa, IA · Accident · Minor injuries · Data collection · Final report · Oct 13, 2005 · N310SK · Substantial damage
  > The pilot misjudged his altitude and airspeed while landing which resulted in the airplane stalling 20 feet above the runway. A factor associated with the accident was the pilot's execution of the approach when reported weather conditions were below the…
- [NTSB MKC89LA071](https://openairdocs.org/ntsb/MKC89LA071.md): Cessna 310 · Des Moines, IA · Accident · No injuries · Limited investigation · Final report · Mar 3, 1989 · N5119C · Substantial damage
  > The failure of the pilot to properly flare the airplane. Contributing to the accident were the weather conditions.
- [NTSB MKC88FA175](https://openairdocs.org/ntsb/MKC88FA175.md): Cessna 310R · Latimer, IA · Accident · 1 fatal · Field investigation · Final report · Sep 21, 1988 · N36HD · Destroyed
  > The pilot had completed his normal flight schedule and was assigned an additional trip from des moines, Iowa to st paul, Minnesota. Calculations show that the pilot had flown an estimated 5 hours in the 8 1/2 hours preceding the accident. The line attendant…
- [NTSB MKC82FA160](https://openairdocs.org/ntsb/MKC82FA160.md): Cessna T310R · Council Bluffs, IA · Accident · 2 fatal · Field investigation · Final report · Aug 30, 1982 · N2906A · Destroyed
  > The omaha weather was reported (in part) to be 3500 ft scattered, estimated 6000 ft broken, 18000 ft broken, visibility 4 mi with fog and haze, wind 200 deg at 5 KTS. However, the aircrew of a preceeding flight that arrived about 8 min earlier said they…
- [NTSB MKC78DA019](https://openairdocs.org/ntsb/MKC78DA019.md): Cessna 310R · Muscatine, IA · Accident · No injuries · Closed · Jan 12, 1978 · N5080J · Substantial damage

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

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

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