NTSB investigations, 2003, 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
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\") = 2003
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") = 2003 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 CHI04LA040Accident · No injuriesLimited investigationFinal reportClement-Kazmierczak Sorrell SNS-7 · Highmore, SDThe unsuitable terrain for landing encountered by the pilot. Contributing factors were the grass runway surface and the snowbank.NTSB CHI03LA299Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · South Shore, SDA loss of engine power for undetermined reasons. A factor was the soft terrain encountered during the forced landing.NTSB CHI03IA300Incident · No injuriesIncident investigationFinal reportCessna 650 · Rapid City, SDThe in-flight failure of the right wing aileron cable during cruise.NTSB CHI03LA271Accident · No injuriesLimited investigationFinal reportCessna 188A · Freeman, SDThe pilot's failure to maintain directional control and clearance during landing roll. Additional factors included the pilot's improper recovery from a bounced landing, the crosswind and the corn crop.NTSB CHI03LA254Accident · No injuriesLimited investigationFinal reportWeatherly 620A · Doland, SDThe pilot's failure to maintain clearance from the wires and directional control not being possible due to the failure of the brake system. Factors contributing to the accident were the wires, the trees, and the failure of the brake system.NTSB CHI03LA249Accident · No injuriesLimited investigationFinal reportNorth American AT-6D · Brookings, SDThe inadequate fuel supply for the flight, and the inadequate preflight by the pilot resulting in exhaustion of the fuel supply and subsequent loss of engine power. The tree was a contributing factor.NTSB CHI03LA243Accident · Minor injuriesLimited investigationFinal reportRockwell International S-2R · Mitchell, SDThe pilot's inadequate visual lookout and not maintaining clearance from the power line during the low level aerial application maneuver. A related factor was the power line.NTSB CHI03LA178Accident · No injuriesLimited investigationFinal reportChampion 7GCBC · Buffalo, SDThe instructor pilot's inadequate remedial action to the dual student's loss of aircraft control during high speed taxiing which lead to the inadvertent ground loop/swerve. A factor was the student not maintaining aircraft control.NTSB CHI03LA227Accident · 1 fatalLimited investigationFinal reportUllrich Auriga FT · Aberdeen, SDA loss of engine power due to the lack of design fuel pressure for undetermined reasons.NTSB CHI03LA199Accident · No injuriesLimited investigationFinal reportAviat A-1B · Okobojo, SDThe failure of the float strut during a water landing.NTSB CHI03LA197Accident · No injuriesLimited investigationFinal reportCessna 175 · Wessington Spri, SDThe pilot not obtaining/maintaining clearance from the barbed wire fence during the go-around. Factors to the accident were the fence, and the brush.NTSB CHI03LA154Accident · Minor injuriesLimited investigationFinal reportBraunschmidt RV-6A · Tea, SDThe loss of engine power for undetermined reasons and the unsuitable terrain for landing encountered. Contributing factors to this accident were the crop and the collapse of the nose landing gear strut.NTSB CHI03FA141Accident · 1 fatalField investigationFinal reportCessna 182Q · Gettysburg, SDThe pilot not maintaining aircraft control in cruise flight leading to his inadvertent spiral. A factor was the pilot's in-flight encounter with moderate to heavy rain.NTSB CHI03LA133Accident · 1 fatalLimited investigationFinal reportAir & Space 18A · South Shore, SDThe pilot's failure to maintain clearance from the terrain. The pilot's lack of experience, the rain, the dark night, the low ceiling, and the rising terrain were contributing factors to the accident.NTSB CHI03LA131Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Pierre, SDThe pilot's failure to maintain adequate airspeed which resulted in a stall. A contributing factor was the collapse of the main landing gear.NTSB CHI03LA109Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Red Owl, SDThe pilot not maintaining aircraft control during initial climb-out, resulting in the encountered stall.