NTSB investigations, WI

228 cases where the phase of flight was Maneuvering.

Cases, newest first

Query with SQL
duckdb -csv -c "WITH phase_names(main, name) AS (VALUES (100, 'Prior to flight'), (150, 'Standing'), (200, 'Pushback/towing'), (250, 'Taxi'), (300, 'Takeoff'), (350, 'Initial climb'), (400, 'Enroute'), (450, 'Maneuvering'), (500, 'Approach'), (550, 'Landing'), (600, 'Emergency descent'), (650, 'Uncontrolled descent'), (700, 'Post-impact'), (750, 'After landing'), (800, 'Other'), (990, 'Unknown')),
    crosswalk(code, main, name) AS (VALUES (500, 150, 'Standing'), (501, 150, 'Standing - pre-flight'), (502, 150, 'Standing - starting engine(s)'), (503, 150, 'Standing - engine(s) operating'), (504, 150, 'Standing - engine(s) not operating'), (505, 150, 'Standing - idling rotors'), (510, 250, 'Taxi'), (511, 200, 'Taxi - pushback/tow'), (512, 250, 'Taxi - to takeoff'), (513, 250, 'Taxi - from landing'), (514, 250, 'Taxi - aerial'), (520, 300, 'Takeoff'), (521, 300, 'Takeoff - roll/run'), (522, 350, 'Takeoff - initial climb'), (523, 300, 'Takeoff - aborted'), (530, 400, 'Climb'), (531, 400, 'Climb - to cruise'), (540, 400, 'Cruise'), (541, 400, 'Cruise - normal'), (542, 400, 'Maneuvering - holding (IFR)'), (550, 400, 'Descent'), (551, 400, 'Descent - normal'), (552, 600, 'Descent - emergency'), (553, 650, 'Descent - uncontrolled'), (560, 500, 'Approach'), (561, 500, 'Approach - VFR pattern - downwind'), (562, 500, 'Approach - VFR pattern - base turn'), (563, 500, 'Approach - VFR pattern - base leg/base to final'), (564, 500, 'Approach - VFR pattern - final approach'), (565, 500, 'Go-around (VFR)'), (566, 500, 'Approach - IAF to FAF/outer marker (IFR)'), (567, 500, 'Approach - FAF/outer marker to threshold (IFR)'), (568, 500, 'Circling (IFR)'), (569, 500, 'Missed approach (IFR)'), (570, 550, 'Landing'), (571, 550, 'Landing - flare/touchdown'), (572, 550, 'Landing - roll'), (573, 550, 'Landing - aborted'), (574, 550, 'Emergency landing'), (575, 550, 'Emergency landing after takeoff'), (576, 600, 'Emergency descent/landing'), (580, 450, 'Maneuvering'), (581, 450, 'Maneuvering - aerial application'), (582, 450, 'Maneuvering - turn to reverse direction'), (583, 450, 'Maneuvering - turn to landing area (emergency)'), (590, 450, 'Hover'), (591, 450, 'Hover - in ground effect'), (592, 450, 'Hover - out of ground effect'), (600, 800, 'Other'), (610, 990, 'Unknown')),
    current_codes AS (
      SELECT e.case_mkey, TRY_CAST(e.\"tier1Number\" AS INTEGER) AS code,
        row_number() OVER (PARTITION BY e.case_mkey ORDER BY coalesce(e.\"isDefiningEvent\", false) DESC, e.position) AS n
      FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e
      WHERE e.aircrafts_position = 1 AND e.\"tier1Number\" GLOB '[1-9][0-9]*'
        AND (e.\"isDefiningEvent\" OR e.case_mkey IN (SELECT \"mKey\" FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' WHERE \"isPre1982\"))
    ),
    phases AS (
      SELECT case_mkey, 'current' AS scheme, code, CASE WHEN code >= 990 THEN 990 ELSE code // 50 * 50 END AS main
      FROM current_codes WHERE n = 1
      UNION ALL
      SELECT o.case_mkey, 'older', o.\"phaseOfFlightCode\", w.main
      FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o JOIN crosswalk w ON w.code = o.\"phaseOfFlightCode\"
      WHERE o.aircrafts_position = 1 AND o.\"occurrenceNumber\" = 1 AND o.case_mkey NOT IN (SELECT case_mkey FROM current_codes)
    ),
    case_phases AS (
      SELECT p.*, c.\"eventDate\", c.\"highestInjuryLevel\" = 'Fatal' AS fatal, a.aircraft_model_code
      FROM phases p JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = p.case_mkey
      LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = p.case_mkey AND a.position = 1
      WHERE c.\"eventDate\" >= DATE '1962-01-01' AND p.main IN (SELECT main FROM phase_names)
    )
  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 case_mkey FROM case_phases WHERE main = 450)
  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 CHI93LA236Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Waukesha, WIThe pilot's failure to maintain airspeed above a stall.Jun 27, 1993 · N83429 · Substantial damageNTSB CHI93LA201Accident · 1 fatalLimited investigationFinal reportBell 47G-2A-1 · Phlox, WIWas the pilot in command's failure to maintain aircraft control. A factor to the accident was the inadequate cyclic control.Jun 11, 1993 · N73988 · DestroyedNTSB CHI93LA179Accident · Minor injuriesLimited investigationFinal reportBell 47 · Berlin, WIThe pilot-in-command's failure to see the obstruction.May 21, 1993 · N8458E · DestroyedNTSB CHI93LA067Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · La Pointe, WISpatial disorientation of the pilot.Jan 9, 1993 · N7057B · Substantial damageNTSB CHI92DEP04Accident · Minor injuriesFinal reportGrumman 164A · Elkhorn, WIThe pilot-in-command's inadequate compensation for wind conditions.Aug 31, 1992 · N48635 · DestroyedNTSB CHI92FA231Accident · 2 fatalField investigationFinal reportCessna 120 · Maple, WIThe non-instrument rated private pilot's failure to maintain aircraft control.Aug 7, 1992 · N1947N · 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 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 CHI92FA066Accident · 1 fatalField investigationFinal reportPiper PA-31P · Mosinee, WIAn inflight fire with the cabin heater as the origin, and unsuitable terrain in which to make a forced landing. A factor related to the accident was the soft terrain.Jan 2, 1992 · N500BH · DestroyedNTSB CHI91DEP12Accident · No injuriesFinal reportSchweizer G-164-A · Elkhorn, WIThe pilot in command's failure to maintain adequate altitude.Aug 20, 1991 · N48635 · Substantial damageNTSB CHI91LA246Accident · 1 fatalLimited investigationFinal reportBeech 35A · Hager City, WIThe failure of the pilot to maintain airspeed above stalling speed while maneuvering.Aug 4, 1991 · N7451N · DestroyedNTSB CHI91DEP09Accident · 1 fatalFinal reportBowers Flybaby 1A · Stoughton, WIThe inadequate design by the manufacturer to provide for adequate protection from moisture accumulation in the form of drain holes. Contributing factors were the deterioration (wood rot) of the wing spar attach and the lack of inspection access.Jun 17, 1991 · N8084D · DestroyedNTSB CHI91DEP08Accident · 1 fatalFinal reportJack Thomas Pitts S-IT · Kenosha, WIImproper maintenance, by person or persons unknown, to the elevator control system which allowed a bolt attaching the elevator control rod to the pitch bellcrank to become disconnected during flight.Jun 16, 1991 · N83AM · DestroyedNTSB CHI91DEP04Accident · Minor injuriesFinal reportBrault Glasair SH2F · Green Bay, WIThe pilot in command's failure to refuel the aircraft prior to departure. A factor contributing to the accident was the unporting of the fuel pick up line in fuel tank during abrupt or negative 'g' maneuvers.Apr 11, 1991 · N1490 · Substantial damageNTSB CHI90FA212Accident · 1 fatalField investigationFinal reportBoeing A75N1 · Oshkosh, WIThe pilot-in-command's failure to maintain airspeed sufficient to avoid a stall/spin at an altitude insufficient to effect a full recovery.Aug 2, 1990 · N25400 · DestroyedNTSB CHI90FA197Accident · 2 fatalField investigationFinal reportCustom Aerotech White Lightning · Oshkosh, WIThe pilot-in-command's failure to maintain airspeed to avoid loss of control of the aircraft.Jul 26, 1990 · N7147W · DestroyedNTSB CHI89DEP10Accident · 1 fatalFinal reportAir Tractor AT-301 · Plainfield, WIFailure of the pilot-in-command to maintain control of the aircraft while conducting aerial application maneuvers in close proximity to the terrain.Aug 1, 1989 · N5044S · DestroyedNTSB CHI89FA151Accident · Minor injuriesField investigationFinal reportCessna A152 · Oshkosh, WIThe pilot's poor judgement, and poor evaluation of the weather due to self induced pressure and overconfidence in his personal ability. Contributing factor was the experimental aircraft association's inadequate supervision of the operation.Jul 29, 1989 · N7610A · DestroyedNTSB CHI89LA147Accident · 1 fatalLimited investigationFinal reportPiper PA-38-112 · River Falls, WIImproper remedial action by the pilot following an abrupt maneuver. The pilot's lack of total aviation experience was a factor in the accident.Jul 27, 1989 · N25687 · DestroyedNTSB CHI89LA133Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Iola, WIThe improper preflight planning by the pilot in command resulting in the airplane fuel quantity being near the unusable quantity which resulted in total loss of engine power due to fuel starvation while maneuvering. Contributing to the accident was the pilots…Jul 12, 1989 · N4054J · Substantial damageNTSB CHI89DEP06Accident · Minor injuriesFinal reportAeronca 15AC · Fort Atkinson, WIWater contamination of the fuel and the pilot's inadequate preflight. Factors related to the accident were: lack of suitable terrain for a forced landing & trees.Jul 3, 1989 · N1271H · Substantial damageNTSB CHI89FA071Accident · Serious injuriesField investigationFinal reportSikorsky S-58T · Milwaukee, WIDisconnect of the tailrotor drive shaft coupling.Apr 11, 1989 · N4247U · 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 CHI88FA120Accident · 1 fatalField investigationFinal reportBellanca 17-30A · Wautoma, WIPerformance of an aerobatic maneuver with insufficient altitude for recovery.May 31, 1988 · N28156 · DestroyedNTSB CHI88FA102Accident · 1 fatalField investigationFinal reportBellanca 7ECA · Merrimac, WIThe pilot had just taken off from a private strip and immediately entered a high angle of bank turn to the left at low altitude. A witness, who was an experienced aerobatic pilot, estimated the angle of bank to approach 90 degrees. The nose was seen to pitch…May 1, 1988 · N31288 · DestroyedNTSB CHI88FA056Accident · 1 fatalField investigationFinal reportCessna 150M · Norwalk, WIThe pilot made several calls to the fss and obtained weather briefings for reported and forecast IFR conditions along his proposed route of flight. After departure from sparta, Wisconsin in weather described by witnesses to be below VMC, the aircraft impacted…Jan 31, 1988 · N9458U · DestroyedNTSB 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.Jul 1, 1987 · N33967 · 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 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 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…Mar 31, 1986 · N23854 · Substantial damageNTSB 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 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…Jul 26, 1985 · N46Z · DestroyedNTSB 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…Jul 25, 1985 · N13708 · DestroyedNTSB 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.Jul 16, 1985 · N8877F · 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 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.Apr 14, 1985 · N4609X · Substantial damageNTSB 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 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…Oct 20, 1984 · N43833 · DestroyedNTSB 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 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.Aug 23, 1984 · N7890H · 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 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.Jul 11, 1984 · N2993P · DestroyedNTSB 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…Jun 30, 1984 · N377ST · Substantial damageNTSB 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 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…May 7, 1984 · N281B · Minor damageNTSB 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 CHI83LU012Accident · Serious injuriesFinal reportWeedhopper B · Fall Creek, WIThe ultralight collided with a powerline during maneuvering after takeoff. The pilot had made a normal takeoff and circled a hayfield and decided to return for landing. The pilot stated he had trouble controlling the acft in a left turn. During a turn the…Sep 3, 1983 · UNREG · DestroyedNTSB CHI83FA371Accident · 1 fatalField investigationFinal reportSiai-Marchetti F.260C · Oshkosh, WIThe foreign registered plt had a statement of aerobatic competency by an FAA inspector which contained a min alt limitation of 300 ft AGL. While performing at an air show, he had planned to pull up in a half loop, make a half roll on top, enter a 2 turn spin…Aug 6, 1983 · IRAID · Substantial damage