NTSB investigations, 1996, WI
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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\") = 1996
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") = 1996 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 CHI97FA047Accident · Minor injuriesField investigationFinal reportBeech C90 · Rhinelander, WIthe pilot-in-command's inadequate weather evaluation and continued flight into forecast severe icing conditions which exceeded the capabilty of the airplane's anti-ice/deice system. The icing conditions were a factor.NTSB CHI97LA011Accident · Serious injuriesLimited investigationFinal reportAero Commander 685 · Eden, WIa partial loss of engine power due to improper adjustment of the fuel pump by an unqualified person (pilot-in-command) and the pilot's inadequate preflight planning which resulted in his selection of unsuitable terrain for the attempted takeoff. The pilot's…NTSB CHI97LA015Accident · No injuriesLimited investigationFinal reportCessna 180 · New Richmond, WIthe dual student's failure to recover from the bounced landing and the instructor pilot's failure to correct the situation in time.NTSB CHI97LA005Accident · Minor injuriesLimited investigationFinal reportBeech 23 · Neenah, WIthe local terrain conditions around the airport. A factor was the inadequate runway safety area.NTSB CHI96LA354Accident · No injuriesLimited investigationFinal reportCessna 172L · Delavan, WIthe pilot's failure to assure the airplane was properly secured prior to hand-propping the engine.NTSB CHI96LA346Accident · No injuriesLimited investigationFinal reportBeech B23 · Viroqua, WIthe pilot's inadequate aircraft preflight which led to fuel exhaustion. A factor was the rough uneven terrain.NTSB CHI96LA335Accident · No injuriesLimited investigationFinal reportPiper PA-31 · Janesville, WIfuel exhaustion as a result of an inadequate preflight by the pilot in command.NTSB CHI96FA327Accident · 1 fatalField investigationFinal reportBeech 23 · Tomahawk, WIthe student pilot's impairment of judgment and performance due to alcohol which led to his initiation of VFR flight into instrument meteorological conditions and loss of control. Factors were: the dark night and the weather conditions.NTSB CHI96IA320Incident · No injuriesIncident investigationFinal reportCessna 525 · Milwaukee, WIan uncontained failure of a high pressure turbine disk blade retention post due to fatigue. A factor relating to the incident was: inadequate design of the high pressure turbine disk. Fretting on the leading side of the lobe near the fracture origin may have…NTSB CHI96LA337Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Wausau, WIthe pilot's selection of an unsuitable landing area, and his misjudgment of distance and speed, while attempting to minimize the effect of crossing an uneven area on the runway. The uneven runway condition was a related factor.NTSB CHI96LA293Accident · No injuriesLimited investigationFinal reportAero Commander 600 · Rhinelander, WIa total loss of engine power for undetermined reasons.NTSB CHI96LA286Accident · Serious injuriesLimited investigationFinal reportSchuler T Bird II · Fond Du Lac, WIloss of engine power because of improperly insulated ignition wiring. Factors relating to the accident were improper maintenance; and high obstructions in the emergency landing area, which the pilot had to avoid, resulting in a collision with terrain.NTSB CHI96LA288Accident · No injuriesLimited investigationFinal reportBeech 23 · Wilmot, WIimproper planning/decision by the flight instructor (CFI) by failing to ensure that the airplane would be able to clear brush and trees near the departure end of the runway.NTSB CHI96FA278Accident · 1 fatalField investigationFinal reportLancair 320 · Fond Du Lac, WIthe fatigue in the propeller flange with soft material and oversized lightening holes. A factor was the pilot's inability to maintain control of the aircraft due to the exceeded weight and balance which led to a stall/spin.NTSB CHI96LA271Accident · No injuriesLimited investigationFinal reportCessna 150 · Wisconsin Rapid, WIfuel exhaustion, due to the pilot's improper planning/decision and inadequate fuel management.NTSB CHI96LA268Accident · No injuriesLimited investigationFinal reportUltravia Aero Int'l Pelican · Winneconne, WIfailure of the pilot to maintain directional control of the airplane during the takeoff roll, which resulted in a ground swerve. The location of the tree was a related factor.NTSB CHI96LA267Accident · No injuriesLimited investigationFinal reportYakovlev YAK-3UA · Fond Du Lac, WIthe pilot's inaccurate fuel consumption calculations, and his inadequate in-flight planning and decision making. The pilot's failure to declare an emergency fuel condition (inadequate communication) was a related factor.NTSB CHI96LA263Accident · Minor injuriesLimited investigationFinal reportRockwell S-2D · Bancroft, WIthe pilot's inadequate compensation for wind conditions and failure to maintain directional control, which resulted in a ground swerve, encounter with soft/sandy terrain, and a subsequent noseover. Factors relating to the accident were: the pilot's selection…NTSB CHI96LA262Accident · Minor injuriesLimited investigationFinal reportPiper PA-J3C · Camp Lake, WIseizure of the number 2 piston. Inadequate maintenance was a related factor.NTSB CHI96LA253Accident · No injuriesLimited investigationFinal reportYasecko LONG-EZE · Waukesha, WIFailure of the throttle cable.NTSB CHI96LA252Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · East Troy, WIcorrosion and fracture of the rudder control horn.NTSB CHI96LA236Accident · No injuriesLimited investigationFinal reportWsk Pzl Mielec M-18 Dromader · Waupaca, WIinadequate maintenance of the throttle cable by maintenance personnel.NTSB CHI96LA225Accident · Serious injuriesLimited investigationFinal reportSisk BD-5 · Lake Geneva, WIfailure of the pilot to abort the takeoff, while there was sufficient runway remaining. The high temperature and calm wind were related factors.NTSB CHI96LA222Accident · 1 fatalLimited investigationFinal reportPiper J3C-90 · Racine, WIwas improper remdial action by the pilot after encountering a stall when the elevator back pressure was not removed and the ailerons were positioned for a right bank by that increasing the airplane's left yaw/roll action. Factors in this accident were a stall…NTSB CHI96LA227Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Cottage Grove, WIthe pilot's failure to maintain directional control of the airplane during landing. A factor was the delayed go-around.NTSB CHI96LA215Accident · No injuriesLimited investigationFinal reportLoehle-Avia 5151RG · Fond Du Lac, WIthe pilot's improper positioning of the fuel tank selector, which resulted in fuel starvation and loss of engine power. A factor relating to the accident was: the design/location of the fuel tank selector.NTSB CHI96LA180Accident · No injuriesLimited investigationFinal reportCessna 152 · Eau Claire, WIthe flight instructor's inadequate supervision. A factor relating to the accident was: the student pilot's improper flare.NTSB CHI96LA165Accident · Serious injuriesLimited investigationFinal reportAS+ AC 4 · Hartford, WIlack of airspeed control by the pilot, while maneuvering.NTSB CHI96LA149Accident · 1 fatalLimited investigationFinal reportDeweese Bushby Mustang M-II · Lancaster, WIfailure of the pilot to maintain adequate airspeed, while maneuvering in the traffic pattern, which resulted in an inadvertent stall/spin and collison with the terrain. The pilot's use of abrupt maneuvers was a related factor.NTSB CHI96LA136Accident · No injuriesLimited investigationFinal reportCessna 172N · Middleton, WIfailure of the pilot to maintain directional control of the airplane during the landing, which resulted in an inadvertent ground swerve. Factors relating to the accident were: the gusty crosswind condition, the pilot's excessive lowering of flaps, and the…NTSB CHI96LA127Accident · No injuriesLimited investigationFinal reportSocata TBM-700 · Eau Claire, WIfatigue fracture and subsequent failure of the gear door hinge bracket.NTSB CHI96LA118Accident · No injuriesLimited investigationFinal reportCessna 310R · Marshfield, WIthe failure of the pilot of the PA-32R, N1030Q, to obtain identification of the Cessna 310R, N1835E, visually, and his inadequate visual outlook. A factor was the failure of both pilots to hear communications from each other.NTSB CHI96LA105Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Camp Lake, WIFailure of the pilot to maintain clearance from trees that were located beside the runway.NTSB CHI96FA113Accident · 1 fatalField investigationFinal reportPiper PA-32 · Milwaukee, WIInadequate maintenance and inspection in that the Airworthiness Directive which applied to the fuel pump had not been complied with. A factor was the pilot was unable to reach land.NTSB CHI96LA078Accident · Serious injuriesLimited investigationFinal reportPiper J3C-65 · Mount Horeb, WIfailure of the pilot to see-and-avoid the pedestrian. Factors relating to the accident were: the pilot's inadequate preflight preparation, his landing on a closed airstrip, and the snow covered terrain.