# NTSB investigations, 2007: 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 SEA08LA029](https://openairdocs.org/ntsb/SEA08LA029.md): Piper PA-44-180 · Byron, CA · Accident · No injuries · Limited investigation · Final report · Nov 14, 2007 · N274ER · Substantial damage
  > The failure of the right main landing gear aft trunnion attach fitting due to overload during the landing roll.
- [NTSB DEN07LA156](https://openairdocs.org/ntsb/DEN07LA156.md): Cessna 402B · Hobbs, NM · Accident · No injuries · Limited investigation · Final report · Sep 10, 2007 · N402BF · Substantial damage
  > The failure of the left main landing gear down lock due to overload causing the main landing gear to collapse.
- [NTSB CHI07CA285](https://openairdocs.org/ntsb/CHI07CA285.md): Navion Navion H · Atlantic, IA · Accident · No injuries · Data collection · Final report · Aug 30, 2007 · N2540T · Substantial damage
  > The pilot's improper flare and touchdown during landing resulting in overload failure of the left main landing gear. A contributing factor was the pilot's distraction due to the unlatched cabin door.
- [NTSB DFW07CA128](https://openairdocs.org/ntsb/DFW07CA128.md): Doggett Jack Samson · Conroe, TX · Accident · No injuries · Data collection · Final report · Jun 1, 2007 · N985JD · Substantial damage
  > The failure of the main landing gear for undetermined reasons.
- [NTSB CHI07LA159](https://openairdocs.org/ntsb/CHI07LA159.md): Cessna 340A · Middleton, WI · Accident · No injuries · Limited investigation · Final report · May 30, 2007 · N17MH · Substantial damage
  > Failure of the right main landing gear extension and retraction linkage, which allowed the gear assembly to collapse during landing rollout. An additional cause was the improper adjustment procedure(s) by undetermined mechanic(s). The runway lights struck…

## 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 year(c."eventDate") = 2007
  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&year=2007

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