Fatal NTSB investigations, 2006, SC
180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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
| 1964 | 1 |
|---|---|
| 1965 | 6 |
| 1966 | 7 |
| 1967 | 6 |
| 1968 | 8 |
| 1969 | 5 |
| 1970 | 4 |
| 1971 | 5 |
| 1972 | 7 |
| 1973 | 6 |
| 1974 | 8 |
| 1975 | 5 |
| 1976 | 4 |
| 1977 | 7 |
| 1978 | 7 |
| 1979 | 7 |
| 1980 | 7 |
| 1981 | 7 |
| 1982 | 10 |
| 1983 | 5 |
| 1984 | 6 |
| 1985 | 5 |
| 1986 | 1 |
| 1987 | 6 |
| 1988 | 3 |
| 1989 | 7 |
| 1990 | 8 |
| 1991 | 4 |
| 1992 | 5 |
| 1994 | 6 |
| 1995 | 12 |
| 1996 | 5 |
| 1997 | 6 |
| 1998 | 5 |
| 1999 | 4 |
| 2000 | 3 |
| 2001 | 5 |
| 2002 | 7 |
| 2003 | 7 |
| 2004 | 9 |
| 2005 | 8 |
| 2006 | 4 |
| 2007 | 2 |
| 2008 | 2 |
| 2009 | 8 |
| 2010 | 6 |
| 2011 | 6 |
| 2012 | 1 |
| 2013 | 4 |
| 2014 | 4 |
| 2015 | 4 |
| 2016 | 2 |
| 2017 | 2 |
| 2018 | 3 |
| 2020 | 2 |
| 2021 | 4 |
| 2022 | 2 |
| 2023 | 4 |
| 2026 | 3 |
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\") = 2006
AND c.\"eventStateOrRegion\" = 'SC' AND c.\"eventCountry\" = 'USA'
AND c.\"highestInjuryLevel\" = 'Fatal'
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") = 2006 AND c."eventStateOrRegion" = 'SC' AND c."eventCountry" = 'USA' AND c."highestInjuryLevel" = 'Fatal' 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 ATL07FA029Accident · 4 fatalField investigationFinal reportCessna 340A · Charleston, SCThe pilot's failure to maintain airspeed during a turn from base to final, resulting in an inadvertent stall/spin. Contributing to the accident was the impairment of the pilot due to the combination of drugs found in his toxicological report.NTSB ATL06FA122Accident · 2 fatalField investigationFinal reportPiper PA-32RT-300 · Hartsville, SCThe pilot's loss of control of the airplane due to spatial disorientation.NTSB ATL06LA070Accident · 1 fatalLimited investigationFinal reportLancair Lancair 360 · Charleston, SCThe pilot's failure to maintain sufficient airspeed during a climb to preclude a stall, which resulted in a loss of control and an in-flight collision with terrain. A factor associated with the accident was an inadvertent stall.NTSB ATL06FA044Accident · 6 fatalField investigationFinal reportBeech 200 · N Myrtle Beach, SCThe pilot's failure to maintain control during landing approach for undetermined reasons.