NTSB investigations, WI

105 cases where the first occurrence was “In flight collision with object”.

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.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 220)
  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 CHI93DEP02Accident · 1 fatalFinal reportStoeckler RV-4 · Lake Delton, WIthe pilot-in-command's failure to maintain proper altitude. A factor was trees.Jul 24, 1993 · N720DS · DestroyedNTSB CHI93LA269Accident · 1 fatalLimited investigationFinal reportBeech A23 · Boyceville, WIthe failure of the pilot to attain the proper touchdown point, and his failure to perform a go-around.Jul 21, 1993 · N3578R · DestroyedNTSB CHI93LA237Accident · Serious injuriesLimited investigationFinal reportDaniel Squire HI-MAX · Omro, WIthe pilot's inadequate preflight planning and preparation. A factor in the accident is the downdraft.Jun 27, 1993 · N200D · Substantial damageNTSB CHI93LA179Accident · Minor injuriesLimited investigationFinal reportBell 47 · Berlin, WIThe pilot-in-command's failure to see the obstruction.May 21, 1993 · N8458E · DestroyedNTSB CHI92DEP04Accident · Minor injuriesFinal reportGrumman 164A · Elkhorn, WIThe pilot-in-command's inadequate compensation for wind conditions.Aug 31, 1992 · N48635 · DestroyedNTSB CHI92FA195Accident · 1 fatalField investigationFinal reportMooney M20K · Oconto Falls, WIThe pilot's failure to maintain adequate clearance from obstructions during a low pass.Jul 3, 1992 · N231FW · DestroyedNTSB CHI92LA173Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Ladysmith, WIFailure of the pilot to attain a proper touchdown point and the attempted abort of the precautionary landing attempt.Jun 13, 1992 · N52142 · DestroyedNTSB CHI92LA134Accident · Minor injuriesLimited investigationFinal reportBellanca 7ECA · La Crosse, WIVisual lookout inadequate and diverted attention by the pilot. A factor related to the accident was transmission wires crossing flight path.Apr 27, 1992 · N53988 · Substantial damageNTSB CHI91DEP13Accident · Serious injuriesFinal reportMerritt Robertson B1-RD · Menasha, WIInadequate visual look out whih resulted in a wire strike and uncontrolled descent.Sep 7, 1991 · UNREG · DestroyedNTSB CHI91LA265Accident · Minor injuriesLimited investigationFinal reportBeech 77 · Mosinee, WIThe pilot's poor preflight planning/preparation, and the selection of unsuitable terrain for takeoff. A related factor was the grassy runway (farm field).Aug 14, 1991 · N38189 · Substantial damageNTSB CHI91LA186Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Pulaski, WIThe pilot's failure to select a proper touchdown point. A factor in the accident was inadequate runway maintenance by airport personnel.Jun 5, 1991 · N111CP · Substantial damageNTSB CHI91DEP01Accident · No injuriesFinal reportDean Bartel Avid Flyer Stol · New London, WIThe pilot's failure to obtain a proper touchdown point and his delay in initiating a go-around.Nov 4, 1990 · N287AF · Substantial damageNTSB CHI91LA020Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180D · Crivitz, WIImproper planning/decision by the pilot, and his failure to abort the takeoff (while there was sufficient runway remaining).Oct 28, 1990 · N264W · DestroyedNTSB CHI90DEP09Accident · Serious injuriesFinal reportCessna 182 · Columbus, WIThe skydiver's panic and failure to depart the aircraft as instructed. Contributing was the skydiver's lack of total experience in this type of operation.Aug 18, 1990 · N20824 · Substantial damageNTSB CHI90FA066Accident · Serious injuriesField investigationFinal reportCessna 402A · Mosinee, WIThe pilot disregarding the published decision height and not performing a missed approach.Jan 17, 1990 · N4532Q · DestroyedNTSB CHI90LA010Accident · No injuriesLimited investigationFinal reportCessna 172M · Cedarburg, WIDelay of the flight instructor (CFI) in making a go-around and his failure to attain sufficient airspeed to climb after taking off again. The transmission wire (power line) and high vegetation were contributing factors.Oct 14, 1989 · N1325U · Substantial damageNTSB CHI89FA154Accident · Minor injuriesField investigationFinal reportRyan PT-22 · Oshkosh, WIThe experimental aircraft association's (eaa's) inadequate procedure for providing control and separation of aircraft, its inadequate surveillance of the operation, and inadequate coordination by ground personnel. Related factors were: the ground personnel's…Jul 31, 1989 · N54403 · 2 aircraft · Substantial damageNTSB CHI89LA137Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Chippewa Falls, WIThe pilot's failure to maintain directional control while attempting to land in crosswind conditions. During the ensuing aborted landing, the pilot failed to ensure adequate obstacle clearance and the aircraft's left wing struck the wind sock pole.Jul 17, 1989 · N8005W · Substantial damageNTSB CHI89LA053Accident · No injuriesLimited investigationFinal reportAeronca 7KCAB · Pine Creek, WIThe pilot's selection of unsuitable terrain which resulted in the failure to achieve a proper climb rate which resulted in the collision with trees. Contributing to the accident was the uphill, snow covered terrain.Mar 5, 1989 · N9044L · Substantial damageNTSB CHI89LA016Accident · No injuriesLimited investigationFinal reportBeech F35 · Milwaukee, WIWhile executing a VOR approach and circling to land, the aircraft collided with trees and a fence, then impacted on a roadway short of the runway. The pilot had obtained a full weather briefing prior to his departure. The weather briefing included SIGMET golf…Oct 23, 1988 · N104TG · Substantial damageNTSB CHI88LA238Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Kenosha, WIWhile on a VFR approach to the airport, at night, the pilot misidentified the street lights in a mobile home park as the runway lights and descended into wires. Afterward the pilot was able to continue to the intended runway and made a successful landing.…Sep 18, 1988 · N6252J · Substantial damageNTSB CHI88LA213Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140E · Glidden, WIWhile attempting to takeoff from a 2,175' grass strip, with the aircraft loaded near maximum gross weight, the pilot approached the end of the runway without having attained liftoff airspeed. The pilot lifted the aircraft off the ground prematurely and was…Aug 18, 1988 · N4476T · Substantial damageNTSB CHI88DEP11Accident · No injuriesFinal reportGrumman-Schweizer G-164A · Plover, WIThe aircraft collided with a farm machinery shed during an aerial application maneuver. The pilot stated that there was no powerplant or control malfunction. The temperature at the accident site was 87 degrees (f), with a calculated density altitude of 2944…Aug 17, 1988 · N8495 · Substantial damageNTSB 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 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…Jun 22, 1987 · N57791 · DestroyedNTSB 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.May 5, 1987 · N49752 · Substantial damageNTSB 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…Mar 8, 1987 · N3960N · Substantial damageNTSB 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 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.Oct 24, 1986 · N8360N · Substantial damageNTSB 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…Aug 24, 1986 · N2352N · Substantial damageNTSB 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 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.Jun 11, 1986 · N98739 · Substantial damageNTSB 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…Jun 7, 1986 · N1268Z · Substantial damageNTSB 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…Mar 1, 1986 · N80167 · DestroyedNTSB 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…Aug 7, 1985 · N1476W · Substantial damageNTSB 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 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…Nov 18, 1984 · N2428L · 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 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…Oct 20, 1984 · N734YR · DestroyedNTSB 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.Sep 10, 1984 · N2265N · Substantial damageNTSB 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 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…Aug 25, 1984 · N2217L · Substantial damageNTSB 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…Jul 29, 1984 · N15EZ · DestroyedNTSB 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.Jun 26, 1984 · N62362 · Substantial damageNTSB 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…Jun 15, 1984 · N59662 · DestroyedNTSB CHI83FA410Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Forestville, WIThe acft was observed making low passes, 150-200 ft AGL, over a wooded area & then strike a radio antenna at the 207-FT level. The acft rolled inverted & impacted the ground. Members of the plt's aero club stated that the plt & pax were probably spotting for…Sep 17, 1983 · N15651 · DestroyedNTSB CHI83LU007Accident · Serious injuriesFinal reportBerwin Waspair Tomcat Tour · Oconomowoc, WIThe ultralight collided with a tree during a go-around. The acft encountered an updraft during the landing attempt and the pilot decided to go-around. The acft was not able to gain alt fast enough to clear a tree at the end of the field. The pilot was in…Aug 10, 1983 · UNREG · Substantial damageNTSB CHI83LA323Accident · No injuriesLimited investigationFinal reportCessna 150 · Wilmot, WIThe acft collided with a tree during a go-around. The pilot added full flaps as the rwy was approached. During the flare the acft ballooned and bounced. A go-around was started but the flaps were not raised. The acft did notachieve enough climb to clear the…Jul 19, 1983 · N714PJ · Substantial damageNTSB CHI83FU004Accident · Serious injuriesFinal reportPara-Sail Glider · Battle Creek, WIThe ultralight vehicle was observed flying low over a golf course. As it approached a tall tree, witnesses heard the addition of power. However, a wing hit the tree & the ultralight spiraled down & impacted the ground. The plt did not possess an FAA plt…Jun 12, 1983 · UNREG · Substantial damageNTSB CHI83FA166Accident · 1 fatalField investigationFinal reportPiper PA24-260 · Middleton, WIDuring arrival at night, the plt was cleared for a vor-b apch to the morey arpt, an uncontrolled facility at an elevation of 928 ft MSL. Rwy 13/31 at the arpt had low intensity rwy lights which could be activated by keying the radio on 123.5 mhz. The circling…Apr 15, 1983 · N9215P · Destroyed