NTSB investigations, 2011, SC
13 cases where the sequence of events included Collision with terr/obj (non-CFIT).
Cases per year
| 2008 | 5 |
|---|---|
| 2009 | 12 |
| 2010 | 11 |
| 2011 | 13 |
| 2012 | 6 |
| 2013 | 9 |
| 2014 | 9 |
| 2015 | 8 |
| 2016 | 8 |
| 2017 | 6 |
| 2018 | 14 |
| 2019 | 11 |
| 2020 | 4 |
| 2021 | 4 |
| 2022 | 6 |
| 2023 | 6 |
| 2024 | 1 |
| 2025 | 5 |
| 2026 | 3 |
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 year(c.\"eventDate\") = 2011
AND 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\" = '470' 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 year(c."eventDate") = 2011 AND 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" = '470' 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 ERA12FA051Accident · 1 fatalField investigationFinal reportCessna 150F · Moncks Corner, SCThe debilitating effects of ethylene glycol poisoning, which resulted in the pilot’s inability to maintain control of the airplane.NTSB ERA11CA445Accident · No injuriesData collectionFinal reportPiper PA-32RT-300 · Charleston, SCThe pilot's decision to continue the approach and landing at a high airspeed, which resulted in an improper touchdown point and subsequent runway excursion.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 ERA11CA373Accident · No injuriesData collectionFinal reportLeatherman Karl L Zodiac CH 601 HDS · Gray Court, SCThe total loss of engine power due to the failure of the radiator coolant supply fitting.NTSB ERA11CA339Accident · No injuriesData collectionFinal reportKendall W R/Mclaughlin J Rans S-10 Sakota · Bennettsville, SCThe pilot's inadequate preflight familiarization of the airstrip.NTSB ERA11CA324Accident · Minor injuriesData collectionFinal reportAeronca 7AC · Honea Path, SCThe student pilot's loss of control during the takeoff.NTSB ERA11LA292Accident · No injuriesLimited investigationFinal reportFlight Design Ctls · Troy, SCThe pilots’ failure to ensure that the airplane had enough fuel to complete the planned flight, which resulted in a total loss of engine power due to fuel exhaustion.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 ERA11LA208Accident · 1 fatalLimited investigationFinal reportJennings John C Mini Max · Clinton, SCThe pilot's inadequate performance planning, which resulted in a collision with a tree during takeoff.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 ERA11LA173Accident · No injuriesLimited investigationFinal reportGlobe GC-1B · Anderson, SCThe total loss of engine power due to the formation of carburetor ice.NTSB ERA11FA118Accident · 2 fatalField investigationFinal reportCessna 172S · North Myrtle Beach, SCThe pilot's loss of airplane control during a missed approach due to spatial disorientation.NTSB ERA11CA109Accident · No injuriesData collectionFinal reportPiper PA-28-235 · Lancaster, SCThe pilot's failure to maintain directional control during an attempted go-around maneuver after landing.