NTSB investigations, 2008, 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\") = 2008
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") = 2008 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 CEN09CA112Accident · No injuriesData collectionFinal reportCessna 140 · Highmore, SDThe pilot's failure to maintain directional control during the flare while landing in deep snow.NTSB CEN09CA026Accident · Minor injuriesData collectionFinal reportHolland Rotorway 162F · Rutland, SDThe loss of torque due to a failure of a transmission drivebelt and the pilot's delayed landing flare during the autorotation. Contributing to the accident was the dusk light condition and the corn crop.NTSB CHI08CA296Accident · No injuriesData collectionFinal reportPiper PA28 · Gann Valley, SDThe pilot's inability to gain sufficient altitude during takeoff as a result of inadequate preflight planning.NTSB CHI08CA246Accident · No injuriesData collectionFinal reportAir Tractor AT-802A · Turton, SDThe failure of the starter generator which resulted in the subsequent loss of engine power. Contributing to the accident were the low altitude at which the airplane was operating, the tall grass, and the ditch.NTSB CHI08CA245Accident · No injuriesData collectionFinal reportAir Tractor 301 · Herreid, SDFailure of one of the tailwheel bolts on landing and the pilot's subsequent inability to maintain directional control.NTSB CHI08CA235Accident · Minor injuriesData collectionFinal reportCessna 150L · Watertown, SDThe pilot's failure to maintain altitude/clearance from terrain during cruise. Contributing to the accident was the night, the haze, and the tall vegetation.NTSB CHI08CA232Accident · Serious injuriesData collectionFinal reportPiper PA-18-150 · Wall, SDThe pilot not maintaining airplane control during the landing. Contributing to the accident was the reported wind shear.NTSB CHI08CA121Accident · No injuriesData collectionFinal reportPiper PA-32-260 · Vermillion, SDThe pilot's failure to adequately compensate for the crosswind condition. Contributing to the accident were the crosswind and the soft terrain.NTSB CHI08CA111Accident · No injuriesData collectionFinal reportVeldhuizen Highlander · Onida, SDThe separation of the right main wheel from the landing gear during takeoff for an undetermined reason.. Contributing to the accident were rough/uneven terrain and that directional control was not possible.