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 MIA84FA116Accident · 2 fatalField investigationFinal reportAlleva Starduster SA300 · Lakeland, FLThe owner/builder of the acft & his wife were flying at aprx 800 ft AGL when the plane rolled to a near inverted attitude & entered a dive. Before entering the maneuver, the plt was observed waving to friends & acquaintances who resided in the area. Before…Mar 18, 1984 · N688 · DestroyedNTSB FTW84FA171Accident · 2 fatalField investigationFinal reportBellanca 8KCAB · Kiefer, OKThe acft was destroyed as it spun into the ground after having been observed doing aerobatics between 800 and 1500 AGL. The maneuvers included barrel rolls and hammerhead stalls. The last maneuver ended in a spin that was said to last ABOUT5 turns before…Mar 17, 1984 · N5502V · DestroyedNTSB MIA84FA112Accident · 1 fatalField investigationFinal reportSwanson/Bensen B-8M · Dunnellon, FLThe student plt was told by the owner of the acft to only taxi the acft & not to fly it. During the 6th taxi maneuver it became airborne. It climbed to about 200 ft AGL where the plt made a 180 deg turn, followed by a 90 deg turn, followed by another 180 deg…Mar 16, 1984 · N8067W · Substantial damageNTSB LAX84FA220Accident · 2 fatalField investigationFinal reportNorth American T-28B · Rialto, CAPlt was authorized by acft owner to test fly the acft around the traffic pattern with a local FBO owner on board. Plt made 3 flts, last of which culminated in the accident. On the first and third flts, unauthorized passengers were on board. FBO owner stated…Mar 16, 1984 · N14110 · DestroyedNTSB MIA84FA106Accident · Serious injuriesField investigationFinal reportSouthern Comfort · Lakeland, FLWhile performing aerobatics at an airshow, the fabric on top of the upper wing started separating from the wing. The plt continued flying the acft & tried to return to the arpt. However, when flt could not be maintained with full power, due to loss of…Mar 15, 1984 · N19FH · DestroyedNTSB SEA84LA066Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Forest Grove, ORThe plt reported that while hovering, during an external load operation, the eng lost power & blue smoke & flames exited the back of the helicopter. The helicopter then struck trees before coming to rest. During an investigation, the eng started normally &…Mar 12, 1984 · N62377 · Substantial damageNTSB LAX84FA215Accident · 2 fatalField investigationFinal reportCessna 150M · Clovis, CAThe plt had called his girlfriend to say he was going to fly over her house an that he wanted her to wave at him as he flew past. In flying low over her house the plt waved and yelled loud enough to be heard on the ground. A friend said that during a…Mar 12, 1984 · N66436 · DestroyedNTSB LAX84LA216Accident · Minor injuriesLimited investigationFinal reportBurkhart Grob G102 Astir CS · Marana, AZThe plt initially lined up for a straight-in approach to land, but on final approach, he decided to make a 360 deg turn to land in front of spectators who were along the beginning of the airstrip. As he was completing the turn to land, the left wing contacted…Mar 10, 1984 · N128SS · Substantial damageNTSB ATL84FMG01Accident · Serious injuriesFinal reportSchleicher KA6CR · Marion, NCThe plt attempted a 360 deg turn prior to landing, while at a low altitude and crashed after aprx 150 to 180 degs of the turn.Mar 10, 1984 · N4221G · Substantial damageNTSB NYC84LA105Accident · No injuriesLimited investigationFinal reportCessna 150K · Livermore, METhe student plt, practicing level flt and turns during a power off descent, advanced the throttle without engine response. There was no suitable landing area so the plt elected to stall the acft into the trees.Mar 8, 1984 · N5685G · Substantial damageNTSB ANC84LA041Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Mcgrath, AKThe pilot told flight service personnel that the aircraft struck the ground while circling. His passenger was attemptingto photograph something on the ground.Mar 8, 1984 · N56304 · Substantial damageNTSB LAX84FU025Accident · 1 fatalFinal reportWizard J-3BR503 · Lake Elsinore, CAThe acft collided with the ground in a past vertical inverted position. The wings failed in negative load after the plt lost control in pitch with the airspeed decreasing and stalled into a dive. The plt was on his first solo flt and his instructor was…Mar 7, 1984 · UNREG · DestroyedNTSB DEN84LA105Accident · No injuriesLimited investigationFinal reportCallair A · Tremonton, UTThe acft collided with a snow covered field while the plt was applying carbon black and fertilizer to induce snow melt. The overcast sky'gave a white-out effect on depth perception'. The collision with a rise in the field tore off the landing gear and the…Mar 6, 1984 · N8260H · Substantial damageNTSB MIA84LA096Accident · No injuriesLimited investigationFinal reportHeinemann Rotorway Executive · Ft. Lauderdale, FLThe commercial/atp plt was not rated for helicopters. He stated that 'while in flt position' to check the cyclic pressures, a strong gust of wind lifted the helicopter off the ground & rolled it over on its side. He believed that this would not have happened…Mar 4, 1984 · N44818 · DestroyedNTSB FTW84LA154Accident · Serious injuriesLimited investigationFinal reportBell 206L-1 · Intracstl City, LAThe helicopter collided with marsh terrain while spotting dead alligators. The plt does not remember events of the accident. The helicopter operator stated the helicopter appeared to have impacted at a low airspeed at a normal RPM. The emergemcy floats were…Mar 3, 1984 · N27798 · Substantial damageNTSB DEN84FTM01Accident · 1 fatalFinal reportKeith A Smith KR-2 · Salt Lake City, UTThe acft collided with a mountain ridge in a flat'pancake'attitude,no evidence of foward motion was apparent and all thewreckage was confined to the immediate area. The wooden prop was intact with the exception of 2 inches missing from the end of one blade,…Feb 26, 1984 · N54KS · DestroyedNTSB CHI84FA119Accident · 1 fatalField investigationFinal reportCessna 152-II · Manhattan, ILThe acft was observed entering a spin from a nose high attitude from which it failed to recover. The student pilot was seen waving to his family as the acft circled in the vicinity of his parent's home. There was no evidence of preimpact failure or…Feb 26, 1984 · N4972H · DestroyedNTSB ATL84FLT03Accident · Serious injuriesFinal reportCessna A-188B · Crawford, MSThe acft stalled during an aerial application turn-around. Before recovery from the stall, the acft collided with trees, a power line and the ground. No evidence of a preimpact malfunction was found or reported.Feb 25, 1984 · N731RJ · DestroyedNTSB SEA84FA060Accident · 3 fatalField investigationFinal reportCessna 172N · Kent, WAAt about 1345 PST, the plt of a Cessna 172N, N4603F, departed crest airpark, Kent, WA, on a local pleasure flt. Aprx 5 min later, the plt & 1 passenger of a float equipped Cessna 180, N4908A, took off from lake meridian, Kent, WA, & were also on a local…Feb 24, 1984 · N4603F · 2 aircraft · DestroyedNTSB LAX84LA194Accident · No injuriesLimited investigationFinal reportBell 47-G4A · Dixon, CAThe acft crashed during a forced landing after the engine quit. The plt stated that, 'three minutes into the crop dusting mission the engine quit and he suspected fuel mismanagement.'Feb 24, 1984 · N9017N · DestroyedNTSB MKC84FU001Accident · Serious injuriesFinal reportPioneer Flightstar · Blytheville, ARThe acft spun into the ground from about 500 ft AGL. The vehicle had been observed by witnesses to be in slow flt makingturns to the right. After 180 degrees of turn, the nose pitched down to about 60 degrees and the left wing went down to about 75 degrees of…Feb 23, 1984 · UNREG · Substantial damageNTSB FTW84LU004Accident · Serious injuriesFinal reportVampire Satalar · Pearland, TXThe acft departed the Pearland arpt, climbed to about 150 feet AGL, entered a left turn, stalled and crashed through themetal roof of a hangar. The plt stated he was eager to get airborne and fly the traffic pattern before sundown. He stated that he climbed…Feb 22, 1984 · UNREG · DestroyedNTSB FTW84LA145Accident · 1 fatalLimited investigationFinal reportGrumman G-164A · Abbeville, LAThe plt was employed as a professional corporate & charter plt; however, he had not flown agricultural acft in several years. He had receently purchased half interest in the air sevice & was on his 1st refresher flt since then. While the plt was practicing a…Feb 22, 1984 · N9728 · DestroyedNTSB FTW84LA144Accident · Minor injuriesLimited investigationFinal reportBell 47G4A · Refugio, TXThe helicopter was being used to herd cattle in a heavily wooded/brushy area. The plt reported he was in a hover maneuver at 50-60 ft AGL when he heard a loud sound from the rear of the helicopter. It immediately pitched nose down & started to rotate to the…Feb 21, 1984 · N7956J · DestroyedNTSB DEN84FA095Accident · 2 fatalField investigationFinal reportCessna 152 · Franktown, COThe acft was observed circling for about 10 minutes. Afterwards, pwr decreased and the acft descended. During descent an occasional burst of pwr was heard. When the acft neared the ground it nosed up & down along with an increase in eng pwr. Witnesses stated…Feb 20, 1984 · N89182 · DestroyedNTSB FTW84LA140Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Ada, OKThe acft collided with powerlines during a low level flt along the canadian river and fell into the shallow water. The plt who is a fireman said he had descended to observe a grass fire burning along side the river.Feb 19, 1984 · N6558M · DestroyedNTSB MIA84FA082Accident · 2 fatalField investigationFinal reportCessna 152 · Cooper City, FLWitnesses saw the acft in a spin prior to impact. They stated that the plt was seen doing practice airwork in the area.Feb 17, 1984 · N5408M · DestroyedNTSB FTW84LA138Accident · Minor injuriesLimited investigationFinal reportPiper PA-31 · Brownsville, TXThe plt was maneuvering for an ILS approach when he collided with the ground. He said he was distracted by the swinging CDI and was below the glide slope. He said he started to add power for a missed approach and the acft impacted the ground. A passenger said…Feb 17, 1984 · N7415L · Substantial damageNTSB ATL84FA100Accident · 1 fatalField investigationFinal reportBell 47GL · Cullman, ALThe plt had just completed an eng overhaul & was test flying the helicopter. While maneuvering at aprx 100 ft AGL, the eng lost power & the plt initiated an autorotation. During the landing, the helicopter impacted hard on rising terrain, rolled onto its side…Feb 17, 1984 · N12KH · DestroyedNTSB MIA84FA081Accident · Serious injuriesField investigationFinal reportBell 47-G · Cedar Key, FLThe helicopter turned and descended from an out of ground effect hover. The rpms dropped and the acft hit the ground hard.Feb 16, 1984 · N6357 · Substantial damageNTSB FTW84LA137Accident · 1 fatalLimited investigationFinal reportPiper PA-25-150 · Altus, OKThe acft crashed in a wheat field that was being spray, then was destoyed by a post crash fire. According to the operator, the plt was at the end of a swath run when he glanced into the cockpit to visually check how much chemical was remaining in the hopper.…Feb 16, 1984 · N6090Z · DestroyedNTSB MIA84LA080Accident · No injuriesLimited investigationFinal reportCessna T-188 · Arcadia, FLThe plt was maneuvering at low alt and low airspeed during aerial application. During a steep (80 bank) the acft stalledand crashed.Feb 15, 1984 · N9932J · Substantial damageNTSB MIA84FA078Accident · Serious injuriesField investigationFinal reportHiller UH-12E · Waldo, FLThe acft was being used to dispense aerial incendiary devices (aids) to control forest burning. The aids were 1.25 inch diameter polystyrene balls containing potassium permanganate. They were injected with ethylene glycol prior to being dropped out of the…Feb 15, 1984 · N19MP · DestroyedNTSB LAX84FA180Accident · 1 fatalField investigationFinal reportMaupin WOODSTOCK-I · California City, CADuring flt, the glider sustained an in-flt failure of both wings, then entered an uncontrolled descent & crashed. An exam of the wreckage revealed no preexisting structural problems. The glider was equipped with a recording barograph. A barograph trace showed…Feb 13, 1984 · N71W · DestroyedNTSB FTW84LA136Accident · Serious injuriesLimited investigationFinal reportSikorsky S-58E · Morgan City, LAThe helicopter was hovering above trees at about 100 ft AGL when the tail rotor chip detector lgt flickered svrl times, then illuminated steadily. This was followed by a loud grinding noise from the tail area & the acft yawed to the right. The acft entered an…Feb 13, 1984 · N70709 · Substantial damageNTSB ATL84FA099Accident · 1 fatalField investigationFinal reportPiper PA-30-160 · Massies Mill, VAWhile en route, the plt was progressing northbound when he contacted the Washington fss at 2134 EST for updated wx info. At that time, he described his position as north of lynchburg, VA. The fss briefer noted that his voice was normal, his manner was calm &…Feb 13, 1984 · N8742Y · DestroyedNTSB LAX84LA168Accident · Serious injuriesLimited investigationFinal reportMoseley/Scorpion 133 · Phoenix, AZThe plt stated that he intended only to grt the helicopter 'in a light position to check for balance and cyclic position. He further stated that a gust of wind caused a total lift off and he over-controlled the acft which rolled andcrashed sideways in a…Feb 8, 1984 · N4661U · Substantial damageNTSB FTW84LA130Accident · Minor injuriesLimited investigationFinal reportBell 47G-2A · Benavides, TXThe plt was herding cattle when an eng failure occurred over a small group of trees. The plt auto-rotated and the acft landed hard.Feb 8, 1984 · N8478E · Substantial damageNTSB FTW84FA127Accident · 2 fatalField investigationFinal reportAmerican AA-1A · Lampasas, TXThe acft descended into the ground along the east bank of the Colorado river at about a 45 deg angle to the horizon in a wings level attitude. There were no witnesses to the accident. Investigation revealed that the plt was planning a springtime canoe trip…Feb 6, 1984 · N9480L · DestroyedNTSB DEN84LA083Accident · Minor injuriesLimited investigationFinal reportMaule M-4S · Three Forks, MTThe plt was flying low toward rising terrain. The airspeed slowed to the point that the point that the acft mushed into the ground and cartwheeled. The plt said he had not removed all the frost on the wings prior to flt and he thought the stall speed was…Feb 5, 1984 · N9832M · Substantial damageNTSB MIA84LA071Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Naranjito, PRThe acft collided with hilly terrain during a low pass. The plt was preparing to land at a nearby private airstrip.Feb 3, 1984 · N15MM · Substantial damageNTSB DEN84FA081Accident · 1 fatalField investigationFinal reportEnstrom F-28C · Chester, MTAccording to a company employee, the plt made a radio call from a remote mountain site where the plt was doing some workon a transmitter tower & stated that he was taking off, & if the employee did not hear from him in an hour to come look for him. The…Feb 1, 1984 · N776FS · DestroyedNTSB LAX84LA160Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Santa Nella, CADuring a low level ag turn, the acft's left wing impacted an 8-FT high stand pipe. The acft then cartwheeled & crashed. A few weeks before the accident, the plt had personally inspected the field. However, just days before the accident, the standpipe had been…Jan 30, 1984 · N731WR · Substantial damageNTSB NYC84FA085Accident · 4 fatalField investigationFinal reportPiper PA-28R-200 · Templeton, MAThe acft collided with trees on unlgtd terrain at ngt after making a low pass at aprx 60 ft AGL with the gear extended. Witnesses reported that the acft's clearance lights were not operating until the rwy lights were turned on, then they observed the acft's…Jan 29, 1984 · N55495 · DestroyedNTSB DEN84FA073Accident · Serious injuriesField investigationFinal reportBell 206L-1 · Huntington, UTWhile in a stabilized, out-of-ground-effect hover, at about 300 feet AGL, the helicopter started an uncontrollable right turn. The plt stated that using full left peddle had no effect on stopping the spin. At the onset of the spin, the occupants of the acft…Jan 22, 1984 · N500CN · Substantial damageNTSB SEA84LA040Accident · No injuriesLimited investigationFinal reportBeech A35 · Renton, WAThe acft was damaged during a forced landing after the engine quit after takeoff. The plt said he noticed the oil pressure drop to zero a few minutes after takeoff and was turning back to the arpt when the engine quit. He did not lower the landing gear since…Jan 21, 1984 · N560B · Substantial damageNTSB LAX84LA150Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Mendota, CAThe acft collided with a tractor while the plt was making a low pass over some workers in a tomato field. The plt said he was returning the rented acft when he decided to make a final check on the field workers before departing for the day. No evidence of any…Jan 20, 1984 · N2492P · DestroyedNTSB MIA84LA060Accident · Minor injuriesLimited investigationFinal reportGrumman AG-CAT · Homestead, FLThe acft crashed during a forced landing after the engine lost power. Investigation revealed that that # 8 cylinder failed. The original cracking was determined to be from fatigue.Jan 16, 1984 · N6736Q · DestroyedNTSB MIA84FA058Accident · 1 fatalField investigationFinal reportHiller UH-12C · San Juan, PRA performer fell from a trapeze rigged below the helicopter while it was hovering at about 150 ft AGL. The FAA had not authorized the modification to the acft. The plt was not certified for external load operations. The performer reportedly had not done this…Jan 12, 1984 · N5317V · No damageNTSB CHI84LA083Accident · No injuriesLimited investigationFinal reportCessna 150M · Pittsboro, INThe acft made a forced landing on a rough, snow covered field after the engine failed. Post accident investigation showed thet the exhaust valve on #1 cylinder punctured the cylinder.Jan 8, 1984 · N6340B · Substantial damage