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 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…NTSB CHI85LA023Accident · No injuriesLimited investigationFinal reportCessna 172K · Berlin, WIThe plt stated that he attempted to takeoff from a grass strip that is priented north and south. He described the grass as being 'too long' and the wind was from the west. The plt over rotated the acft to raise the nose wheel clear of the grass and was unable…NTSB CHI85LA022Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Dodgeville, WIThe plt attempted a landing on rwy 30 which is 85 ft higher in elev at the approach end of the rwy than the departure end. This was the plt's first flt to this arpt. The acft touched down further down the rwy than intended so the plt applied pwr to abort the…NTSB 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…NTSB 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…NTSB CHI84LA389Accident · Minor injuriesLimited investigationFinal reportDenil Sonera II · De Pere, WIPlt stated that on initial climb, he became distracted by an insect in the cockpit and the acft drifted off the right side of the rwy, colliding with telephone lines near the end of the rwy.NTSB CHI84LA386Accident · No injuriesLimited investigationFinal reportPiper PA25 · Sheboygan, WIPlt initiated takeoff in strong gusty x-wind. Approaching tree line, acft began to sink. Plt turned to avoid trees and stalled acft. Load jettison was too late to aid in stall recovery and acft mushed into ground.NTSB CHI84LA381Accident · No injuriesLimited investigationFinal reportUngerecht Q-2 · Appleton, WIAfter takeoff on the third flight of the new homebuilt aircraft the pilot smelled 'something hot' and noted a high cylinder head temp. During the subsequent precautionary landing the plt flared the acft 3-4 ft above the rwy resulting in a hard landing and…NTSB 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…NTSB CHI84IA373Incident · No injuriesIncident investigationFinal reportBoeing 737-291 · Madison, WIShortly after lift-off & while climbing thru about 150 ft AGL, there was a loud noise from the left eng when it failed. The aircrew secured the left eng, returned to the arpt & made a single eng landing without further incident. An investigation revealed that…NTSB 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…NTSB CHI84LA360Accident · No injuriesLimited investigationFinal reportBeech B-24-R · Independence, WIThe acft collided with trees near the departure end of the field during an attempted go-around. A passenger reported that the go-around was initiated at about 100 ft AGL, 1/2 way down the fld. The plt said the fld was in a valley, it wasa hot (reported temp…NTSB CHI84LA358Accident · Serious injuriesLimited investigationFinal reportPiper PA-12 · Cottage Grove, WIWhile over-flying a local arpt at aprx 200 ft AGL the eng lost power. A forced landing was made in an adjacent alfalfa field. The acft landed hard in a nose low attitude and came to rest about 90 ft from initial ground contact.NTSB CHI84LA356Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Palmyra, WIPlt entered landing pattern after maintenance ferry flt, checked lighted wind indicator & evaluated wind as calm. Plt executed tight, close-in base due to electric billboard drag factor & noted strong wind blowing acft away from runway. Acft began to lose…NTSB CHI84LA349Accident · No injuriesLimited investigationFinal reportBellanca 17-31ATC · Antigo, WIThe acft was forced to land after the engine failed. The plt heard an explosion and saw part of the cowling come off before the engine quit. His passenger said that oil covered the windshield. Post accident inspection showed a failed cylinder. The cylinder…NTSB CHI84LA339Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Washington Is., WIThe acft stalled and crashed after the engine lost power at about 50 ft AGL during takeoff. The acft caught fire after touchdown. The fire consumed the cockpit and cabin. An examination of wreckage showed the fuel selector on the left tank. The left tank had…NTSB CHI84LA332Accident · No injuriesLimited investigationFinal reportArnold Forest Quickie 2 · Grantsburg, WIThe acft made one forced landing after engine trouble. The plt cleaned the fuel filters and took off for a test flt. The engine failed during takeoff. Post accident inspection of the engine showed it would run but the oil pressure was very low.NTSB 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…NTSB CHI84LA329Accident · Minor injuriesLimited investigationFinal reportGulfstream AA-5A · Wausau, WIDrg a x-country flt at 4500 ft, eng began sputtering. Plt adusted the mix; then applied carb heat, but rprtdly for only a short time. Eng contd operg, but at reduced pwr. Acft lost alt & dscndd into clds, but the plt was able to lvl at APRX500' AGL. He…NTSB 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…NTSB CHI84LA328Accident · No injuriesLimited investigationFinal reportViking Dragon FLY · Eau Claire, WIWitnesses observed acft touchdown left main gear first and bounce twice before remaining on the rwy. The left conard collapsed during the landing. The landing gear is attached at canard tip on this make/model.NTSB CHI84LA324Accident · Minor injuriesLimited investigationFinal reportBeech BE-23 · Dodgeville, WIThe student solo plt flared the acft over the rwy, the acft bounced and hit the nose gear which collapsed. The acft became airborne again and went off the rwy about 100 ft to the right side. The arpt directory cautions of a steep downgrade to the rwy. The…NTSB CHI84FA321Accident · No injuriesField investigationFinal reportS.I. Briggs Varieze · Pickett, WIThe acft contacted a 25 ft AGL 2 strand 14000 v power line. After contacting the lines, the acft touched down in a corn field and traveled for aprx 210 ft. the acft then crossed a 2 lane road, struck a ditch separating the canard/gear and traveled an…NTSB CHI84LA316Accident · No injuriesLimited investigationFinal reportCessna 150H · Menomonie, WIThe plt was disoriented during a x-country and circled the wrong area looking for an arpt until low fuel demanded a landing. During the approach the engine quit and the acft nosed over in a bean field during landing.NTSB CHI84FA319Accident · No injuriesField investigationFinal reportCessna 182N · Oshkosh, WIThe plt was on a flt to an eaa meet at Oshkosh, WI. During arrival, there were numerous acft in the traffic pattern for landing. While the acft was on final approach, just before landing, the tower controller instruncted the plt to 'land long.' The plt stated…NTSB CHI84FU008Accident · 1 fatalFinal reportMattison MAC Ultralight · Three Lakes, WIThe recently purchased ultralight was taxied for about 40 minutes prior to the new owner trying his first flt. He had been advised by the former owner to make short hops at low altitude during a familiarization period. The former owner wanted to be present…NTSB CHI84FA303Accident · 3 fatalField investigationFinal reportCessna 421 · Birchwood, WIDuring flt, the plt transmitted to ARTCC 'we've got a problem, we're losing altitude.' The controller provided a vector to the nearest arpt, but shortly after that, the plt stated that he would not be able to reach the arpt. The plt did not inform ARTCC of…NTSB CHI84LA288Accident · No injuriesLimited investigationFinal reportRotorway Executive · Cambridge, WIThe fixed wing plt who was not qualified to fly rotorcraft tried to hover his homebuilt acft. After failing the 1st timehe tried again and this time the acft rolled over and burned. The plt said the roll over occurred so fast he did not have time to act.NTSB CHI84LA285Accident · No injuriesLimited investigationFinal reportCessna 170B · Edgerton, WIThe plt stated he made a faster than normal approach & upon touchdown, the acft bounced back into the air. He added a little power to smooth out the landing, but when the acft touched down, the second time, it veered off the rwy, encountered a muddy corn…NTSB CHI84LA284Accident · No injuriesLimited investigationFinal reportCessna 172M · Lake Geneva, WIAccording to the plt, he was on a short final apch to land when the acft encountered sudden turbulence. At that time, the passenger in the right front seat lurched against the control wheel, causing the nose to pitch down & the acft to bank left.…NTSB CHI84LU006Accident · Serious injuriesFinal reportPterodactyl Fledgling · Hartford, WIThe ultralight was in the takeoff climb at about 75 ft AGL when the engine failed. During the emergency forced landing, the acft landed hard on upsloping terrain & the nose gear failed in overload. Investigation revealed that an ignition wire was worn and had…NTSB CHI84LA270Accident · No injuriesLimited investigationFinal reportHughes 500C/369HS · Arena, WIDuring an agricultural spraying operation the helicopter eng lost pwr. The plt attempted an autorotation. The acft rolled over on landing. The plt stated that he observed a loss of eng & rotor RPM, necessatating the autorotation. Inspection of the eng…NTSB CHI84LA267Accident · No injuriesLimited investigationFinal reportCessna 152 · Park Falls, WIThe plt reported that during his preflt run-up, everything seemed normal. Using short field takeoff procedures, he rotated at 40 KTS & reached an alt of about 10 ft AGL. However, he stated that the acft did not want to accelerate to the best angle of climb…NTSB CHI84LA263Accident · Minor injuriesLimited investigationFinal reportHiller UH 12 D · Deerfield, WIPlt was aware of pwr lines which crossed the field over which he was performing a calibration test. Plt stated that because of sun glare visual contact with the wires was lost. The acft contacted the wires.NTSB CHI84LA253Accident · No injuriesLimited investigationFinal reportBeech B-19 · Oshkosh, WIThe student pilot stated that he rounded out a little high, while landing on rwy 09, stalled & contacted the runway in a crabbed position. A hard landing resulted which substantially damaged the aircraft.NTSB CHI84LA238Accident · No injuriesLimited investigationFinal reportPiper PA-36-300 · Leroy, WIThe acft collided with trees while turning during an aerial application mission. The plt said that the acft started losing altitude in the turn and despite application of full power it continued to settle until trees were hit. The plt reported that during…NTSB CHI84LU003Accident · Serious injuriesFinal reportEipper Quicksilver MXL · Orfordville, WIThe operator, flying off a local street, had just off-loaded a passenger when another individual asked for a ride. The operator agreed and was on takeoff climb when the passenger interferred with the controls resulting in an uncontrolled descent and ground…NTSB CHI84FA226Accident · 1 fatalField investigationFinal reportHiller UH-12E · Merrimac, WIThe acft crashed and burned after an in-flt explosion at about 75 ft AGL as the acft approached to land. The acft had experienced electrical problems of overheating generators and irregular voltage outputs on 2 previous occasions. The pltwas told after some…NTSB CHI84LA213Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Port Washington, WIThe plt stated that after takeoff from a sod field covered with tall grass, the acft drifted to the right of the rwy. While bringing the acft back to the center of the rwy, the acft stalled. The nose gear hit the ground & collapsed, the left wing hit a fence…NTSB CHI84LA210Accident · Minor injuriesLimited investigationFinal reportWagner Cuby WAG-A-BOND · Lyons, WIThe plt noticed '...a little power loss...' After takeoff at about 550 AGL. He turned downwind & flew a normal traffic pattern, but at a lower altitude. The acft stalled during the base turn. The plt stated that the loss of power was due to the mixture…NTSB CHI84LA206Accident · Serious injuriesLimited investigationFinal reportErcoupe 415C · Sturtevant, WIAccording to the plt, he was making a hi speed taxi check when the acft lifted off to about 5 ft AGL. After lift-off, the acft began to go to the left. When the plt applied right rudder, the plane veered further left & crashed in an onion field. An exam of…NTSB CHI84LA204Accident · Minor injuriesLimited investigationFinal reportCessna 210L · Middleton, WIPwr loss experienced during normal cruise flt. Plt received vector to nearest airport. There was no evidence of attempt to regain power. On approach to airport, plt extended lndg gear. Resultant drag factor increased glide angle to extent plt felt clearance…NTSB CHI84FA180Accident · 1 fatalField investigationFinal reportColonial C-2 · Stone Lake, WIThe plt had flown to little sissabagama lake where he owned a cabin. A witness had observed the last 3 mins of flt but not the actual impact with the water. The acft was later found inverted in 15 ft of water 300 ft from a shore. Plt was found 150 ft from the…NTSB CHI84LA174Accident · Serious injuriesLimited investigationFinal reportGable Sonerai II · Berlin, WIThis homebuilt acft stalled during a forced landing after an engine failure. The plt reported that the engine temperature went to 650 degrees which was an overheat condition. The plt stated that he tried to return to the arpt but stalled 20 ft short of rwy 27…NTSB CHI84LA176Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Ft Atkinson, WIThe acft stalled during a short field takeoff after a landing during which full up trim was used. The student plt did not use a checklist or reset the trim prior to takeoff.NTSB CHI84LA166Accident · Minor injuriesLimited investigationFinal reportGrumman AA5A · Cudahy, WIThe acft struck a storage shed while attempting to reach a golf course during an emergency landing in gusty wind conditions. There were no visible signs or odor of fuel at the accident site. When the acft was inspected the carburetor and fuel sumps were…NTSB CHI84LA164Accident · Minor injuriesLimited investigationFinal reportCessna 177A · Bloomer, WIPlt failed to visually check fuel tanks after they were refueled. On the second leg of a x-country fuel exhaustion occurred. The acft nosed over during the forced landing on soft terrain.NTSB CHI84LA162Accident · Minor injuriesLimited investigationFinal reportTaylorcraft DCO-65 · Palmyra, WIThe pilot lost control of the acft on the landing flare & collided with a tree. The acft was blown to the left of the rwy & before he could execute a go-around the propeller struck some high brush alongside the rwy. The plt pulled power off, landed in rough…NTSB CHI84LA161Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Genoa City, WIAfter takeoff, the plt had made 2 turns & had attained an alt of about 200 ft AGL when the eng sputtered & lost power. He was unable to turn & land on the rwy, but continued straight ahead to avoid houses & trees. During an emergency landing, the acft…NTSB CHI84IA155Incident · No injuriesIncident investigationFinal reportSwearingen SA226TC · Milwaukee, WIA gear up landing was performed after the crew was unable to extend the rgt main gear thru normal & emerg procedures. An exam of the acft disclosed the rgt main gear door aft hinge bolt was slightly bent & difficult to rotate in its bushing. The bushing &…