Fatal NTSB investigations, 2017, WI
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 | 5 |
|---|---|
| 1965 | 12 |
| 1966 | 4 |
| 1967 | 10 |
| 1968 | 12 |
| 1969 | 13 |
| 1970 | 9 |
| 1971 | 8 |
| 1972 | 10 |
| 1973 | 11 |
| 1974 | 15 |
| 1975 | 7 |
| 1976 | 11 |
| 1977 | 12 |
| 1978 | 11 |
| 1979 | 15 |
| 1980 | 7 |
| 1981 | 11 |
| 1982 | 9 |
| 1983 | 13 |
| 1984 | 11 |
| 1985 | 5 |
| 1986 | 5 |
| 1987 | 9 |
| 1988 | 7 |
| 1989 | 8 |
| 1990 | 11 |
| 1991 | 9 |
| 1992 | 12 |
| 1993 | 10 |
| 1994 | 2 |
| 1995 | 7 |
| 1996 | 5 |
| 1997 | 6 |
| 1998 | 10 |
| 1999 | 5 |
| 2000 | 7 |
| 2001 | 13 |
| 2002 | 5 |
| 2003 | 5 |
| 2004 | 10 |
| 2005 | 6 |
| 2006 | 6 |
| 2007 | 5 |
| 2008 | 10 |
| 2009 | 4 |
| 2010 | 2 |
| 2011 | 8 |
| 2012 | 2 |
| 2013 | 2 |
| 2014 | 4 |
| 2015 | 7 |
| 2016 | 4 |
| 2017 | 6 |
| 2018 | 5 |
| 2019 | 2 |
| 2020 | 1 |
| 2021 | 7 |
| 2022 | 2 |
| 2023 | 5 |
| 2024 | 1 |
| 2025 | 1 |
| 2026 | 2 |
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\") = 2017
AND c.\"eventStateOrRegion\" = 'WI' 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") = 2017 AND c."eventStateOrRegion" = 'WI' 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 CEN17LA307Accident · 2 fatalLimited investigationFinal reportPegasus Quantum · Fort Atkinson, WIThe student pilot's failure to maintain aircraft control during a go-around, which resulted in impact with water. Contributing to the accident was the non-instructor sport pilot's decision to allow the student pilot to fly the aircraft.NTSB CEN17FA287Accident · 2 fatalField investigationFinal reportAerofab Lake LA 4 250 · Oshkosh, WIThe pilot's failure to properly configure the airplane for takeoff and his decision to takeoff with a tailwind in unfavorable water conditions, which resulted in the airplane entering an aerodynamic stall and the pilot losing control.NTSB CEN17FA248Accident · 6 fatalField investigationFinal reportCessna 421C · Catawba, WIA loss of control and subsequent in-flight breakup for reasons that could not be determined based on the available information.NTSB CEN17FA197Accident · 2 fatalField investigationFinal reportAerotek Pitts S 2A · Sheboygan Falls, WIThe pilot's failure to maintain airplane control following a partial loss of engine power during a low-level aerobatic maneuver; the reason for the loss of engine power could not be determined during postaccident examination of the engine. Contributing to the…NTSB CEN17FA196Accident · 1 fatalField investigationFinal reportPiper J3C · Chetek, WIThe pilot's failure to maintain control of the airplane while flying at a low altitude, which resulted in the airplane exceeding the critical angle of attack and a subsequent aerodynamic stall.NTSB CEN17FA067Accident · 1 fatalField investigationFinal reportDemmer BD-4 · Brookfield, WIThe pilot's failure to abort the takeoff when he was not able to maintain directional control in the strong crosswind conditions.