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 FTW82FQA26Accident · Serious injuriesFinal reportCessna 150 · La Plata, NMAcft struck a power line which crossed a road at about 40 ft AGL. The acft was observed flying at low altitude in the area prior to the accident.Aug 27, 1982 · N3251V · DestroyedNTSB FTW82DA351Accident · No injuriesFinal reportAir Tractor AT-400 · Alvin, TXThe pilot had finished spraying a field and was surveying another field for his next day operation when the aircraft engine flamed out. He landed the aircraft in a soybean field and ground-looped the aircraft to prevent hitting trees at the edge of the field.…Aug 27, 1982 · N3657J · Substantial damageNTSB DEN82FTG06Accident · 2 fatalFinal reportPiper PA-12 · Oakes, NDSeveral witnesses reported that the purpose of the flight was blackbird control of a sunflower field. There was speculation by local residents that the aircraft was being used to spread poisoned corn. This was substantiated when corn and a portion of an…Aug 27, 1982 · N7715H · DestroyedNTSB ATL82DA252Accident · No injuriesFinal reportGrumman G-164C · Gunnison, MSThe pilot reported that he smelled something hot while spraying. He checked the instruments and noted that the oil temperature gauge was indicating off the high side of the scale. He started to make a precautionary landing but the engine seized during final…Aug 27, 1982 · N6787K · Substantial damageNTSB MKC82DA158Accident · No injuriesFinal reportFairchild Hiller FH 1100 · Mason City, IADuring a swath run, the engine RPM dropped to flight idle and the helicopter was landed hard in a clear area beside the field. An investigation revealed that a sensing line for the fuel control system had failed. This prevented the engine from operating above…Aug 26, 1982 · N1345Q · Substantial damageNTSB FTW82DA350Accident · No injuriesFinal reportAir Tractor AT-301 · Winnesboro, LAThe pilot was circling the field during alignment for his initial swath run when the aircraft engine failed. During the forced landing the aircraft nosed over and the pilot exited the aircraft without turning off any switches. He stated that fuel was leaking…Aug 26, 1982 · N4342S · DestroyedNTSB FTW82FRG37Accident · 2 fatalFinal reportChampion 7GCAA · Killeen, TXThe majority of the wreckage was contained within a small area except for the left wing tip which was found about 125 yds from the wreckage & some pieces of fabric from the left wing that were found about 525 yds from the wreckage. Both wings had separated…Aug 25, 1982 · N2541F · DestroyedNTSB NYC82FA208Accident · 2 fatalField investigationFinal reportErco 415C · Carthage, METhe aircraft was observed flying at low altitude during which the engine sounds ceased. The aircraft stalled and descended vertically to the ground.Aug 24, 1982 · N3728H · DestroyedNTSB FTW82FRJ16Accident · 2 fatalFinal reportRockwell S-2R · Jones, LAAir tractor AT-400, N2342Z, and another aircraft, a Rockwell international S-2R, N8474V, collided while both aircraft were involved in spraying operatons. The AT-400 pilot was spraying a field that was surrounded by trees. He had just completed a swath run to…Aug 23, 1982 · N8474V · 2 aircraft · DestroyedNTSB ATL82FA243Accident · 1 fatalField investigationFinal reportAeronca 7AC · Greenwood, MSPilot was flying to spot deer. When deer were spotted pilot banked steeply to get better look, stalled and only had time to level wings before ground impact.Aug 23, 1982 · N67JH · DestroyedNTSB MKC82DA152Accident · Minor injuriesFinal reportCessna 172 · Thedford, NEThe pilot reported that after he took off on a dark night, he remembered there were obstacles in that area and he reversed his direction of turn. He stated that after reversing the turn, he became disoriented and the aircraft dove into the ground.Aug 22, 1982 · N3419E · Substantial damageNTSB MIA82FKT11Accident · Serious injuriesFinal reportCessna 152 · Lantana, FLWitnesses observed the acft flying 35-40 ft over the ocean making banks, climbs & dives. Just prior to crashing the acft was seen to be in a very steep climb.Aug 21, 1982 · N68738 · DestroyedNTSB LAX82DA316Accident · No injuriesFinal reportMidget Mustang · Ventura, CAWhile flying in the vicinity of a beach area, the engine lost power. The pilot landed on a dirt parking area near the beach, but did not have room to stop. In order to avoid surfers and their parked vehicles, he intentionally ran the aircraft across an area…Aug 21, 1982 · N50RT · DestroyedNTSB CHI82DA318Accident · 2 fatalFinal reportMustang II · Plainfield Twp, ILAircraft came down vertically rolling. Just before ground contact or at about 200 feet rolling slowed and aircraft continued descent to terrain contact. No malfunction noted.Aug 21, 1982 · N68099 · DestroyedNTSB LAX82DA306Accident · No injuriesFinal reportHiller UH-12E · Chandler, AZThe pilot was spraying liquid chemicals at night. The pilot flew into his own wake turbulence and lost control and collided with the ground. Control was regained to make an upright landing in the field. Skids were torn off the aircraft.Aug 20, 1982 · N4026S · Substantial damageNTSB ATL82FLG13Accident · 1 fatalFinal reportSmith Miniplane · Swansea, SCThe pilot was on a pleasure flight to practice aerobatic maneuvers. He held a current certificate of waiver which authorized him to practice low level aerobatics below 1500 ft above the surface. Four known witnesses observed the aircraft pull up from a low…Aug 19, 1982 · N1CJ · DestroyedNTSB ANC82DAG42Accident · Serious injuriesFinal reportCessna 185 · Near Tyonek, AKThe float equipped plane was being used to transport cargo. A passenger was put on the flight at the last minute, but the pilot believed the aircraft was within its maximum weight limit. After takeoff, the pilot remained at a low altitude for a time while the…Aug 19, 1982 · N3489Y · Substantial damageNTSB CHI82FA312Accident · 2 fatalField investigationFinal reportTaylorcraft BL-65 · Rock Falls, ILAircraft caught fire while performing aerobatics and crashed out of control. Gas tank cap had come off and during inverted flight fuel spilled out and ignited.Aug 18, 1982 · N29660 · DestroyedNTSB NYC82FA203Accident · 2 fatalField investigationFinal reportChampion 7ECA · Lewes, DEAbout 15 min after takeoff, the aircraft was observed to enter a maneuver from low altitude over a beach area. During the maneuver, the plane pulled up, entered a steep climb and then banked or rolled left and entered a nose down attitude. Before recovering,…Aug 17, 1982 · N1886G · DestroyedNTSB MKC82DA148Accident · No injuriesFinal reportCessna T188C · Near Traer, IAThe pilot failed to refuel during the last loading, and shortly after returning to the spray area, the engine quit. A forced landing was made in an alfala field during which the aircraft collided with a fence. During the investigation, no fuel was found in…Aug 17, 1982 · N9975J · Substantial damageNTSB FTW82DA336Accident · No injuriesFinal reportSnow AT-301A · Leachville, ARThe pilot stated that while he was in the procedure turnaround for the third swath run. He lost elevator control. The aircraft impacted the ground and cartwheeled. Investigation revealed that the bolt connecting the elevator horn assembly and the elevator…Aug 17, 1982 · N2321V · DestroyedNTSB DEN82FTK06Accident · 1 fatalFinal reportPiper PA-18 · Watertown, SDThe pilot was spraying a sunflower field next to an alfalfa field that was being irrigated. As he pulled up from his third swath run, he began a procedure turn-around over the alfalfa field. During the turn, the plane rolled to an inverted attitude, then…Aug 17, 1982 · N154T · DestroyedNTSB ATL82FLJ08Accident · Serious injuriesFinal reportPiper PA-25-260 · Scotland Neck, NCDuring the fourth swath run the acft struck a 60-foot tree approximately 5 ft from the top.Aug 17, 1982 · N9780P · Substantial damageNTSB ANC82DAG45Accident · No injuriesFinal reportPiper PA-38-112 · Eagle River, AKDuring a local flight, the pilot elected to fly into the mouth of peter's creek valley to look at a friend's cabin. He stated that after he flew over the cabin at about 1500 ft MSL, he "initiated power and a 180 deg turn." He stated that on application of…Aug 17, 1982 · N2409P · Substantial damageNTSB NYC82DA200Accident · Minor injuriesFinal reportBellanca 7GCAA · Coltsneck, NJThe pilot missed a banner pick-up, pulled up abruptly and leveled off at about 350 feet. The aircraft engine lost power and the pilot lowered the nose while in a right turn in an attempt to return to the airport. He stated that engine power was restored while…Aug 15, 1982 · N87108 · DestroyedNTSB ATL82FKQ17Accident · 1 fatalFinal reportEaa Biplane · Meridan, MSAccording to three witnesses the plt was performing aerobatic maneuvers at tree-top level & the acft stalled during a pull-up & turn-around. The plt's blood alcohol level was 128 mg% & the gastric level was 287 mg%.Aug 14, 1982 · N1101M · DestroyedNTSB ATL82DA238Accident · No injuriesFinal reportCessna 152 · Stone Mountain, GAThe pilot reported that a split-s maneuver was performed at a low altitude and the aircraft struck the branches of a pine tree. The aircraft continued to fly and the pilot returned to the airport. There was damage to the right wing and the fuselage.Aug 14, 1982 · N4737B · Substantial damageNTSB ANC82DA072Accident · Serious injuriesFinal reportPiper PA-22 · Icy Bay, AKWhile on a cross country flight, the pilot landed on a small lake to add fuel to the aircraft from cans carried in the aircraft. After departing the lake he encountered weather and attempted to transition to instrument flight when a hole he was using to climb…Aug 14, 1982 · N6954B · DestroyedNTSB FTW82DA330Accident · No injuriesFinal reportGrumman G-164A · Dimmitt, TXThe pilot reported that during a procedure turn around, the engine lost power. He elected to land in a cotton field. After touchdown, the wheels dug in the ground and the aircraft nosed over.Aug 13, 1982 · N8826H · Substantial damageNTSB DEN82DA161Accident · Minor injuriesFinal reportAir Tractor AT-301 · Center, COThe pilot was on the first swath run of his second load. He stated that as he started to cross below transmission lines, when he saw a small boy and a dog appear from a ditch below the wires. He stated that when he pulled up to avoid the child, the aircraft…Aug 12, 1982 · N1KL · Substantial damageNTSB MIA82DA167Accident · Minor injuriesFinal reportBell 206B · Miami, FLThis was an instructional flight for recurrent training and involved an external load operation with a 10 ft line. While preparing to pick up an 800 lb load, the helicopter was maneuvered over the object with slack in the line. The instructor observed that…Aug 11, 1982 · N7891S · DestroyedNTSB FTW82DA324Accident · No injuriesFinal reportPiper PA-25-260C · Des Arc, ARAfter pulling up from a swath run, the aircraft began to settle, then collided with the ground. This occurred after the pilot had dispensed all or nearly all of his load.Aug 11, 1982 · N4952Y · Substantial damageNTSB CHI82DA303Accident · No injuriesFinal reportEnstrom F-28 · Waynesville, OHThe pilot stated that during a spraying operation he felt a vibration in the aircraft. He attempted a precautionary landing with reduced power, avoiding further stress on the rotor system. During the landing the skids dug into the soybeans and the main rotor…Aug 11, 1982 · N81HF · Substantial damageNTSB CHI82DA301Accident · No injuriesFinal reportHiller 12E · Palisade, MNAircraft lost power, pilot autorotated at 20 feet AGL. Made hard forced landing and aircraft rolled over. Piston rod failed because cap bolt was undertorqued.Aug 10, 1982 · N5594N · Substantial damageNTSB FTW82DA322Accident · No injuriesFinal reportCessna T188C · Altheimer, ARThe pilot stated he encountered turbulence while flying under a power line during a crop spraying operation. The left wing pitched-up and struck the power line and the aircraft went into an uncontrolable left bank. He reduced power and landed in a bean field,…Aug 9, 1982 · N2881J · DestroyedNTSB MKC82IA138Incident · Minor injuriesIncident investigationFinal reportPiper PA-25-235 · Wilsonville, NEThe pilot stated that he was overcome by exposure to the organic phosphate he was deploying. According to local law enforcement authorities, the aircraft crashed in a field and came to rest inverted. Medical tests for toxic chemical exposure were inconclusive.Aug 8, 1982 · N7043Z · Minor damageNTSB MKC82DA140Accident · No injuriesFinal reportCessna 188 · Stockton, KSThe engine lost power as the pilot pulled up from a swath run. A forced landing was made in open terraced field. Dirt was found in the engine fuel pump. Reportedly, the dirt would have restricted the fuel flow.Aug 8, 1982 · N53227 · Substantial damageNTSB FTW82DA319Accident · No injuriesFinal reportEagle DW-1 · Cheneyville, LAThe acft was on the approach to spray a cottonfield when a collision with an unseen power line occurred. The collision forced the acft down and the pilot made a hard landing which damaged the landing gear and the right wing. The visibilitywas about 5 miles in…Aug 8, 1982 · N8807Z · Substantial damageNTSB DEN82FTE22Accident · 1 fatalFinal reportEiriavion PIK-20D · Crested Butte, COThe pilot was attending an "aviation weekend" sponsored by the town of Crested Butte, CO. He had flown in this area often and was acquainted with the terrain and weather. After being towed to an area near the northwest corner of mt Crested Butte, a normal…Aug 8, 1982 · N199A · DestroyedNTSB FTW82FQA24Accident · Serious injuriesFinal reportPiper PA-22 · Lake Arthur, NMThe pilot and one passenger were on a flight to pick up spare parts. The passenger recalled that while en route, the pilot remarked, "oh, I can't resist" and started to descend, then made a pass at about 50 ft over a field hand. The field hand, a mexican…Aug 6, 1982 · N1489A · Substantial damageNTSB FTW82DA316Accident · Minor injuriesFinal reportCessna 152 · Rockwall, TXThe pilot stated that he encountered wind shear, dust devil or other instantaneous failure, while flying at about 100 ft AGL. He stated the aircraft dropped, fell out of control, impacted and tumbled to a stop. Reportedly, a witness observed the aircraft…Aug 5, 1982 · N67570 · DestroyedNTSB DEN82DA155Accident · No injuriesFinal reportBell Helicopter Textron 47G3B1 · Buena Vista, COAccording to the pilot, the purpose of the flight was to track wild sheep with transmitters attached to their necks. While maneuvering at approximately 14,000 feet elevation and executing a right turn the aircraft felt "rubbery." He applied left cyclic but…Aug 4, 1982 · N23DW · DestroyedNTSB ANC82DA070Accident · Serious injuriesFinal reportCessna 150H · Near Anchorage, AKWhile taking off from a lake, the instructor reduced the power to simulate a forced landing at about 200 ft AGL. He reported that the student elected to make a 180 deg turn to land. He stated that during the turn, the student brought the nose up and the…Aug 4, 1982 · N22695 · Substantial damageNTSB MIA82FKJ05Accident · 1 fatalFinal reportPiper PA-25 · Jay, FLThe acft stalled during a spraying operation. The plt received his private pilot's certificate approximately four months prior to the accident. He had no flt time logged in a PA-25 & no information could be found to indicate the plt had received any…Aug 2, 1982 · N8921L · DestroyedNTSB ATL82DA226Accident · No injuriesFinal reportHughes 269A · Wetumpka, ALThe pilot reported that at the end of a spray run, the engine lost power. He stated that the engine RPM dropped to zero, the airspeed was zero, and he established an autorotation. According to the pilot, the helicopter touched down on rough hilly terrain,…Aug 2, 1982 · N8801F · Substantial damageNTSB LAX82FVM17Accident · 1 fatalFinal reportGreat Lakes 2T-1A-2 · Scotts Valley, CAWhile performing in an aerobatic show, the pilot entered a spin. According to a witness, he entered the spin at about 2000 ft AGL and made approximately 5 turns before starting a recovery at about 500 ft AGL. He stopped the spin, but there was insufficient…Aug 1, 1982 · N61861 · DestroyedNTSB LAX82DA283Accident · No injuriesFinal reportEnstrom F28C · Phoenix, AZThe helicopter made a forced landing in a cotton field after tail rotor driveshaft failure. Examination showed a ductileshear overload failure. No evidence of fatigue was reported.Jul 31, 1982 · N5688N · Substantial damageNTSB DEN82IA150Incident · No injuriesIncident investigationFinal reportAerospatiale 350D · Near Winter Par, COWitnesses who were aboard the aircraft stated that the aircrafts rotor struck a tree during a "straffing run" on a railroad trestle just below the Continental divide. The pilot stated that the engine flamed out as he passed over the trestle. The aircraft was…Jul 31, 1982 · N49556 · Minor damageNTSB NYC82FA175Accident · 1 fatalField investigationFinal reportBeech B19 · South Yarmouth, MAThe acft stalled & impacted trees as the plt was buzzing a residence at 150-200 ft above the tree tops.Jul 30, 1982 · N783Y · DestroyedNTSB ATL82DA219Accident · No injuriesFinal reportCessna 188 · Bishopville, SCThe pilot reported that as he was entering a field on his third swath, the aircraft collided with a single transmission line. The line was leading to the center of a cotton field. The pilot did not see the line. After contacting the line, the aircraft was…Jul 30, 1982 · N9888V · Substantial damage