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 CHI86FA194Accident · Serious injuriesField investigationFinal reportPiper PA-24-250 · Oshkosh, WIThe aircraft ran out of fuel after 3+41 hours of flight. The pilot stated that he was sure the tanks were full on takeoff. Flight planning and a documented conservative fuel burn rate indicated that the aircraft should have been able to remain airborne for at…NTSB CHI86FEP08Accident · Minor injuriesFinal reportNorth American T28D-FENNEC · Madison, WIAfter the aircraft was initally taxied for takeoff, the pilot returned to the ramp and stated that he was experiencing engine problems. He inquired at an FBO about chartering an aircraft to take himself and his son to an experimental aircraft association…NTSB CHI86FA193Accident · No injuriesField investigationFinal reportCapetown Builders Glasair RG · Fond Du Lac, WIThe pilot experienced a complete electrical system failure that was caused by a broken wire at an alternator terminal. Upon extension of the hydraulically operated landing gear a safe gear down indication was not obtained. Activation of the CO2 operated…NTSB CHI86FA192Accident · No injuriesField investigationFinal reportCessna 177RG · Oshkosh, WIThe IFR flt experienced an engine failure during the landing apch to the destination aprt in Oshkosh, WI, and the plt ditched the acft in lake winnebago. Exam of the acft showed that the eng failed due to fuel exhaustion. The plt reported there were 60…NTSB CHI86FEP07Accident · No injuriesFinal reportWheeler Gold Wing · Sturdevant, WIThis aircraft force landed shortly after takeoff and was substantially damaged when the wing struck the shoulder of a ditch during the landing. An examination of the engine after the accident revealed that the fuel pump was improperly installed (not in…NTSB CHI86LA188Accident · No injuriesLimited investigationFinal reportBellanca 17-30 · Winneconne, WIWhile landing, the plt failed to maintain directional control. Subsequently, the acft went off the right side of the rwyand entered a skid. The left main gear collapsed, then the nose gear collapsed.NTSB CHI86LA182Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Dodgeville, WIAccording to the pilot, his brakes failed and he was unable to stop before going off the end of the runway and over a 30 foot embankment. During an inspection, the brakes and braking system were found to be free of any defects and in proper working order.…NTSB CHI86LA181Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Middleton, WIThe CFI and student had been practicing touch-and-go's and had just made a full stop landing. The CFI reported that during a subsequent soft field takeoff, accelleration seemed a little slow, and after lift-off, the aircraft seemed to stop accelerating…NTSB 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…NTSB 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.NTSB CHI86FEP06Accident · No injuriesFinal reportPatton Pitts S-1C · Hartford, WIThe plt was on an aerobatic competition flt. He reported that after finishing a sequence of aerobatic maneuvers, he returned to the rwy to land. During the landing, the acft was high on final apch & touched down to FAR down the 2100 ft rwy. It then contd off…NTSB 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…NTSB CHI86LA167Accident · Minor injuriesLimited investigationFinal reportCessna A152 · Middleton, WIThe student pilot stated that he was practicing soft field takeoffs on a grass strip. He aborted his first attempt to make an intersection takeoff. On his second try, he thought he could get airborne, but did not. The aircraft struck an embankment near the…NTSB CHI86LA159Accident · No injuriesLimited investigationFinal reportCessna 152 · Shiocton, WICFI delayed corrective action during a practice forced landing by a student. Aircraft touched down with insufficient runway remaining to stop safely. During the subsequent go-around attempt the aircraft rolled into a plowed field and nosed over.NTSB CHI86FEP05Accident · No injuriesFinal reportBeech C-23 · Milwaukee, WIDuring taxi for takeoff the plt inadvertently taxied onto an access road and struck and unlit sign. The taxiway had been resurfaced and no taxi guide lines had been repainted.NTSB CHI86LA149Accident · Minor injuriesLimited investigationFinal reportPiper J3 · Brodhead, WIThe plt was making a low pass over a friend's house. He was waving to the people on the ground and when he looked up he was too close to a tree to avoid hitting it. The plane then descended to the ground.NTSB CHI86FA151Accident · No injuriesField investigationFinal reportBeech 55 · Kenosha, WIThe acft was on a positioning flt returning from traverse city, MI, to Kenosha, WI. The reported milwaukee weather was ceiling 300 ft and visibility 2 miles. The pilot was cleared for a VOR 14 approach and given vectors to the final approach course. The pilot…NTSB CHI86LA150Accident · No injuriesLimited investigationFinal reportCessna 182F · Hillsboro, WIThe pilot stated that following touchdown a gust of wind caused the aircraft to balloon back into the air. The second touchdown was in a crab angle and the aircraft began to slide sideways. The right wing struck the runway just as the aircraft departed the…NTSB CHI86LA148Accident · No injuriesLimited investigationFinal reportCessna 182K · Durand, WIAccording to the pilot, winds at the time of the accident were out of the southwest at 10 gusting to 15 knots. He stated that upon landing on runway 18, the aircraft lifted slightly and rotated approximately 10 degrees to the right. It then ran off the edge…NTSB CHI86LA145Accident · No injuriesLimited investigationFinal reportCessna 182P · Platteville, WIThe plt landed the acft on rwy 7 which was wet. Winds at the time were from 120 degs at 12 KTS. The plt stated that the wind caused the acft to skid and travel off the left side of the rwy. The acft nosed over after contacting soft soil alongside the rwy.NTSB CHI86FER07Accident · No injuriesFinal reportCessna 172P · Webster, WIShortly after lift-off, the plt noted a loss of power as the acft was climbing, about 40 ft above the rwy. He rprtd the eng 'appeared to run a little above idle.' He landed the acft on the remaining rwy, but it contd off the departure end & nosed over. No…NTSB CHI86LA138Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Webster, WIDuring an attempted go-around after a bounced crosswind landing, pilot failed to maintain a proper ground track and the aircraft collided with trees.NTSB CHI86LA123Accident · No injuriesLimited investigationFinal reportCessna 182 · Augusta, WIThe pilot made his approach to runway 27 after noticing that the winds were from the north northwest. He said the made his approach at 80 KTS because of the crosswind. After touching down beyond his intended touchdown area he felt he would not clear the trees…NTSB CHI86FEP04Accident · No injuriesFinal reportDay Skybolt DB · Wisconsin Rapid, WIThe plt thought he had sufficient fuel for a 'short trip around the pattern.' However, shortly after taking off from rwy 29, the eng began to lose power. The plt attempted to land on rwy 2, but all power was lost & he was unable to reach the rwy. He landed…NTSB CHI86FEP03Accident · Minor injuriesFinal reportSteinorth Extra Long EZ · Kenosha, WIDuring an apch to land, the eng of the home built acft lost power. The plt tried to restart the eng by using the ignition switch, but was unable. He turned to land in a pasture, but the acft hit an electrical wire & came to rest in a row of trees. The plt…NTSB CHI86FEP02Accident · Serious injuriesFinal reportPiper PA-38-112 · Dexterville, WIOn the fourth flight of the day carrying relatives in the vicinity of another relatives house the pilot admitted that he allowed the airspeed to decay during a 55 degree bank and did not recognize an impending stall. When the aircraft stalled there was…NTSB 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…NTSB CHI86LA110Accident · No injuriesLimited investigationFinal reportCessna 172MM · Middleton, WIThe 94 hour private pilot was attempting a landing with a crosswind component of 90 degrees and a wind velocity of 15 to 18 KTS gusting to 22 KTS when he touched down with the right main gear & 2 feet off the right side of the runway. The right main gear came…NTSB CHI86LA097Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Milwaukee, WIThe aircraft was approximately 180 lbs over max recommended takeoff gross weight and used almost all of a 3560 foot runway to take off. The pilot stated that after liftoff the aircraft would not turn left and began to turn right on its own. He climbed to…NTSB CHI86LA095Accident · No injuriesLimited investigationFinal reportCessna 172C · Waupun, WIDrg arrival for a x-wind landing, the plt made a high apch & used full flaps to steepen his dscnt over trees near the apch end of the rwy. He stated that the touchdown was normal, but before he could raise the flaps, the x-wind pushed the plane to the left.…NTSB CHI86FA092Accident · Serious injuriesField investigationFinal reportBeech G18S · Janesville, WIThe aircraft impacted the ground about 1,000 ft to the left of the runway. The pilot stated that he did not have visual contact with the ground & remembers attempting to make a missed approach. Conditions were IMC.NTSB CHI86LA084Accident · No injuriesLimited investigationFinal reportCessna 207 · Milwaukee, WIAfter preheating the eng the plt took off and during climb the cabin filled with smoke and the eng stopped. A forced landing was made on a city street during which the left wing contacted a sign pole. Post accident teardown of the eng disclosed that an oil…NTSB CHI86LA085Accident · No injuriesLimited investigationFinal reportCessna 401B · Milwaukee, WIWhile taxiing to park, the left main landing gear collapsed. Investigation revealed that the left hand gear support had torn from the wing rib to which it was bolted. On the FAA malfunction or defect report submitted by the operator, company officials stated…NTSB CHI86LA078Accident · No injuriesLimited investigationFinal reportMooney M20-K · Madison, WIA gear up landing was performed by the pilot. He stated that he was distracted by an airliner ahead of him in the pattern and did not consult his before landing checklist. He also stated that he had not flown much in the last three months.NTSB CHI86LA075Accident · No injuriesLimited investigationFinal reportCessna 172 · Baraboo, WIThe plt attempted a x-wind landing that was beyond his capabilities. He stated that if the x-wind was excessive he intended to divert to another arpt with a more favorable runway. At touchdown the aircraft drifted right into a two foot high snow bank off the…NTSB CHI86LA074Accident · No injuriesLimited investigationFinal reportCessna L-19 · Kenosha, WIThe pilot drained the fuel tanks until no evidence of water was present. Alcohol & 100LL was added prior to takeoff. In the traffic pattern engine power was lost. The runway was over flown & a collision with a fence insued during the forced landing. Water was…NTSB CHI86LA053Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Glidden, WIThe aircraft collided with powerlines while attempting a power off landing after engine stoppage. The fuel tanks were inspected and there was no fuel in the right tanks and only a small quantity in the lft tank. The engine was tested and found to function…NTSB CHI86LA049Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Dodgeville, WIAfter a x-country flt and during the landing roll the acft started to drift left on the snow covered rwy. The left main gear then encountered deeper snow causing the acft to swing to the left and run into a six-ft snowbank.NTSB CHI86LA022Accident · Serious injuriesLimited investigationFinal reportCessna 182N · Kenosha, WIAccording to the pilot the flight from toledo to the kenoshaarea was uneventful. During the VOR approach to rwy 14 (approx 2 miles from the end of the runway) the aircraft impacted the ground and was destroyed. The pilot stated that the last thing he rembered…NTSB 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…NTSB CHI86LA010Accident · Serious injuriesLimited investigationFinal reportBeech K35 · New Lisbon, WIAccording to the plt, acft preflight, engine runup and warm up were normal. Takeoff and initial climb up to approx 300 ft AGL were normal also. At this point the engine quit and the plt performed a forced landing in a clover field below him. The acft was…NTSB CHI86LA008Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Lake Geneva, WIAfter touchdown & about 600 ft from the approach end of runway 23 the aircraft collided with a moped crossing the runway. The 11 yr old operator of the moped was seriously injured.NTSB CHI86LA005Accident · No injuriesLimited investigationFinal reportTodd Pitts · Hartford, WIN2032 had taken off, remained in the traffic pattern, & landed. N14JK had taken off, obtained a radio check at altitude,descended and entered the traffic pattern. Immediately afterlanding N14JK ran into N2032. N14JK reportedly made two radio calls in the…NTSB CHI86LA002Accident · No injuriesLimited investigationFinal reportCessna 172 · Crivitz, WIThe plt lost directional control of the acft during the landing roll in x-wind conditions. As the acft veered to the left side of the rwy it struck a rwy light. The arpt owner stated the acft touched down in a crabbed position and the local winds were from…NTSB CHI85LA384Accident · No injuriesLimited investigationFinal reportCessna 150H · Racine, WIThe pilot reported a gust of wind resulted in a nose high left turn just prior to touchdown. Power was added & the left wing contacted the runway. The aircraft went off the left side of the runway and hit a ditch.NTSB CHI85LA374Accident · No injuriesLimited investigationFinal reportCessna T210N · Minocqua, WIThe PIC attempted to start the engine. The engine started but in about 3 seconds stopped. During a second start attempt a fire started in the engine compartment. The PIC thought he had extinguished the fire when flames were seen in the copilot pedal area. The…NTSB 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…NTSB CHI85FEP04Accident · Serious injuriesFinal reportPZL-Bielsko SZD-45A Ogar · Ft. Atkinson, WIWitnesses reported seeing the acft shortly after takeoff at an alt of aprx 40 to 50 ft AGL. At this time, according to witnesses, the eng slowed down, the acft turned left and dove into the terrain. No mechanical failure/malfunction was discovered during an…NTSB CHI85IA359Incident · No injuriesIncident investigationFinal reportBritish Aerospace BAC 1-11-201AC · Green Bay, WIThe airplane landed & touched down in the first 1/3 of the runway. It veered to the left, then back to the center & went off the end the runway showed signs of steam cleaning where the tires were & the tires showed signs of rubber inversion. The pilot elected…NTSB CHI85FEP03Accident · Serious injuriesFinal reportRoger W. Stigen EAA Biplane SR-1 · Sprimg Greem, WIEaa bi plane N3541, piloted by john boatright, and registered to freeborn county aircraft inc., albert lea, Minnesota, sustained substantial damage during a landing approach to runway 27 at the lone rock airport at approximately 1900 CDT on August 26, 1985.…