NTSB investigations, SC

4 cases where the first occurrence was “Gear collapsed”.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19832026

NTSB investigations, SC per year, 1983–2026: 4 cases
1983	1
1985	2
2004	1

Where

Open the map

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" = 190) 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\" = 190)
  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" = 190)
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 ATL04LA092Accident · No injuriesLimited investigationFinal reportCessna 140 · Greenville, SCFatigue failure of the leaf spring gear strut.Apr 8, 2004 · N527ST · Substantial damage NTSB ATL86LA043Accident · No injuriesLimited investigationFinal reportPiper PA-31T · Spartanburg, SCDuring 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…Dec 16, 1985 · N4445K · Substantial damage NTSB ATL85LA148Accident · No injuriesLimited investigationFinal reportBeech 58 · Hilton Head, SCThe 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…Apr 25, 1985 · N679BL · Destroyed NTSB ATL83LA098Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Charleston, SCThe 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…Feb 6, 1983 · N1810M · Substantial damage