Fatal NTSB investigations, WI

180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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, newest first

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 c.\"eventStateOrRegion\" = 'WI' AND c.\"eventCountry\" = 'USA'
    AND c.\"highestInjuryLevel\" = 'Fatal'
  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.

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.Aug 19, 1990 · N4070Q · DestroyedNTSB CHI90FAMS3Accident · 2 fatalMissing aircraftFinal reportCessna 172M · Kewaunee, WIUndetermined.Aug 14, 1990 · N9529H · DestroyedNTSB 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.Aug 12, 1990 · N9468V · DestroyedNTSB 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.Aug 2, 1990 · N25400 · DestroyedNTSB 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.Jul 26, 1990 · N7147W · DestroyedNTSB 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.Jul 6, 1990 · N30666 · DestroyedNTSB 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.May 6, 1990 · N76089 · DestroyedNTSB 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.Apr 24, 1990 · N2976R · DestroyedNTSB 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.Jan 17, 1990 · N87163 · DestroyedNTSB CHI90FA055Accident · 3 fatalField investigationFinal reportBeech A24R · Merrill, WIFlight into known adverse weather by the pilot, and structural/wing ice. Factors related to the accident were: the icing conditions and trees in the area of the accident.Dec 28, 1989 · N37329 · DestroyedNTSB CHI90FA028Accident · 3 fatalField investigationFinal reportBeech A36 · Shell Lake, WIThe pilot-in-command's failure to perform a missed approach, his descending below the minimum descent altitude, and his failure to maintain proper altitude to avoid impact with the terrain. Contributing to the accident was the pilot-in-command's lack of total…Nov 14, 1989 · N1607W · DestroyedNTSB CHI89FA155Accident · 2 fatalField investigationFinal reportLancair 235 · Fond Du Lac, WIFailure of the pilot-in-command to assure that adequate airspeed was maintained during the turn to final approach, which resulted in an inadvertent stall/spin.Aug 1, 1989 · N385L · DestroyedNTSB CHI89DEP10Accident · 1 fatalFinal reportAir Tractor AT-301 · Plainfield, WIFailure of the pilot-in-command to maintain control of the aircraft while conducting aerial application maneuvers in close proximity to the terrain.Aug 1, 1989 · N5044S · DestroyedNTSB CHI89LA147Accident · 1 fatalLimited investigationFinal reportPiper PA-38-112 · River Falls, WIImproper remedial action by the pilot following an abrupt maneuver. The pilot's lack of total aviation experience was a factor in the accident.Jul 27, 1989 · N25687 · DestroyedNTSB CHI89FA113Accident · 1 fatalField investigationFinal reportCessna 150L · Wisc Rapids, WIThe pilot's failure to assure that the flaps were in the up position during takeoff. A factor related to the accident was the pilot's lack of familiarity with aircraft.Jun 18, 1989 · N6878G · DestroyedNTSB CHI89FA049Accident · 3 fatalField investigationFinal reportCessna 172RG · Mosinee, WISpatial disorientation of the pilot as a result of initiating the flight into known adverse weather. Factors related to the accident were: dark night, snow, and low ceilings.Feb 8, 1989 · N6525V · DestroyedNTSB CHI89DEP01Accident · 1 fatalFinal reportCessna T337G · Green Bay, WIThe pilot's loss of aircraft control, due to the loss of cockpit/instrument panel lighting for an undetermined reason, the inoperative penlight, and subsequent spatial disorientation of the pilot. Factors related to the accident were: darkness and the adverse…Jan 26, 1989 · N6CF · DestroyedNTSB CHI88FA248Accident · 2 fatalField investigationFinal reportCessna 210L · Monroe, WISep 30, 1988 · N5268V · DestroyedNTSB CHI88DEP13Accident · 1 fatalFinal reportHeibel AIR Command 532 · Cottage Grove, WIWhile in cruise flight this amateur built gyrocopter experienced a main rotor strike to the rudder and propeller. The student pilot who had a total of eight hours flight time, all in this aircraft, was conducting a solo flight in this dual control gyrocopter.…Sep 21, 1988 · N7015C · DestroyedNTSB CHI88DEP12Accident · 1 fatalFinal reportPiper PA-36-300 · Pulaski, WIThe aircraft descended at a high rate of speed, 75 degrees nosedown, into the terrain. His widow stated that the pilot had left home at approximately 2100 CST on the accident night, in an inebriated condition. After a discussion about his drinking, he…Sep 14, 1988 · N57847 · DestroyedNTSB CHI88FA179Accident · 1 fatalField investigationFinal reportPiper PA-30 · Oshkosh, WIJul 29, 1988 · N43GS · No damageNTSB CHI88FA120Accident · 1 fatalField investigationFinal reportBellanca 17-30A · Wautoma, WIPerformance of an aerobatic maneuver with insufficient altitude for recovery.May 31, 1988 · N28156 · DestroyedNTSB CHI88FA102Accident · 1 fatalField investigationFinal reportBellanca 7ECA · Merrimac, WIThe pilot had just taken off from a private strip and immediately entered a high angle of bank turn to the left at low altitude. A witness, who was an experienced aerobatic pilot, estimated the angle of bank to approach 90 degrees. The nose was seen to pitch…May 1, 1988 · N31288 · DestroyedNTSB CHI88FA056Accident · 1 fatalField investigationFinal reportCessna 150M · Norwalk, WIThe pilot made several calls to the fss and obtained weather briefings for reported and forecast IFR conditions along his proposed route of flight. After departure from sparta, Wisconsin in weather described by witnesses to be below VMC, the aircraft impacted…Jan 31, 1988 · N9458U · DestroyedNTSB CHI88MA026Accident · 8 fatalMajor investigationFinal reportBeech 200 · Jefferson, WIWhile cruising abv frzg lvl at 12,000', the flt was clrd to dscnd & maint 9000'. Abt 1-1/2 min ltr, the flt declared a mayday (emergency). Radio & radar ctc were lost & the acft crashed in a nr vertical dscnt. Radar data showed that after starting a dscnt,…Nov 16, 1987 · N334DP · DestroyedNTSB CHI87FA197Accident · 2 fatalField investigationFinal reportAeronca 7AC · Kenosha, WIThe aircraft was on final approach for landing during a dual instructional flight. The aircraft was observed to pitch up, then enter a nose down, right wing low attitude which it maintained until it impacted the ground. Witnesses, including another CFI who…Aug 30, 1987 · N3406E · DestroyedNTSB MKC87FA161Accident · 2 fatalField investigationFinal reportPiper PA-22-150 · Solon Springs, WIThe surviving pax rprtd that drg initial climb after takeoff, the eng suddenly stopped & did not respond to atmts of a restart. The plt turned back toward the arpt, but was unable to reach the rwy. The acft impacted large trees in a wooded area, then crashed…Aug 15, 1987 · N5831D · DestroyedNTSB CHI87FA153Accident · 2 fatalField investigationFinal reportPiper PA-28R · Milwaukee, WIDrg arr at the Milwaukee/lawrence j timmerman arpt, the plt made 2 atmts to use the localizer 15L apch. After the 2nd missed apch, he elected to divert to Milwaukee/general mitchell fld (mke). At that time, he was adzd the mke wx was 300' ovc, 1/4 mi vis with…Jun 22, 1987 · N2678R · DestroyedNTSB CHI87FA149Accident · 2 fatalField investigationFinal reportCessna 172A · Tomah, WIThe pilot had flown a closed pattern and was making touch and go landing. A witness saw the acft bounce and then initiate a go around. The surviving pax said the stall warning horn was sounding 'a long time.' At midpoint of downwind leg the acft stalled out.…Jun 20, 1987 · N7189T · DestroyedNTSB CHI87FA140Accident · 4 fatalField investigationFinal reportGrumman American AA-5 · Middleton, WIThe pilot had communicated with other pilots concerning the difficulties he was having with the winds. He had already attempted approaches to two other runways but had failed to complete a landing. He asked the pilot of a recent arrival for the wind…Jun 7, 1987 · N1358R · DestroyedNTSB CHI87DEP06Accident · 1 fatalFinal reportZank Challenger II · Redgranite, WIThe student pilot had purchased this amateur built aircraft earlier in the day and had made one successful flight and was on the downwind leg of the second flight. The aircraft was at an estimated altitude of 150' to 200' AGL, when witnesses stated that the…Jun 4, 1987 · N56DZ · DestroyedNTSB CHI87DEP02Accident · 1 fatalFinal reportCessna 182N · Wissota, WIWhile attempting a night landing, by use of car headlights, the aircraft struck wires and descended out of control into the terrain. Witnesses stated that the pilot seemed low during the final approach. The private airport was not lighted.Mar 8, 1987 · N92840 · DestroyedNTSB CHI87LA086Accident · 1 fatalLimited investigationFinal reportCessna 172RG · Camp Douglas, WIThe passenger rprtd that about 5 min after takeoff, the plt became incapacitated & was no longer able to maintain control of the acft. The non-certificated passenger assumed control. With the assistance (instructions) from an airborne flt instructor & an…Feb 20, 1987 · N4601V · Substantial damageNTSB CHI86FEP09Accident · 1 fatalFinal reportPiper PA-32R-300 · Wisconsin Rapid, WIATC had cleared the aircraft for an approach to an airport with several nonprecision instrument approaches and to maintain an altitude until established on a segment of an approach to that airport. Shortly after that time witnesses located 4.5 miles northwest…Sep 20, 1986 · N4909F · DestroyedNTSB CHI86FA179Accident · 2 fatalField investigationFinal reportStinson 108-3 · Shiocton, WIWitnesses rprtd that prior to the acdnt, the acft was flying at a very low level, near treetop level, over residences, a ball park & a lake park. Subsequently, the acft collided with a utility pole & trees, then crashed into a private residence & burst into…Jul 26, 1986 · N6567M · DestroyedNTSB CHI86FA174Accident · 2 fatalField investigationFinal reportCessna 172K · Random Lake, WIThe acft lost pwr on final apprch and crashed into a swamp. Post accident investigation revealed that the eng camshaft was worn reducing the pwr output of the powerplant.Jul 20, 1986 · N79069 · DestroyedNTSB CHI86FA171Accident · 1 fatalField investigationFinal reportAero Commander 100 · Crivitz, WIFollowing one approach to land under conditions of low visibility (less than 1/4 mile) the pilot attempted to land again. On base leg, according to witnesses, the aircraft fell to the ground. In the wreckage the stall warning light bulb filament was grossly…Jul 16, 1986 · N3667X · DestroyedNTSB CHI86FEP01Accident · 2 fatalFinal reportCessna 177 · Portage, WISeveral witnesses stated that upon climbout following a low pass, smoke came out of the engine and the engine sputtered. The aircraft was then seen in a steep turn. During this turn the wings reached a vertical position and the aircraft descended to the…Mar 29, 1986 · N29849 · DestroyedNTSB CHI86FA017Accident · 1 fatalField investigationFinal reportBell 47G-5 · Plainfield, WIThe acft crashed into trees and nosed into the wooded terrain after a loss of powr. The helicopter had been refueled the day before the acc. Normal fuel load was 20 gals. The plt had sprayed 20 acres & flown 9 miles to another field to spray but aborted due…Oct 27, 1985 · N7840S · DestroyedNTSB DCA85AA036Accident · 31 fatalFinal reportDouglas DC-9-14 · Milwaukee, WIThe Safety Board's full report on this investigation is provided as Aviation Accident Report number AAR-87/01. To obtain a copy of this report, or to view the executive summary online, please see the Web site at http://www.ntsb.gov/publictn/publictn.htm Drg…Sep 6, 1985 · N100ME · DestroyedNTSB CHI85FA334Accident · 1 fatalField investigationFinal reportCessna 182Q · Walworth, WIThe pilot took off with weather conditions of 100 ft ceiling & visibility of 1/4 mile. Theflight tookd off to the south & crashed in a corn field south of the airstrip tracking 058. The engine was heard at a high power setting just prior to impact.Aug 5, 1985 · N11VS · DestroyedNTSB CHI85FA253Accident · 2 fatalField investigationFinal reportPiper PA-28-151 · Reedsburg, WINo known witnesses observed the plt preflt the acft or takeoff. He departed in the evening while the arpt was not attended. At aprx 2012 CDT, his son observed & recognized the acft. At that time, the son was at his own home about 1/2 mi from the plt's home.…Jun 26, 1985 · N32461 · DestroyedNTSB CHI85FA176Accident · 1 fatalField investigationFinal reportCessna R182 · Prairie Dusac, WIThis midair collision occurred approx 2 mi NE of sauk-Prairie apt. The pilots of the Cessna were in a climbing right departure turn at approx 1600 ft MSL heading approx 120 deg when a collsion occurred with a Piper heading approx 270 deg and descending. One…Apr 26, 1985 · N4707T · 2 aircraft · Substantial damageNTSB CHI85FA036Accident · 1 fatalField investigationFinal reportPiper PA-32R-300 · North Freedom, WIAt an early morning predeparture wx briefing the pilot was advised of deteriorating afternoon wx pilot flew cross country conducted business and departed late afternoon with no wx brief no flt plan departure area and destination both reporting IMC while…Oct 31, 1984 · N30TR · DestroyedNTSB CHI85FA021Accident · 2 fatalField investigationFinal reportTaylorcraft BC12-D · Kiel, WIWitnesses observed acft performing aerobatics during demo flight prior to prospective sale of acft to buyer/pax. A plt/witness observed the acft executing slow speed stalls and enter a spin from an altitude of about 1000 ft. recovery was accomplished at about…Oct 20, 1984 · N43833 · DestroyedNTSB CHI85FA020Accident · 2 fatalField investigationFinal reportPiper PA-32-300 · Bruce, WIThe acft crashed into a heavily wooded area during a x-country personal flight. Witnesses observed the acft circle the lighted football field at atlanta, WI, at an altitude low enough that they feared the acft would hit trees in the vicinity. At this time the…Oct 20, 1984 · N2898D · DestroyedNTSB CHI84FA376Accident · 3 fatalField investigationFinal reportPiper PA-18-150 · Oak Grove, WIThe plt stated to the host of the picnic that he would 'buzz the party a couple of times.' The two seat acft had three occupants aboard at the time of the accident. Witnesses stated that the acft passed over the picnic twice at a very low altitude. The acft…Sep 3, 1984 · N8042B · DestroyedNTSB CHI84FA364Accident · 4 fatalField investigationFinal reportCessna A185F · Lake Delton, WIThe float plane crashed shortly after taking off from Lake Delton while of a sight-seeing flt. The acft was used daily during the tourist season on flts of aprx 15 min long. This was the 8th or 9th flt of the day & was the 4th or 5th flt since refueling. A…Aug 26, 1984 · N61584 · DestroyedNTSB CHI84LA338Accident · 1 fatalLimited investigationFinal reportPiper PA-28-160 · Palmyra, WIWhile on a personal flt the eng and airframe began to vibrate severely. The plt closed the throttle and turned eastward to land in a mint field. As he approached the field he applied power to clear a row of small houses, but during this maneuver struck a…Aug 4, 1984 · N5086W · DestroyedNTSB CHI84FA374Accident · 2 fatalField investigationFinal reportPiper PA-28-180F · Cable, WIThe acft collided with trees & ground during IMC wx at night. The plt obtained a wx briefing at 1731 hrs CDT by phone from hibbing fss. He was advised that VFR flt was not recommended. No other wx briefing for this flt was recorded. Witnesses at the arpt of…Aug 4, 1984 · N3963R · Destroyed