Fatal NTSB investigations, 1995, 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\") = 1995
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") = 1995 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 CHI96FA067Accident · 2 fatalField investigationFinal reportCessna 560 · Eagle River, WIthe failure of the pilot to maintain airspeed while executing the circling approach. Factors were the descent below minimum descent altitude, the fog, the low ceiling and the icing conditions.NTSB CHI96FA029Accident · 2 fatalField investigationFinal reportPiper PA-28-151 · Fond Du Lac, WIthe pilot's intentional VFR flight into instrument meteorological conditions, and his failure to maintain altitude. Factors included the weather obscuration due to snow and fog, the dark night, and the pilot's lack of recent night flight time.NTSB CHI95FA310Accident · 1 fatalField investigationFinal reportChampion 7GCB · Howard, WIa loss of engine power due to water-contaminated fuel and the pilot's inadequate preflight.NTSB CHI95FA259Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Fifield, WIthe pilot's attempted visual flight into instrument meteorological conditions, which resulted in spatial disorientation and loss of control. A factor was the fog.NTSB CHI95FA255Accident · 2 fatalField investigationFinal reportBeech T-34C · Oak Creek, WIthe pilot's failure to maintain an adequate fuel supply, and his failure to maintain airspeed.NTSB CHI95FA126Accident · 4 fatalField investigationFinal reportCessna 150M · Oshkosh, WIInadequate visual lookout by the pilot of the Beech V35B, resulting in his failure to see-and-avoid the Cessna 150, which was ahead and below him on final approach; and failure of the tower controller to provide adequate service (flight advisories and landing…NTSB NYC95FA056Accident · 2 fatalField investigationFinal reportPiper PA-46-310P · Chippewa Falls, WIThe pilot's improper decision to depart into known adverse weather conditions, and the subsequent encounter with freezing drizzle, resulting in an inadvertent stall and collision with the terrain during an approach to land. Also causal to the accident was the…