# NTSB investigations, TX: Complete 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 FTW87LA204](https://openairdocs.org/ntsb/FTW87LA204.md): Beech F50 · Terlingua, TX · Accident · No injuries · Limited investigation · Final report · Aug 18, 1987 · N5629D · Substantial damage
  > The owner, who occupied the right front seat, stated that he retracted the landing gear during the landing roll inadvertently instead of the flaps. The PIC never responded in writing concerning the actions he took during the accident.
- [NTSB FTW85LA231](https://openairdocs.org/ntsb/FTW85LA231.md): Piper PA-24-250 · Austin, TX · Accident · No injuries · Limited investigation · Final report · May 22, 1985 · N6665P · Substantial damage
  > The plt stated he felt the gear extend and the corresponding decrease in airspeed when the gear was lowered during the apch. He stated he thought he observed a green gear down indication and he did observe the shadow of the extended gear on the ground as the…
- [NTSB FTW85LA007](https://openairdocs.org/ntsb/FTW85LA007.md): Piper PA-30 · Amarillo, TX · Accident · No injuries · Limited investigation · Final report · Oct 7, 1984 · N8692Y · Substantial damage
  > During the lndg roll, all 3 lndg gear collapsed. The plt stated that on short final he inadvertantly retracted the gear instead of the flaps. He immediately cycled it back down butthe gear collapsed shortly after touchdown.
- [NTSB FTW85LA005](https://openairdocs.org/ntsb/FTW85LA005.md): Piper PA-28R-201T · Crowell, TX · Accident · No injuries · Limited investigation · Final report · Oct 5, 1984 · N6263C · Substantial damage
  > The plt stated that he lowered the landing gear on short final and that he received 3 green lights. During the landing roll a total gear collapse was experienced. A pilot witness on the ground stated that the nose gear did not appear to beextended when the…
- [NTSB FTW83LA385](https://openairdocs.org/ntsb/FTW83LA385.md): Piper PA-23 · Catarina, TX · Accident · No injuries · Limited investigation · Final report · Aug 13, 1983 · N3003P · Substantial damage
  > The acft was damaged when the landing gear was retracted during landing rollout at Catarina, TX. The plt identifed himself as larry day from chattanooga, TN. He claimed to have had engine trouble and was unable to extend the gear for landing. Post accident…
- [NTSB FTW83LA022](https://openairdocs.org/ntsb/FTW83LA022.md): Beech H35 · Abilene, TX · Accident · No injuries · Limited investigation · Final report · Oct 24, 1982 · N7937D · Substantial damage
  > The pilot stated that he extended the gear about 10 to 15 miles out to hold down the speed and descend. Before landing, he noted that none of his lights were working and he was unable to communicate with Abilene radio. Reportedly, he assumed the gear was down…

## 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" = 'TX' 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" = 194)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?occurrence=194&state=TX

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