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 CHI85LA027Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Tecunseh, MIWhile on an aerial application flight, the plt noted a change in engine sound and a slight power loss. During turn to return to the airstrip for precautionary lndg, complete power loss occurred. A forced landing was executed in soft terrain. On lndg roll, the…Oct 24, 1984 · N5299 · Substantial damageNTSB LAX85FA030Accident · Serious injuriesField investigationFinal reportCessna 150M · Lee Vining, CAThe acft crashed into a mountain during a VFR x-country. The acft was approaching the mountain ridge on the lee side anddid not clear the top of the ridge. The plt said that when he saw the acft was not going to clear the ridge he lowered 10 degrees of flaps…Oct 21, 1984 · N704EQ · DestroyedNTSB CHI85FA021Accident · 2 fatalField investigationFinal reportTaylorcraft BC12-D · Kiel, WIWitnesses observed acft performing aerobatics during demo flight prior to prospective sale of acft to buyer/pax. A plt/witness observed the acft executing slow speed stalls and enter a spin from an altitude of about 1000 ft. recovery was accomplished at about…Oct 20, 1984 · N43833 · DestroyedNTSB MIA85FA012Accident · 3 fatalField investigationFinal reportHughes 369D · St.ThomasThe acft was flying at 50 feet above the water at 15 knots airspeed photographing a sail boat. The acft then climbed to 150 feet and drifted left over the top of the boat. At this point witnesses reported hearing a loud pop and seeing a puff of black smoke…Oct 19, 1984 · N8631F · DestroyedNTSB DEN85LA013Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Loring, MTAcft stalled while making a downwind turn during slow flight at a low alt while on a cattle survey flt. Acft descended, impacted the terrain and was destroyed by fire.Oct 19, 1984 · N7478L · DestroyedNTSB ATL85FA013Accident · 1 fatalField investigationFinal reportCessna 150L · Douglas, GAThe passenger reported that the former aerial application plt was demonstrating an aerial application maneuver when he entered a steep descent over a lake. The plt delayed the recovery and the passenger, who held a student plt certificate, attempted to level…Oct 19, 1984 · N5226Q · Substantial damageNTSB ATL85FA011Accident · 1 fatalField investigationFinal reportBeech QU-22A 1074 · Fancy Gap, VAAt about the 2,800 ft level the acft flew into the mountainous terrain which was obscured by clouds. Witnesses observed 2 previous attempts to fly over the rising terrain under the cloud layer. Departure and dest arpt, plt identity, and acft owner are all…Oct 17, 1984 · N83475 · DestroyedNTSB FTW85LA017Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Seminole, TXThe plt reported that while on a local flt the engine 'blew up' & he made an emergency landing. He stated that the windshield was covered with oil & he could not see to flare the acft & landed hard. Inspection revealed a failure of the #4 rod at the master…Oct 16, 1984 · N3164Y · Substantial damageNTSB FTW85FA012Accident · 7 fatalField investigationFinal reportConsolidated-Vultee PBY-6A · Port Isabel, TXAerial photos were being taken of the mishap acft. Mission called for a simulated water lndg (actual water lndg prohibited) by flying as close as possible to water. Co-plt at controls descended acft to about 6 ft, then gradually reduced clrnc to 6-12 inches…Oct 13, 1984 · N16KL · DestroyedNTSB MKC85LA006Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Cotton Plant, ARDuring aerial application flight, the engine master connecting rod failed. Forced landing was performed in a Cotton field. Acft nosed over during landing roll due to terrain conditions. Engine had 176 hours since major ovhl.Oct 11, 1984 · N8644H · Substantial damageNTSB FTW85FA010Accident · 2 fatalField investigationFinal reportRockwell 695A · Checotah, OKThe pilot allowed the aircraft to stall at an altitude which was too low to effect recovery before ground impact occurred. He was in the process of performing VMC test and maximum performance single engine climbs during the test flight. Witness description of…Oct 9, 1984 · N81502 · DestroyedNTSB LAX85LA004Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Lamont, CAThe plt stated that he had flown earlier on the day of the accident for aprx 30 mins. He stated that he intended to refuel before his next flight, but because the fuel hose would not reach the aircraft, the acft was not refueled. Thepilot did not visually…Oct 7, 1984 · N6587 · Substantial damageNTSB ATL85FLT01Accident · 2 fatalFinal reportMitchell Ronald A Skybolt · Athens, TNThe acft collided with the ground inverted with the rt wing and nose hitting first. Witnesses said that the acft appeared to be doing aerobatics and entered a flat inverted spin. The plt/owner in the back seat held an ATP certificateand reportedly had over…Oct 7, 1984 · N8506C · DestroyedNTSB CHI85FA004Accident · 1 fatalField investigationFinal reportKallansrud/Pitts S-1C · Overisel, MIMishap acft, in company with another acft of same make/model, made preplanned passes over locale of residence prior to departure for short cross-country. After several circles at 500 ft AGL, mishap plt broke out of loose formation into shallow dive; other plt…Oct 6, 1984 · N561CK · DestroyedNTSB LAX85LA002Accident · Minor injuriesLimited investigationFinal reportHiller UH-12E · Firebaugh, CAThe acft collided with terrain while on an aerial application flt. The plt stated he, 'heard a loud bang' while spraying. Then the 'nose of the helicopter dove radically down', and he crashed into the field. Examination of the site revealed that one of the…Oct 5, 1984 · N161HA · Substantial damageNTSB DEN85LA004Accident · Minor injuriesLimited investigationFinal reportAerospatiale SE316B · East Glacier, MTThe acft crashed at a remote landing site while on a seismic operation. The plt stated that he departed a ridge- top with intentions of dropping off 2 to 4 passg at another ridgetop located one-half mi south. The intended ldg point was a narrow ridgetop at…Oct 5, 1984 · N98325 · Substantial damageNTSB SEA85FA001Accident · 3 fatalField investigationFinal reportCessna R182 · Austin, NVDeteriorating wx was encountered as the plt followed a highway to his dest on an easterly heading. On scene evidence indicated that the acft impacted left wing tip first on a northerly heading near the east end of a box canyon. The impact flight path angle…Oct 2, 1984 · N1842R · DestroyedNTSB MIA85LA001Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Miami, FLThe rated pilot and certified flt instructor stated that they were practicing agricultural dives and turns. During a dive, the pilot pulled out of the dive at about 5 feet and the aircraft contacted sawgrass and crashed. The instructor pilot initially stated…Oct 2, 1984 · N2427P · Substantial damageNTSB FTW85LA001Accident · No injuriesLimited investigationFinal reportCessna TU206G · Chandeleur Isl, LAPlt was flying low and slow in area awaiting arrival of boat for fishing party. Plt allowed his attention to be distracted by spotting fish & inadvertently contacted water with a float. Acft came to rest inverted in 6 inches of water.Oct 1, 1984 · N4641U · Substantial damageNTSB DEN84FTM04Accident · 1 fatalFinal reportRolladen-Schneider LS3 · Brigham City, UTThe acft impacted on a mountain ridge during a 60 deg left bank. The plt had been in radio communication with another glider plt near his flt area. Just prior to the accident he radioed that he was going around a mountain point in search of a thermal. When no…Sep 29, 1984 · N8JN · Substantial damageNTSB MKC84FA285Accident · 2 fatalField investigationFinal reportPiper PA-22-108 · Wilmot, ARWitnesses stated, acft was seen circling over farmland and during the third circle it descended toward a brick house. The acft was seen to pull-up at which time it contacted the top of a sycamore tree in a left bank. The acft continued an additional 230 ft…Sep 28, 1984 · N4722Z · DestroyedNTSB DEN84FA303Accident · 1 fatalField investigationFinal reportPiper PA-31-310 · Paonia, COThe acft was flying at a very low alt over mountanous terrain. As the acft approached a crest of a ridge the acft started to buffet and then encountered a downslope wind condition. The combination of approaching a stall and encountering a downdraft forced the…Sep 28, 1984 · N7205L · DestroyedNTSB DEN84LA301Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Kiowa, COWhile practicing a simulated engine failure the student plt inavertantly shut off the fuel. During the actual forced landing in a rough field, the acft contacted a yucca plant and a gear collapse resulted. The CFI later reported the spring loaded safty stop…Sep 26, 1984 · N8145V · Substantial damageNTSB ATL84FA297Accident · 2 fatalField investigationFinal reportBell 206B · Kernersville, NCWhile dismantling a water tower, an iron worker was seriously injured & pinned as he was removing a portion of a water tower leg (aprx 92 ft AGL). The helicopter plt responded to the emergency. The acft was equipped with a make-shift sling line to retrieve…Sep 26, 1984 · N7CF · DestroyedNTSB LAX84LA494Accident · Serious injuriesLimited investigationFinal reportHiller UH12ET · Yuma, AZThe pilot stated that he was carrying a load of pesticide for application on a broccoli field. The aircraft was in level flight, approximately 4 to 8 feet AGL when it became uncontrollable and impacted the ground. The aircraft was consumed by a post crash…Sep 25, 1984 · N9278Z · DestroyedNTSB ATL84LA295Accident · Minor injuriesLimited investigationFinal reportBell 47G-5 · Bluefield, WVThe pilot stated that he hovered the helicopter, made a right pedal turn and initiated a hover taxi across a rocky ravine adjacent to the pad. When over the ravine the helicopter settled onto to boulders beneath it. The pilot also stated that he thought he…Sep 24, 1984 · N1398X · Substantial damageNTSB ATL84LA294Accident · No injuriesLimited investigationFinal reportHughes 269B · Saluda, SCThe acft crashed during an attempted practice autorotation after power was applied to effect a recovery. The CFI, on theflt, stated that he noticed that the student was going to overshoot and instructed him to make a power recovery at 100 ft AGL. He said that…Sep 23, 1984 · N9339F · DestroyedNTSB FTW84FU009Accident · 2 fatalFinal reportMitchell T-10R263 · Mckinney, TXAccording to a person who helped assemble the ultralight vehicle for flt, the base of the clouds were at about 200 ft AGL, when the plt took off. The helper expected the plt to return & land due to the wx; however, the vehicle crashed in a wooded area. There…Sep 22, 1984 · UNREG · DestroyedNTSB CHI84LA398Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-160 · Richmond, INThe acft collided with power lines and crops after a loss of power while on a training flt. The CFI and student plt were practicing in cruise, single eng simulation by leaning the rt eng and setting a 'zero' thrust condition. The student was then to set the…Sep 22, 1984 · N4433P · DestroyedNTSB LAX84LA488Accident · Serious injuriesLimited investigationFinal reportBell 206B · Paso Robles, CAPlt stated that after receiving a special VFR clearence he took off to spray a nearby field. He continued to state that he 'made a couple of circuits over the field, observed the telephone wires and began spraying. After performing 2 or 3 passes I hit some…Sep 20, 1984 · N2246W · DestroyedNTSB DEN84FU011Accident · 1 fatalFinal reportEipper Quicksilver MX · Brighton, COThe ultralight was turning in a spiral turn to the right when witnesses heard the engine stop. The acft went into a spinand crashed. Witnesses said the plt had been doing this before with a pull out at about 50 ft AGL and a restart of the engine. The height…Sep 20, 1984 · UNREG · DestroyedNTSB ANC84LA186Accident · Minor injuriesLimited investigationFinal reportChampion 7KCAB · Anchorage, AKThe float equipped acft crashed while maneuvering near a small lake. The plt stated that while at 1000 ft AGL the eng 'coughed a few times and died'. The plt told the rescue crew that his eng iced-up while was at low alt. The passenger stated that the acft…Sep 19, 1984 · N9143L · Substantial damageNTSB NYC84FNE06Accident · Minor injuriesFinal reportBell 206L-1 · Somers, CTPlt stated acft began to settle and roll to right from stable 3 foot hover. Application of left cyclic did not arrest roll and main rotor made ground contact. Plt had 11 hrs in this make & model.Sep 17, 1984 · N2088V · Substantial damageNTSB DEN84LA292Accident · No injuriesLimited investigationFinal reportAerospatiale SA315B Lama · Mountain View, WYThe helicopter experienced a loss of power during an external load operation. The plt released the load and performed an autorotation. A hard landing resulted during which the tail boom was severed by the main rotor blades. Metallurgical examination of the…Sep 17, 1984 · N49532 · Substantial damageNTSB DEN84FA293Accident · Serious injuriesField investigationFinal reportCessna 172K · Aspen, COAfter takeoff from a valley airstrip in mountainous terrain, plt elected to climb out straight ahead toward rising terrain instead of circling to gain altitude first (normal procedure). Approaching mountain pass, acft was observed climbing below level of the…Sep 17, 1984 · N78680 · Substantial damageNTSB LAX84FUJ04Accident · 1 fatalFinal reportWeatherly 620 · Waddell, AZThe acft collided with a power line during a spray operation. Witnesses said the acft flew under a power line and as it pulled up collided with a line which angled off of the main line. The vertical stabilizer and part of the rudder separated. The acft nosed…Sep 16, 1984 · N46032 · DestroyedNTSB DEN84LA291Accident · No injuriesLimited investigationFinal reportCessna 172P · Longmont, COThe plt was making a low pass over a strip he wanted certified. During an attempted go-around the eng would not respond so the plt landed. The acft ran off the end of the wet sod airstrip and nosed over. The plt said after the accident that the carburetor…Sep 16, 1984 · N6579K · Substantial damageNTSB DEN84LA280Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Canton, SDDuring a descending apch to an unfamiliar cornfield for a swath run, the plt stated he had 'a flashing vision of wires.' The plt pushed the control stick forward to avoid hitting the wires at which time the acft contacted a corn crop in a slight nose down…Sep 15, 1984 · N7236Z · Substantial damageNTSB LAX84FU034Accident · 1 fatalFinal reportMitchell A-10 · Corning, CAThe ultralight had recently been purchased by the new owner who received no instruction in its operation. On the day of the accident, he told his wife he was just going to taxi-test the vehicle. She said there was no intent to fly. When sheno longer heard or…Sep 14, 1984 · UNREG · DestroyedNTSB NYC84FFJ05Accident · Minor injuriesFinal reportHomebuilt DER Jager DIX · Albion, NYThe plt reported that after takeoff he did normal flt maneuvers, slow flt, stalls & wing overs in the Homebuilt acft. He then decided to do a barrel roll, which he described as smooth until completion when the acft wanted to continue in the roll & the nose…Sep 13, 1984 · N4JE · DestroyedNTSB MIA84LA252Accident · Minor injuriesLimited investigationFinal reportAyres S2R-T15 · Climax, GAThe plt said he was familiar with the area and was aware of the power line but misjudged his clearance and inadvertantlycollided with the top wire. The wire broke and wrapped around the landing gear of the acft and dragged it down. The acftwas destroyed when…Sep 13, 1984 · N40184 · Substantial damageNTSB FTW84LA391Accident · Serious injuriesLimited investigationFinal reportBell 206B III · Ship Shoal 241The pilot had landed on a offshore helideck, which had one aircraft parked on it. After the passengers were clear of the aircraft, the pilot picked the aircraft up to a hover. During the hover, the pilot allowed the aircraft to drift slightly and one skid…Sep 13, 1984 · N22713 · DestroyedNTSB DEN84FA290Accident · Serious injuriesField investigationFinal reportBell 206L-3 · Denver, COPlt had slowed the helicopter to 30 KIAS using 50 to 60% pwr at an alt of 700 ft AGL. Plt the heard 'two beeps' from the eng out warning horn, saw eng out annunciator lights illuminate & the 'turbine neddle dropping.' Plt 'bottomed'the collective, lowering…Sep 13, 1984 · N99TV · DestroyedNTSB ANC84LA178Accident · Serious injuriesLimited investigationFinal reportPiper PA-11 · Tasnuna Valley, AKThe plt stated that they had just taken off from a gravel bar when they spotted a moose. He circled the moose in a left orbit at about 65 miles per hour. During one of the orbits the 'right wing fell in a downward direction and the nose of the acft pitched…Sep 13, 1984 · N4801M · Substantial damageNTSB FTW84LA415Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Lamesa, TXThe plt stated he was following an aerial application acft & may have encountered propeller wash/downdraft. The acft collided with the ground & was substantially damaged.Sep 12, 1984 · N61564 · Substantial damageNTSB NYC84FA310Accident · 2 fatalField investigationFinal reportAeronca 11AC · Newbury, MAThe student plt had logged approximately 240 hrs of flying time. He was not certificated to carry pax. Witnesses stated that they observed the acft descend at a slow airspeed to an alt of 100 ft. the acft then made a steep bank turn to the right and impacted…Sep 11, 1984 · N85819 · DestroyedNTSB NYC84LA278Accident · No injuriesLimited investigationFinal reportCessna C182 · Norridgewock, MEA parachte became entangled in the horizontal stabilizer while the acft was maneuvering to drop the parachutists. The acft made a hard landing after the parachustist disengaged from the acft. The acft stabilizer spar was damaged in the encounter and the lack…Sep 9, 1984 · N90G · Substantial damageNTSB DEN84FU010Accident · Serious injuriesFinal reportWeedhopper B · Erie, COThe ultralight engine lost power while the plt was in a practice area. He returned to the arpt, and during the attempt to land, the acft crahsed. An instructor said the acft seemed to be flying slower than normal and the plt extended the downwind turn to base…Sep 9, 1984 · UNREG · Substantial damageNTSB ANC84FA169Accident · 1 fatalField investigationFinal reportStinson 108 · Hayes River, AKThe plt was on a low level flt to spot wild game when the acft crashed on a gravel drainage bar. A witness stated the acft was flying 5 to 6 ft AGL when the accident occurred.Sep 9, 1984 · N6660M · DestroyedNTSB NYC84FA307Accident · 4 fatalField investigationFinal reportBell 206B · Wallingford, CTThe acft collided with wires after the plt announced by radio that he was going to make a low pass over the site of an outdoor event that he had just attended. Some witnesses saw the helicopter flying extremely low. It appeared that one of the landing skid…Sep 8, 1984 · N4FL · Destroyed