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 FTW86FRG24Accident · No injuriesFinal reportGrumman G-164 · La Feria, TXAs the plt was making a swath run, he started to cross under power lines, but saw the profile view of a road marker. When he pulled up to avoid the road marker, the acft struck the wires, rolled to the left & collided with the ground.Jun 5, 1986 · N552Y · DestroyedNTSB FTW86LA100Accident · No injuriesLimited investigationFinal reportBellanca 7GCAA · Thomas, OKShortly after takeoff at an alt of aprx 200 ft AGL, the plt attempted a snap-roll. The plt was unable to recover after the intended 1 roll and the maneuver continued for 1 1/2 rolls. The plt was able to level the wings but the acft contacted the terrain in a…Jun 4, 1986 · N8580V · DestroyedNTSB DEN86LA151Accident · Minor injuriesLimited investigationFinal reportBell 206B · Portal, NDThe plt reported that the acft hit wires at the end of a swath run. The pitch change link broke when the main rotor contacted the wires and the plt attempted to land. After touchdown, the helicopter rolled onto its side.Jun 4, 1986 · N59495 · Substantial damageNTSB MIA86LA171Accident · No injuriesLimited investigationFinal reportAir AT301 · Darling, MSThe plt stated that during an aerial application swath run he attempted to go around a telephone wire. The acft stalled, hit the ground and was destroyed by post crash fire.Jun 2, 1986 · N8569S · DestroyedNTSB ATL86FA156Accident · 3 fatalField investigationFinal reportMBB BO-105C · Peterson, ALThe EMS helicopter was heard and observed as it flew at low altitude down the river. A witness saw it dip down then attempt to climb just prior to the collision with power lines across the river. The helicopter broke the wires but was stopped and came apart…Jun 2, 1986 · N114BH · DestroyedNTSB ATL86FA155Accident · 1 fatalField investigationFinal reportBeech 95-B55 · Elizabethtown, KYAcft observed in level flt in IMC just below EST 500 foot ovc. EST viz about 3/4 mi. Lt wing struck 15/16 inch dia steel guy cable 534 feet AGL shearing outer 118 in. Acft impacted earth fill dam 1169 ft from 650 feet tall tv antenna. Tower. Top of tower…Jun 2, 1986 · N3001S · DestroyedNTSB MKC86FA123Accident · 3 fatalField investigationFinal reportCessna 140 · Des Arc, ARNumerous witnesses on a sandbar in the white river observed this collision of two airplanes as they were flying close together, low, over the river. Of the nine witness statements received, five had the Piper PA-28-140 hitting the Cessna 140, three had the…Jun 1, 1986 · N89247 · 2 aircraft · DestroyedNTSB ATL86LA153Accident · No injuriesLimited investigationFinal reportCessna 150M · Franklin, NCFifty two hr pvt plt flying over lake in mountainous terrain started climb out toward destination. Elevation of lake about 3000 ft. ambient temp about 90 f. plt could not climb a/c at an angle to clear rising terrain. Flew a/c into trees.Jun 1, 1986 · N8109U · DestroyedNTSB SEA86FA137Accident · 1 fatalField investigationFinal reportBell UH-1L · Wenatchee, WAN4964N, a Bell UH-1L, was being operated in logging ops by an experienced, military trained plt who possessed 6000 hrs of flt experience in model. While lifting a sling load gnd crew rptd smoke from the tail rotor area. Plt released sling load & acknowledged…May 31, 1986 · N4964N · DestroyedNTSB MKC86LA121Accident · No injuriesLimited investigationFinal reportAero Commander S-2R · Pocahontas, ARThe pilot stated that this was his third flight of the morning with a full load of fertilizer. Reportedly, he was in the process of aerial application, when the engine quit. He made a forced landing on a short field road. He further stated that the ground…May 31, 1986 · N8896Q · Substantial damageNTSB LAX86MA238Accident · Minor injuriesMajor investigationFinal reportAerospatiale AS-355F-1 · Kameula, HIThe plt rprtd that as he 'hovered' the helicopter btn 5 & 10 ft after lift-off, he noted a 'slight lateral vibration.' He lndd immediately, but the vibration/ground resonance (vib) increased in severity, so he 'shut-off' both throttles. The vib contd to the…May 31, 1986 · N909CH · Substantial damageNTSB FTW86FA096Accident · 1 fatalField investigationFinal reportMeyers 200B · Krum, TXThe retired airline captain was returning to a retirement party for another airline captain. He began a barrel roll from a relatively low pass over the party, but collided with the ground on pull out. Alcohol was not a factor.May 31, 1986 · N34397 · DestroyedNTSB DEN86FA146Accident · 1 fatalField investigationFinal reportBauer'S Mitchell Wing U-2 · Cheyenne, WYThis was an experimental amateur-built acft. Witnesses reported seeing the acft in a steep right bank when the eng lost power. The acft was then seen to stall and enter a right spin. Witnesses said the plt recovered but entered a second stall and dove…May 31, 1986 · N3967S · DestroyedNTSB ATL86LA151Accident · Serious injuriesLimited investigationFinal reportCessna 120 · Magnolia, KYThe plt was using the acft to drop a tool to a mechanic friend and was flying at low alt toward rising terrain to verify the location where the tool fell. Witnesses said that when the plt exited the acft after the accident he stated he was too low, too slow,…May 31, 1986 · N76730 · Substantial damageNTSB SEA86LA134Accident · No injuriesLimited investigationFinal reportAyres S2R · Hamer, IDDuring aerial application the engine ceased operating and a small fire erupted. During forced landing the landing gear was torn off and the fuselage became twisted. After landing, the fire continued for a short period of time. Postaccident eng teardown…May 29, 1986 · N4000A · Substantial damageNTSB MIA86LA168Accident · Minor injuriesLimited investigationFinal reportBell 47-D1 · Panama City Bch, FLThe pilot had intended to hover the helicopter and allow a 'clown' to touch the skids while a photographer recorded the event looking upward to give the appearance that the 'clown' was hanging from the skid. The 'clown' grabbed the left rear skid and the…May 29, 1986 · N10065 · Substantial damageNTSB FTW86FPA18Accident · 1 fatalFinal reportEagle Eagle DW-1 · Howe, TXThe acft appeared to stall during a sharp pull-up and turn during a test flt after a low pass over the airstrip. The plt was testing the spray equipment and made the low pass so the ground observer could see the spray pattern. No malfunctions in equipment…May 28, 1986 · N8814G · Substantial damageNTSB ATL86LA146Accident · Minor injuriesLimited investigationFinal reportHughes 300/269B · Marshville, NCDuring an instructional flight, a power recovery was attempted at the completion of a practice autorotation. Power was applied and the engine lost power. The autorotation was completed to the preselected practice field and the helicopter rolled over after a…May 28, 1986 · N9460F · Substantial damageNTSB NYC86FNC03Accident · 1 fatalFinal reportPiper J-3 · Milan, NHThe pilot was flying a 'drunken farmer' routine at a airshow. He was observed in the air to begin a descent from which he did not recover. The pilot was fatally injured in the crash and the aircraft destroyed. No mechanical or physical reason for the crash…May 25, 1986 · N6498H · DestroyedNTSB FTW86FA091Accident · 2 fatalField investigationFinal reportAerotek Pitts S2A · Santa Fe, TXA short occurred in the aircraft's electrical system distracting the owner/pilot occupying the back seat of the aircraft. This seat was not equipped with a second lap restraint. The aircraft was observed, by witnesses, to enter a spin which went inverted. The…May 24, 1986 · N80004 · DestroyedNTSB CHI86FEV02Accident · Serious injuriesFinal reportJerry Cox Goldwing · Mattoon, ILThe acft was circling a racetrack at a relatively low alt, described as between 800-1500 ft AGL, with the eng throttled back. During a subsequent steep bank to the left while accelerating the left wing failed and the acft crashed into the trees.May 24, 1986 · N85JC · Substantial damageNTSB ATL86FKG09Accident · 1 fatalFinal reportPitts S-1 · Atmore, ALThe acft crashed almost vertically from aprx 250/300 ft AGL after rolling inverted at the completion of a double snap roll to the rt. The acft slowed during the rolls and appeared to be too slow to control the stopping of the rolls. The acft continued to roll…May 24, 1986 · N83JW · Substantial damageNTSB NYC86FA133Accident · 3 fatalField investigationFinal reportMooney M20K · West Milford, NJWhile on an IFR flight the aircraft entered an area of thunderstorms, lost control of the aircraft and crashed. In an attempt to circumnavigate the storms the plt inadvertently entered a storm and collided with the ground in an uncontrolled descent. The plts…May 23, 1986 · N97299 · DestroyedNTSB CHI86FER09Accident · 1 fatalFinal reportPiper PA-22-150 · Lino Lakes, MNThis aircraft was overloaded on takeoff with extra fuel, camping equipment, a passenger, an outboard motor, tools and the like. In addition the center of gravity was probably out of safe limits. An additional factor affecting takeoff and turn performance was…May 23, 1986 · N5710D · DestroyedNTSB FTW86LRD13Accident · No injuriesFinal reportGrumman G164B · Morse, LAThe acft settled into power lines and stalled into the ground during a spray operation. The plt had turned downwind to line up for his spray run. The acft started descending and even though power was applied as load was jettisoned the acfts tail wheel snagged…May 22, 1986 · N665OQ · Substantial damageNTSB FTW86LRD12Accident · No injuriesFinal reportGrumman G-164A · Branch, LAShortly after takeoff, a partial power loss occurred & the plt made a forced landing in a soft plowed field, where the acft nosed over onto its back. The plt rprtd the loss of power was due to failure of the eng blower.May 21, 1986 · N5407 · Substantial damageNTSB SEA86FA121Accident · 2 fatalField investigationFinal reportCessna 152 · Mead, WABoth acft were operating in VFR conditions modified by slight haze, high overcast and low sun angle near airport. N6161M was performing lazy eight maneuvers in a normal practice area two miles east of airport; N8267Q was in clockwise orbital descent for…May 20, 1986 · N6161M · 2 aircraft · DestroyedNTSB FTW86LRG21Accident · No injuriesFinal reportGrumman G-164B · Port O'Connor, TXAcft flipped over on touchdown during an emergency landing in a cultivated field following a partial power loss during a swath run at 30 ft AGL. Investigation revealed that the no. 1 cyl exhaust valve push rod had failed. Exact cause of the push rod failure…May 20, 1986 · N6740Q · Substantial damageNTSB ATL86LA138Accident · No injuriesLimited investigationFinal reportBell 47G-3B · Red Bay, ALThe pilot had completed a dispensing operation and was returning to the ag staging area to refuel. As the helicopter hovered towards the parked refueling vehicle, the main rotor blades struck a metal structure attached to the truck. The pilot stated that the…May 19, 1986 · N73269 · Substantial damageNTSB LAX86FJA06Accident · 2 fatalFinal reportBell 206B · Maui, HIThe acft collided with powerlines while carrying pass'g on a sightseeing flt through a canyon. The wires across the canyon were EST to be 1700 long with height AGL unknown. The wires were unmarked and were 1/2 in dia aluminum. One of the passengers was…May 18, 1986 · N244WC · DestroyedNTSB ANC86LA058Accident · No injuriesLimited investigationFinal reportHiller 12-C · Palmer, AKThe pilot stated that he drew too much rotor pitch for the h.p. available. The helicopter lost control and rolled over on its side.May 18, 1986 · N49983 · Substantial damageNTSB SEA86FA126Accident · 4 fatalField investigationFinal reportLake LA-4-250 · Blue River, ORSeveral witnesses reported seeing the acft flying near the eugene arpt at an alt of 400 to 500 ft AGL. The acft was heading toward the Blue River. The acft was then seen flying over the Blue River forest ranger station aprx 7 minutes prior to the accident. At…May 17, 1986 · N1403A · DestroyedNTSB LAX86LA225Accident · No injuriesLimited investigationFinal reportCessna 150D · Lancaster, CAThe acft collided with a 60 foot tall pine tree while maneuvering over a residential area. The pilot indicated that he was heading west at 750 feet above the ground with 30 degrees of flaps at approximately 60 mph airspeed with fifty percent power applied. He…May 17, 1986 · N6013T · Substantial damageNTSB ATL86LA130Accident · No injuriesLimited investigationFinal reportCessna 150M · Littleton, NCPIC made low pass to let friend know he would land at airport for prearranged meeting. PIC reported he was low and slow. When go-around was attempted acft controls were mushy and acft would not climb. Later pilot commented he thought he was on the backside of…May 17, 1986 · N328M · Substantial damageNTSB ATL86FA133Accident · 1 fatalField investigationFinal reportCessna 172 · Douglasville, GAThe acft was observed flying at low alt & circling several houses. The plt landed on a grass strip, then after a short time, he & his passenger took off again. The acft was again observed circling several houses at low alt in an area near the strip. A witness…May 17, 1986 · N6839A · DestroyedNTSB DEN86FTK01Accident · Serious injuriesFinal reportBellanca 7GCBC · Huron, SDThe acft contacted powerlines and descended uncontrolled to ground impact. The plt reported that he was checking fields when the accident occurred. The acft was traveling to the west into the setting sun when accident occurred.May 16, 1986 · N53756 · Substantial damageNTSB MKC86LA109Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Stuttgart, ARDuring an agricultural spray maneuver back to a field the PIC was fertilizing, the PIC stated he allowed the acft to become too slow and the aircraft descended into trees which bordered the field. The PIC stated he should have been flying with a lighter load…May 14, 1986 · N5648X · DestroyedNTSB MKC86LA108Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Tekamah, NEThe pilot stated that as he was finishing his run spraying pine trees and was pulling up when the engine lost power. The right wings struck trees and the aircraft nosed over during the forced landing.May 14, 1986 · N6630 · Substantial damageNTSB CHI86FEE03Accident · No injuriesFinal reportBeaupre Elfering Quickie · Waukegan, ILThe acft crash landed in a cultivated part of the arpt after the eng quit during takeoffs & landings. The acft climbed to about 400 ft AGL and started a turn when the eng stopped. The acft was glided to an alfalfa field on the arpt. The acft was damaged…May 12, 1986 · N134BE · Substantial damageNTSB ANC86FA055Accident · 1 fatalField investigationFinal reportEnstrom F28C · Turnagain, AKThe helicopter was observed flying along the highway at a low altitude and it then struck some high power transmission lines, fell to the ground and burned upon impact. The transmission lines were 283 feet above the road surface and spanned a distance of 1127…May 12, 1986 · N51726 · DestroyedNTSB SEA86LA122Accident · Serious injuriesLimited investigationFinal reportCessna 182P · Smiths Ferry, IDThe plt was returning to home base from a business flight on which he delivered parts to company personnel. The acft was observed flying down the north fork of the river at low altitude with its wings dipping. Aprx one mile after entering the canyon, the acft…May 10, 1986 · N91184 · DestroyedNTSB NYC86FGM02Accident · Minor injuriesFinal reportContinental Copters OH13H Tomcat Mark 5A · Indiana, PAThe acft collided with wires during a spray run and crashed out of control. The plt tried to fly under the wires that were sighted too late to clear. During his survey of the field the plt had failed to see the wires that were struck. The collision broke off…May 10, 1986 · N41830 · Substantial damageNTSB BFO86FID08Accident · 1 fatalFinal reportMilliken Gyrocopter B-80 · Suffolk, VAAccording to a plt witness the accident plt was attempting to compensate for an increase in wind velocity when the accident occurred. The witness stated the plt entered a steep dive to compensate for the increase lift followed by the gyrocopter ballooning due…May 10, 1986 · N202M · DestroyedNTSB ATL86FA126Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Ludlow, PAAn acft fitting the description of the acdt acft was observed entering the lake arm about 7 1/2 mi n of the acdt site. The acft was observed to pull up to clear pwr lines across the lake arm about 2 1/2 mi n of the acdt site. The acft was observed to fly into…May 10, 1986 · N999HT · DestroyedNTSB MKC86FPG03Accident · Serious injuriesFinal reportSchweizer Grumman G-164B · Harrisburg, ARThe plt reported that while spraying a fld with propanil and penoxalin the wind shifted from the southeast to the northeast allowing the chemicals to cover the windshield thus reducing the plt's forward vision. This in combination with sun glare, resulted in…May 9, 1986 · N8493K · DestroyedNTSB ATL86LMG07Incident · No injuriesFinal reportBell UH-1B · Wrightsville, NCThe plt reported that he was about to descend from a high hover to land in an open field adjacent to a hotel parking lot when the tips of both main rotor blades contacted a light pole. The plt maneuvered away from the pole and landed in the open field.…May 8, 1986 · N158HP · Minor damageNTSB ANC86LA054Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Atmautluak, AKThe air taxi pilot planned six hours of night flying with a five minute fuel reserve at his destination. When he saw that he would be unable to reach the destination, he diverted toward atmautlauk. However, the acft ran out of fuel as the plt was maneuvering…May 5, 1986 · N4246T · Substantial damageNTSB NYC86LA118Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 1-26 · Mt. Graylock, MAThe pilot was practicing simulated cross country passes on a ridge at an altitude of 150 ft AGL on the windward side of a ridge in a Schweizer sgs 1-26 sailplane. The pilot encountered a roll condition from which he lost control, was unable to recover and…May 4, 1986 · N1140S · Substantial damageNTSB MIA86FA142Accident · Serious injuriesField investigationFinal reportCessna 172N · Starkville, MSWitnesses rprtd that the plt had purchased wine cooler beverages before going to the arpt. He stated that he drank from one of the bottles before the flt. The plt took off at about 2230 CDT. After takeoff, he flew back over the arpt & made a low pass over a…May 3, 1986 · N4838G · DestroyedNTSB MIA86LA141Accident · No injuriesLimited investigationFinal reportBellanca 7KCAB · New Smyrna Bch, FLDuring a pickup of an aerial advertising banner the acft struck the pickup bridle with the left main landing gear. He stated that he was unable to climb. The acft then stalled and crashed along the arpt boundary in a swamp.May 2, 1986 · N90985 · Substantial damage