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 LAX86FA315Accident · 3 fatalField investigationFinal reportPiper PA-28-140 · Phoenix, AZThe recently certificated private pilot initiated flt with an over loaded acft into high density alt conditions. The acft stalled as it made a climbing left turn to the crosswind leg of the traffic pattern. The stall resulted in an uncontrolled collision with…Aug 7, 1986 · N8876N · DestroyedNTSB DEN86FTK04Accident · Serious injuriesFinal reportPiper PA-25-235 · Clear Lake, SDThere was a power line across the approach to the field being treated. The plt reports that he got too low during the flare out for entry to the swath run. The wheels contacted the sunflower crop and the acft impacted the ground. A fire developed during…Aug 7, 1986 · N7121Z · DestroyedNTSB CHI86LA189Accident · No injuriesLimited investigationFinal reportRobinson R22A · Eden Prairie, MNThe CFI reported that upon liftoff, the aircraft began drift left. When he tried to correct this condition he found that he could not move the cyclic to the right. While drifting to the left, the left rear skid hit the ground, the aircraft tilted back and the…Aug 7, 1986 · N8556M · Substantial damageNTSB ANC86LA122Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Mcgrath, AKThe pilot stated that during the climbout the engine began to sputter, lost power and crashed into a wooded area. Examination of the aircraft revealed heavy carburetor icing.Aug 6, 1986 · N9661P · Substantial damageNTSB MKC86LA168Accident · No injuriesLimited investigationFinal reportCessna 188B · Edison, NEThe PIC had made 5 or 6 passes to the corn field he was spraying. During this pass, the PIC stated he struck a pwr line that ran diagonally across the fld. The PIC stated he did not observe this particular strand during the other passes on the fld. Pwr lines…Aug 5, 1986 · N4807R · Substantial damageNTSB ATL86LA216Accident · No injuriesLimited investigationFinal reportAero Commander Callair A-9B · Ridgeland, SCThe pilot was performing a test flight to test a new spray pump which was recently installed on the aircraft. Following a low pass over the runway the pilot heard a grinding noise from the left side of the aircraft. Shortly thereafter the aircraft lost total…Aug 5, 1986 · N7946V · Substantial damageNTSB CHI86FER16Accident · No injuriesFinal reportAero Commander Callair A9B · Argyle, MNWhile setting up for a swath run the pilot struck the ground in a wings level descent. He stated that a 'whirlwind' or 'downdraft' prevented him from pulling up in time to pre-vent impact with the ground.Aug 4, 1986 · N7617V · Substantial damageNTSB LAX86MA311Accident · 2 fatalMajor investigationFinal reportBell 206B · Alamo, CAWitnesses reported seeing the helicopter circle twice over a residence at an alt of aprx 50' AGL. Upon initiating the third turn the helicopter entered an abrupt 90 deg bank and nosed down to impact with the terrain. Exam of the helicopter failed to reveal…Aug 3, 1986 · N49606 · DestroyedNTSB MKC86LA164Accident · No injuriesLimited investigationFinal reportCessna 188B · Hugoton, KSThe PIC stated that he was flying low and slow in an attempt to observe an acft that had just crashed in an open fld off the departure end of the rwy at Hugoton. The acft was then observed to roll left and descend and impact the gnd about 1/4 mile beyond…Aug 2, 1986 · N9379G · Substantial damageNTSB FTW86FRG29Accident · 2 fatalFinal reportCollins Charles A KR-2 · Georgetown, TXAcft was observed to takeoff, circle the arpt and make a low pass down the departure rwy. Following the low pass the acft entered a steep right bank, stalled and nosed over into the ground. During the investigation, no evidence of mech failure or malfunction…Aug 2, 1986 · N600CA · DestroyedNTSB SEA86LA187Accident · No injuriesLimited investigationFinal reportBoeing PT13/17 · Vancouver, WAThe plt reported the engine started running rough near woodland, Washington and an approach was set up, but due to many aircraft in the pattern the pilot elected to go to scappose, Washington (about 10 NM south of woodland). At scappose, Washington the pilot…Jul 31, 1986 · N1307N · Substantial damageNTSB LAX86FJA03Accident · Serious injuriesFinal reportBell 47G-3B1 · Lihue, HIThe helicoper crashed into trees while on a local pleasure flight. The pilot indicated that while hovering out of ground effect the main rotor and engine RPM were dropping below the minimum operating limits. The pilot lowered the collective to regain RPM but…Jul 31, 1986 · N700EC · Substantial damageNTSB DEN86FA213Accident · 2 fatalField investigationFinal reportThorp T-18 · Rawlins, WYThe accident acft, a Thorp T-18, was one of four acft (quickie ii, varieze, longeze) in a loose formation that was en route to the annual eaa convention at oshkosh, WI. The acft departed redding, CA, at 0500 PDT, refueled at wendover, UT, and departed there…Jul 31, 1986 · N85JJ · DestroyedNTSB MKC86LA163Accident · No injuriesLimited investigationFinal reportPiper PA-25-260 · Hershey, NEThe pilot stated he was spraying insecticides on corn and encountered a wind shear that pulled the airplane down into the corn. He was unable to recover and the airplane hit the ground.Jul 30, 1986 · N9641P · Substantial damageNTSB MKC86LA159Accident · No injuriesLimited investigationFinal reportCessna T188C · Davenport, IAThe ag pilot was spraying a field when he impacted powerlines which removed the upper one-third of the vertical stab and rudder. On landing he groundlooped and collapsed the right main gear.Jul 27, 1986 · N9975J · Substantial damageNTSB LAX86FA304Accident · 1 fatalField investigationFinal reportPlaymate SA-11A · Yucca Valley, CAThe PIC planned a local flight in his homebuilt 'Playmate' experimental acft. A witness reported observing the acft 1/8 mi n of the uncontrolled arpt in a spin. The plt recovered fm the spin at 200 ft AGL, & then entered a near vertical descent until…Jul 27, 1986 · N315W · DestroyedNTSB DEN86FA210Accident · Serious injuriesField investigationFinal reportBurkhart Grob G-102 Astir CS · Black Forest, COThe glider plt, took off at 1155 and was towed to an alt of 10,200 ft MSL and released. The plt said that a rapidly developing thunderstorm cut off his route back to the glider port and he was forced to make an off airport landing at about 1300. The plt said…Jul 26, 1986 · N144SS · DestroyedNTSB DEN86FA208Accident · 1 fatalField investigationFinal reportPiper PA-46-310P · Boulder, COThe purpose of the flt for both acft was an aerial photo mission. N5113S was used as the camera platform. The plts of N5113S and N4346L discussed prior to takeoff the procedures of the flt. Both acft departed and flew a course to position the airplanes on a…Jul 26, 1986 · N4346L · 2 aircraft · DestroyedNTSB CHI86FEV03Accident · 1 fatalFinal reportWoodrow Starduster SA-100 · New Baden, ILThe owner of the single seat, home built, acft offered to allow a navy F-14 plt to fly the plane. The owner made a shortflt, then proceeded to give the F-14 plt a cockpit check. The check-out explaination included such things as the flt characteristics,…Jul 26, 1986 · N64HW · DestroyedNTSB CHI86FA179Accident · 2 fatalField investigationFinal reportStinson 108-3 · Shiocton, WIWitnesses rprtd that prior to the acdnt, the acft was flying at a very low level, near treetop level, over residences, a ball park & a lake park. Subsequently, the acft collided with a utility pole & trees, then crashed into a private residence & burst into…Jul 26, 1986 · N6567M · DestroyedNTSB ATL86LA213Accident · Minor injuriesLimited investigationFinal reportLuscombe 8A · Ringgold, GAThe pilot reported he attempted to make a 180 degree turn because he realized he was getting too close to an airport while on a cross country flight. A highway patrolman said the pilot told him he became disoriented during the turn, cut the power to land, and…Jul 26, 1986 · N71713 · Substantial damageNTSB SEA86LA179Accident · 1 fatalLimited investigationFinal reportAyres S2R · Nampa, IDGround personnel reported the acft entered procedure turnaround in an excessive attitude, appeared to stall, rolled inverted and struck the ground. No evidence found of pre-impact mechanical failure or malfunction.Jul 25, 1986 · N5511X · DestroyedNTSB FTW86LRD18Accident · No injuriesFinal reportGrumman G-164A · Bastrop, LAThe acft came to rest inverted with the engine under water after a power loss and forced landing. The plt stated that he started losing power in the turn to line up for his first aerial application run. The acft settled to ground impact in a landing attitude…Jul 25, 1986 · N6718Q · DestroyedNTSB FTW86LA147Accident · No injuriesLimited investigationFinal reportBell 206B · Sand Springs, OKThe student pilot was hovering aircraft at 3 feet and allowed the aircraft to drift to the right. High skid gear was installed on the a/c. the right skid made contact with the ground causing dynamic rollover. The student pilot had a total of 44.2 hours flight…Jul 25, 1986 · N2779R · Substantial damageNTSB FTW86LA138Accident · No injuriesLimited investigationFinal reportHughes 269C · Batesville, TXThe pilot experienced a partial power loss at 60 feet AGL. He made a hard landing in an open field causing the rotor blades to severe the tail boom on touchdown. On examination of the aircraft fuel system debris was found in the fuel strainer, causing fuel…Jul 25, 1986 · N99803 · Substantial damageNTSB SEA86LA178Accident · 1 fatalLimited investigationFinal reportAyres S-2R · Kuna, IDAcft was observed in orbit pattern near object field for night aerial application. Plt overflew object field secured acft lights and shortly thereafter collided with powerline tower. Plt had made application at this field four previous times this year. Ground…Jul 24, 1986 · N5017X · DestroyedNTSB LAX86LA302Accident · 1 fatalLimited investigationFinal reportCessna 150D · San Diego, CAA Cessna 150D collided with the pacific ocean while spotting fish approximately 5 mi from the coast. The acft owner and operator indicated that the plt was FAA licensed and current. FAA records revealed the plt was issued a student plt certificated along with…Jul 23, 1986 · N5917T · DestroyedNTSB ATL86LA206Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Surfside Beach, SCDuring first banner tow of the day, plt reported that the eng lost power during initial climb after the banner was hooked. The banner was released and acft descended into trees 1 mile from the pick-up point. Inspection of the eng confirmed a magneto ignition…Jul 23, 1986 · N4519U · DestroyedNTSB LAX86FVA12Accident · 1 fatalFinal reportAyres S2R · Tranquility, CADuring an aerial application operation the aircraft was observed to have made a pass over the field, began turning to make another pass when a loud pop was heard. Just after the noise, witnesses observed the aircraft spin as the turn lights mounted on the…Jul 22, 1986 · N4023S · DestroyedNTSB FTW86LRD22Accident · No injuriesFinal reportGrumman G-164A · Franklin, LADuring aerial application, the pilot was maneuvering for alignment with a field, when the aircraft struck the ground. Nopreimpact mechanical malfunction or failure was evident.Jul 22, 1986 · N920X · Substantial damageNTSB SEA86LA177Accident · Minor injuriesLimited investigationFinal reportBell 47G3B2 · Nahcotta, WAWhile spraying oyster beds the pilot inadvertently flew the helicopter into the ground.Jul 21, 1986 · N7092J · DestroyedNTSB MKC86LA152Accident · No injuriesLimited investigationFinal reportCessna 188 · Jonesboro, ARThe acft was engaged in spraying a rice field when, according to the plt, a total loss of power occurred. The acft was subsequently damaged during a forced landing in an open field. Due to the lack of fuel which he observed after the accident, the acft owner…Jul 21, 1986 · N4483Q · Substantial damageNTSB LAX86FVG05Accident · Serious injuriesFinal reportBrown Pitts Special · Bridgeville, CAWitnesses reported the plt made 4 or 5 low passes over the rwy prior to the accident. During each pass the acft was rolled inverted, the eng would quit and the plt would roll the acft upright. On the last pass, according to witnesses, the eng quit again, the…Jul 20, 1986 · N9BB · Substantial damageNTSB FTW86LA137Accident · Serious injuriesLimited investigationFinal reportRose Rhinehart A4-C · Midland, TXThe pilot stated that he encountered severe windshear on approach to landing at the ryan aerodrom airport. He applied full power and pulled the nose up to the best angle of climb attitude, however he could not arrest the sink rate and hit the runway in a…Jul 20, 1986 · N846V · Substantial damageNTSB LAX86LA295Accident · Minor injuriesLimited investigationFinal reportCessna T207A · Whitmore, AZThe airplane departed marble canyon airport, marble canyon, Arizona, to pick up passengers at the grand canyon bar ten airstrip (1Z1) for a 14 CFR 135 flight. The pilot reported that upon arrival at 1Z1 he flew over the single dirt strip runway at about 20 ft…Jul 19, 1986 · N6484H · Substantial damageNTSB CHI86FER14Accident · No injuriesFinal reportBell-Campbell CHG-2 · Brooklyn Park, MNAccording to the pilot after making three quarter-mile passes over the field the engine quit and he was forced to make an emergency landing in a field. The pilot stated, prior to takeoff the helicopter had been refueled by a ground crew member. According to…Jul 18, 1986 · N5235N · Substantial damageNTSB LAX86FUJ04Accident · No injuriesFinal reportGrumman G-164-3 · Casa Grande, AZThe acft collided with telephone wires on the third apch to a field for an aerial application run. The acft then descended to collision with the terrain. The plt reported having noticed the power lines during the previous spray runs.Jul 17, 1986 · N5342 · Substantial damageNTSB ATL86FEK04Accident · No injuriesFinal reportAyres S2R-T15 · Mandale, OHThe acft stalled in turbulent air during a 180 turn while crop spraying at about 150 ft AGL. The plt said he increased power & dropped the acft nose while turning an additional 20 degrees to avoid trees. The recovery of positive control was in process when…Jul 16, 1986 · N4015P · Substantial damageNTSB SEA86LA168Accident · No injuriesLimited investigationFinal reportBell 47G2A · Chehalis, WADuring an aerial applications maneuver, a complete loss of power occurred. The power loss was caused by failure of the connecting rod bolt. The acft was too low for autorotation and the aircraft struck the ground tail low. The main rotor blade then struck the…Jul 13, 1986 · N12848 · Substantial damageNTSB NYC86FNC05Accident · Minor injuriesFinal reportBell 47G-5 · Walthamer, MEWhile on a spray run the pilot of the Bell 47 was blinded by the sun as he was turning. The aircraft struck power lines, control was lost and the helicopter crashed.Jul 12, 1986 · N7861S · Substantial damageNTSB MKC86FCJ03Accident · Serious injuriesFinal reportAero Commander Callair A-9A · Pleasant Dale, NEA witness reported the acft pulled up with one wing high and went practically inverted before striking the ground in a steep nose down attitude. The acft was engaged in an aerial application operation when the accident occurred. The company owner stated the…Jul 12, 1986 · N8413V · DestroyedNTSB FTW86FA127Accident · 3 fatalField investigationFinal reportBeech 58 · Santa Fe, TXA pvt plt & instructor (CFI) were on a LCL flt with a 3rd occupant aboard. The purpose of the flt was to provide dual instruction to the pvt plt so he could obtain a multi-eng rating. At 1818, 1 of the plts contacted houston TRACON & reqdradar adzy & said…Jul 12, 1986 · N61442 · DestroyedNTSB FTW86LRD19Accident · Minor injuriesFinal reportAir Tractor AT-301 · Campti, LAThe acft crash landed from about 60 ft AGL after the eng quit during the end of a cotton spraying operation. The plt said he just dived & 'pancaked' which sheared the landing gear. The reason for the power filure is unknown. The plt said he has had 20 power…Jul 11, 1986 · N3106L · DestroyedNTSB DEN86FA193Accident · 2 fatalField investigationFinal reportCessna 152 · Pierce, COThe acft reportedly departed the fort collins, Colorado, downtown arpt at 2151 MDT, July 10, 1986, on a local student night training flt. The wreckage was discovered at O800 MDT, July 11, 1986, in open, flat, cultivated terrain. The acft impacted in a steep…Jul 11, 1986 · N5121P · DestroyedNTSB LAX86FVA11Accident · Serious injuriesFinal reportBell 47G-5 · Porterville, CADuring an aerial application flight the plt lost control of the helicopter and collided with a building. Examination revealed that the inside diameter of the tail rotor driveshaft was not coated with aluminized lacquer as required by the Bell finish process…Jul 8, 1986 · N1316X · Substantial damageNTSB ANC86LA104Accident · No injuriesLimited investigationFinal reportCessna 170 · Fairbanks, AKThe plt reported experiencing a total loss of pwr during cruise flt. He stated he switched fuel tanks and was temporarily able to regain pwr before experiencing a second total loss. Substantial damage resulted during the forced landing. During post accident…Jul 8, 1986 · N3864V · Substantial damageNTSB LAX86LA283Accident · Serious injuriesLimited investigationFinal reportTexas Helicopter OH-13H/M · Valencia, CAThe pilot reported that he heard a loud bang and grinding noise from the engine/main transmission area while on a swath run. He stated that the main rotor RPM decayed immediately after he heard the noise. As the helicopter descended to about 50 feet above the…Jul 6, 1986 · N51856 · Substantial damageNTSB DEN86LA190Accident · Minor injuriesLimited investigationFinal reportPiper PA-38 · Cimarron, NMThe plt received a checkout in the acft prior to the accident and then flew to the philmont scout ranch located at approximately 9,000 foot MSL elevation. Ground witnesses stated that the acft was 'buzzing the area' and flew into an area of high terrain. The…Jul 6, 1986 · N2587B · Substantial damageNTSB ATL86FEG01Accident · No injuriesFinal reportBeech C-45H · Tremont City, OHThe acft collided with a utility pole during an exhibition fly-by. The acft continued to fly to its home arpt where it made an uneventful landing. The rt wing was damaged on the outboard end to include 2 ft of the aileron. The pole struck was 30 ft high and…Jul 6, 1986 · N8640E · Substantial damageNTSB ANC86LA102Accident · No injuriesLimited investigationFinal reportCessna 152 · Nenana, AKThe student plt stated that he ran out of fuel on a solo x-country flt after becoming disoriented. A forced landing was made during which the acft nosed over.Jul 6, 1986 · N6276P · Substantial damage