Fatal NTSB investigations, SC
11 cases where the sequence of events included Aerodynamic stall/spin.
Cases per year
| 2009 | 1 |
|---|---|
| 2010 | 1 |
| 2011 | 2 |
| 2012 | 1 |
| 2013 | 1 |
| 2014 | 1 |
| 2021 | 1 |
| 2022 | 1 |
| 2023 | 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.\"highestInjuryLevel\" = 'Fatal'
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '241' 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."highestInjuryLevel" = 'Fatal' AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '241' 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 ERA23LA342Accident · 2 fatalClass 3 · LimitedFinal reportBeech C23 · Greer, SCA partial loss of engine power during the initial climb due to the formation of carburetor ice, resulting in reduced climb capability. Contributing to the accident was the pilot’s failure to maintain proper airspeed during the emergency descent, which…NTSB ERA23FA280Accident · 5 fatalClass 3 · FieldFinal reportPiper PA-32R-300 · North Myrtle Beach, SCThe pilot’s loss of control during initial climb, which resulted in an aerodynamic stall and impact with terrain. Contributing to the accident was the pilot’s operation of the airplane above its maximum gross weight and near its aft center of gravity limit,…NTSB ERA22FA243Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-12 · North Myrtle Beach, SCThe pilot's exceedance of the airplane's critical angle of attack, which resulted in a subsequent aerodynamic stall at an altitude that was too low for recovery.NTSB ERA22FA047Accident · 1 fatalClass 3 · FieldFinal reportPiper PA30 · Rock Hill, SCThe pilot’s exceedance of the airplane's critical angle of attack while troubleshooting a landing gear indication, which resulted in an aerodynamic stall at low altitude.NTSB ERA14FA144Accident · 3 fatalField investigationFinal reportRogers George T Lancair IVP · Hartsville, SCFailure of the flying pilot to maintain control of the airplane while maneuvering at a low altitude, which resulted in the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall. Contributing to the accident were the…NTSB ERA13FA295Accident · 2 fatalField investigationFinal reportRockwell International 690B · McClellanville, SCThe pilot’s loss of airplane control during high-altitude maneuvering and his subsequent failure to recover airplane control. Contributing to the accident was the flight instructor’s inadequate supervision of the pilot and his failure to perform remedial…NTSB ERA12FA303Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · Anderson, SCThe pilot's failure to maintain control of the airplane during the aborted landing, which resulted in an aerodynamic stall and impact with terrain.NTSB ERA11FA210Accident · 1 fatalField investigationFinal reportPiper PA-20 · Elgin, SCA total loss of engine power due to fuel exhaustion resulting from the pilot’s inadequate preflight planning. Contributing to the accident was that the pilot did not maintain an adequate airspeed, which resulted in an aerodynamic stall.NTSB ERA11FA151Accident · 1 fatalField investigationFinal reportCessna 150E · Ware Shoals, SCThe non-certificated pilot's impairment due to alcohol and a sedating antihistamine, which resulted in his failure to maintain airspeed and the subsequent aerodynamic stall and ground impact.NTSB ERA10LA199Accident · 1 fatalLimited investigationFinal reportRatcliffe John A Kolb MARK3X · Charleston, SCThe pilot's failure to maintain adequate airspeed which resulted in an aerodynamic stall and subsequent loss of control. Contributing to the accident was the pilot's lack of experience in the make and model airplane.NTSB ERA09FA235Accident · 1 fatalField investigationFinal reportGrumman AA-1B · Chesnee, SCA loss of engine power in flight due to fuel starvation as a result of the pilot's inadequate inflight fuel planning and the pilot's failure to maintain airspeed while descending for a forced landing.