# NTSB investigations, SC: 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 ATL04LA092](https://openairdocs.org/ntsb/ATL04LA092.md): Cessna 140 · Greenville, SC · Accident · No injuries · Limited investigation · Final report · Apr 8, 2004 · N527ST · Substantial damage
  > Fatigue failure of the leaf spring gear strut.
- [NTSB ATL86LA043](https://openairdocs.org/ntsb/ATL86LA043.md): Piper PA-31T · Spartanburg, SC · Accident · No injuries · Limited investigation · Final report · Dec 16, 1985 · N4445K · Substantial damage
  > During landing roll the landing gear collapsed and the acft skidded to a stop on the rwy. The acft was substantially damaged and the plt was not injured. A witness stated that he observed the landing gear in the down position while the acft was in the traffic…
- [NTSB ATL85LA148](https://openairdocs.org/ntsb/ATL85LA148.md): Beech 58 · Hilton Head, SC · Accident · No injuries · Limited investigation · Final report · Apr 25, 1985 · N679BL · Destroyed
  > The plt stated that the landing gear selector was placed in the down position while on downwind for ldg & upon touchdown the landing gear collapsed. Post crash examination of the landing gear failed to disclose any mechanical failure or malfunction of the…
- [NTSB ATL83LA098](https://openairdocs.org/ntsb/ATL83LA098.md): Piper PA-30 · Charleston, SC · Accident · No injuries · Limited investigation · Final report · Feb 6, 1983 · N1810M · Substantial damage
  > The plt stated that the landing gear collapsed after acft had rolled aprx 1200 ft during the landing. An exam of the acft revealed that the gear retraction transmission was torn out of its fuselage bulkhead mount, the landing gear push-pull cable rod ends…

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

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

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