NTSB investigations, 2017, WI
180,604 investigations by the National Transportation Safety Board since 1962: 174,583 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 | 70 |
|---|---|
| 1965 | 75 |
| 1966 | 88 |
| 1967 | 99 |
| 1968 | 81 |
| 1969 | 93 |
| 1970 | 87 |
| 1971 | 65 |
| 1972 | 74 |
| 1973 | 77 |
| 1974 | 81 |
| 1975 | 69 |
| 1976 | 55 |
| 1977 | 75 |
| 1978 | 90 |
| 1979 | 89 |
| 1980 | 62 |
| 1981 | 69 |
| 1982 | 54 |
| 1983 | 60 |
| 1984 | 64 |
| 1985 | 59 |
| 1986 | 55 |
| 1987 | 48 |
| 1988 | 47 |
| 1989 | 56 |
| 1990 | 47 |
| 1991 | 46 |
| 1992 | 39 |
| 1993 | 55 |
| 1994 | 41 |
| 1995 | 41 |
| 1996 | 35 |
| 1997 | 33 |
| 1998 | 44 |
| 1999 | 44 |
| 2000 | 34 |
| 2001 | 46 |
| 2002 | 37 |
| 2003 | 32 |
| 2004 | 37 |
| 2005 | 38 |
| 2006 | 21 |
| 2007 | 32 |
| 2008 | 40 |
| 2009 | 23 |
| 2010 | 26 |
| 2011 | 31 |
| 2012 | 35 |
| 2013 | 18 |
| 2014 | 22 |
| 2015 | 30 |
| 2016 | 28 |
| 2017 | 25 |
| 2018 | 26 |
| 2019 | 19 |
| 2020 | 14 |
| 2021 | 25 |
| 2022 | 23 |
| 2023 | 25 |
| 2024 | 24 |
| 2025 | 24 |
| 2026 | 20 |
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\") = 2017
AND c.\"eventStateOrRegion\" = 'WI' AND c.\"eventCountry\" = 'USA'
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' 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 GAA18CA058Accident · No injuriesData collectionFinal reportCessna 182 · Black River Falls, WIThe student pilot’s failure to maintain lateral control of the high-performance airplane during the go-around in crosswind conditions.NTSB CEN18LA038Accident · Serious injuriesLimited investigationFinal reportPiper / Laudeman J3C 65 · Palmyra, WIThe pilot’s inadvertent pulling of the fuel shutoff valve, which resulted in a total loss of engine power and a subsequent forced landing into trees. Contributing to the pilot’s inadvertent pulling of the fuel shutoff valve were habit patterns he had…NTSB GAA18CA005Accident · No injuriesData collectionFinal reportCessna 172 · Black River Falls, WIThe pilot’s failure to maintain directional control during landing in gusting crosswind conditions.NTSB CEN17LA344Accident · No injuriesLimited investigationFinal reportAviat A 1B · Prairie du Chien, WIThe fatigue failure of the aileron hinge bracket tubing for reasons that could not be determined based on the available evidence.NTSB GAA17CA523Accident · No injuriesData collectionFinal reportTaylorcraft BC12 · Redgranite, WIThe pilot’s failure to maintain directional control during the landing roll.NTSB GAA17CA524Accident · Minor injuriesData collectionFinal reportBoeing A75N1(PT17) · Oshkosh, WIThe pilot’s overapplication of the brakes, which resulted in the biplane coming to rest inverted.NTSB GAA17CA491Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · Westby, WIThe pilot's failure to see and avoid power lines while maneuvering at low altitude.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 GAA17CA451Accident · No injuriesData collectionFinal reportMark Goldberg Bearhawk Patrol · Oshkosh, WIThe pilot's failure to maintain directional control during the landing roll in crosswind conditions, which resulted in a ground loop.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 GAA17CA420Accident · No injuriesData collectionFinal reportCostruzioni Aeronautiche Tecna P2008 · Lone Rock, WIThe student pilot’s improper landing flare, which resulted in a bounced landing and subsequent loss of directional control and runway excursion during the aborted landing. Contributing to the improper landing flare was the student’s distraction by a deer…NTSB GAA17CA412Accident · No injuriesData collectionFinal reportMooney M20C · Washington Island, WIThe pilot's failure to maintain a proper approach path, which resulted in impact with trees.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 CEN17FA231Accident · Serious injuriesField investigationFinal reportGefa-Flug AS-105-GD · Hartford, WIThe overpressurization failure of the airship envelope as a result of the airship's encounter with gusty wind conditions and thermal activity. Contributing to the accident was the jammed Plexiglass venting panel.NTSB CEN17LA224Accident · No injuriesLimited investigationFinal reportMckenna SD-1A · Juneau, WIThe pilot’s difficulty controlling the airplane due to his incorrect reinstallation of the wings, which led to a bounced precautionary landing. Contributing to the accident was the failure of the pilot and the mechanic to verify the wings’ angle of incidence.NTSB CEN17LA210Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R22 · Kenosha, WIThe pilot's loss of helicopter control during landing to a dolly.NTSB CEN17LA204Accident · Minor injuriesLimited investigationFinal reportAviat A-1B · Tomahawk Lake, WIThe pilot's failure to maintain a proper approach path, which resulted in the airplane’s hard landing and nose over after the water landing.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 GAA17CA278Accident · Minor injuriesData collectionFinal reportReims Cessna FR172 · De Pere, WIThe pilot’s failure to maintain directional control during takeoff with a tailwind.NTSB GAA17CA244Accident · No injuriesData collectionFinal reportBeech 99 · Waukesha, WIAn in-flight collision with a bird during the approach.NTSB GAA17CA224Accident · No injuriesData collectionFinal reportStinson 108 · Woodruff, WIThe pilot receiving instruction's incorrect brake usage and failure to maintain directional control during the landing roll.NTSB CEN17CA114Accident · No injuriesData collectionFinal reportCessna 340A · Waukesha, WIThe pilot’s decision to fly in in conditions conducive to structural icing and her subsequent failure to maintain airplane control during the instrument approach.NTSB CEN17LA076Accident · No injuriesLimited investigationFinal reportCessna 182T · Green Bay, WIThe airplane’s encounter with unforecast icing conditions, which led to structural icing that obscured the pilot’s vision, an aerodynamic stall, and a subsequent hard landing.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.