Final NTSB investigations, 2026, SC
180,658 investigations by the National Transportation Safety Board since 1962: 174,636 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
Cases per year
| 1964 | 46 |
|---|---|
| 1965 | 41 |
| 1966 | 58 |
| 1967 | 49 |
| 1968 | 62 |
| 1969 | 39 |
| 1970 | 51 |
| 1971 | 42 |
| 1972 | 58 |
| 1973 | 43 |
| 1974 | 49 |
| 1975 | 51 |
| 1976 | 39 |
| 1977 | 44 |
| 1978 | 56 |
| 1979 | 28 |
| 1980 | 29 |
| 1981 | 32 |
| 1982 | 52 |
| 1983 | 40 |
| 1984 | 35 |
| 1985 | 36 |
| 1986 | 25 |
| 1987 | 35 |
| 1988 | 41 |
| 1989 | 27 |
| 1990 | 23 |
| 1991 | 20 |
| 1992 | 31 |
| 1993 | 24 |
| 1994 | 30 |
| 1995 | 32 |
| 1996 | 19 |
| 1997 | 28 |
| 1998 | 28 |
| 1999 | 26 |
| 2000 | 19 |
| 2001 | 13 |
| 2002 | 21 |
| 2003 | 22 |
| 2004 | 20 |
| 2005 | 22 |
| 2006 | 17 |
| 2007 | 15 |
| 2008 | 20 |
| 2009 | 29 |
| 2010 | 19 |
| 2011 | 21 |
| 2012 | 21 |
| 2013 | 13 |
| 2014 | 13 |
| 2015 | 12 |
| 2016 | 15 |
| 2017 | 12 |
| 2018 | 21 |
| 2019 | 18 |
| 2020 | 13 |
| 2021 | 22 |
| 2022 | 21 |
| 2023 | 21 |
| 2024 | 10 |
| 2025 | 13 |
| 2026 | 8 |
Where
Latest 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\") = 2026
AND c.\"eventStateOrRegion\" = 'SC' AND c.\"eventCountry\" = 'USA'
AND c.\"completionStatus\" = 'Completed'
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") = 2026 AND c."eventStateOrRegion" = 'SC' AND c."eventCountry" = 'USA' AND c."completionStatus" = 'Completed' 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 ERA26LA359Accident · No injuriesClass 4 · LimitedFinal reportCessna 182P · Mount Pleasant, SCThe pilot’s failure to maintain directional control during landing, which resulted in a runway excursion.NTSB ERA26LA234Accident · Serious injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 · Mayesville, SCThe pilot’s failure to remain clear of a power line during an aerial application flight.NTSB ERA26LA199Accident · No injuriesClass 4 · LimitedFinal reportAlexander Schleicher ASW 27-18 · Greenwood, SCThe glider pilot’s encounter with a strong sink/loss of lift, which resulted in a forced landing to unsuitable terrain.NTSB ERA26LA157Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22T · Mount Pleasant, SCThe airplane’s encounter with uneven terrain during takeoff, which resulted in a runway excursion and impact with water.NTSB ERA26LA155Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Greenville, SCAn in-flight collision with a bird during cruise flight.NTSB ERA26LA154Accident · Minor injuriesClass 4 · LimitedFinal reportBeech V35 · Saluda, SCThe pilot’s failure to maintain control of the airplane during an aborted landing, which resulted in a runway excursion, collision with a fence, and a hard landing .NTSB ERA26LA132Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172L · Bennettsville, SCThe pilot’s failure to maintain clearance from trees on takeoff from a rural road.NTSB ERA26LA104Accident · No injuriesClass 4 · LimitedFinal reportCessna 150L · Gantt, SCThe student pilot’s improper landing flare, which resulted in a bounced landing, and a nose landing gear collapse.