NTSB investigations, 2025, SD
180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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
| 1962 | 1 |
|---|---|
| 1964 | 40 |
| 1965 | 43 |
| 1966 | 42 |
| 1967 | 46 |
| 1968 | 39 |
| 1969 | 35 |
| 1970 | 37 |
| 1971 | 30 |
| 1972 | 27 |
| 1973 | 20 |
| 1974 | 28 |
| 1975 | 35 |
| 1976 | 21 |
| 1977 | 44 |
| 1978 | 38 |
| 1979 | 27 |
| 1980 | 24 |
| 1981 | 28 |
| 1982 | 18 |
| 1983 | 22 |
| 1984 | 22 |
| 1985 | 15 |
| 1986 | 14 |
| 1987 | 11 |
| 1988 | 11 |
| 1989 | 6 |
| 1990 | 16 |
| 1991 | 12 |
| 1992 | 9 |
| 1993 | 11 |
| 1994 | 10 |
| 1995 | 12 |
| 1996 | 11 |
| 1997 | 12 |
| 1998 | 14 |
| 1999 | 8 |
| 2000 | 12 |
| 2001 | 11 |
| 2002 | 8 |
| 2003 | 16 |
| 2004 | 10 |
| 2005 | 9 |
| 2006 | 5 |
| 2007 | 10 |
| 2008 | 9 |
| 2009 | 8 |
| 2010 | 8 |
| 2011 | 13 |
| 2012 | 15 |
| 2013 | 8 |
| 2014 | 7 |
| 2015 | 9 |
| 2016 | 8 |
| 2017 | 7 |
| 2018 | 9 |
| 2019 | 11 |
| 2020 | 7 |
| 2021 | 2 |
| 2022 | 7 |
| 2023 | 6 |
| 2024 | 5 |
| 2025 | 10 |
| 2026 | 5 |
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\") = 2025
AND c.\"eventStateOrRegion\" = 'SD' AND c.\"eventCountry\" = 'USA'
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") = 2025 AND c."eventStateOrRegion" = 'SD' AND c."eventCountry" = 'USA' 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 CEN26LA019Accident · No injuriesClass 4 · LimitedFinal reportBellanca 7GCBC · Bonilla, SDThe pilot’s inadequate flight planning and his failure to maintain aircraft control during the precautionary off-airport landing.NTSB CEN25LA368Accident · Minor injuriesClass 3 · LimitedPreliminary reportBeech 35-C33 · Brookings, SDOn September 6, 2025, about 0859 central daylight time, a Beech 35-C33 airplane, N1310A, was destroyed when it was involved in an accident near Brookings, South Dakota. The pilot and two passengers sustained minor injuries. The airplane was operated as a…NTSB CEN25FA289Accident · 1 fatalClass 3 · FieldPreliminary reportPiper PA-22-150 · New Underwood, SDOn July 28, 2025, about 0604 mountain daylight time, a Piper PA-22-150 airplane, N9642D, was substantially damaged when it was involved in an accident near New Underwood, South Dakota. The pilot was seriously injured and the passenger sustained fatal…NTSB CEN25LA288Accident · No injuriesClass 3 · LimitedPreliminary reportPiper PA-28RT-201T · Brookings, SDOn July 26, 2025, at 1840 central daylight time, a Piper PA-28RT-201T airplane, N8423H, was substantially damaged when it was involved in an accident near Brookings, South Dakota. The airline transport pilot and passenger were uninjured. The airplane was…NTSB CEN25LA315Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Faith, SDThe pilot's failure to maintain directional control during the landing roll with crosswind.NTSB CEN25FA248Accident · 1 fatalClass 3 · FieldPreliminary reportPiper PA-25 · Hot Springs, SDOn July 12, 2025, about 1322 mountain daylight time, a Piper PA-25, N8186K, was substantially damaged when it was involved in an accident near Hot Springs, South Dakota. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal…NTSB CEN25LA221Accident · Serious injuriesClass 4 · LimitedFinal reportAir Tractor AT-402B · Pierre, SDThe pilot’s failure to maintain clearance with the power lines while maneuvering that resulted in an in-flight collision with the power lines and impact with terrain.NTSB CEN25LA218Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-36-375 · Huron, SDThe pilot’s exceedance of the airplane’s critical angle of attack during a low-level aerial application, which resulted in an aerodynamic stall and loss of airplane control at too low of an altitude to recover.NTSB CEN25LA105Accident · Serious injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 II · Edgemont, SDThe pilot’s failure to properly identify the proper anchor point for the supplemental harness and the crew’s incorrect use of the restraint system structure as an anchor point, which resulted in the separation of the structure.NTSB CEN25LA069Accident · No injuriesClass 3 · LimitedFinal reportCirrus Design SF50 · Spearfish, SDThe pilot’s failure to land on the centerline of the snow-covered runway at night, which resulted in the left wing impacting a snowbank, a subsequent loss of directional control, and runway excursion.