# NTSB investigations, SC: 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 ATL87LA133](https://openairdocs.org/ntsb/ATL87LA133.md): Beech E-55 · Spartanburg, SC · Accident · No injuries · Limited investigation · Final report · May 6, 1987 · N713DM · Substantial damage
  > The plt reported that he lowered the ldg gear and observed a down-and-locked indication on the ldg gear position light on final appch. During rollout, he felt a severe vibration in the nose gear and pulled back on the yoke in an attempt to reduce it. He then…
- [NTSB ATL84LA152](https://openairdocs.org/ntsb/ATL84LA152.md): Beech E55 · Charleston, SC · Accident · No injuries · Limited investigation · Final report · Apr 25, 1984 · N85052 · Substantial damage
  > After the landing the acft landing gear retracted during a period of maximum braking to avoid an arresting cable. During the examination of the landing gear door damage it was determined that the landing gear was retracted during the landing roll.
- [NTSB ATL84LA142](https://openairdocs.org/ntsb/ATL84LA142.md): Aero Commander 560F · Hilton, SC · Accident · No injuries · Limited investigation · Final report · Apr 7, 1984 · N6368U · Substantial damage
  > The acft was landed with the gear retracted. The nose gear light indicating down remained'on' at all itmes but had no bearing on the landing gear extension/retraction system. The plt did not report using a checklist or lowering the landing gear. The landing…
- [NTSB ATL84LA037](https://openairdocs.org/ntsb/ATL84LA037.md): Beech BE-58P · Beaufort, SC · Accident · No injuries · Limited investigation · Final report · Nov 4, 1983 · N3688E · Substantial damage
  > The plt stated that he started having problems with various eletrically operated components during the latter part of the flt. During descent into Beaufort, he lost the ability to transmit and communicated to ATC by transponder. The plt said he put the gear…
- [NTSB ATL83LA090](https://openairdocs.org/ntsb/ATL83LA090.md): Piper PA-30 · Greenville, SC · Accident · No injuries · Limited investigation · Final report · Jan 13, 1983 · N7737Y · Substantial damage
  > The aircraft landing gear collapsed during landing rollout. The pilot stated that he raised the gear instead of the flaps during the landing roll.
- [NTSB ATL83LA010](https://openairdocs.org/ntsb/ATL83LA010.md): Beech 95-B55 · Camden, SC · Accident · No injuries · Limited investigation · Final report · Oct 16, 1982 · N4186S · Substantial damage
  > According to the pilot, he received landing information from the UNICOM operator for runway 7. He was advised to keep the pattern tight to accommodate heavy traffic at the airport. While expediting to get off the runway after landing, he reached to retract…

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

This list as a web page: https://openairdocs.org/ntsb?occurrence=194&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.
