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 NYC88DGM03Accident · 1 fatalFinal reportPiper PA-28-161 · Spartansburg, PAThe pilot landed at the franklin, PA airport after encountering fog. After making several phone calls and remaining on the ground for about 37 minutes he departed. About 30 minutes later the aircraft was seen circling at a low altitude, flying in and out of…Nov 14, 1987 · N8318L · DestroyedNTSB LAX88LA040Accident · Minor injuriesLimited investigationFinal reportCessna 172B · Jamestown, CADuring a local sightseeing flight over a lake, the plt reported after circling for some time at a low altitude, the engine lost power. The plt made an emergency landing on the lake where the acft sank. Several days later, the acft was retrieved and the engine…Nov 12, 1987 · N7797X · Substantial damageNTSB DEN88DTE02Accident · 1 fatalFinal reportBoeing A75N1 · Keenesburg, COThe commercial ag plt was starting a spray run on a new field. During the first pass, the aircraft struck power line wires. The aircraft rolled left and impacted the terrain in a wings level, nose low attitude. An immediate post crash fire destroyed the…Nov 10, 1987 · N65110 · DestroyedNTSB SEA88MA015Accident · 4 fatalMajor investigationFinal reportCessna 310N · Bellingham, WAThe acft was chartered to take university (wwu) psnl to an alumni dinner. While rtrng at ngt, the plt made a localizer only, ILS rwy 16 apch in marginal VFR conds. Drg the apch, radar svc was terminated & the plt was told to ctc bellinghamradio, but he did…Nov 5, 1987 · N4178Q · DestroyedNTSB DEN88FA021Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Durango, COThe two pax had chartered N8266U for a sightseeing flight of the local area. The charter plt, a CFI found that one of the pax was a plt and permitted him to fly the acft. The pax expressed an interest in spotting elk and flew the acft into a canyon, below the…Nov 4, 1987 · N8266U · DestroyedNTSB LAX88FA032Accident · 2 fatalField investigationFinal reportRobinson R22A · Moraga, CAA divergence of the main rotor from its normal plane of rotation for an undetermined reason, which resulted in rotor contact with the cockpit area.Nov 3, 1987 · N8475A · DestroyedNTSB NYC88DHA01Accident · 2 fatalFinal reportCouden Skybolt · Mansfield, NJWitnesses observed acft performing multiple aerobatic maneuvers. They said airplane was performing vertical maneuver or nearing top of loop when it entered an inverted flat spin. Rotation was stopped, but recovery incomplete when airplane crashed in a hay…Nov 1, 1987 · N341SB · DestroyedNTSB LAX88LA030Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-150 · San Jose, CAWhile flying 500-600 feet above the terrain on a local pleasure flight, the pilot turned into what he believed to be an open ended canyon. After becoming aware that he had inadvertently turned into a box canyon, the pilot attempted a 'chandelle turn' to exit…Oct 31, 1987 · N4771A · DestroyedNTSB LAX88FA065Accident · 2 fatalField investigationFinal reportBritten-Norman BN2A-26 · Desert Center, CAThe plt was hired to ferry an islander from el paso, TX to santa paula, CA. He represented himself to the ferry company as being an experienced islander plt. No previous islander flt time was found in the pilot's logbook. It was the plt's 40th birthday & he…Oct 31, 1987 · N25MR · DestroyedNTSB DEN88LA017Accident · No injuriesLimited investigationFinal reportPiper J5A · Devils Lake, NDA commercial plt was giving instruction to another commercial plt with a CFI rating. Witnesses observed the aircraft at approximately 100 feet over a water fowl production lake. The plt stated that during a turn and pull up, the engine lostpower and the…Oct 31, 1987 · N32887 · Substantial damageNTSB CHI88FA012Accident · 2 fatalField investigationFinal reportBellanca 8KCAB · Lawrenceville, ILWhile performing aerobatic maneuvers the aircraft entered a spin to the left and did not recover before impacting the ground. The acft entered the spin after the plt announced that this spin would be the last maneuver before landing. The spin was started at…Oct 31, 1987 · N41682 · DestroyedNTSB MIA88FA023Accident · 2 fatalField investigationFinal reportCessna 150E · Aguadilla, PRWitnesses observed the acft maneuvering a low alt over ocean water near a shoreline. They saw it pull up sharply to clear a commercial boat dock, then nose over & impact the water in a nose low, rgt wing low attitude. The acft sank & came to rest in 30' of…Oct 30, 1987 · N4081U · DestroyedNTSB LAX88LA025Accident · No injuriesLimited investigationFinal reportMcdonnell Douglas 369D · Borrego Springs, CAThe pilot and three passengers were flying at low altitude over mountainous terrain looking for big horn sheep. Thirty minutes into the flight the pilot heard a loud noise and the tail yawed left. The pilot turned away from the mountain to look for a place to…Oct 27, 1987 · N47861 · Substantial damageNTSB FTW88DPJ02Accident · Serious injuriesFinal reportPiper PA-25 · Catoosa, OKThe pilot stalled the aircraft while turning downwind during a practice agricultural operation. The aircraft impacted the ground out of control. The pilot stated that he could not recall anything about the flight.Oct 26, 1987 · N9787P · DestroyedNTSB LAX88FA023Accident · 1 fatalField investigationFinal reportBellanca 7KCAB · Red Bluff, CAThe pilot was asked to move his aircraft from a private airstrip on which he had landed without prior approval. As the aircraft climbed after takeoff the pilot made a left wingover, reversed course and buzzed the runway at an elevation of about 30 - 40 feet.…Oct 25, 1987 · N8645V · DestroyedNTSB FTW88LA013Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Brownsville, TXWhile circling an unlighted private airstrip, the pilot allowed the aircraft to descend into 2 feet of water causing substantial damage.Oct 25, 1987 · N4045M · Substantial damageNTSB SEA88FA011Accident · 3 fatalField investigationFinal reportCessna 180K · Walton, ORWitnesses observed the aircraft flying westbound toward a pass at a low altitude above the ground near the base of low stratus clouds. The aircraft struck a tree at the top of a ridgeline in mount/hilly terrain on a northeasterly heading, traveled 1/2 mile…Oct 21, 1987 · N2754K · DestroyedNTSB FTW88LA008Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Lapra, TXUpon entering a bank approx. 80 to 100 ft. off the ground, the aircraft experienced a power loss with vibration. During autorotation the aircraft contacted a tree causing substantial damage. Examination of the wreckage found the transmission clutch assembly…Oct 20, 1987 · N8403E · Substantial damageNTSB LAX88LA018Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Carpenteria, CAThe pilot encountered deteriorating weather as he approached his destination. After descending to 1,500 feet MSL, he attempted to follow a highway to the ocean but inadvertently encountered fog. The pilot attempted to turn, after spotting lights from houses…Oct 19, 1987 · N11176 · DestroyedNTSB FTW88DQG02Accident · Serious injuriesFinal reportAir Tractor AT-301 · Lockney, TXAfter completing a swath run, the plt began a procedure turn to the right for another run. During the maneuver, the acft stalled & turned counterclockwise for about 180 deg before impacting the ground in a nose down, left wing low attitude.Oct 19, 1987 · N73127 · Substantial damageNTSB ATL88LA017Accident · Minor injuriesLimited investigationFinal reportPiper J-3 · Clarks Hill, SCThe aircraft was circling about 200 feet above the trees when the pilot began a climbing turn. As he leveled the wings the aircraft began to descend. The pilot applied full power and eased forward on the control stick lowering the aircraft nose slightly. When…Oct 18, 1987 · N98806 · Substantial damageNTSB ANC88FA011Accident · 3 fatalField investigationFinal reportPiper PA-18 · Homer, AKThe weather between Homer and anchorage included marginal conditions along segments of the route. The airline transport rated pilot was encouraged to take advantage of an offer to travel by automobile and still arrive in time for a commitment in anchorage. He…Oct 18, 1987 · N4193Z · Substantial damageNTSB SEA88LA009Accident · No injuriesLimited investigationFinal reportNapper Vancraft · Pocatello, IDThe experimental gyrocopter was on a test flight when the right rudder pedal pivot bolt broke. The aircraft began a spiral in a counter-clockwise direction with the rudder separating from the aircraft at the hinge points. The aircraft continued to spiral to…Oct 17, 1987 · N49694 · DestroyedNTSB MIA88FA008Accident · 1 fatalField investigationFinal reportExtra Flugzeugbau 230 · Arcadia, FLThe accident occurred while the aircraft was performing exhibition aerobatics at an airshow. The acft had just completed a portion of the planned low alt aerobatic sequence which included a tail slide & 3 rolls with the nose of the acft pointed toward the…Oct 17, 1987 · N230WF · DestroyedNTSB LAX88FA016Accident · 1 fatalField investigationFinal reportPiper PA-28RT-201 · Buena Park, CAWhile depg on an IFR flt to VFR conds, the plt failed to provide the correct transponder code per ATC clnc. The local controller (ctlr) reminded him to set the correct code & the plt subsequently replied 'I'm having a problem right now . . . I've got to get…Oct 17, 1987 · N43551 · DestroyedNTSB LAX88DXQ01Accident · Serious injuriesFinal reportPugh LONG-EZ · Newell, CABefore taking off, the plt noted that the wind sock was 'whipping & was about 3/4 full.' He said that after takeoff, he made a flyby at about 50' AGL, with an airspeed of about 150 mph. He then entered a steep climbing right turn. The plt estimated that at…Oct 17, 1987 · N38EZ · DestroyedNTSB LAX88FA015Accident · 3 fatalField investigationFinal reportDassault-Breguet DA 10 · Rancho Murieta, CAIn flight loss of control by the pilot flying while performing an intentional low level aerobatic maneuver.Oct 15, 1987 · N121FJ · DestroyedNTSB ATL88DKG01Accident · No injuriesFinal reportCessna 188 · Samson, ALThe plt said the prop surged during a swath run. While rtning to land the engine quit. The acft landed in a plowed field, resulting in substantial damage to the rt wing and lndg gear. Inspection of the engine by the plt revealed that the oil filter adapter…Oct 15, 1987 · N731RF · Substantial damageNTSB ATL88LA012Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Scyrene, ALThe engine lost pwr during a low-altitude powerline patrol. The airplane nosed over during the subsequent forced ldg. Post-crash examination of the acft by an FAA inspector revealed that the fuel tank vent system was obstructed with mud-dauber nests in…Oct 14, 1987 · N22553 · Substantial damageNTSB MKC88LA004Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Storm Lake, IAWhile practicing an approach to lndg stall, the stu plt stated that the eng failed to respond to throttle advancement. After unsuccessfully attempting emergency procs to include carb heat, fuel pump, and switching fuel tanks, he selected a fld. Prior to t/d,…Oct 12, 1987 · N4477X · Substantial damageNTSB ATL88DMG01Accident · 1 fatalFinal reportRogers-Gibson 1 · Bennettsville, SCThe homebuilt aerobatic airplane impacted flat terrain adjacent to the rwy shortly after takeoff. A pilot/witness who was in the arpt terminal lobby at the time rptd that he briefly observed the airplane pass by the terminal at a low level in a near…Oct 11, 1987 · N111MJ · DestroyedNTSB BFO88FA002Accident · 1 fatalField investigationFinal reportCessna 172N · Lowmoor, VAThe acft was involved in powerline patrol over mountainous terrain at low altitude. The plt made a climbing right turn to avoid a ridge and went into a valley where he was boxed in by two ridges. He unsuccessfully tried to outclimb one of the ridges before he…Oct 9, 1987 · N3075E · DestroyedNTSB ATL88FA007Accident · 1 fatalField investigationFinal reportBeech HA-1 · Memphis, TNAfter t/o PIC was told by twr that tail stand, used to prevent acft from tipping on tail when loaded, was still attached to acft. PIC req teardrop turn back to departure rwy. Approach controller stated he saw mode c indication of 700'. A/p elev. Is 332'. Acft…Oct 9, 1987 · N9231 · Substantial damageNTSB SEA88LA003Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Canby, ORAt a reduced power setting, while maneuvering, a loss of power occurred. An inadvertent stall was then entered. The student pilot is legally deaf, but the stall warning system incorporated a red stall warning light. After the stall occurred the aircraft…Oct 8, 1987 · N4112J · DestroyedNTSB FTW88DRD01Accident · No injuriesFinal reportGrumman G-164A · Port Allen, LAThe pilot experienced a partial loss of power during pull-up from a swath run. He attempted to return to the field he was working in order to make an emergency landing but was unable to due to inadequate engine power. He landed in high vegetation and flipped…Oct 8, 1987 · N6743Q · Substantial damageNTSB MIA88LA014Accident · Minor injuriesLimited investigationFinal reportHiller UH-12E · Union Church, MSAt an altitude of aprx 75 feet during an agricultural turn, the plt reported that the engine lost power. While executing a forced landing, the rotor blades contacted trees, after which, during the descent, the right skid collided with a stump & the helicopter…Oct 6, 1987 · N4029R · Substantial damageNTSB DEN88FA002Accident · Serious injuriesField investigationFinal reportBellanca 7ECA · Fowler, CODuring a pleasure flight the pilot flew too low over the Arkansas river, collided with powerlines and crashed into the river. The pilot stated he could not see well due to the setting sun in his eyes. The pilot and his passenger received serious injuries and…Oct 5, 1987 · N8563V · DestroyedNTSB ATL88LA002Accident · Minor injuriesLimited investigationFinal reportCessna 172F · Grand Bay, ALThe engine lost pwr shortly after t/o. the engine regained pwr as the plt was about to make a forced ldg in a field. He aborted the ldg attempt and attempted to make it back to the airstrip. The engine subsequently lost pwr again. The plt stretched his glide…Oct 3, 1987 · N5647R · Substantial damageNTSB DEN88FA001Accident · 1 fatalField investigationFinal reportPiper PA-18-125 · Miles City, MTA cattle rancher was flying his aircraft looking for stray cattle and checking the condition of the ranch. He was at approximately 300 feet AGL when he spotted cattle that had strayed off the ranch. The pilot turned to get a better view of the cattle and flew…Oct 1, 1987 · N1377A · Substantial damageNTSB DEN88DQA01Accident · 2 fatalFinal reportChristen Industries Eagle II · Roswell, NMThe plt and his plt rated pax departed Roswell at about 0900 MDT to practice maneuvers in the local area. The wreckage of the homebuilt acft was found in an open field about 1+20 after takeoff. There were no known witnesses to the accident. The inverted…Oct 1, 1987 · N16RK · DestroyedNTSB DEN87LA247Accident · Minor injuriesLimited investigationFinal reportBell 47G-3B1 · Grand Junction, COThe plt was practicing some helicopter maneuvers in preparation for taking an FAA flt examination. During one of his maneuvers the helicopter's main rotor blades struck the ground causing the acft to crash. A post accident fire errupted and destroyed the…Sep 30, 1987 · N7806S · DestroyedNTSB MIA87LA262Accident · Minor injuriesLimited investigationFinal reportBoeing E75 · Ocala, FLThe plt stated that the eng lost power & he was at low alt looking for an emerg ldg field when the wing hit a tree. The pax stated they were doing aerobatics at low alt & the eng quit. She stated that she was not wearing the required parachute & had asked the…Sep 29, 1987 · N5190N · Substantial damageNTSB SEA87LA195Accident · No injuriesLimited investigationFinal reportBeech 23 · Basin City, WAThe pilot was making a low pass over the ground for a possible off airport landing next to his farm. During the low approach, he noticed power lines ahead and pushed forward on the controls to clear under them. However, there was a wrecked vehicle below the…Sep 26, 1987 · N2330Q · Substantial damageNTSB ANC87LA167Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Beluga Lake, AKThe pilot stated that he was maneuvering 20 feet above the tree tops when a gust of wind made him lose directional control of the aircraft, causing the aircraft to strike the trees and hillside.Sep 26, 1987 · N4471A · Substantial damageNTSB ATL87LA266Accident · No injuriesLimited investigationFinal reportCessna 172H · Chuckey, TNThe plt estimated there was 9 gal of fuel on board when he took off. Aprx 20 min later, he was making a low pass over a private strip when the eng lost power. He stated that he repositioned the fuel selector to the other tank, but was unable to restart the…Sep 25, 1987 · N3885R · Substantial damageNTSB FTW87DPJ09Accident · Serious injuriesFinal reportG&C Helicopters EL Tomcat MK5A · Marlow, OKPilot failed to see and avoid tree at end of swath run during a spraying operation. After contacting the tree, the helicopter started to spin and struck the ground in an approximate 90 degree right bank and started to burn.Sep 23, 1987 · N17315 · Substantial damageNTSB LAX87DVA12Accident · No injuriesFinal reportGrumman G164B · Buttonwillow, CADuring an aerial application flight, after pulling out of a pass over a field the plt heard a loud bang followed by severe engine vibration. The acft lost power and the pilot made a forced landing in a plowed field. During the landing roll the acft nosed…Sep 22, 1987 · N6607Q · Substantial damageNTSB CHI87FA219Accident · 1 fatalField investigationFinal reportBeech H-18 · Rockford, ILThe commercial pilot was on a repositioning flight from kenosha, Wisconsin to atlanta, Georgia, after having been without sleep for about 20 hours. Witnesses observed the aircraft circling a subdivision near Rockford, Illinois at a low altitude, just above…Sep 22, 1987 · N5850S · DestroyedNTSB LAX87LA340Accident · Serious injuriesLimited investigationFinal reportPiper JC3-65 · Sacramento, CAThe pilot was observed to be flying at a very low altitude by two separate witnesses. They stated that he was flying and maneuvering at approximately 15-20 feet AGL and buzzing powerlines. The pilot stated that he can not remember what happened and that the…Sep 20, 1987 · N6187H · Substantial damageNTSB LAX87FA341Accident · 1 fatalField investigationFinal reportBellanca 7ECA · Sonoma, CAThe 70-hour student plt had recently passed the pvt plt written exam & had completed most of the flt trng for certification. He was looking forward to becoming a licensed plt. While on a personal flt, the plt flew over his brother's residence & was observed…Sep 20, 1987 · N8598V · Destroyed