OpenAirDocs.org

NTSB investigations

18,851 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.\"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 SEA82FYK11Accident · 2 fatalFinal reportCessna T210M · Cottage Grove, ORThe aircraft crashed while receiving radar vectors from eugene approach control to the vor-dme runway 34 approach at eugene, OR. Investigation revealed that the aircraft impacted tree tops in a level, nose down attitude and traveled approximately 180 yard…Jul 29, 1982 · N761ZY · DestroyedNTSB NYC82DA172Accident · No injuriesFinal reportHughes 269A · Westfield, MAThe helicopter started to spin around after takeoff during a hover in strong wind. The pilot decided to land. Sideloading broke a skid and the helicopter rolled over during touchdown.Jul 29, 1982 · N8782F · Substantial damageNTSB CHI82IA282Incident · No injuriesIncident investigationFinal reportCessna 172N · Columbus, OHDuring stall recovery practice, the right control yoke jammed in the full forward position. Recovery was accomplished byplacing both feet on the instrument panel for leverage then pulling the yoke rearward. Investigation revealed that the RH nylon bearing on…Jul 29, 1982 · N6292D · Minor damageNTSB CHI82DA281Accident · No injuriesFinal reportEnstrom 280C · Spring Green, WIThe aircraft was on a photographic flight for the purpose of taking pictures of a piece of farm equipment. The first pass was made at about 50 ft AGL, heading into the wind. A turn was then made downwind, back toward the farm equipment. At about that time,…Jul 29, 1982 · N5698M · Substantial damageNTSB LAX82FA279Accident · 2 fatalField investigationFinal reportCessna 152 · Morgan Hill, CAA Cessna 152, N5090Q and a Cessna 172, N20100 collided in flight while the aircrews of both aircraft were on local dual instructional flights. The student in the Cessna 152 was practicing a recovery from an unusual attitude after the instructor (ip) put the…Jul 28, 1982 · N5090Q · 2 aircraft · Substantial damageNTSB CHI82DA279Accident · No injuriesFinal reportBell 47G-2 · Plainview, MNWhile making cleanup swaths over an odd shaped portion of a corn field, the pilot made two turns of about 220 degrees each in close proximity to each other. The second turn was made downwind from two previous swaths that had just been completed. During a…Jul 28, 1982 · N19JM · Substantial damageNTSB ANC82DA063Accident · Minor injuriesFinal reportPiper PA-32-300 · Mckinley Nat'L., AKThe pilot was flying over one glacier at about 700 feet AGL and turned to fly to another upslope glacier. He encountereda downdraft and was unable to climb enough to avoid colliding with the glacier. The elevation of the crash site was about 6600 ft MSL.Jul 28, 1982 · N3093T · Substantial damageNTSB DEN82DA144Accident · No injuriesFinal reportPiper PA-25-235 · Leonard, NDThe pilot stated the engine lost power as he pulled up from the final spray run. The aircraft wing contacted a tree and a forced landing was made in a barley field. Post flight exam showed no reason for the power loss.Jul 26, 1982 · N4461Y · Substantial damageNTSB CHI82DA276Accident · No injuriesFinal reportPiper PA25-235C · Ada, MNThe pilot sprayed one field and proceeded to the next field about 2 miles away. He stated that he executed a tight 270 deg turn to the right at about 100 ft. he also stated that after about 90 deg through the turn, the aircraft lost power, stalled and…Jul 26, 1982 · N7208Z · Substantial damageNTSB SEA82FYM22Accident · 3 fatalFinal reportPiper 24-140 · Enterprise, ORWitnesses observed an aircraft fly over the city of Enterprise, Oregon on a bright night with clear sky conditions. Reportedly, the aircraft was flying very erratic; and just as it disappeared from the witnesses' sight, an explosion andfireball were observed…Jul 25, 1982 · N55492 · DestroyedNTSB DEN82DA143Accident · No injuriesFinal reportCessna 150M · Nr. Colorado Sp, COThe acft crashed in north cheyenne wood near pikes peak at approximately 8400 ft MSL. The plt reported that after arriving at the first ridge of mountains he was caught in downdrafts. Unable to clear the top of a mountain, he turned into a box canyon.Jul 25, 1982 · N9424U · DestroyedNTSB SEA82DA128Accident · Serious injuriesFinal reportAeronca 7AC · Kent, WADuring practice steep turns the aircraft encountered its wake turbulence. Manuevers to regain control were not effective. The aircraft contacted trees in a nose low attitude.Jul 24, 1982 · N82651 · DestroyedNTSB FTW82FRJ14Accident · Serious injuriesFinal reportCessna 188 · Monroe, LADuring turn around after first spray run, the aircraft collided with trees at an altitude of 75 feet. The path of flight was on a heading of 280 degrees, into the sun.Jul 24, 1982 · N9125G · Substantial damageNTSB CHI82DA272Accident · No injuriesFinal reportStinson 108-1 · Laporte, INThe pilot/mechanic was preparing to make an annual inspection of the aircraft. He was in the process of flight testing the plane to find defects when engine stoppage occurred. While landing in a bean field. The left tire blew out and the left gear dug into…Jul 24, 1982 · N97904 · Substantial damageNTSB CHI82DA270Accident · Serious injuriesFinal reportAustin S.E. 5A · Bolingbrook, ILThe pilots of an Austin s.e. 5A and a folker (both ww I replica aircraft) agreed to make a photo fly-by. The pilot of the Austin took off as number one, but instead of remaining in the traffic pattern, he turned out of the pattern. The folker pilot followed…Jul 24, 1982 · N8040Z · DestroyedNTSB MKC82FCD08Accident · Serious injuriesFinal reportCessna A150L · New Hampton, IAThe aircraft crashed while maneuvering in the vicinity of the pilot/owner's private airfield. The pilot stated that plane went into a 180 deg reverse backslide after he started a left turn and applied left rudder and aileron. He reported that the plane began…Jul 23, 1982 · N5937J · Substantial damageNTSB LAX82AA274Accident · 3 fatalFinal reportBell UH-1B · Valencia, CAAcft being used to film movie scene depicting attack of village typical of villges in viet nam. Acft was about 25 ft AGL & above location where special effects explosives were detonated. As the plt turned acft for camera coverage, acft'stail section was…Jul 23, 1982 · N87701 · Substantial damageNTSB CHI82FA267Accident · No injuriesField investigationFinal reportRobinson R22 · Milwaukee, WIAs the student plt was practicing a hovering maneuver, the acft started moving to the left & losing altitude slowly. The CFI was adding collective pitch when the left skid contacted the ground & the acft rolled over. The left skid, m/r blades & tailboom…Jul 23, 1982 · N9031F · Substantial damageNTSB LAX82FA269Accident · Minor injuriesField investigationFinal reportCessna 150M · Orinda, CAWhile enroute to oakland the plt reported experiencing a loss of climbing power at 2,000 ft near the san pablo reservoir. He applied carb heat, checked mixture setting & primer. He then extended full flaps & retarded the throttle just prior to landing in the…Jul 21, 1982 · N8288U · Substantial damageNTSB LAX82DA271Accident · Minor injuriesFinal reportGrumman G-164A · Chandler, AZWhile spraying at night & during the fourth pass under power lines crossing the field, the acft contacted the wires. After the accident the flagger at the field informed the plt that the wind was causing the wires to whip up & down at times.Jul 21, 1982 · N6559 · Substantial damageNTSB FTW82FPJ16Accident · Serious injuriesFinal reportPiper 18 · Gage, OKThe aircraft was being used to spray grasshoppers and was flying in an easterly direction. The right wing struck a high line wire that is oriented north and south. After striking the wire the aircraft struck the ground approximately 190 feet east of the high…Jul 21, 1982 · N3937Z · Substantial damageNTSB FTW82FPD16Accident · Serious injuriesFinal reportCessna 188B · Stanford, TXThe pilot had completed spraying approximately 75 percent of a 76 acre field. Witnesses stated that the aircraft collided with the lower of two powerlines. The aircraft was observed to clear the higher of the two power lines but hook the lower set of wires…Jul 21, 1982 · N731AK · DestroyedNTSB CHI82FA262Accident · 2 fatalField investigationFinal reportCessna 150L · Pontiac, ILBoth plts onboard were cfi's. the acft was observed to slow down & enter a stall/spin which continued to impact.Jul 21, 1982 · N18727 · DestroyedNTSB MKC82FCQ13Accident · 1 fatalFinal reportCessna 152 · Rose Hill, KSThe student pilot was on a solo flight while he was in a training phase to practice flight maneuvers. During the flight, the aircraft crashed and burned. An investigation revealed that the plane did not move after impact and both wings were crushed…Jul 20, 1982 · N5179B · DestroyedNTSB LAX82FA267Accident · Serious injuriesField investigationFinal reportCessna T337H · Near Inyokern, CAApproximately 10 min after takeoff the acft impacted a ridge of a canyon at 5,500 ft MSL about 200 ft below the ridge line. The density altitude was 8,900 ft.Jul 20, 1982 · N1378L · DestroyedNTSB CHI82FA259Accident · 1 fatalField investigationFinal reportPiper PA-25-150 · Winamac, INThe plt was practicing aerial application maneuvers, & after making a low pass down the rwy at his private airstrip, theengine quit. The acft collided with 30-FT high power lines located at the end of the strip. A state trooper who arrived at the scene 10 to…Jul 20, 1982 · N6241Z · DestroyedNTSB CHI82DA261Accident · No injuriesFinal reportGrumman G-164B · East Grand Fork, MNThe acft stalled during pull-up from a swath run.Jul 20, 1982 · N8272K · Substantial damageNTSB DEN82DA151Accident · No injuriesFinal reportCessna 150F · Sheridan Lake, COThe pilot reported that he was on a flight to check his fields and crops for possible hail damage. Reportedly, he decided to see how a friend was doing with his wheat harvest and to see if he had received hail damage. The pilot stated that he spotted his…Jul 19, 1982 · N8232S · Substantial damageNTSB CHI82FA255Accident · 2 fatalField investigationFinal reportAeronca 7AC · Pine Valley Tow, WIThe acft was observed flying at a low altitude to a point 1/4 mi NE of the town over a wooded area & began a turn to the left. During the turn the bank continued to increase & then the nose dropped & the acft descended steeply into the trees. The police…Jul 19, 1982 · N85580 · DestroyedNTSB SEA82FA117Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Portland, ORThe pilot, enrolled in a course for a commercial pilot certificate, was scheduled for a solo flight from seattle to bremerton, Washington and return. He departed at about 1300 PDT. At about 1635 PDT, residents near the crash site reported that they saw and…Jul 18, 1982 · N2146Y · DestroyedNTSB MIA82DA159Accident · No injuriesFinal reportCessna 150 · Englewood, FLAs the pilot was climbing through about 700 ft MSL, he observed a person on the beach waving at his aircraft. He thought the person was someone he knew so had made a descending turn to 500 ft to take a better look. When he determined that it was the wrong…Jul 18, 1982 · N6440T · Substantial damageNTSB LAX82DA264Accident · No injuriesFinal reportBell 204 · Delano, CAThe acft was spraying for mediterranean fruit flies with another acft. Entering a "scissors" or opposite direction pattern with the second helicopter spraying in the opposite direction, the plt had to slow down in order to begin his swath at the completion of…Jul 18, 1982 · N910PD · DestroyedNTSB LAX82FUJ42Accident · 1 fatalFinal reportAir Tractor 301 · Yuma, AZThe pilot had completed his last load of the day and was en route back to the airport. According to witnesses, the aircraft entered a nose high attitude, then the nose dropped and the plane entered a spin. It struck the ground before recovering from the spin.…Jul 16, 1982 · N8538S · DestroyedNTSB LAX82FUQ16Accident · Serious injuriesFinal reportGrumman G-164 · Lancaster, CAPlt was spraying very low due to wind conditions. Acft struck a water sprinkler & immediately caught on fire.Jul 15, 1982 · N4589 · DestroyedNTSB MKC82FCQ12Accident · Serious injuriesFinal reportCessna 172 · Medicine Lodge, KSThe acft stalled while the plt was buzzing his grandfather's fishing cabin on a lake.Jul 14, 1982 · N75802 · DestroyedNTSB CHI82DA247Accident · No injuriesFinal reportAero Commander S2R · Graceville, MNThe pilot was on an aerial application flight to a field with power lines alongside. The wind was reported to be from the southeast a 6, gusting 11 KTS. The pilot said that he encountered "dead air" while he was in his fourth porcedure turn. Due to the…Jul 14, 1982 · N3690X · DestroyedNTSB FTW82FPG18Accident · Serious injuriesFinal reportGrumman G-164A · Casa, ARThe aircraft collided with rising terrain during a procedure turn. While spraying a rice field.Jul 12, 1982 · N4657 · DestroyedNTSB CHI82DA245Accident · No injuriesFinal reportHughes 269A · Davison, MIThe student pilot was making a 180 degree pedal turn to the right while hovering. The instructor pilot (ip) stated that after 90 degrees of turn, the rate of turning started to increase and the student applied left pedal to slow the turn. The ip noted that…Jul 12, 1982 · N8902F · Substantial damageNTSB MKC82DA120Accident · No injuriesFinal reportPiper PA-22-160 · Stockton, MOThe aircraft was one of a flight of four, making demonstration flybys at the airport. The pilot stated that he was slow flying, about 80 to 85 ft AGL, when the aircraft started to sink. At that time, he was about 1000 to 1500 ft behind, to the right, and 20…Jul 11, 1982 · N9319D · Substantial damageNTSB FTW82FQG19Accident · 1 fatalFinal reportPiper PA-25 · Edmonson, TXThe pilot had been spraying the field for about 1 hr and was on the last pass. The owner/flagger stated that he had warned the pilot (by using a two way radio) to watch out for a standpipe and radio antenna, and the pilot acknowledged. He reported the plane…Jul 10, 1982 · N4979Y · DestroyedNTSB FTW82DA276Accident · No injuriesFinal reportCessna T188C · Marvell, ARAn aerial application of an oil-based material resulted in a smearing of the windscreen. The pilot landed on a grass strip to clear the windscreen, and during, the landing, the aircraft flipped over. The pilot said when he applied brakes, the left wheel broke…Jul 9, 1982 · N9635J · Substantial damageNTSB SEA82DA104Accident · Minor injuriesFinal reportPiper PA-32-300 · 51 Nm Ese Yakut, AKThe pilot reported that during departure, he proceeded east along the alsek river and along the south side of the alsek glacier while climbing to 6200 ft. he then decided that the intended route was closed due to low clouds and he initiated a turn to reverse…Jul 8, 1982 · N1119X · DestroyedNTSB FTW82DPG17Accident · No injuriesFinal reportRockwell S2R · Blackton, ARThe eng failed during a swath run & the acft struck a rice levee drg the forced landing in an adjacent bean field. After exiting the aircraft and while talking to his flagman the pilot stated the aircraft began to burn around the engine area. The fire spread…Jul 8, 1982 · N1762S · DestroyedNTSB CHI82DA241Accident · Serious injuriesFinal reportCessna 188B · Stevens Point, WIThe pilot stated that when he was pulling up from a swath run, he noticed a left spray nozzle was leaking. At the same time, he noticed a person on the porch of a house that he was flying over. As he looked to see if the house and person would be avoided, the…Jul 8, 1982 · N9284G · DestroyedNTSB ATL82DA190Accident · No injuriesFinal reportCessna A188B · Lula, MSDuring a swath run under electrical transmission lines, the vertical stabilizer and rudder contacted the wires and separated from the aircraft. The pilot attempted to return to the airport, but was unable to control the aircraft. He then attempted an…Jul 7, 1982 · N731EG · Substantial damageNTSB ATL82DA189Accident · No injuriesFinal reportBalloon Works Firefly 7 · Greenville, SCThe ballon with three persons on board dropped too low in a target hitting contest. The pilot then decided he could not climb above wires so he vented the Balloon in an attempt to land short. The bag contacted the wires and burned. The pilot stated he…Jul 5, 1982 · N2236H · Substantial damageNTSB MKC82DA116Accident · No injuriesFinal reportGrumman G164A · Ericson, NEThe aircraft was flown from the loading area to the field intended for treatment. Upon arrival, the pilot reduced power and entered an observation fly-by. When the aircraft started to settle the pilot's application of power failed to arrest the descent. The…Jul 4, 1982 · N48534 · Substantial damageNTSB CHI82DA238Accident · No injuriesFinal reportPiper PA-28-200R · Black River Fal, WIThe pilot stated that during flight, he encountered an engine problem and started to land on a road, but then the engine began to run better, so he continued to his destination. After landing, he discovered that a portion of the vertical stabilizer (about 18…Jul 4, 1982 · N56339 · Substantial damageNTSB FTW82IA268Incident · No injuriesIncident investigationFinal reportBell 47G2A1 · Near Mertzon, TXWhile the aircraft was being hovered low and slow around a water trough, directional control was lost. The pilot autorotated to the ground and on touchdown the right skid buckled and the tailrotor gearbox separated when it struck an ant hill. The pilot…Jul 3, 1982 · N73983 · Minor damageNTSB FTW82DA258Accident · Serious injuriesFinal reportGrumman G-164B · Swifton, ARThe pilot was engaged in an aerial application flight over a rice field with multiple high tension wires. At the beginning of a swath run, the aircraft struck power lines and crashed. The pilot had no recollection of the accident.Jul 2, 1982 · N9869 · Destroyed