NTSB investigations, 2007, SD
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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\") = 2007
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") = 2007 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 CHI08CA029Accident · No injuriesData collectionFinal reportCessna 172R · Brookings, SDThe student pilot's failure to maintain directional control during takeoff roll. Contributing to the accident was the student pilot's lack of solo flight experience and the runway sign.NTSB CHI07TA241Accident · Minor injuriesFinal reportChristen Industries A-1 · Elm Springs, SDThe pilot not maintaining clearance from the rising terrain. A factor contributing to the accident was the rising terrain.NTSB CHI07LA317Accident · Serious injuriesLimited investigationFinal reportAerostar International S81A · Custer, SDThe high wind during landing. Contributing to the accident was the encounter with adverse weather during the flight.NTSB CHI07CA216Accident · No injuriesData collectionFinal reportCessna 180 · Madison, SDThe tailwheel vibrations during the landing roll that resulted in the tailwheel spring disconnect. Directional control was not possible and the grassy terrain were factors.NTSB CHI07TA201Accident · Minor injuriesFinal reportWSK PZL Mielec PZL M18B · Kyle, SDThe pilot's failure to maintain clearance from terrain during an aerial application maneuver. Contributing to the accident were wind gusts, low altitude, and the reported downdraft.NTSB CHI07CA155Accident · No injuriesData collectionFinal reportChampion 7EC · Sioux Falls, SDThe pilot's inadequate compensation for the wind conditions and the excessive pull-up during the initial takeoff climb which resulted in the stall. A factor associated with the accident was the crosswind condition.NTSB CHI07LA147Accident · 1 fatalLimited investigationFinal reportThrush S2RHG-T65 · Tyndall, SDThe pilot not maintaining altitude/clearance from a powerline while maneuvering. A factor was the low visibility associated with the thunderstorm and the powerlines.NTSB CHI07CA148Accident · No injuriesData collectionFinal reportCessna A188 · Scotland, SDThe pilot not maintaining adequate airspeed during takeoff, which resulted in an inadvertent stall. Factors contributing to the accident were the sudden wind shift and the low altitude at which the stall occurred.NTSB CHI07CA122Accident · No injuriesData collectionFinal reportCessna 140 · Winner, SDThe pilot's excessive use of braking during the landing roll, causing the aircraft to nose over.NTSB CHI07CA061Accident · No injuriesData collectionFinal reportPiper J3C-65 · White Lake, SDThe pilot's inadequate compensation for the crosswind conditions during the landing roll, which resulted in a loss of control and a nose over. A factor associated with the accident was the crosswind.