# NTSB investigations: AiResearch TPE331 series: Landing gear collapse

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 ERA23LA277](https://openairdocs.org/ntsb/ERA23LA277.md): Rockwell International 695 · Philadelphia, PA · Accident · No injuries · Class 3 · Limited · Final report · May 31, 2023 · N515AM · Substantial damage
  > Failure of the nose gear support structure for unknown reasons, which resulted in the nose landing gear collapsing during landing.
- [NTSB ANC22LA042](https://openairdocs.org/ntsb/ANC22LA042.md): Short Bros. & Harland SC7 · Chisana, AK · Accident · No injuries · Class 4 · Limited · Final report · Jun 8, 2022 · N731E · Substantial damage
  > The pilot’s selection of an unsuitable landing site, which resulted in the nosewheel collapsing.
- [NTSB WPR18LA129](https://openairdocs.org/ntsb/WPR18LA129.md): Gulfstream AM Corp Comm Div 695A · Bishop, CA · Accident · No injuries · Class 3 · Limited · Final report · Apr 26, 2018 · N79PH · Substantial damage
  > The failure of the left main landing gear upper arm forging due to fatigue cracking and subsequent overstress, which resulted in the collapse of the landing gear during the landing roll.
- [NTSB CEN12CA215](https://openairdocs.org/ntsb/CEN12CA215.md): Cessna 441 · Battle Creek, MI · Accident · No injuries · Data collection · Final report · Mar 27, 2012 · N1212C · Substantial damage
  > The maintenance technician did not remove the tow bar prior to the flight.
- [NTSB ERA11IA172](https://openairdocs.org/ntsb/ERA11IA172.md): Mitsubishi MU-2B-20 · Walterboro, SC · Incident · No injuries · Incident investigation · Final report · Jan 16, 2011 · N52CD · Minor damage
  > The inadequate inspection and rigging of the nose landing gear downlock mechanism by maintenance personnel, which resulted in the failure of a bolt and the subsequent collapse of the nose gear during the landing roll.

## 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 ('01514', '01517')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e."isDefiningEvent" AND e."tier2Number" = '094'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-events/094/cases?engine=01514

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