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 CHI08LA124Accident · 1 fatalLimited investigationFinal reportPiper PA-25-235 · New Lisbon, WIThe pilot's failure to maintain adequate altitude during a course reversal at the completion of an agricultural spray run.May 5, 2008 · N4352Y · Substantial damageNTSB CHI08CA007Accident · Serious injuriesData collectionFinal reportKrueger Quickie · Antigo, WIThe inadequate preflight planning and preparation by the pilot, the proper climb rate not obtained/maintained by the pilot, and the airspeed not obtained/maintained by the pilot. Contributing factors were the lack of total experience in the type of aircraft…Oct 8, 2007 · N5425D · Substantial damageNTSB CHI07LA260Accident · 1 fatalLimited investigationFinal reportPiper PA-28-140 · West Bend, WIThe pilot's decision to depart in adverse weather conditions, and his failure to maintain clearance from the terrain. Contributing to the accident included the pilot's lack of an instrument rating, his lack of recent night experience, the night conditions and…Aug 10, 2007 · N1696H · Substantial damageNTSB CHI06CA247Accident · Minor injuriesData collectionFinal reportPiper J-3C-65 · Bayfield, WIThe pilot's failure to maintain adequate airspeed while maneuvering which resulted in a stall. A factor associated with the accident was the low altitude at which the airplane stalled.Aug 27, 2006 · N76JS · Substantial damageNTSB CHI06LA163Accident · 1 fatalLimited investigationFinal reportVarga 2150A · Columbus, WIThe pilot's failure to maintain adequate clearance from the trees during the attempted low altitude pass along the river. Contributing factors were the intentional low altitude flight maneuver, the pilot's improper decision to attempt that maneuver, and his…Jun 25, 2006 · N8267J · DestroyedNTSB CHI06FA077Accident · 3 fatalField investigationFinal reportShort Brothers SD-360-300 · Watertown, WIThe other airplane's flight crew failure to maintain clearance while maneuvering during formation flight. Contributing to the accident was the decision of both flight crews to fly in formation.Feb 5, 2006 · N3735W · 2 aircraft · DestroyedNTSB CHI05FA197Accident · 1 fatalField investigationFinal reportNorth American F-51D · Malone, WIThe pilot not maintaining aircraft control and clearance from terrain for undetermined reasons during a low level maneuver.Jul 26, 2005 · N6327T · DestroyedNTSB CHI05FA194Accident · 1 fatalField investigationFinal reportCessna 172P · Jackson, WIThe pilot not maintaining aircraft control for undetermined reasons while maneuvering.Jul 20, 2005 · N65875 · DestroyedNTSB CHI04FA214Accident · 2 fatalField investigationFinal reportEurocopter France EC130 B4 · Prairie du Sac, WIThe pilot's intentional low-level flight toward the lake and his failure to maintain clearance from the static wire on power transmission lines. Contributing factors were the separation of the Fenestron (tail rotor) assembly from the tail boom as a result of…Aug 7, 2004 · N450CM · DestroyedNTSB CHI04LA128Accident · 1 fatalLimited investigationFinal reportNorth American P-51C · Hager City, WIThe improper installation of the camshaft drive gear assembly which resulted in the retaining nut backing off allowing the drive gear to move up the shaft. A factor associated with the accident was the low altitude at which the power loss occurred and the…May 29, 2004 · N61429 · Substantial damageNTSB CHI04FA045Accident · 2 fatalField investigationFinal reportMooney 20E · Webster, WIThe pilot's inadequate decision to conduct a low altitude flight maneuver without sufficient altitude to maintain clearance from the terrain. Low altitude flight and ostentatious display are contributing factors.Dec 20, 2003 · N1275X · DestroyedNTSB CHI03FA301Accident · 1 fatalField investigationFinal reportAeronca 11BC · Colfax, WIThe pilot failed to maintain adequate airspeed while maneuvering which resulted in an inadvertent stall. A factor associated with the accident was the low altitude at which the pilot was maneuvering.Sep 7, 2003 · N4103E · Substantial damageNTSB CHI03LA272Accident · No injuriesLimited investigationFinal reportPiper PA-25 · Brandon, WIThe pilot failed to maintain clearance from the corn crop during an aerial application maneuver. Additional factors were the terrain induced turbulence and the corn crop.Aug 19, 2003 · N4346Y · Substantial damageNTSB CHI03LA185Accident · Minor injuriesLimited investigationFinal reportHiller UH-12E · Elk Mound, WIThe pilot's failure to maintain clearance from the terrain. Factors contributing to the accident were the whirlwind, the turbulence, and the helicopter's low altitude.Jun 27, 2003 · N62417 · DestroyedNTSB CHI03LA053Accident · Minor injuriesLimited investigationFinal reportRobinson R22B · Oshkosh, WIThe directional control not maintained by the unrated helicopter pilot, and the remedial action not performed by the pilot-in-command. The pilot-in-command's lack of certification as a certified flight instructor and the dark night conditions were…Jan 14, 2003 · N530DB · Substantial damageNTSB CHI02CA203Accident · Minor injuriesData collectionFinal reportBilgri Sonerai II Lts · Juneau, WIThe pilot's failure to maintain sufficient airspeed while maneuvering to return to the airport. A reduction in handling quality and the distraction due to the open canopy were contributing factors.Jul 19, 2002 · N9B · Substantial damageNTSB CHI02LA133Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Bancroft, WIThe loss of engine power due to contamination of the fuel system from an unknown source and the blocked fuel filter. The rough terrain was a factor.May 10, 2002 · N4224X · Substantial damageNTSB CHI02LA013Accident · Serious injuriesLimited investigationFinal reportMeester HP-14 · Sturtevant, WIThe restricted movement of the aileron control system for undetermined reasons.Oct 27, 2001 · N8833 · Substantial damageNTSB CHI02LA003Accident · Serious injuriesLimited investigationFinal reportKainz Kitfox IV · Tomahawk, WIThe inadvertent stall/spin encountered by the pilot during a slow flight maneuver. Factors relating to this accident were the low airspeed and the trees.Oct 9, 2001 · N1195F · DestroyedNTSB CHI01LA288Accident · No injuriesLimited investigationFinal reportCessna 188 · Almond, WIthe pilot failed to maintain clearance from the corn crop. Additional factors were the inoperative spray pump, the corn crop, and the pilot's diverted attention.Aug 22, 2001 · N91138 · Substantial damageNTSB CHI01LA243Accident · 1 fatalLimited investigationFinal reportBell 47G-2 · Wheeler, WIThe pilot not maintaining altitude/clearance from the power transmission line. A factor to the accident was the power transmission line.Jul 26, 2001 · N986B · Substantial damageNTSB CHI01LA240Accident · No injuriesLimited investigationFinal reportSnow 600-S2C · Plainfield, WIThe pilot not maintaining aircraft control while maneuvering on the aerial application flight. A factor to the accident was the encountered stall/mush at a low altitude.Jul 21, 2001 · N8703V · Substantial damageNTSB CHI01LA177Accident · Serious injuriesLimited investigationFinal reportTaylorcraft DCO-65 · Kenosha, WIthe inadvertent stall by the pilot. The low altitude was a contributing factor.Jun 17, 2001 · N46215 · DestroyedNTSB CHI01FA180Accident · 2 fatalField investigationFinal reportPotez-Air Fouga CM 170 · La Crosse, WIThe fatigue failure of the aircraft's left wing tip fuel tank rear attachment, while the aircraft was being maneuvered in a low approach, leading to the tank's in-flight separation and subsequent in-flight break up of the airplane and the aircraft's control…Jun 16, 2001 · N301FM · DestroyedNTSB CHI01LA138Accident · 1 fatalLimited investigationFinal reportBrault Glasair SH2F · Green Bay, WIThe pilot allowed the airspeed to get too low and inadvertently stalled the airplane.May 16, 2001 · N1490 · Substantial damageNTSB CHI01FA085Accident · 1 fatalField investigationFinal reportCessna 152 · Horicon, WIthe inadvertent stall/spin. Additional factors included the aerobatic manuevers, low altitude, and the procedures not followed.Feb 10, 2001 · N5085P · DestroyedNTSB CHI01FA044Accident · 2 fatalField investigationFinal reportBeech 95-B55 · Milltown, WIThe flight instructor's inadequate supervision of the flight, the flightcrew not maintaining control of the airplane, and the flight instructor's delayed remedial action which resulted in the inadvertent spin. Factors to the accident were the inadvertent spin…Dec 3, 2000 · N7678N · Substantial damageNTSB CHI00LA277Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Spring Brook, WIA fatigue failure of the tail rotor drive gear shaft.Aug 31, 2000 · N67083 · Substantial damageNTSB CHI00LA189Accident · No injuriesLimited investigationFinal reportStaudacher S-300D2 · Kenosha, WIThe fatigue failure of the rod end bearing and the separation of the aileron. A factor was the inadequate design change by the aircraft designer.Jul 7, 2000 · N112KG · Substantial damageNTSB CHI99LA334Accident · Minor injuriesLimited investigationFinal reportBell 206B · Nekoosa, WIthe pilot's inadequate compensation for wind gusts. Factors were the wind gusts and the two vehicles parked nearby.Sep 9, 1999 · N4010G · Substantial damageNTSB CHI99LA273Accident · No injuriesLimited investigationFinal reportMooney M20B · Hayward, WIthe pilot's failure to maintain clearance with the surface of the lake. Factors associated with the accident were the low level flight, dusk light conditions, and the glassy water.Jul 26, 1999 · N74523 · Substantial damageNTSB CHI99LA248Accident · No injuriesLimited investigationFinal reportRobinson R22 · Spring Green, WIthe pilots failure to maintain clearance with the wire. A factor was the wire.Jul 23, 1999 · N2313D · Substantial damageNTSB CHI99FA167Accident · 1 fatalField investigationFinal reportChampion 7ECA · Comstock, WIThe pilot's failure to maintain aircraft control. A factor contributing to this accident was the airplane's low altitude.May 29, 1999 · N12028 · DestroyedNTSB CHI99FA042Accident · 2 fatalField investigationFinal reportCessna 172F · Coleman, WIpilot's failure to maintain clearance from the trees and his intentional flight into IMC conditions. Factors contributing to this accident were the pilot's lack of instrument certification, his becoming lost in the poor weather, his inadequate preparation for…Nov 29, 1998 · N72RE · DestroyedNTSB CHI99LA005Accident · Serious injuriesLimited investigationFinal reportPiper J3C-65 · New Holstein, WIthe pilot-in-command's intentional low altitude maneuver and his ostentatious display. A factor was his allowing the airplane to enter an inadvertent stall.Oct 11, 1998 · N70880 · Substantial damageNTSB CHI99LA007Accident · 1 fatalLimited investigationFinal reportBellanca 8KCAB · Superior, WIthe pilot not maintaining clearance with the terrain, and his improper decision to enter maneuvers too close to the terrain. Factors contributing to this accident were the aerobatic maneuvers, the trees and the berm.Oct 9, 1998 · N924TA · DestroyedNTSB CHI98FA123Accident · 1 fatalField investigationFinal reportCessna 180J · Ashland, WIthe pilot failing to maintain separation from the trees. Factors contributing to this accident were the trees and the pilot being too low in altitude.Apr 15, 1998 · N828CE · DestroyedNTSB CHI98LA083Accident · Minor injuriesLimited investigationFinal reportNerstrom-Tailwind W-8 · Lodi, WIthe pilot's failure to maintain a proper altitude due to the whiteout conditions. Factors associated with the accident were the low pass performed by the pilot and the visual illusion created by the whiteout conditions.Jan 20, 1998 · N12038 · DestroyedNTSB CHI98LA030Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Madison, WIthe flight instructor's (CFI's) inadequate supervision of the flight, and his failure to ensure that control of the airplane was maintained. Factors associated with the accident were: the CFI's improper use of flaps, and subsequent contact with the runway…Nov 5, 1997 · N2536N · Substantial damageNTSB CHI97LA225Accident · No injuriesLimited investigationFinal reportSorrell SNS-7 · Tomahawk, WIThe pilot encountered a tailplane stall. The factors involved were the pilot conducted a low altitude flight maneuver and encountered engine torque effect.Jul 27, 1997 · N774HB · DestroyedNTSB CHI96LA293Accident · No injuriesLimited investigationFinal reportAero Commander 600 · Rhinelander, WIa total loss of engine power for undetermined reasons.Aug 12, 1996 · N1797S · DestroyedNTSB CHI96LA236Accident · No injuriesLimited investigationFinal reportWsk Pzl Mielec M-18 Dromader · Waupaca, WIinadequate maintenance of the throttle cable by maintenance personnel.Jul 10, 1996 · N2047S · Substantial damageNTSB CHI96LA222Accident · 1 fatalLimited investigationFinal reportPiper J3C-90 · Racine, WIwas improper remdial action by the pilot after encountering a stall when the elevator back pressure was not removed and the ailerons were positioned for a right bank by that increasing the airplane's left yaw/roll action. Factors in this accident were a stall…Jun 29, 1996 · N77563 · DestroyedNTSB CHI96LA165Accident · Serious injuriesLimited investigationFinal reportAS+ AC 4 · Hartford, WIlack of airspeed control by the pilot, while maneuvering.May 18, 1996 · N29HS · Substantial damageNTSB CHI96LA105Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Camp Lake, WIFailure of the pilot to maintain clearance from trees that were located beside the runway.Mar 12, 1996 · N2966U · Substantial damageNTSB CHI95LA288Accident · Serious injuriesLimited investigationFinal reportde Havilland DHC-1 · Hammond, WIan overload failure of the right horizontal support tube assembly which the pilot/owner had modified to be adjustable. A factor in the accident was the corn.Aug 19, 1995 · N320WM · DestroyedNTSB CHI94LA091Accident · No injuriesLimited investigationFinal reportCessna 150M · La Crosse, WIThe failure of the exhaust valve in the number one cylinder. The lack of suitable terrain for the forced landing was a factor in the accident.Feb 18, 1994 · N704CE · Substantial damageNTSB CHI94LA025Accident · No injuriesLimited investigationFinal reportCessna 150M · Franklin, WIFailure of the instructor pilot (CFI) to use carburetor heat during the simulated engine failure, which resulted in carburetor ice and loss of engine power. Factors related to the accident were: carburetor icing conditions and the crop in the emergency…Oct 26, 1993 · N9259U · Substantial damageNTSB CHI94FA010Accident · 2 fatalField investigationFinal reportCessna R182 · Herbster, WIFailure of the pilot to maintain clearance from trees.Oct 11, 1993 · N6422S · DestroyedNTSB 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 · Destroyed