NTSB investigations, SC
8 cases where the defining event was Landing gear collapse.
Cases per year
| 2011 | 1 |
|---|---|
| 2014 | 2 |
| 2017 | 1 |
| 2021 | 1 |
| 2025 | 2 |
| 2026 | 1 |
Where
Open the mapLatest cases
Query with SQL
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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '094')
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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '094') 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 ERA26LA104Accident · No injuriesClass 4 · LimitedFinal reportCessna 150L · Gantt, SCThe student pilot’s improper landing flare, which resulted in a bounced landing, and a nose landing gear collapse.NTSB ERA25LA298Accident · No injuriesClass 4 · LimitedFinal reportPaschal JR Roy E Velocity XL RG · Columbia, SCA landing gear collapse during landing.NTSB ERA25LA165Accident · No injuriesClass 3 · LimitedPreliminary reportCessna S550 · Hilton Head Island, SCOn March 19, 2025, about 1445 eastern daylight time, a Cessna S550 airplane, N627HS, was substantially damaged when it was involved in an accident near Hilton Head Island, South Carolina. The airline transport pilot and passenger were not injured. The…NTSB ERA22LA005Accident · No injuriesClass 4 · LimitedFinal reportCessna 210 · Columbia, SCA failure of the landing gear hydraulic power pack for reasons that could not be determined.NTSB ERA17LA258Accident · No injuriesLimited investigationFinal reportKubassek David Zenith 601 · Aiken, SCThe failure of the nose landing gear’s (NLG) lower bearing, which resulted in the pilot’s inability to maintain directional control during landing, a runway excursion, and the NLG collapsing.NTSB ERA14CA200Accident · No injuriesData collectionFinal reportKaldor Gregory N Zenith 701 · Eutaw Springs, SCThe pilot's improper decision to execute a precautionary landing to unsuitable terrain following an inflight encounter with a wind gust, resulting in substantial damage to the airplane.NTSB ERA14LA170Accident · No injuriesLimited investigationFinal reportCessna 421 · Charleston, SCInadequate maintenance, which resulted in the collapse of the right main landing gear during landing.NTSB ERA11IA172Incident · No injuriesIncident investigationFinal reportMitsubishi MU-2B-20 · Walterboro, SCThe inadequate inspection and rigging of the nose landing gear downlock mechanism by maintenance personnel, which resulted in the failure of a bolt and the subsequent collapse of the nose gear during the landing roll.