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 DEN88LA161Accident · No injuriesLimited investigationFinal reportPiper PA-36-285 · Buchanan, NDThe plt said he made several swath runs passing under a transmission line and over a power line that crossed the end of the fld being sprayed. He said as he passed under the transmission line during a run the vert stab collided with the line and was damaged.…Jul 18, 1988 · N9990P · Substantial damageNTSB CHI88DEV02Accident · No injuriesFinal reportGrumman G-164A · Cape Girardeau, ILThe plt was applying chemicals to a field with 3 radio transmission towers along one side. He rprtd that as he was finishing the field, he circled one of the towers, them made a final swath run across the end of the field. He stated that as he pulled up from…Jul 18, 1988 · N677U · Substantial damageNTSB LAX88LA260Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Agua Dulce, CAThe pilot attempted a takeoff from a 2,900 ft MSL elevation airport when the observed unofficial outside air temperature was a reported 105 degrees fahrenheit. Although no exact pressure altitude was available an approximate density altitude of 6,300 was…Jul 16, 1988 · N33043 · Substantial damageNTSB FTW88DRD14Accident · Serious injuriesFinal reportGrumman G-164A · Crowley, LAThe agricultural pilot was working in a field which had telephone lines at one end and power lines at the other. On his last run, as he started his pull up, the airplane struck the power lines at one end of the field. The airplane went through the power…Jul 16, 1988 · N8580H · DestroyedNTSB MKC88LA126Accident · No injuriesLimited investigationFinal reportRockwell S2R · England, ARThe plt said he had been flying under power lines during an aerial application operation, and while performing his downwind pass, an updraft caused him to collide with the bottom wires. He lost control of the aircraft and collided with the terrain.Jul 15, 1988 · N4186X · Substantial damageNTSB FTW88LA134Accident · No injuriesLimited investigationFinal reportBell 47G2 · Port O'Connor, TXThe pilot stated that he turned downwind during hover practice, allowed the main rotor RPM to decrease, and settled with power to a hard landing. The front portion of the skids impacted first and the main rotor blades struck the tail boom. The pilot was not…Jul 15, 1988 · N47WJ · Substantial damageNTSB ATL88DKG10Accident · No injuriesFinal reportCessna 188 · Douglas, GAJul 15, 1988 · N91217 · Substantial damageNTSB FTW88DRD13Accident · Serious injuriesFinal reportGrumman G-164A · Kinder, LAThe pilot was spraying a fungicide on the field and the owner of the field was flagging for him, on the top of a dike, on the west end of the field. During normal operation, the flagman stayed in position until the airplane was 300 feet away, at which time he…Jul 14, 1988 · N8512H · Minor damageNTSB SEA88LA129Accident · Serious injuriesLimited investigationFinal reportAerospatiale SA315B · Oakridge, ORWhile slinging a log the pilot allowed the log/sling line to contact a tree. The momentum of the log and helicopter bowed the tree over when the line contacted it. The pilot chose to release the log from the sling line rather than disengage the entire line…Jul 13, 1988 · N3128G · DestroyedNTSB LAX88FA254Accident · Serious injuriesField investigationFinal reportSikorsky S-58BT · Marina Del Rey, CAMismanagement of the fuel system by the pilot which resulted in fuel starvation and a duel engine flameout. Contributing to the accident was the pilot's lack of total experience in the Sikorsky S58T.Jul 13, 1988 · N94AH · Substantial damageNTSB DEN88FA212Accident · 2 fatalField investigationFinal reportPiper PA-22-150 · Kanosh, UTPlt obtained wx briefing and filed VFR flt plan from burley, ID, to chandler, AZ, with enroute refueling stop at fillmore, UT. Plt landed on dirt road at fillmore and taxiied acft to roadside truck stop. Acft serviced with auto gas. Acft departed fillmore but…Jul 13, 1988 · N3541Z · DestroyedNTSB SEA88LA128Accident · No injuriesLimited investigationFinal reportSchempp-Hirth Discus B · Minden, NVAcft were ascending in the same thermal during national soaring competition and collided in flight. N554T sustained loss of the horizontal tail in collision, followed by loss of control in flight. The pilot parachuted safely. N130JB sustained minor damage and…Jul 12, 1988 · N554T · 2 aircraft · DestroyedNTSB ATL88FA213Accident · Serious injuriesField investigationFinal reportBell TH-1L · Walterboro, SCThe military surplus helicopter experienced a 42 degree gear box failure while lifting a load of logs. The helicopter subsequently landed hard as the plt was attempting to autorotate to a ldg. Metallurgical examination of the gearbox revealed that a gear…Jul 12, 1988 · N465JR · Substantial damageNTSB FTW88DRD12Accident · No injuriesFinal reportTexas Helicopter M74C · Rayville, LAThe commercial pilot was spraying his cotton field with his own helicopter. The acft hit a tree during a right turning pull-up. The tail rotor blades were severed first then, during an uncontrolled right turn, the tailboom hit another tree. The main rotor…Jul 11, 1988 · N47345 · DestroyedNTSB CHI88DEX08Accident · No injuriesFinal reportContinental Copters Tomcat MK-6 · Straughn, INAerial application helicopter struck power lines in field on first swath run. This was the first time the pilot had sprayed this field. Prior to spraying the field he questioned the farmer regarding power lines or other obstructions. The farmer replied that…Jul 11, 1988 · N9093T · Substantial damageNTSB CHI88DEC05Accident · No injuriesFinal reportBell 47D1 (OH-13E) · Stockbridge, MIThe plt was spraying an onion field when he noted a vibration, followed by a loud noise & severe shaking of the helicopter. He attempted a forced landing, but the helicopter was unresponsive to cyclic & collective inputs. Subsequently, the right skid dug into…Jul 11, 1988 · N12087 · Substantial damageNTSB FTW88FA132Accident · 2 fatalField investigationFinal reportPiper PA-38-112 · Electra, TXThe private pilot's logbook indicated he had a checkout on steep turns and spins two months prior to the accident. He also logged four landings during the same one-half hour flight. A witness saw the airplane complete a three turn spin and saw it start to…Jul 10, 1988 · N2459K · DestroyedNTSB DEN88FA151Accident · Serious injuriesField investigationFinal reportAerospatiale SA-315B · Dubois, WYJul 10, 1988 · N47274 · Substantial damageNTSB ATL88DKG09Accident · 1 fatalFinal reportCessna 188 · Garfield, GAFollowing minor engine maintenance, the plt/mechanic made the test flight. The engine cowling was not installed prior to the flt. Witnesses reported that the acft wheels touched the water of a nearby pond followed by a sharp pull-up into the plt's customary…Jul 10, 1988 · N3525Q · DestroyedNTSB LAX88DUM04Accident · Minor injuriesFinal reportHiller UH-12D · Winterhaven, CAJul 9, 1988 · N646JS · DestroyedNTSB MKC88LA129Accident · Minor injuriesLimited investigationFinal reportGrumman G-164 · Baker, MOWitnesses said that shortly after takeoff, the fully loaded acft appeared to be unable to climb out of ground effect. About 1.5 mile from the airstrip, the pilot began a turn back to the north. Unable to climb, he initiated action to dump his chemical load,…Jul 7, 1988 · N6848K · Substantial damageNTSB CHI88LA155Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Hillsboro, OHAfter making a low pass down a private strip, the aircraft experienced a wire strike followed by an uncontrolled descent into the ground. The pilot stated that his attention was diverted by the owner of the strip.Jul 7, 1988 · N2200E · Substantial damageNTSB SEA88LA123Accident · Serious injuriesLimited investigationFinal reportKaman HH43 · Joseph, ORThe pilot was making the initial long line external load hookup of the day for the purpose of conducting logging operations. The pilot stated that as he maneuvered the aircraft into position the helicopter's main rotor system contacted a tall tree.Jul 5, 1988 · N55714 · DestroyedNTSB MIA88LA212Accident · No injuriesLimited investigationFinal reportBell 47D1 · Ruleville, MSDuring an aerial application flt while spraying chemicals the plt reported that the engine quit. The pilot attempted an autorotation but was too low and slow to complete it. The aircraft landed hard in the field of crops and nosed over. Examination of the…Jul 4, 1988 · N903B · Substantial damageNTSB MIA88FA213Accident · 2 fatalField investigationFinal reportFranklin Drifter XP-503 · Lake Wales, FLThe owner rprtd the plt flew the acft at a company picnic without authorization. Company psnl saw the experimental, amateur built acft takeoff from the company strip, then maneuver for a low pass over the area at about 150 to 200 ft AGL. Some estimated the…Jul 4, 1988 · N65DF · DestroyedNTSB CHI88FA147Accident · 1 fatalField investigationFinal reportCessna 150G · Plymouth, OHJul 4, 1988 · N2865S · DestroyedNTSB ANC88FA083Accident · 4 fatalField investigationFinal reportCessna 185 · Whittier, AKThe flight departed six mile lake on elmendorf air force base and was destined for coghill lake. The airplane was found at the 2500 foot level of a mountain on the north side of burns glacier. The airplane heading was 324 degrees. The heading to go through…Jul 4, 1988 · N185BT · Substantial damageNTSB ANC88DAG05Accident · 2 fatalFinal reportPiper PA-18A · Mcgrath, AKThe airplane crashed approximately 94 miles east of the city of Mcgrath, Alaska. The pilot and passenger were fatally injured and the Piper PA-18 airplane was substantially damaged. The airplane impacted ground in a near vertical attitude near the end of a…Jul 4, 1988 · N1556P · Substantial damageNTSB NYC88DHM01Accident · Serious injuriesFinal reportRutgers Agriplane · Freehold, NJThe plt was working for a firm that was developing the experimental, light weight, crop duster in a joint venture with another firm. An acdnt occurred as he was operating the acft at the location of one of the firms. The plt stated that after takeoff, 'I was…Jul 3, 1988 · N54472 · Substantial damageNTSB ANC88LA081Accident · 1 fatalLimited investigationFinal reportCessna 206 · Naknek, AKThe pilot was hauling fish from remote beach sites in Alaska to a nearby gravel airstrip. Witnesses reported seeing the airplane make two approaches to the field in weather estimated as visibility 1/2 mile in fog, and a ceiling of 100-200 feet. After the two…Jul 3, 1988 · N5045U · DestroyedNTSB NYC88LA177Accident · Minor injuriesLimited investigationFinal reportBellanca 7GCBC · Laconia, NHThe plt stated that after pickup on a banner tow operation, the tow became twisted and he elected to return and release. On downwind, the acft began a rapid descent which the plt could not compensate for, even after releasing the banner and adding power.…Jul 2, 1988 · N5041J · Substantial damageNTSB MKC88FA120Accident · 1 fatalField investigationFinal reportPiper PA-28-160 · Beedeville, ARIntentional buzzing performed, visual outlook not maintained and over confidence in personal ability by the pilot in command.Jul 2, 1988 · N5517W · Substantial damageNTSB LAX88LA247Accident · 1 fatalLimited investigationFinal reportSchweizer SGS-1-26A · Montague, CADuring a pleasure flight, the last transmission by the pilot stated he was going to see what the glider could do besides straight and level flight. Witnesses in the area reported that they heard a loud pop and observed the glider, minus the left wing, in a…Jul 1, 1988 · N2726Z · DestroyedNTSB LAX88FA240Accident · 1 fatalField investigationFinal reportCessna 172P · Descanso, CAPilot's poor judgment and intentional decision to low fly the aircraft below the minimum safe altitude.Jun 30, 1988 · N51234 · DestroyedNTSB SEA88FA120Accident · 2 fatalField investigationFinal reportCessna 150F · Skykomish, WAThe noninstrument rated pilot was attempting to follow us highway 2 westbound across the cascades mountains. According to several witnesses upon cresting the stevens pass area at an altitude of 4300 feet MSL (approximately 250 feet AGL) he encountered low…Jun 29, 1988 · N2RE · DestroyedNTSB LAX88DXQ02Accident · 1 fatalFinal reportBaron Minicoupe · Truckee, CAIt was reported that the purpose of the flight was to buzz friends of the pilot who were windsurfing on sailboards. The airplane was seen maneuvering erratically at a very low altitude over the boca reservoir. Witnesses said the airplane did several steep…Jun 29, 1988 · N8534A · DestroyedNTSB ANC88LA073Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Kenai, AKThe pilot stated that he was in a 180 degree turn when he encountered IMC conditions. The flight path had placed the pilot in a valley with cloud shrouded hills to the sides. The aircraft struck the side of a hill at 1780 MSL.Jun 28, 1988 · N65928 · Substantial damageNTSB NYC88DFJ02Accident · Minor injuriesFinal reportHiller UH-12E · Cherry Creek, NYThe pilot reported that during an aerial application operation, he heard a noise that was followed by a decay in rotor RPM. Subsequently, he was forced to land in an area of tall trees & the helicopter was damaged. An investigationrevealed that a connecting…Jun 27, 1988 · N157HA · Substantial damageNTSB DEN88LA139Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Conrad, MTThe plt reported that he was making a lt turnaround to begin a swath run. He said the acft slowed while in a steep lt bank at the highest part of the turn and he was unable to raise the lt wing as the acft approached the ground. The lt wing and main landing…Jun 27, 1988 · N9856P · Substantial damageNTSB MIA88FA206Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Madeira Beach, FLWitnesses stated that the acft was flying about 20 feet above the bay when the left wing dipped into the water. The airplane cartwheeled and sank. Witnesses said the aircraft had been buzzing homes and boats all along the coast, from clearwater south to the…Jun 25, 1988 · N15986 · DestroyedNTSB BFO88LA059Accident · Serious injuriesLimited investigationFinal reportChampion 7ECA · Talcott, WVAccording to a witness, the acft was maneuvering at a low altitude when it contacted trees. The acft then descended, impacting the terrain 45 ft from the trees and slid aprx 110 ft before coming to rest. The plt stated that due to injuries he is unable to…Jun 25, 1988 · N9504S · DestroyedNTSB DEN88LA134Accident · Minor injuriesLimited investigationFinal reportCessna T188C · Big Timber, MTThe plt said he was spraying 2,4,d on two barley flds. He had completed one fld and was turning around when the acft began to settle. He said when he attempted to avoid ground contact the acft stalled and collided with the ground. During a telephone…Jun 22, 1988 · N4970J · Substantial damageNTSB ATL88FA199Accident · 1 fatalField investigationFinal reportLuscombe 8A · Horse Shoe, NCA witness reported that he was irrigating a newly cultivated corn field with a spray irrigation machine. He heard and then observed the accident airplane fly through or just over a gap in the trees at the northeast end of the field. The airplane proceeded to…Jun 22, 1988 · N1144B · DestroyedNTSB LAX88DVA07Accident · 1 fatalFinal reportAyres S2R · Firebaugh, CADuring an agricultural spraying run, the airplane was required to fly under power lines to complete the job. The airplane was seen flying in the direction of the wires. The airplane initially contacted a levee with the wing and then collided with a power…Jun 21, 1988 · N5512X · DestroyedNTSB SEA88LA115Accident · Minor injuriesLimited investigationFinal reportPeterson J-4 · Ephrata, WAThe glider plt was maneuvering for a thermal when he encountered a downdraft. The plt said insufficient altitude remained for an airport landing. An off-airport landing on rough terrain resulted in damage to the glider.Jun 20, 1988 · CGHGZ · Substantial damageNTSB NYC88LA168Accident · No injuriesLimited investigationFinal reportCessna 305A · Colts Neck, NJDuring a banner pick up attempt, the tow rope became affixed to the main landing gear. The pilot was unable to release the banner and landed with it still attached. Upon landing roll out, the aircraft's tail rose abruptly and the propeller dug into the turf.…Jun 18, 1988 · N14418 · Substantial damageNTSB NYC88FA167Accident · 2 fatalField investigationFinal reportBellanca 7GCBC · Livermore Falls, METhe citabria 7GCBC was observed to make a loop. The left wing bent upward at the strut attach point as the aircraft was at the bottom of the loop and recovering to level flight. The aircraft was then observed to descend in a right spiral and not recover prior…Jun 18, 1988 · N4129Y · DestroyedNTSB MIA88FA197Accident · 1 fatalField investigationFinal reportKennedy Skycycle 2 · Orlando, FLThe gyroplane was on a local demonstration flt. The passenger (pax) stated the plt took off, climbed to aprx 500 ft AGL,descended to aprx 20 ft AGL & maneuvered near observers. He said the plt then added power & initiated a 30 deg climb attitude. The pax…Jun 18, 1988 · N33KA · DestroyedNTSB DEN88LA131Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Ayr, NDJun 18, 1988 · N455Y · Substantial damageNTSB FTW88LA122Accident · No injuriesLimited investigationFinal reportCessna 182R · Garden City, TXThe pilot was inspecting some areas to be sprayed and also a road to be used as an airstrip for his aerial spraying. After a low pass over the road at reduced power, he advanced the throttle but the engine would not respond. During the forced landing in rough…Jun 17, 1988 · N9836H · Substantial damage