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 NYC85FA162Accident · 1 fatalField investigationFinal reportBellanca 7GCBC · Cape May, NJThe tow plane came in for a banner pickup. The ground handler holding the tail of the double banner had his left foot caught by the banner as it went airborne. The ground handler was carried 50 to 100 ft in the air prior to falling to the ground. The ground…Jul 4, 1985 · N1880G · No damageNTSB MKC85LA151Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Paragould, ARThe acft was being used in aerial application of ordram when engine failed. A hard landing resulted during the forced landing in an open fld. Investigation revealed the float needle seat ass'y backed out of the threads in the main body of the carburetor FAR…Jul 3, 1985 · N5543X · Substantial damageNTSB SEA85LA155Accident · No injuriesLimited investigationFinal reportBell 47G2 · Roosevelt, WAA total loss of power occurred while on a CFR 137 flight, due to fuel exhaustion. Although the fuel gauge showed 1/2 tank of fuel, the pilot failed to visually check the fuel prior to this flight. During autorotation onto a wheat field a hard landing occurred…Jul 2, 1985 · N11VH · Substantial damageNTSB DEN85LA177Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Platte, SDWhile the plt was spraying a field, the landing gear of the acft struck the center pivot of an irrigation structure. Later, when the acft was landed, the gear collapsed.Jul 1, 1985 · N6674K · Substantial damageNTSB ANC85LA115Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Sandy Piont, AKPilot lost control while attempting to demonstrate aerobatic flight at low altitude and crashed.Jul 1, 1985 · N49512 · Substantial damageNTSB SEA85LA154Accident · No injuriesLimited investigationFinal reportCessna 150G · Asotin, WAWhile maneuvering, the aircrafts engine sputtered and then quit. During forced landing on a freshly plowed field, the aircrafts nose wheel dug in and collapsed. The acircraft nosed over. The aircraft was examined by an a & p mechanic and no abnormalities…Jun 29, 1985 · N3814J · Substantial damageNTSB LAX85LA299Accident · Minor injuriesLimited investigationFinal reportBell 206B3 · Grand Canyon, AZDuring a movie filming flight, the helicopter was acting as the camera platform and filming a fixed wing aircraft during a straight in appraoch to the airport, the plt of the helicopter requested a right 180 degree turn at mid field to land at the north…Jun 28, 1985 · N2766Y · Substantial damageNTSB ATL85FA198Accident · Serious injuriesField investigationFinal reportPiper J3C-65 · Dothan, ALA witness related that she observed the acft flying low over fields and trees. She lost sight of the acft as it went around a bend in the road. When she rounded the curve she saw the acft nose down in a field with the tail pointed virtually straight up. The…Jun 28, 1985 · N151A · Substantial damageNTSB SEA85LA152Accident · 1 fatalLimited investigationFinal reportPiper PA-25-235 · Burns, ORDuring aerial applications the pilot cleared a rise, got a down draft, struck trees and then stalled striking the ground with little forward motion. An intense explosion and fire followed. The fire origin was in the area of the fiberglass fuel tank. An…Jun 27, 1985 · N6647Z · DestroyedNTSB ATL85FLT08Accident · Serious injuriesFinal reportCessna A188B · Marks, MSThe plt reported that while he was on an aerial application flt, a rain storm suddenly began & forced him to quickly return & land. He reported that the rain was so heavy that he could only see straight down. He contacted his ground crew & asked them to help…Jun 27, 1985 · N4905Q · Minor damageNTSB CHI85FA253Accident · 2 fatalField investigationFinal reportPiper PA-28-151 · Reedsburg, WINo known witnesses observed the plt preflt the acft or takeoff. He departed in the evening while the arpt was not attended. At aprx 2012 CDT, his son observed & recognized the acft. At that time, the son was at his own home about 1/2 mi from the plt's home.…Jun 26, 1985 · N32461 · DestroyedNTSB SEA85LA151Accident · 1 fatalLimited investigationFinal reportBell UH-1B · Hoquiam, WAThe helicopter was being used during an external load operation to move large blocks of wood. However, while hovering, the sling broke. Subsequently, a block of wood struck a company employee on the head while he was working on the ground. The employee was…Jun 25, 1985 · N4991D · No damageNTSB SEA85LA149Accident · No injuriesLimited investigationFinal reportPiper PA-25-235-C · Wenatchee, WADuring an aerial applications maneuver the engine ceased operating and a forced landing was made in an orchard in between apple tree rows. Engine and aircraft inspection could not reveal any abnormalities with the exception of a very dirty, partially clogged…Jun 25, 1985 · N7396Z · Substantial damageNTSB CHI85FA251Accident · 1 fatalField investigationFinal reportNeumann-Everett N2 · Cambridge, MNThe newly rated prt plt was on his 12th flt in the recently certificated homebuilt that he had designed and built himself. While performing an unknown maneuver both horizontal stabilizers and both wings separated from the acft. The acft was restricted from…Jun 24, 1985 · N2287D · DestroyedNTSB ANC85FA107Accident · 1 fatalField investigationFinal reportPiper PA-18 · Lake Beverley, AKThe plt stated that he & his student plt was flying around the lake well below the tree line, & after a steep right bank the acft struck the trees & crashed in the lake, the acft sank into 10 to 12 ft of water.Jun 23, 1985 · N74963 · Substantial damageNTSB SEA85LA146Accident · No injuriesLimited investigationFinal reportGrumman 164B · Twin Falls, IDA partial loss of power occurred during aerial application due to a crack around one of the cylinders. While the plt was attempting to dump chemicals, the acft settled onto the ground tearing off the rt main gear. The plt then flew on to Twin Falls to land.…Jun 22, 1985 · N6762K · Substantial damageNTSB SEA85FA147Accident · 4 fatalField investigationFinal reportCessna C-177RG · Yakima, WAThe pilot, while in slow-flight configuartion, at low altitude, in light chop, failed to see and avoid trees. Resulting tree impact caused acft into stall conditions. Acft contacted other trees, crashed and burned.Jun 22, 1985 · N1983Q · DestroyedNTSB FTW85LA264Accident · Serious injuriesLimited investigationFinal reportBellanca 7ECA · Ville Platte, LAThe plt had rented the acft for a local flt and was observed by ground witnesses to have flown very low (50 ft AGL) over miller lake when the left wing struck a tree. The acft continued for aprx 50 ft in a left wing low attitude before striking another tree,…Jun 22, 1985 · N53958 · DestroyedNTSB FTW85LA262Accident · Minor injuriesLimited investigationFinal reportBell 206L-1 · Ship Shoal BlkThe pilot had landed on the offshore platform and was in the process of repositioning the helicopter to one side of the landing pad to provide additional space for another aircraft when the main rotor blades struck a 3' steel sign post. Theblade separated…Jun 22, 1985 · N1086Q · DestroyedNTSB DEN85LA173Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Deming, NMThe plt told FAA he was spraying a cotton field and was turning around from a swath run when the propeller feathered. The plt told NTSB that the acft 'pitched upward and lost power.' Acft type certificate shows that a hamilton standard propeller m/n…Jun 22, 1985 · N5337 · Substantial damageNTSB CHI85LA246Accident · Minor injuriesLimited investigationFinal reportAnderson Skybolt · Escanaba, MIPrior to the acdnt, the acft was observed making repeated low passes over the area where it subsequently crashed. Witnesses reported that during a turning maneuver over water, the acft collided with the surface & crashed. A police officer, who responded,…Jun 22, 1985 · N66AA · Substantial damageNTSB LAX85LA287Accident · No injuriesLimited investigationFinal reportCessna 152 · Filmore, CAThe plt flew into a canyon with the intention of turning around to back out. He then decided the canyon was too narrow for a 180 degree turn. He continued flying up the canyon while attempting to gain alt, however, the rising terrain exceeded the acft's climb…Jun 21, 1985 · N24338 · DestroyedNTSB LAX85FA286Accident · 2 fatalField investigationFinal reportBell 214B-1 · Squaw Valley, CAThe helicopter was engaged in lowering a large pole to the ground when the eng failed catastrophically due to a total first turbine rotor disc failure. The plt turned the acft down the mountain but was unable to gain enough speed to autorotate. The acft…Jun 20, 1985 · N214RM · DestroyedNTSB ATL85FA191Accident · 1 fatalField investigationFinal reportPiper J5A · Cleveland, GAThe plt took off from a private strip with his 5 yr old daughter on board. He then made several low passes by a guest house so that his daughter could wave to her grandparents. The acft was last seen headed generally in a northerly direction when it banked…Jun 20, 1985 · N35612 · Substantial damageNTSB MKC85FA134Accident · 1 fatalField investigationFinal reportRyan Navion A · Kingman, KSAfter departing a pvt strip the acft was observed to perform some low altitude aerobatic maneuvers. The maneuvers consisted of two snap rolls at about 100 feet off the ground. The acft was observed descending steeply on the second roll maneuver until striking…Jun 19, 1985 · N4974K · DestroyedNTSB LAX85LA284Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Glenn, CADuring initial climb on an ag flight the plt reported experiencing a loss of eng power. From the acft's alt of 30 ft AGL the plt attempted an emergency landing but did not have sufficient alt to negotiate a turn back toward the road from which he had…Jun 19, 1985 · N73646 · Substantial damageNTSB FTW85FRD02Accident · 1 fatalFinal reportTeratorn Tierra II · Lake Charles, LAThe acft impacted the terrain in an uncontrolled descent. Witnesses stated the acft was participating in a bean bag drop contest when the accident occurred. After dropping the last bag the acft made a turn to the west, entered a spin and descended to ground…Jun 18, 1985 · N4438V · DestroyedNTSB SEA85LA140Accident · Serious injuriesLimited investigationFinal reportCessna 188A · Pocatello, IDDuring aerial application the aircrafts engine ceased operating. During engine tear down it was discovered that the engine's #2 connecting rod was broken and had come through the top of the crankcase. Recommended overhaul time is 1200 hours. This engine had a…Jun 17, 1985 · N5695J · Substantial damageNTSB MKC85FA133Accident · 2 fatalField investigationFinal reportHildebrand Spezio Sport DAL-1 · Gravois Mills, MOWitnesses reported that the acft made at least two complete circles over a cove on lake of the ozarks at low alt. Part of the acft track took it over the southeast shoreline where several lake homes are located. During the third circle, as the acft approached…Jun 17, 1985 · N1141L · DestroyedNTSB DEN85LA161Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Clovis, NMAs the plt was pulling up over a power line at the end of a spray run, the eng lost power & smoke began coming from the right side of the eng. The plt turned to land in a field, but was unable to align the acft with forrows. During a forced landing, the acft…Jun 17, 1985 · N2312U · Substantial damageNTSB MKC85FCD01Accident · 1 fatalFinal reportJoel K. Senter RV-4 · Jefferson, IAThe acft crashed out of control after & low alt demonstration passes above rwy at about 50 ft AGL. After the last pass, a low airspeed maneuver. The plt executed a steep turn and descended in a nose low attitude to ground impact.Jun 16, 1985 · N4703S · DestroyedNTSB FTW85LA258Accident · No injuriesLimited investigationFinal reportCessna 150 · Girard, TXThe plt stated he had just buzzed a friend's house when the eng began running rough. He was making a precautionary landing on a country road when a wing dropped and drug on the side of the adjacent ditch. The acft spun around 180 degs,sustaining substantial…Jun 16, 1985 · N1991Z · Substantial damageNTSB CHI85LA239Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Deckerville, MIPurpose of the flt was a 'flour bombing contest'. After dropping a 'flour bomb' the plt entered a right bank to avoid trees along the flt path. The acft then stalled and impacted the ground on the main gear after which it nosed over.Jun 16, 1985 · N57250 · Substantial damageNTSB MIA85FA193Accident · 2 fatalField investigationFinal reportNorth American SNJ-5 · Stuart, FLThe acft was observed by witnesses flying slow at an estimated alt of 700 ft. the acft was observed to stall, enter an over the top spin which immediately evolved into an upright spin. Recovery was not executed prior to the acft crashing into the ocean.…Jun 15, 1985 · N988E · DestroyedNTSB DEN85LA166Accident · No injuriesLimited investigationFinal reportPiper PA-25 · Leonard, NDDuring an aerial spray operation, the plt returned to a field with his 2nd chemical load. As he descended over trees to begin a swath run, he began a flare, but the acft continued descending & impacted the ground. The right landing gear was torn off & the…Jun 15, 1985 · N4733Y · Substantial damageNTSB MIA85LA192Accident · Minor injuriesLimited investigationFinal reportBell 206B · West Palm Beach, FLTwo helicopters had just completed a mail delivery operation as a flt of two. N159L had landed and the plt left the eng running so as to let the eng operting temp stabilize. N156L approached in a ground hover and collided with N159L. The two plts received…Jun 14, 1985 · N156L · 2 aircraft · DestroyedNTSB FTW85LA256Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-301 · Brownsville, TXThe ag acft was destroyed when it failed to pull out of an aerial application maneuver following the initial swath run over a field. The plt stated that after making his turn to return to the field, he attempted to level the acft and received no response from…Jun 14, 1985 · N23692 · Substantial damageNTSB DEN85LA163Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Sunspot, NMThe plt was flying in the valleys of mountainous terrain. He elected to fly to the left around what appeared to be a small hill, but was actually part of a ridge line. Subsequently, the acft entered a 'draw' & would not out-climb rising terrain. The acft…Jun 14, 1985 · N47822 · DestroyedNTSB CHI85LA244Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Mcconnelsville, OHThe student plt had taken the acft without authority of the owner & reportedly was using it to elude police. While flying at low alt, he attempted to pass under wires along a state hiway. However, the acft impacted an embankment in a nose low, wings level…Jun 14, 1985 · N7122F · Substantial damageNTSB SEA85FA134Accident · 1 fatalField investigationFinal reportBell UH-1B · Juneau, AKWhile engaged in a log slinging operation over mountainous, densely forested terrain the rotor craft suffered a total power loss forcing the pilot to execute an autorotative landing into high conifer trees. Disassembly of the engine revealed evidence that the…Jun 11, 1985 · N99676 · DestroyedNTSB NYC85FA145Accident · 1 fatalField investigationFinal reportSikorsky S76A · Belmar, NJDuring takeoff & landing practice for a pre-solo plt the CFI saw a helicopter, N176FJ, approaching the arpt. N4956B, at the time of 1st sighting, was on a left base for rwy 3. The rotorcraft apparently did not see N4956B or hear any radio calls at this…Jun 11, 1985 · N176FJ · 2 aircraft · Substantial damageNTSB MKC85LA123Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Paragould, ARPilot was seeding rice when the engine failed. Pilot attempted forced landing on gravel road and impacted a utility pole before touchdown. Acft destroyed by impact and post impact fire. The reason for the engine failure could not be determined.Jun 11, 1985 · N48523 · DestroyedNTSB MIA85LA188Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Wabasso, FLThe acft nosed over during a forced landing on a beach. The plt was on a solo flt to practice maneuvers. He stated that when pwr was reduced to 1500 RPM in preparation for a stall series the RPM continued to decrease to aprx 1100. He was not able to regain…Jun 11, 1985 · N2603C · Substantial damageNTSB MKC85FA124Accident · 1 fatalField investigationFinal reportE.T. Meredith III Christen Eagle II · Carlisle, IAThe aerobatic airplane had a total of 23.6 flight hours at the time of this accident. This accident pilot had flown 6.3 hours of that time. The aircraft log did not indicate any spin practice by this pilot in this airplane but did indicate three flights with…Jun 9, 1985 · N33ET · DestroyedNTSB DEN85LA155Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Fillmore, UTThe plt reported the engine failed while he was spraying a corn field, necessitating a straight ahead forced landing. During the landing roll the wheels bogged down in the soft earth and the plane overturned. Subsequent examination of theengine by the plt…Jun 9, 1985 · N7346Z · Substantial damageNTSB DEN85FA153Accident · 1 fatalField investigationFinal reportPiper PA-32R-300 · Melstone, MTThe acft was observed in a left turn in a steep dive until it passed out of view behind a hill. The investigation revealed no evidence of airframe or engine malfunction or failure piror to the crash. Medical findings revealed the plt, sole occupant, had 90…Jun 9, 1985 · N75063 · Substantial damageNTSB MKC85LA125Accident · No injuriesLimited investigationFinal reportSnow AT301 · Marianna, ARAfter departing the ag strip the plt rptd a vibrating engine which shook violently until finally quitting. The plt responded with an emergency landing attempt to a plowed bean field. The acft impacted the soft terrain at a high rate of speed where the acft…Jun 8, 1985 · N5078S · Substantial damageNTSB MIA85FA187Accident · 1 fatalField investigationFinal reportErcoupe 415-C · Daytona Beach, FLAccording to witnesses, the plt was flying at a very low alt & was making 's' turns while proceeding southbound along a Beach. During the last left turn toward the east, the acft turned further left toward the north. While turning, the left wing struck water…Jun 8, 1985 · N99018 · DestroyedNTSB DEN85LA160Accident · No injuriesLimited investigationFinal reportAyres S2R-600 · Gardner, COThe ag-acft stalled & crashed during an ag operation in high density alt. The mountainous terrain and downdrafts contributed to the overall effect of dissapating the clearance between the acft & the undulating terrain.Jun 8, 1985 · N4871X · DestroyedNTSB CHI85FA226Accident · 1 fatalField investigationFinal reportSchweizer G-164A · Red Lake Falls, MNThe plt had been spray a field in north & south directions, then elected to make a swath run from east to west toward the sun. This pass was made late in the day. While on the swath run, the acft collided with an unmarked wire, then veered & crashed in a…Jun 8, 1985 · N6761Q · Destroyed