# NTSB investigations: Cessna 310L: Main gear collapsed

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 MIA87LA121](https://openairdocs.org/ntsb/MIA87LA121.md): Cessna 310L · Venice, FL · Accident · No injuries · Limited investigation · Final report · Mar 28, 1987 · N3304X · Substantial damage
  > The left main landing gear collapsed during the landing roll after the plt inadvertently retracted the landing gear instead of the flaps. The pilot left the scene of the accident and his identity is unknown.
- [NTSB MIA86LA134](https://openairdocs.org/ntsb/MIA86LA134.md): Cessna 310L · Opa Locka, FL · Accident · No injuries · Limited investigation · Final report · Apr 26, 1986 · N216Y · Substantial damage
  > The right main landing gear collapsed on the landing rollout, after which the acft slid off the right side of the rwy & came to rest on the grass. Post crash examination of the landing gear retract system revealed that the right main gear retract push pull…

## 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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2074230')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 191))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=2074230&occurrence=191

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