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 DEN83LA006Accident · Minor injuriesLimited investigationFinal reportBell 47G3B1 · Malta, MTThe pilot stated that he "was spraying the alfalfa field west to east" and that "there were tall cottonwood trees on three sides. A very sudden wind "came up" and "pushed" him into a tree.Oct 2, 1982 · N7928S · Substantial damageNTSB ANC83FAA03Accident · No injuriesFinal reportPiper PA-18 · 27 E Sagwon, AKThe plt was inspecting a landing site for possible use. A low pass was being made at approximately 3 ft when the acft encountered a downdraft & impacted a rocky ridge area short of the site.Oct 1, 1982 · N13960 · Substantial damageNTSB FTW82FA402Accident · 1 fatalField investigationFinal reportRobinson R-22 · Paige, TXFollowing completion of the helicopter's annual inspection, the aircraft mechanic/pilot departed clover field in houston for the R22'S home base in austin, TX. One witness observed the helicopter in cruise flight, then saw a large piece separate from the…Sep 30, 1982 · N9063Z · DestroyedNTSB SEA82FA175Accident · 2 fatalField investigationFinal reportCessna 305A · Belden, CADuring a search mission, the subject aircraft was seen to turn, then apparently slow or pause and then disappear inverted into high trees at the 4600 foot level. Parts of the aircraft being searched for were only 300 feet from the crash of the subject…Sep 27, 1982 · N5196G · DestroyedNTSB LAX82DA365Accident · No injuriesFinal reportGrumman G-164B · Delano, CAAircraft collided with wires during spraying of grapes. No air or ground survey made which was a normal procedure. Work pressure created the deviation.Sep 27, 1982 · N48482 · DestroyedNTSB LAX82FJA07Accident · 2 fatalFinal reportBellanca 7KCAB · Makawao, HIFor insurance purposes, the owner needed about 15 more hours in the tailwheel aircraft before he could fly solo without an instructor. On 9/24 and 9/25, the owner and instructor planned to fly the needed time. Maui tower controllers reported the plane…Sep 25, 1982 · N8656V · DestroyedNTSB FTW82FPM16Accident · 1 fatalFinal reportMustang II · Tahlequah, OKThe amateur built Mustang ii crashed while attempting a roll during the annual tulsa fly-in at Tahlequah airport. The acft was observed making a hi-speed fly-by over runway 35 at approximately 50 ft AGL, and start a gradual climb & roll to the right to…Sep 25, 1982 · N48342 · DestroyedNTSB FTW82DA393Accident · Minor injuriesFinal reportBellanca 7GCBC · Bracketville, TXPilot stated that while flying low over a ranch looking for lost cows, he flew into high powerlines. He also stated thathe was aware that the powerlines were in the area.Sep 24, 1982 · N8744V · DestroyedNTSB SEA82DA172Accident · No injuriesFinal reportCessna 188B · Lava Hot Spring, IDReportedly, the aircraft ran out of fuel during a swath run. During a forced landing, the aircraft struck a fence, then traveled about 400 ft and stopped with the nose down in a potatoe field.Sep 23, 1982 · N9251G · Substantial damageNTSB ATL82DA283Accident · No injuriesFinal reportGlasflugel Mosquito · Tazewell, VAThe glider pilot was participating in a cross-country contest. As he was passing one of the turn points, he maneuvered to photograph the position. During this time, he went too low and was forced into making an emergency landing. While maneuvering to land, he…Sep 23, 1982 · N12JR · Substantial damageNTSB MIA82DA187Accident · No injuriesFinal reportPiper PA-36 · N. Chipley, FLAircraft collided with a tree while spraying. Aircraft then landed hard in the bean field.Sep 21, 1982 · N2327Y · DestroyedNTSB LAX82FXQ14Accident · 2 fatalFinal reportPiper PA-38 · Imlay, NVThe pilot flew up a canyon in weather that obscured the ridges in low visibility and rain. Clouds also covered the terrain. A witness saw the aircraft disappear behind a hill and a storm obscured her vision and hearing. The aircraft was located in a box…Sep 19, 1982 · N24641 · DestroyedNTSB LAX82DA349Accident · No injuriesFinal reportNorth American P-51D · Reno, NVThe engine failed & caught fire during the national championship air races. The plt stated he was pre-occupied trying toput out the engine fire & turned base too late. The acft landed short of the rwy on a poorly graded road & the plt lost control of the acft.Sep 18, 1982 · N151DM · Substantial damageNTSB CHI82FA357Accident · 2 fatalField investigationFinal reportFlitecraft Senior Aero · Footville, WIThe home built aircraft was on a familiarization flight for the pilot in the right seat. One witness stated he saw the aircraft (at about 2000 ft AGL) enter a nose high (straight up) attitude followed by a nose low (straight down) attitude. A spin then…Sep 18, 1982 · N119P · DestroyedNTSB DEN82FTI18Accident · Serious injuriesFinal reportCessna 150 · Conrad, MTPilot had engine lose power momentarily on a previous flight but did not concern himself about it. During this flight power was lost at 4100 feet. Pilot tried restart without success. During landing nose was lowered prior to touchdown and it caught on an…Sep 17, 1982 · N1299Q · Substantial damageNTSB DEN82FA198Accident · 1 fatalField investigationFinal reportCessna 152 · Divide, MTThe acft stalled & crashed on the side of a ridge. The plt was described as an avid outdoorsman, sportsman & hunter. According to local residents near the crash site, the area is well populated with large & small game. Density altitude was computed to be…Sep 16, 1982 · N49816 · DestroyedNTSB SEA82FYM24Accident · 2 fatalFinal reportCessna 172P · 3nm Se Scappoos, ORThe acft struck & severed power lines strung between two 90-foot towers located about 1500 feet apart. The power lines were about 50 to 60 feet above the water at the lowest point of the line sag.Sep 15, 1982 · N7335F · DestroyedNTSB FTW82DA380Accident · No injuriesFinal reportCessna 172N · Hobbs, NMPilot collided with power line while on pipeline patrol. A sucessful landing was made at hobb, NM airport after accident.Sep 15, 1982 · N6553E · Substantial damageNTSB DEN82DA195Accident · Serious injuriesFinal reportAerospatiale SA315B · Near Kemmerer, WYWhile hovering with an external load a loud bang was heard and the helicopter started to yaw. The pilot dropped the external load, pulled collective, centered cyclic and started descent. The main rotors hit trees and the aircraft fell to the ground.…Sep 15, 1982 · N7915 · Substantial damageNTSB DEN82FA193Accident · 1 fatalField investigationFinal reportCessna R172K · Vernal, UTThe aircraft collided with trees while low flying on a local flight. Two aircraft piloted by students from a nearby college had been seen flying low and close to each other around the local mountainous terrain. The students were enrolled in the college…Sep 14, 1982 · N758JM · DestroyedNTSB MIA82DA181Accident · Minor injuriesFinal reportBell 47G4 · Madison, FLThe eng did not respond when power was added beginning a swath run. The plt hit the dump button to jettison the load & collided with the ground. Eng teardown revealed no evidence of failure or malfunction prior to the accident.Sep 13, 1982 · N1151W · Substantial damageNTSB LAX82FUQ17Accident · Serious injuriesFinal reportLong-Ez Rutan · Canyon Country, CAThe eng quit as the acft was observed performing acrobatic maneuvers. The acft was not equipped with a fuel system that would sustain fuel flow through negative "g" maneuvers. The eng would stop with a 0.5 negative g load.Sep 13, 1982 · N7LZ · DestroyedNTSB LAX82DXQ13Accident · 2 fatalFinal reportNorth American F-51D · Elko, NVThe plt flew down the length of rwy 06 about 100 ft AGL, pulled up & did an 8-point roll while climbing. He then flew down rwy 12 & pulled up. After a brief climb the plt began a slow roll to the left. Just as the acft became inverted the roll stopped & the…Sep 11, 1982 · N51JW · DestroyedNTSB ATL82DA269Accident · No injuriesFinal reportPiper PA 25-235 · Ray City, GAThe pilot reported that while he was spraying crops, the engine began to skip and backfire. He decided to terminate the swath run and climb from the field. At that time, the engine quit and the pilot climbed as high as possible before gliding to a nearby…Sep 11, 1982 · N7687Z · Substantial damageNTSB FTW82DA374Accident · Minor injuriesFinal reportCessna 172 · Vain, OKThe pilot and his passenger took off on a local flight and flew over a runway that they were constructing in their pasture. The pilot stated that he was in slow flight over the runway. Both occupants received concussions in the accident and could not recall…Sep 9, 1982 · N7424A · Substantial damageNTSB FTW82DA372Accident · No injuriesFinal reportAir Tractor AT-400 · Muleshoe, TXPilot collided with a water spraying machine while making crop spray pass. Landing gear tore off.Sep 9, 1982 · N2369N · Substantial damageNTSB ATL82DA265Accident · No injuriesFinal reportCessna 188B · Gibson, GAThe pilot began a swath run by approaching the field over tall trees. Just beyond the trees was a 7 ft rise in the terrain. The pilot stated that he did not flare soon enough. Reportedly, the plane struck the crop, the gear sheared off and the plane slid to a…Sep 7, 1982 · N4877R · Substantial damageNTSB SEA82FYP11Accident · Serious injuriesFinal reportHiller UH-12-SOLOY · Kellogg, IDThe plt stated he had just released a load of logs & started his transition into forward flt when the eng failed. No usable fuel was on board. The plt stated the fuel gauge registered 50 pounds of fuel when the eng failed. A leak test of the fuel suction…Sep 6, 1982 · N9035H · Substantial damageNTSB MKC82FCG19Accident · 2 fatalFinal reportCessna 172N · Lake Of The Oza, MOWitnesses reported that the pilot made a low pass at a cove, then flew out over the water, turned and flew back at low altitude. During a second low pass, it struck electrical cables that crossed the cove. After hitting the cables, the aircraft crashed in a…Sep 6, 1982 · N6339F · DestroyedNTSB LAX82DA335Accident · No injuriesFinal reportSchempp-Hirth Ventus · California City, CAThe accident occurred during a cross-country glider race involving 41 gliders. Seven or eight gliders were circling in right turns in a thermal at approximately the same altitude when the collision occurred. The plt of the ventus stated his glider became…Sep 5, 1982 · N214T · 2 aircraft · DestroyedNTSB LAX82DA332Accident · 2 fatalFinal reportVarieze Hamlin · Susanville, CADuring a 2nd pass down the runway at about 50 feet AGL, the aircraft pulled up to about 200 feet and completed over halfof a roll, then spiraled into a lake and was destroyed. According to witnesses, the engine was running at all times until impact.Sep 4, 1982 · N777EJ · DestroyedNTSB DEN82DA185Accident · Serious injuriesFinal reportPiper J-3 C65 · Durango, COThe pilot reported that he took off with the doors latched open, and after lift-off, the aircraft failed to exceed 42 mph. He reported that an altitude of about 150 ft was attained. Due to the lack of performance and fearful of obstructions ahead, the pilot…Sep 4, 1982 · N98872 · Substantial damageNTSB DEN82DA183Accident · 1 fatalFinal reportAmerican AA1 · Opheim, MTThe pilot tookoff and made a pass over the airport. At about 500 feet the aircraft began to roll and spun to ground impact. Investigation revealed the pilot was apparently maneuvering and wing dipping for his friends on the ground when the stall occurred.Sep 4, 1982 · N6130L · DestroyedNTSB LAX82DA330Accident · Serious injuriesFinal reportBell 206-L · Lihue, HIDuring a sightseeing trip to the west side of kapalaoa ridge area near punham crater, the pilot experienced a downdraft and then a severe updraft that put him in IFR conditions in the clouds. The helicopter is not equipped for instrument flight and the pilot…Sep 3, 1982 · N59358 · DestroyedNTSB CHI82DA336Accident · Serious injuriesFinal reportBell 47G-5A · Waconia, MNJust prior to the flight, the helicopter had been released by the maintenance section after troubleshooting a squawk concerning a "binding collective." The student and instructor (CFI) departed on a local flight and flew about an hour practicing precision…Sep 3, 1982 · N58077 · DestroyedNTSB MIA82AA177Accident · 2 fatalFinal reportPiper PA-31-350 · Near Lakeland, FLThe flt was conducting single-eng flt tests with the inboard gear doors removed & was being photographed by a chase acft. At the end of the tests the plt was unable to restart the left eng & returned for a single-eng landing. The plt overshot the landing…Sep 2, 1982 · N62957 · DestroyedNTSB LAX82FA329Accident · 2 fatalField investigationFinal reportChampion 7EC · Near Isleton, CAThe pilot and passenger were on a local flight to fly to the san joaquin river delta to observe and photograph a break in the river's level, as well as the passenger's boat. A consensus of the witnesses was that the aircraft was circling the area when it…Sep 2, 1982 · N141A · DestroyedNTSB ANC82DA093Accident · No injuriesFinal reportPiper PA-20 · Near Mcgrath, AKPrior to departure, the pilot serviced the aircraft with fuel and verified the right wing tank was full. The pilot did not switch the fuel selector from the left fuel tank prior to departing. During a low pass over a wooded area, the engine quit. Due to the…Sep 2, 1982 · N1510A · Substantial damageNTSB LAX82DA326Accident · No injuriesFinal reportCessna 172M · San Jose, CAThe aircraft was substantially damaged when a landing gear, damaged by a wire strike, collapsed during landing. Witnesses indicated that the aircraft had entered a narrow valley at treetop level. Broken power lines started a grass fire which was eventually…Sep 1, 1982 · N80301 · Substantial damageNTSB ATL82DA260Accident · Minor injuriesFinal reportCessna A188 · Hillsboro, ALThe pilot reported that while making a swath run to the west over uneven terrain, his right wing contacted the cotton crop that he was spraying. The aircraft crashed and began to burn after coming to rest inverted. The pilot escaped with minor injuries before…Sep 1, 1982 · N9759V · DestroyedNTSB ANC82FA079Accident · 1 fatalField investigationFinal reportCessna A185F · Clarks Point, AKThe aircraft was observed flying at low altitude near the shore line of the bay near Clarks Point. At one Point in the flight, which had been erratic since takeoff, the aircraft pulled up into a vertical climb stalled and spun to the water. The pilot was a…Aug 31, 1982 · N3357S · DestroyedNTSB SEA82FYA10Accident · 1 fatalFinal reportPiper PA-18-150 · Homedale, IDAs the acft made a pass over a field the plt cut the power & slowed the acft into slow flight. The acft then made a steep turn & stalled.Aug 30, 1982 · N54242 · Substantial damageNTSB LAX82DVG31Accident · Serious injuriesFinal reportLindgren Evans VP-1 · Winters, CAAcft ran out of fuel while plt was practicing stalls.Aug 30, 1982 · N64552 · Substantial damageNTSB FTW82DA357Accident · No injuriesFinal reportCessna 152 · College Station, TXAfter the CFI cut power for a simulated forced landing, the student set up an approach to a road. When power was added at the bottom of the approach the engine accelerated to about 75% power & then decelerated back to idle. On touchdown on the road the left…Aug 30, 1982 · N49452 · DestroyedNTSB ATL82DKQ18Accident · Minor injuriesFinal reportAir Tractor 301A · Marks, MSAircraft collided with guy wire while spraying chemicals, aircraft went out of control and crashed.Aug 30, 1982 · N8823S · DestroyedNTSB ATL82DA254Accident · No injuriesFinal reportGrumman G164B · Sampson, ALThe aircraft lost power during a swath run, the pilot attempted to lighten the load but the aircraft collided with a tree. When interviewed the pilot stated that the aircraft was sold for salvage. No examination of the engine was possible but he indicated…Aug 30, 1982 · N6795Q · DestroyedNTSB LAX82FA320Accident · No injuriesField investigationFinal reportCessna 150M · Rancho Santa Fe, CAAs the student was recovering from a slip maneuver at about 1,500 ft power was applied. The eng initially produced about 2500 RPM, then decreased to about 2000 RPM. Application of carburetor heat did not have any effect of the eng RPM.RPM continued to…Aug 29, 1982 · N888GS · Substantial damageNTSB FTW82DA356Accident · No injuriesFinal reportCessna T188C · Black, TXWhile making a swath run the aircraft collided with an irrigation pipe which extended about 15 feet AGL. The pipe was near farm equipment and blended with the background. After the collision the aircraft made a forced landing in a cotton field.Aug 28, 1982 · N9646J · Substantial damageNTSB ATL82DA256Accident · No injuriesFinal reportHughes 269B · Angier, NCWhile spaying soy beans, the pilot observed 3 power lines bordering the field, but failed to see a fourth. While on a swath run, the helicopter struck the fourth line with the main and tail rotor blades which resulted in a forced landing.Aug 28, 1982 · N9374F · Substantial damageNTSB FTW82FRJ17Accident · Serious injuriesFinal reportBell 206B · Jamestown, LAThe pilot was conducting aerial burning operations over a wooded area when he heard a loud bang from the engine area of the helicopter. At that time, the helicopter was approximately 20 ft above the tallest tree in the area with the aerial torch burning. The…Aug 27, 1982 · N5754P · Destroyed