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 CHI85FA344Accident · No injuriesField investigationFinal reportLearjet 23 · Madison, WIThe plt elected to take off with a heavy loaded acft on the short rwy. The plt stated a loud noise was heard as the acft approached 80 KTS. The takeoff was aborted at 100 KTS. Hydroplaning was experienced and a loss of control occurred. The acft traveled off…NTSB CHI85LA338Accident · No injuriesLimited investigationFinal reportBell 47G-5 · Pickett, WIThe fld where this accident occurred had been sprayed one week prior to the accident by a fixed-wing acft at an alt of 20 ft. no wires were noted to be a hazard at that time. On the day of the accident the plt of the helicopter was talking to a spotter on the…NTSB CHI85LA341Accident · No injuriesLimited investigationFinal reportCessna 172H · Whitewater, WIAccording to the plt he planned to use max performance takeoff procedures out of the owner's manual for the takeoff. After brake release the acft began to roll down the sod rwy. Acceleration continued, but according to the plt, his airspeed increase seemed…NTSB 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.NTSB CHI85FA325Accident · No injuriesField investigationFinal reportPiper PA-28-181 · Eureka, WIPrior to takeoff the pilot calculated that with 48 gallons of fuel he could make the four hour flight to oshkosh with one hour of fuel to spare. Upon arriving at a point 25 mi sw of oshkosh he received a request to descend 1200 ft, a request to climb 1200 ft…NTSB CHI85LA324Accident · No injuriesLimited investigationFinal reportBoeing E75 · Delavan, WIThe acft nosed over during a forced lndg after the eng quit. The plt said he ran out of fuel.NTSB CHI85LA320Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Franklin, WIThe pilot used a shortfield takeoff and the acft would not fly. The plt aborted the takeoff and landed on the end of therwy, overrunning the rwy and striking a ditch. The plt reported engine RPM normal and the acft was under max gross takeoff weight.NTSB CHI85LA328Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Lakewood, WIThe student plt and his pax had landed on an airstrip on a golf course. On takeoff the student plt lifted off early and stalled back on the turf. He then lost directional control, veered off the airstrip and struck a golfer in the back with the outer section…NTSB CHI85LA327Accident · No injuriesLimited investigationFinal reportHoward DGA-15P · Fond Du Lac, WIThe plt had accurued aprx 12 hrs of flying time on the day of the accident. During the final landing the acft touched down at the rwy mid-point and bounced. The acft then struck a rwy light and veered off the rwy paved surface into soft sod. The plt attempted…NTSB CHI85FA315Accident · Serious injuriesField investigationFinal reportChristopher D. Brown Gyroplane · Oshkosh, WIThe pilot was practicing low altitude maneuvers, adjacent to the runway. When he turned to make a downwind, at the southeast end of the runway, he impacted with the terrain. Witnesses stated that they observed the gyroplane making steep turns at a low…NTSB CHI85FEP02Accident · Serious injuriesFinal reportNeyman-Pietenpol GN-2 · Brodhead, WIThe acft was observed making steep turns at about 500 ft AGL just prior to the acdnt. One witness stated that the airspeed was decaying during these turns & the acft stalled while in a steep bank. Reportedly, the acft began spinning, then the plt stopped the…NTSB CHI85LA307Accident · No injuriesLimited investigationFinal reportBellanca 17-30 · Sheboygan, WIThe acft collided with a ditch during a forced landing following a loss of power in cruise flt. The plt reported he switched the fuel selector from the left to the right tank, & after aprx 3 minutes, a total loss of power was experienced. He stated that…NTSB CHI85LA304Accident · Serious injuriesLimited investigationFinal reportCessna 210H · Burlington, WIPilot estimated 15 gals of fuel at preflt. After 15 min grd delay due to traffic pilot tookoff and climbed to 2,500'MSL. After cruising 22 nmi the engine quit due to fuel exhaustion. During attempt to ld in corn field pilot attempted to stretch his glide and…NTSB CHI85LA298Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Pepin, WIThe aircraft traveled three quarters down a 2300 foot sod runway and the pilot attempted to takeoff with 55 KIAS. The aircraft mushed into trees off the end of the runway when the pilot couldn't obtain flying speed. The pilot reported full engine RPM was…NTSB CHI85LA290Accident · No injuriesLimited investigationFinal reportHughes 269A · Oconomowoc, WIThe helicpoter contacted a corn crop and came to rest inverted during an aerial application flt. The plt stated, 3 passes were made over the fld being sprayed and after a turn to begin the 4th pass, the helicopter settled with pwr contacting the crop.NTSB CHI85LA286Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Appleton, WIAs the plt applied brakes during a full stop landing, the right brake failed. The plt then maneuvered the acft off the paved landing surface in an attempt to get it to roll to a stop. The right landing gear strut collapsed. The acft then slid into a fence and…NTSB CHI85LA297Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Iola, WIUpon takeoff at approximately 100 ft AGL the pilot experienced a partial power loss which necessitated a forced landing in a soft, wet potato field. The pilot had time to switch fuel tanks and magnetos prior to touchdown, but the power loss remained constant.…NTSB CHI85LA287Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Stoughton, WIUpon landing following a normal 70 knot final approach the aircraft initially touched down one-third of the way down the 2500 ft grass runway. A bounce carried the aircraft to a point halfway down the runway where the aircraft landed in a full stall. The…NTSB CHI85LA279Accident · No injuriesLimited investigationFinal reportCessna 150F · Fond Du Lac, WIThe acft nosed over in soft terrain 1/4 mile short of the rwy at fon du lac arpt following a total loss of pwr. The flt departed henderson, KY, at 1510 CDT with 26 gallons of fuel and the pwr loss occurred at 1925 CDT, 4 hrs and 15 minsafter departure. Post…NTSB CHI85LA267Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-200 · New Richmond, WIThe acft veered to the rt & hit a rwy marker during the attempted go-around. The wind was from 210 degrees at 19 KTS gusting to 27 KTS. The plt said that if the marker had been 'break-away' plastic the damage would have been negliable.NTSB CHI85LA266Accident · No injuriesLimited investigationFinal reportCessna 152 · Elkhorn, WIThe acft collided with the terrain during a low alt maneuver. The plt said that he allowed the airspeed to dissipate during a turn and before he could recover the acft hit the ground.NTSB CHI85LA264Accident · No injuriesLimited investigationFinal reportCessna 172H · Coleman, WIThe pilot departed on a short x-country flt. Stated fuel aboard was 8 gls. Pilot diverted from drct flt and ran out of fuel after one hour airborne. Ld in farm field. Struck a post with resultant sub damage to airframe.NTSB 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.…NTSB CHI85LA252Accident · No injuriesLimited investigationFinal reportBeech BE-19A · Appleton, WIThe left main landing gear collapsed following a loss of directional control during landing. The landing was made on rwy 21 with winds from 240 degs at 18 KTS gusting to 30 KTS. The plt reported the acft drifted left during the landing and side loads on the…NTSB CHI85LA241Accident · No injuriesLimited investigationFinal reportCessna 172M · Mosinee, WIThe plt stated that he failed to flare properly following a 'fast and flat' final approach. The acft landed on its nosewheel resulting in substantial damage to the acft.NTSB CHI85LA235Accident · No injuriesLimited investigationFinal reportBeech V35B · Boscobel, WIThe engine failed on final approach. The aircraft did not clear a wooded area resulting in an uncontrolled descent. The camshaft had failed at the number 1 journal oil groove.NTSB CHI85LA230Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Blair, WIThe plt attempted to land the acft in a farm field but was unable to stop before reaching the end of the field. The acft ran through a fence & a ditch before coming to rest. The plt stated that he overshot the rwy, landed long, & was unable to stop the acft…NTSB CHI85LA228Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Osceola, WIThe solo student plt attempted to land the acft with an aprx 90 deg x-wind of 24 KTS gusting to 32 KTS. Feeling unsure of the conditions on his first apch, he decided to make a go around. This he successfully accomplished. On his second attempt, he was able…NTSB CHI85LA217Accident · No injuriesLimited investigationFinal reportCessna 150M · Merrill, WIThe plt was performing touch-and-go's when on the landing roll she allowed the acft to drift off the rwy into soft terrain. The acft nosed over. The plt stated that she was looking inside to raise the flaps.NTSB CHI85LA215Accident · No injuriesLimited investigationFinal reportCessna 152 · Marshfield, WIThe pilot made a precautionary landing in a field. After checking the acft fuel tanks he attempted to takeoff on a gravel road. During the ground run the acft collided with trees & skidded into a field.NTSB CHI85LA208Accident · No injuriesLimited investigationFinal reportCessna 150L · Necedah, WIAfter a flt with an instructor, the student took off on a solo flt. During a touch & go the student stated, '... I came in high & fast. I landed long and the aircraft bounced twice. I then panicked and pushed the control forward causing the nose to dive into…NTSB CHI85FEP01Accident · Minor injuriesFinal reportBeech 35-C33 · Middleton, WIAt lift-off during the departure, the plt noticed oil spray on the windshield. He initiated an aborted takeoff by retarding the throttle, then realized there was insufficient rwy remaining, so he applied full throttle again. However, the eng did not respond…NTSB CHI85LA216Accident · No injuriesLimited investigationFinal reportPiper PA-32T-300 · Milwaukee, WIThe pilot stated that the approach was normal and flown at 90 KIAS. He flared high and the acft landed hard on the right main landing gear, due to the excessive rate of decent. The damage was limited to the right wing spar and ribs.NTSB CHI85LA194Accident · No injuriesLimited investigationFinal reportDassault-Breguet Falcon 50 · Lake Geneva, WIHigh sink rate developed on short final. Acft touched down 13 ft prior to runway before sink rate could be arrested. Landing gear collapsed after contacting edge of rwy which is 7 inches higher than surrounding terrain. Tail section of acft caught fire just…NTSB CHI85LA192Accident · No injuriesLimited investigationFinal reportCessna A152 · West Bend, WIPlt departed fondulac, WI, with full fuel (24.5 gallons usable) and flew aprx 25 miles south where 2 1/2 hrs were spent taking aerial photographs. Flt then proceeded aprx 60 miles to manitowoc, WI where a landing was made. Departure was then made with aprx 9…NTSB CHI85FA185Accident · No injuriesField investigationFinal reportBeech B35 · Sussex, WIA student plt was on his 1st solo x-country flt in a Cessna 152, N6464L. After taking off at the brookfield arpt (elev 850 ft), he had climbed to 2000 ft MSL & was heading 350 deg when he saw a Beech B35 (bonanza), N5182C, converging from his right. The…NTSB CHI85LA183Accident · No injuriesLimited investigationFinal reportCessna 152 · Broadhead, WIThe plt stated that during arrival, he entered a traffic pattern for what he thought, according to his directional gyro, was rwy 9. Rwy 9 was 2500 ft long; however, he landed on rwy 3, which was 1520 ft long. During the landing, the plt was unable to stop on…NTSB 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…NTSB CHI85FA170Accident · No injuriesField investigationFinal reportBeech E18S · Janesville, WIOn April 20,1985 at approx. 2100HRS local time a Beechcraft model E185 N68Y owned and operated by blackhawk airways inc. was conducting a normal runup in preparation for a flight from Janesville, WI. (Jvl) to chicago IL. (Ord). At the completion of the of the…NTSB CHI85LA161Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Stevens Point, WIDuring a low level flt over a river, the plt initiated a turn to reverse direction at 300 ft AGL. The acft contacted the water during the descending turn and nosed over.NTSB CHI85LA131Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Madison, WIThe acft collided with a snowbank during takeoff after the plt lost directional control. The takeoff was attempted on rwy 22. The wind was from 180 degrees at 13 KTS.NTSB CHI85LA126Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Markesan, WIAlthough the pilot believed he had enough visibility to land at this unlighted airfield at dusk, he, in fact, aligned the aircraft up approximately 20 feet to the right of the runway. He landed in a shallow snowbank that paralleled the entire length of the…NTSB CHI85LA123Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Ephriam, WIThe aircraft began drifting to the right during the landing flare. As the aircraft touched down the right wheel entered an area of slush. The aircraft then slid off the runway to the right into a snowbank, damaging the landing gear and left wing tip. The…NTSB CHI85LA117Accident · No injuriesLimited investigationFinal reportCessna 177RG · Janesville, WIThe acft collided with a snowbank during lndg. An investigation by a qualified A&P mech found the lock-o-seal in the master cylinder had improper clearance. Lack of proper clearence restricted return flow of brake fluid to the reservoir. This led to locking…NTSB CHI85LA106Accident · No injuriesLimited investigationFinal reportCessna 150D · Siren, WIThe acft collided with a snow bank during landing. This was a solo student flt for the plt. The wind was 20 degrees off the rwy heading and varying bet 7-12 KTS in velocity. The student reported that either more brake & aileron or a running takeoff would have…NTSB CHI85LA076Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Byron Township, WIThe low time 55 hr pilot was wx briefed on unfavorable flt conditions en route to destination. He departed no flt plan. As he approached destination, 8 mi south, the ceiling had lowered to 200 ft, visibility one mi; icing on windshield. While following…NTSB CHI85LA081Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Wisconsin Rapid, WIThe plt stated that during takeoff into winds form 290 deg at 10 KTS gusting to 15 KTS, the acft began to slide to the left on the icy rwy. When the acft hit a snow bank along the rwy, the nose gear collapsed.NTSB CHI85LA056Accident · Serious injuriesLimited investigationFinal reportPiper PA-32RT-300T · Chambers Island, WIThe plt reported that during takeoff upon reaching an alt of 8-10 ft AGL a down draft was encountered and the acft contacted the rwy on the rt landing gear which was in the transient position. He reported he was able to remain airborne but the rate of climb…NTSB CHI85LA049Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Wild Rose, WIThe plt stated that he was flying at 500 ft AGL over an open marsh that is surrounded by higher terrain covered with pine trees, looking for his father who was hunting in the area. The plt continued to state that he became preoccupied with trying to identify…NTSB CHI85LA090Accident · No injuriesLimited investigationFinal reportBeech 58 · Hayward, WIThe acft sustained subst damage after uncontrolled contact with the rwy during landing. Investigation revealed that the landing was inadvertently attempted at a time when the winds shifted to a direct x-wind with gusts to 35 KTS.