NTSB investigations, 2005, 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
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\") = 2005
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") = 2005 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 CHI06CA052Accident · No injuriesData collectionFinal reportCessna 152 · Pelican Lake, WIThe pilot selecting an unsuitable landing area. Factors were the snow and ice covered lake.NTSB CHI06CA056Accident · Minor injuriesData collectionFinal reportChampion 7EC · Platteville, WIThe student pilot not maintaining directional control during the landing. A factor was the snow bank the pilot encountered.NTSB CHI06LA031Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Milwaukee, WIThe loss of engine power due to fuel starvation as a result of the pilot's fuel mismanagement. Factors to the accident included the pilot's impairment due to alcohol, the FAA's inadequate oversight when it issued the pilot a second class medical certificate,…NTSB CHI06CA022Accident · No injuriesData collectionFinal reportCessna 180 · Manitowish Wate, WIThe pilot's inadequate preflight planning which resulted in a loss of engine power due to fuel exhaustion. A factor to the accident was the trees the airplane impacted during the forced landing.NTSB ENG06IA001Incident · No injuriesIncident investigationFinal reportCessna Citation 650 · Madison, WIThe inadequate design of the engine's interstage transition duct that yielded after the LPT stage 3 blades had separated and allowed the uncontained release of turbine debris. A contributing factor was the separation of a turbine blade.NTSB CHI05CA275Accident · No injuriesData collectionFinal reportCessna T206H · Sturgeon Bay, WIThe unexpected wave that the airplane encountered during the landing flare.NTSB CHI05FA274Accident · 3 fatalField investigationFinal reportRobinson R44 · Drummond, WIClearance not obtained/maintained by the pilot during an unknown phase of flight. Contributing factors were the improper use of procedures by the pilot, the inadequate surveillance of the operation by company/management, and the wire.NTSB CHI05IA273Incident · No injuriesIncident investigationFinal reportConvair Div. of Gen. Dynamics 440 · Kenosha, WIThe flight crew failed to verify that the cargo was secured before takeoff.NTSB CHI05CA270Accident · No injuriesData collectionFinal reportCessna 182S · Waukesha, WIThe misjudged flare by the pilot.NTSB CHI05CA268Accident · Minor injuriesData collectionFinal reportCessna 180A · Lodi, WIThe pilot's failure to maintain directional control of the airplane during landing resulting in a nose-over.NTSB CHI05CA266Accident · No injuriesData collectionFinal reportRyan Navion G · Lake Geneva, WIThe loss of engine power due to water contamination of the fuel and the pilot's inadequate preflight. A factor was the fence.NTSB CHI05CA262Accident · No injuriesData collectionFinal reportCessna 310Q · Boscobel, WIThe pilot's misjudged distance/altitude which resulted in an undershoot. A related factor was the pilot's diverted attention due to the open cabin door.NTSB CHI05LA237Accident · 1 fatalLimited investigationFinal reportKircher RV-8 · Menomonie, WIThe pilot's decision to perform an aerobatic roll during takeoff, the low altitude, and his failure to maintain clearance from the crops and terrain.NTSB CHI05CA241Accident · Minor injuriesData collectionFinal reportPiper PA-22-150 · Brodhead, WIThe pilot's misjudged distance/altitude which resulted in an undershoot. A related factor was the vehicle the airplane contacted.NTSB CHI05CA240Accident · No injuriesData collectionFinal reportPiper PA-12 · Boscobel, WIThe separation of the right main landing gear attachment bracket bolt during the landing and the pilot's aircraft control not possible with the collapsed gear.NTSB CHI05CA252Accident · No injuriesData collectionFinal reportCessna 150E · Durand, WIThe inadequate flare during landing by the pilot. A contributing factor was the lack of certification of the pilot.NTSB CHI05CA219Accident · No injuriesData collectionFinal reportAmerican Champion 7GCBC · Watertown, WIThe flightcrew's failure to maintain directional control during landing rollout.NTSB CHI05CA206Accident · No injuriesData collectionFinal reportLuscombe 8F · Sturtevant, WIThe pilot not obtaining/maintaining airplane control during the aborted takeoff. A factor was the berm.NTSB CHI05CA204Accident · Minor injuriesData collectionFinal reportWilson Acrolite 1T · Oshkosh, WIThe partial loss of engine power due to an obstructed carburetor fuel metering jet. Factors to the accident included the low altitude at which the loss of engine power occurred, the contamination of the fuel system from degraded automobile-style fuel lines,…NTSB CHI05LA200Accident · Minor injuriesLimited investigationFinal reportVans RV-9A · Neenah, WIThe pilot failed to maintain sufficient airspeed on final approach to avoid a stall, resulting in an inadvertent stall and uncontrolled descent to the terrain.NTSB CHI05FA199Accident · 1 fatalField investigationFinal reportGlasair GS-2 · Wautoma, WIthe abrupt maneuver that was performed while failing to maintain airpeed, resulting in a stall, and uncontrolled impact with the ground without sufficient altitude to recover.NTSB CHI05FA197Accident · 1 fatalField investigationFinal reportNorth American F-51D · Malone, WIThe pilot not maintaining aircraft control and clearance from terrain for undetermined reasons during a low level maneuver.NTSB CHI05CA196Accident · No injuriesData collectionFinal reportSimmons GP-4 · Oshkosh, WIThe pilot's failure to maintain airspeed sufficient enough to compensate for the gusty crosswind condition and prevent a stall during the landing flare. A factor associated with the accident was the gusting crosswind condition.NTSB CHI05FA194Accident · 1 fatalField investigationFinal reportCessna 172P · Jackson, WIThe pilot not maintaining aircraft control for undetermined reasons while maneuvering.NTSB CHI05CA184Accident · Minor injuriesData collectionFinal reportHirsch RV-6A · Oshkosh, WIThe pilot's failure to maintain directional control during the takeoff. Contributing factors were the uneven (rough) runway surface and the fence.NTSB CHI05CA167Accident · No injuriesData collectionFinal reportTaylorcraft BC12-D · Palmyra, WILoss of directional control by the dual student and delayed remedial action by the flight instructor resulting in the airplane nosing over.NTSB CHI05CA146Accident · No injuriesData collectionFinal reportCessna 172N · Madison, WIThe pilot's improper pre-flight which resulted in the control lock not being removed and his subsequent inability to control the airplane. The unmarked control lock and the FBO's failure to replace the unmarked control lock were factors in the accident.NTSB CHI05LA129Accident · No injuriesLimited investigationFinal reportCessna 210B · Friendship, WIThe loss of engine power for an undetermined reason. Contributing factors to the accident were the trees and the dark night light condition.NTSB CHI05LA130Accident · Minor injuriesLimited investigationFinal reportPilatus PC-6 · Sturtevant, WIFailure of the jump plane pilot to maintain clearance from the parachutist descent area/drop zone until assured that all jumpers had landed, and the parachutist's failure to maintain an adequate visual lookout for the jump plane during all phases of the jump.…NTSB CHI05CA123Accident · No injuriesData collectionFinal reportCessna C-172M · Madison, WIThe pilot's inadequate compensation for the wind conditions and his failure to maintain directional control. Factors were the gusty winds and the soft ground.NTSB CHI05CA119Accident · No injuriesData collectionFinal reportSchweizer SGS 2-33A · Beloit, WIThe pilot's misjudgment of distance/altitude which resulted in an undershoot of the runway and collision with trees.NTSB CHI05FA180Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Lake Michigan, WIThe pilot's inaccurate preflight planning and his delayed en route decision to make a fuel stop, which resulted in the loss of engine power due to fuel exhaustion and subsequent ditching.NTSB CHI05LA091Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · Wautoma, WIThe inadvertent stall and low airspeed by the pilot-in-command while maneuvering. Additional causes were the low altitude when the stall occurred and excessive takeoff weight by the pilot-in-command.NTSB CHI05LA086Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Waunakee, WIThe pilot's inadequate preflight planning and the delay in aborting the landing which resulted in the subsequent insufficient airspeed. Factors associated with the accident were the night light conditions, the fence, and the pole which the airplane contacted.NTSB CHI05FA077Accident · No injuriesField investigationFinal reportBombardier CL-600-2B19 · Milwaukee, WIthe captain's failure to adequately compensate for the crosswind conditions, and his failure to maintain directional control during landing. Contributing factors include the captain's failure to land at the nearest suitable airport after an in-flight…NTSB CHI05CA075Accident · Serious injuriesData collectionFinal reportCessna 172K · Portage, WIThe pilot's failure to maintain adequate airspeed during the aborted landing, which resulted in an inadvertent stall at a low altitude. Factors to the accident were the pilot's lack of experience flying from the right pilot station and his failure to maintain…NTSB CHI05LA067Accident · No injuriesLimited investigationFinal reportCessna 152 · Sturtevant, WIThe pilot's failure to identify the electrical system failure and to maintain adequate airspeed during the landing approach. Factors associated with the accident were the electrical system failure, the snow covered terrain, and the pilot's lack of experience.NTSB CHI05CA052Accident · Minor injuriesData collectionFinal reportPiper PA-32R-300 · Cumberland, WIThe pilot could not maintain altitude or airspeed due to airframe icing as a result of the pilot flying into known adverse weather and failing to comply with the airplane's icing limitation . Factors included the icing conditions and the ice accumulation on…