# NTSB investigations: Pratt & Whitney R-2800 series: 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 ANC83IA118](https://openairdocs.org/ntsb/ANC83IA118.md): Fairchild C-82A · Anchorage, AK · Incident · No injuries · Incident investigation · Final report · Jul 7, 1983 · N9701F · Minor damage
  > The main landing gear collapsed after landing. The nose gearwas down & locked with a green light in the cockpit. There was no down & locked light illuminated for the main gear. Examination revealed signatures consistent with extreme overload as in attempting…
- [NTSB NYC82DA114](https://openairdocs.org/ntsb/NYC82DA114.md): Douglas RB-26C · Dubois, PA · Accident · No injuries · Final report · Jun 2, 1982 · N3428G · Substantial damage
  > The aircraft was being ferried to its home base in Montana. During a landing to refuel, the left main gear collapsed after the aircraft had rolled about 2500 ft and had slowed to about 30 to 40 KTS. An inspection revealed that the left main gear beam mounting…

## 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.engine_model_code IN ('52026')
    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?engine=52026&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.