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 ATL87LA167Accident · No injuriesLimited investigationFinal reportCessna 172M · Sylva, NCThe CFI instructed his low-time beginning student to make a normal appch to the rwy, and fly down the rwy at about 10 ft above the rwy surface while maintaining rwy hdg. The CFI stated that the purpose of the maneuver was '...to help the student improve his…Jun 12, 1987 · N9355H · Substantial damageNTSB MIA87LA177Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Ruleville, MSWhile maneuvering the acft for a swath run after takeoff the plt stated that it was slow to climb. He then lowered the nose to increase airspeed, & realizing that the acft would not clear trees located ahead of the flt, elected to land in a field. Upon…Jun 10, 1987 · N585Y · Substantial damageNTSB ATL87DKG04Accident · No injuriesFinal reportBell TH-13T · Melvin, ALThe plt rprtd that after lndg to reload with herbicide, he got out of the helicopter to check the fuel in the tanks. After a visual inspn, he believed he had 'an adequate amount' of fuel to fly about 1/4 mi to the area to be sprayed, apply the chemical &…Jun 10, 1987 · N205PS · Substantial damageNTSB FTW87DRA03Accident · No injuriesFinal reportGrumman G-164B · Egypt, TXAcft experienced a power loss drng an aerial app maneuver. During the ensuing emerg lndg, the left wing struck high weeds on the shoulder of a road, veered left into a ditch, and flipped over. Investigation revealed no. 7 cylinder had a pre-existing crack in…Jun 8, 1987 · N6667Q · Substantial damageNTSB ATL87FA160Accident · 1 fatalField investigationFinal reportGlobe Globe GC-1A · Pleasant View, TNUpon returning from a short local area flight the aircraft was observed as it buzzed the owners private airstrip, where the passenger waved to his family. The plt pulled up sharply and made another low pass. This pullup was straight ahead. The climb peaked…Jun 8, 1987 · N80532 · DestroyedNTSB MIA87LA173Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Vaiden, MSThe plt stated that during the takeoff ground run the acft travelled over a small rise on the rwy & became airborne prematurely. The acft then collided with trees while the plt was trying to maneuver it to avoid a populated area. The acft then collided with…Jun 6, 1987 · N9734 · DestroyedNTSB DEN87FA147Accident · 4 fatalField investigationFinal reportBell 206L-1 · Choteau, MTThe EMS helicopter was returning to great falls, MT, on 6/5/87 when it crashed. Its occupants had earlier participated in a rescue seminar at many glacier, MT. The wreckage was not found until 6/9/87. A video tape recovered from the wreckage disclosed the…Jun 6, 1987 · N4999N · DestroyedNTSB FTW87DRD05Accident · No injuriesFinal reportGrumman G-164 · Kaplan, LAThe plt was dispensing fertilizer on a rice field when the acft collided with six strands of a power line at about 20' AGL. The airplane then crashed to the ground & was substantially damaged. The power line poles were located outside the field boundry.…Jun 5, 1987 · N7804 · Substantial damageNTSB LAX87FA225Accident · 1 fatalField investigationFinal reportDouglas A-4A · California City, CAThe airplane, a civilian Douglas A4A, was engaged in filming a commercial which required the plt to fly over a ferrari vehicle. The pilot had completed a low filming pass over the vehicle and was circling the area while the film crew was preparing for another…Jun 4, 1987 · N444AV · DestroyedNTSB DEN87LA142Accident · No injuriesLimited investigationFinal reportBell 206B II · Logan, UTThe plt did not have authorizatoin from his employer to conduct the flight. The plt stated after the acc that he was on a LCL flt with the pax to view property. He cont to state that drng a rt turn the eng low rotor RPM warning sounded. The plt executed an…Jun 3, 1987 · N59624 · Substantial damageNTSB MKC87LA114Accident · Minor injuriesLimited investigationFinal reportGrumman G-164 · Knoble, ARThe PIC had taken off for a local aerial application operation. While maneuvering to make initial application the acft started to lose power and sink during a downwind turn. PIC dumped his load but acft continued to sink until one wing struck the terrain and…Jun 1, 1987 · N730Y · Substantial damageNTSB BFO87FIG04Accident · No injuriesFinal reportAyres S2R-T15 · Grantsville, MDThe acft was second in a flt of three spraying forest area with dimilin when it contacted a power line suspended between two hilltops. The prop severed the single strand of cable and shortly after the engine lost power. The plt maneuvered for an emgcy lndg,…May 31, 1987 · N40184 · Substantial damageNTSB ATL87DLQ02Accident · Minor injuriesFinal reportHughes 369HS · Hawesville, KYDuring a weed control spraying operation, the pilot experienced a power failure 45 feet above the ground. The autorotation attempt resulted in the helicopter impacting the ground on it's left side. The investigation disclosed that the flexible fuel line to…May 28, 1987 · N9180F · Substantial damageNTSB DEN87LA135Accident · No injuriesLimited investigationFinal reportCessna 152 · Ogden, UTThe student plt & CFI were practicing slow flt & stalls. Carb heat was applied before the start of each stall series. During the recovery from the last stall the student plt applied only partial pwr. The CFI applied full pwr & the eng began to run rough. The…May 26, 1987 · N48590 · Substantial damageNTSB ANC87LA072Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BC-12D · Soldotna, AKThe 280 hour private pilot was observed doing steeply banked turns in excess of 90 degrees, inside loops and other aerobatic maneuvers, prior to entering a spin at an estimated altitude of 1500 to 2000 feet. The airplane completed approximately 8 turns prior…May 25, 1987 · N96857 · Substantial damageNTSB NYC87DHD05Accident · Minor injuriesFinal reportPiper PA-36-400 · Mullica Hill, NJThe pilot of the PA-36 was spraying chemicals on trees for control of the gypsy moth. He reported that he was unable to clear power lines and dumped his load. The aircraft settled to the ground. The FAA reported that the weight of the aircraft exceeded the…May 23, 1987 · N2412X · DestroyedNTSB ATL87LA146Accident · Minor injuriesLimited investigationFinal reportConsolidated Aeronautics Lake LA-4-200 · Sparta, NCThe plt attempted a precautionary ldg at a private grass airstrip he had located, after being advised of wx at his intended destination by ATC. Just prior to touchdown, he observed a balloon at mid-field and excuted a go-around. During climbout, he lost sight…May 23, 1987 · N8543A · Substantial damageNTSB MKC87LA107Accident · Minor injuriesLimited investigationFinal reportGrumman G-164 · Newport, ARThe pilot stated that he was spraying a rice field in formation with another airplane when his aircraft experienced an inflight upset due to the propwash, or wake turbulence, generated by the other aircraft. The landing gear struck a rice levee and was…May 22, 1987 · N492Y · Substantial damageNTSB FTW87DRG02Accident · No injuriesFinal reportAir Tractor AT301 · Weslaco, TXDuring an aerial application flt the eng lost pwr and the plt made a forced lndg. Post acc disassembly of the acft eng revealed the failure of an impeller bearing which resulted in the failure of the eng.May 22, 1987 · N5510S · Substantial damageNTSB MKC87DPG01Accident · 1 fatalFinal reportCessna A188B · Lake Village, ARAfter completing several spary swaths, the pilot began another turn for another spray swath. A witness stated that during this right turn, the aircraft initiated a left descending turn and crashed into nearby trees and then burned. Examination found no…May 21, 1987 · N731YU · DestroyedNTSB LAX87DVA09Accident · No injuriesFinal reportAyres S2R-T34 · Mendota, CADuring an agricultural application flight, the aircraft struck a pole that was located 30 feet within the field boundary. The pilot stated that due to the dawn light and the way the pole blended in with the field along with a light amount of chemical on the…May 21, 1987 · N4012Y · Substantial damageNTSB 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 ATL87DEI03Accident · No injuriesFinal reportBell 47G-2A · Monroeville, OHThe plt was on a normal spray run next to the edge of a field when he misjudged his clearance & the main rotor blades contacted a tree. The helicopter then crashed to the ground in a wheat field.May 20, 1987 · N818HJ · Substantial damageNTSB MIA87FA160Accident · 1 fatalField investigationFinal reportSchweizer G-164A · Dundee, MSWhile spraying a rice field, the acft was flying across svrl small dirt banks that had been furrowed for water ctl. Drg a swath run, it struck 3 furrowed banks that were close together, flipped over as it crashed, then burned. Witnessesrprtd the eng was…May 19, 1987 · N4654 · DestroyedNTSB BFO87FA037Accident · 1 fatalField investigationFinal reportCessna 150M · Elkton, MDThe acft was flying at low altitude over an area of open fields when according to witnesses the acft abruptly pitched down and descended to the ground. Some witnesses stated they heard the engine operating throughout the descent while ohter witnesses reported…May 17, 1987 · N714FZ · DestroyedNTSB CHI87FA129Accident · 2 fatalField investigationFinal reportCessna A150K · Scotts, MIThe airplane had been circling a residence at tree top level when a witness saw the nose drop and the acft descend steeply toward the terrain. The airplane struck a power line before ground impact.May 16, 1987 · N8331M · DestroyedNTSB CHI87DER07Accident · 1 fatalFinal reportAir Command Unknown · Dodge Center, MNBefore flt the pilot had stated that his uncertified and unregisterd gyroplane had a 'lot of bugs to work out'. After t.o. and five min of airwork the acft entered a steep 90 degree banked turn and then began to tumble. Shortly after the main rotor separated.…May 16, 1987 · UNREG · DestroyedNTSB ATL87LA138Accident · Minor injuriesLimited investigationFinal reportCessna 172-N · Walhalla, SCDuring a local sightseeing flight the plt trimmed the aircraft to a slow flight configuration, and circled a lake in the mountains of south carolina at an alt of approx 1,000 ft AGL. The aircraft was near max gross weight and the ground temp was 82 deg f. the…May 16, 1987 · N739QF · DestroyedNTSB DEN87LA124Accident · No injuriesLimited investigationFinal reportBrantly Helicopter 305 · Golden, COThe commercial plt was performing hover tests in his experimental helicopter at his private helipad, located 60 feet from his residence. The plt reported winds as variable gusting to 40 knots. The plt's attention was diverted and a wind gust pushed the…May 14, 1987 · N5JM · Substantial damageNTSB CHI87DER06Accident · 1 fatalFinal reportBell 47G-2A · New Prague, MNAfter about a 5 min flight, the helicopter collided with the ground during a downwind turn on an agricultural turnaround. Impact was on a heading of 210 degrees. Wind was from 326 degrees at 14 KTS, gusts to 22 KTS. No evidence was found of powerplant, flight…May 14, 1987 · N6786D · DestroyedNTSB SEA87LA092Accident · Minor injuriesLimited investigationFinal reportAerospatiale SA315-D Lama · Siletz, ORDuring external load operations the chockers became loose due to improper loading. The external load longline cable became entangled with the tailrotor causing a failure of the tail rotor system. The helicopter assumed a nose down attitude and spun to the…May 13, 1987 · N47256 · DestroyedNTSB LAX87DUM04Accident · Minor injuriesFinal reportTexas Helicopter M74L-WASP · Holtville, CADuring an aerial application flight, the pilot reported that the electrical system failed. Shortly after, the aircraft collided with power lines. Inspection of the aircraft revealed that the generator was inoperative. There were no other reported mechanical…May 12, 1987 · N1001Z · Substantial damageNTSB LAX87DUM03Accident · 2 fatalFinal reportChance Vought F4U-7 · Chula Vista, CAThe pilot of the F4U was giving the passenger a ride in appreciation of her volunteer work she contributed to an airshow conducted at brown field in san diego, California. Ground witnesses observed the F4U enter an inverted dive from an altitude of about 1500…May 10, 1987 · N33693 · DestroyedNTSB DEN87FA121Accident · 2 fatalField investigationFinal reportNorth American T-28D · Tatum, NMAccording to friends of the plt, the acft left roswell, new Mexico, with 2 people aboard after an airshow with a destination of lovington, NM. Witnesses observed the acft flying in the distance and then observed a big cloud of dust rising from the ground. The…May 10, 1987 · N9611C · DestroyedNTSB ATL87FA136Accident · 2 fatalField investigationFinal reportPiper J4A · Collierville, TNIt was reptd that the plt was taking his pax up for a LCL photographic flt at the req of the pax. Witnesses reptd that the acft remained over the apt for two or three circuits and then deptd the area in the dir of Collierville. Witnesses near the crash site…May 10, 1987 · N25020 · DestroyedNTSB SEA87LA091Accident · No injuriesLimited investigationFinal reportBell 206-B · Sloan, NVWhile climbing at a slow airspeed at a low altitude above the ground during strong gusting wind conditions, the pilot initiated a right turn and encountered an uncommanded right yaw. The aircraft completed several right spinning turns, impacted the ground,…May 9, 1987 · N3187D · DestroyedNTSB MKC87FA103Accident · 2 fatalField investigationFinal reportChampion 7EC · Delia, KSWitnesses stated that the aircraft was performing high speed, low level passes over the homes of some friends and relatives when, suddenly, it started a steep climb over a tree line. The aircraft appeared to slow down at the top of the climb; then it leveled…May 9, 1987 · N7556E · DestroyedNTSB BFO87LA034Accident · Minor injuriesLimited investigationFinal reportAyres Turbo Thrush 52R34 · Lavale, MDWhile spraying for gypsy moths during the early morning, the turbo-thrush collided with static wires located on top of high tension lines. The pilot stated that he did not see the wires because they were located on the shady side of an adjacent mountain.May 8, 1987 · CGDFQ · Substantial damageNTSB MKC87LA102Accident · No injuriesLimited investigationFinal reportEnstrom F-28A · Fayetteville, ARThe PIC was demonstrating the helo to a prospective customer. The PIC was hovering in a remote area with rough and uneven terrain. The PIC rptd outside air temps of abt 90 degrees during the demo flt. The PIC stated that he was moving around over the grnd in…May 7, 1987 · N13CM · Substantial damageNTSB MKC87DCQ02Accident · Serious injuriesFinal reportCessna 188 · Harper, KSThe pilot was preparing to spray a wheatfield. During the second 1/3 of procedural turnaround, the aircraft struck powerlines, then the ground. The aircraft was destroyed by post-impact fire.May 7, 1987 · N5609J · DestroyedNTSB LAX87DVG06Accident · Minor injuriesFinal reportAyres S-2R · Williams, CAThe plt reported he heard something break. The sound was followed by a vibration. The plt then turned to land on a road. He was unable to maintain alt and airspeed. The rockwell S2R landed in a cultivated field and nosed over after a collision with a dirt…May 6, 1987 · N4216X · Substantial damageNTSB DEN87LA119Accident · No injuriesLimited investigationFinal reportCessna A188B · St. Ignatius, MTAn ag plt was spraying a field near the local arpt, at 100 feet AGL. During an aerial application maneuver, the engine made a loud bang and stopped. The plt leveled the acft, selected a landing site and landed. During the roll out, the acft crossed an…May 6, 1987 · N9282R · Substantial damageNTSB ANC87LA066Accident · Serious injuriesLimited investigationFinal reportCessna 170B · Kenai, AKThe pilot stated during a low level flight above the trees, the aircraft started to vibrate. A few seconds later the propeller completely separated from the aircraft. The propeller was not located in the wooded area. The propeller separated from the aircraft…May 6, 1987 · N2754D · Substantial damageNTSB MIA87LA155Accident · No injuriesLimited investigationFinal reportBell 47G-3B1 · Panama City Bch, FLThe plt reported that shortly after takeoff the eng began to lose power, then failed. He then autorotated & set the helicopter down aprx 6 feet offshore. Examination of the eng logbooks by FAA personnel revealed that AD 62-23-02 which requires insp of the oil…May 3, 1987 · N43CD · Substantial damageNTSB MKC87LA095Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Brinkley, ARThe acft had 100 gallons of water onboard for the ag training flt. The plt has completed one spray pass and was half way through the turnaround when the acft stalled. It collided with the ground and flipped forward to the inverted position. The plt listed 80…Apr 30, 1987 · N2000A · DestroyedNTSB LAX87LA199Accident · 2 fatalLimited investigationFinal reportHughes 369D · TamuningsA Hughes 369D, operated off of a fishing vessel, went out of control and crashed in the pacific ocean, nr guam. The accident was witnessed by the ship's captain. His statement indicated one of the main rotor blades separated in flt while the helo was orbiting…Apr 29, 1987 · N10995 · DestroyedNTSB MIA87FA150Accident · 1 fatalField investigationFinal reportPiper PA-11 · Hollandale, MSWitnesses stated that the acft circled a pond & dived once, then on a 2nd circling attempt, it made a short steep turn & went into a twisting dive into the pond. The passenger stated that they were flying at appx 100 to 150 ft above some fish ponds when the…Apr 28, 1987 · N5093H · DestroyedNTSB LAX87DVG04Accident · No injuriesFinal reportSchweizer G-164B · Pleasant Grove, CADuring an aerial application flight, the pilot reported that during a turn for the next pass over the field, the engine quit. The aircraft was turned into the wind and was landed on a rough plowed field. During the landing roll the aircraft nosed over. The…Apr 28, 1987 · N3633B · Substantial damageNTSB DEN87LA112Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-260 · Harvey, NDAn ag plt was working a field on an aerial application flt. At the end of a spray pass, the acft struck a shelterbelt and went out of control. The acft climbed to 300 ft and rolled inverted. The acft impacted the ground in a nose low, wing down attitude. The…Apr 27, 1987 · N9736P · Substantial damageNTSB MKC87FA092Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Valley, NEAt aprx 2020 CDT, witnesses saw the acft as the plt made svrl low passes over the platte river near Valley, NE. On the last pass, the acft struck power lines, then crashed in the river. The wreckage came to rest in the main channel of the river in aprx 25 ft…Apr 26, 1987 · N1145Q · Destroyed