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 LAX86FA004Accident · 4 fatalField investigationFinal reportCessna T210L · Lebec, CAThe acft contacted trees and the terrain in an uncontrolled descent and was destroyed by impact and an ensuing fire. The acft's left elevator was not located during the post accident inspection. Witnesses reported seeing the acft flying low (50 ft AGL) and…Oct 6, 1985 · N29158 · DestroyedNTSB LAX86FA002Accident · 2 fatalField investigationFinal reportPiper PA-38-112 · Paradise, CAAfter takeoff, for an aflight orentation, the high time (over 2 4000 flt hours) pilot descended to an altitude of approx. 300 over a lake. The pilot was then flying up a twisting arm of the lake, in mountainous terrain into unmarked electrical transmission…Oct 6, 1985 · N24126 · DestroyedNTSB MIA86LA004Accident · No injuriesLimited investigationFinal reportBell 206L · Islamorada, FLAircraft was ditched in the atlantic ocean after loss of engine power. Post crash inspection of the engine after recovery from the ocean revealed thje pc or compressor pressure air line had failed at a 'b' nut at the compressor schroll. With this line failed…Oct 5, 1985 · N60C · Substantial damageNTSB ANC86LA001Accident · Serious injuriesLimited investigationFinal reportChampion Citabria 7GCBC · Ptarmigan Pass, AKThe pilot-in-command stated that just after departure. He spotted a moose and made a low circle above the moose. He leveled off and attempted to pull the aircraft up. The nose of the aircraft pitched down and the airplane crashed to the ground.Oct 5, 1985 · N90921 · Substantial damageNTSB DEN86FA002Accident · 2 fatalField investigationFinal reportPiper PA-18-150 · Chamberlain, SDThe plt and his passenger friend were looking for stray cattle when aprx at 142 ft above the ground their acft struck an antennae mounted on a microwave tower. The acft descended and was destroyed on ground impact.Oct 3, 1985 · N40359 · DestroyedNTSB SEA85FA228Accident · 2 fatalField investigationFinal reportTeratorn Tierra II · Post Falls, IDThe acft contacted the terrain in an uncontrolled descent following an inflt separation of the left wing. A witness stated the left wing separated as the acft was being maneuvered in a race track pattern using bank angles of 45 degs. The wife of the acft…Sep 29, 1985 · UNREG · DestroyedNTSB NYC85LA250Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Galway, NYStudent plt was practicing maneuvers at 3000 ft when acft eng failed. The plt made a forced landing in a field. The tallgrass in field caused the landing gear to fail and substantially damaged the acft during the landing roll. NTSB metallurgist report shows…Sep 29, 1985 · N6120M · Substantial damageNTSB FTW85LA359Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-R · Mount Vernon, TXThe pilot reported he ran out of gas maneuvering under an overcast to find a suitable landing site. He had attempted to circumnavigate a large area of severe weather but exhausted his fuel supply. He stated that the engine quit and he stalled the aircraft at…Sep 29, 1985 · N7554J · Substantial damageNTSB LAX85FA402Accident · 1 fatalField investigationFinal reportAerospatiale AS350D · Kula, HIThe helicopter collided with terrain while on a sightseeing tour. The plt stated that the helicopter lost alt as he attempted to cross power lines. Directional control was lost during the ensuing down wind emergency landing. The helicopter contacted the…Sep 26, 1985 · N4268V · Substantial damageNTSB NYC85LA248Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-1B · Hamburg, NYThe plt stated that he started a maneuver at 2700 ft. the maneuver was a dive after reducing pwr followed by a climb with a left turn at the top followed by a descending left turn. The turn 'at the top' was uncoordinated and g forces occurred. Throttle…Sep 25, 1985 · N2640R · Substantial damageNTSB CHI85FA383Accident · 1 fatalField investigationFinal reportCessna 150L · Hillsboro, OHThe acft was being flown by a plt who's company takes low alt photos of farms for later resale. This is accomplished with hand-held 35MM cameras from the right seat. According to the single witness to the accident, the acft was first sighted flying 'low and…Sep 22, 1985 · N21903 · DestroyedNTSB NYC85FHJ06Accident · Serious injuriesFinal reportRobinson R-22 · Ronkonkoma, NYWhile hovering student pilot applied aft cyclic and the flt instructor could not regain control before tail rotor struck the taxiway. Helicopter rotated violently and rolled over and to rest on the skids. The helicopter was destroyed.Sep 19, 1985 · N90716 · DestroyedNTSB SEA85FA217Accident · 1 fatalField investigationFinal reportErcoupe 415-C · Orchards, WAThe pvt plt was observed executing a wings level pull-up from a dive during which, the witness reported, the wing tips began fluttering. Immediately thereafter, both wings separated in positive overload. Visual meteorological conditions existed in the area of…Sep 18, 1985 · N93848 · DestroyedNTSB CHI85FER02Accident · No injuriesFinal reportGrumman 164A · Becker, MNThe plt reported the eng pwr dropped from 2000 to 1550 RPM during the aerial application flt. The plt increased throttleand advanced the prop with no increase in pwr. The acft then settled to ground impact and nosed over. Post accident inspection disclosed…Sep 18, 1985 · N48405 · Substantial damageNTSB LAX85LA393Accident · 1 fatalLimited investigationFinal reportPitts S-2A · Carlsbad, CAAfter completing an upright spin over the pacific ocean during the filming of a movie viewed from the spinning acft, the plt climbed his acft back to the entry alt and entered a flat inverted spin. The acft was observed to spin through its recovery alt at…Sep 17, 1985 · N13AS · DestroyedNTSB DEN85FA241Accident · 1 fatalField investigationFinal reportAerospatiale SA315B · Craig, COThe helicopter was long-lining a 1280-pound air compressor to an 8500-foot MSL mountain drilling site. Witnesses heard a squealing sound and bang. They observed gray-white smoke and orange-blue flame emitting from the exhaust. The plt released the load and…Sep 14, 1985 · N3836E · DestroyedNTSB ATL85FA276Accident · 1 fatalField investigationFinal reportLaux Pitts S-1S · Paducah, KYThe aircraft was observed in the local area for several minutes. It was perfoming aerobatic maneuvers. One witness reported that it was lower than it usually was when it was perfoming these maneuvers. It was observed to do an inside loop, roll inverted and…Sep 14, 1985 · N30BL · DestroyedNTSB FTW85LA348Accident · 1 fatalLimited investigationFinal reportCessna A185F · Catahoula, LAThe plt took off from a bayou with inadequate distance to climb above the trees growing along each side before the bayou made an aprx 120-DEG right turn. In order to avoid collision with the trees the plt entered a steep banked right turn to follow the bayou.…Sep 13, 1985 · N333WL · DestroyedNTSB MKC85FA213Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Hoskins, NEThis accident occurred on a telephone cable patrl flt. The acft would normally fly along the route of the buried cable at 200 to 300 ft AGL. When construction activity was sighted the plt would first record the sighting on a portable tape recorder and then…Sep 11, 1985 · N15970 · DestroyedNTSB MIA85LKG06Accident · Serious injuriesFinal reportCessna A188B · Bascom, FLThe acft collided with a pecan tree during a spray operation the plt said he should have been more attentive to the operation of the acft and the environment.Sep 10, 1985 · N9742G · DestroyedNTSB ATL85FA272Accident · Serious injuriesField investigationFinal reportMBB BK-117A-1 · Aiken, SCPlt was maneuvering helicopter at low alt and into rising terrain. On 3rd right turn racetrack pattern, witnesses observed acft descend slightly, roll into a 45 deg or greater bank and contact trees. The acft started a yawing rotation to the right and…Sep 9, 1985 · N117SR · Substantial damageNTSB CHI85FEV03Accident · 1 fatalFinal reportCessna 172 · Sweetwater, ILThe acft was observed flying at low alt parallel to a hiway before colliding with a tree before impacting the ground. The plts wife said that the plt had been under extreme stress for a few months and had not been to bed for 2 days preceding the accident. She…Sep 8, 1985 · N6236E · DestroyedNTSB ANC85LAG03Accident · No injuriesFinal reportTaylorcraft 19 · Anchorage, AKThe pilot stated that after he recovered from the spiral theaircraft struck the tree tops. At the time of the accident the weather was below VFR.Sep 8, 1985 · N3588T · Substantial damageNTSB SEA85FA208Accident · 1 fatalField investigationFinal reportPiper PA-25-235 · Wenatchee, WAAfter two application runs, plt apparently attempted to shorten the race-track pattern by initiating the inbound turn into a canyon. Acft was observed to climb clear of the canyon wall near completion of turn, but load was jettisoned at this point and the…Sep 7, 1985 · N7340Z · DestroyedNTSB ATL85LA269Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Tunica, MSThe plt stated that during aerial application maneuver he allowed the airspeed to get too low and the acft settled into a soy bean field. The left wing contacted the crop and the acft cartwheeled.Sep 6, 1985 · N9893 · Substantial damageNTSB ATL85FLT10Accident · Serious injuriesFinal reportAeronca 7AC · Mcewen, TNThe plt stated the acft stalled during a turn at an alt between 200 and 300 ft AGL. Recovery was not accomplished prior to the acft impacting the terrain.Sep 6, 1985 · N83053 · DestroyedNTSB DEN85LTG08Accident · Minor injuriesFinal reportPiper PA-28-140 · Underwood, NDThe acft nosed over during a forced landing following a loss of pwr. The plt stated he was practicing slow flt on the return flt from picking the acft up after an annual inspection. As the acft slowed to 90 mph during slow flt, the plt attempted to increase…Sep 5, 1985 · N8864N · Substantial damageNTSB DEN85FA236Accident · 2 fatalField investigationFinal reportPiper PA-28RT-201T · Saint Mary, MTPlt received wx update enroute to kalispell, MT. He attempted to navigate through the glacier national park, following the 'going-to-the-sun' highway. The wx along the plt's route of flt included low cloud ceiling, limited visibility and mountain obscurement.…Sep 5, 1985 · CGTGV · DestroyedNTSB ATL85LKG09Accident · No injuriesFinal reportGrumman G-164 · Opp, ALThe plt reported that during a pull-up and turnaround at the end of a swath run, the eng gave off smoke and lost pwr. The plt dumped the chemical load and performed a forced landing in a fld which contained 6 to 8 ft tall vegetation. The acft travelled aprx…Sep 5, 1985 · N598Y · Substantial damageNTSB ANC85LAA02Accident · No injuriesFinal reportPiper PA-18 · Fairbanks, AKThe plt stated that while making a loss pass over a gravel area, he experienced violent sinking due to wind shear. The plt reported the winds were from 240 degs at 25 KTS gusting to 35 KTS.Sep 5, 1985 · N3839Z · DestroyedNTSB ANC85LAG02Accident · Minor injuriesFinal reportPiper PA-18 · Kodiak, AKThe plt stated that he entered a small canyon with a ridge line at the end which he would have to cross. As the plt continued into the canyon he had insufficient alt to clear the ridge. The acft stalled and struck the side of the mountian ridge.Sep 4, 1985 · N9919D · Substantial damageNTSB MKC85LA204Accident · Minor injuriesLimited investigationFinal reportGrumman AA5 · Boone, IAAfter departing laporte city airport the plt of the acft proceeded to his destination airport despite deteriorating weather conditions at this destination. The plt stated he should not have proceeded into poor weather conditions. Weather conditions at the…Sep 2, 1985 · N16LB · Substantial damageNTSB LAX85LA394Accident · No injuriesLimited investigationFinal reportGlasflugel ST Liebelle 201B · California City, CAThe glider landed off the arpt on a road and groundlooped after colliding with shrubbery. The plt complained of encountering a downdraft during the flt.Sep 2, 1985 · N711DP · Substantial damageNTSB MKC85LA201Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Weskan, KSThe plt rptd a high eng oil temperature & low oil pressure while maneuvering over a siesmic operation site in west Kansas. The acft was substantially damaged when it contacted a ditch during a forced landing. Post accident inspection failed to disclose any…Aug 31, 1985 · N6903P · Substantial damageNTSB MKC85FA199Accident · 1 fatalField investigationFinal reportAeronca 7AC · Bridgeton, MOA witness observed the acft flying in an easterly direction at an alt of 200 to 300 ft AGL. The acft then made a 180 deg turn to a westerly heading. After flying a distance of aprx 2000 ft, the acft entered a left turn and dove into a squash fld. Post…Aug 31, 1985 · N2560E · DestroyedNTSB LAX85FA376Accident · Serious injuriesField investigationFinal reportCessna T303 · Simi Valley, CAThe acft collided with trees during a forced landing following a loss of pwr. The student plt stated the flt was normal until a 'violent right yaw' developed when the trottles were advanced to recover from a practice stall. As the CFI took over the controls…Aug 31, 1985 · N6490V · DestroyedNTSB FTW85LRA04Accident · Minor injuriesFinal reportRockwell S2R-600 · Rosharon, TXThe plt reported the acft contacted the ground after the left boom caught weeds during a spray run.Aug 30, 1985 · N4012P · Substantial damageNTSB FTW85LA340Accident · 1 fatalLimited investigationFinal reportCessna L-19E · Palo Pinto, TXThe acft was reported by witnesses to have been flying very low over a lake just prior to accident. The acft collided with pwr lines after passing over a dam and was destroyed on ground impact. The plt reported a loss pwr was experienced. The eng was test run…Aug 30, 1985 · N3255X · DestroyedNTSB CHI85LA363Accident · No injuriesLimited investigationFinal reportCallair A-9 · Hollandale, MNDuring a maneuvering turn while crop dusting the pilot experienced a muffler failure and engine fire. He landed successfully and abandoned the aircraft. Subsequent investigation revealed that the bracket that holds the muffler/ exhaust pipe to the aircraft…Aug 30, 1985 · N8273H · Substantial damageNTSB ATL85FA278Accident · 1 fatalField investigationFinal reportBellanca 8KCAB · Proctor, WVThe acft was artd msg and was the object of a search from 9-1-85 to 9-12-85. Acft found in remote area of mtns and dense woods by man on foot hunting ginseng on 9-16-85.ND witnesses found. Residents in area reported rain all day on 8-30-85 and it was heavy at…Aug 30, 1985 · N4195Y · Substantial damageNTSB FTW85FQG03Accident · 1 fatalFinal reportPiper PA-25-235 · Morton, TXAfter the plt completed a swath run, the acft entered a rgt climbing maneuver, then rolled wings level. After that, it reportedly began an abrupt climb for aprx 50 to 60 ft, then nosed down & crashed in a steep descent. After impact, the acft was destroyed by…Aug 29, 1985 · N4708Y · DestroyedNTSB CHI85LA360Accident · No injuriesLimited investigationFinal reportSchweizer G164A "450" · Constantine, MIThe acft nosed over during a forced landing in a corn fld. The plt stated that at 30 ft AGL during his second swath run the eng backfired and lost pwr. He attempted to dump the load however, the acft continued to loose alt and the forced landing resulted.…Aug 29, 1985 · N8444K · Substantial damageNTSB FTW85LA336Accident · No injuriesLimited investigationFinal reportBeech A36 · Conroe, TXAcft was substantially damaged during an off-arpt emergency landing following an eng failure. During landing roll acft collided with a fence and the gear collapsed. Investigation revealed about 13 gallons of fuel in right fuel tank and none in the left tank.…Aug 28, 1985 · N6564D · Substantial damageNTSB FTW85FA335Accident · 2 fatalField investigationFinal reportNorth American British Harvard Mkii · Ada, OKTwo fully qualified single engine plts were in the acft at the time of the accidnet. The acft was observed making low passes near the airport after takeoff. One plt's mother lived near the accident site. The acft was in a steep banked right turn when the…Aug 28, 1985 · N711XX · DestroyedNTSB LAX85LA374Accident · No injuriesLimited investigationFinal reportAir Tractor AT301 · Williams Afb, AZAfter making his first swath run,during the hours of darkness,the pilot became disorented and flew into an area with tall electrical transmission lines. He descended into trees beneath the lines in his attempt to miss them.Aug 27, 1985 · N3168U · Substantial damageNTSB MIA85FA239Accident · 2 fatalField investigationFinal reportSilvaire Luscombe 8E · Ocala, FLThe acft was observed to take off, make a steep turn, a few seconds later, at an altitude of about 200 ft AGL, enter another steep turn and spin into the ground. Witnesses report that the pilot exhibited lack of control coordination while performing turns in…Aug 26, 1985 · N47BM · DestroyedNTSB LAX85FJA06Accident · 1 fatalFinal reportEmroth Emair MA-1B · Pahala, HIWitnesses reported seeing pieces of wood and fabric coming off the acft during it's second swath run. At the end of the run, the acft climbed abruptly to clear trees after which it entered an uncontrolled descent to ground impact. The acft was destroyed by…Aug 26, 1985 · N1012Y · DestroyedNTSB NYC85FA219Accident · 1 fatalField investigationFinal reportCessna 150L · Lewiston, NYWitnesses reported seeing the acft circling at low altitudes up to 30 minutes prior to the accident. One witness stated the plt appeared to be performing power stalls at an alt of aprx 500 ft AGL. The acft then entered a spin and descended to ground impact.…Aug 25, 1985 · N18717 · DestroyedNTSB CHI85FA357Accident · 2 fatalField investigationFinal reportPiper PA-28-235 · Worthington, MNThe acft had progreesed 16 miles on a 95 mile x-country flt when it was witnessed in low flt over a corn fld. The acft was about 200 ft AGL when it entered a descending right power on turn until ground impact. An autopsy report on the plt disclosed,…Aug 25, 1985 · N8571W · DestroyedNTSB ATL85LA259Accident · No injuriesLimited investigationFinal reportHughes 269C · Elizabethtown, KYAfter takeoff from off airport landing zone, the acft encountered heavy raninshowers and the plt attempted to return to the landing zone. Visibility was such that the plt was unable to see the ground and the tailrotor contacted a lake adjacent to the landing…Aug 25, 1985 · N9280F · Substantial damage