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 LAX83LA180Accident · No injuriesLimited investigationFinal reportHughes 269A · Lindsay, CAThe plt was rounding up cattle for a bbq. One of the steer in the herd charged the helicopter & struck its skid. The main rotor deflected & severed the tail boom. The plt lost control of the acft which impacted the ground & rolled over.Apr 17, 1983 · N8775F · Substantial damageNTSB MIA83LA125Accident · No injuriesLimited investigationFinal reportHughes 300C · Vero Beach, FLThe helicopter landed hard during a practice autorotation.Apr 16, 1983 · N8602F · Substantial damageNTSB LAX83LA195Accident · Serious injuriesLimited investigationFinal reportPiper PA18-150 · Likely, CAThe plt reported that he was on a flt to survey some irrigation properties. He reported that he was at aprx 200 ft AGL & had became preoccupied when he initiated a right turn & exceeded the bank limitation for the speed & weight of the acft. The acft stalled…Apr 16, 1983 · N3895Z · Substantial damageNTSB ATL83LA158Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Lexington, NCThe aircraft collided with a ditch during a forced landing after power loss while on an aerial application flight. The engine failed because of loss of #2 cylinder. The cylinder head cracked and ruptured two oil lines. With the windshield covered with oil and…Apr 11, 1983 · N9782 · Substantial damageNTSB LAX83LA186Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Guadalupe, CAAfter practicing a series of power-on departure stalls at 3500 feet, the plt climbed to 6500 feet and practiced several power-off approach/landing stalls. At about 3000 feet the engine sputtered and quit. The plt was unable to restore power and made an…Apr 8, 1983 · N5542H · Substantial damageNTSB LAX83LA184Accident · Minor injuriesLimited investigationFinal reportBell 47G-3B-1 · Delano, CAThe acft collided with a power line and trees while applying pesticide to an orchard. The pilot was flying into the rising sun and failed to see the power line which serviced an agricultural deep well.Apr 8, 1983 · N1397X · Substantial damageNTSB FTW83LA180Accident · No injuriesLimited investigationFinal reportCessna 150 · Donna, TXAccording to the student plt, he was practicing a simulated emergency landing & had aborted the approach when the acft banked to the left, went out of control & crashed. An investigation revealed that the acft hit a palm tree, aprx 60 ft tall, then came to…Apr 7, 1983 · N6648G · Substantial damageNTSB SEA83LA078Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Near Sisters, ORAccording to the plt, he began climbing after making a pass over a frozen lake & Near a youth camp. He reported that the acft entered a stall, then began to spin to the right at aprx 1000 ft AGL. He initiated corrective action, but the main gear hit the lake…Apr 6, 1983 · N83096 · Substantial damageNTSB ANC83FA066Accident · Serious injuriesField investigationFinal reportBell 206B · Stony River, AKThe plt was on an external load operation with a 100 ft long line. The long line had 4 remote hooks, of which, 3 had cable bags attached. While waiting for the 4th bag to be filled, he decided to land in an open area. He set the external load down & laid the…Apr 6, 1983 · N376KA · Substantial damageNTSB ATL83LA152Accident · No injuriesLimited investigationFinal reportCessna 152 · Verbena, ALThe acft collided with a wire cable during a simulated emergency landing to an open field off the arpt. The pilot said he was flying locally and saw a field that looked large enough to land in so he reduced power to idle and was making a simulated emergency…Apr 4, 1983 · N757HT · Substantial damageNTSB LAX83FJA06Accident · 1 fatalFinal reportGrumman American AA-5B · Waimanalo, Oahu, HIThe acft was observed maneuvering over the water at low altitude prior to impact with the water. A surviving pax stated that he & the plt had a big party the day before the flt & they both had hangovers the following morning. He further stated that they had a…Apr 3, 1983 · N28808 · Substantial damageNTSB SEA83FA072Accident · 2 fatalField investigationFinal reportGlasair SH2 · Camano Island, WAThe aircraft was observed in a flat left hand spin which continued to ground impact. The aircraft entered the spin from a vertical maneuver at about 2000 feet AGL. The pilot had helped build this aircraft. He was characterized as a conservative pilot and had…Apr 2, 1983 · N94RB · DestroyedNTSB LAX83LA234Accident · No injuriesLimited investigationFinal reportLet L-13 · California City, CADuring flt, the glider sustained in-flt structural damage while maneuvering at an altitude of aprx 17,500 ft MSL in the vicinity of California City, CA. During a preliminary verbal statement to an FAA inspector, the plt stated that he had done a couple of…Apr 2, 1983 · N99965 · Substantial damageNTSB LAX83LA177Accident · Serious injuriesLimited investigationFinal reportCessna T188C · Soloman, AZThe acft experienced a partial power loss and made an emergency landing in the field it was spraying. The acft had only made one spraying pass since being serviced with a full load of fuel and 140 gallons of chemical before the power loss occurred. As the…Apr 2, 1983 · N2074J · Substantial damageNTSB MIA83FLA01Accident · Serious injuriesFinal reportCessna T188C · St. Augustine, FLThe plt reported that he had just completed east to west swath runs & turned toward the sun to trim the east side of the field. Also, he reported that his windshield was covered with spray mist which restricted his visibility. Subsequently, he did not see how…Apr 1, 1983 · N2541J · Substantial damageNTSB NYC83FU001Accident · 1 fatalFinal reportPterodactyl Ascender II · Lehighton, PASeveral witnesses observed the ultralight vehicle takeoff & climb in a circular pattern to an alt of about 1500 ft. one witness stated that just prior to the accident sequence, the ultralight was turning with a steep angle of bank. At about that time, the…Mar 31, 1983 · UNREG · DestroyedNTSB ANC83LA061Accident · Minor injuriesLimited investigationFinal reportPiper PA-18A · W. Clam Gulch, AKThe acft stalled and crashed during an approach to land in a wilderness area. According to the plt he was preoccupied with landing near a wolverine he wanted to shoot. His approach was too high so he closed the throttle put down full flaps and started a turn.…Mar 30, 1983 · N8081C · Substantial damageNTSB MKC83LA082Accident · Minor injuriesLimited investigationFinal reportPiper PA-25 · Anthony, KSThe aircraft crashed during a forced landing after engine failure. It was determined during inspection after the accident that the fuel remaining in the aircraft was mostly water. The pilot during preflight had drained the fuel sumps and did not find any…Mar 28, 1983 · N8547L · Substantial damageNTSB SEA83LA086Accident · No injuriesLimited investigationFinal reportEagle DW-1 · Waverly, WAThe pilot was on an aerial application mission spraying dry fertilizer on an upslope when he encountered a downdraft. Heturned downslope as the acft settled but was unable to prevent ground contact. The acft contacted the soft terrain and nosed over to an…Mar 27, 1983 · N8809A · Substantial damageNTSB LAX83LA163Accident · No injuriesLimited investigationFinal reportCessna 188 · Stanfield, AZThe rated commercial plt was on a solo instructional flt while in training for aerial application. He stated that before the accident, he had visually checked the fuel load & thought there was sufficient fuel for the flt. He took off, sprayed a load of water,…Mar 26, 1983 · N9893V · Substantial damageNTSB LAX83FUJ12Accident · Serious injuriesFinal reportCessna 182B · Benson, AZThe acft collided with a tree following a power loss during a low pass over a remote open area. The pilot and his wife were on a local pleasure flt when he decided to make a low pass over an area. During a 2nd pass over the same area when he applied the power…Mar 26, 1983 · N7293E · Substantial damageNTSB LAX83LA159Accident · No injuriesLimited investigationFinal reportHughes 369D · Rancho Bernardo, CAAccording to the plt, he was about 10 ft AGL in a hover, with a left quartering tailwind at 5, gusting 10 KTS, when he attempted a left pedal turn. He said the helicopter began to turn to the right & additional left pedal application had no effect. He rolled…Mar 25, 1983 · N9589F · Substantial damageNTSB ATL83FA144Accident · 1 fatalField investigationFinal reportKit Built Scorpion 133 · Centerville, TNThe rotorcraft crashed in a steeply descending turn shortly after takeoff from about 100 feet AGL. No mechanical malfunction was found during, the on-site wreckage examination which would have resulted in the abrupt steep left bank and ground impact. The…Mar 25, 1983 · N506R · DestroyedNTSB LAX83FJA05Accident · 1 fatalFinal reportMurrayair MA1B · Nr Lihue Arpt, HIThe acft collided with a tree during a turn-around while engaged in aerial application operations. The pilot had made a few runs over the same field until he exhausted his load. After landing and reloading he returned to the area to finish the job and on the…Mar 24, 1983 · N101MA · DestroyedNTSB DEN83LA082Accident · No injuriesLimited investigationFinal reportAmerican AA-5B · Heber City, UTAfter taking off at Heber City, UT, the plt turned to a 090 deg heading & began a climb with full throttle, mixture full rich, 80 to 90 KIAS & aprx 500 fpm rate of climb. At aprx 6500 ft MSL, he altered the course to 110 to 115 deg to provide better terrain…Mar 21, 1983 · N4520V · Substantial damageNTSB MIA83FA096Accident · 1 fatalField investigationFinal reportPiper J3C-65 · Fort Lauderdale, FLThe pilot's father and fiancee were acting as ground crew for the banner pickup. The pilot's father, who is a senior captain for pan am, stated that the acfr flew in a very erratic manner after the banner towing hook was thrown out. The acft was banking and…Mar 20, 1983 · N3618K · DestroyedNTSB LAX83FA150Accident · 1 fatalField investigationFinal reportCessna 150M · Dos Palos, CAThe non-rated plt & a friend (also non-rated) took the acft without permission of the owner. They took off at night & made repeated passes over the city of Dos Palos, CA. After about 15 to 20 min, the acft was flown to the vicinity of a home belonging to the…Mar 20, 1983 · N2832V · DestroyedNTSB LAX83FA396Accident · 1 fatalField investigationFinal reportCessna 182 · Littlefield, AZThe passenger stated the flt was behind schedule, and an airport thought to be tuweep was spotted. They descended to 150-200 ft to read a sign and when the plt tried to climb in a left turn he collided with rising terrain. The accident location is about 8…Mar 19, 1983 · N2646G · DestroyedNTSB NYC83FA078Accident · 2 fatalField investigationFinal reportMitsubishi MU-2B-60 · North Adams, MAAt 1145 the plt reported VFR conditions & requested radar vectors to the arpt. He was issued a cruise clearance of 5,000 ft & given a heading. 18 mi from the arpt he reported visual contact with the ground. At 1151 he was asked if he was familiar with the…Mar 18, 1983 · N473MA · DestroyedNTSB MIA83LA087Accident · No injuriesLimited investigationFinal reportHughes 269A · St. Petersburg, FLThe helicopter contacted the ground with a skid during a hover and ended up in a dynamic roll over. This was a dual instructional flt and the student was at the controls in a hover at the runways end awaiting twr instructions when the right skid became stuck…Mar 18, 1983 · N9020M · Substantial damageNTSB LAX83LA137Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12D · San Manuel, AZAccording to the pilot, she was flying above a canyon and noticed a loss of altitude. The best rate of climb airspeed, 60 mph, failed to produce any climb, so the pilot began to circle to gain altitude. 'Before completion of the first circle the plane lost…Mar 18, 1983 · N43958 · Substantial damageNTSB SEA83FA062Accident · 1 fatalField investigationFinal reportCessna 150J · Glenns Ferry, IDThe acft collided with wires and crashed during a low pass while it was being delivered to a repair station. The pilot was flying low to keep pace with his wife who was following in a car to transport the pilot after landing. Witnesses observed the acft…Mar 13, 1983 · N60461 · DestroyedNTSB MIA83LA091Accident · No injuriesLimited investigationFinal reportGray J-3 Trainer · Lakeland, FLWhile maneuvering to enter the ultralight landing area on the arpt during an eaa fly-in, the elevator became jammed in the down position when a bolt in the linkage became jammed against the wheel axle which had been bent in a previous accident. The plt was…Mar 13, 1983 · N1391P · Substantial damageNTSB FTW83LA151Accident · No injuriesLimited investigationFinal reportCessna 182RG · Sheffield, TXAfter takeoff from a ranch strip, the eng lost power during a turn, then started again after the plt leveled the wings. He maneuver over the strip & the eng cut out two more times. The acft descend into grassy terrain, but hit a rock & damaged the nose gear.…Mar 13, 1983 · N1739R · Substantial damageNTSB ATL83FKJ03Accident · 1 fatalFinal reportEaa Biplane P-2 · Southside, ALThe pilot was performing aerobatics over the airport at 400-500 feet AGL. On the last pass, he had completed one roll and was inverted in what appeared to be a second roll when the aircraft dove at the ground in a near vertical position. The aircraft engine…Mar 13, 1983 · N20KJ · DestroyedNTSB DEN83LA080Accident · No injuriesLimited investigationFinal reportHelio H-295 · Baggs, WYThe plt reported that he was hauling hay for his stranded horse. The plt was delivering hay, 5 bales per flt & dropping 1 bale at a time. On the 19th drop, after 4 hrs & 15 min of flt time since refueling, the eng lost power. During a forced landing in deep…Mar 12, 1983 · N533LD · Substantial damageNTSB DEN83FTE07Accident · 1 fatalFinal reportHomebuilt Rotorcraft Z6 · Bennett, COThe Homebuilt gyrocopter crashed on level terrain after rudder and rotor blade separation in flt. The rudder was found about 100 yards from the main wreckage. It had been struck by one of the rotor blades and had separated in flt. The separated rotor blade…Mar 12, 1983 · N23104 · Substantial damageNTSB LAX83LA135Accident · No injuriesLimited investigationFinal reportVans RV-3A · Bakersfield, CAAccording to the plt, he took off, climbed to 1500 ft & set the engine controls at cruise power (2500 RPM at 160 mph). He stated that he then turned back toward the arpt & made a low pass without changing the power setting. As he started to climb from the low…Mar 11, 1983 · N630CB · Substantial damageNTSB DEN83FA077Accident · 2 fatalField investigationFinal reportChampion 7EC · Wright, WYThe acft spun into the ground from low alt while hunting foxes. The acft had previously landed in a wheat field and the occupants talked with a friend about seeing foxes nearby. They were going to fly around some more and have a look. A short time later the…Mar 11, 1983 · N7527E · DestroyedNTSB MKC83LA075Accident · No injuriesLimited investigationFinal reportCessna 150F · Ollie, IAThe student reported that the eng lost aprx 500 RPM while he was practicing turns & stalls at an altitude of aprx 3500 ft MSL. Reportedly, the situation became worse & he was unable to maintain altitude. He applied carburetor heat, but it did not help.…Mar 7, 1983 · N8803G · Substantial damageNTSB LAX83FVG09Accident · 1 fatalFinal reportBeech V35B · Copperopolis, CAThe acft was observed taking off to the south from the plt's private strip. The acft made a 180 deg turn & flew over theplt's residence near the runway. A momentary increase in eng RPM was heard. The acft then made another 180 deg turn & flew down the runway…Mar 7, 1983 · N4755M · DestroyedNTSB LAX83LA128Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Williams Afb, AZWhile on a spray run, the eng lost power. Subsequently, the acft was damaged during a forced landing.Mar 6, 1983 · N4529 · Substantial damageNTSB ATL83FA127Accident · 1 fatalField investigationFinal reportDouglas B-26C · Hubbards Fork, KYThe plt & acft had been fighting forest fires earlier in the day. A late developing fire necessitated another dispatch. The acft arrived on scene & checked in with the lead acft circling overhead coordinating the fire fighting efforts. The tanker made 2 runs…Mar 5, 1983 · N4060A · DestroyedNTSB FTW83LA135Accident · Minor injuriesLimited investigationFinal reportChampion 7ECA · Muskogee, OKThe passenger was in the back seat with a 35 mm camera, a pocket camera, a pair of binoculars in a case and a windbreaker. While flying at dusk, they flew by a herd of deer, but the passenger did not get a photograph. Reportedly, the plt made a 180 deg turn &…Mar 1, 1983 · N6386N · 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 LAX83FA121Accident · 2 fatalField investigationFinal reportHughes 269A · Phoenix, AZThe purpose of flt was to take aerial photogrphs of a business agency near the crash site. The helicopter was observed orbiting a parking lot in a right hand pattern at 150-300 ft AGL. After 2-3 orbits it appeared to hover before pitching nose down to a near…Feb 28, 1983 · N42426 · DestroyedNTSB LAX83FA120Accident · 1 fatalField investigationFinal reportAyres S2R-R3S · Kerman, CAThe acft returning from a spray mission collided with a tree and crashed near the pilots home. The pilot made a low passover his house to let his wife know he had returned. He made a spray run over his own vineyard and collided with a largetree while pulling…Feb 27, 1983 · N40160 · DestroyedNTSB ANC83LA050Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Northway, AKThe plt reported that while he was flying in a canyon, up cub creek, he encountered unanticipated turbulence. He decided to make a 180 deg turn & leave the canyon. However, while making a left turn, the right wing of the acft struck a tree. Subsequently, the…Feb 27, 1983 · N4876A · Substantial damageNTSB FTW83LA130Accident · No injuriesLimited investigationFinal reportCessna 182R · Flatonia, TXThe acft collided with a power line while the plt was making a low apch over a private strip. The top 3 inches of the vertical stabilizer was cut off. The plt did not realize the acft was damaged & landed without further incident.Feb 26, 1983 · N5515N · Substantial damageNTSB ATL83FA122Accident · No injuriesField investigationFinal reportBell 47G-2 · Hardeeville, SCThe plt stated that he noticed a peculiar pedal reaction during a turn-around; however, he reported that this may have been caused by the wind which was gusting to 15 KTS. Shortly after completing the turn-around, he experienced a complete loss of tail rotor…Feb 26, 1983 · N5191B · Substantial damage