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 LAX84FU027Accident · 2 fatalFinal reportMitchell TU-10 · Perris, CAThe purpose of the flt was for one instructor plt (CFI) to check out the other CFI in the ultralight vehicle. Reportedly, many witnesses watched as the acft climbed to aprx 3000 ft AGL. The aircrew then performed a series of rolls to the left & right. The…May 13, 1984 · UNREG · DestroyedNTSB FTW84FA224Accident · Serious injuriesField investigationFinal reportAeronca 11BC · Hamilton, TXThe acft stalled at 1500-2000 ft AGL and collided with a fence and the ground during recovery attempts. The plt said theacft was intentionally stalled but the spin was not expected. The acft was estimated to be aprx 47 lbs over max gross weight. The flt had…May 13, 1984 · N4081E · DestroyedNTSB MKC84LA136Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Lepanto, ARThe acft lost power during an aerial application flt & crashed during a forced landing. An investigation revealed that the magnetos were not in an airworthy condition at the time of the accident. The acft had been operated 338 hrs since the last 100 hr…May 12, 1984 · N731VM · Substantial damageNTSB NYC84FA170Accident · 1 fatalField investigationFinal reportI.C.A. Brasov IS-29D2 · Collegeville, PAAccording to a witness who ran the wing of the glider during takeoff, at 250 to 300 ft AGL the tow acft turned left but the glider maintained rwy heading. Shortly thereafter the tow line released at the glider-end and the glider initiated a right turn. After…May 11, 1984 · N29DT · DestroyedNTSB MIA84FA166Accident · 1 fatalField investigationFinal reportBell UH-1B · Clermont, FLThe plt was not aware that two ground attendants were riding the cable during a logging operation when there was an accidental cable release & the attendants fell to the ground. Examination of the acfts hook did not reveal a system failure or malfunction.…May 10, 1984 · N2252A · No damageNTSB MIA84FA164Accident · 1 fatalField investigationFinal reportMooney M-18C · Sugar Loaf Key, FLThe acft was observed making several passes over a friends house. At the end of the third pass during, a climbing left turn, the right wing separated from the acft. Inspection of the wreckage revealed wood rot in the main wing spar. The last known inspection…May 10, 1984 · N487M · DestroyedNTSB LAX84LA294Accident · Minor injuriesLimited investigationFinal reportHiller UH-12E (Soloy) · Delano, CAThe helicopter experienced an inflt failure of an eng mount, pn 63181-5, which bent the collective control rod & forced the the collective pitch into the up position. The helicopter then settled into the grapes it was spraying & made a hard landing. An…May 10, 1984 · N90461 · Substantial damageNTSB FTW84LA228Accident · 1 fatalLimited investigationFinal reportRockwell S-2R · Bay City, TXWhile spraying a field with propanel & modown grass killers, the plt was crossing below a high tension power line. The vertical stabilizer contacted the lowest wire which tore loose the vertical stabilizer. The acft pitched nose up, then it dove down, crashed…May 10, 1984 · N8481V · Substantial damageNTSB FTW84LA225Accident · No injuriesLimited investigationFinal reportGrumman G164A · Fenton, LAThe acft, while maneuvering at low alt, hit the ground and flipped inverted. The plt reported encountering a strong downdraft over a wooded area and in maneuvering to avoid the trees, the acft settled to the ground. The plt reported winds from 225 degrees at…May 7, 1984 · N48377 · DestroyedNTSB CHI84FA180Accident · 1 fatalField investigationFinal reportColonial C-2 · Stone Lake, WIThe plt had flown to little sissabagama lake where he owned a cabin. A witness had observed the last 3 mins of flt but not the actual impact with the water. The acft was later found inverted in 15 ft of water 300 ft from a shore. Plt was found 150 ft from the…May 7, 1984 · N281B · Minor damageNTSB FTW84FA220Accident · 1 fatalField investigationFinal reportPitts Special S-1 · La Marque, TXThe plt was scheduled to perform aerobatics in an air show. While maneuvering at about 300 ft AGL, the acft entered a nose high, steep left turn, stalled, then entered a 2 turn spin to the left. The plt recovered in a nose low, wings level attitude, but the…May 5, 1984 · N31DF · DestroyedNTSB CHI84LA177Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Boyd, MNThe acft was circling a field at about 400 to 500 ft AGL in at least a 40 degree bank when it stalled. The pilot added power and lowered the nose, as the acft was recovering from the stall it impacted the ground and nosed over.May 5, 1984 · N50022 · DestroyedNTSB ATL84LA163Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Jesup, GAThe plt reported he was spraying water and at the end of a swath run when he turned off the spray and pulled up, the engine lost power. The acft collided with trees during the forced landing. No mechanical discrepencies or malfuntions were found after the…May 5, 1984 · N90856 · DestroyedNTSB FTW84LA222Accident · Minor injuriesLimited investigationFinal reportBeech A36TC · Marble Falls, TXDuring arrival, the plt descended from 10,500 ft to 2300 ft, then circled a house 3 times before turning toward the arpt. As he rolled the wings level & was preparing to call the arpt, the eng lost power. He was unable to start the eng, so he elected to make…May 4, 1984 · N321TJ · DestroyedNTSB FTW84LA219Accident · Minor injuriesLimited investigationFinal reportCessna 180B · Galveston, TXThe a/c was being flown at about 300 ft over the bay and the pilot and passenger were looking for fish. When the pilot made a turn to fly in a downwind direction the aircraft started to stall. The pilot stated that he advanced the throttle but the engine did…May 4, 1984 · N5190E · DestroyedNTSB NYC84FA157Accident · 1 fatalField investigationFinal reportCessna A152 · Bethlehem, PAThe acft crashed while spinning from low alt. The acft was observed by witnesses doing aerobatics at low alt. At the topof loop or vertical climb the acft did a hammerhead stall under power and went into a spin. It appeared to one witness as if the plt was…May 2, 1984 · N8135L · DestroyedNTSB LAX84LA278Accident · Minor injuriesLimited investigationFinal reportChristen Eagle Stallins 195 · Knights Landing, CAThe acft crashed during a series of aerobatic practice maneuvers. The plt reported that during the positive and negative'g' maneuvers he 'apparently passed out.'May 2, 1984 · N195RS · Substantial damageNTSB DEN84FA142Accident · Serious injuriesField investigationFinal reportHughes 369D · Meeker, CODuring slow (35-40 KTS) cruise flt at about 50 ft AGL in mountainous terrain for wildlife survey, pwr loss occurred. Auto systems briefly restored pwr, followed by a ttl loss. Plt executed emergency autorotation into trees on sloping terrain. Investigation…May 2, 1984 · N1090A · Substantial damageNTSB MIA84LA158Accident · No injuriesLimited investigationFinal reportBoeing A75L300 · Daytona Beach, FLThe acft lost power while the plt was towing a banner over water. He was unable to restart the eng & subsequesntly ditched the acft in the ocean near Daytona Beach, FL. The plt elected to keep the banner attached to the acft to keep the plane from flipping…May 1, 1984 · N65676 · Substantial damageNTSB LAX84LA273Accident · Minor injuriesLimited investigationFinal reportBell UH-1B · Salinas, CAWhile spraying a field of artichokes, the plt had made 1 pass southbound & started another northbound. He began the swath run by descending over power lines, then tried to climb & clear rising terrain beyond the lines. However, the helicopter continued…Apr 29, 1984 · N57HP · DestroyedNTSB SEA84LA097Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Hermiston, ORDuring a beginning swath run, the plt was making a left skidding turn to follow the edge of a circular field. He stated that the acft encountered a downdraft which raised the right wing. Subsequently, the left wing contacted the ground & the acft crashed.Apr 28, 1984 · N4897 · Substantial damageNTSB MKC84FU002Accident · Serious injuriesFinal reportRally Rotec 2B · Carroll, IAThe ultralight was seen maneuvering at low alt in the vicinity of the accident. The plt circled his brother's house at low alt and then pulled up abruptly to avoid rising terrain. In the abrupt maneuver, the plt lost control of the ultralight and impacted the…Apr 28, 1984 · UNREG · Substantial damageNTSB MIA84FA156Accident · Serious injuriesField investigationFinal reportMurphy-Charles PJ-1 (Adventure) · Merritt Island, FLWhile the plt was maneuvering on final approach to land on rwy 11, the eng lost power. Subsequently, the acft crash landed in the backyard of a residence. The plt received serious injuries & could not recall details of the accident. No preimpact part failure…Apr 28, 1984 · N1181D · DestroyedNTSB MKC84LA128Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Pocahontas, ARThe acft crashed after an engine failure during a swath run at an alt of 20 ft AGL. Examination of the engine revealed 3 dowel pins and 6 screws which hold the starter drive gear and the accessory drive gear had sheared. Metallurgical exam revealed that dowel…Apr 24, 1984 · N9740C · DestroyedNTSB SEA84LA093Accident · No injuriesLimited investigationFinal reportPiper PA-25-235D · Heppner, ORThe plt reported that he was making a turn below the lee side of a ridge line at an alt of about 30 ft AGL. The acft reportedly encountered a downdraft & settled into the ground. During this occurrence, the landing gear collapsed, but no other major damage…Apr 22, 1984 · N9866P · DestroyedNTSB LAX84FU026Accident · 1 fatalFinal reportTeratorn Tierra II · Chico, CAThe ultralight was being test flown after alterations to the acft & its flight control system. The plt put the acft through some maneuvers and during one of them, described by witnesses as a chandelle, the acft nosed down & crashed intothe ground. The acft…Apr 22, 1984 · UNREG · DestroyedNTSB FTW84LA208Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Mullin, TXThe acft was observed by witnesses to have been flying very low, paralleling highway 84. A set of railroad tracks parallel the highway. Between the rr tracks and hwy is a power line. The witnesses saw the left wing contact the pwr line and the acft roll to…Apr 22, 1984 · N5454J · DestroyedNTSB FTW84FA206Accident · 2 fatalField investigationFinal reportNorth American AT-6D · Cypress, TXThe acft crashed while spinning after only a few minutes flt. The acft had just been flown by another plt for aprx 20 minutes just prior to the accident flt. This plt/owner said the acft operated in a trouble free manner. During the accident flt the plt made…Apr 21, 1984 · N10605 · DestroyedNTSB CHI84LA157Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Morrow, OHAbout 10 min. After takeoff on an aerial application flt the acft's eng lost pwr. The plt made a forced landing in a corn field & during rollout collided with a tree. According to the plt, the acft's eng blew its right rear cylinder because its hold down…Apr 20, 1984 · N6733Z · Substantial damageNTSB MIA84LA142Accident · No injuriesLimited investigationFinal reportGulfstream-Schweizer G-164B · Arecibo, PRDuring a swath run over a rice field, the plt noted a partial loss of power & a rapid deceleration of the acft. As he looked in the cockpit momentarily, the acft settled & the main gear hit a levi & separated. The plt then pulled up, turned to the left & made…Apr 17, 1984 · N8232K · Substantial damageNTSB LAX84FA256Accident · No injuriesField investigationFinal reportCessna L-19E · Ontario, CAThe plt stated that during descent he used 'left wing down, nose yawed right, slipping.' The fuel selector was positioned to the left fuel tank. A thousand flt slip the acft engine lost power. During the emergency corrective actionthe plt did not use the…Apr 16, 1984 · N4431D · DestroyedNTSB MIA84FA139Accident · 2 fatalField investigationFinal reportRockwell 114A · Key West, FLThe acft took off from rwy 27. Several witnesses stated the acft appeared unusually slow during the initial climb. The plt reported to the tower he had a problem & was going to 'come around.' The acft entered a right turn and appeared to stop climbing at 200…Apr 14, 1984 · N5942N · DestroyedNTSB LAX84FA255Accident · 1 fatalField investigationFinal reportFolke Wulf 1903A · Livermore, CAThe acft crashed after stalling during the initial climb after takeoff. The plt had called on the radio to say he was 'going to come back around.' When asked by the tower if he wwas declaring an emergency he did not answer. The acft reportedly was making a…Apr 14, 1984 · N190W · DestroyedNTSB LAX84LA254Accident · Serious injuriesLimited investigationFinal reportBoeing A75N1 · Scaggs Island, CADuring a local flt, the acft crashed on the side of a levee while maneuvering. Both plts were seriously injured & neither of them could recall details of the flt. An exam of the crash site revealed the plane was traveling nearly parallel with the levee when…Apr 13, 1984 · N3387 · Substantial damageNTSB MIA84LA134Accident · No injuriesLimited investigationFinal reportBell 47D1 · Berlin, GAThe plt collided with power lines as he turned to fly back to reload the acft. The plt made a statement that he did not see the wires in the trees. The plt did not file an accident report.Apr 12, 1984 · N586T · DestroyedNTSB MIA84FU004Accident · Serious injuriesFinal reportUnknown Easy Riser · Snead, FLThe ultralight collided with a high tension wire and crashed. The plt said he made a low pass to look at an auto and didnot see the wire in time to avoid the collision.Apr 12, 1984 · UNREG · Substantial damageNTSB FTW84LA195Accident · No injuriesLimited investigationFinal reportCessna 150 · Papalote, TXThe acft collided with a powerline while making a low pass over a local residence during a solo training flt. The plts recommendation for prevention is to 'use common sense.'Apr 11, 1984 · N19557 · Substantial damageNTSB FTW84LA194Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Beaumont, TXThe acft stalled during a turn around between swath runs. The pilot stated that he was unable to recover because there was not sufficient alt.Apr 11, 1984 · N9978 · DestroyedNTSB CHI84LA152Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Hoffman Estates, ILThe acft nosed over in a plowed field after the plt made an off-arpt landing. The plt said he was practicing turns around a point when he noticed a loss of alt and a sputtering of the engine. Since he was low he decided to land. (Therewas a sod strip 1/2 mile…Apr 11, 1984 · N8400B · Substantial damageNTSB FTW84LA192Accident · No injuriesLimited investigationFinal reportRockwell A-9B · Lamont, OKThe plt reported that between swath runs, his attention was directed to swath marks on the ground, then he tried to determine how much chemical was remaining in the hopper. At about 100 ft AGL, while in a 50 deg left bank, he heard 'the eng slow down' & felt…Apr 6, 1984 · N7776V · Substantial damageNTSB ATL84LA138Accident · No injuriesLimited investigationFinal reportRobinson R22A · Woodbridge, VAThe CFI stated that while hovering with a prospective student pilot using the cyclic control, the student pushed rapidlyforward on the cyclic control. The instructor pilot (CFI) attempted to regain control but the acft struck a tree and crashed.Apr 3, 1984 · N8415X · Substantial damageNTSB MIA84LA127Accident · No injuriesLimited investigationFinal reportBucker Flugzeugbau Jungmann · St. Augustine, FLThe plts of a Bucker jungmann, N1947G, & a pitts S-2B, N5302M, were practicing for an airshow. They began a maneuver called a 'mirror fly-by' in which the Bucker was rolled upside down & the pitts was flown underneath it. Due to the air flow over the wings…Apr 2, 1984 · N1947G · 2 aircraft · Minor damageNTSB DEN84LA120Accident · Serious injuriesLimited investigationFinal reportGulfstream 500 Commander · Los Lunas, NMA non-rated person stole the aerocommander, added 10 gallons of fuel to the empty tanks took off and both engines failed. The acft landed on hwy 85, the gear collapsed on landing and the acft came to rest in a ditch. Post accident investigation revealed only…Mar 30, 1984 · N3274Q · Substantial damageNTSB ANC84LA049Accident · Serious injuriesLimited investigationFinal reportCessna 206 · Mcgrath, AKAccording to the plt, he flew over a frozen lake, then encountered reduced visibility down to about 1/8 mi. He made a 180 deg turn, but lost all referecne to the terrain during the turn. Shortly after completing the turn, he was proceeding eastbound & was…Mar 29, 1984 · N756XB · DestroyedNTSB CHI84FA142Accident · 3 fatalField investigationFinal reportCessna 175 · Portage, MIDuring a return flt to traverse city, MI, the acft was observed flying at 'tree top' & 'roof height'. In the vicinity of the crash site, the acft was observed maneuvering. It entered a dive a tree top level, then made a sweeping 270 deg turn to about 500 ft…Mar 27, 1984 · N6733E · DestroyedNTSB CHI84LU002Accident · Serious injuriesFinal reportBirdman Enterprises Chinook · Mecosta, MIThe acft stalled during a forced landing and the right wing struck the ground. The plt stated that on his first takeoff full power was not obtained and a turn of 180 degrees was initiated to return to the airstrip. The engine failed completely on downwind and…Mar 26, 1984 · UNREG · Substantial damageNTSB NYC84FA118Accident · 1 fatalField investigationFinal reportBellanca 7KCAB · E. Hanover, NJThe acft was observed as it made a low pass over the end of the rwy, then pull up in a roll and/or vertical maneuver. One witness said that on the downward side of the maneuver, the acft appeared to stall or shudder. Before recovering, the acft impacted in a…Mar 25, 1984 · N11678 · DestroyedNTSB LAX84FA227Accident · Serious injuriesField investigationFinal reportAero Commander A-98 · Woodbridge, CAThe plt said the acft stalled as he was performing a left climbing turn during aerial application. The acft spun down hitting some oak tree limbs on its way to the ground. The plt had applied all but 200 lbs of his 1450 pounds of ammoniumsulfate.Mar 23, 1984 · N7643V · DestroyedNTSB NYC84FA114Accident · 5 fatalField investigationFinal reportPiper PA-31-350 · Oneonta, NYThe acft crashed in a wooded area after the loss of eng power. The wx was VMC. The plt made a missed approach after trying to land on rwy at Oneonta, at 1838 hrs. Later the plt radioed that he was unable to 'pick up' the kring beacon. Boston center vectored…Mar 22, 1984 · N27886 · DestroyedNTSB CHI84LA133Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · St. Ignace, MIThe pilot initiated flight into adverse wx conditions in order to pick up a heart attack victim. The pilot encountered fog & in an attempt to return to his departure point, collided with the frozen lake.Mar 21, 1984 · N4343X · Substantial damage