NTSB investigations, 1990, 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\") = 1990
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") = 1990 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 CHI91LA047Accident · 2 fatalLimited investigationFinal reportCessna 175 · Boscobel, WIThe pilot's continued VFR flight into instrument meteorological conditions (IMC) and his failure to remain clear of the trees. Factors related to the accident were: the adverse weather conditions and the pilot's lack of instrument experience.NTSB CHI91LA042Accident · No injuriesLimited investigationFinal reportCessna 150 · Portage, WIDelayed go-around and stall encountered. Contributing factors were a snow bank, proper alignment not attained, and raising the flaps not performed by the PIC.NTSB CHI91DEP02Accident · Serious injuriesFinal reportCessna 172P · Hayward, WIThe pilot-in-command's intentional flight into known adverse weather.NTSB CHI91DEP01Accident · No injuriesFinal reportDean Bartel Avid Flyer Stol · New London, WIThe pilot's failure to obtain a proper touchdown point and his delay in initiating a go-around.NTSB CHI91LA019Accident · No injuriesLimited investigationFinal reportCessna 150 · La Crosse, WIInadequate visual outlook by the PIC.NTSB CHI91LA020Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180D · Crivitz, WIImproper planning/decision by the pilot, and his failure to abort the takeoff (while there was sufficient runway remaining).NTSB CHI91LA017Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Portage, WIThe PIC became lost and disorientated and performed a premature precautionary landing.NTSB CHI90LA274Accident · Minor injuriesLimited investigationFinal reportBurkhart Grob 109A · Waukesha, WIThe pilot's failure to maintain adequate clearance and visual lookout for the moving tractor.NTSB CHI90DEP11Accident · Minor injuriesFinal reportVarga Kachina 2150A · Neenah, WIThe pilot's misjudgement of the fuel supply, and his failure to refuel the aircraft. Contributing to the accident was the unsuitable, soft terrain encountered.NTSB CHI90LA266Accident · No injuriesLimited investigationFinal reportCessna 152 · Eau Claire, WIFuel exhaustion. Contributing factor was the unsuitable terrain.NTSB CHI90DEP10Accident · No injuriesFinal reportBrose Cirrus VK-30 · Baraboo, WIThe pilot's inadequate preflight and misjudgement of the amount of fuel on board, which resulted in fuel exhaustion and loss of engine power, due to an inadequate supply of fuel. The inoperative fuel totalizer was a related factor.NTSB CHI90MA244Accident · 5 fatalMajor investigationFinal reportBell 206B · Elkhorn, WIImproper planning/decision by the pilot, and his failure to attain adequate altitude before flying over rising terrain at night. Factors related to the accident were: darkness, fog, haze, rising terrain, and the lack of visual cues that were available to the…NTSB CHI90FA236Accident · 7 fatalField investigationFinal reportPiper PA-32R-300 · Watertown, WIInitiation of VFR flight into adverse weather and instrument meteorologial conditions. Factors which contributed to the accident were the adverse weather conditions and the pilot's self-induced pressure to maintain currency.NTSB CHI90DEP09Accident · Serious injuriesFinal reportCessna 182 · Columbus, WIThe skydiver's panic and failure to depart the aircraft as instructed. Contributing was the skydiver's lack of total experience in this type of operation.NTSB CHI90FAMS3Accident · 2 fatalMissing aircraftFinal reportCessna 172M · Kewaunee, WIUndetermined.NTSB CHI90DER06Accident · 1 fatalFinal reportMooney M20C · Webster, WIThe pilot's failure to maintain control of the airplane. Factors related to the accident were: the dark night, the pilot's alcohol impairment, and his night flying restriction.NTSB CHI90DEP08Accident · Minor injuriesFinal reportChristen Industries Eagle II · Milwaukee, WIThe pilot-in-command's failure to maintain aircraft control, his misjudgment of proper glidepath and his not performing a timely go-around.NTSB CHI90FA212Accident · 1 fatalField investigationFinal reportBoeing A75N1 · Oshkosh, WIThe pilot-in-command's failure to maintain airspeed sufficient to avoid a stall/spin at an altitude insufficient to effect a full recovery.NTSB CHI90FA208Accident · Serious injuriesField investigationFinal reportLockheed 12A · Oshkosh, WIThe inadequate emergency procedure(s) by the pilot in command following a loss of engine power for undetermined reasons(s).NTSB CHI90LA209Accident · No injuriesLimited investigationFinal reportCessna 150 · Oshkosh, WILoss of engine power for an undetermined reason.NTSB CHI90LA201Accident · No injuriesLimited investigationFinal reportBryant Rowland T-18 · Fisk, WIThe pilot-in-command of the thorp T-18'S failure to maintain a sufficient visual lookout to avoid a collision with the Cessna 170A. Contributing was the limited visibility forward and to the right in the thorp T-18.NTSB CHI90LA210Accident · No injuriesLimited investigationFinal reportPiper J-3 CUB · Clay Banks, WIPilot's failure to maintain an adequate visual lookout during the descent. Contributing factors are the pilot's poor weather evaluation, and continued VFR flight into IFR conditions.NTSB CHI90LA200Accident · No injuriesLimited investigationFinal reportBeech A36TC · Oshkosh, WIThe pilot's failure to recognize the deteriorating airspeed and imminent stall during the landing flare, which resulted in a hard landing.NTSB CHI90LA199Accident · No injuriesLimited investigationFinal reportFouga FOUGA-MAGISTER · Oshkosh, WIThe pilot-in-command's failure to maintain proper airspeed in turn from base to final.NTSB CHI90FA197Accident · 2 fatalField investigationFinal reportCustom Aerotech White Lightning · Oshkosh, WIThe pilot-in-command's failure to maintain airspeed to avoid loss of control of the aircraft.NTSB CHI90LA189Accident · No injuriesLimited investigationFinal reportMitsubishi MU-300 · Milwaukee, WIThe pilot's delayed determination of traction or braking action until too little runway remained to go around or to employ alternate means of activiating the brakes. Contributing to the accident was the overservicing of the main gear struts.NTSB CHI90LA187Accident · No injuriesLimited investigationFinal reportPiper PA-30B · Webster, WIThe failure of the nose gear transmission mounting bracket which resulted in nose gear collapse during the landing roll.NTSB CHI90LA194Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Pulaski, WIThe pilot's failure to maintain positive control of the airplane while landing. Factors related to the accident were the pilot's lack of total flight experience, and inadequate compensation for crosswind conditions.NTSB CHI90DER01Accident · No injuriesFinal reportPiper PA-28-140 · New Richmond, WIThe pilot's inadequate preflight inspection, which resulted in the gascolator drain being left open.NTSB CHI90DEP07Accident · No injuriesFinal reportBell 47-G2 · Hatley, WIThe partial loss of power due to sticking intake valves.NTSB CHI90DEP06Accident · 1 fatalFinal reportCessna 177B · Iola, WIFailure of the pilot to maintain adequate airspeed, which resulted in a stall/spin. Factors related to the accident were: the pilot's poorly planned approach, and his failure to go around.NTSB CHI90LA164Accident · Serious injuriesLimited investigationFinal reportCessna 182P · Cornell, WIThe pilot's inadequate preflight resulted in a loss of engine power due to contamination in the fuel system.NTSB CHI90LA157Accident · Minor injuriesLimited investigationFinal reportBeech K-35 · Oshkosh, WIFuel mismanagement.NTSB CHI90DEP05Accident · No injuriesFinal reportCirrus Klappmeier Cirrus VF-30 · Baraboo, WIManufacturer's inadequate equipment design to prevent a fuel leak which resulted in an in-flight fire. A factor related to the accident was the lack of an unsuitable forced landing area.NTSB CHI90DEP04Accident · Serious injuriesFinal reportGoss KR-2 · Kenosha, WIFailure of the pilot to maintain control of the aircraft, while flying it with a laterally imbalanced condition. Factors related to the accident were: the pilot's lack of flying experience, and his lack of familiarity with this aircraft.NTSB CHI90FA123Accident · 3 fatalField investigationFinal reportCessna 172N · New Richmond, WIFailure of the pilot to maintain sufficient airspeed to avoid a stall/spin. A factor related related to the accident was: the pilot's lack of familiarity with the make and model of aircraft.NTSB CHI90FA117Accident · 2 fatalField investigationFinal reportBellanca 8KCAB · West Bend, WIInflight failure of the right wing strut-to-spar attachment fitting due to fatigue initiated by improper welding techniques involving inadequate post-weld cooling control.NTSB CHI90LA116Accident · No injuriesLimited investigationFinal reportBeech E 55 · New Richmond, WIPilot's improper use of the landing gear mechanism during the landing roll, which resulted in the partial collapse of the landing gear.NTSB CHI90LA115Accident · Minor injuriesLimited investigationFinal reportBeech F33A · Milwaukee, WIThe utilization of improper procedures on the part of the pilot in command by attempting to execute a coupled approach outside the parameters of the autopilot.NTSB CHI90LA114Accident · No injuriesLimited investigationFinal reportRockwell AC-690 · Sheboygan, WIFailure of the pilot to complete the landing checklist and lower the landing gear. Contributing to this accident is habit pattern interference and distraction.NTSB CHI90LA107Accident · No injuriesLimited investigationFinal reportCessna 150G · Franklin, WIInadequate compensation for wind conditions by the pilot, and his failure to maintain runway alignment during the attempted go-around (aborted landing). The wind conditions and soft terrain were related factors.NTSB CHI90DEP03Accident · No injuriesFinal reportJames A Nelson ZEN AIR CH701 · Raymond, WIManufacturer's inadequate design of the fuel drain. Contributing was the pilot-in-command's disregarding the fuel supply which resulted in fuel exhaustion.NTSB CHI90LA103Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Wausau, WIA hard landing resulting from the pilot not taking timely remedial when a stall was encountered.NTSB CHI90LA074Accident · No injuriesLimited investigationFinal reportMBB BK-117A-1 · Janesville, WIThe pilot-in-command failed to ensure that the engine cowling latches were properly secured prior to departing on the maintenance test flight; the cowling came loose during flight, and contacted the main rotor blades before it separated from the helicopter.NTSB CHI90LA072Accident · No injuriesLimited investigationFinal reportBeech E18S · Oak Creek, WIImproper planning/decision by the pilot. Factors related to the accident were: the adverse weather conditions, accumulation of structural and/or induction ice, and dark night.NTSB CHI90FA066Accident · Serious injuriesField investigationFinal reportCessna 402A · Mosinee, WIThe pilot disregarding the published decision height and not performing a missed approach.NTSB CHI90FA065Accident · 1 fatalField investigationFinal reportCessna 402B · Appleton, WIThe pilot's decision to continue flight into known adverse weather conditions resulting in a windshear encounter with insufficient altitude for recovery. The existing adverse weather conditions were factors.