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 ATL87FA209Accident · 1 fatalField investigationFinal reportCessna 152 · Yanceyville, NCThe plt was engaged in low alt commercial photography. Witnesses had observed the acft operating at a very low altitude in the area for the past two or three days. The witness closest to the crash site related that the acft would make a straight pass near a…Jul 13, 1987 · N4869B · DestroyedNTSB SEA87FA135Accident · 2 fatalField investigationFinal reportMaule M-4-210C · Sitka, AKPlt was on local VFR flight plan. Witnesses observed acft flying at low level along beaches. Later, witness saw smoke rising from wooded terrain about two miles inland from nearest beach. Investigation revealed no evidence of inflight failure of malfunction…Jul 12, 1987 · N9812M · DestroyedNTSB CHI87LA167Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Springfield, MITwo hot air balloons were involved in a midair collision during a sanctioned Balloon competition. N40363 was able to retain control and landed uneventfully. N1505F partially deflated and descended out of control to the ground. Witnesses stated that N40363 was…Jul 12, 1987 · N1505F · 2 aircraft · Substantial damageNTSB ANC87LA096Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · Mcneil Cove, AKThe pilot and his passenger were flying at approximately 150 feet above the water near the shoreline when the pilot made a steep left climbing turn. The airplane stalled and crashed into the water. The pilot was not rated to fly seaplanes. No mechanical…Jul 12, 1987 · N4322E · Substantial damageNTSB ANC87FA095Accident · Serious injuriesField investigationFinal reportPiper PA-18 · Sheep Mountain, AKThe pilot and his two passengers took off in a two place Piper PA-18 from a glacier after doing repair work on an aircraft that had crashed there earlier. Weather conditions were deteriorating as they approached their destination airstrip located in a nearby…Jul 12, 1987 · N159T · Substantial damageNTSB NYC87LA200Accident · Minor injuriesLimited investigationFinal reportChampion 7GCAA · Bargaintown, NJThe pilot reported that during climb out and level off after a banner pickup, the engine would not produce sufficient power to sustain flight. After checking the carburetor heat and mixture, he released the tow ropes and established a glide. Subsequently, the…Jul 11, 1987 · N9085L · Substantial damageNTSB MKC87DPG02Accident · Serious injuriesFinal reportPiper PA-25-235 · Hazen, ARThe pilot stated to a witness that after coming out of his 2nd pass, in the last 1/3 of his procedural turn, the plane stalled and the right wing struck a telephone wire which caused it to swing onto a gravel road. It hit left wing/nose down, bounced, and…Jul 11, 1987 · N7705Z · DestroyedNTSB ATL87DLT03Accident · 1 fatalFinal reportBurkhart Grob G102-111B · Memphis, TNGlider tow rope released at about 200FT following t/o. glider made rt turn followed by stall/spiral which continued until ground impact. Tow pilot saw glider pilot's hat falling to ground just after tow rope was released by glider pilot. Glider canopy was…Jul 11, 1987 · N3950L · DestroyedNTSB FTW87LA165Accident · Minor injuriesLimited investigationFinal reportBell 206L-1 · Venice, LAThe pilot was repositioning the aircraft after a phase iv inspection. The aircraft lifted off the pad and made several clockwise revolutions, descended out of control, impacted the ground and rolled over on its right side. Investigation revealed the number 1…Jul 9, 1987 · N5734S · Substantial damageNTSB ATL87DEI08Accident · Minor injuriesFinal reportGrumman G-164A · Bucyrus, OHAs the plt was apchg a field to spread fertilizer, the acft collided with a tree & crashed to the ground. The plt received a head injury & said he could not recall the acdnt. According to hospital records, he was suffering from pneumonia & had a 101 deg temp…Jul 9, 1987 · N7845 · Substantial damageNTSB MKC87FA131Accident · 2 fatalField investigationFinal reportBellanca 8GCBC · Holdrege, NEWitnesses stated that the aircraft was performing a loop when the left wing failed upward and rearward causing the aircraft to plummet to the ground, out of control. The aircraft appeared to have been in trouble during the loop entry and throughout the…Jul 8, 1987 · N87099 · DestroyedNTSB CHI87DER08Accident · No injuriesFinal reportCessna T188C · Olivia, MNDuring a 180 degree turn from completion of a spray swath the aircraft began to sink. The pilot dumped his load and added power, however was unable to arrest sink. When it was obvious that impact with the ground was imminent, the pilot reduced power and…Jul 8, 1987 · N9674J · Substantial damageNTSB ATL87LA204Accident · No injuriesLimited investigationFinal reportBell 47D1 · Huntsville, ALThe aerial application flight was dispensing insecticides on a cotton field. While maneuvering to avoid powerlines during the procedure turnaround following an upwind swath run, the pilot failed to maintain sufficient airspeed to ensure effective…Jul 8, 1987 · N908B · Substantial damageNTSB SEA87LA137Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 · Cashmere, WADuring aerial applications maneuver a loud whine accompanied by a loss of power occurred. During forced landing a hard landing was made collapsing the skids with the main rotor blades striking the ground. No reason for the power loss was found.Jul 6, 1987 · N73932 · Substantial damageNTSB ATL87LA203Accident · No injuriesLimited investigationFinal reportCessna 152 · Goldsboro, NCStudent PIC rpted he followed wrong railroad track to return from the practice area to the airport. Viz was about 6 miles in hazy conditions. Prior to exhausting fuel or daylight he elected to land in a field. Field was soft terrain and acft nosed over.Jul 6, 1987 · N69087 · Substantial damageNTSB NYC87LA197Accident · No injuriesLimited investigationFinal reportAeronca 7EC · Scoodic Lake, METhe plt of the float equipped acft was taking off from Scoodic Lake. Drg the initial climb phase after takeoff, he noted the acft began to lose altitude & would not clear trees on a ridge ahead. He initiated a turn back toward the lake; however, the acft…Jul 5, 1987 · N8955R · Substantial damageNTSB NYC87DNC07Accident · 1 fatalFinal reportMcculloch Monerai "S" · Springfield, VTThe monerai 's' (N54MS, a pwrd glider) experienced an inflt failure of the left wing spar & crashed. An investigation revealed the acft was being operated in excess of its max gross wt limit of 450 lbs. The plt of an unpowered monerai said he & 3 others…Jul 5, 1987 · N54MS · DestroyedNTSB DEN87MA168Accident · 10 fatalMajor investigationFinal reportBeech D18S · Lakeside, MTThe plt borrowed the acft to fly a musical group to kalispell for a pvt engagement at Lakeside, MT, which was aprx 15 mi south of the arpt. That evening, the group boarded the acft for the return flt. After takeoff, the acft was seen flying at low alt in the…Jul 5, 1987 · N132E · DestroyedNTSB DEN87LA170Accident · 2 fatalLimited investigationFinal reportChristian Eagle II · Snowmass, COThe ATP plt and his passenger departed aspen, CO on a local acrobatic flight. Witnesses stated the plt had been performing acrobatic manuevers and was attempting a 'loop' when the acft was observed to 'stall' at the top of the manuever, approximately 2000…Jul 5, 1987 · N81DG · DestroyedNTSB LAX87DUJ06Accident · 1 fatalFinal reportDavis Midget Mustang · Kirkland, AZDuring a low level aerobatic flight, the aircraft collided with the terrain after completing a roll. There were no mechanical failures or malfunctions reported. The plt performed the last roll in view of two friends driving in a car near the acc scene.…Jul 3, 1987 · N7SD · DestroyedNTSB LAX87LA255Accident · Serious injuriesLimited investigationFinal reportBell 206L-3 · Benson, AZA Bell helicopter 206L-3 collided with wires while maneuvering over an underground telephone cable. The plt indicated that he had just completed a 360 deg right turn at the request of the pax and was aprx 185 deg through the second turn when he struck a…Jul 2, 1987 · N2123X · Substantial damageNTSB CHI87LA160Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BC-12D · Dyckesville, WIAircraft stalled as the pilot attempted to climb and turn back to fly along green bay shoreline. The pilot was flying approx. 100 to 150 feet above the water in order for the passenger to photograph the shoreline.Jul 1, 1987 · N33967 · DestroyedNTSB ATL87FA194Accident · Serious injuriesField investigationFinal reportPiper PA-18A-150 · No.Myrtle Beach, SCThe airplane was maneuvering at 350 ft AGL in preparation for a banner pick-up when it entered a spin and subsequently impacted trees and the terrain. The plt stated that he 'failed to fly the airplane' while attempting to deploy a banner tow line, and that…Jun 30, 1987 · N74815 · DestroyedNTSB DEN87LA161Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Cayuga, NDThe plt was completing a swath run and struck a power line with the right wing, severing the wing. The aircraft did a snap roll to the right and impacted in a field.Jun 29, 1987 · N4703R · DestroyedNTSB NYC87LA191Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Cape May, NJThe Piper J3C-65 made an unsuccessful attempt at a banner pickup and was maneuvering at 400 ft in a climbing left turn for another pickup when a power loss occurred. The pilot made a forced landing in a marsh. The pilot reported the fuel quanity gauge was…Jun 28, 1987 · N42138 · Substantial damageNTSB LAX87DUJ08Accident · Serious injuriesFinal reportTeague Phantom · Casa Grande, AZThe plt was flying the ultralight type acft at low level. As he flew thru a pass between two foothills, the acft struck telephone lines, then collided with terrain. There were no reported mechanical failures or malfunctions.Jun 28, 1987 · N922ET · DestroyedNTSB DEN87FA162Accident · 4 fatalField investigationFinal reportCessna 421C · Cody, WYThe plt & 3 paxs were returning to dallas, TX from a retreat in Montana. The plt filed an IFR flt plan from white sulphur springs, MT, to casper, WY, but did not activate it after departure. The acft was rprtd overdue by family & a search was initiated. The…Jun 28, 1987 · N26553 · DestroyedNTSB FTW87FA152Accident · 1 fatalField investigationFinal reportChampion 7ECA · Monahans, TXWitnesses stated that upon departure the pilot pulled the aircraft up abruptly and rolled into a very steep right climbing turn. After about 20 minutes the pilot returned to the airport due to weather conditions along his porposed route of flight. Over the…Jun 27, 1987 · N2500F · DestroyedNTSB FTW87DRD07Accident · No injuriesFinal reportGrumman G-164B · Chenneyville, LAThe engine experienced a total loss of power due to a failed #1 connecting rod. During the forced landing the left wing contacted cotton plants which caused the aircraft to veer left and flip inverted.Jun 26, 1987 · N7500K · Substantial damageNTSB CHI87DEM09Accident · 2 fatalFinal reportNorth American P-51D · Ludington, MIN3278D was #1 (leader) in a flt of 2 North American P-51 acft. The plt of the 2nd P-51 rprtd that they were on a southerly heading over water about 1/2 mi from the shore when the leader raised his nose & began rolling to the right. Witnesses on the beach…Jun 26, 1987 · N3278D · DestroyedNTSB ATL87FA189Accident · 4 fatalField investigationFinal reportPiper PA-28-180 · Jesup, GAWitnesses rprtd the acft 'buzzed' (flew low) over a factory, where the plt used to work, then it went over the altamaha river, flew under a bridge & continued up the river at low alt. About 2 to 3 mi upstream, the acft was maneuvering when it struck trees &…Jun 26, 1987 · N15978 · DestroyedNTSB ATL87DEI06Accident · 2 fatalFinal reportSteen Skybolt · Wadsworth, OHThe accident occurred when the pilot was practicing aerobatics. The investigation disclosed that linkage control rods between the pilot's stick and the pitch elevator was broken. The evidence indicated that the failure was caused by a combination of…Jun 25, 1987 · N86173 · DestroyedNTSB SEA87LA121Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Viola, IDDuring an aerial applications maneuver a total loss of power occurred due to the internal failure of the supercharger impeller. During the forced landing the left main gear collapsed causing the aircraft to nose over inverted.Jun 24, 1987 · N5285 · Substantial damageNTSB CHI87DEP07Accident · Serious injuriesFinal reportPiper PA-36 · Plover, WIAfter spraying most of a bean crop, the plt was making clean-up swaths over an area at the north side of the field. This area had bldgs to the west & trees to the east. To avoid flying toward the bldgs, the plt elected to make the passes to the east (toward…Jun 22, 1987 · N57791 · DestroyedNTSB CHI87LA155Accident · Minor injuriesLimited investigationFinal reportStinson 108-1 · Big Sandy Lake, MNThe engine stalled for undetermined reasons after the pilot made a wide circle turn. During a forced landing in a lake, the aircraft nosed over. The last annual aircraft inspection was 15 months prior to the date of the accident.Jun 21, 1987 · N40161 · Substantial damageNTSB ATL87LA184Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Cottonwood, ALThe plt stated that everything was normal for the acft during the preflt and runup. He had just about completed his first swath run when he reptd that the engine shook a little and started backfiring. He pulled up and started across a swamp toward a paved…Jun 21, 1987 · N7687 · Substantial damageNTSB MIA87LA190Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Miami, FLThe instructor plt stated that the helicopter began to vibrate while the student plt was maneuvering it during an instructional flt. The instructor plt then executed a forced landing and upon touchdown the main rotor blades contacted the ground. Inspection of…Jun 20, 1987 · N6772D · Substantial damageNTSB ATL87LA175Accident · No injuriesLimited investigationFinal reportPiper PA-25 · Myrtle Beach, SCThe acft encountered a strong downdraft in a thunderstorm and impacted the water during a beachside banner towing operation. The plt reported that he had observed thunderstorms developing inland about 1/2 hr prior to the accident and that his acft was…Jun 19, 1987 · N6078Z · Substantial damageNTSB NYC87LA180Accident · No injuriesLimited investigationFinal reportCessna 172 · Mt.Union Boro, PAThe aircraft collided with transmission wires while flying low during a pleasure flight. An uneventful precautionary landing was made on a highway with reduced power and full flaps.Jun 18, 1987 · N3913F · Substantial damageNTSB MKC87LA124Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Neelyville, MOThe ag pilot was making a low pass to wave his flagman out of the field. The engine response was slow and he was forced to land. To keep from hitting trees, pilot overbraked and flipped airplane forward to inverted position.Jun 18, 1987 · N5214 · Substantial damageNTSB LAX87LA238Accident · No injuriesLimited investigationFinal reportCessna 172N · Malibu, CADuring a local instructional flight, the pilot stated that they were flying along the coast aprx 1 mile offshore and 500 ft AGL. The student started a climbing right turn towards land. The student continued to apply back pressure to the point that the acft…Jun 18, 1987 · N738JV · Substantial damageNTSB DEN87FA153Accident · No injuriesField investigationFinal reportConcept 70 · Durango, COThe plt reported that he had been flying for one hour and had been doing acrobatics. He had started an inside loop and during pull up, he reported indicating 5.5 g's on his new g meter. The plt reported that both wings left the acft and he jettisoned the…Jun 17, 1987 · N23405 · Substantial damageNTSB ATL87LA170Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Hazard, KYThe plt observed the rear of the upper engine cowling lift up shortly after takeoff and he became concerned that the cowling might come off the airplane during flight. The pilot attempted to maneuver the airplane back to the airport to land, the airplane…Jun 16, 1987 · N8021W · Substantial damageNTSB LAX87LA235Accident · No injuriesLimited investigationFinal reportCessna 152 · Long Beach, CAThe aircraft ditched in the pacific ocean while on a VFR instructional flight. Both pilots indicated that the engine stopped abruptly and they were unable to restart it. The propeller would not turn when the starter was engaged, nor would it windmill. The CFI…Jun 15, 1987 · N115RJ · DestroyedNTSB LAX87FA234Accident · 1 fatalField investigationFinal reportCessna T210N · Huntington Bch, CADuring a pleasure flight, the pilot informed an air traffic controller that he was running out of fuel and turning to an airport. During the descent the airplane collided with a tree and terrain. There were no reported mechanical failures or malfunctions with…Jun 15, 1987 · N6461N · DestroyedNTSB FTW87LA144Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T-1A · Lago Vista, TXWhile maneuvering at approximately 50 feet AGL, the aircraft's landing gear contacted a 7200 volt powerline. Control of the aircraft was lost, and it descended out of control into about 2 feet of water, causing substantial damage.Jun 14, 1987 · N874K · Substantial damageNTSB SEA87LA114Accident · Minor injuriesLimited investigationFinal reportCessna T-188C · Yerington, NVWhile on an aerial application swath run the pilot allowed the aircraft landing gear to contact the grain crop, resulting in loss of airspeed, uncontrolled descent, impact with the ground and nose over.Jun 13, 1987 · N9795J · DestroyedNTSB NYC87LA178Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Sterling, MAWhile practicing hovering in the designated hover area at the arpt, the stu plt accidently pulled aft cyclic while the helicopter was drifting backwards. This caused the tail structure and rotor blades to contact the ground. The main rotor blades then…Jun 13, 1987 · N351 · Substantial damageNTSB DEN87LA150Accident · No injuriesLimited investigationFinal reportCessna A185E · Norwood, COThe plt was circling gnd psnl at 300 to 500 ft AGL, banking up to 60 deg, when the eng quit. An eng restart was successful; however, the acft was too low to recover & it collided with a fence. After hitting the fence, the acft crashed to the gnd & was…Jun 13, 1987 · N5836J · Substantial damageNTSB SEA87LA118Accident · Minor injuriesLimited investigationFinal reportBell 47G-3B-2 · Milton-Freewatr, ORThe pilot was hovering up rising terrain at a slow airspeed, at 15 feet above the ground while on an agricultural spraying flight and encountered settling with power. The aircraft entered an uncontrolled descent and impacted the ground.Jun 12, 1987 · N2219W · Destroyed