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 LAX85FA241Accident · 1 fatalField investigationFinal reportNorth American AT6A · Lemoore, CAAfter dropping a parachutist to open an air show the plt's takeoff was delayed by a blown tire on a landing airplane and difficulties with filling his smoke oil tank. After completing about two thirds of his aerobatic routine the plt recovered from a reverse…May 5, 1985 · N144KM · DestroyedNTSB CHI85FA186Accident · 2 fatalField investigationFinal reportPiper PA-38-112 · Lakeville, MNThe acft was observed to enter a spin from aprx 3000 ft AGL. The acft continued the spin to ground contact which witnesses stated occurred as the acft seemed to level off. Witnesses also reported seeing the acft perform aerobatics, which included loops, prior…May 5, 1985 · N2475L · DestroyedNTSB DEN85LA123Accident · No injuriesLimited investigationFinal reportCessna 172 · Garfield, COThe acft collided with terrain on the east side of monarch pass near Garfield, CO. The three occupants, all pilots, were not injured. The acft departed salida, CO, located aprx 20 miles east of the pass. The plt stated that the acft would not climb above…May 1, 1985 · N737DH · Substantial damageNTSB SEA85FYM01Accident · Serious injuriesFinal reportAir Tractor AT301 · Weston, ORDuring this aerial application flight the aircraft clipped a tree and then impacted with the ground. The pilot was seriously injured when the stitching on the shoulder harness failed and the pilot was thrown forward.Apr 30, 1985 · N3652F · DestroyedNTSB LAX85FJA02Accident · No injuriesFinal reportRobinson R-22 · Hilo, HIThe acft rolled onto its left side within 10 ft of where it was parked prior to flt, the plt was attempting to come to a hover when it rolled. This was the plts 2nd attempt at solo flt in the helicopter. No mechanical malfunctions were noted during the post…Apr 29, 1985 · N8447C · Substantial damageNTSB MKC85LA091Accident · No injuriesLimited investigationFinal reportPiper PA-25-235C · Grenola, KSWhile maneuvering during a swath to a field, the engine quit. The plt was operating his acft for aprx 1/2 hr prior to the loss of pwr. The plt states he visually checked the fuel level. An inspection of the acft engine revealed no mechanical failure or…Apr 28, 1985 · N8624L · DestroyedNTSB CHI85LA179Accident · No injuriesLimited investigationFinal reportPitts Pitts S2B · Indianapolis, INThe acft performed 4 aileron rolls during which some alt was lost with each roll. During the final roll a wing made ground contact and folded as the acft slid to a stop.Apr 28, 1985 · N260JH · Substantial damageNTSB MIA85LA160Accident · No injuriesLimited investigationFinal reportCessna C-182J · Loughman, FLThe acft was towing a banner at 500 ft alt when the engine lost power. The pilot amde an emergency landing in a sandy field and the acft nosed over. The acft had flown 1 hr 15 min with the fuel tank selector on 'both'. The acft took off with a total of aprx…Apr 27, 1985 · N2892F · Substantial damageNTSB MIA85LA158Accident · No injuriesLimited investigationFinal reportCessna 172K · Sharpes, FLCarburetor had rusted parts and needed an overhaul. Pilot was demonstrating power off stall to passengers, when he tried to apply power, engine did not respond. Landed in soft terrain. Swerved to avoid ditch. Nose wheel collapsed.Apr 27, 1985 · N46494 · Substantial damageNTSB MKC85FA089Accident · 2 fatalField investigationFinal reportPiper PA-24-260 · Wakeeney, KSOn a x-country flt from dodge city, KS, to hill city, KS, the plt encountered IFR wx conditions around Wakeeney, KS. The IFR conditions were not forecast for his area of flt. A 2000 CST observation at hill city, KS, was indicating IFR conditions existing aprx…Apr 26, 1985 · N8852P · DestroyedNTSB FTW85FPA01Accident · Minor injuriesFinal reportAir Tractor AT301-A · Rockwall, TXThe acft nosed over during a forced landing in a plowed field after the engine quit. Later exam showed water and fuel in the carburetor. The plt had expressed concern about contaminated fuel. The fuel came from the plt/operators own supply.Apr 25, 1985 · N2361C · Substantial damageNTSB DEN85FA120Accident · 1 fatalField investigationFinal reportCessna P210N · Laporte, COThe plt was a business man, involved in building/construction work. On the morning of the acdnt, he had breakfast with friends who said he was in good spirits & was going to fly before going to work. Witnesses near the acdnt site saw the acft flying in the…Apr 22, 1985 · N6208W · DestroyedNTSB MKC85FA087Accident · 1 fatalField investigationFinal reportGrumman G-164A · Coy, ARWhile approaching a field to dispense rice, the acft struck a set of power lines. The plt had flown over the same set of power lines for nearly 2 hours. The flagmen stated they heard the acft strike the wires and one of the wires made a 'pop' as if being…Apr 20, 1985 · N8729H · DestroyedNTSB LAX85FA217Accident · Minor injuriesField investigationFinal reportBell 206-L1 · Kailua/Kona, HIA revenue sight-seeing helicopter flight operating under 14 CFR 91 collided with lava rock while attempting a forced landing on the summit of muana loa volcano after a partial loss of power. The pilot stated that while in a shallow downwind turn at aprx 200…Apr 20, 1985 · N478KA · DestroyedNTSB ATL85FA143Accident · 2 fatalField investigationFinal reportChampion 7GCA · Collinsville, MSWitnesses, friends of the plt, reported seeing the acft engaged in aerobatics at altitudes between 500 ft AGL and 2000 ft AGL, aprx 1/4 mile from their outdoor social function. They continued to report, the acft entered a spin and after aprx 2 3/4 revolutions…Apr 20, 1985 · N9636S · DestroyedNTSB MIA85FA150Accident · 2 fatalField investigationFinal reportBellanca 8KCAB · Clearwater, FLThe pilot was observed doing low level aerobatics. While diving inverted over the water, he attempted to perform an outside loop. The acft impacted the water inverted after the stall onset. Interviews with fellow pilots disclosed that the pilot had been…Apr 19, 1985 · N5054Y · DestroyedNTSB LAX85FA216Accident · 1 fatalField investigationFinal reportPiper PA25-235 · Walnut Grove, CAThe acft flew into the ground on a procedure turnaround while spraying wheat with a toxic chemical. The acft did not stall and the engine sound did not change. A separated aileron crossover cable showed no fatigue. The cholinesterase level in the pilot's…Apr 19, 1985 · N9636P · DestroyedNTSB LAX85FA210Accident · 6 fatalField investigationFinal reportCessna U206G · Tuba City, AZThis was a medical transportation flight during the early morning hours in marginal weather conditions. The flight was not completed and was returning to the departure airport when it descended into desert terrain 10 miles short of its destination.Apr 19, 1985 · N8849Q · DestroyedNTSB FTW85FRA03Accident · 2 fatalFinal reportCondor Condor III · Hockley, TXThe acft collided with the terrain in a near vertical descent. Witnesses stated the ultralight was airborne for aprx 5 minutes before a loud 'pop' was heard and it entered a steep nose down spiral. Inspection of the ultralight revealed a failed bolt in the…Apr 19, 1985 · UNREG · DestroyedNTSB DEN85FA118Accident · 2 fatalField investigationFinal reportCessna 172 P · Santa Fe, NMTwo persons, neither rated as plts, took the acft without the knowledge or consent of the operator or arpt officials. They took off at night, & after a short time, returned to the arpt to land. During an attempted landing, the acft touched down hard, bounced…Apr 19, 1985 · N52457 · DestroyedNTSB ATL85FA140Accident · 2 fatalField investigationFinal reportCessna 140 · Hawesville, KYThe acft collided with and sunk into the Ohio river following a wing separation after contacting the lowest wire in a set of 3 power lines which spanned the river. Two other wires were located above the set of 3 power lines. Witnesses on and near the river…Apr 19, 1985 · N72587 · DestroyedNTSB ANC85LA069Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Beluga, AKAcft was doing low alt turns-about-a-point when the eng quit due to fuel starvation. The acft then crashed into trees. Plt stated the acft had aprx 5 gals of fuel an board at the time of the accident.Apr 18, 1985 · N4228M · Substantial damageNTSB FTW85LA186Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Roby, TXThe pipeline patrol plt diverted from the normal route to circle over a house in which he used to live. Witnesses reported the acft was in a low alt left turn when the left wing dropped and the rate of turn increased. The acft impacted a tree in a steep nose…Apr 17, 1985 · N89862 · DestroyedNTSB MKC85FCA02Accident · Serious injuriesFinal reportPiper PA-25-235 · Dexter, MOThe plt was making a swath run while on an aerial application training flt. During a pull-up at the end of the swath run, the rgt wing struck the tops of 3 willow trees. The acft then entered a rgt roll, struck an eletrical power line, rolled inverted &…Apr 15, 1985 · N9826P · DestroyedNTSB FTW85FA188Accident · Serious injuriesField investigationFinal reportBell UH-1B · Boutte, LAThe plt had stabilized acft in a 125' hover, prior to picking up a load, when the eng spooled down and acft entered talltrees with low rotor RPM and pitched nose down as it descended thru the trees. Ground witnesses heard 2 loud 'bangs' prior to the acft…Apr 15, 1985 · N2252A · DestroyedNTSB LAX85FA202Accident · 2 fatalField investigationFinal reportCessna 172M · Camp Verde, AZBoth acft involved in the collision were part of a 4-plane formation flt en route to a group fly-in. N6439R was seen to change positions several times during the flt while the other acft remained stable. Reports from witnesses say that N6439R made 'close…Apr 14, 1985 · N73708 · 2 aircraft · DestroyedNTSB CHI85LA161Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Stevens Point, WIDuring a low level flt over a river, the plt initiated a turn to reverse direction at 300 ft AGL. The acft contacted the water during the descending turn and nosed over.Apr 14, 1985 · N4609X · Substantial damageNTSB MIA85LA145Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Wabasso, FLInstructional flight practicing steep turns. Engine lost oil through crack in propeller governor oil line and seized. Instructor took over control and landed on a road in a sand pit. Pilot was unable to steer through an 's' turn on the road and collided with…Apr 10, 1985 · N2648R · Substantial damageNTSB MIA85FA146Accident · Serious injuriesField investigationFinal reportBell 47G-2 · Panama City Bch, FLThe pilot was carrying two paying passengers for a sightseeing ride and had taken off two minutes earlier from a helicopter pad at the beach. He stated that he felt the engine sputter, the cyclic stick shake, less than 10 seconds later the acft hit the water…Apr 10, 1985 · N54522 · Substantial damageNTSB FTW85FA176Accident · Serious injuriesField investigationFinal reportCessna 152 · Arlington, TXAcft on traffic patrol watch was observed for several minutes before crash at low altitude doing slow flt and flying erratic prior to acft stalling ans spinning into apt building no evidence of pre-impact failure or malfunction of the acft was found.Apr 10, 1985 · N49831 · DestroyedNTSB SEA85FA082Accident · 3 fatalField investigationFinal reportCessna 172B · Smith, NVAccording to witnesses, the plt made multiple passes over his residence at low alt. The witnesses observed the acft in various maneuvers at low alt. One maneuver was described as a pull-up from about 100 ft to aprx 600 ft, where the acft went into a wingover…Apr 3, 1985 · N6923X · DestroyedNTSB MKC85FA080Accident · 1 fatalField investigationFinal reportGulfstream-Schweizer G-164B · Garland, ARThe plt was beginning a spray run over a wheat field when the acft impacted the top 3 strands of a 4 strand, high voltage power line. The acft then descended uncontrolled until impact with the terrain.Apr 1, 1985 · N8418K · DestroyedNTSB FTW85FPJ01Accident · Serious injuriesFinal reportGrumman AG CAT G-164 · Norman, OKThe acft collided with a high static wire on an electric transmission line before colliding out of control with the ground. The plt stated after the accident that he forgot about the static line and flew into it during a maneuver for aerial spraying.Apr 1, 1985 · N5338 · DestroyedNTSB FTW85FA171Accident · 1 fatalField investigationFinal reportCessna T210N · Riesel, TXThe acft eng had just been top overhauled and a stol kit was added. The mechanic reportedly told the plt to be 'easy' on the eng and fly the acft 45-60 mins near the traffic pattern so it could be checked for oil leaks. The plt reportedlyignored these…Apr 1, 1985 · N6436N · DestroyedNTSB NYC85LA093Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Orange, MAThe plt reported he was flying at about 25 ft above water. As the acft crossed over a grass covered sand bar, the gear encountered 'swail grass' & the acft was 'dragged in.' The plt also reported that the acft had encountered turbulence; however, a witness…Mar 30, 1985 · N43871 · Substantial damageNTSB LAX85LVM03Accident · No injuriesFinal reportBell 47G-2 · Watsonville, CAThe plt stated he intended to climb over a pwr line at the end of a swath run, however, a tailwind gust was encountered and the acft could not obtain sufficient altitude to clear the line. The plt elected to fly under the line unaware of a lower line which…Mar 30, 1985 · N4227B · DestroyedNTSB ANC85LA061Accident · No injuriesLimited investigationFinal reportCessna 150C · Kenai, AKThe pilot was on a local pleasure sightseeing trip when the engine quit; the pilot attempted a forced landing on a road. Just before touchdown the aircraft struck two power lines. The pilot stated that he ran out of fuel and he believed that he had enough…Mar 30, 1985 · N7866Z · Substantial damageNTSB LAX85LA187Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Banning, CAThe acft collided with a power line 50 ft AGL while maneuvering over a freeway at low alt. A palm springs ATC employee who was driving his car in the eastbound lane of I-10 aprx 10 NM east of the Banning arpt, observed the accident acft on a westbound heading…Mar 23, 1985 · N6653G · Substantial damageNTSB ATL85FMG04Accident · 1 fatalFinal reportGross Taylor Titch · Liberty, NCAccording to witnesses interviewed, pilot made a takeoff on runway 2, holding the plane just a few feet off the runway with a steep pull up at the end of the runway. It was then observed doing a steep bank, low altitude 180 degree turn and proceeded…Mar 23, 1985 · N9438 · DestroyedNTSB DEN85FA102Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Vail, COThe plt did not obtain a wx briefing, file a flight plan or refuel the acft prior to departing for eagle Colorado. The acft departed at 1800 under VFR cond. The plt reported over minturn co at 2019. Witnesses at Vail co stated that the wx cond were poor from…Mar 22, 1985 · N8359B · DestroyedNTSB SEA85LA077Accident · No injuriesLimited investigationFinal reportGrumman G-164-A · Dufur, ORA loss of power occurred during aerial application and a forced landing was made onto a field. The right main gear sank into a hole and was torn off. The acft then flipped inverted. The throttle leakage was found to be broken.Mar 17, 1985 · N5326 · Substantial damageNTSB FTW85FA152Accident · 1 fatalField investigationFinal reportUniversal Stinson 108 · Emhouse, TXWitnesses observed the student plt making repeated low passes near his friend's house. While maneuvering, the acft collided with a power line, then crashed to the ground inverted. The student held a student plt certificate that was dated 10/17/62. No record…Mar 17, 1985 · N953D · Substantial damageNTSB MIA85LA121Accident · No injuriesLimited investigationFinal reportCessna 152 · Miami, FLThe acft collided with trees while the plt was practicing slow flt on a solo training flt. The plt stated after the accident that he diverted his attention from outside to the acft instrument panel and felt a jolt. A full pwr recovery to level flt was made…Mar 14, 1985 · N95627 · Substantial damageNTSB ANC85FA056Accident · 1 fatalField investigationFinal reportPiper PA-18 · Koyukuk, AKThe plts of N62744 & three other acft were on an aerial hunting flt. Witnesses in two of the other acft stated the plt of N62744 was maneuvering near a wolverine, but was flying too fast. He announced on the radio that he was going to come back for another…Mar 14, 1985 · N62744 · Substantial damageNTSB MKC85FA069Accident · 1 fatalField investigationFinal reportCessna 150F · Waldron, MOWhile maneuvering northbound on the Missouri river levee the passenger noticed the plt flying just above the levee road. The passenger stated the plt told him they were forty feet off the ground but sometimes lower. The passenger stated he saw the pickup…Mar 9, 1985 · N8078F · DestroyedNTSB FTW85LA146Accident · No injuriesLimited investigationFinal reportCessna 150G · Onalaska, TXPilot anderson was on a business type flight. He stated he lost engine power and attempted to make a forced landing. He was unable to land and collided with a electric pole then a porch railing and flipped inverted. Cause of loss of engine power not…Mar 9, 1985 · N4767X · DestroyedNTSB CHI85LA134Accident · No injuriesLimited investigationFinal reportHughes 269C · Center Village, OHWhile the student plt practiced hovering 8 to 12 inches AGL the heel of the right skid contacted the ground. The CFI stated he did not notice the helicopter drifting or descending but when the ground contact was felt he took over the controls. Up collective…Mar 9, 1985 · N5125U · Substantial damageNTSB ATL86FA028Accident · 2 fatalField investigationFinal reportPiper PA-32-301 · Robbinsville, NCMsg acft found after 9 mos. Remains found on east side of coline ridge in graham co NC. Path of broken limbs/trees about level into mountainside. Both occupants fatal.Mar 9, 1985 · N8470X · DestroyedNTSB ANC85FA052Accident · 1 fatalField investigationFinal reportBell 206B · Whittier, AKThe helicopter impacted terrain in a 150 ft gorge after contacting telephone lines along a railroad right-of-way aprx 2 miles north of a tunnel station. Purpose of the flt was to survey the area around the tunnel station.Mar 9, 1985 · N2060V · DestroyedNTSB SEA85LA068Accident · No injuriesLimited investigationFinal reportCessna 150F · Nampa, IDWhile flying at ngt in the LCL practice area south of Nampa, the plt thought he had flown into IMC, but the wx was good. He was unable to see the ground, so he made a 180 deg turn, then noted problems seeing his instrument panel. Suspecting psbl carbon…Mar 6, 1985 · N6812F · Substantial damage