Skip to content

NTSB investigations, SC

9 cases where the first occurrence was “Main gear collapsed”.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19822026

Where

Latest cases

Query with 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" = 191) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

duckdb -csv -c "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\" = 191)
  ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

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

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

NTSB ATL92LA164Accident · Minor injuriesLimited investigationFinal reportClassic Waco YMF-5 · Surfside Beach, SCThe failure of the main landing gear as a result of inadequate manufacturing.Aug 25, 1992 · N527MN · Substantial damage NTSB ATL89LA097Accident · No injuriesLimited investigationFinal reportCessna 180J · W. Columbia, SCImproper torquing of the attachment bolt during installation by unknown person(s), which resulted in the separation of the bolt and nut and subsequent separation of the main landing gear from the airplane.Mar 4, 1989 · N601RF · Substantial damage NTSB ATL88LA223Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Laurens, SCThe plt rprtd that when he landed, everything seemed normal until he was lowering the nose to the rwy drg the landing roll. At that time, the left wing began to settle. At first, he thought the left tire was going flat, but the settling continued.…Aug 1, 1988 · N8191J · Substantial damage NTSB ATL88LA080Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Florence, SCThe left main ldg gear collapsed during takeoff roll, following a touch & go ldg. The airplane subsequently veered into a snowbank. Post-crash examination of the airplane revealed that the left MLG truss bracket assy had pulled loose from the acft structure…Jan 16, 1988 · N268NA · Substantial damage NTSB ATL84LA281Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Cheraw, SCAccording to the plt, after 100 to 150 ft of landing roll the right main landing gear collapsed.Sep 16, 1984 · N14217 · Substantial damage NTSB ATL83LA367Accident · No injuriesLimited investigationFinal reportRockwell AC-112A · Batesburg, SCThe acft experienced a gear collapse during landing rollout. The pilot stated that the gear green lights were on prior to landing. The landing and rollout were uneventful until a right turn of 180 degrees was made. During the turn the left main gear folded…Sep 13, 1983 · N1423J · Substantial damage NTSB ATL83LA069Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Columbia, SCThe pilot landed on runway 23 with winds that were variable from 250 to 290 deg at 14 gusting 24 KTS. With these winds, the maximum crosswind component would have been about 21 KTS. The maximum demonstrated crosswind component for this aircraft was 15 KTS.…Dec 20, 1982 · N41336 · Substantial damage NTSB ATL82DA132Accident · No injuriesFinal reportCessna 310 · Allendale, SCThe pilot reported that before landing, the landing gear indicators showed that all gear were down and locked. However, on the landing roll-out, the left main gear collapsed as the nosewheel was lowered to the runway. Subsequently, the left wing, left…May 14, 1982 · N1831H · Substantial damage NTSB ATL82DA102Accident · No injuriesFinal reportPiper PA-31 · Clemson, SCDuring the preflight inspection the pilot noticed the hydraulically operated inboard main landing gear doors were open. Although realizing that they should be closed when the landing gear are fully extended, he pumped the doors up and taxied for takeoff.…Apr 15, 1982 · N7570L · Substantial damage