# NTSB investigations, OH: 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 NYC00LA190](https://openairdocs.org/ntsb/NYC00LA190.md): Spartan 7W · Jefferson, OH · Accident · No injuries · Limited investigation · Final report · Jul 6, 2000 · N17613 · Substantial damage
  > The overload failure of the left main gear strut housing.
- [NTSB NYC99LA051](https://openairdocs.org/ntsb/NYC99LA051.md): Cessna 650 · Columbus, OH · Accident · No injuries · Limited investigation · Final report · Jan 22, 1999 · N782QS · Substantial damage
  > The collapse of the airplane's right main landing gear due to inadequate design by its manufacturer.
- [NTSB NYC92LA094](https://openairdocs.org/ntsb/NYC92LA094.md): Cessna 310R · Cleveland, OH · Accident · No injuries · Limited investigation · Final report · Jun 2, 1992 · N225SC · Substantial damage
  > A failure of the left main gear's upper strut housing and down lock link assembly attach point.
- [NTSB CHI89LA106](https://openairdocs.org/ntsb/CHI89LA106.md): Piper PA-38-112 · Elyria, OH · Accident · No injuries · Limited investigation · Final report · Jun 9, 1989 · N2529D · Substantial damage
  > Failure (shearing) of the right main gear attaching bolts. A contributing factor was: failure of the owner/operator to comply with service bulletin #673B.
- [NTSB ATL88LA193](https://openairdocs.org/ntsb/ATL88LA193.md): Cessna 195A · Port Clinton, OH · Accident · No injuries · Limited investigation · Final report · Jun 12, 1988 · N1527D · Substantial damage
  > During touchdown, the pilot noted a vibration and the airplane veered to the left. He attempted to correct by applying right brake and rudder, but the airplane continued off the left side of the runway into the grass. The right landing gear strut failed at…
- [NTSB CHI83LA142](https://openairdocs.org/ntsb/CHI83LA142.md): Bellanca 17-30A · Columbus, OH · Accident · No injuries · Limited investigation · Final report · Mar 16, 1983 · N93571 · Substantial damage
  > The plt had purchased the acft on 2/28/83. From that date until the day of the accident on 3/16/83, he had problems with the landing gear. When he attempted to retract the gear after takeoff on the day of the accident, the indicators showed that the gear had…

## 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" = 'OH' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE 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?occurrence=191&state=OH

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