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 NYC84FA306Accident · 2 fatalField investigationFinal reportBellanca 8GCBC · Wilmot, NHWitnesses saw a rt wing section separate when the acft was in a loop. The acft descended and crashed afterwards. The investigation disclosed the pilot had previous aerobatic experience in gliders. No records were disclosed revealing pilot flight time in…Sep 8, 1984 · N86859 · DestroyedNTSB LAX84LA474Accident · No injuriesLimited investigationFinal reportGrumman 164A · Goodyear, AZPlt reported pwr loss occurred during night aerial application. Acft nosed over during forced landing in crop field. Investigation failed to reveal any evidence of a mechanical failure/malfunction. Engine was test run to extent permitted by damage and no…Sep 8, 1984 · N9925 · Substantial damageNTSB LAX84FU033Accident · 1 fatalFinal reportPioneer Flightstar · Lowerlake, CAAfter takeoff the ultralight flew at about 50 ft AGL toward a row of oak trees bordering a pasture. It then struck a 60 ft tree & crashed. Two witnesses who knew the plt well stated he had 'been drinking quite a bit' on the day of the accident. They also…Sep 8, 1984 · UNREG · No damageNTSB CHI84LA385Accident · Serious injuriesLimited investigationFinal reportPitts S-2A · Oak Harbor, OHWitness stated plt was performing aerobatic maneuvers. At the top of a loop (aprx 3000 ft AGL) the acft remained inverted, pwr was reduced and an inverted spin was entered. The acft remained in the inverted spin to water impact. The plt does not recall the…Sep 8, 1984 · N899 · DestroyedNTSB ATL84LU008Accident · 1 fatalFinal reportRotec Ralley 2B · Sherrills Ford, NCThe ultralight was flying over the lake at about 100 ft AGL when the engine began to cut out. The plt had reportedly said to a friend before takeoff that the engine may not be right but he flew it anyway. The ultralight had been flown bythe plt 3 hours…Sep 8, 1984 · UNREG · DestroyedNTSB DEN84FTM03Accident · No injuriesFinal reportRotorway Rotorway Executive · Lehi, UTThe student plt was practicing hover taxiing at the abandoned arpt. While taxiing the right skid hit a 3 inch high moundof dirt. The acft bounced up and rolled to the left. The plt attempted to correct using the cyclic but the acft began to roll further to…Sep 7, 1984 · N5211F · Substantial damageNTSB LAX84FA469Accident · 2 fatalField investigationFinal reportCessna T210J · Valencia, CAWitnesses observed the acft entering a slow roll maneuver. As the acft became inverted, the roll rate decreased, the nose of the acft dropped toward the ground & the plane crashed. No preimpact part failure or malfunction was found. Toxicological checks of…Sep 6, 1984 · N2291R · DestroyedNTSB MKC84LA269Accident · Minor injuriesLimited investigationFinal reportRockwell S-2R · Weiner, ARThe plt was executing a turn around maneuver to continue spraying when the #2 cyl broke free from the eng & it completely shut down. The acft struck the levee of a bean field & flipped over, coming to rest in an inverted position. Post crash examination…Sep 5, 1984 · N4924X · Substantial damageNTSB DEN84LA282Accident · No injuriesLimited investigationFinal reportAerospatiale 316B Alouette III · Cokeville, WYThe plt stated that he lost tailrotor control while maneuvering for a landing. He elected to return to Cokeville airport and make the landing. The plt executed an aitorotation to the runway and during the landing flare, the tail skid struck the runway,…Sep 5, 1984 · N8266 · Substantial damageNTSB SEA84FA217Accident · 4 fatalField investigationFinal reportCessna 210K · Mccall, IDTwo acft departed in trail intending to follow a river through the mountainous terrain in their climb above the ridge line. The first acft proceeded as planned along the river and turned toward the dest at a safe alt. About 1/4 of a mile behind, the second…Sep 3, 1984 · N8136G · DestroyedNTSB CHI84FA376Accident · 3 fatalField investigationFinal reportPiper PA-18-150 · Oak Grove, WIThe plt stated to the host of the picnic that he would 'buzz the party a couple of times.' The two seat acft had three occupants aboard at the time of the accident. Witnesses stated that the acft passed over the picnic twice at a very low altitude. The acft…Sep 3, 1984 · N8042B · DestroyedNTSB ANC84LA153Accident · Serious injuriesLimited investigationFinal reportCessna 185 · Cutler River, AKWhile spotting caribou in a descent from 1500 ft MSL to 1300 ft MSL, the engine lost all power. The plt attempted to restart the engine while flying toward a lake for the forced landing. He stated that because of the low alt and airspeed he was unable to…Sep 3, 1984 · N4839C · Substantial damageNTSB ATL84LA276Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Leland, MSThe plt said he was attempting a roll at low alt shortly after takeoff and was unable to complete the maneuver before the acft collided with the ground.Sep 1, 1984 · N48428 · Substantial damageNTSB ANC84LA164Accident · No injuriesLimited investigationFinal reportCessna 180 · Cordova, AKAccording to the plt, he circled the landing area & then began a low pass (upwind leg) at 30 to 40 ft AGL when the acft started to settle. He applied full power, but the acft struck the ground in a level attitude & rolled to a stop in a boulder patch. During…Sep 1, 1984 · N3467Y · Substantial damageNTSB FTW84LA376Accident · Minor injuriesLimited investigationFinal reportHughes 269A · Apple Springs, TXAfter dispensing a load of gelled gasoline, to burn windrows of brush, the plt landed & refilled the chemical tank. Before taking off, he checked his fuel with a dip stick & decided there was enough remaining to dispense a 2nd load. While flying downwind &…Aug 30, 1984 · N48930 · Substantial damageNTSB DEN84FA274Accident · 1 fatalField investigationFinal reportBoeing Stearman E75 · Kalispell, MTThe pilot was completing a turn to final on a normal aerial application maneuver. He was aprx 15 ft AGL at 65 mph when the a/c struck a bird (presumed to be a red tailed hawk). The force of the impact broke the plexiglass canopy and temporarily distracted the…Aug 30, 1984 · N5183N · Substantial damageNTSB MKC84LA265Accident · No injuriesLimited investigationFinal reportHughes 269C · Witts Springs, ARWhile manuevering at an alt of 35 to 40 ft above tree the plt felt a shutter and low frequency shaking of the rotor disk. Rotor RPM and engine RPM decreased and the acft entered a shallow descent. The plt applied forward cyclic, reduced collective and…Aug 29, 1984 · N7487F · Substantial damageNTSB LAX84LA464Accident · No injuriesLimited investigationFinal reportBell 47G-5 · Watsonville, CAThe plt maneuvered during an aerial application flt to avoid high tension wires and collided with lower telephone lines. The plt said the winds were gusty at the time of the accident.Aug 29, 1984 · N4096G · Substantial damageNTSB DEN84LA271Accident · No injuriesLimited investigationFinal reportEnstrom 280C · Bluffdale, UTPlt was practicing hovering over a 40 x 60 foot helicopter pad. Plt stated, a gust of wind caught the helicopter moving it off the pad and into nearby power lines. The terrain around the pad slopes down. The power lines were located aprx 125 ft from the pad…Aug 29, 1984 · N4992M · Substantial damageNTSB LAX84LUJ01Accident · No injuriesFinal reportCessna 188B · Salome, AZThe acft collided with the terrain following a loss of power due to fuel exhaustion while spraying a cotton field. The plt stated he was aware of the low fuel supply but was pushing to complete the job before dark.Aug 27, 1984 · N731VZ · Substantial damageNTSB LAX84FA459Accident · 5 fatalField investigationFinal reportPiper PA-28-140 · Yucaipa, CAThe acft was observed with its' wing dipping as it flew low over a valley. The acft then touched down in a fld, collidedwith a boulder and a tractor trailer. Examination of the acft disclosed no evidence of a malfunction. The accident site is 6 miles east of…Aug 27, 1984 · N15699 · DestroyedNTSB MKC84FA263Accident · 2 fatalField investigationFinal reportRockwell S-2R · Palestine, ARAfter an aerial spray operation, the plt took a passenger aboard the single place acft for a 'ride around the field.' Witnesses said the pax sat to the rgt of the plt in the cockpit. After takeoff to the east, the plt returned for a low pass down the rwy in…Aug 26, 1984 · N4966X · DestroyedNTSB NYC84FNC09Accident · 1 fatalFinal reportCessna 172 · Pownal, MEPrior to the accident, witnesses observed the acft making several low passes & maneuvering. During the last maneuver, the acft entered a dive & collided with trees before the plt recovered. Trees were broken or damaged over an area of about 200 ft. no…Aug 25, 1984 · N5091A · DestroyedNTSB MKC84LA258Accident · No injuriesLimited investigationFinal reportPiper PA-36-400 · Hill City, KSThe plt cleared some power lines and descended to spray a sunflower field. The acft descended until it contacted the flowers with the landing gear. The tall flowers destroyed the leading edges of the acft wings and the landing gear. The drag slowed the acft…Aug 23, 1984 · N269JW · DestroyedNTSB FTW84LA365Accident · Serious injuriesLimited investigationFinal reportPiper PA-36-300 · Lorenzo, TXAfter completion of a swath run the acft turned right and then left before it descended to the ground in a left bank and nose down attitude. Plt stated that the acft would not recover from the left turn when full right stick travel was applied. The acft was…Aug 23, 1984 · N2397Y · Substantial damageNTSB CHI84LA358Accident · Serious injuriesLimited investigationFinal reportPiper PA-12 · Cottage Grove, WIWhile over-flying a local arpt at aprx 200 ft AGL the eng lost power. A forced landing was made in an adjacent alfalfa field. The acft landed hard in a nose low attitude and came to rest about 90 ft from initial ground contact.Aug 23, 1984 · N7890H · Substantial damageNTSB CHI84FA354Accident · 3 fatalField investigationFinal reportCessna 150A · Twin Lake, MIThe acft collided with the ground in a spiral like descent with the eng in a power retarded state as evidenced by the sound effects. The was no missing or backfiring of the power plant. The acft struck the ground vertically after being seen in a nose dwn…Aug 23, 1984 · N7250X · Substantial damageNTSB SEA84FA209Accident · 1 fatalField investigationFinal reportBenson B8M · Newman Lake, WAWitnesses observed the aircraft go through a series of rapid pitch oscillations at about 300 ft AGL. The pitch changes increased in magnitude and severity until the main rotor blades struck the rudder stopping it's rotation and resulting in an uncontrolled…Aug 22, 1984 · N45684 · DestroyedNTSB LAX84LA450Accident · No injuriesLimited investigationFinal reportBastian Pitts S1S · Tucson, AZThe plt stated after the accident that he was flying inverted when he experienced an engine failure. Several in flight restart attempts were unsuccessful and the pilot initiated a forced landing on a dirt road. While on final apch to the dirt road, a pick up…Aug 22, 1984 · N56AB · DestroyedNTSB FTW84LA363Accident · 1 fatalLimited investigationFinal reportAir Tractor AT301 · Plain Dealing, LAWitnesses reported that the acft made a descending low level turn at the end of a spray run, nosed over and dove into the soybean fld being sprayed. The plt was not wearing a shoulder harness or helmet when the accident occurred. Toxicology results revealed a…Aug 22, 1984 · N2356M · Substantial damageNTSB ATL84FA268Accident · 1 fatalField investigationFinal reportCessna A188B · Eastover, SCThe acft collided with the ground during a turn-around. The hopper dump valve on the acft was found closed after the accident. The fuel tanks were reportedly full (54 gallon capacity) and 120 gals of benlate, a non-toxic liquid herbicidehad been loaded aboard…Aug 22, 1984 · N9270R · DestroyedNTSB ATL84LA264Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Greenville, NCThe plt made a steep turn after completing a low pass and spraying a field. Plt stated that while in the turn the acft encountered wind gust that rolled the acft inverted. The acft stalled. The plt was able to roll out of inverted before ground collision.Aug 21, 1984 · N4851Y · Substantial damageNTSB SEA84FA204Accident · 2 fatalField investigationFinal reportVaughn MA-5 Charger · Buxton, ORWitnesses reported seeing the acft engaged in aerobatic flight described as 'like a spray plane conducting spray operations.' The acft collided with relatively level terrain during one of these maneuvers. No airframe or powerplant failures/malfunctions were…Aug 20, 1984 · N8037D · DestroyedNTSB NYC84LA280Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Caldwell, NJThe acft hit the surface of the water during a low pass which was described by a witness as 10-30 ft AGL & done in a series of passes with 'wings wobbling' until the pass that damaged the gear & wing causing the plt & acft to depart the area. Upon returning…Aug 20, 1984 · N4314L · Substantial damageNTSB FTW84FA354Accident · 2 fatalField investigationFinal reportCessna 180J · Lafitte, LAWitnesses observed the acft approach an oil production platform located in a marshy area near the destination airstrip. They reported that the acft made an abrupt, steep left turn at 200 to 300 ft AGL, followed by what they described as an accelerated stall.…Aug 20, 1984 · N9786G · DestroyedNTSB SEA84LA206Accident · No injuriesLimited investigationFinal reportDonald E. Bradshaw Starduster TOO · Whidbey Island, WAWitnesses stated the acft was engaged in aerobatics before it contacted the water and was destroyed.Aug 19, 1984 · CGIPZ · DestroyedNTSB LAX84LA446Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Coalinga, CAThe acft struck power lines about 50 ft AGL while on a x-country. The plt made a successful landing after the collision at an arpt about 30 miles away. The plt said the accident could have been prevented by not flying so low.Aug 18, 1984 · N86644 · Substantial damageNTSB LAX84LA440Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Watsonville, CAThe acft collided with a utility pole and was forced to land. The plt reported that on his last spray run in trying to do a better job than anyone else, he came to close to the pole. His rotor made contact with the pole. During the forced landing the landing…Aug 18, 1984 · N5353V · Substantial damageNTSB ATL84LA261Accident · No injuriesLimited investigationFinal reportCessna A188B · Kingstree, SCThe acft ran into high vegatation during a precautionary landing after the plt heard a vibration which began aprx 2 hrs after the initial takeoff. The vibration was caused by a loose wing fairing. Examination of the acft revealed that a screw stripped out of…Aug 18, 1984 · N9652J · Substantial damageNTSB ANC84FA141Accident · 4 fatalField investigationFinal reportCessna 172P · Fortress Creek, AKFlight was conducted to locate wild game. Acft collided with mountain at 4250 ft level. Acft impacted in a near verticalattitude. Examination of acft disclosed no evidence of malfunction.Aug 18, 1984 · N54173 · DestroyedNTSB MKC84FA256Accident · 2 fatalField investigationFinal reportCessna 170B · Oskaloosa, IASeveral witnesses viewed the acft circling over a bean field at an alt of 200 to 300 ft AGL. The plt and pax were reportedly looking for a radio-controlled airplane lost in the field. Witnesses continued to state an increase of power occurred and the acft…Aug 17, 1984 · N516PC · DestroyedNTSB MKC84FA254Accident · 1 fatalField investigationFinal reportCessna A188B · Algona, IAN9387G was flying at an altitude of aprx 75 feet AGL when it struck power lines while maneuvering to spray a corn field. The reported weather near the accident site was: visibility 7 miles, temperature 73 degrees, light precipitation in the way of rain was…Aug 17, 1984 · N9387G · DestroyedNTSB DEN84LA253Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Arthur, NDAcft flown at high gross weight in high density altitude conditions. The plt said takeoff pwr was added too late to stopthe descent at the start of a spray run.Aug 17, 1984 · N5332 · Substantial damageNTSB CHI84FA348Accident · 1 fatalField investigationFinal reportBell 206L-1 · Medford, MNPlt stated engine failed during cruise at an alt of 500 to 700 ft AGL. Autorotation was attempted. With collective full down rotor RPM continued to decrease while the plt maintained 60 to 70 KTS in a descent. Acft touched down with 40 to 50 KTS forward speed.…Aug 17, 1984 · N2109C · Substantial damageNTSB NYC84LA277Accident · Minor injuriesLimited investigationFinal reportGrumman G-164 · Fairmont, MDN527Y departed sallisburg, MD, on a flt to spray mesquitoes. The pilot had dispenced aprx half the load of chemicals when he experienced an engine failure. He executed an emergency landing in swampy terrain and the aircraft nosed over.Aug 16, 1984 · N527Y · Substantial damageNTSB MKC84LA255Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Marianna, ARThe landing gear contacted the bean crop which was being sprayed with sodium chlorate and the acft nosed over.Aug 16, 1984 · N6730K · Substantial damageNTSB MKC84LA251Accident · No injuriesLimited investigationFinal reportCessna A188A · Goodland, KSThe acft descended to the corn field for the 1st swath run after reloading. The acft did not level off properly but keptdescending until it was in contact with the crop. The additional drag caused the acft to stall into the ground. The plt said the acft had…Aug 15, 1984 · N4413Q · DestroyedNTSB SEA84LA199Accident · No injuriesLimited investigationFinal reportRockwell Thrush SR2 · Nampa, IDThe acft began to lose power while engaged in aerial application so the plt dumped his load and headed for the airstrip. Enroute the power deteriorated so the plt elected to land. Cutting the mixture gave the engine a surge which caused an overshoot into…Aug 14, 1984 · N5553X · Substantial damageNTSB MKC84LA250Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Swifton, ARDuring a swath run the #9 cylinder on the radial engine separated. A forced landing was made during which the acft landed in a levee and nosed over.Aug 14, 1984 · N7693 · Substantial damageNTSB DEN84LA258Accident · No injuriesLimited investigationFinal reportPiper PA-25-150 · New Rockford, NDPlt stated, 'on spray run. Got to close to sunflowers. When I started hitting them on the landing gear the plane slowed down and didn't have enough speed or power to get out so the plane landed in the sunflower field in about 50 yards.' Substantial damage…Aug 13, 1984 · N6431Z · Substantial damage