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 LAX86FVD06Accident · Minor injuriesFinal reportCallair A-9B · Lodi, CAPilot was returning to Lodi airport after aerial application when the engine lost oil pressure. The engine seized, and a forced landing was made in a vineyard.Mar 8, 1986 · N7688V · DestroyedNTSB SEA86FA073Accident · 1 fatalField investigationFinal reportAerospatiale SE 318C · Siletz, ORThe plt unsuccessfully attempted to lift a 1597 lb load of cedar blocks which would have placed the helicopter aprx 880 lbs over its max gross weight with an external load. The plt was setting the load down for ground personnel to unload some of the blocks…Mar 7, 1986 · N4966 · DestroyedNTSB FTW86LA041Accident · Minor injuriesLimited investigationFinal reportHughes 369D · New Boston, TXThe pilot experienced a tail rotor drive shaft flexible coupling failure when he pulled collective pitch to come to a hover before landing. The helicopter entered an uncontrollable right spin. During his haste to get the helicopter on the ground the pilot…Mar 7, 1986 · N58420 · Substantial damageNTSB ATL86MA087Accident · 1 fatalMajor investigationFinal reportPiper PA-32-300 · Andalusia, ALThe accident flt was to be the last in a series of flt tests. This flt was for the purpose of determining the landing characteristics of the acft with a combination speed/stol kit installed. When the FAA flt test plt failed to return from the mission a search…Mar 7, 1986 · N1099X · DestroyedNTSB LAX86FVD07Accident · No injuriesFinal reportBell 47G-2 · Stockton, CAThe pilot was making a slow pass and dragged one spray boom on the ground. Insufficient airspeed resulted in loss of control. Helicopter crashed.Mar 6, 1986 · N6727D · DestroyedNTSB LAX86FA131Accident · 3 fatalField investigationFinal reportPiper PA-28-181 · Newport Beach, CAThe acft was rprted to be on a dual, night recurrent, training flt. The student plt's wife rprtd that the flt instructor(CFI) & her husband had been drinking beer before they & the passenger (another student plt) departed on the flt. Ground witnesses observed…Mar 3, 1986 · N81918 · DestroyedNTSB ATL86FA084Accident · Minor injuriesField investigationFinal reportBell B-214-B-1 · Bullard, GAA helicopter involved in a logging operation was in process of lifting a log when crew reported a 'loud explosion' and a loss of power was experienced. An autorotative landing was accomplished and a small engine fire was extinguished. The 1st stage turbine…Mar 3, 1986 · N114RM · Substantial damageNTSB LAX86FUG04Accident · No injuriesFinal reportRotorway Scorpion 133 · Corona, CAThe plt stated he was 'running up the engine' after making some adjustments. The helicopter was tied down when the plt lifted off to a 5 to 6 ft hover. The helicopter tipped to the right, the main rotor blades contacted the terrain and the helicopter rolled…Mar 2, 1986 · UNREG · DestroyedNTSB FTW86LQG12Accident · No injuriesFinal reportPiper PA-36-300 · Muleshoe, TXThe ag acft was climbing after a pass to clear power lines at the north end of the field. The main lndg gear contacted the top wire as the acft started leveling off. The wire did not break and the acft descended to ground impact. The lndg gear snapped off and…Feb 28, 1986 · N57878 · Substantial damageNTSB LAX86LA231Accident · Serious injuriesLimited investigationFinal reportBell 47G-5 · Castaic, CAThe helicopter collided with unmarked wires while heading into sun during spraying operation. Plt does not recall seeing or hitting wires.Feb 27, 1986 · N7802S · Substantial damageNTSB LAX86FUA01Accident · No injuriesFinal reportBeech J35 · Long Beach, CAThe acft collided with an object in flt. The plt reported that his right wing had been struck by what he thought was a large bird. After a safe landing at nearby Long Beach arpt the acft was examined. The rt wing had a hole aft of the leading edge and…Feb 27, 1986 · N7293B · Substantial damageNTSB MIA86LA084Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Homestead, FLThe plt stated that she had completed one spray pass with one ton of fertilizer aboard & pulled up in a turn to about 200 ft. at that time the acft 'hit a pocket of dead air.' The acft nosed down and although the plt dumped the chemical load, she could not…Feb 24, 1986 · N3629J · Substantial damageNTSB MIA86LA083Accident · Serious injuriesLimited investigationFinal reportCessna T188C · Greenwood, MSThe plt stated that during an aerial application swath run, he struck a group of power lines & crashed into a field.Feb 24, 1986 · N9936J · Substantial damageNTSB FTW86FQG11Accident · No injuriesFinal reportCessna 402B · Plainview, TXThe acft landed gear up after a practice single-eng procedure. The plt attempted a go-around when the landing was aborted due to an improper approach. When the approach proceeded to this point with an intentionally inoperative eng the go-around was not a…Feb 23, 1986 · N4605N · Substantial damageNTSB ANC86LA031Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Houston, AKThe pilot was buzzing the area less than 200 feet above the ground when the engine started to run rough; the pilot attempted to land near the road when the aircraft struck power lines and a row of trees. Examination of the engine revealed no mechanical…Feb 23, 1986 · N1827A · Substantial damageNTSB FTW86LPA19Accident · No injuriesFinal reportCessna 182A · Decatur, TXThe acft was damaged in a collision with a power line during a low pass over a field. The acft was landed off arpt in a field after the collision with the wires. Half the rudder and vert fin were separated, the wing was torn and the prop nicked during the…Feb 22, 1986 · N4071D · Substantial damageNTSB SEA86LA062Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Odessa, WADuring an external load operation to remove groundwire off crossarms, the cable splice jammed in the pulley frame. The helicopters forward motion stopped and it then struck the ground. The pilot said the cargo hook release didn't work but no failures were…Feb 21, 1986 · N8542F · DestroyedNTSB ATL86FA079Accident · 2 fatalField investigationFinal reportCessna 152 · Wilkesboro, NCShortly after midnight the acft was observed flying erratically over the town. IMC existed in the area at the time. The student plt did not have any instrument flight time logged and his pax was not a plt. The acft was in a descending turn when it flew into…Feb 21, 1986 · N93567 · DestroyedNTSB SEA86LA061Accident · Serious injuriesLimited investigationFinal reportPiper PA-15 · Mount St.Helens, WAThe pilot was attempting to fly inside a volcanic crater around the lava dome above 6000 feet m.s.l.. The aircraft has a 75 horsepower engine. High winds entering the crater from the northeast flowing across the lava dome created a downdraft that the aircraft…Feb 20, 1986 · N4521H · DestroyedNTSB LAX86LUG02Accident · 1 fatalFinal reportWhigham GW4A · Hemet, CADuring a tow operation, the plt of the tow plane stated that just after takeoff the glider assumed a very low tow position, then swung very high to the right then to the left. At aprx 250 ft AGL the glider plt released from the tow plane and executed a 180…Feb 20, 1986 · N24GW · Substantial damageNTSB DEN86LA082Accident · Minor injuriesLimited investigationFinal reportAerospatiale SA315B · Meeker, CODuring the lift off the right skid toe of the helicopter caught a seismic cable which was covered by aprx 2 ft of snow. The plt stated he brought the acft to a hover after off loading 2 pax & started a right sideward hover. When the slack was out of the…Feb 20, 1986 · N27387 · Substantial damageNTSB ATL86FKG07Accident · Serious injuriesFinal reportPiper PA-28-180 · Statesboro, GAThe acft collided with the ground after encountering a downdraft over a wooded area at about 500 ft AGL. The plt reported that he flew out to overlook some land from the air. To avoid air traffic in the landing pattern he dropped down to about 550 ft and made…Feb 20, 1986 · N8288W · DestroyedNTSB ANC86LA030Accident · Minor injuriesLimited investigationFinal reportCessna 206 · Delta Junction, AKThe aircraft struck a telephone pole guide wire while maneuvering at a low altitude. The electric company stated that the guide wire was 32 feet above the road surface. The pilot stated that he was low flying less than 50 feet above the ground to review…Feb 20, 1986 · N116ME · DestroyedNTSB DEN86LA079Accident · Minor injuriesLimited investigationFinal reportBell 47G3 B-2 · Grand Junction, COThe plt stated that while turning to the intended landing area, the helicopter he was piloting encountered both downdrafts & tailwind. The plt indicated the helicopter settled until grnd contact.Feb 18, 1986 · N1424W · Substantial damageNTSB MIA86FA080Accident · 2 fatalField investigationFinal reportPiper PA-31-310 · Moore Haven, FLOn February 17, 1986 the wreckage of N7EA along with the skeletal remains of two persons were found. The acft crashed into trees causing the separation of the outboard six feet of left wing and then continued crashing through more trees before colliding with…Feb 17, 1986 · N7EA · DestroyedNTSB ANC86LA028Accident · Serious injuriesLimited investigationFinal reportCessna 182-A · Merrill Pass, AKThe pilot stated that he could see the whiteout condition ahead. During the 180 deg turn the aircraft struck the 3000 foot level of the mountian Pass. At the time of the accident the weather was a complete IFR whiteout condition.Feb 9, 1986 · N3813D · DestroyedNTSB FTW86LA044Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Mcalester, OKThe plt was hearding cattle with the helicopter when the accident occurred. He was traveling slow and parallel with a barbed wire fence. He had to turn to the right to avoid a tree which was directly ahead of the acft. Upon making the turn he caught the tail…Feb 8, 1986 · N8557K · Substantial damageNTSB LAX86LA113Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Lodi, CAWhile on an aerial agricultural spraying flight the acft engine lost total power. The plt executed an immediate autorotation landing. Upon ground contact, the acft skid for about 8 ft until the front skid contacted the ground furrow and nosed over causing the…Feb 7, 1986 · N62421 · Substantial damageNTSB ATL86LA069Accident · Serious injuriesLimited investigationFinal reportHughes 269B · Council, NCDuring a control burning operation, the plt experienced a complete eng failure. The plt entered an autorotation and collided with trees. The eng examination disclosed that the #4 connecting rod had failed. The failure was determined to have resulted from…Feb 4, 1986 · N9374F · DestroyedNTSB LAX86FA106Accident · 1 fatalField investigationFinal reportBell 206B · Young, AZThe plt & his daughter planned to fly to their ranch for the purpose of hiring a manager. Upon arriving at their destination ground fog prevailed. The plt, familiar with the area, attempted to find an area where he could descend below the fog. The fog was at…Feb 3, 1986 · N3193T · DestroyedNTSB DEN86FA070Accident · 2 fatalField investigationFinal reportCessna 152 · Berthoud, COStudent plt rented acft from flying club, acft was observed by witnesses to approach the lake from the south end at a low alt. Acft struck water with right main lnd gear and rt wing tip, and nosed over. The water was described as being 'glassy' and the sun…Feb 2, 1986 · N46193 · Substantial damageNTSB FTW86FPJ05Accident · 1 fatalFinal reportStephenson Teenie TWO · Owasso, OKThe acft descended to ground impact in a steep turn while practicing lazy eight maneuvers. The last turn was very steep at low alt and the acft disappeared behind trees. The plt was reportedly checking the acft's stability for the owner. The ground impact…Feb 1, 1986 · N106TD · DestroyedNTSB DEN86LA072Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Afton, WYThe plt stated he had descended to observe wildlife. When he attempted to add pwr he discovered the eng had quit. The plt indicated the acft wheel contacted the deep snow at a moderate rate of horizontal speed while he was trying to restart the eng.Feb 1, 1986 · N4238Z · Substantial damageNTSB NYC86FA068Accident · 1 fatalField investigationFinal reportBeech E55 · Sunderland, MAWitnesses reported seeing the acft descend vertically in a flat spin until impact in open, flat terrain. The accident occurred aprx 45 min after the plt had taken off on a local proficiency flt. After impact, most of the airframe was demolished by fire. The…Jan 31, 1986 · N6641A · DestroyedNTSB FTW86LRA06Accident · Minor injuriesFinal reportAerospatiale AS-350D · Freeport, TXWhile on a maintenance test flt the helicopter experienced an eng failure. An autorotation was entered and a hard landing occurred which resulted in a roll over. The flt originated at oyster creek heliport and returned twice for maintenance adjustments and…Jan 24, 1986 · N3599X · Substantial damageNTSB SEA86LA043Accident · 2 fatalLimited investigationFinal reportLuscombe 8A · Sloan, NVAcft was observed performing low-level aerobatics, failed to complete pull-out from second consecutive overhead maneuver, striking ground in 20-30 degree nose-low attitude. No evidence of pre-impact mechanical failure or malfunction found in acft structure,…Jan 19, 1986 · N41926 · DestroyedNTSB CHI86FA068Accident · 1 fatalField investigationFinal reportCessna 177RG · Valley View, ILThe plt was conducting a low pass, 40 ft AGL, on a river and struck a power line crossing his flt path. The strike caused loss of control and the acft impacted on the frozen surface of the river.Jan 19, 1986 · N52949 · DestroyedNTSB SEA86FA039Accident · 1 fatalField investigationFinal reportHiller-Soloy UH-12E · Horton, ORThe fork connecting the rotorcraft's blue blade to the main rotor hub separated after a long term fatigue crack had spread through more than 60% of the fork circumference. The operator failed to carry out the appropriate inspection of the fork unit as…Jan 16, 1986 · N40290 · DestroyedNTSB NYC86LA061Accident · No injuriesLimited investigationFinal reportBell 47J2A · Atkinson, NHPilot stated he was attempting to position the Bell 47 helicopter on a small pad. This pad was too narrow to accommodate this acft and the right skid slipped off the platform. The pilot then requested his passenger to deplane. After the pilot determined that…Jan 13, 1986 · N888EN · DestroyedNTSB FTW86FA034Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Deville, LAThe student plt had previously flown this acft in flt training. However, the insurance for the acft had lapsed & the owner had secured the acft to a tie-down with a chain & pad lock to prevent it from being flown. After the chain was cut with a hack saw, the…Jan 13, 1986 · N5655U · DestroyedNTSB FTW86LRD05Accident · Serious injuriesFinal reportBell BH206L-1 · Gulf Of Mexico, LAThe acft descended into the Gulf Of Mexico from a 100 ft AGL hover after the plt lost yaw control downwind of an offshore oil platform in 35 kt winds. As the acft came to a hover it began a turn to the right even though it was headed into the wind. Full left…Jan 9, 1986 · N2653 · Substantial damageNTSB ATL86LA053Accident · Minor injuriesLimited investigationFinal reportHughes 269A · Brewton, ALDuring low level controlled burning of a small timber forest the helicopter lost power. A forced landing was attempted in a field and the helicopter was substantially damaged. The aircraft owner related that the aircraft ran out of fuel.Jan 8, 1986 · N8866F · Substantial damageNTSB LAX86LA078Accident · 1 fatalLimited investigationFinal reportCessna R172K · Kamuela, HIThe acft collided with terrain while maneuvering to aviod clouds during a local scenic flt. The plt stated that turbulence caused loss of control and the acft was blown into trees. The winds were from 050 degs at 37 KTS with gusts to 45 KTS. SIGMET oscar five…Jan 1, 1986 · N7320K · DestroyedNTSB LAX86FA077Accident · 2 fatalField investigationFinal reportCessna T210N · Hyder, AZWitnesses observed the acft depart the ranch airstrip, level off at about 200 ft AGL & make a turn back over the ranch house. The acft occupants were seen to wave to the people on the ground as the acft began an abrupt climbing turn. The witnesses then saw…Dec 29, 1985 · N4592Y · DestroyedNTSB ANC86FA020Accident · 2 fatalField investigationFinal reportCessna 182 · Lake Clark Pass, AKThe acft collided with rising terrain while maneuvering in a mountain Pass. Low ceilings, 40 to 50 kt winds and rain showers were reported in the area at the time of the accident.Dec 23, 1985 · N5009D · DestroyedNTSB FTW86LRG08Accident · No injuriesFinal reportRobinson R-22HP · Pflugerville, TXThe helicopter rolled over when the right skid contacted the ground during a hover. The plt stated he had landed to and opened the door to check the skid position. After takeoff while in a hover at 2 ft AGL, the door popped open. The right skid contacted the…Dec 21, 1985 · N8358C · Substantial damageNTSB ATL86LA046Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Mendenhall, MSThe plt stated that the acft collided with a tree while he was making a low pass over his father's home. The plt said his attention was diverted while making a left turn and the acft descended into the tree.Dec 21, 1985 · N6712G · Substantial damageNTSB LAX86FVM01Accident · No injuriesFinal reportPitts Special G-1 · Salinas, CAOn December 19, 1985, an experimental Pitts-special, N14JD, owned and operated by the owner crashed under unknown circumstances near Salinas, California. The pilot survived but the aircraft was not recovered. The pilot stated that he had an unknown flight…Dec 19, 1985 · N14JD · DestroyedNTSB DEN86LA049Accident · Serious injuriesLimited investigationFinal reportFairchild Hiller FH-1100 · Bountiful, UTAccording to the plt, he and three friends were en route to a local ski resort, when the helicopter encountered deteriorating wx. The plt stated he elected to cross the ridge and fly down a ravine to maintain visual reference. The plt said he was aware of…Dec 19, 1985 · N184FH · DestroyedNTSB DEN86LA044Accident · No injuriesLimited investigationFinal reportCessna 172N · Logan, UTThe plt stated that shortly after a night departure, the acft entered a fog bank. The plt said he was turning to reverse direction and descending in order to avoid IMC. Prior to completing the turn, the plt encountered IMC and lost all outside visual…Dec 16, 1985 · N739KU · Substantial damage