NTSB investigations, SC
13 cases where NTSB found Incorrect action performance.
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 1 |
| 2010 | 1 |
| 2011 | 2 |
| 2012 | 2 |
| 2014 | 1 |
| 2017 | 1 |
| 2018 | 1 |
| 2019 | 2 |
| 2020 | 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\", '02041015'))
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", '02041015')) 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 ERA20CA249Accident · No injuriesClass 4 · Data collectionFinal reportCessna 172 · Pickens, SCThe student pilot's improper landing flare and improper recovery from a bounced landing, which resulted in a hard landing.NTSB ERA20LA006Accident · No injuriesClass 3 · LimitedFinal reportHonda HA-420 · Charleston, SCGround personnel’s use of an improper towbar adapter lug, which prevented the nose landing gear from extending.NTSB GAA19CA416Accident · No injuriesData collectionFinal reportThomas Wild Avid · York, SCThe pilot's inadvertent reduction of power during the initial climb, which resulted in an aerodynamic stall. Contributing to the pilot’s inadvertent reduction of power was his lack of experience with his left hand on the control stick and right hand on the…NTSB ERA18LA213Accident · No injuriesLimited investigationFinal reportPiper PA46 · West Columbia, SCThe pilot’s inadvertent navigation onto a service road instead of a taxiway, which resulted in a collision with a stop sign.NTSB ERA18LA054Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Ridgeland, SCThe student pilot’s improper control inputs, which resulted in a loss of control on takeoff. Contributing to the accident was the flight instructor’s inadequate remedial action.NTSB ERA14CA210Accident · Minor injuriesData collectionFinal reportJerome A Baak CH 601XL · Sumter, SCThe total loss of engine power due to fuel exhaustion. Contributing to the fuel exhaustion was the pilot's failure during the building process to properly determine the unusable quantity of fuel.NTSB ERA12LA498Accident · Serious injuriesLimited investigationFinal reportEmbraer ERJ 170-200 LR · Hilton Head, SCThe passenger’s failure to adhere to flight and cabin crewmembers’ instructions to remain seated in anticipation of adverse weather and turbulence along the airplane’s flight path.NTSB ERA12CA228Accident · Minor injuriesData collectionFinal reportPiper PA-28-151 · Charleston, SCThe pilot's improper landing flare, which resulted in a hard landing.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 ERA11CA223Accident · No injuriesData collectionFinal reportCessna 177 · Columbia, SCThe pilot's improper landing flare, which resulted in a hard landing.NTSB ERA10CA300Accident · Minor injuriesData collectionFinal reportPiper PA-18-135 · North Myrtle Beach, SCThe pilot’s failure to maintain adequate airspeed during a climbing turn, which resulted in an aerodynamic stall.NTSB ERA09CA373Accident · No injuriesData collectionFinal reportCessna 152 · Mt. Pleasant, SCThe pilot's improper recovery from a bounced landing.NTSB MIA08CA155Accident · No injuriesData collectionFinal reportCubcrafter CC11-100 · Gilbert, SCThe pilot's improper use of brakes during landing roll resulting in a nose-over.