NTSB investigations, IL

333 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\" = 'IL' 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 CHI90DEV09Accident · 1 fatalFinal reportPietenpol AIR Camper · Minonk, ILThe pilot's inattention to visual lookout.Aug 7, 1990 · N535CG · DestroyedNTSB CHI90FA193Accident · 2 fatalField investigationFinal reportPiper PA-38 · Hinckley, ILThe instructor pilot's inability to recover from a stall/spin. Factors were: acft wt & balance exceeded, and the instructor's and student pilot's lack of familiarity with acft.Jul 25, 1990 · N2508D · DestroyedNTSB CHI90DEE07Accident · Minor injuriesFinal reportSchweizer G-164B · Deer Grove, ILThe pilot's inadequate visual lookout, resulting in collision with a power line.Jun 26, 1990 · N8483K · Substantial damageNTSB CHI90DEV04Accident · No injuriesFinal reportGrumman G-164B · Princeton, ILThe pilot-in-command's failure to maintain adequate clearance from obstacles during flight at low altitude, resulting in wire strike.May 18, 1990 · N6695Q · Substantial damageNTSB CHI90DEV03Accident · Minor injuriesFinal reportBellanca 8KCAB · Lawrenceville, ILThe student pilot failure to maintain flying speed. Contributing to the accident was the flight instructor in that the instructor allowed the student to let the airspeeed dissipate below stall speed.Apr 16, 1990 · N50671 · Substantial damageNTSB CHI90DEE03Accident · 1 fatalFinal reportNelsen-David Sonerai II/EV · Huntley, ILPilot-in-command's failure to maintain airspeed during a turn at low altitude, resulting in an inadvertent stall and impact with terrain, lack of recent total experience and lack of total experience in type of aircraft.Nov 26, 1989 · N4984H · DestroyedNTSB CHI90FA026Accident · 1 fatalField investigationFinal reportCessna 172D · Mt Morris, ILVFR flight into IMC and spatial disorientation of the pilot. Contributing to the accident were the meteorological conditions and the overconfidence and lack of experience of the pilot.Nov 15, 1989 · N2796U · DestroyedNTSB CHI90DEE01Accident · Serious injuriesFinal reportBaker/Santiago Pitts S-1S · Dekalb, ILImproper planning/decision by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel.Oct 8, 1989 · N983CS · Substantial damageNTSB CHI89DEV06Accident · No injuriesFinal reportHughes 269C · Millersville, ILLoss of rotor RPM for an undetermined reason during a turn to reverse direction while applying agricultural chemicals.Jun 6, 1989 · N7439F · DestroyedNTSB CHI89MA095Accident · 3 fatalMajor investigationFinal reportDouglas DC3C-S13CG · Waterman, ILThe pilot-in-command (PIC) failed to provide adequate supervision while training the copilot and allowed the aircraft to enter a stall/spin, then did not provide adequate remedial action to properly recover from the spin. Factors related to the accident were:…May 22, 1989 · N47CE · DestroyedNTSB CHI89LA029Accident · Minor injuriesLimited investigationFinal reportMcdonnell Douglas 269C · Frankfort, ILThe helicopter experienced a tree strike with the main rotor blades and then rolled over when it struck the ground during a precautionary landing attempt. The helicopter had been conducting contract power line patrol when the PIC noted an apparent partial…Nov 28, 1988 · N1098P · Substantial damageNTSB CHI89DEV02Accident · 1 fatalFinal reportAir Command 503 · Sullivan, ILThe pilot failed to maintain control of the aircraft.Nov 13, 1988 · UNREG · DestroyedNTSB CHI89DEV01Accident · No injuriesFinal reportCessna 152 · Vandalia, ILThe eng began running rough aprx 5 min after the plt took off from an en route arpt drg a night, x-country training flt. He reversed course back toward the departure arpt with the eng providing partial power. While maneuvering to land on rwy 18, the eng…Nov 8, 1988 · N93085 · Substantial damageNTSB CHI88FA240Accident · 1 fatalField investigationFinal reportBellanca 8KCAB · Oswego, ILInadequate design inthe manufacture of the pilot's seat which failed during intentional aerobatic maneuvers for which the aircraft including the seat were intended.Sep 20, 1988 · N50702 · DestroyedNTSB CHI88DEV04Accident · No injuriesFinal reportGrumman G164A · Chenoa, ILUnavailability of suitable terrain on which to accomplish a forced landing.Aug 3, 1988 · N8980H · Substantial damageNTSB CHI88DEE07Accident · No injuriesFinal reportHughes 269C · Sandwich, ILThe plt rprtd that while he was conducting spraying opns, he noted a significant loss of eng power. He made a run-on landing in a bean field. As he landed, the left skid dug into a furrow & the helicopter rolled over. During the investigation, which included…Jul 21, 1988 · N7425F · Substantial damageNTSB CHI88DEV02Accident · No injuriesFinal reportGrumman G-164A · Cape Girardeau, ILThe plt was applying chemicals to a field with 3 radio transmission towers along one side. He rprtd that as he was finishing the field, he circled one of the towers, them made a final swath run across the end of the field. He stated that as he pulled up from…Jul 18, 1988 · N677U · Substantial damageNTSB CHI88DEE02Accident · 1 fatalFinal reportHill Bushby Mustang II · Yorkville, ILPerformance of aerobatic maneuvers with insufficient altitude for recovery.Feb 18, 1988 · N84HM · DestroyedNTSB CHI88FA012Accident · 2 fatalField investigationFinal reportBellanca 8KCAB · Lawrenceville, ILWhile performing aerobatic maneuvers the aircraft entered a spin to the left and did not recover before impacting the ground. The acft entered the spin after the plt announced that this spin would be the last maneuver before landing. The spin was started at…Oct 31, 1987 · N41682 · DestroyedNTSB CHI87FA219Accident · 1 fatalField investigationFinal reportBeech H-18 · Rockford, ILThe commercial pilot was on a repositioning flight from kenosha, Wisconsin to atlanta, Georgia, after having been without sleep for about 20 hours. Witnesses observed the aircraft circling a subdivision near Rockford, Illinois at a low altitude, just above…Sep 22, 1987 · N5850S · DestroyedNTSB CHI87DEE10Accident · Minor injuriesFinal reportHughes 269A · Plainfield, ILWhile maneuvering at about 4 feet above ground level the pilot experienced a loss of engine power and entered an uncontrolled right turn and descent, colliding with the ground. The engine power loss was due to the failure of a stud and bolt holding the…Sep 15, 1987 · N8927F · Substantial damageNTSB CHI87FA195Accident · 3 fatalField investigationFinal reportCessna 172 · Baileyville, ILWhile performing a low level (300-400' above the ground) flight search for a remote controlled aircraft that had been lost during flight, the pilot lost control of the acft. A witness reported that the aircraft entered a 'tight left turn', and then the nose…Aug 23, 1987 · N8207B · DestroyedNTSB CHI87FA132Accident · 1 fatalField investigationFinal reportJauch Coot · Franklin Grove, ILThe plt deptd mendota, IL on a local test flt under a 40 hour time in service restriction in an experimental home built airplane. A witness stated that the airplane was circling over his farm and then turned south. He said the eng stalled and the airplane…May 21, 1987 · N81KX · DestroyedNTSB CHI87FA104Accident · 1 fatalField investigationFinal reportPiper PA-32-300 · Frankfort, ILAircraft control was lost as the pilot attempted to descend to his assigned altitude of 5000 feet from excessive climb. He was in IFR conditions at the time. The airframe broke apart, empennage first, during the uncontrolled descent to the ground due to high…Mar 27, 1987 · N452BH · DestroyedNTSB CHI87LA041Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Vergenns, ILAccording to the student pilot, while practicing emergency landings, he descended to about 250 feet AGL and then surrendered the controls to the instructor. The student pilot stated that the instructor immediately added full power and banked the acft to the…Dec 5, 1986 · N95614 · Substantial damageNTSB CHI86FEV03Accident · 1 fatalFinal reportWoodrow Starduster SA-100 · New Baden, ILThe owner of the single seat, home built, acft offered to allow a navy F-14 plt to fly the plane. The owner made a shortflt, then proceeded to give the F-14 plt a cockpit check. The check-out explaination included such things as the flt characteristics,…Jul 26, 1986 · N64HW · DestroyedNTSB CHI86FEV02Accident · Serious injuriesFinal reportJerry Cox Goldwing · Mattoon, ILThe acft was circling a racetrack at a relatively low alt, described as between 800-1500 ft AGL, with the eng throttled back. During a subsequent steep bank to the left while accelerating the left wing failed and the acft crashed into the trees.May 24, 1986 · N85JC · Substantial damageNTSB CHI86FEE03Accident · No injuriesFinal reportBeaupre Elfering Quickie · Waukegan, ILThe acft crash landed in a cultivated part of the arpt after the eng quit during takeoffs & landings. The acft climbed to about 400 ft AGL and started a turn when the eng stopped. The acft was glided to an alfalfa field on the arpt. The acft was damaged…May 12, 1986 · N134BE · Substantial damageNTSB CHI86FA129Accident · Minor injuriesField investigationFinal reportBell 222B · Chicago, ILThe aircraft had just discharged two passengers on the rooftop helipad and was preparing for departure. The aircraft was picked up to a hover and the tailrotor struck a heliport surface perimeter light. The tailrotor separated from the aircraft and the…Apr 25, 1986 · N660DD · Substantial damageNTSB CHI86FA068Accident · 1 fatalField investigationFinal reportCessna 177RG · Valley View, ILThe plt was conducting a low pass, 40 ft AGL, on a river and struck a power line crossing his flt path. The strike caused loss of control and the acft impacted on the frozen surface of the river.Jan 19, 1986 · N52949 · DestroyedNTSB CHI86FA029Accident · 2 fatalField investigationFinal reportCessna 172N · Mt Carmel, ILAccording to the survivor, the plt & 2 pax all had a beer, then went to the arpt. After taking off at night, the plt flew over Mt Carmel, then flew toward his home. He elected to make a low pass over his house. During the pass, the acft struck a tree & some…Nov 17, 1985 · N738PL · DestroyedNTSB CHI86FA013Accident · 1 fatalField investigationFinal reportCessna 170A · Murphysboro, ILThe plt took off in marginal VMC in an acft placarded for 'day VFR only'. Aprx 32 minutes after takeoff the acft collided with trees and descended to ground impact. A hunter in the local area at the time of the accident reported hearing the acft eng sound…Oct 19, 1985 · N9271A · DestroyedNTSB CHI85FEV03Accident · 1 fatalFinal reportCessna 172 · Sweetwater, ILThe acft was observed flying at low alt parallel to a hiway before colliding with a tree before impacting the ground. The plts wife said that the plt had been under extreme stress for a few months and had not been to bed for 2 days preceding the accident. She…Sep 8, 1985 · N6236E · DestroyedNTSB CHI85FA292Accident · 1 fatalField investigationFinal reportCessna 170A · Olney, ILThe aircraft departed new baden and began flying erratically down an interstate highway. It caused one automobile accident by flying low head-on passes at cars. It flew underan overpass, damaging a wingtip in the process. It flew intoan electrical cable and…Jul 16, 1985 · N1223D · Substantial damageNTSB CHI85LA280Accident · No injuriesLimited investigationFinal reportHughes 269A1A · Coal Valley, ILDuring an aerial application run the plt reported a 'split second loss of power.' He lost directional control of the helicopter and it settled into tall corn. Impact resulted in loss of the main rotor blades, severence of the tail cone and separation of the…Jul 10, 1985 · N8951F · Substantial damageNTSB CHI85FA211Accident · 1 fatalField investigationFinal reportSteens Skybolt · New Baden, ILWitnesses stated the acft made a low pass down the rwy (20 to 30 ft AGL) at an airspeed of aprx 200 mph. The acft then entered a steep climb and at about 100 at AGL, the acft rolled to the right. The acft lost alt during the roll and descended to ground…May 27, 1985 · N64AB · DestroyedNTSB CHI85LA197Accident · No injuriesLimited investigationFinal reportHughes 269 · Stonington, ILAfter completing a swath run, the plt maneuvered the helicopter up over a power line, then made a turn-around for another swath run. He stated that as he started the next run, he 'felt the wind push the tail upward forcing the nose downward...' He applied aft…May 15, 1985 · N7485F · DestroyedNTSB CHI85LA191Accident · No injuriesLimited investigationFinal reportCessna A188B · Virden, ILDuring aerial application, the pilot attempted to pass over a set of low wires and under high tension lines. The wires are 300 ft. apart horizontally. The prop contacted the high tension lines and the acft was destroyed on contact with the ground.May 8, 1985 · N731VR · DestroyedNTSB CHI85LA048Accident · Serious injuriesLimited investigationFinal reportBeech D-45 (T-34) · Bedford, ILThe plt reported that during flt, he proceeded to fly along a river. After a time, he reversed course & began flying along the river in the opposite direction. He said that the flt back was at a lower alt & that the propeller contacted something in the water.…Nov 12, 1984 · N5543 · DestroyedNTSB CHI84FA282Accident · Serious injuriesField investigationFinal reportCessna 205 · Oak Brook, ILPilot and passengers here circling over a golf tournanent taking photographs when the engine quit. The pilot made an emergency landing on an adjacent golf course and the aircraft struck a tree during the rollout. Post accident exam of the eng revealed no…Jul 8, 1984 · N8377Z · DestroyedNTSB CHI84LA152Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Hoffman Estates, ILThe acft nosed over in a plowed field after the plt made an off-arpt landing. The plt said he was practicing turns around a point when he noticed a loss of alt and a sputtering of the engine. Since he was low he decided to land. (Therewas a sod strip 1/2 mile…Apr 11, 1984 · N8400B · Substantial damageNTSB CHI84FA119Accident · 1 fatalField investigationFinal reportCessna 152-II · Manhattan, ILThe acft was observed entering a spin from a nose high attitude from which it failed to recover. The student pilot was seen waving to his family as the acft circled in the vicinity of his parent's home. There was no evidence of preimpact failure or…Feb 26, 1984 · N4972H · DestroyedNTSB CHI84FU001Accident · 1 fatalFinal reportQuicksilver MX · Elwin, ILThe plt possessed a student plt & 3rd class medical certificate. After takeoff, he circled over the airfield, then climbed to about 200 ft AGL. A high school classmate stated that the ultralight then entered a nose high attitude & appeared to enter a practice…Nov 5, 1983 · UNREG · DestroyedNTSB CHI83LU011Accident · Serious injuriesFinal reportPioneer Flightstar · Robinson, ILThe plt reported that after taking off, he stayed low over farm fields. He reported that he traveled about 1 1/4 mi from the arpt & decided to return & land. However, during a left turn, the ultralight vehicle crashed. The plt was seriously injured & did not…Aug 27, 1983 · UNREG · Substantial damageNTSB CHI83FA387Accident · 2 fatalField investigationFinal reportAerotek Pitts S-2A · Waukegan, ILWhile on a local flt, the acft crashed in lake Michigan about 1/2 mi from the shoreline. According to witnesses, it was flying over the water at about 100 ft, then pulled almost straight up to about 300 ft above the water, nosed over & went almost straight…Aug 20, 1983 · N80016 · DestroyedNTSB CHI83LA342Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-235 · Camp Point, ILThe plt had just completed a swath run. As he approached a road he pulled up to avoid a car, then attempted to descend below power lines & in so doing collided with a stop sign. The acft cartwheeled & landed inverted in a bean field.Jul 31, 1983 · N4332Y · Substantial damageNTSB CHI83LA238Accident · Minor injuriesLimited investigationFinal reportCessna 305A · Park Forrest, ILThe acft was being flown on a routine flight check after having completed an annual inspection. The plt stated that after takeoff he climbed to 800 ft, turned downwind, extended flaps to 30 deg, slowed to 70-80, & intended to make a pass over the field to…Jun 4, 1983 · N5258G · Substantial damageNTSB CHI83FA125Accident · 1 fatalField investigationFinal reportDodd Pitts S1S · Harvard, ILThe acft crashed into an open field leaving no ground scars other than the principal impact. One witness saw the acft stall at the top of a loop and go into a spin (tail-down). He stated the acft rotated 6-8 times prior to impact with the engine running. The…Mar 1, 1983 · N11D · DestroyedNTSB CHI83LA062Accident · 1 fatalLimited investigationFinal reportScorpion Too · Sandwich, ILThe rotorcraft impacted the runway very hard with no flare after the engine quit 100-200 feet AGL. The pilot had no training in this aircraft. No fuel was found in the fuel tank and no fuel odors were present. An examination of the fuelsystem, engine and…Dec 18, 1982 · N9354A · DestroyedNTSB CHI83LA011Accident · Minor injuriesLimited investigationFinal reportRand KR2 · Fairview, ILThe pilot overflew his destination and attempted to locate the airport. The pilot realized his fuel supply was low and decided to land in an open field. The aircraft's left wing struck the ground during the landing and the aircraftcartwheeled.Oct 6, 1982 · N2263N · Destroyed