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 ANC85LA143Accident · Serious injuriesLimited investigationFinal reportPiper PA-22 · Mccarthy, AKThe plt stated that while executing a 180 deg right turn the acft drifted 50 ft to the east of rwy 19 where it struck a row of trees. The acft continued in a steep descending turn. The acft stalled and crashed into a wooded area.Aug 4, 1985 · N2566A · Substantial damageNTSB MIA85LA224Accident · No injuriesLimited investigationFinal reportBell TH-13T · Quitman, GAPilot stated that after completing a left turn at the end of a cotton field, the aircraft yawed sharply to the left and the yaw could not be controlled with cyclic control. Another left turn at the oppsite end of the field the aircraft again yawed to the…Aug 1, 1985 · N31FG · Substantial damageNTSB LAX85LA336Accident · No injuriesLimited investigationFinal reportBell 206 B3 · Arroyo Grande, CAWhile hovering and slinging an external load over rough terrain the eng chip light illuminated. The plt immediately positioned the acft to release the load and the eng began making a 'whining' noise. Several seconds later all eng power was lost. The plt…Aug 1, 1985 · N90328 · Substantial damageNTSB SEA85LA187Accident · No injuriesLimited investigationFinal reportGrumman 164A · Shelley, IDThe safety broke in the carburetor and the seat backed out causing fuel starvation. The carburetor had been overhauled 350 hours prior to the accident.Jul 30, 1985 · N5186 · Substantial damageNTSB DEN85LA207Accident · Minor injuriesLimited investigationFinal reportCessna 205 · Pueblo, COThe plt/owner departed Pueblo, CO, on a VFR pleasure flt to California. During the flt the plt encountered IMC and elected to return to Pueblo. Witnesses observed the plt making low passes over his parent's home in west Pueblo just prior to impacting rolling…Jul 30, 1985 · N1818Z · Substantial damageNTSB LAX85LA332Accident · No injuriesLimited investigationFinal reportGulfstream-Schweizer Gulfstream AM G-164B · Poston, AZThe plt reported weather conditions during the night aerial application flt were 'clear and winds of 15 KTS with gusts to 20 KTS. After three unsuccessful attempts to line up for the spray run, the plt said he allowed the acft to 'get too low and slow' while…Jul 29, 1985 · N8133K · Substantial damageNTSB LAX85FUM01Accident · 2 fatalFinal reportAerotek Pitts S-2A · Ramona, CAOn July 28, 1985 at approximately 1820 hours, a pitts S-2A, N56PS, owned and operated by william l. travis, crashed on a hillside on the 192 deg radial, 12.8 nautical miles from the julian VOR. The flight was for the purpose of aerobatics. The aircraft was…Jul 29, 1985 · N56PS · DestroyedNTSB CHI85FA316Accident · 1 fatalField investigationFinal reportCessna 172G · Plain City, OHThe plt had just taken off from his pvt strip for the fourth flt of the day when witnesses heard the eng quit. The acft had been flown 3.4 hrs since the last refueling. The acft was being operated on a mixture of avgas and automotive fuel with no STC. The…Jul 29, 1985 · N4202L · DestroyedNTSB ATL85LA226Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Athens, ALDuring an aerial application flight the aircraft lost power due to fuel exhaustion. The pilot made an emergency landing in a corn field. The pilot stated that he visually checked the fuel prior to take off and it appeared as if there was enough fuel to…Jul 29, 1985 · N10AA · Substantial damageNTSB ANC85LA137Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Drift River, AKApln crashed on gravel bar after wing tip hit ground during low alt turn. The unlicesed plt stated that he WA s in his second 360 deg turn & hit his own wake turbulence.Jul 29, 1985 · N14159 · Substantial damageNTSB ANC85FA138Accident · 4 fatalField investigationFinal reportCessna 172M · Red Devil, AKShortly after the plt took off on a ngt flt to bethel, the acft crashed just north of the east/west rwy in a nose down attitude & on a southwesterly heading. The acft was destroyed during impact, but contd sliding aprx 35 yds to the north edge of the rwy,…Jul 29, 1985 · N12904 · DestroyedNTSB NYC85LA197Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Coventryville, NYDuring a local flt over Coventryville, NY, the plt decided to overfly and observe a building. The plt made one pass and was about to make another when the eng began to lose pwr. While planning to land in a nearby fld, the eng regained pwr and the plt…Jul 28, 1985 · N45564 · Substantial damageNTSB MKC85LA173Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Norcatur, KSThe acft had been spraying for 40 minutes at 2500 ft MSL with a density alt of aprx 4600 ft when it stalled during a turnaround. It then impacted an electric pwr pole followed by the terrain.Jul 28, 1985 · N4772Y · Substantial damageNTSB MKC85FA169Accident · 2 fatalField investigationFinal reportPiper PA-18 · North Loup, NEThe acft was observed flying low over the ground in the vicinity of where it eventually crashed. A witness aprx 1/2 mi from the crash site noticed the plane flying low over a corn field as though the student plt was practicing ag-acft type swath runs. (The…Jul 27, 1985 · N9973Q · DestroyedNTSB CHI85FA315Accident · Serious injuriesField investigationFinal reportChristopher D. Brown Gyroplane · Oshkosh, WIThe pilot was practicing low altitude maneuvers, adjacent to the runway. When he turned to make a downwind, at the southeast end of the runway, he impacted with the terrain. Witnesses stated that they observed the gyroplane making steep turns at a low…Jul 26, 1985 · N46Z · DestroyedNTSB ATL85LKG08Accident · No injuriesFinal reportSchweizer AG CAT · Samson, ALThe acft was damaged in a forced lndg after a pwr loss during a swath run. During the ldg a pwr line was struck and the acft was pulled sideways which caused a groundloop and resulted in damages. Lyon flying services of welsh la dismantled the eng & found no…Jul 26, 1985 · N3629K · Substantial damageNTSB SEA85LA177Accident · No injuriesLimited investigationFinal reportCessna 172 · Mitchell, ORA go-around was attempted and the pilot was unable to outclimb rising terrain. The field elevation was over 3400 feet and the temperature was above 90 degrees. The pilot made a turn to avoid terrain and stalled. The density altitude was around 7,800 feet.Jul 25, 1985 · N734WW · Substantial damageNTSB CHI85FEP02Accident · Serious injuriesFinal reportNeyman-Pietenpol GN-2 · Brodhead, WIThe acft was observed making steep turns at about 500 ft AGL just prior to the acdnt. One witness stated that the airspeed was decaying during these turns & the acft stalled while in a steep bank. Reportedly, the acft began spinning, then the plt stopped the…Jul 25, 1985 · N13708 · DestroyedNTSB DEN85LTG04Accident · No injuriesFinal reportPiper PA-25 · Antler, NDThe left wing of the acft received substantial damage when it contacted trees during a pull-up at the end of a swath run. The plt then flew the acft to a fld aprx 1 mile away and a precautionary landing was made.Jul 24, 1985 · N6083Z · Substantial damageNTSB BFO85FA062Accident · 2 fatalField investigationFinal reportPiper J3C-65 · Oakland, MDThe acft had been observed on the day of this flt and on the 'past couple of days' to be flying low and very slow at tree top level. Ground witnesses heard the sounds of the crash but could not see the acft at the time. The acft impactedthe ground in a near…Jul 24, 1985 · N70336 · DestroyedNTSB BFO85FA061Accident · Serious injuriesField investigationFinal reportCessna 152 · Mechanicsville, MDAfter completing several low altitude passes over the family business, the student pilot extended 10 degrees of flaps and pulled the power back to slow the airplane in order to lengthen his viewing time. According to the pilot, after the accident, at between…Jul 23, 1985 · N24787 · Substantial damageNTSB DEN85LA195Accident · No injuriesLimited investigationFinal reportSchweizer G-164B-600 · Riverton, WYThe plt was crop spraying a field in a Schweizer ag-cat acft when the left landing wire broke. The plt returned to Riverton, WY. During the landing roll, in attempt to stop the acft as soon as possible, he inadvertently applied the brakes too hard, causing…Jul 22, 1985 · N6825K · Substantial damageNTSB NYC85FA185Accident · 1 fatalField investigationFinal reportBellanca 8KCAB · Fall River, MAWitnesses observed the acft execute an aerial pick up of the aerial advertising banner & climb very steeply away from the ground. Normal eng sounds were reported by the witnesses. The acft was observed to climb to an alt of approx 150 ft, nearly come to a…Jul 21, 1985 · N5504B · DestroyedNTSB CHI85LA310Accident · No injuriesLimited investigationFinal reportEnstrom 280C · Milford, MIThe pilot made a 'steep approach' to a hover over a boat channel and then ld in the yard of a residence. He then picked up a 270 id pax flew a short flt and was refueled with 25 gals of fuel. After another short flt the pilot returned to the channel and…Jul 21, 1985 · N556H · Substantial damageNTSB LAX85LA323Accident · Serious injuriesLimited investigationFinal reportBell 206B · Soda Springs, CAOn July 19,1985 a Bell 206B lost control while maneuvering near Soda Springs,CA.the aircraft was substantially damaged and the two pilots sustained serious injuries. The repoted he was maneuvering at 30 mph looking for sheep in mountainous terrain when he…Jul 19, 1985 · N7910J · Substantial damageNTSB ANC85LA126Accident · No injuriesLimited investigationFinal reportChampion 7KCAB · Glennallen, AKThe pilot-in-command made a low pass over the airstrip from south to north and UP0N reaching the departure end began a right hand turn at 50 to 75 foot above ground level. Upon reaching 30 to 40 degrees angle of bank, he lost control of the airplane.…Jul 19, 1985 · N9045L · Substantial damageNTSB SEA85FA171Accident · 2 fatalField investigationFinal reportPiper J3-C-65 · Goose Prairie, WAThe acft contacted trees while the plt was performing low level passes over a boy scout camp. Witnesses reported the plt made three passes over the camp and during one of those passes, the plt dropped a bag of candy bars to the scouts. The fourth, during…Jul 18, 1985 · N70691 · DestroyedNTSB MIA85LA214Accident · No injuriesLimited investigationFinal reportBell 47D1 · Moultrie, GAThe plt stated that while he was on an aerial application mission, the helicopter ran out of fuel. During an autorotation, the main rotor severed the tail boom.Jul 18, 1985 · N586T · Substantial damageNTSB ATL85LA219Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Pickens, SCThe plt had completed application of a herbicide and was returning to his temp opns area 1/2 mi distant when the engine quit about 50 ft AGL. Plt flared the helicopter on the 45 deg downslope and tailbeem/rotor contacted ground. The fuel gauge ind 18 gals…Jul 18, 1985 · N40296 · Substantial damageNTSB LAX85LA321Accident · 1 fatalLimited investigationFinal reportPiper PA-28-235 · Monterey, CAThe pilot took off on a training flight to practice holding over a VOR intersection 12 miles off shore. Approximately 12MINUTES after take off the pilot declared 'mayday,rough engine', to the Monterey,calfornia control tower control specialist. The control…Jul 17, 1985 · N15548 · DestroyedNTSB LAX85LA320Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Durham, CADuring an ag flight in which a compound containing sulfur dust was being sprayed a fire began in the acft's spray apparatus. The cockpit filled with heavy smoke & the plt made a successful forced ldg in the underlying field. The fire spread & eventually…Jul 17, 1985 · N7853 · DestroyedNTSB FTW85LA288Accident · No injuriesLimited investigationFinal reportBell 47G-5 · Crane, TXThe helicopter was being operated from a flat bed trailer. The plt stated he had lifted to a 3 foot hover when the eng stopped. The helicopter suddenly rotated about 45 degs before he could stop it. The plt attempted to make an autorotation touchdown but was…Jul 16, 1985 · N8197J · DestroyedNTSB CHI85LA290Accident · No injuriesLimited investigationFinal reportHughes 269A · Oconomowoc, WIThe helicpoter contacted a corn crop and came to rest inverted during an aerial application flt. The plt stated, 3 passes were made over the fld being sprayed and after a turn to begin the 4th pass, the helicopter settled with pwr contacting the crop.Jul 16, 1985 · N8877F · Substantial damageNTSB CHI85FA292Accident · 1 fatalField investigationFinal reportCessna 170A · Olney, ILThe aircraft departed new baden and began flying erratically down an interstate highway. It caused one automobile accident by flying low head-on passes at cars. It flew underan overpass, damaging a wingtip in the process. It flew intoan electrical cable and…Jul 16, 1985 · N1223D · Substantial damageNTSB LAX85LVM04Accident · Serious injuriesFinal reportLarry Robbins Bakeng Duce · Gilroy, CAThe acft crashed after circling a ground fire at about 500 ft AGL. The plt said that she was watching the grnd fire when suddenly the acft dropped to the left. She added power and applied opposite rudder but the acft did not recover. She does not remember…Jul 14, 1985 · N3957D · Substantial damageNTSB CHI85FA284Accident · 1 fatalField investigationFinal reportEipper MX Super · Almont, MIWitnesses reported the acft was in an inverted flight aprx 60 to 70 ft AGL before it entered a split 's' maneuver and descended to ground impact. The plt was performing aerobatics in an airshow when the accident occurred. The plt's aerobatic waiver had…Jul 14, 1985 · N23MX · DestroyedNTSB DEN85LA187Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Kiowa, COThe acft collided with a telephone wire and crashed. The plt admitted he had been flying over a boy scout ranch at 7500 ft MSL (about 500 ft AGL). He could not recall any other details. One witness said he saw the acft cross in front of his pickup truck at…Jul 13, 1985 · N3030Z · Substantial damageNTSB DEN85FA186Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Aspen, COCFI and student departed Aspen, Colorado, on a dual x-country flt. The density altitude at the time of departure was calculated to be 9954 feet. The CFI directed student to fly up a canyon in an area of rising terrain. The CFI took control of acft and was…Jul 12, 1985 · N2443Y · DestroyedNTSB MKC85LA152Accident · Minor injuriesLimited investigationFinal reportBell 47G · Pella, IAThe purpose of the flt was to provede training in aerial application procedures and techniques for the plt/owner of N75273. The instructor plt has extensive experience in this m/m and was at the controls. He was demonstrating a turn around at the end of a…Jul 10, 1985 · N75273 · Substantial damageNTSB FTW85LA281Accident · No injuriesLimited investigationFinal reportWeatherly 201B · Rosharon, TXThe plt stated he failed to switch fuel selector to the left tank prior to takeoff (right tank empty). The engine quit abruptly at low altitude. Plt switched to left tank but could not regain engine power prior to hard landing in cotton field.Jul 10, 1985 · N2938W · Substantial damageNTSB DEN85LTG03Accident · No injuriesFinal reportPiper PA-25-235 · Kramer, NDThe acft collided with the shoulder of a hwy when the plt attempted to avoid power lines during an aerial application flt.Jul 10, 1985 · N9538P · Substantial damageNTSB CHI85LA283Accident · No injuriesLimited investigationFinal reportAir Tractor AT301 · Roseau, MNThe aircraft had been airborne about 15 min engaged in ag spray operations when the pilot described hearing a loud band. Engine power decreased to idle. Pilot ld in soft soil and nosed over inverted. Exam disclosed #2 piston had failed.Jul 10, 1985 · N23702 · Substantial damageNTSB CHI85LA280Accident · No injuriesLimited investigationFinal reportHughes 269A1A · Coal Valley, ILDuring an aerial application run the plt reported a 'split second loss of power.' He lost directional control of the helicopter and it settled into tall corn. Impact resulted in loss of the main rotor blades, severence of the tail cone and separation of the…Jul 10, 1985 · N8951F · Substantial damageNTSB LAX85FA311Accident · 2 fatalField investigationFinal reportCessna 152 · Marana, AZThe passenger had just purchased property at the accident site and intended to take aerial video tape footage of the property. Witnesses saw the plt and passenger board the acft with video camera and recorder. After departue, the acft flew directly to the…Jul 8, 1985 · N5204P · DestroyedNTSB ANC85LA123Accident · No injuriesLimited investigationFinal reportCessna 185F · Egegik, AKEngine failed at 200 ft AGL, due to fuel starvation. Plt attempted to reach lake, & crashed in trees at edge of lake.Jul 8, 1985 · N8700Z · Substantial damageNTSB ANC85LA121Accident · No injuriesLimited investigationFinal reportRobinson R-22A · Summit Lake, AKHelicopter struck glassy water lake during a low alt turn. Plt/flt instructor said he became disoriented during the turn, after he looked inside the helicopter briefly to check the rotor RPM. Accident occured during a bright night.Jul 7, 1985 · N8530J · Substantial damageNTSB NYC85LA159Accident · Minor injuriesLimited investigationFinal reportMBB GMBO-105C · Pittsburgh, PAThe air ambulance helicopter landed hard and rolled over after collidding with a fence. The helicopter had taken off to a hover position and was making a pedal turn in preparation for a climb. Collective was increased but RPM decreased and the acft began to…Jul 6, 1985 · N83CJ · DestroyedNTSB DEN85LA182Accident · Minor injuriesLimited investigationFinal reportCessna 182-R · Telluride, COThe plt said that he maneuvered the near max gwt acft in close proximity to a ski slope and 'I didn't leave myself an exit.' The plt then applied full power in an attempt to outclimb the rising terrain but impacted a knoll. Density altitude was computed to be…Jul 6, 1985 · N9837H · DestroyedNTSB CHI85LA275Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 · Donaldson, MNWhen the plt applied pwr to level off while entering a spray the eng did not produce sufficient pwr to stop the descent. He attempted a run on landing but the uneven terrain caused substantial damage to the helicopter. Inspection of the eng revealed the…Jul 6, 1985 · N7856S · Substantial damageNTSB LAX85LA305Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Gonzales, CAWhile cruising during an ag flight the acft's eng began losing pwr. At the time the acft was about 50 ft AGL & was travelling at 50 mph. The plt made a forced ldg onto a nearby plowed fld. Upon touchdown the rt skid dug into a furrow & the acft rolled over.…Jul 5, 1985 · N161HA · Substantial damage