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 SEA84LA151Accident · Minor injuriesLimited investigationFinal reportBell 47G-3B-1 · Shelley, IDThe acft collided with the ground during an ag flt. The plt reported the winds were 3 to 5 KTS with no gusts when the accident occurred but that the winds are unpredictable at the base of the mountains and a gust of wind caught the acft. The plt also stated…Jul 2, 1984 · N501FH · Substantial damageNTSB LAX84LA379Accident · Minor injuriesLimited investigationFinal reportRockwell S-2R · Stanfield, AZThe plt was maneuvering to start another field when the acft's left wing hit the roof of the ground flagging vehicle. The acft then collided with the ground.Jul 2, 1984 · N8430V · DestroyedNTSB LAX84LA377Accident · No injuriesLimited investigationFinal reportCessna 177 · Lancaster, CAThe acft struck trees during a go-around from a simulated forced landing to a dirt road. The instructor plt stated that the acft would not climb as rapidly as it should, perhaps due to the density alt. The density alt was aprx 6000 ft.Jul 1, 1984 · N3161T · Substantial damageNTSB FTW84FA297Accident · 1 fatalField investigationFinal reportStephens AKRO-MASTER · Killeen, TXThe acft collided with the ground following a low alt aerobatic maneuver while participating in an airshow. Investigation revealed the acft entered a snap roll at about 800 ft AGL, made one complete revolution in about a 20-45 deg nose down attitude, entered…Jul 1, 1984 · N67HB · DestroyedNTSB ATL84FU006Accident · 1 fatalFinal reportRitz A · Tullahoma, TNThe ultralight had been flown for 4 ftls and the plt upon landing mentioned a possible control problem with the owner and builder. The builder then took the vehicle up to show how fast it would go. After about 30 minutes of flt he dove atthe rwy in a full…Jul 1, 1984 · UNREG · DestroyedNTSB MKC84LA192Accident · No injuriesLimited investigationFinal reportRotec Rally Sport · Wichita, KSPilot stated that after takeoff and climb to the downwind leg of the traffic pattern, he reduced engine pwr and reversed course. The pilot continued to state that the eng started losing pwr and subsequently failed. A forced landing was made in a newly…Jun 30, 1984 · N912RE · Substantial damageNTSB MIA84FA197Accident · Serious injuriesField investigationFinal reportConsolidated Aeronautics Lake LA-4-200 · Marathon, FLThe plt reported that he was flying low & in level flt over the ocean when the acft hit the wake from a large boat & flipped over. According to witnesses, the acft began a right turn while flying low, then the right wing hit the water & the acft cartwheeled &…Jun 30, 1984 · N1211L · DestroyedNTSB CHI84LA270Accident · No injuriesLimited investigationFinal reportHughes 500C/369HS · Arena, WIDuring an agricultural spraying operation the helicopter eng lost pwr. The plt attempted an autorotation. The acft rolled over on landing. The plt stated that he observed a loss of eng & rotor RPM, necessatating the autorotation. Inspection of the eng…Jun 30, 1984 · N377ST · Substantial damageNTSB ATL84LKG10Accident · Minor injuriesFinal reportAero Commander S2R · Americus, GAAccording to the plt, he had maneuvered to finish spraying a field & was descending on a trim run when the eng coughed/hesitated. He stated that he became distracted by the problem & before he realized it, the acft was converging on trees. He turned the acft…Jun 30, 1984 · N9059N · DestroyedNTSB MKC84LA190Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Atwood, KSDuring a swath run, the eng began losing power. The plt pulled up & looked for a place to land, then dumped his chemical load. Eng RPM continued decreasing so he elected to land in a field that was being summer fallowed. During the landing, the acft nosed…Jun 29, 1984 · N6797Z · Substantial damageNTSB LAX84FA371Accident · 2 fatalField investigationFinal reportHughes 269B · Palos Verde Est, CAGnd witnesses obsvd helicopter into normal turn at 500 ft AGL followed by a violent rt turn. During the violent turn the tail rotor assy separated & the main rotor blades coned upwards. The helicopter went into a near vertical descent & crashed. Wreckage exam…Jun 28, 1984 · N9400F · DestroyedNTSB DEN84LA279Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Stanley, NDThe plt reported that he was spraying a field with 2 power lines at the north edge. He had been making passes under the wires, but where 2 poles were too close together, he decided to fly over the wires. After making a procedure turn back toward the field, he…Jun 28, 1984 · N3574Z · Substantial damageNTSB CHI84LA266Accident · No injuriesLimited investigationFinal reportPiper PA-36-300 · Lake Benton, MNWhile on an aerial application flt, the plt was crossing under a power line when a wire caught the rudder & separated itfrom the acft. During a landing, the left wing contacted the ground 1st.Jun 28, 1984 · N3681E · DestroyedNTSB FTW84FA288Accident · 1 fatalField investigationFinal reportPiper PA-22-150 · Quinlan, TXSeveral witnesses stated the acft 'buzzed them below tree-top level' before the accident. Witnesses also stated that the engine 'sounded like it cut out.' The acft impacted the ground in a steep left bank. Post accident inspection revealed no evidence of any…Jun 26, 1984 · N7350D · DestroyedNTSB CHI84LA263Accident · Minor injuriesLimited investigationFinal reportHiller UH 12 D · Deerfield, WIPlt was aware of pwr lines which crossed the field over which he was performing a calibration test. Plt stated that because of sun glare visual contact with the wires was lost. The acft contacted the wires.Jun 26, 1984 · N62362 · Substantial damageNTSB SEA84LA140Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Wenatchee, WAThe plt made a low pass over a herd of elk in hilly terrain. He reported that after encountering a downdraft, he decided he could not climb out of the valley & landed with full flaps. The density alt was aprx 5400 ft.Jun 25, 1984 · N51785 · Substantial damageNTSB DEN84FA194Accident · Minor injuriesField investigationFinal reportPiper PA-28-140 · Cedar City, UTThe acft collided with rising terrain in a box canyon. The plt said he found himself trapped with the terrain coming up 'to meet the plane' and decided to try and land on a nearby road. The acft stalled into trees prior to reaching the road. The plt also said…Jun 25, 1984 · N98220 · DestroyedNTSB ANC84LA100Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Flathorn Lake, AKAccording to the passengers,the plt was flying at aprx 250 ft when they saw a bear. After starting a left turn, the nose of the acft dropped. One passenger said the plt made a tight turn before the plane lost its lift. The other passenger stated that the acft…Jun 25, 1984 · N4164Z · DestroyedNTSB MKC84LA181Accident · Minor injuriesLimited investigationFinal reportGrumman G-164B · Campbell, MOPIC was making a clean up swath run after spraying a field and failed to avoid a high voltage power line. After strikingthe line the acft impacted the ground, caught fire and burned.Jun 23, 1984 · N6600K · DestroyedNTSB DEN84LA192Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Murdo, SDThe pilot reported the engine failed while he was in a procedure turn. The pilot made a forced landing in an open field and the acft nosed over. Examination of the engine after the accident revealed the engine 'swallowed an exhaust valve' that caused the…Jun 23, 1984 · N8974H · Substantial damageNTSB CHI84LA254Accident · No injuriesLimited investigationFinal reportEagle DW-1 · Oklee, MNThe plt reported that he had completed spraying 60 acres of land & was beginning a pass in another field. Half way through the spray pass the eng quit. He pulled up to clear a tree & the acft stalled into a field of sunflowers. No mechanical failure or…Jun 22, 1984 · N8810Y · Substantial damageNTSB NYC84LA226Accident · No injuriesLimited investigationFinal reportBell 47J · Cranbury, NJThe helicopter had made 4 successful spray passes during this series of runs after reloading. During the turn to start the fifth pass the acft started to settle and contacted the ground before recovery could be made.Jun 20, 1984 · N9398H · Substantial damageNTSB SEA84LA137Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Spokane, WAThe eng lost power during an aerial application flt, then as the plt was making a forced landing, the acft struck telephone wires. After hitting the wires, the acft struck the ground & cartwheeled. An exam revealed that a failure of the cam ring system had…Jun 19, 1984 · N48681 · DestroyedNTSB NYC84FA214Accident · 3 fatalField investigationFinal reportAerospatiale AS-350D · Island Beach, NJThe on-demand air taxi flt departed for garden city with one pax. The reported weather at the aprx time of the accident indicated low clouds, thunderstorm activity including rain and lighting. One witness stated that he observed the helicopter flying at an…Jun 19, 1984 · N5784M · DestroyedNTSB MKC84LA176Accident · Minor injuriesLimited investigationFinal reportPiper PA-36-375 · Storm Lake, IAWhile on the 2nd swath run, the plt maneuvered the acft to cross under power lines bordering the edge of the corn field. He said he misjudged the distance to clear the power lines. The vertical stabilizer & rudder struck the lines & were torn from the acft.…Jun 19, 1984 · N3953E · Substantial damageNTSB MKC84FA179Accident · 1 fatalField investigationFinal reportCessna 150H · Golden, MOThe acft was flying low over trees when it banked steeply and spun to the ground according to a witness. The acft impacted the ground in an almost vertical nose down descent. The plt was a student who was on a local solo flt. No mechanical or physical…Jun 19, 1984 · N23233 · DestroyedNTSB FTW84LA280Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Blue Ridge, TXPlt had power at idle during descent from 900 ft AGL to 200 ft AGL. During a low pass over a field, plt advanced throttle, engine sputtered and did not accelerate. Heavy braking was used during forced landing roll and acft nosed over. Plt did not recall using…Jun 19, 1984 · N82213 · Substantial damageNTSB DEN84LA186Accident · 1 fatalLimited investigationFinal reportCessna 188 · Groton, SDDuring aerial application flight, the aircraft passed beneath two power lines. The top of the vertical fin and collision avoidance beacon light apparently made contact with the first wire, as they were found separated near that location. After contact, the…Jun 18, 1984 · N9261R · DestroyedNTSB NYC84LA212Accident · No injuriesLimited investigationFinal reportHiller 12E · Meadville, PAThe acft flew into wires during a crop spraying mission. The acft was flying at about 5-10 ft when a flash was seen overhead. The acft vibrated and slowed before impacting the ground and rolling over.Jun 17, 1984 · N4033P · Substantial damageNTSB MKC84LA180Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Pocahontas, ARAbout 18 inches of one propeller blade separated in flight. The acft began to shake violently and the plt shutdown the engine. The aircraft crashed during the forced lndg. Metallurgical examination revealed features typical of fatique cracking over aprox 2/3…Jun 16, 1984 · N4913X · Substantial damageNTSB FTW84LA274Accident · No injuriesLimited investigationFinal reportAir Tractor AT301 · San Benito, TXAt the beginning of the initial swath run the acft collided with power lines. The power lines remained attached to the acft throughout the uncontrolled descent into a cotton field.Jun 16, 1984 · N8594S · Substantial damageNTSB CHI84LA238Accident · No injuriesLimited investigationFinal reportPiper PA-36-300 · Leroy, WIThe acft collided with trees while turning during an aerial application mission. The plt said that the acft started losing altitude in the turn and despite application of full power it continued to settle until trees were hit. The plt reported that during…Jun 15, 1984 · N59662 · DestroyedNTSB SEA84LA133Accident · Minor injuriesLimited investigationFinal reportGrumman G-164B-450 · Pullman, WAAfter making a swath run, the acft entered a steep turn with an airspeed of about 75 mph. According to two witnesses, the eng lost power & then the acft crashed. The plt was unable to remember what had happened from the time he entered the turn until he…Jun 14, 1984 · N6798Q · DestroyedNTSB SEA84LA132Accident · No injuriesLimited investigationFinal reportBell 47G2A · Buena, WAMain rotor blades contacted a wind machine during an aerial application flt. Helicopter settled into trees and rolled over. Plt said he knew the machine was there but had forgotten.Jun 14, 1984 · N11VH · Substantial damageNTSB CHI84LA237Accident · No injuriesLimited investigationFinal reportHughes 269C · Boyd, MNWhile beginning a gradual pull-up at the end of a spray run, the plt was distracted by a person in a ditch & did not see the wire at the end of the field. The wire contacted the tail rotor & the helicopter began to spin. The plt reduced power & was able to…Jun 14, 1984 · N9668F · Substantial damageNTSB FTW84LA277Accident · No injuriesLimited investigationFinal reportHughes 269C · Kerrville, TXPlt descended to a low hover into wind. Pedal turn was made at alt of 5 ft AGL into wind. Control was lost in the downwind hover. Acft contacted ground and rolled over. No mechanical malfunctions were reported.Jun 13, 1984 · N58272 · Substantial damageNTSB FTW84FA272Accident · 1 fatalField investigationFinal reportChampion 7GCAA · Lone Wolf, OKWitnesses reported that the plt made a low pass by each of his 2 sons who were operating combines in a wheat field. After making the low passes, he pulled up in a steep climb. The acft then entered a steep descent & crashed. An exam of the wreckage revealed…Jun 13, 1984 · N1835G · DestroyedNTSB DEN84LA179Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Kindred, NDThe engine quit on the first swath run after a carburetor change. Substantial damage resulted from the forced landing. Subsequent examination of the carburetor revealed fouling by sealant material partially dissolved by fuel.Jun 13, 1984 · N10247 · Substantial damageNTSB CHI84LA232Accident · Minor injuriesLimited investigationFinal reportBell 47G · Fairfax, MNThe helicopter plt turned at the end of a spray run & the acft collided with a power line. He said that because of a quartering tailwind, the helicopter was in a nose high attitude & the tail rotor hit a wire. The plt was able to make an autorotation after…Jun 13, 1984 · N501H · Substantial damageNTSB ATL84LA199Accident · 1 fatalLimited investigationFinal reportCessna A188B · Hollandale, MSTwo acft were spraying same field. A farm hand was used as flagger to mark last crop row sprayed. Flagger used for last two seasons and briefed previously on flagging operations by the pilot/farm owner. Flagger was not briefed where to begin counting crop…Jun 13, 1984 · N731XJ · No damageNTSB SEA84LA130Accident · No injuriesLimited investigationFinal reportAyres S2R-1820 · Pasco, WAThe plt was applying herbicides to a corn field when a power loss to idle RPM occurred. During an emergency landing, the main gear sunk into soft sand & the acft nosed over. An exam revealed that the throttle bracket, p/n 19703-5001, had failed.Jun 12, 1984 · N4025K · Substantial damageNTSB ATL84LA198Accident · No injuriesLimited investigationFinal reportBell 222 · Salem, VAThe helicopter was flown to the site of an auto accident to transport an injured person. After landing, the patient was loaded without shutting down the eng. Due to the position of power lines, the aircrew had to depart in the opposite direction. While…Jun 12, 1984 · N222LH · Substantial damageNTSB MKC84LA165Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Harrisburg, ARThe acft's landing gear collided with a levee during a swath run. The acft then slowed & hit other levees. The plt dumped his load, but the plane crash landed & nosed over.Jun 11, 1984 · N8491K · Substantial damageNTSB MKC84LA166Accident · No injuriesLimited investigationFinal reportAero Commander S-2R · Pocahontas, ARThe plt said he was making a cleanup swath & encountered spray from the previous swath run. The spray contains a dye which covered the windshield & obscured the plt's vision. The plt said he pulled up at the end of the field but failed to clear the trees.…Jun 10, 1984 · N8896Q · Substantial damageNTSB MKC84FA164Accident · Serious injuriesField investigationFinal reportPiper PA-25-235 · Satanta, KSAfter making a swath run, the plt initiated a turn-around in a downwind direction. During the turn, a wing dropped & the acft entered a descent & struck the ground, nose 1st. It then bounced & traveled another 53 ft before stopping & bursting into flames. The…Jun 10, 1984 · N4452Y · DestroyedNTSB DEN84LA175Accident · No injuriesLimited investigationFinal reportAerospatiale SA-315B · Salina, UTThe acft was on a maintenance check flt after the main rotor shaft assembly thrust bearing had been replaced after the acft had yawing problems and popping sounds at high pitch settings while liftings loads. The plt tried to duplicate the conditions for the…Jun 10, 1984 · N29907 · Substantial damageNTSB ANC84LA088Accident · No injuriesLimited investigationFinal reportMaule M-5 · Palmer, AKThe pilot attempted his first water take-off of the season with the aircraft loaded over gross with an aft CG. Unable to attain sufficient airspeed to clear tall trees bordering the waterway, he attempted to turn around and land in the opposite direction. The…Jun 10, 1984 · N347X · Substantial damageNTSB NYC84LA209Accident · No injuriesLimited investigationFinal reportCessna 172 · Mantan, NJPlt stated, while maneuvering at 650 ft the engine quit. During the forced landing apch, the acft contacted powerlines. The acft contacted the ground in a nose down attitude and nosed over.Jun 9, 1984 · N3633L · Substantial damageNTSB MIA84FA181Accident · 1 fatalField investigationFinal reportSchweizer SGS 1-26E · Williston, FLThe acft was observed to enter a left base leg for rwy 4. The plt continued to fly the base leg heading & flew thru the final apch leg. The acft then entered a right bank, & after 180 deg of turn, it stalled & went into a right spin at an estimated 600 to 800…Jun 9, 1984 · N33916 · Substantial damageNTSB DEN84FA172Accident · 2 fatalField investigationFinal reportCessna 182K · Cascade, COThe purpose of the flt was to qualify one of the plts to fly search missions over mountainous terrain. Such flts included maneuvering at low alt, but not below 500 ft AGL. During the flt, the acft crashed on the nortwest side of pikes peak at an elevation of…Jun 9, 1984 · N2676Q · Destroyed