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 FTW88DRD18Accident · Serious injuriesFinal reportGrumman G-164A · Rayne, LAAt the end of a swath run, the ag pilot pulled the airplane up and to the left to start a turn-around. The upper left wing struck a steel guy-cable of a 300 foot tower. The airplane made several turns of an inverted flat-spin before water impact into an eight…Aug 14, 1988 · N979X · Substantial damageNTSB FTW88DRD17Accident · No injuriesFinal reportSchweizer G-164A · Mangham, LAThe ag airplane was spraying cotton when the engine started to vibrate. Pilot pulled airplane up and vibration was so bad power had to be reduced. Pilot made a forced landing in a muddy field. The left wing caught in tall grass and airplane cartwheeled. Pilot…Aug 14, 1988 · N7234 · Substantial damageNTSB ATL88DKG17Accident · No injuriesFinal reportIntermountain Mfg. Callair A-9 · Redbud, GAAug 13, 1988 · N7233V · Substantial damageNTSB SEA88LA150Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Leavenworth, WAThe PIC reported that during a practice helicopter autorotation to a power recovery, the pilot under instruction held the flare too long. The helicopter's tail guard and tail rotor struck the ground and the aircraft began to spin. The PIC reduced the throttle…Aug 10, 1988 · N62404 · Substantial damageNTSB CHI88DEX11Accident · 1 fatalFinal reportContinental Copters MK-5 · Redkey, INPhysical impairment of the pilot due to drugs which resulted in a misjudged approach and subsequent contact with trees during the approach to an aerial application swath run.Aug 10, 1988 · N25561 · DestroyedNTSB ATL88DKG12Accident · No injuriesFinal reportCessna 188B · Bainbridge, GAAug 10, 1988 · N731UH · DestroyedNTSB ANC88LA107Accident · 2 fatalLimited investigationFinal reportArtic S-1B2 · Kotzebue, AKThe airplane crashed at 2700 feet m.s.l. in a box canyon while maneuvering at low level & scouting for sheep. The top of the ridge was approximately 3200 feet m.s.l. the investigation revealed that the pilot was trying to outclimb the ridge when the airplane…Aug 10, 1988 · N58AT · Substantial damageNTSB MKC88DCA02Accident · Serious injuriesFinal reportCallair A-9A · Rush Hill, MOAbout 25 minutes after sunset, the airplane struck a powerline and pole during a spray run. The airplane struck the ground inverted.Aug 9, 1988 · N7735V · Substantial damageNTSB ATL88DKG13Accident · No injuriesFinal reportGrumman G-164A · Fadette, ALThe pilot reported a partial power loss during an aerial application flight. The aircraft landed in the crops. The pilot stated that he found the number 3 cylinder partially separated from the engine.Aug 9, 1988 · N8573H · Substantial damageNTSB SEA88LA148Accident · No injuriesLimited investigationFinal reportWeatherly 620 · Wilbur, WAThe pilot reported that an engine power loss occurred during an aerial application maneuver. The pilot made a forced landing in rough terrain. Examination of the engine revealed deteriorated seals in the engine driven fuel pump. Exam of the electric fuel pump…Aug 8, 1988 · N4603G · Substantial damageNTSB MKC88DCD03Accident · 1 fatalFinal reportPiper PA-25-235 · Eldora, IAPilot was spraying a bean field when a witness saw his aircraft strike the ground. The aircraft then climbed to approximately 200 feet and leveled off. It then began a gentle climb, then entered a spin and desended into the ground. Examination of the aircraft…Aug 8, 1988 · N9612P · Substantial damageNTSB CHI88FA192Accident · 1 fatalField investigationFinal reportAeronca 7AC · Pierz, MNPilot failed to maintain adequate control of the aircraft while maneuvering at a low altitude, resulting in a stall and collision with the ground. A factor contributing to the accident was the pilot's lack of recent flight experience and training.Aug 7, 1988 · N3001E · DestroyedNTSB CHI88DET04Accident · No injuriesFinal reportCessna A188B · Preu, INAerial applicator experienced total failure of throttle cable during application swath run. Aircraft received substantial damage when pilot executed forced landing in adjacent crop field. Aircraft and engine had received annual inspection 125 hours prior to…Aug 7, 1988 · N5550G · Substantial damageNTSB CHI88DER07Accident · 2 fatalFinal reportChampion 7CCM · Int'L Falls, MNThere were no eyewitnesses to this accident. The aircraft with an instructor and student aboard was reported missing. When located the seaplane had descended into a wooded swamp and the aircraft was substantially damaged and both occupants received fatal…Aug 6, 1988 · N1744E · DestroyedNTSB NYC88LA209Accident · No injuriesLimited investigationFinal reportBell 47G3B-1 · Oakland, MEDuring an aerial photography flt, the pilot was maneuvering at 30 ft, at 25 mph and making a right turn over a lake when the nose of the helicopter swung to the right unexpectedly. He stated that 'when the aircraft entered the unexpected swing to the right I…Aug 5, 1988 · N6286N · DestroyedNTSB CHI88DET05Accident · No injuriesFinal reportBell 47J · Dowagiac, MIFailure to maintian adequate rotor RPM by the unqualified pilot.Aug 5, 1988 · N2838B · Substantial damageNTSB SEA88LA143Accident · Minor injuriesLimited investigationFinal reportBell UH-1E · North Bend, ORDrg a logging opn, the plt noted an apparent transmission malfunction. An autorotative landing was made on unprepared terrain & the helicopter was damaged. An investigation revealed the tail rotor drive input gear in the 42 deg gearbox had failed from…Aug 4, 1988 · N151LC · Substantial damageNTSB NYC88DGM01Accident · 1 fatalFinal reportHiller UH-12E · Lovely, PAThe undetermined loss of engine power while performing low level aerial application operations.Aug 4, 1988 · N5375V · Substantial damageNTSB FTW88LA143Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Dalhart, TXAs the ag airplane tried to level off at the start of the spray run, it continued the descent into the corn and flipped forward to the inverted position. The elevation in the area was 4100 ft MSL and the density altitude was 5000 ft.Aug 4, 1988 · N9248R · DestroyedNTSB LAX88DUM06Accident · No injuriesFinal reportHiller UH12E · Bard, CADuring helicopter aerial application, engine power was lost. Plt applied back cyclic and tail rotor contacted terrain, followed by hard landing. Investigation revealed less than useable fuel remaining.Aug 3, 1988 · N14633 · Substantial damageNTSB CHI88DEV04Accident · No injuriesFinal reportGrumman G164A · Chenoa, ILUnavailability of suitable terrain on which to accomplish a forced landing.Aug 3, 1988 · N8980H · Substantial damageNTSB ATL88LA225Accident · No injuriesLimited investigationFinal reportChampion 7GCAA · N. Myrtle Beach, SCThe plt reported that he made a low pass over the banner staging area to drop a banner; the release mechanism in the cockpit failed to operate and the banner remained in tow. Xwind conditions blew the banner into another banner on the ground which was…Aug 3, 1988 · N9692S · Substantial damageNTSB ATL88DLT01Accident · 1 fatalFinal reportVan RV-4 · Ashland City, TNAug 3, 1988 · N223RD · DestroyedNTSB MKC88LA148Accident · Minor injuriesLimited investigationFinal reportRockwell S-2R · Tarry, ARThe pilot said the engine quit abrubtly during an aerial application turn around maneuver. He attempted to land in a nearby farm field and because of the soft terrain conditions, the acft nosed over during the roll out. Post accident investigation revealed a…Aug 2, 1988 · N3682X · Substantial damageNTSB MKC88LA146Accident · Minor injuriesLimited investigationFinal reportVarga 2150A · Washington, IAWhile enroute the PIC rptd a loss of eng pwr. The PIC stated in his rpt that having passed Washington, IA, he switched fuel tanks to draw fuel from the lft tank which indicated 1/2 full. Shortly after switching, the PIC stated the tank went empty. The PIC…Aug 2, 1988 · N8259J · Substantial damageNTSB LAX88FA278Accident · 1 fatalField investigationFinal reportCessna T-210 · Brea, CAAug 2, 1988 · N79Y · DestroyedNTSB BFO88LA070Accident · No injuriesLimited investigationFinal reportCessna 150K · Selbyville, DEThe plt was in the process of picking up a banner when the aircraft stalled and crashed into a wooded area. The banner was picked up at an airspeed of 80 mph and the acft altitude was increased to 250 ft AGL. The pilot reported that the wings of the acft…Aug 1, 1988 · N5682G · Substantial damageNTSB LAX88FA277Accident · 1 fatalField investigationFinal reportCessna 414A · Big Pine, CAThe pilot intentionally flew over an area of high terrain in which he failed to maintain the proper altitude and he delayed his decision to reverse course. A contributing factor was the pilot's improper in-flight decision.Jul 31, 1988 · N414YV · DestroyedNTSB SEA88FA140Accident · 3 fatalField investigationFinal reportCessna 185 · Liscome Bay, AKWhile in a narrow, tree-lined area just above a small cove, the pilot lost control of the aircraft while maneuvering, in preparation for a landing on a lake. The aircraft struck trees in-flight while in an unusual attitude and then struck the water. Poor…Jul 30, 1988 · N70168 · DestroyedNTSB MKC88DPG02Accident · 2 fatalFinal reportSnow 600-S2C · Almyra, ARTwo ag aircraft were spraying the same field. According to several witnesses, 1671S was heading south and 3660X was heading east. Both aircraft were actively engaged in the spraying operation but did not seem to the witnesses to be coordinating with each…Jul 30, 1988 · N1671S · 2 aircraft · DestroyedNTSB ATL88DKG11Accident · Minor injuriesFinal reportPiper PA-25-235 · Climax, GAJul 30, 1988 · N4880Y · Substantial damageNTSB DEN88LA169Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Forsyth, MTJul 29, 1988 · N3290B · Substantial damageNTSB MKC88LA141Accident · No injuriesLimited investigationFinal reportRockwell S2R · O'Kean, ARWhile performing an aerial application operation, the plt said he experienced a total powerplant failure. He attempted an emergency ldg in a cultivated rice field. During the ldg attempt, the aircraft sustained substantial damage to the propeller, landing…Jul 28, 1988 · N3665X · Substantial damageNTSB CHI88DER05Accident · Minor injuriesFinal reportVans RV-3A · Walker, MNThe pilot reported that after making a low level pass over a lake, he attempted to climb to pattern altitude in preparation for landing at a nearby airport. When the climb was initiated, the aircraft did a loop and the plt lost control. The acft subsequently…Jul 27, 1988 · N9WL · Substantial damageNTSB LAX88DVA09Accident · Serious injuriesFinal reportStephenson U-2 · Porterville, CADuring a pleasure flight, while soaring with the engine at idle, the flying wing motor glider inadvertently entered a stall. The pilot did not recover from the stall and the airplane began to spin. The pilot was able to regain control at approximately 50 feet…Jul 26, 1988 · N9192V · DestroyedNTSB MKC88LA136Accident · No injuriesLimited investigationFinal reportCessna 152 · Underwood, IAThe CFI and student were performing maneuvers near Underwood, IA as part of 14 CFR 61 stu pilot trng. The acft was flown for abt 1/2 hr, prior to the CFI taking control of the acft when the stu experienced a loss of eng pwr during recovery fm a maneuver. The…Jul 25, 1988 · N69240 · Substantial damageNTSB FTW88DRD16Accident · No injuriesFinal reportPZL-Mielec M18 · Bastrop, LAThis ag airplane has a hydraulic system that operates the brakes and flaps. The engine driven hydraulic pump provides pressure to the primary system for normal use and also provides pressure to an accumulator for emergency use. The pressure in the accumulator…Jul 24, 1988 · N46831 · Substantial damageNTSB CHI88DER04Accident · No injuriesFinal reportPiper PA-25 · Elbow Lake, MNThe pilot was practicing low level flight in preparation for his certification under 14 CFR 137 when the aircraft experienced a collision with wires. The aircraft was substantially damaged during this collision and the subsequent collision with trees and the…Jul 24, 1988 · N6590Z · Substantial damageNTSB NYC88LA191Accident · Serious injuriesLimited investigationFinal reportBellanca 7GCAA · Pendleton, NYLoss of control of the aircraft after the pilot had hooked the banner.Jul 23, 1988 · N53784 · Substantial damageNTSB LAX88DUM05Accident · No injuriesFinal reportAir Tractor AT-301 · Niland, CAJust after takeoff, the pilot made a right turn to locate the ground flaggers and to avoid transmission wires. The pilot, unable to locate the flaggers, initiated a climb to avoid wires and rising terrain. However, the airplane did not gain sufficient…Jul 22, 1988 · N8719S · Substantial damageNTSB LAX88DUJ06Accident · No injuriesFinal reportGrumman G-164B · Chandler, AZDuring an aerial application flight, the engine experienced a loss of power. A forced landing was made in an open field and during the landing roll the airplane nosed over. Inspection of the engine revealed that the number five cylinder dome separated from…Jul 22, 1988 · N66890 · Substantial damageNTSB ATL88LA218Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Somerville, TNThe CFI was attempting a demonstration of a forced landing following a simulated loss of engine power. Just as he started to recover and climb back to altitude, the student plt spotted wires and yelled. Company policy required a recovery at 500 ft. the…Jul 22, 1988 · N757YP · Substantial damageNTSB CHI88DEE07Accident · No injuriesFinal reportHughes 269C · Sandwich, ILThe plt rprtd that while he was conducting spraying opns, he noted a significant loss of eng power. He made a run-on landing in a bean field. As he landed, the left skid dug into a furrow & the helicopter rolled over. During the investigation, which included…Jul 21, 1988 · N7425F · Substantial damageNTSB SEA88LA134Accident · Minor injuriesLimited investigationFinal reportCessna 180K · Eastsound, WAPlt was cruising at 200 feet over the water, looked down to get a chart under his seat and collided with the water.Jul 20, 1988 · N2748K · DestroyedNTSB LAX88FA264Accident · 1 fatalField investigationFinal reportBeech 76 · Portola Valley, CAWhile dining with friends with whom he resided, the pilot told them that he was 'going flying'. At the completion of the flight he would fly over the house before he returned to palo alto airport (pao). The pilot twice circled the residence which is abt 7…Jul 20, 1988 · N2074M · DestroyedNTSB ANC88LA093Accident · No injuriesLimited investigationFinal reportCessna 185 · Bettles, AKThe pilot reported that the aircraft ran out of fuel approximately 25 miles from the airport. The aircraft crashed into a wooded area. The pilot stated that both fuel indicators were indicating at or near empty at the time of the accident.Jul 20, 1988 · N93769 · Substantial damageNTSB DEN88LA163Accident · No injuriesLimited investigationFinal reportEnstrom 280C · Glendive, MTJul 19, 1988 · N111CD · Substantial damageNTSB NYC88FA185Accident · 1 fatalField investigationFinal reportBellanca 7KCAB · Egg Harbor Twsp, NJThe Bellanca was maneuvering and had hooked up with a banner, when control was lost and it impacted the ground. Witnesses said the aircraft was at full power when it went into a nose high attitude and stalled to the right. After impact with the ground the…Jul 18, 1988 · N86628 · DestroyedNTSB MKC88LA131Accident · No injuriesLimited investigationFinal reportRockwell S2R · Swifton, ARThe PIC was conducting ag-spray maneuvers dispensing liquid fertilizer to rice. During a procedure turn to return to the field the eng quit. The PIC chose an open field abt 60 degrees to his rt to land the aircraft. The field was wet, soft and rough. The acft…Jul 18, 1988 · N8441V · Substantial damageNTSB MIA88LA225Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Clewiston, FLThe plt stated the fuel gages indicated 20 gals when he took off on spraying flt. He had just completed the spray run & started to pull up from about 10 ft & 25 mph. At that time the eng quit '& sounded just like it would if it ran out of gas'. There was not…Jul 18, 1988 · N108HA · Substantial damage