NTSB investigations, 2004, 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\") = 2004
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") = 2004 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 CHI05FA048Accident · 2 fatalField investigationFinal reportBeech S35 · Herman, WIThe installation of the improper cylinder base packing seals by maintenance personnel resulting in the loss of lubriation and subsequent failure of the number four connecting rod/bearing. A factor associated with the accident was the trees that the airplane…NTSB CHI05CA032Accident · Serious injuriesData collectionFinal reportOlson Sonex · Oconomowoc, WIThe loss of engine power due to a fatigue fracture of the crankshaft. An additional cause to the accident was the pilot/builder's failure to verify the dimensions of the shrink-fit crankshaft components prior reassembling the engine. A factor to the accident…NTSB CHI05LA028Accident · Serious injuriesLimited investigationFinal reportSaab-Scania 340B · Milwaukee, WIFailure of the ramp employee to maintain clearance to the rotating propeller resulting in inadvertent contact with a propeller blade.NTSB CHI05FA016Accident · 2 fatalField investigationFinal reportCessna P210N · Wautoma, WIThe pilot not maintaining airplane control during cruise flight in instrument meteorological conditions after reporting a loss of gyros leading to his exceeding the design load limits of the wings. Factors were the clouds, the deteriorated vacuum manifold…NTSB CHI05CA006Accident · No injuriesData collectionFinal reportPiper PA-28-160 · Altoona, WIThe pilot's inadequate fuel management leading to the fuel starvation in the left tank during the flight's descent. A factor was the impacted power line.NTSB CHI04FA290Accident · 3 fatalField investigationFinal reportBeech B95A · Burlington, WIThe improper maintenance of the fuel servo resulting in a loose adjustment nut and subsequent failure of the fuel injection servo which led to a complete loss of power on the right engine. Other causes were the pilot's failure to obtain or maintain minimum…NTSB CHI04LA265Accident · Serious injuriesLimited investigationFinal reportKenny Mariner-MF Boat · Eagle River, WIThe pilot's inability to maintain control of the aircraft during flight for undetermined reasons.NTSB CHI04LA256Accident · 1 fatalLimited investigationFinal reportClaxton S-12 · Oconomowoc, WIThe loss of engine power due to the seizure of the pistons and the pilot's failure to maintain airspeed which resulted in an inadvertent stall. The previous damage to the pistons due to earlier seizure occurrences was a factor.NTSB CHI04LA253Accident · Serious injuriesLimited investigationFinal reportWilliams Glastar GS-1 · Hayward, WIThe pilot's failure to adequately compensate for the wind conditions which resulted in a loss of aircraft control. A factor associated with the accident was the gusty wind condition.NTSB CHI04FA255Accident · 1 fatalField investigationFinal reportCirrus Design SR-22 · Park Falls, WIThe flightcrew's failure to maintain airspeed which resulted in an inadvertent stall and subsequent impact with water during approach. The low altitude was a factor in the accident.NTSB CHI04CA250Accident · No injuriesData collectionFinal reportPiper PA-32-301 · Crivitz, WIThe proper touchdown point not attained by the pilot during landing. The road and tailwind were contributing factors.NTSB CHI04LA243Accident · 1 fatalLimited investigationFinal reportBoeing A75 · Wisconsin Rapid, WIThe pilot's improper in-flight decision when he decided to fly at a low altitude over the river and failed to maintain clearance from the power lines. A factor was the wires.NTSB CHI04FA223Accident · 1 fatalField investigationFinal reportCessna 172L · Webster, WIThe high velocity impact with terrain for undetermined reasons.NTSB CHI04FA214Accident · 2 fatalField investigationFinal reportEurocopter France EC130 B4 · Prairie du Sac, WIThe pilot's intentional low-level flight toward the lake and his failure to maintain clearance from the static wire on power transmission lines. Contributing factors were the separation of the Fenestron (tail rotor) assembly from the tail boom as a result of…NTSB CHI04FA203Accident · 1 fatalField investigationFinal reportKnoepflein Lancair Legacy 2000 · Madison, WIA loss of engine power due to high engine temperatures which resulted in a failure of the number three piston, the pilot's continued operation of the airplane with known high temperature problems, the pilot's poor inflight planning, and the pilot's failure to…NTSB CHI04CA219Accident · No injuriesData collectionFinal reportLake LA4-200 · Oshkosh, WIThe unsuitable rough water conditions encountered during the attempted water takeoff.NTSB CHI04CA211Accident · No injuriesData collectionFinal reportStamsta Wittman Tailwind W10 · Waunakee, WIThe pilot's failure to maintain proper airspeed during final approach, which resulted in the inadvertent stall/mush at a low altitude and subsequent hard landing. A factor to the accident was the pilot's unsuccessful remedial action to the encountered…NTSB CHI04CA191Accident · Serious injuriesData collectionFinal reportAerostar RX-7 · Wausau, WIThe pilot's inability to compensation for the turbulence and wind conditions. Contributing factors were the variable winds and the turbulence.NTSB CHI04CA189Accident · Minor injuriesData collectionFinal reportLuscombe 8A · Merrill, WIThe dual student's failure to maintain directional control during the initial climb after takeoff and the flight instructor's delayed remedial action. A contributing factor was that all available runway was not used for takeoff due to the touch-and-go…NTSB CHI04IA178Incident · No injuriesIncident investigationFinal reportBeech 1900D · Milwaukee, WIThe fatigue fracture of the left main landing gear during landing roll.NTSB CHI04CA174Accident · No injuriesData collectionFinal reportCessna 182N · Lancaster, WIThe pilot's inadequate compensation for the gusty winds and his improper flare. The wind gusts were a contributing factor.NTSB CHI04LA167Accident · No injuriesLimited investigationFinal reportBeech 200 · Green Bay, WIThe loss of engine power after takeoff for an undetermined reason.NTSB CHI04CA168Accident · No injuriesData collectionFinal reportPeck Vans RV-4 · Palmyra, WIThe pilot's failure to maintain proper airspeed resulting in the inadvertent stall during the go-around. The overload failure of the left main landing gear was a contributing factor.NTSB CHI04CA150Accident · No injuriesData collectionFinal reportMaule MX7235 · Waukesha, WIThe pilot failed to maintain directional control and his inadequate compensation for wind conditions. Factors associated with the accident were the gusty crosswind and the concrete culvert that the airplane contacted.NTSB CHI04CA138Accident · No injuriesData collectionFinal reportMerkel Acro Sport II · Beloit, WIInaccurate fuel consumption calculations which resulted in fuel exhaustion. Factors associated with the accident were the pilot's continued flight with an inoperable fuel quantity indicator and the wires which the airplane contacted during the forced landing.NTSB CHI04LA147Accident · No injuriesLimited investigationFinal reportNorth American T-28C · Manitowoc, WIFailure of the number 4 piston articulating rod resulting in a complete loss of engine power during initial climb. The ditch was a contributing factor.NTSB CHI04CA136Accident · No injuriesData collectionFinal reportCessna 172P · Milwaukee, WIThe CFI failed to maintain adequate airspeed during the go-around which resulted in an inadvertent stall.NTSB CHI04LA128Accident · 1 fatalLimited investigationFinal reportNorth American P-51C · Hager City, WIThe improper installation of the camshaft drive gear assembly which resulted in the retaining nut backing off allowing the drive gear to move up the shaft. A factor associated with the accident was the low altitude at which the power loss occurred and the…NTSB CHI04CA118Accident · No injuriesData collectionFinal reportPiper PA-12 · Hartford, WIThe loss of engine power for undetermined reasons. A factor to the accident was the soft terrain encountered during the forced landing.NTSB CHI04CA116Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Genesee Depot, WIThe pilot's failure to maintain proper rotor RPM during the hover landing and his inadequate remedial action, which resulted in the hard landing.NTSB CHI04LA104Accident · No injuriesLimited investigationFinal reportCessna 172M · New Munster, WIVisual lookout not maintained by the pilots of both airplanes.NTSB CHI04CA094Accident · No injuriesData collectionFinal reportCessna 180 · Long Lake, WIThe pilot flared improperly and failed to maintain directional control during landing.NTSB CHI04LA084Accident · Serious injuriesLimited investigationFinal reportBoeing 757-200 · Janesville, WIThe unexpected encounter with convective turbulence.NTSB CHI04LA079Accident · No injuriesLimited investigationFinal reportRobinson R44 · Burlington, WIThe pilot's inadequate visual lookout and his failure to obtain/maintain clearance from the transmission wire during the takeoff. Factors contributing to the accident were the transmission wire and the pole.NTSB CHI04LA075Accident · No injuriesLimited investigationFinal reportCessna 120 · Merrill, WIThe pilot's selection of unsuitable terrain to conduct a landing. Factors were the reported flat light conditions and the uneven terrain.NTSB CHI04LA083Accident · No injuriesLimited investigationFinal reportCessna 195 · Manitowoc, WIThe Cessna 195 pilot's failure to maintain clearance from the Cessna 177RG while taxiing to the ramp after landing. A contributing factor was the restricted forward visibility (blind spot) of the Cessna 195 due to the engine cowling. An additional factor was…NTSB CHI04LA064Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Lone Rock, WIThe pilot's continued flight into icing conditions resulting in ice accretion on the wing and his failure to maintain airspeed resulting in a stall.