Fatal NTSB investigations, 2011, UT
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
| 1963 | 1 |
|---|---|
| 1964 | 7 |
| 1965 | 12 |
| 1966 | 8 |
| 1967 | 7 |
| 1968 | 7 |
| 1969 | 9 |
| 1970 | 8 |
| 1971 | 4 |
| 1972 | 11 |
| 1973 | 12 |
| 1974 | 11 |
| 1975 | 14 |
| 1976 | 9 |
| 1977 | 10 |
| 1978 | 11 |
| 1979 | 12 |
| 1980 | 9 |
| 1981 | 15 |
| 1982 | 11 |
| 1983 | 12 |
| 1984 | 10 |
| 1985 | 8 |
| 1986 | 3 |
| 1987 | 6 |
| 1988 | 10 |
| 1989 | 7 |
| 1990 | 5 |
| 1991 | 4 |
| 1992 | 6 |
| 1993 | 8 |
| 1994 | 10 |
| 1995 | 7 |
| 1996 | 5 |
| 1997 | 6 |
| 1998 | 9 |
| 1999 | 3 |
| 2000 | 8 |
| 2001 | 7 |
| 2002 | 6 |
| 2003 | 10 |
| 2004 | 2 |
| 2005 | 2 |
| 2006 | 6 |
| 2007 | 7 |
| 2008 | 8 |
| 2009 | 6 |
| 2010 | 7 |
| 2011 | 7 |
| 2012 | 9 |
| 2013 | 3 |
| 2014 | 6 |
| 2015 | 3 |
| 2016 | 3 |
| 2017 | 4 |
| 2018 | 4 |
| 2019 | 6 |
| 2020 | 6 |
| 2021 | 4 |
| 2022 | 2 |
| 2023 | 7 |
| 2024 | 3 |
| 2025 | 2 |
| 2026 | 4 |
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\") = 2011
AND c.\"eventStateOrRegion\" = 'UT' 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") = 2011 AND c."eventStateOrRegion" = 'UT' 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 WPR12FA001Accident · 2 fatalField investigationFinal reportVaughn Pulsar · West Jordan, UTThe pilot’s failure to maintain sufficient airspeed and airplane control while initiating a turn during the initial climb after takeoff in a high density altitude environment, above the airplane’s maximum allowable gross weight, and with an overly rich…NTSB WPR11FA450Accident · 1 fatalField investigationFinal reportCone James A RV-6A · West Jordan, UTThe pilot’s execution of an abrupt maneuver, likely to avoid birds, which resulted in a stall and spin.NTSB WPR11FA429Accident · 1 fatalField investigationFinal reportBrewster LONG-EZ · Kanab, UTThe pilot's loss of airplane control during cruise flight.NTSB WPR11LA270Accident · 1 fatalLimited investigationFinal reportSix Chuter Skye Ryder Aerochute · Tooele, UTThe operation of a powered parachute by a non-certificated pilot. Contributing to the accident was the pilot's decision to conduct a flight in a strong gusty wind.NTSB WPR11FA242Accident · 4 fatalField investigationFinal reportCessna 172R · Wendover, UTThe pilot did not maintain adequate airspeed during the downwind turn resulting in an aerodynamic stall, in-flight loss of control, and spin. Contributing to the accident was the pilot’s inadequate preflight planning and exceedance of the approved weight and…NTSB WPR11FA147Accident · 1 fatalField investigationFinal reportNeefjes Lancair 360 MK-II · Milford, UTThe pilot's loss of control of the airplane due to spatial disorientation after inadvertently entering instrument meteorological conditions. Contributing to the accident were the pilot's inadequate preflight preparation, his en route decision-making, and his…NTSB WPR11LA133Accident · 1 fatalLimited investigationFinal reportBuckeye Breeze LX · Bullfrog, UTThe pilot’s loss of control while maneuvering to land at an off-airport site.