NTSB investigations, 2001, SD
180,604 investigations by the National Transportation Safety Board since 1962: 174,583 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\") = 2001
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") = 2001 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 CHI01LA306Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Pierre, SDThe pilot not maintaining directional control of the airplane during landing.NTSB CHI01LA262Accident · No injuriesLimited investigationFinal reportGrice Avid Flyer · Belle Fourche, SDThe pilot failed to maintain aircraft control during the forced landing. A factor associated with the accident was the excessive adjustment that the pilot made to the propeller's pitch prior to the flight.NTSB CHI01LA251Accident · Serious injuriesLimited investigationFinal reportAero Commander S2R · Pierre, SDclearance not obtained by the pilot. A contributing factor was the transmission line.NTSB CHI01LA254Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Wall, SDThe student pilot failed to maintain a proper glidepath, failed to obtain proper climb rate, and executed the go-around improperly. Additional factors included the pilot's lack of experience, the crop, and the soft, wet ground.NTSB CHI01LA253Accident · No injuriesLimited investigationFinal reportCessna 150M · Rapid City, SDThe student solo pilot failed to compensate for the wind conditions. Factors included the high wind, gusts, and tailwind.NTSB CHI01LA210Accident · No injuriesLimited investigationFinal reportCessna 140 · Spearfish, SDThe pilot failed to maintain directional control of the airplane during the landing. Factors associated with the accident were the pilot's inadequate recovery from a bounced landing and his lack of experience in the make and model of the accident airplane.NTSB CHI01LA151Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-402B · Mount Vernon, SDthe pilot not maintaining aircraft control while maneuvering close to the ground.NTSB CHI01FA113Accident · 3 fatalField investigationFinal reportBeech 95-B55 · Norris, SDThe pilot encountering instrument meteorological conditions and his subsequent loss of control of the airplane.NTSB CHI01LA082Accident · Serious injuriesLimited investigationFinal reportBeech 65-B80 · Sioux Falls, SDThe pilot initiated the flight into known icing conditions which resulted in his ability to maintain control of the airplane. Factors associated with the accident were the ice accumulation and the company induced pressure for the pilot to make the flight into…NTSB CHI01LA086Accident · No injuriesLimited investigationFinal reportCessna 310Q · Mitchell, SDThe pilot disregarded the aircraft limitation placard, and attempted flight into known adverse weather after receiving a hazardous weather advisory. Factors to the accident were the ice-covered cockpit windshield, the ice-covered runway, and the snowbank.NTSB CHI01LA060Accident · No injuriesLimited investigationFinal reportCessna 172S · Sioux Falls, SDAircraft directional control not being maintained by the student pilot during the takeoff roll. Factors to the accident were the snow bank and the student pilot's lack of total experience.