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 MIA86FA199Accident · Serious injuriesField investigationFinal reportRobinson R22 · Islamorada, FLWitnesses reported seeing the helicopter flying at approximately 8 to 10 feet off the water. The helicopter entered a left turn and as the turn progressed the helicopter descended striking the water with a skid and cartwheeling.Jul 4, 1986 · N2385X · DestroyedNTSB DEN86LA188Accident · No injuriesLimited investigationFinal reportPiper J-3 · Ashland, MTPlt did not possess a plt certificate or medical certificate. The plt stated that he fueled the acft with the 'last gas in the storage tank.' The plt preflighted the acft and took off. Shortly after takeoff the engine lost power. The plt executed a landing in…Jul 4, 1986 · N40660 · Substantial damageNTSB CHI86FEX09Accident · Serious injuriesFinal reportCessna 150F · Marion, INThe plt rprtd that while circling around farm fields, he entered a turn & was looking behind the acft when it entered a power-on stall, then began to spin. Rprtdly, the acft was in a nose high attitude when it stalled. The plt stopped the rotation & was…Jul 4, 1986 · N8602G · DestroyedNTSB CHI86FEM10Accident · Minor injuriesFinal reportPiper PA-25-235 · Ionia, MIDuring initial banner pick-up of a banner towing operation the tow cable fouled the rudder control mechanism. The rudder was jammed and the banner release mechanism failed to operate. The aircraft impacted the ground left wing first and was substantially…Jul 4, 1986 · N4811Y · Substantial damageNTSB ANC86LA100Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Sparrovahn, AKThe plt reported a total loss of pwr occurred while maneuvering over an area to observe the terrain. A forced landing was made on a gravel bar during which the acft nosed over. In his recommendation on how the accident could have been prevented, the plt…Jul 3, 1986 · N5472H · Substantial damageNTSB DEN86LA182Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Williston, NDDuring the telephone interview, the plt stated the eng of his crop duster quit due to fuel exhaustion and a forced landing was made.Jul 2, 1986 · N7131Z · Substantial damageNTSB SEA86LA161Accident · No injuriesLimited investigationFinal reportCessna T-188-C · Othello, WAAn engine failure for unknown reasons occurred during an aerial application maneuver. A forced landing was accomplished onto very rough, rocky terrain where the aircraft was destroyed during the landing sequence.Jul 1, 1986 · N9574J · DestroyedNTSB SEA86LA159Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-260 · Rexburg, IDDuring an aerial application turn the aircraft encountered a severe downdraft. Although the pilot lowered the nose of the aircraft, leveled the wings, added full power and dumped his chemical load, he was unable to climb. The aircraft then struck the ground…Jul 1, 1986 · N9621P · DestroyedNTSB SEA86LA158Accident · 1 fatalLimited investigationFinal reportAyres S2RT34 · Jordan Valley, ORWitnesses observed at acft make a 2-5 foot pass over water going north, a 180 degree turn and a 2 foot AGL run to south. The acfts left main landing gear touched water bouncing the right wing on water. Acft pitched up, rolled inverted and crashed on south…Jun 30, 1986 · N4013D · DestroyedNTSB NYC86FHA03Accident · No injuriesFinal reportThomas Pitts S-1T · Avoca, PADuring a ribbon cutting ceremony at the wilkes-barre/scranton air show, the acft had a temporary engine failure while inverted 20 feet above the terrain. The acft impacted on the rwy, slid 500 feet inverted, turned over and stopped upright.Jun 28, 1986 · N83TJ · Substantial damageNTSB SEA86LA154Accident · 1 fatalLimited investigationFinal reportCessna A188B · Boise, IDThe purpose of the flight was to spray thirty gallons of rinse water to clear the spray tanks of chemical. While maneuvering the acft struck power lines and then struck the ground. The acft slid for about 20 feet and then nosed over inverted.Jun 27, 1986 · N9779G · DestroyedNTSB FTW86LRG27Accident · No injuriesFinal reportAyres S2R-600 · Tivoli, TXOn June 27,1987 at approximately 1700 CDT, an Ayres S2R-600 impacted the terrain approximately 5 miles east of Tivoli, TX while conducting agriculture spraying operations. The right wing of the aircraft contacted the ground causing the aircraft to cartwheel…Jun 27, 1986 · N8905Q · Substantial damageNTSB DEN86LA176Accident · No injuriesLimited investigationFinal reportCessna T188 · Kimball, SDAccording to the plt, the acft he was piloting encountered unfavorable winds during the aerial application maneuver and stalled. The plt indicated that during the touchdown, the main gear collapsed and the acft was substantially damaged.Jun 27, 1986 · N2507J · Substantial damageNTSB SEA86LA153Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Pullman, WAAfter takeoff during a 180 degree turn the aircraft developed a rapid rate of sink which the pilot was unable to arrest. While attempting to dump 140 pounds of water, the aircraft struck power lines and then struck the ground inverted. The aircraft was then…Jun 26, 1986 · N6490Z · DestroyedNTSB MKC86LA134Accident · Minor injuriesLimited investigationFinal reportGrumman G-164B · Wellman, IAThe PIC stated that during the last 3rd of his procedure turnaround the acft descended to just below the powerlines at the edge of the field he was spraying. The acft struck the powerlines with the main landing gear which nosed the acft over. Full power was…Jun 26, 1986 · N48532 · Substantial damageNTSB MIA86FLT01Accident · Serious injuriesFinal reportAmateur Built Eenie TWO · Waynesboro, MSThe acft nosed over during a forced landing after a power loss. According to witnesses the acft made a climbing turn after takeoff followed by a low pass near the witnesses. The acft then disappeared behind some trees and when it reappeared the engine was not…Jun 26, 1986 · N6009 · Substantial damageNTSB DEN86LA174Accident · No injuriesLimited investigationFinal reportSchweizer G-164A · La Moure, NDAccording to the plt, during a swath run, the acft he was piloting encountered 'bad air' and descended until the wings and wheels contacted the crop of grain he was spraying. The plt stated the acft stalled and contacted the ground.Jun 24, 1986 · N6838Q · Substantial damageNTSB FTW86LRD20Accident · Serious injuriesFinal reportPiper PA-25-235 · Marksville, LAThe pilot delayed in his pullup from a spray swath run until there was insufficient time and distance to clear the line of trees at the end of the field. Airspeed decreased rapidly during the pullup. Tree impact occurred and the pilot was unable to recover…Jun 23, 1986 · N7321Z · Substantial damageNTSB FTW86FPA23Accident · 1 fatalFinal reportCessna A188B · Malone, TXThe acft crashed before beginning a spraying operation after making a low pass over the field to alert a workman. According to one witness, a young bicyclist, the acft was turning around and began 'flopping' before it disappeared behind a hill. The field…Jun 23, 1986 · N9737J · DestroyedNTSB CHI86FET02Accident · 1 fatalFinal reportPiper PA-28-180 · Syracuse, INThe acft crashed into a lake while making a farewell low pass at friends on the lakeshore. He came over the lake toward his friends at such a low alt that he had to pull up to get over the trees. He commenced a steep rt turn which progressed into a descent…Jun 23, 1986 · N8226W · DestroyedNTSB NYC86FNC04Accident · 1 fatalFinal reportRolladen-Schneider LS-4A · Rochester, VTThe pilot was participating in a x-country soaring race. Aprox 15 miles from destination and for unknown reasons, the pilot experienced in flight collision with terrain. There was no evidence of pre-impact malfunction or failure. The pilot was certificated…Jun 22, 1986 · N430RH · Substantial damageNTSB DEN86LA171Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Cope, COThe plt reports that the eng quit during a pull-up at the end of a swath run. A forced landing in a field straight ahead was attempted but the field had been cultivated recently and was soft. After a short ground roll the gear dug in and the acft nosed over.…Jun 22, 1986 · N7723Z · Substantial damageNTSB LAX86FA260Accident · 2 fatalField investigationFinal reportCessna 152 · Marysville, CAAt 0203 PDT, there was an electrical power outage when a Cessna 152, N4873H, collided with a power line that crossed the feather river near Marysville, CA. The acdnt occurred as a student plt was flying over the river at low alt with a passenger aboard at…Jun 21, 1986 · N4873H · DestroyedNTSB ATL86FA178Accident · 2 fatalField investigationFinal reportCessna 120 · Marlton, NJAbout 10 min after takeoff, the acft collided with trees & crashed while the plts were performing aerobatic maneuvers. According to witnesses, aerobatics were being performed at an about 500 ft AGL. They rprtd that the plts had made an overhead maneuver…Jun 21, 1986 · N89789 · DestroyedNTSB DEN86LA167Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · South Heart, NDAccording to the plt, during a swath run (agricultural spraying), the eng quit & a forced landing was accomplished. During the interview, the plt stated the eng quit due to fuel exhaustion.Jun 20, 1986 · N8768L · Substantial damageNTSB CHI86FEM09Accident · 2 fatalFinal reportCessna 172I · Nunica, MIThe acft was seen flying over the water at an alt of aprx 150-200 ft AGL prior to hitting wires. The acft was flying into the sun at the time of the wire strike.Jun 20, 1986 · N46074 · DestroyedNTSB MKC86FCJ02Accident · 1 fatalFinal reportCessna A188B · Bridgeport, NEDuring an agricultural spray run, the aircraft collided with a utility pole, leaving part of the spary boom wrapped around the pole, and pieces of flap, wing, and fuel bladder nearby. The aircraft then impacted the ground about 1000 ft from the pole & was…Jun 19, 1986 · N84729 · DestroyedNTSB MIA86FA185Accident · 1 fatalField investigationFinal reportAyres S2R-1820 · Dundee, MSThe ag acft was flying low over a water covered muddy rice field when the eng stopped running. The plt then jettisoned the load of fertilizer & entered a steep right turn. Subsequently, the aircraft struck the ground on the right wing & nose, then…Jun 18, 1986 · N4023P · DestroyedNTSB DEN86LA164Accident · No injuriesLimited investigationFinal reportPiper PA-25-260 · Toston, MTThe plt reports that he took off from an ag strip about a mile from the fld being treated and was making a turn-around after his second swath run when the acft began to settle. He dumped his chem but the acft continued to settle and impacted the ground. The…Jun 18, 1986 · N82539 · Substantial damageNTSB DEN86FA165Accident · 1 fatalField investigationFinal reportBeech A36 · Mosquero, NMThe acft was observed flying at low altitude when it pitched up at a steep angle, climbed about 400 ft, rolled off on left wing, descended into the ground, exploded and burned. Post accident exam revealed the landing gear was retracted but the flaps were…Jun 18, 1986 · N333RS · DestroyedNTSB DCA86AA028Accident · 25 fatalFinal reportde Havilland DHC-6-300 · Grand Canyon, AZAt about 0933 MST, Dehavilland DHC-6, N76GC, (owned & operated by Canyon airlines) & bell 206B, N6TC, (operated by heliteck) collided while on sightseeing flts over the Grand Canyon national park. After colliding in flt, both acft crashed & burned in the…Jun 18, 1986 · N76GC · 2 aircraft · DestroyedNTSB FTW86LA111Accident · Serious injuriesLimited investigationFinal reportAyres S-2R · Liverpool, TXThe pilot was involved in a aerial application flt when the acft stalled during a turn. The pilot stated he had too much weight to execute the turn at the airspeed selected. The airspeed was aprx 10 KTS above stall speed at the time of the downwind turn. He…Jun 17, 1986 · N8935Q · Substantial damageNTSB CHI86FER11Accident · Serious injuriesFinal reportBell 47G-5 · Brooten, MNAccording to the pilot, the helicopter collective control failed to respond to a climb input to level off after a descent for an agricultural swath run. Fire and impact damage to the helicopter was extensive, however one broken rod end in the collective…Jun 17, 1986 · N8122J · DestroyedNTSB ANC86FA078Accident · 1 fatalField investigationFinal reportCessna 207A · Saint Marys, AKThe pilot stalled the airplane while making a steep turn to avoid high voltage power lines. The airplane caught fire on impact and the air taxi pilot subsequently died of extensive thermal injuries. The plt was flying in formation with another acft at low…Jun 17, 1986 · N9699M · DestroyedNTSB MIA86MA182Accident · 2 fatalMajor investigationFinal reportHughes 369HE · Jacksonville, FLA LCL tv stn had hired the oper to provide a helicopter for use in broadcasting an airborne traffic show. The plt took off with a rprtr & a camera man aboard. Drg a live traffic rprt, the acft was hdg eastbound at slow speed ovr a downtownarea at aprx 400 ft…Jun 16, 1986 · N9045F · DestroyedNTSB LAX86FUG03Accident · 1 fatalFinal reportBensen-Jansen B-8M · Adelanto, CAThe acft collided with power lines crossing the airstrip at midfield and crashed on the rwy. A witness stated that the plt had been briefed on the pwr lines prior to the flt.Jun 16, 1986 · N2522 · DestroyedNTSB MIA86FA181Accident · 1 fatalField investigationFinal reportRobinson R22 HP · Lk Buena Vista, FLMotorists obsd the helicopter flying low ovr & along an interstate hiway. In the vicinity of a hiway rest area, the helicopter maneuvered to the side of the hiway, then flew back ovr the median. Two witnesses said it came to a hover, then started to continue…Jun 14, 1986 · N8400C · DestroyedNTSB CHI86FEM07Accident · No injuriesFinal reportCessna 188B · Bay City, MIDuring an ag spray operation, the plt flew over the area before starting his swath runs. On his first run, he flew over wires at the end of the field. On the return swath run, he attempted to fly under the wires. While doing so, the acft struck a newly…Jun 14, 1986 · N53140 · DestroyedNTSB SEA86LA146Accident · No injuriesLimited investigationFinal reportPiper PA-36-300 · Moore, IDDuring an aerial application turn a rapid rate of descent developed. The pilot released the chemical load at about 100 feet AGL and the aircraft continued to descend to the ground even though the pilot leveled the wings and initially lowered the nose. The…Jun 13, 1986 · N3742E · DestroyedNTSB CHI86LA153Accident · No injuriesLimited investigationFinal reportPiper PA-36-375 · Breckenridge, MNAircraft collided with a truck while engaged in aerial application work. Pilot was unable to maintain control and the aircraft collided with terrain after an uncontrolled descent. Investigation revealed that the aileron had separated due to the collision.Jun 13, 1986 · N6184A · Substantial damageNTSB SEA86FA144Accident · 2 fatalField investigationFinal reportSanders Starduster TWO · Mead, WAA witness reported seeing the aircraft perform a series of loop maneuvers. At the top of the last loop, the acft rolled upright then rolled into a near vertical right spin which continued to ground impact. The pilot had no history ofspin recovery practice in…Jun 12, 1986 · N118JB · DestroyedNTSB DEN86LA162Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Wessington, SDAccording to the plt, during maneuvering on a swath run, the acft he was piloting encountered a downdraft, forcing the acft down until contact with the ground.Jun 12, 1986 · N751Y · Substantial damageNTSB MIA86LA175Accident · Minor injuriesLimited investigationFinal reportAyres S2R · Graceville, FLA witness stated that the acft had just completed a swath run & was pulling up to the left when the left wing tip struck the ground & cartwheeled the acft. The plt stated that the acft went into a 'high-speed' stall & cartwheeled approx four times & that he…Jun 11, 1986 · N5630X · 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 NYC86LA150Accident · Serious injuriesLimited investigationFinal reportAerosport Scamp · Columbia, PAThe aircraft crashed shortly after takeoff due to insufficient airspeed and altitude gain.Jun 10, 1986 · N1031M · Substantial damageNTSB FTW86FPJ08Accident · Serious injuriesFinal reportAir Tractor AT-301 · Blackwell, OKThe acft crashed after a turn while spraying a field. The acft caught fire after the impact but the plt escaped.Jun 7, 1986 · N23539 · DestroyedNTSB DEN86LA157Accident · No injuriesLimited investigationFinal reportPiper PA-25 · Williston, NDPlt stated that he was unfamiliar with the geographical area on this flt. He also stated, 'I was paying attention to the pwr lines and road and did not realize the hill out front was as high as it was...I attempted to turn back out, but with downwind it blew…Jun 7, 1986 · N6190Z · Substantial damageNTSB ATL86LA166Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Magnolia Spring, ALDuring a spray run the plt attempted to climb over a tall tree, the acft failed to clear the tree which was contacted with the right wing. The acft then crash landed in a field. The acft was observed to stagger during several turns earlier in the operation.…Jun 7, 1986 · N9105R · Substantial damageNTSB LAX86LA242Accident · 1 fatalLimited investigationFinal reportHiller UH-12E · Thermal, CAThe helicopter collided with terrain during a maneuvering turn while applying a pesticide to a cultivated field. The acft was seen on the pass just prior to the accident and the acft appeared to be lower than usual. The acft was destroyed by post-impact fire.Jun 6, 1986 · N8503W · DestroyedNTSB FTW86FRG25Accident · 1 fatalFinal reportAero Commander S2R · La Feria, TXThe acft contacted guy wires which supported a 1000 ft high television tower. Impact with the wires occurred at an alt of aprx 300 ft.Jun 5, 1986 · N8813Q · Destroyed