NTSB investigations, SC
9 cases where NTSB found Aircraft structures.
Cases per year
| 2008 | 1 |
|---|---|
| 2011 | 1 |
| 2012 | 1 |
| 2015 | 2 |
| 2020 | 1 |
| 2021 | 1 |
| 2022 | 1 |
| 2025 | 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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '0103'))
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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '0103')) 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 ERA25LA337Accident · No injuriesClass 4 · LimitedFinal reportLarocca Roch B Eracer MK II · Mount Pleasant, SCThe failure of the nose gear actuator bolt during the landing roll, which resulted in the collapse of the nose landing gear and subsequent runway excursion.NTSB ERA22LA116Accident · No injuriesClass 4 · LimitedFinal reportDehavilland DHC-2 · Gilbert, SCThe pilot’s improper flap setting, which resulted in a collision with trees during a takeoff attempt from a short grass field.NTSB ERA21LA379Accident · No injuriesClass 3 · LimitedFinal reportHawker Beechcraft 400A · Charleston, SCThe in-flight separation of the left engine’s four-panel cowling for reasons that could not be determined based on the available evidence.NTSB ERA20CA243Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA28 · Greenwood, SCThe pilot's failure to maintain adequate clearance from a parked airplane while taxiing. Contributing to the accident was the parked airplane's position over the double-yellow taxiway edge lines and into the taxiway object-free movement area.NTSB ERA16FA001Accident · 4 fatalField investigationFinal reportPiper PA32R · Westminster, SCThe pilot's loss of airplane control for reasons that could not be determined based on the available information.NTSB GAA15CA043Accident · No injuriesData collectionFinal reportShort Bros SD 360-300 · Greer, SCThe fuel truck driver's inattention, which resulted in backing over a warning cone and into the horizontal stabilizer of the airplane.NTSB ERA13LA061Accident · No injuriesLimited investigationFinal reportCessna 550 · Greenwood, SCCollision with a deer during the landing roll, which resulted in a compromised fuel tank and a postimpact fire.NTSB ERA11LA415Accident · 2 fatalLimited investigationFinal reportPolaris Polar Star · Dewees Island, SCThe non-certificated pilot’s operation of the unregistered airplane while impaired by alcohol. Contributing to the accident was the pilot’s performance of aerobatic maneuvers that exceeded the structural limits of the aircraft, which resulted in failure of…NTSB MIA08CA176Accident · Serious injuriesData collectionFinal reportCameron ZL-60 · Anderson, SCThe pilot's improper use of the balloon burners.