Fatal NTSB investigations, 1997, 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\") = 1997
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") = 1997 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 CHI98LA061Accident · 1 fatalLimited investigationFinal reportPiper PA-28-140 · Sturtevant, WIThe pilot's misjudgment of altitude/distance and her failure to maintain adequate visual lookout. Also causal was the pilot's failure to maintain adequate obstacle clearance. A contributing factor was the pilot experiencing a visual illusion.NTSB CHI97FA248Accident · 1 fatalField investigationFinal reportValley Adventurers Adventurer 333 · Fond Du Lac, WIThe kit manufacturer's use of inadequate material in construction of the airplane, his inadequate application of quality controls resulting in the debonding of the horizontal stabilizer. Factors were the total loss of the horizontal stabilizer, the elevator,…NTSB CHI97FA252Accident · 2 fatalField investigationFinal reportBeech 76 · New Richmond, WIThe certified flight instructor's inadequate supervision and delayed remedial action and the flight crew's lack of aircraft control. A factor was loss of control while maneuvering downwind by one of the pilot's.NTSB CHI97FA245Accident · 2 fatalField investigationFinal reportPeck Osprey 2 · Poygen, WIA loss of control in flight for undetermined reasons.NTSB CHI97LA239Accident · 1 fatalLimited investigationFinal reportBriegleb BG-12A · Superior, WIthe separation of the wing from the glider for undetermined reasons.NTSB CHI97FA084Accident · 4 fatalField investigationFinal reportDouglas DC-3C/BT-67R · Newton, WIfailure of the Beech A36 pilot to maintain clearance from the modified Douglas DC-3, while positioning the A36 for photography of the DC-3.