NTSB investigations, 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, 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' 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 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 CHI87FA187Accident · No injuriesField investigationFinal reportPiper PA-28 · Fairwater, WIWhen the plt attempted to add pwr to level off from a dscnt, the eng did not respond. He then applied carb heat & tried to restart the eng, but to no avail. During an emerg landing, the acft touched down with a tailwind, struck a fence & skidded to a stop in…NTSB CHI87FA185Accident · Serious injuriesField investigationFinal reportCessna 120 · Oshkosh, WIThe plt was taxiing out of the antique/classic camping area at Oshkosh with the assistance of wing walkers when he stopped to permit the pax (his wife) to perform an errand. The pax deplaned & went under the outer 1/3 of the wing strut, then walked back into…NTSB CHI87DEP10Accident · Serious injuriesFinal reportRobinson Avid Flyer · Tomah, WIThe homebuilt, hiwing acft had just been assembled by the owner/plt & was readied for its 1st flt. After takeoff from rwy 25, the acft entered a climb, turned back over the arpt & crossed over the rwy. Subsequently, it was maneuveredabout 500 to 800 ft south…NTSB CHI87DEP09Accident · No injuriesFinal reportAyres 600S-2D · Bancroft, WIOn landing the aircraft veered to the right. Application of left brake and rudder did not arrest the turn. The aircraft impacted a fence post rendering substantial damage to the aircraft. Subsequent investigation revealed an axle spacer on the right wheel was…NTSB CHI87LA169Accident · No injuriesLimited investigationFinal reportCessna 172 · Madison, WIThe instructor (CFI) & pvt plt (student) were on a renter's check-out flt to familiarize the student with a Cessna 172. While practicing landings, tower psnl provided a windshear alert. Drg an apch to land, the acft went into a high sink rate over the apch…NTSB CHI87DEP08Accident · No injuriesFinal reportUnknown Avid Flyer · Cottage Grove, WIOn return from the second test flight in the experimental aircraft, the pilot failed to maintain the proper descent rate on short final. An attempt to add power to correct the situation was unsuccessful, and the aircraft touched down on a highway short of the…NTSB CHI87LA160Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BC-12D · Dyckesville, WIAircraft stalled as the pilot attempted to climb and turn back to fly along green bay shoreline. The pilot was flying approx. 100 to 150 feet above the water in order for the passenger to photograph the shoreline.NTSB CHI87LA158Accident · Minor injuriesLimited investigationFinal reportCessna 175C · Oshkosh, WIDuring cruise flight near Oshkosh the engine quit for undetermined reasons. The pilot contacted wittman field and was cleared by air traffic personnel to land on runway 27. Attempts to restart the engine were not successful and the pilot ditched the aircraft…NTSB 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…NTSB CHI87DEP07Accident · Serious injuriesFinal reportPiper PA-36 · Plover, WIAfter spraying most of a bean crop, the plt was making clean-up swaths over an area at the north side of the field. This area had bldgs to the west & trees to the east. To avoid flying toward the bldgs, the plt elected to make the passes to the east (toward…NTSB 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.…NTSB CHI87LA143Accident · No injuriesLimited investigationFinal reportCessna 172N · Prairie Duchien, WIWhile in cruise flight, tape which was holding a piece of plexiglass over the cracked windshield came loose. The windshield lifted up and the pilot was not able to maintain altitude. During the forced landing in a soft field. The nose gear sheared off.NTSB CHI87LA141Accident · Minor injuriesLimited investigationFinal reportLuscombe 8E · Dodgeville, WIWhile landing on runway 30, the pilot reported that the wind shifted from a crosswind to a tailwind. During an attempted go-around the pilot lost directional control and struck a metal utility shed prior to impacting the ground.NTSB 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…NTSB 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…NTSB CHI87LA137Accident · No injuriesLimited investigationFinal reportAircoupe A-2-DEX · Iola, WIThe aircraft experienced a loss of engine power shortly after takeoff and was forced to make an emergency landing next to the runway. On landing roll the nose wheel of the aircraft stuck in the ground, flipping the aircraft over onto its back. According to a…NTSB CHI87LA131Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Neillsville, WIA student & instructor (CFI) were on a dual x-country flt fm elroy to Neillsville & rtrn. The flt to Neillsville was uneventfull. After the acft was on the gnd aprx 20 min, hot starting procedures were used to start the eng for the rtrn flt. Eng runup &…NTSB CHI87LA127Accident · No injuriesLimited investigationFinal reportCessna 152 · Waukesha, WIAccording to the plt, he entered downwind for rwy 18 and the apch 'seemed normal.' The plt stated that he 'slipped into wind' on final apch and extended ten degrees of flaps, but when he straightened out, the acft 'veered' to the left suddenly. According to…NTSB CHI87LA122Accident · No injuriesLimited investigationFinal reportCessna 152 · Footville, WIPilot landed in a field to practice an emergency landing. After two unsuccessful attempts to takeoff from the soft, plowed field, the pilot taxiied onto a two-lane road. On lift off the left wing struck a road sign.NTSB CHI87DEP05Accident · Serious injuriesFinal reportJohnson Quickie 2 · Eau Claire, WIThe pilot was attempting to land the experimental aircraft when he lost control and impacted on the rwy. This was the first time the pilot had flown this aircraft. The pilot stated the aircraft 'refused to flare properly.'NTSB CHI87LA116Accident · No injuriesLimited investigationFinal reportCessna 172XP · Superior, WIUpon landing on runway 13, pilot reports wind blowing aircraft towards the edge of runway. Aircraft went off right side, nose wheel stuck in mud and collapsed, and aircraft nosed over. Winds at duluth, MN, approx. 11 nmi northwest of accident site, were…NTSB CHI87DEP03Accident · No injuriesFinal reportErickson Sonerai 2L · Algoma, WIWhile in normal cruise flight the crankshaft failed at the propeller flange and the propeller departed the aircraft. The pilot executed a forced landing to a farm field. He was unable to flare successfully and lost control during landing.NTSB CHI87LA102Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Merrill, WIAircraft lost power on takeoff and plt made a forced landng in a rough field. The left main gear collapsed and substantial damage to the outer two feet of the right wing was sustained. Inspection of the aircraft after the accident did not disclose cause of…NTSB CHI87LA095Accident · No injuriesLimited investigationFinal reportBeech C24R · Manitowoc, WIPilot flared too high on landing. Aircraft landed hard and nose wheel broke off.NTSB CHI87LA092Accident · No injuriesLimited investigationFinal reportMooney M-20G · Kenosha, WIWhile on downwind leg the pilot heard another aircraft call downwind. When he turned to final the other aircraft turned base. As he descended on final approach the other aircraft turned sharply inside the acft on final and landed. The following aircraft…NTSB 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.NTSB 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…NTSB CHI87LA082Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Oshkosh, WIAccording to the plt, at aprx 1800 feet 'the engine abruptly quit with no runon or sputter' following takeoff from rwy 18 at Oshkosh, WI. The plt stated that he banked the acft back to the airport, but the aileron controls became jammed or 'frozen'. According…NTSB CHI87LA075Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Dodgeville, WIWhile taxiing after landing on runway 12, a tailwind was encountered. The acft spun around, slid backwards off the rwy, down a steep embankment and struck a large rock. The plt reported winds from 270 degrees at 12 knots gusting to 18 knots.NTSB CHI87LA073Accident · No injuriesLimited investigationFinal reportCessna 182M · East Troy, WIThe aircraft was cruising at approximately 2000 feet AGL when the engine began running rough. The plt stated that he added carburetor heat and leaned the mixture, but the engine continued to run rough. The plt elected to make a precautionary landing in an…NTSB CHI87DEP01Accident · Minor injuriesFinal reportChampion 7ECA · La Crosse, WIAfter the third try at an engine start the eng started and ran at full throttle. The plt could not reduce RPM. To avoid striking two parked acft the plt struck a hangar. Post accident investigation revealed that the throttle cable was not operating properly.…NTSB CHI87LA059Accident · No injuriesLimited investigationFinal reportCessna 172H · Mosinee, WIThe CFI stated that while in the landing configuration, over the apch end of the rwy, the student excessively flared the acft and it stalled with the right wing contacting the rwy. According to the CFI, power was added but it was too late to 'save the…NTSB CHI87DEP04Accident · No injuriesFinal reportMooney M20F · Greenwood, WIThe aircraft lost engine power during a descent due to a loose throttle linkage and the pilot was forced to make an emergency landing in a field. On landing roll the aircraft struck a reflector post with the right wing.NTSB CHI87LA055Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · Harrison Twp., WIDuring cruise flt the plt attempted to add power and carb heat with no immediate response in eng power. The plt then tried to make an emergency landing in a field but did not have sufficient altitude and airspeed. The acft collided with trees. The plt…NTSB CHI87LA056Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Madison, WIWhile practicing touch & go landings, the student plt reports, the acft 'suddenly dropped' resulting in a hard landing. The acft then porpoised separating the nose gear and skidding to a stop off the rwy.NTSB CHI87LA052Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Middleton, WIAt the completion of a period of instrument training and while returning to the airport of origin the CFI asked the private rated dual student to demonstrate a simulated forced landing to the runway. In an attempt to lose altitude on the final approach the…NTSB CHI87IA039Incident · No injuriesIncident investigationFinal reportDouglas DC-9-51 · Madison, WIAircraft slid off the right side the runway during the rollout from a cross wind landing and struck 6 runway edge lights causing minor damage to the inboard trailing edge of the right flap. At the time of the incident there was 1/2 inch of snow on the runway…NTSB CHI87LA037Accident · No injuriesLimited investigationFinal reportMooney M20K · Watertown, WIFollowing an engine power loss due to fatigue of the #1 cylinder, the plt force landed the acft on a highway. The highway was the only available landing area, according to the plt. On landing rollout, the plt was forced to swerve the acft off the paved…NTSB CHI87LA034Accident · Serious injuriesLimited investigationFinal reportRaven S-66A · Baldwin, WIWhile landing, the passengers were instructed to stay to the side of the basket and hold on. However, one passenger moved toward the center of the basket and hit a video camera with her leg. During the occurrence, her leg was fractured between the knee and…NTSB CHI87LA014Accident · No injuriesLimited investigationFinal reportBeech V35A · La Pointe, WIThe acft struck a deer during the landing flare. The plt was able to maintain control of the acft and complete the landing even though the acft sustained substantial damage to the right wing and its associated structure.NTSB CHI87LA008Accident · No injuriesLimited investigationFinal reportCessna 177 · Waukesha, WIAccording to the plt, it was a normal flight and approach to rwy 18. On touchdown, the acft nose dropped and the acft bounced three of four times. The plt stated that he immediately added pwr and became airborne, but a vibration caused him to cut pwr and land…NTSB CHI86LA236Accident · No injuriesLimited investigationFinal reportHughes 269B · Baldwin, WIAfter picking up his passenger at williams pipeline, minneapolis, Minnesota, the plt flew eastward along interstate 90 enroute to a pipeline near wausau, Wisconsin. While flying at approximatelly 400 feet, the plt and passenger stated that the engine started…NTSB 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…NTSB CHI86FER18Accident · No injuriesFinal reportShanks/Becker Acro Sport · New Richmond, WIAccording to the pilot during landing rollout his left wing encountered three to four foot high grass growing up to the edge of the turf runway. The aircraft then veered off into a ditch. The runway involved is 2100 feet long and 75 feet wide.NTSB CHI86LA214Accident · Serious injuriesLimited investigationFinal reportPiper PA-12 · Menominee Falls, WIThe plt stated that the eng had quit 3 times in the past 2 weeks. The purpose of the flt was to insure that the eng was working properly. During takeoff, it lost power at about 100 ft AGL. The plt tried to turn & land on the sw part of the arpt. However, a…NTSB CHI86FER17Accident · Serious injuriesFinal reportEugene Boos VARI-EZE · Rice Lake, WIDuring cruise flight the engine of this homebuilt aircraft began running rough. The pilot turned toward an airfield approximately 15 miles away, but was forced to perform a forced landing about 5 miles short of this field because, following a loud metallic…NTSB CHI86LA213Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Clintonville, WIFollowing at least three successful practice low approaches to a farm field, the student pilot climbed over a small wooded area and did a 180 degree turn to perform an approach to another field. He flew down to within 20 feet of the ground, then applied full…NTSB CHI86LA210Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Lodi, WIDuring a practice emergency landing approach, the instructor told the student to go around at an altitude of about 600 feet AGL. The student failed to add power and pulled the yoke all the way back. The aircraft then stalled. The instructor took control,…NTSB CHI86FA199Accident · No injuriesField investigationFinal reportCessna 177 · Oshkosh, WIA spl tfc management program was in effect for an annual eaa fly-in, & a waiver to FAA handbook 7110.65D was in effect which allowed for reduced sepn btn acft opng at wittman fld. As 2 acft were lndg, the plt of the 1st acft (Cessna 177, N17204) was told to…NTSB CHI86LA196Accident · No injuriesLimited investigationFinal reportPiper PA-20-115 · Mosinee, WIFollowing departure from oshkosh, WI, the plt proceeded directly to central Wisconsin airport, Mosinee, WI, at aprx 2500 ft MSL. After receiving an arpt advisory from the central Wisconsin UNICOM, the plt landed on rwy 26. According to the plt, a 30-35 deg…