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 MKC84LA163Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Carlisle, ARA ttl loss of pwr occurred during the second swath run. Plt made forced landing in a rice field containing aprx 6 to 7 inches of water at which time the acft nosed over. Plt stated water was found in the carburetor after the accident. Acft was fueled before…Jun 8, 1984 · N6704Z · Substantial damageNTSB MIA84LA180Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Cocoa Beach, FLThe plt was flying low & dropping leaflets in the vicinity of a graduation crowd at a high school. During a maneuvering turn, the acft fell 'from the sky' & crashed in a canal. According to witnesses, the acft was 'low & slow' when it started to turn prior to…Jun 8, 1984 · N2493E · Substantial damageNTSB NYC84LA204Accident · No injuriesLimited investigationFinal reportHughes 500D · Bedford, PAAccording to the plt, the helicopter took off with under 200 lbs of fuel indicating on the fuel gage. Fifteen minutes after takeoff at 125 ft AGL the engine out warning system indicated an engine failure. The acft began to rotate about its vetical axis and…Jun 7, 1984 · N5106Y · Substantial damageNTSB MIA84LA179Accident · No injuriesLimited investigationFinal reportBell 47G-5 · Jupiter, FLThe acft crashed landed after a partial loss of power. During an exam of the eng, the compressor bleed control valve was found stuck open causing an improper fuel/air mixture.Jun 7, 1984 · N1201W · Substantial damageNTSB MKC84LA158Accident · No injuriesLimited investigationFinal reportSchweizer G164B · Ellinwood, KSWhile the plt was spraying a field of soybeans, the right main gear of the acft hit an irrigation sys that he had been crossing. The right main gear was torn off, but the acft continued to fly. During the landing on a sod arpt, the prop dug in & the acft…Jun 3, 1984 · N6618Q · Substantial damageNTSB NYC84FGM04Accident · No injuriesFinal reportHiller UH-12E · Sigel, PAThe plt was on an aerial application flt over a wooded area. According to him, he had a tail rotor problem & it was necessary to extend his glide to reach an open area. Subsequently, the helicopter landed hard & the main rotor blades struck & severed the tail…Jun 2, 1984 · N109EH · Substantial damageNTSB MKC84LA159Accident · No injuriesLimited investigationFinal reportCessna A188B · Campbell, NEDuring a forced landing in a milo field, the spray bar caught in the crop, causing the acft to pitch nose down before coming to a stop, damaging the wings and propeller.Jun 2, 1984 · N70042 · Substantial damageNTSB LAX84LA336Accident · No injuriesLimited investigationFinal reportStarduster II · Half Moon Bay, CAThe plt said he encountered wind shear at 700 ft AGL, lost control & landed in a field. The plt subsequently walked to a friend's house next to the field to report the occurrence.Jun 2, 1984 · N19PS · Substantial damageNTSB LAX84LA329Accident · Minor injuriesLimited investigationFinal reportBell 206 · Allegheny, CAThe plt was delivering supplies from a mountain site to a river work site. He stated that on his 10th & last flt, the wind caused the helicopter & external load combination to shift laterally. At that time, the load/line became entangled in a tree. The…Jun 2, 1984 · N9722R · Substantial damageNTSB ATL84LA192Accident · Serious injuriesLimited investigationFinal reportBellanca 7GCBC · Tunica, MSThe non-rated plt stated that during a local flt, he flew over a water well drilling operation to survey the area. He reported that he circled at 500 ft 'indicate'. After surveying the area, he initiated a climb, but the eng lost power. Shortly after that,…Jun 2, 1984 · N4211Y · Substantial damageNTSB ANC84FA080Accident · 2 fatalField investigationFinal reportCessna 180G · Tyonek, AKTaking off from an abandoned road near a fishing camp, the Cessna turned back and descended with power on over his departure point, heading into the sun which was low on the horizon. It collided left wing to left wing with the Maule which had climbed out at a…Jun 2, 1984 · N4708U · 2 aircraft · DestroyedNTSB FTW84LA263Accident · 1 fatalLimited investigationFinal reportRockwell A-9B · Maringouin, LAThe plt was completing the first swath pass attempting to fly under a power line and between a tree and parked farm equipment. In a slight left turn under the power line, the right wing contacted tree tops aprx 30 ft AGL. The acft continued aprx 150 yards…Jun 1, 1984 · N7252V · DestroyedNTSB MKC84FA155Accident · 1 fatalField investigationFinal reportPiper PA-38-112 · Hills, IAThe acft impacted the ground in a 90 degree bank with the nose down about 20 degrees. The acft had been seen in a seriesof low alt dives and climbs. On this last climb over the trees a witness saw a wing suddenly drop and the acft disappear behind the trees.…May 31, 1984 · N2364D · DestroyedNTSB FTW84LA257Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Ripley, OKAcft contacted three unmarked transmission power lines which crossed the cimarron river. The plt was flying over the river trying to locate a field which was to be sprayed. The acft then crashed on nearby river bed.May 31, 1984 · N731KU · Substantial damageNTSB MKC84LA154Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Stuttgart, ARWhile the plt was spraying rice, the left main gear of the acft struck a levee of a rice field & separated. The plt then proceeded to a nearby field for a landing. After a slight landing roll on soft terrain, the acft nosed over.May 30, 1984 · N937X · Substantial damageNTSB MKC84LA153Accident · Minor injuriesLimited investigationFinal reportHiller 12E · Bedford, IAThe plt had made two swath runs & was descending to begin the third. He stated that the turn was downwind & as he approached the level-off altitude he encountered a downdraft. The acft impacted the ground & rolled over. The plt also stated that the downdraft…May 29, 1984 · N2726C · Substantial damageNTSB DEN84FU006Accident · 1 fatalFinal reportWeedhopper B · Beresford, SDThe ultralight was observed flying when it suddenly nosed down and crashed. One witness said he thought he heard the engine quit running before the nose down. The acft impacted in a vertical nose down attitude. Investigation showed that the pistons were…May 29, 1984 · UNREG · DestroyedNTSB ANC84FA078Accident · 3 fatalField investigationFinal reportCessna 150L · Nome, AKNumerous witnesses observed the acft flying at low alt & behaving in an erratic manner. According to 3 witnesses, the plt buzzed persons fishing on a local river, an occupied roadhouse & vehicles on 2 roadways. Subsequently, the acft crashed on soft terrain…May 29, 1984 · N17024 · DestroyedNTSB MIA84FU005Accident · 1 fatalFinal reportEipper Quicksilver GT · Lithia, FLThe ultralight crashed in the backyard of a friends house as the plt circled at low alt while waving and shouting to be seen. The acft appeared to witnesses to stall before falling on the right wing to the ground from about 50 ft AGL. The engine continued to…May 28, 1984 · UNREG · DestroyedNTSB LAX84LA326Accident · No injuriesLimited investigationFinal reportAerotek Pitts Special S-1S · Piru, CAPlt was performing aerobatic manuevers in a designated practice area at an altitude of 2500 ft AGL. The plt stated that he performed a 'tail slide' maneuver and the engine stopped which 'is a normal engine response for the maneuver.' The plt was unable to…May 28, 1984 · N608BC · Substantial damageNTSB LAX84LA318Accident · Minor injuriesLimited investigationFinal reportBell 47G-2 · Woodland, CAAccording to the plt, the acft encountered a local whirlwind during a 90/270 ag maneuver & crashed.May 28, 1984 · N94218 · DestroyedNTSB MKC84FA147Accident · 1 fatalField investigationFinal reportHughes 369D · Kearney, NEDuring return to arpt from a local flight, the plt diverted to observe property of a personal friend, located along a river bank. The plt was making a right turn about 200 ft AGL at 40 to 50 KTS airspeed when vibration was felt in the anti-torque pedals & the…May 27, 1984 · N5102Z · Substantial damageNTSB FTW84FA244Accident · Serious injuriesField investigationFinal reportBell 206B · San Antonio, TXIn a left orbit the helicopter yawed right and continued the right rotation to impact. At the time of the loss of control the acft was operating out of ground effect at 250 ft AGL with a density alt of 3751 ft and an indicated airspeed of 20 to 25 KTS. The…May 27, 1984 · N102CD · DestroyedNTSB LAX84FA315Accident · Serious injuriesField investigationFinal reportBölkow Phoebus A-1 · Llano, CACircling in lift near a high ridge the sailplane encountered what the plt referred to as wind shear. Losing control, the sailplane collided with a tree before impacting the ground.May 26, 1984 · N7700 · DestroyedNTSB FTW84LA253Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Kinder, LAThe plt reported after the accident that he was dispensing fertilizer and had just flown through a heavy rain shower when the engine began to lose power. A forced landing was made in a flooded rice field and the acft nosed over. The pilot stated that he was…May 26, 1984 · N9693 · Substantial damageNTSB DEN84FA161Accident · 1 fatalField investigationFinal reportLet L-13 · Edgewood, NMWitnesses reported that the acft appeared to be too high, too fast, and in a crab as it approached the rwy. Over the rwy the glider was observed to roll into a right turn as the nose came up. Shortly thereafter the right wing struck 3 parked acft and collided…May 26, 1984 · N48032 · DestroyedNTSB ATL84LA186Accident · No injuriesLimited investigationFinal reportBellanca 8KCAB · New Bern, NCThe plt was performing a low level fly-by simulating an inexperienced flyers erratic maneuvers when the acft fell vertically to the ground and bounced into a fence before it came to rest in a field. The plt said he hit a down draft at a tree line. The fly-by…May 26, 1984 · N5030J · Substantial damageNTSB MKC84FA146Accident · 2 fatalField investigationFinal reportCessna 150H · Camdenton, MOWitnesses observed the acft flying low over a lake. As it approach the home of the plt's parents, the acft's wings moved as though waving, then the acft entered a steep climb. After reaching its maximum height from the pull-up, the acft rolled into a steep…May 25, 1984 · N7192S · DestroyedNTSB ATL84FA183Accident · Serious injuriesField investigationFinal reportCessna 152 · Piedmont, ALThe plt reported that prior to flying, he had 2 mixed drinks which contained alcoholic beverage. The flt originated at talledega, AL. The plt then flew to anniston, AL, where he landed. From there he flew to jacksonville & centre, where he made touch-&-go…May 24, 1984 · N48767 · Substantial damageNTSB MKC84LA144Accident · No injuriesLimited investigationFinal reportEnstrom F-28C · Louisville, NEAccording to the plt, the helicopter was involved in a ground search with a non-trained pax in the right seat. With the pax flying the acft in a hover the right skid contacted the muddy terrain causing the acft to roll over.May 23, 1984 · N51792 · Substantial damageNTSB MKC84LA143Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Silver Creek, NEThe plt stated he was making an end pass while spraying a pasture & collided with a hilltop on the opposite side of a draw. This occurred while the sun was obstructing his vision.May 23, 1984 · N6677Q · Substantial damageNTSB MIA84FA170Accident · 2 fatalField investigationFinal reportPiper PA-38-112 · St.Petersburg, FLAccording to witnesses, the plt did at least one complete roll prior to the accident. They stated that after rolling at about 100 ft above the water & parallel to the beach, the acft appeared to bank very steeply to the left, then pitch down into the water.…May 23, 1984 · N2552A · DestroyedNTSB LAX84LA311Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Williams, CAShortly after departing the airfield, the eng lost power & the plt was unable to restart it. He landed in a soft, freshly plowed field. After rolling about 50 ft, the acft nosed over. An exam revealed that the shaft which holds the float assembly in the…May 23, 1984 · N5368 · Substantial damageNTSB NYC84FA180Accident · 1 fatalField investigationFinal reportBeech D-45 · Taunton, MAN812Z crashed in a wooded area about one mile southeast of the Taunton municipal airport. Witnesses in the area observed the acft prior to the crash. One witness saw what appeared to be yellow smoke coming from the bottom of the acft. Some of the witnesses…May 22, 1984 · N812Z · DestroyedNTSB LAX84LA313Accident · No injuriesLimited investigationFinal reportCessna 172N · Ballard, CAThe pilot of N73857, a Cessna 172 and the pilot of N521ST, a Cessna 305 arranged prior to the flight to fly a 'missing man' formation with two other aircraft. The plt of N73857 was instructed to fly to the left rear of the lead acft, N521ST. The pilot of…May 22, 1984 · N73857 · 2 aircraft · Minor damageNTSB ATL84LA182Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Jacksonville, ALAccording to the instructor (CFI), he & the student were practicing base-to-final turns as they were returning to the arpt. He reported that the acft was flown at about 60 KTS with 20 deg of flaps at appx 800 ft AGL. He stated that the student steepened the…May 22, 1984 · N46910 · Substantial damageNTSB ANC84FA074Accident · 2 fatalField investigationFinal reportPiper PA-18 · Sleetmute, AKAccording to witnesses, the plt made 3 low passes at some boats in Sleetmute slough. They estimated the passes were at 5 to 10 ft above the water, then the plt would pull up in a steep climb attitude, execute a 180 deg turn and make another pass. After the…May 22, 1984 · N1378C · Substantial damageNTSB ANC84FA073Accident · 2 fatalField investigationFinal reportPiper PA-18-150 · Platinum, AKThe herring season was to open at 1600 hrs. According to witnesses, about 30 acft were circling in left turns over merging schools of herring while the plts & their respective boat crews were awaiting the opening signal. The acft were circling under a low…May 21, 1984 · N82454 · 2 aircraft · DestroyedNTSB LAX84LA303Accident · Serious injuriesLimited investigationFinal reportPiper PA-32RT-300 · Avalon, CAThe plt flew to catalina island, then flew northwest along the north side of the island. He stated that he then made a climbing left turn over the island from about 500 ft MSL, but encountered a downdraft at 1000 ft MSL, which slowed the acft below the…May 20, 1984 · N30298 · Substantial damageNTSB DEN84FU005Accident · 1 fatalFinal reportEipper Quicksilver MX · Peyton, COThe ultralight was flying in formation with 2 other craft. The accident plt was seen by one of the other two plts to descend to a low alt over a creek bed and then pull up abrultly to climb over a power line. The landing gear collided with the wires and the…May 20, 1984 · UNREG · DestroyedNTSB CHI84LA184Accident · Serious injuriesLimited investigationFinal reportBell 47D1 · Alpena, MIPrior to the accident, the owner/plt of the helicopter reportedly 'buzzed' a local baseball game. Shortly after that, the helicopter was observed to maneuver over a wooded area, enter a nose high attitude, then roll or bank & enter a descent into a wooded…May 20, 1984 · N9158R · DestroyedNTSB SEA84FA110Accident · 1 fatalField investigationFinal reportRockwell S-2R · American Falls, IDThe load/ground crew reported that the plt planned to make 1 more spray run before flying back to the home base. When the acft did not return to the loading area, they assumed he had returned to the base. They drove 20 mi back to the base, but found neither…May 19, 1984 · N4865X · Substantial damageNTSB NYC84FIG02Accident · Serious injuriesFinal reportCessna 172 · Elkton, MDThe acft was flown over the field at low alt in an attempt to pick up an AD banner. The acft had dived in a shallow angle from 300 ft to perform the pick-up. The banner was missed by the plt who climbed away in a steep ascent until he entered a hammerhead…May 19, 1984 · N8323B · Substantial damageNTSB LAX84FU028Accident · Serious injuriesFinal reportPioneer FLT Star · Elk Grove, CAThe ultralight was on a solo training flt when the engine stopped as the vehicle passed over the rwy. The student made a shollow bank to the right and descended into an adjacent field where she and the vehicle collided with some bales of hay. The student had…May 19, 1984 · UNREG · Substantial damageNTSB MKC84LA140Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Dubuque, IAWhile manuevering over a university a ttl loss of pwr was experienced. Attempts to restart the engine failed. The plt made a hard forced landing which resulted in substantial damage. Inspection of the engine did not reveal any mechanical failure/malfunction.May 18, 1984 · N2390A · Substantial damageNTSB LAX84LA309Accident · Serious injuriesLimited investigationFinal reportCessna 172RG · Lakeside, AZThe plt was unable to clear rising terrain after a low pass for a photo. The density alt was about 8700 ft.May 18, 1984 · N9700B · DestroyedNTSB LAX84LA298Accident · Minor injuriesLimited investigationFinal reportCessna P210N · Ramona, CAAs part of an experimental test flt in the turbine powered acft, intentional spins were performed. The planned one turn spin evolved into a flat spin. Recovery procedures were ineffective and the plt elected to deploy the anti-spin parachute. Despite repeated…May 18, 1984 · N4772K · DestroyedNTSB SEA84LA109Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Craigmont, IDDuring aerial application the engine lost power & a forced landing was initiated to a wheat field. During the landing approach the acft stalled at about 10 to 20 feet AGL. The acft landed hard and flipped over. Examination of the engine revealed a broken…May 17, 1984 · N48373 · Substantial damageNTSB FTW84LA240Accident · No injuriesLimited investigationFinal reportRockwell S2R · Alexandria, LAThe acft collided with a static wire between two electrical poles while maneuvering during aerial application. Control was maintained and the acft returned to the airport and landed without futher incident.May 16, 1984 · N5641X · Substantial damageNTSB DEN84LA151Accident · Serious injuriesLimited investigationFinal reportCessna A185F · Grand Junction, COThe plt-in-command (PIC) was checking out another plt on a pipeline route. The copilot was occupying the left seat & was flying the acft. While surveying the pipeline, they proceeded north up a canyon toward Douglas pass. No turbulence & little effect from…May 16, 1984 · N714PM · Destroyed