NTSB investigations, SC
8 cases where the sequence of events included Unknown or undetermined.
Cases per year
| 2009 | 1 |
|---|---|
| 2010 | 1 |
| 2011 | 1 |
| 2022 | 2 |
| 2024 | 2 |
| 2026 | 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '000' 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" = '000' 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 ERA26FA341Accident · 1 fatalClass 3 · FieldPreliminary reportWeatherly 620 · Lynchburg, SCOn September 17, 2026, about 0720 eastern daylight time, a Weatherly Aviation Company Inc. 602B, N20003, was substantially damaged when it was involved in an accident near Lynchburg, South Carolina. The pilot was fatally injured. The airplane was operated as…NTSB ERA25LA051Accident · Minor injuriesClass 3 · LimitedFinal reportJames A Gray Just Aircraft Highlander · Fountain Inn, SCA total loss of engine power for undetermined reasons.NTSB ERA24LA080Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-28R-201 · Wiggins, SCA total loss of engine power for reasons that could not be determined.NTSB ERA22LA346Accident · Serious injuriesClass 3 · LimitedFinal reportTextron G36 · Ridgeland, SCA loss of engine power for reasons that could not be determined.NTSB ERA22LA168Accident · No injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 · Myrtle Beach, SCVibration in the airframe and flight controls for reasons that could not be determined based on the available evidence.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 ERA11LA071Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Bluffton, SCAn in-flight upset of undetermined origin resulting in a forced landing.NTSB ERA10FA024Accident · 4 fatalField investigationFinal reportPiper PA-23-250 · Summerville, SCFlight into terrain for undetermined reasons.