NTSB investigations, SC
15 cases where the sequence of events included Attempted remediation/recovery.
Cases per year
| 2015 | 1 |
|---|---|
| 2016 | 4 |
| 2018 | 5 |
| 2019 | 3 |
| 2022 | 2 |
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '060' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '060' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 ERA22LA337Accident · No injuriesClass 4 · LimitedFinal reportBell 206B · Pelion, SCThe pilot’s improper landing flare during a practice autorotation.NTSB ERA22LA201Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Union, SCThe pilot’s failure to maintain directional control during the landing roll, which resulted in a runway excursion and impact with terrain.NTSB GAA19CA194Accident · Minor injuriesData collectionFinal reportCessna 172 · Clemson, SCThe pilot's failure to maintain directional control during the landing roll and his exceedance of the airplane's critical angle of attack when it inadvertently became airborne, which resulted in an aerodynamic stall.NTSB GAA19CA152Accident · No injuriesData collectionFinal reportCessna 185 · Ridgeland, SCThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and impact with a ditch.NTSB GAA19CA144Accident · No injuriesData collectionFinal reportMooney M20J · Ridgeland, SCThe flight instructor's failure to retract the flaps during an attempted go-around and his failure to maintain the runway heading, which resulted in a collision with terrain left of the runway.NTSB GAA19CA083Accident · No injuriesData collectionFinal reportSmith AEROSTAR601 · Rock Hill, SCThe pilot's improper decision to fly with an air cast boot on his foot, which led him to rely on the passenger to apply brakes and rudder, which was performed improperly and led to a loss of directional control.NTSB ERA19LA029Accident · No injuriesLimited investigationFinal reportDiamond DA20 · Mountain Rest, SCA partial loss of engine power due to multiple discrepancies of the engine's ignition system.NTSB GAA18CA434Accident · No injuriesData collectionFinal reportClassic Waco · North Myrtle Beach, SCThe pilot's failure to maintain directional control during landing in a left quartering headwind.NTSB GAA18CA225Accident · No injuriesData collectionFinal reportRepublic RC 3 · Pelion, SCThe pilot’s failure to maintain directional control during landing in gusting crosswind conditions.NTSB GAA18LA131Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R22 · Charleston, SCThe flight instructor’s abrupt evasive maneuver to avoid a reported unmanned aerial system, which resulted in a loss of forward airspeed and settling with power and a subsequent collision with trees and terrain.NTSB GAA16CA478Accident · No injuriesData collectionFinal reportCessna 180 · Clemson, SCThe pilot’s loss of directional control during the takeoff roll, which resulted in a runway excursion.NTSB GAA16CA306Accident · Minor injuriesData collectionFinal reportS.O.C.A.T.A. Rallye 150 · York, SCThe pilot's failure to maintain directional control during takeoff, which resulted in an impact with a peach tree(s).NTSB GAA16CA181Accident · No injuriesData collectionFinal reportCessna 172 · Orangeburg, SCThe pilot's failure to maintain directional control during the takeoff, resulting in a runway excursion and a nose over.NTSB GAA16CA170Accident · No injuriesData collectionFinal reportWaco CTO · Ridgeland, SCThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground loop.NTSB GAA15CA297Accident · No injuriesData collectionFinal reportCzech Sport Piper Sport · Spartanburg, SCThe pilot's failure to maintain pitch control during the landing which resulted in a bounced landing, and an aerodynamic stall during the attempted recovery.