NTSB investigations, 2007, 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\") = 2007
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") = 2007 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 CHI08FA054Accident · 1 fatalField investigationFinal reportPiper PA-32R-300 · Warrens, WIThe decision by the pilot to fly into known adverse weather, and the pilot's failure to maintain control of the airplane due to spatial disorientation. Contributing factors include the clouds and the night conditions.NTSB CHI08CA047Accident · No injuriesData collectionFinal reportCessna Skyhawk 172 · Wausau, WIThe pilot failed to maintain directional control during the landing roll. Factors that contributed to the accident included the snow on the runway and the snowbank.NTSB CHI08CA019Accident · No injuriesData collectionFinal reportBell 47G-2A · Wautoma, WIThe pilot's failure to maintain control of the helicopter resulting from a distraction in the cockpit. A contributing factor was the distraction due to the dog in the cockpit.NTSB CHI08CA007Accident · Serious injuriesData collectionFinal reportKrueger Quickie · Antigo, WIThe inadequate preflight planning and preparation by the pilot, the proper climb rate not obtained/maintained by the pilot, and the airspeed not obtained/maintained by the pilot. Contributing factors were the lack of total experience in the type of aircraft…NTSB CHI07CA295Accident · Serious injuriesData collectionFinal reportEkornaas, Fred SkyRanger II Kit · Bristol, WIThe pilot's improper recovery from a bounced landing and his failure to maintain directional control during the attempted go-around. An additional cause was the inadvertent stall as the pilot maneuvered to avoid the hangar. Contributing factors were the…NTSB CHI07CA284Accident · No injuriesData collectionFinal reportCessna 182P · Eau Claire, WIThe pilot's failure to maintain directional control of the airplane during the landing roll. A factor associated with the accident was the ditch.NTSB CHI07LA280Accident · Serious injuriesLimited investigationFinal reportMcFaul, Daniel D. Quicksilver GT500 · New London, WIThe pilot not maintaining airspeed during the unintentional takeoff and the pilot's inadvertent stall.NTSB CHI07LA260Accident · 1 fatalLimited investigationFinal reportPiper PA-28-140 · West Bend, WIThe pilot's decision to depart in adverse weather conditions, and his failure to maintain clearance from the terrain. Contributing to the accident included the pilot's lack of an instrument rating, his lack of recent night experience, the night conditions and…NTSB CHI07LA238Accident · 1 fatalLimited investigationFinal reportSwanson Aventura II · Lakewood, WIThe pilot's excessive pull up, his not maintaining airspeed, and the inadvertent stall resulting in the loss of control. A factor contributing to the accident was the trees.NTSB CHI07FA243Accident · 1 fatalField investigationFinal reportBeck P-51A · Oshkosh, WIThe P-51A pilot's inadequate visual lookout and his failure to maintain clearance from the P-51D. Contributing factors to the accident included the restricted forward visibility of the P-51A, the air race team representative's inadequate flight brief, the…NTSB CHI07CA231Accident · No injuriesData collectionFinal reportBeech A36 · Sturtevant, WIThe pilot's improper decision to land with a tailwind, which resulted in an overrun during landing rollout. Factors contributing to the accident include the dirt pile and the tailwind.NTSB CHI07CA228Accident · No injuriesData collectionFinal reportFlight Design Ctsw · Oshkosh, WIThe pilot's failure to maintain adequate airspeed during landing which resulted in an inadvertent stall and subsequent impact with the ground.NTSB CHI07LA219Accident · No injuriesLimited investigationFinal reportNorth American T-6G · Fond Du Lac, WIThe loss of engine power due to the failure of the engine's master connecting rod which resulted in the forced landing. The road sign was a factor.NTSB CHI07LA204Accident · Minor injuriesLimited investigationFinal reportCessna 182K · Edgerton, WIThe reported non-mechanical loss of engine power for undetermined reasons during cruise and the excessive airspeed the pilot maintained during the approach for the forced landing. Factors were the loss of electrical power during cruise and the high vegetation…NTSB CHI07LA249Accident · No injuriesLimited investigationFinal reportCessna C-177 · Webster, WIThe loss of engine power for an undetermined reason, and the pilot's misjudged flare during the subsequent forced landing.NTSB CHI07LA177Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Rio Creek, WIThe pilot's improper aircraft weight and balance, and his failure to maintain sufficient airspeed to avoid a stall during takeoff-initial climb.NTSB CHI07LA168Accident · Minor injuriesLimited investigationFinal reportCessna R172K · Lakewood, WIThe amphibian nose wheel strut assembly separated due to an overload fracture as a result of the manufacturer's inadequate design.NTSB CHI07MA160Accident · 6 fatalClass 1 · MajorFinal reportCessna 550 · Milwaukee, WIThe National Transportation Safety Board determines that the probable cause of this accident was the pilots’ mismanagement of an abnormal flight control situation through improper actions, including failing to control airspeed and to prioritize control of the…NTSB CHI07LA159Accident · No injuriesLimited investigationFinal reportCessna 340A · Middleton, WIFailure of the right main landing gear extension and retraction linkage, which allowed the gear assembly to collapse during landing rollout. An additional cause was the improper adjustment procedure(s) by undetermined mechanic(s). The runway lights struck…NTSB CHI07CA158Accident · No injuriesData collectionFinal reportCessna 182S · Cedarburg, WIThe improper landing flare which resulted in the airplane porpoising during the landing and the subsequent overload of the nose gear.NTSB CHI07CA132Accident · No injuriesData collectionFinal reportCessna 172P · Kenosha, WIThe pilot's improper recovery from a bounced landing, which resulted in a flat nose wheel tire and a buckled firewall. A factor was the porpoising that was encountered during the flare.NTSB CHI07LA135Accident · No injuriesLimited investigationFinal reportCessna 414A · Sturgeon Bay, WIWorn brakes which resulted in an overrun during landing. A fence was a factor.NTSB CHI07CA123Accident · Minor injuriesData collectionFinal reportCessna 150J · Amery, WIThe pilot's failure to maintain control of the airplane during the aborted landing attempt which resulted in the airplane impacting trees. A misjudged flare, subsequent bounced landing, and gusty wind conditions were contributing factors.NTSB CHI07CA117Accident · Minor injuriesData collectionFinal reportNeal Anderson Comp Air 6 · Sturtevant, WIThe pilot's failure to obtain a proper touchdown point, which resulted in a runway over run and subsequent nose-over of the aircraft, and the pilot's improper weather evaluation to land with a quartering tailwind. Factors contributing to the accident were a…NTSB CHI07CA112Accident · No injuriesData collectionFinal reportPZL Warzawa-CNPSL PZL-104 Wilga 35A · Waukesha, WIThe pilot's decision to attempt flight following the initial loss of engine power and successful forced landing to a cornfield. An additional cause was the loss of engine power for undetermined reasons. A contributing factor was the furrowed cornfield…NTSB CHI07CA101Accident · No injuriesData collectionFinal reportLuscombe 8A · Chippewa Falls, WIThe pilot intentionally leaving the airplane unoccupied during the engine start, which resulted in the unoccupied airplane traversing into a cornfield. A factor was the rough/uneven cornfield.NTSB CHI07LA092Accident · No injuriesLimited investigationFinal reportSocata TB-20 Trinidad · Rhinelander, WIThe failure of the pilot to maintain directional control of the airplane during taxi. A contributing factor was the gusting winds and sign.NTSB CHI07LA091Accident · Serious injuriesLimited investigationFinal reportHaddan Sonerai IIL · Fort Atkinson, WIThe pilot's failure to maintain airspeed following a loss of engine power for undetermined reasons. A low altitude and an inadvertent stall were factors.NTSB CHI07CA087Accident · No injuriesData collectionFinal reportCessna 150 · LaCrosse, WIThe dual student's failure to maintain the proper glidepath and clearance from terrain and the flight instructor's delayed remedial action. A factor was the flight instructor's fatigue.NTSB CHI07CA081Accident · No injuriesData collectionFinal reportRotary Air Force Marketing RAF 2000 · Neenah, WIThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion. Contributing factors were a bent rudder trim tab, the narrow runway, and the uneven terrain at the edge of the runway pavement.NTSB CHI07FA060Accident · Minor injuriesField investigationFinal reportBeechcraft BE99 · Milwaukee, WIThe failure of both pilots to adequately scan for and avoid other aircraft traffic during taxi operations, and the failure of Air Traffic Control to issue a traffic advisory to both of the pilots. A contributing factor to the accident was the night time light…NTSB CHI07CA055Accident · No injuriesData collectionFinal reportCessna 150M · Bristol, WIThe pilot's selection of unsuitable terrain to taxi on for takeoff. A factor was the soft terrain condition.