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 MIA84LA205Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Bonifay, FLWhile turning after a swath run the control stick came loose and the acft impacted the ground. Inspection revealed the bolt used to secure the control stick failed due to corrosion.Jul 20, 1984 · N9860P · DestroyedNTSB FTW84LA314Accident · No injuriesLimited investigationFinal reportAerospatiale AS-355F · El Paso, TXThe helicopter encountered turbulence and downdrafts during landing. The acft impacted the asphalt ramp slightly nose low and bounced 2-3 ft into the air. The nose dipped more and full aft cyclic was applied. The main rotor blades hit the ground and the acft…Jul 20, 1984 · N240US · Substantial damageNTSB ATL84FA225Accident · 1 fatalField investigationFinal reportde Havilland DHC-1B · Greenwood, MSWitnesses observed the acft become airborne and accelerate low over the rwy. At the end of the private strip the acft entered a 30 to 40 deg nose high attitude climbing to aprx 1,000 ft. the acft then rolled right as the nose dropped and continued to roll…Jul 20, 1984 · N27JD · DestroyedNTSB MKC84LA223Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Pollard, ARThe plt stated that he was spot spraying a bean field and was aware of the location of the electrical transmission line. As he attempted to maneuver the acft under the line, a wing made contact with the line and the acft inpacted the ground.Jul 19, 1984 · N8815L · DestroyedNTSB MKC84LA222Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Stanford, ARWhen the pilot made his first swath run he flew over a set of wires, on the return run he went under the wires. The pilot said he hit his own prop wash and rolled enough for the wing tip to contact the wire.Jul 19, 1984 · N8914H · Substantial damageNTSB MKC84FCD01Accident · Serious injuriesFinal reportCessna A188B · Hesper, IAThe acft crashed after colliding with a power line. During the first spray pass the plt attempted to fly under the power line. The veritcal fin hit the wire and the acft crashed. There were no mechanical problems with the acft during this aerial application…Jul 18, 1984 · N84494 · DestroyedNTSB MKC84LA211Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Roe, ARAs a result of a supercharger failure, a partial power loss was experienced during a swath run. During the landing roll after a forced landing, the acft nosed over & came to rest inverted. An eng teardown revealed that both supercharger bearings had failed…Jul 17, 1984 · N8365K · Substantial damageNTSB LAX84LA399Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · Folsom, CAThe acft was observed flying down a river at a low altitude toward the main body of a lake. The acft impacted a 12 kv power line. The plt stated that he did not see the wires until an instant before impact.Jul 17, 1984 · N5752P · Substantial damageNTSB SEA84LA174Accident · Minor injuriesLimited investigationFinal reportHiller UH-12E · Redmond, ORThe acft collided with the ground after a in-flt main rotor blade separation during an aerial application flt. Inspection of the fracture surface of the failed blade revealed characteristics consistant with the high stress, low cycle fatigue. Lab findings…Jul 16, 1984 · N1043L · Substantial damageNTSB MKC84LA219Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Chadron, NEPlt stated that while manuvering to avoid transmission wires on a small incline, his rolling pull-up was excessive, causing airspeed decay and a stall/mush. The empennage failed to clear the power lines during the mush. Acft then collided with terrain.Jul 16, 1984 · N6765Z · Substantial damageNTSB MKC84FA218Accident · 1 fatalField investigationFinal reportEagle DW1 · Kimball, NEThe acft collided with a microwave tower 158 ft AGL while the plt was making a smoke trail to test the wind. As the plt was seen to look back along his smoke path, the acft collided with the tower. The cables supporting the twr & the twr destroyed the acft…Jul 16, 1984 · N8815S · DestroyedNTSB LAX84FA396Accident · 1 fatalField investigationFinal reportTravel Air 4000 · San Miguel, CAGround witnesses reported that this & another acft were engaged in a mock 'dogfight'; both acft were circling the accident area between 500-800 ft AGL & neither acft was negotiating any aerobatic maneuvers. The plt stated that during a descending 30 deg right…Jul 16, 1984 · N8719 · DestroyedNTSB MKC84LA215Accident · No injuriesLimited investigationFinal reportCessna 172H · Marvell, ARThe acft collided with telephone lines as the plt was making a low pass over the passengers place of business. The plt said he did not know the lines were there when his passenger asked for the low pass. The acft stalled and contacted the ground on the…Jul 15, 1984 · N8820Z · Substantial damageNTSB LAX84LA394Accident · Serious injuriesLimited investigationFinal reportExperimental Amateur Built OWL Racer · Oroville, CAThe Experimental/amateur built aircraft had just turned inbound for an exhibition race run when it experienced severe vibrations as the pilot applied full power. He headed for the runway and found that he could not control the engine with the throttle. He was…Jul 15, 1984 · N711BS · Substantial damageNTSB LAX84FA395Accident · No injuriesField investigationFinal reportHiller UH-12E · Orcutt, CAMaintenance had just been performed & the crew were beginning a test flt to check the tracking of the main rotor blades. While the plt was hover taxiing, he lost collective control & rotor RPM decreased. However, he was able to make a roll-on landing, but the…Jul 15, 1984 · N4030A · Substantial damageNTSB DEN84FA222Accident · 2 fatalField investigationFinal reportNorth American P-51D · Carbondale, COThe plt was performing aerobatic maneuvers in a P-51D that had been modified for racing & exhibition. Witnesses near the accident site stated that the acft had just completed several aerobatic maneuvers before it began a vertical climb. The climb was…Jul 15, 1984 · N5449V · DestroyedNTSB MKC84LA217Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Osceola, ARThe acft crashed into a levee in a rice field after losing engine power during a spray operation turn-around. The enginedid not quit entirely but lost enough power so that flt was not maintained. An inspection of the engine revealed a broked connecting rod.Jul 13, 1984 · N7928 · Substantial damageNTSB MKC84LA214Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Brule, NEAccording to the pilot, during the swath run the left wing dropped and the acft flew into the corn field. Density altitude was aprx 5,200 ft.Jul 13, 1984 · N6825K · Substantial damageNTSB LAX84FA390Accident · Serious injuriesField investigationFinal reportCessna T188C · Brawley, CAThe acft crashed shortly after takeoff from a dirt strip. The plt said the acft was 'over-gross' and that it would not climb. The plt had used full flaps for takeoff and when the acft would not climb he reached for the dump or load jettison handle and grabbed…Jul 13, 1984 · N9951J · DestroyedNTSB CHI84FA290Accident · 1 fatalField investigationFinal reportJerry D. Fish Drifter · Columbus, INDuring flt, the plt was performing aerobatics & did a series of loops. While maneuvering, the left wing folded upward & the acft, an experimental ultralight, entered a descent & crashed. An exam revealed that the left wing had folded over the eng. Evidence…Jul 13, 1984 · N5150J · DestroyedNTSB CHI84FA289Accident · 1 fatalField investigationFinal reportAero Commander Callair A-9 · Pullman, MIThe acft crashed while practicing aerial application maneuvers. The plt of the acft had been interrupted at the refueling pump by an acft which was awaiting a chemical reload. The student crop dusting plt, who was also a loader, left the refueling area to…Jul 13, 1984 · N7714V · DestroyedNTSB SEA84FA172Accident · 1 fatalField investigationFinal reportSchempp-Hirth Ventus A · Ephrata, WAA 'gaggle' of about 7 gliders were maneuvering in a climb when N919R climbed into the group. The plt of N17KS said he saw N919R closing and increased his angle of bank to about 100 degrees to try and avoid a collision. The leadingedge of the left wing of…Jul 12, 1984 · N17KS · 2 aircraft · Minor damageNTSB MKC84LA213Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Gillette, ARDuring swath run engine ran rough and could not sustain acft in flight. The plt made a forced landing in a soft freshly plowed field. The acft nosed over during the landing. Inspection of the acft revealed that one magneto was missing teethfrom the drive gear…Jul 12, 1984 · N9785 · Substantial damageNTSB DEN84FA219Accident · 1 fatalField investigationFinal reportPiper PA-25-235 · Peetz, COPlt had completed spraying around farm buildings for insect control. On first pass in crop area, the acft was observed to pull up over pwr lines at end of swath run but collided with overhead ground wire at top of multi- wire array. Acft then collided with…Jul 12, 1984 · N6484Z · DestroyedNTSB MKC84LA209Accident · Serious injuriesLimited investigationFinal reportGrumman G-164B · West Memphis, ARThe acft nosed over during an off arpt forced landing following an engine failure. During post accident examination the acft was found to have a cracked #7 cylinder.Jul 11, 1984 · N8109K · DestroyedNTSB LAX84FU029Accident · 1 fatalFinal reportUltralight Soaring Wizard J-3B · Lake Elsinore, CAThe Ultralight was observed by witnesses to be circling, then performed what was described as a 'barrel-type' maneuver. During the maneuver, the right wing collapsed and the acft spiraled to the ground in an uncontrolled descent. During theinvestigation of…Jul 11, 1984 · UNREG · DestroyedNTSB CHI84LA288Accident · No injuriesLimited investigationFinal reportRotorway Executive · Cambridge, WIThe fixed wing plt who was not qualified to fly rotorcraft tried to hover his homebuilt acft. After failing the 1st timehe tried again and this time the acft rolled over and burned. The plt said the roll over occurred so fast he did not have time to act.Jul 11, 1984 · N2993P · DestroyedNTSB DEN84LA216Accident · No injuriesLimited investigationFinal reportBell 206B · Salina, UTThe acft crashed during takeoff. The plt said he was hovering after takeoff at about 20 ft AGL when he noticed a long line draped over the rt skid. He said he thought he could dislodge it. While maneuvring to attempt this, the helicopter rolled to the rt and…Jul 10, 1984 · N878LC · Substantial damageNTSB MKC84LA210Accident · No injuriesLimited investigationFinal reportGrumman G164B · Mc Gehee, ARThe acft was engaged in an aerial application flt when the eng lost power. The plt made a forced landing in a bean field. During the landing roll, the acft struck a levee that was obscured by high vegetation & nosed over. A post-accident investigation…Jul 9, 1984 · N8222K · Substantial damageNTSB DEN84LA214Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Empire, COPlt stated, 'departed arapahoe, planning on selecting best mountain pass versus altitude achieved. At 10,500, decided pass I was entering would be too difficult & began maneuvering for 180 turn. Severe downdraft occurred & altitude & airspeed lost precluded a…Jul 9, 1984 · N9638W · Substantial damageNTSB MKC84LA206Accident · Minor injuriesLimited investigationFinal reportBrantly Helicopter B-2 · Bennington, KSThe student plt stated that after lifting to a hover on her first solo flt, she made two 180 degree hovering turns. She said that the helicopter entered a violent lateral vibration and descended to the ground. Examination of the wreckage did not disclose any…Jul 8, 1984 · N4999C · Substantial damageNTSB CHI84FA282Accident · Serious injuriesField investigationFinal reportCessna 205 · Oak Brook, ILPilot and passengers here circling over a golf tournanent taking photographs when the engine quit. The pilot made an emergency landing on an adjacent golf course and the aircraft struck a tree during the rollout. Post accident exam of the eng revealed no…Jul 8, 1984 · N8377Z · DestroyedNTSB ATL84FA216Accident · 1 fatalField investigationFinal reportCessna 150J · Terry Town, GAWitnesses observed the aircraft manuvering in the vicinity of the accident site at about 100 ft AGL. A second low pass was executed, terminating with a sharp pull up to a near vertical attitude. The acft climbed to about 300 ft AGL, the nose tucked under and…Jul 8, 1984 · N50776 · Substantial damageNTSB MKC84LU005Accident · Serious injuriesFinal reportUFM Easy Riser · Des Moines, IAThe ultralight was making turns at low alt when it stalled and spun into the ground. The plt was unable to recover before ground impact.Jul 7, 1984 · UNREG · Substantial damageNTSB FTW84FA302Accident · 1 fatalField investigationFinal reportMooney M-18LA · New Iberia, LAA plt witness observed the acft in a 20 to 30 deg dive at high speed just prior to the accident. He reported that at an alt of about 1200 to 1300 ft, the acft began a pull-up. As the pull-up was started, the outboard portion of the acft's left wing folded…Jul 7, 1984 · N4090 · DestroyedNTSB DEN84LU007Accident · 1 fatalFinal reportEipper Quicksilver MXL · Granby, COReportedly, the plt was flying at low altitude over a lake & had to pull up to cross over a dam. After crossing the dam, he began to descend, but the ultralight vehicle collided with power lines on the down river side of the dam. The power lines were about…Jul 7, 1984 · UNREG · DestroyedNTSB ATL84LA217Accident · Serious injuriesLimited investigationFinal reportCessna T188C · Glen Allen, MSThe plt stated that while doing aerial applications and flying into the sun he failed to see a tree and collided with it. The pilot was not wearing sunglasses nor was the aircraft equipped with sun shading devices.Jul 7, 1984 · N2803J · DestroyedNTSB NYC84FA233Accident · 1 fatalField investigationFinal reportGrumman AA-5 · Woodstock, NYAcft was on a VFR personal flight. Witness on mountain slope heard sounds of approaching acft, observed brief glimpse of acft wheel and wing through cloud and fog about 100 ft away, at tree-top level. A few seconds later. Witness heard eng sound cease.…Jul 6, 1984 · N9519L · DestroyedNTSB FTW84LA301Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Killian, LAThe acft crashed while in a steep bank at low alt in VMC wx.a witness who knew the plt said he heard the acft approaching, went outside his house and saw the acft at about 200 ft AGL. The acft went into a turn and became almost inverted before colliding with…Jul 6, 1984 · N33074 · DestroyedNTSB MKC84FU004Accident · Serious injuriesFinal reportAmer. Aerolight Eagle 2 PLC · Millard, NEThe plt reported that after exchanging the canard elevator & readjusting the spoiler control teleflex cable rod end at the spoiler bellcrank, he took off on a test flt. After about 5 min of flt, the right spoiler failed to retract after it was used during a…Jul 5, 1984 · UNREG · Substantial damageNTSB MIA84FA200Accident · 1 fatalField investigationFinal reportPeter A. Yarger Skybolt · St. Augustine, FLDuring a turn after takeoff the plt reported the control stick suddenly 'snapped back' to the full nose up position. The acft was at about 300 ft AGL when it stalled. The pilot who was in the back seat was unable to recover before ground impact. After the…Jul 5, 1984 · N9722A · Substantial damageNTSB NYC84LA230Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-160 · Bargaintown, NJThe acft was on a banner tow mission. Plt dropped banner and initiated a pull-up manuever to go-around and return for a landing. As the plt pulled up, a downdraft was encountered at the end of the field. Plt initiated a right turn and acft continued sinking…Jul 4, 1984 · N3040Z · DestroyedNTSB NYC84FGM05Accident · No injuriesFinal reportBell 47G-5 · Penn Run, PAThe plt was spraying a potatoe field with a lightly loaded helicopter when the eng failed. At that time, the helicopter was about 10 ft AGL in a slight right turn & at aprx 35 mph. The plt flared to stop the forward movement & landed, but the tail rotor…Jul 4, 1984 · N1477W · Substantial damageNTSB CHI84LA279Accident · Serious injuriesLimited investigationFinal reportBell 47G2 · Detroit, MIThe acft landed in the Detroit river after the engine sputtered and the acft vibrated. The plt reduced pwr & collective and pushed the cyclic forward. The RPM reduced from 3000 to 2500 but the rotor and engine RPM remained married. The plt adjusted descent…Jul 4, 1984 · CFISH · DestroyedNTSB BFO84FU001Accident · 1 fatalFinal reportEipper Quicksilver MX · Elkton, MDThe ultralight pilot had been practicing maneuvers that weredescribed as whip stalls which were not taught or authorizedbecause of the excessive 'g' forces imposed. An instructor checked his machine and warned him of the dangers on the day of the accident.…Jul 4, 1984 · UNREG · Substantial damageNTSB SEA84LA159Accident · No injuriesLimited investigationFinal reportApplebay Sailplanes Zuni II · Ephrata, WAThe two gliders collided while thermaling in vicinity of each other while engaged in a contest. According to the plts they lost sight of each other while spiraling in the lift. Both acft landed safely. The collision was nose to tail.Jul 3, 1984 · N22HL · 2 aircraft · Substantial damageNTSB MKC84LA200Accident · Minor injuriesLimited investigationFinal reportGrumman G164A · Bernie, MODescending out of the procedure turn into a swath run the plt was unable to level the acft in time to avoid flying into the bean field. The acft nosed over on impact and caught fire. Density altitude was about 2,800 ft. acft gross weight was aprx 5,500…Jul 3, 1984 · N4796 · Substantial damageNTSB MKC84FA197Accident · 1 fatalField investigationFinal reportPiper PA-18-150 · Wright, ARDuring aerial application, the plt was making a left turn over high voltage power lines when the acft hit the cables, crashed & burned in a rice field. An exam revealed 2 wire marks & 2 electrical arc marks on the left wing along with wire marks on one of the…Jul 3, 1984 · N4025 · DestroyedNTSB CHI84LA274Accident · No injuriesLimited investigationFinal reportHughes 269B · Eden Prairie, MNThe CFI stated that while practicing a pedal turn the student pilot suddenly applied back cylic causing the tail rotor to contact the ground. The main rotor then contacted the ground and the helicopter rolled over.Jul 3, 1984 · N9487F · Substantial damageNTSB CHI84IA294Incident · No injuriesIncident investigationFinal reportEnstrom F-28A · Muncie, INAccording to the plt, he was in a 20 deg left bank with an airspeed of about 40 KTS when the helicopter began rotation to the right. He entered an autorotation & landed with a forward speed of about 5 KTS. An exam revealed that the tail rotor drive shaft had…Jul 3, 1984 · N13CM · Minor damage