# NTSB investigations: Cessna 310G, AZ

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 LAX90LA193](https://openairdocs.org/ntsb/LAX90LA193.md): Cessna 310G · Sedona, AZ · Accident · Minor injuries · Limited investigation · Final report · May 24, 1990 · N161A · Substantial damage
  > The pilot selected the wrong runway, and proper touch down point was not attained.
- [NTSB LAX87LA133](https://openairdocs.org/ntsb/LAX87LA133.md): Cessna 310G · Sedona, AZ · Accident · No injuries · Limited investigation · Final report · Feb 17, 1987 · N161A · Substantial damage
  > The acft landed hard on rwy 3 while on a night VFR pleasure flight. The plt indicated that it was a dark night and he elected to fly the nda-a iap to insure terrain clearance while looking for the rwy. While on final apch he activated the mirl on the traffic…
- [NTSB LAX84LA141](https://openairdocs.org/ntsb/LAX84LA141.md): Cessna 310 · Tucson, AZ · Accident · No injuries · Limited investigation · Final report · Jan 15, 1984 · N8926Z · Substantial damage
  > The right main landing gear collapsed as the acft was being taxied to the ramp. The plt reported that the acft was traveling about 30 mph during entry into the taxi turn-off area at the time of the accident. Failure occurred in theright rear trunion pin.
- [NTSB LAX73FUJ45](https://openairdocs.org/ntsb/LAX73FUJ45.md): Cessna 310G · Phoenix, AZ · Accident · No injuries · Closed · Dec 27, 1972 · N8975Z · Substantial damage
- [NTSB LAX70F0014](https://openairdocs.org/ntsb/LAX70F0014.md): Cessna 310G · Phoenix, AZ · Accident · No injuries · Closed · Jun 14, 1969 · N2913R · 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" = 'AZ' 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 ('2074218'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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