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 SEA89LA023Accident · No injuriesLimited investigationFinal reportPiper PA-18A · Murphy, IDWhile making a low pass over a snow-covered airstrip, the plt misjudged his altitude. The aircraft's main gear made contact with six inch deep snow, & after traveling aprx 100 ft, the plane nosed over.Nov 11, 1988 · N8562C · Substantial damageNTSB MIA89FA027Accident · 2 fatalField investigationFinal reportGrumman AA5A · Tampa, FLWitnesses stated the acft was flying at low alt in the area of lake thonotosassa just before it struck the top static wire of a group of power lines. Impact occurred while the acft was on a southerly heading. The acft then crashed into an orange grove. An…Nov 11, 1988 · N9975U · DestroyedNTSB MIA89LA024Accident · Minor injuriesLimited investigationFinal reportBell 206L · St. ThomasThe plt autorotated the helicopter into the water after a loss of power while transitioning from fwd flight to a hover. While landing with the emergency floats armed, he attempted to deploy the floats but was unable. The plt & pax evacuated. The helicopter…Nov 10, 1988 · N16619 · Substantial damageNTSB LAX89DUM03Accident · No injuriesFinal reportGrumman G-164 · Blythe, CAThe pilot stated that the engine lost power on a 'spray pass.' He then executed a forced landing straight ahead and nosed over after touchdown in a cotton field. Investigation revealed an elbow fitting connecting the main fuel supply line and the carburetor…Nov 10, 1988 · N10219 · Substantial damageNTSB ATL89LA030Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Deane, KYWhile en route to wise, Virginia from richmond, Kentucky on a pleasure flight, the airplane collided with trees on rockhouse mountain. The airplane was substantially damaged and the pilot and passenger were seriously injured. The fuel selector was found…Nov 9, 1988 · N98185 · DestroyedNTSB CHI89DEV01Accident · No injuriesFinal reportCessna 152 · Vandalia, ILThe eng began running rough aprx 5 min after the plt took off from an en route arpt drg a night, x-country training flt. He reversed course back toward the departure arpt with the eng providing partial power. While maneuvering to land on rwy 18, the eng…Nov 8, 1988 · N93085 · Substantial damageNTSB CHI89LA022Accident · No injuriesLimited investigationFinal reportCessna 150J · Carson City, MINov 7, 1988 · N50649 · Substantial damageNTSB NYC89FA021Accident · 2 fatalField investigationFinal reportCessna 152 · Smithfield, RIFailure of the pilot to maintain airspeed after beginning an ascent from a low pass, which resulted in a stall & loss of aircraft control. Inadequate altitude to recover from a stall was considered to be a contributing factor.Nov 6, 1988 · N5462B · DestroyedNTSB FTW89FA015Accident · 2 fatalField investigationFinal reportCessna A150K · Flint, TXThe airplane was observed flying on an easterly heading at low altitude, with the propeller stopped. One of the witnesses said the airplane was gliding toward him and when close he started running away. He said the airplane abruptly turned left and went…Nov 6, 1988 · N5913J · DestroyedNTSB FTW89DRD01Accident · Minor injuriesFinal reportSandridge KR-2 · Monroe, LAAs the plt was taxiing to takeoff, the tower adzd him that wind shear advisories were in effect. At aprx 1359, he was clrd for takeoff on rwy 31. At that time, the wind was from 280 deg at 18 KTS. Drg takeoff, the acft was climbing thru about 300 to 500 ft,…Nov 5, 1988 · N4474U · DestroyedNTSB SEA89LA016Accident · No injuriesLimited investigationFinal reportBell 214B-1 · Ketchikan, AKOutbd 5 feet of top skin from one main rotor blade separated in flt. Plt effected lndg with no further damage. Investigation revealed erosion of leading edge protective strip allowed airloads to intrude under skin to cause delamination and separation. Soot…Nov 4, 1988 · N514RM · Substantial damageNTSB LAX89LA035Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Chandler, AZThe pilot lost control and collided with the runway while maneuvering for landing. The pilot and passenger were testing atmospheric conditions with meteorological equipment in conjunction with noise testing of a Boeing 707 'hush' kit. The Cessna tookoff…Nov 4, 1988 · N4657L · DestroyedNTSB FTW89DQG01Accident · 1 fatalFinal reportPiper PA-25-235 · Lamesa, TXThe pilot was spraying a field of cotton, and was in a turnaround when the airplane descended to the ground. The autopsy indicated the pilot died of acute coronary thrombosis. Although tox results indicate the presence of alcohol in the pilot's blood, the…Nov 4, 1988 · N75217 · DestroyedNTSB MKC89LA018Accident · Serious injuriesLimited investigationFinal reportRockwell S2R · Sublette, KSWhile conducting an aerial application operation, the aircraft struck some cross-country power lines. The acft nosed down and struck the terrain, causing substantial damage to the acft and serious injuries to the pilot. The pilot was unable to recall the…Nov 1, 1988 · N5517X · Substantial damageNTSB DEN89LA025Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Tucumcari, NMThe private plt was flying a friend over his ranch searching for cows. The plt reported making a 40 deg left banked turn at 300 ft AGL at full power and 70 knots. He said that the plane would not respond to aileron control inputs initially. The plt said the…Oct 30, 1988 · N4026Z · Substantial damageNTSB DEN89DTE02Accident · 1 fatalFinal reportJones Christen Eagle II · Parker, COThe plt was performing aerobatics in a homebuilt christen eagle near his girlfriend's house where a birthday party was in progress. Witnesses said the acft executed a roll at low altitude and 'went straight in.' Weather was not a factor and examination of the…Oct 30, 1988 · N25DJ · DestroyedNTSB MIA89LA020Accident · Minor injuriesLimited investigationFinal reportParsons B-8M · Lake City, FLDuring an airshow, the plt took off to perform a planned 8-spin autorotative landing from an alt of aprx 800 ft. an FAA inspector who observed the accident stated the flt ascended to aprx 650 ft MSL. After closing the throttle, the plt began the maneuver.…Oct 29, 1988 · N10WP · Substantial damageNTSB LAX89LA027Accident · 1 fatalLimited investigationFinal reportLet L-13 · Marana, CAThe pilot reported that shortly after liftoff from runway 26 the control stick became difficult to move. He decided to continue the air tow and release at 200 feet AGL after release, the pilot turned the glider to return to the runway to land. He was still…Oct 29, 1988 · N90848 · Substantial damageNTSB LAX89DUJ02Accident · Serious injuriesFinal reportPiper PA-25-235 · Glendale, AZDuring an aerial application flight the pilot reported that the right wing suddenly went up then down. The airplane rolled to the right and collided with the terrain. Inspection of the airplane revealed that the lift strut was broken. Evidence of corrosion…Oct 23, 1988 · N7229Z · Substantial damageNTSB LAX89DUJ01Accident · Serious injuriesFinal reportCessna A188A · Casa Grande, AZDuring aerial application flight, the aircraft collided with a high-tension static wire and subsequently with the ground. Post-impact fire ensued. The pilot stated he misjudged his approach to the field and did not see the wire.Oct 23, 1988 · N5640J · DestroyedNTSB ANC89LA012Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Huslia, AKThe private pilot and his adult male passenger were both severely burned when the pilot's Piper PA-18 crashed and burned following a low altitude stall and impact with trees. The pilot's wife stated that her husband told her that he was showing his passenger…Oct 23, 1988 · N7688L · Substantial damageNTSB LAX89FA023Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Big Pine, CAPilot's failure to maintain proper altitude.Oct 22, 1988 · N140RM · DestroyedNTSB LAX89FA018Accident · 2 fatalField investigationFinal reportCessna 172P · Union City, CALoss of control of the aircraft by the pilot when he inadvertently entered instrument meteorological conditions. Factors contributing to the accident were, dark night light conditions and foggy weather conditions, inadvertent flight into IMC under visual…Oct 19, 1988 · N52222 · DestroyedNTSB SEA89LA013Accident · 4 fatalLimited investigationFinal reportCessna 210E · Wenatchee, WAThe acft crashed while the plt was on a x-country flt at dawn. Impact occurred on rising, rocky terrain in a box canyon area at an elev of about 6000 ft. no ground scars were evident, but the acft impacted on a rocky slide area. It came to rest in one area…Oct 18, 1988 · N4961U · DestroyedNTSB LAX89DUM02Accident · Serious injuriesFinal reportPiper PA-36-285 · Brawley, CAAt the completion of aerial application, the plt attempted flight beneath power lines. The aircraft contacted and severed four power lines and then collided with terrain. A post-impact fire ensued.Oct 18, 1988 · N57591 · DestroyedNTSB LAX89DVM01Accident · No injuriesFinal reportContinental Copters OH13H · Castroville, CADuring aerial application by helicopter, engine power was lost. Plt maneuvered to avoid power lines during autorotation, resulting in hard lndg. Investigation revealed failure of accessory drive to magnetos.Oct 16, 1988 · N9092T · Substantial damageNTSB LAX89DUM01Accident · 1 fatalFinal reportArlington Sisu 1A · Borrego Springs, CAWhile thermal soaring, the acft entered a steep spinning descent, three turns to the right followed by two turns to the left and ground impact in a near vertical attitude. No evidence was found of aircraft structural failure or control malfunction. The…Oct 15, 1988 · N252JB · Substantial damageNTSB ATL89FA013Accident · 1 fatalField investigationFinal reportCessna 182E · Brooklet, GAWitnesses reported the plt began a low altitude, high speed pass over the rwy as he had done on several previous occasions. However, as he initiated the pass, the descent to the rwy was not arrested & the airplane 'pancaked' near the threshold. The airplane…Oct 14, 1988 · N2834Y · DestroyedNTSB MKC89DPG01Accident · 1 fatalFinal reportCulver LFA · Dumas, ARA witness stated that the airplane backfired while in a turn at low altitude. He heard it backfire twice more and noticed engine running at idle just before it crashed. When runup, the engine would attain 1900 RPM, then backfire and the RPM would drop to 600…Oct 13, 1988 · N34872 · DestroyedNTSB ANC89FA009Accident · 2 fatalField investigationFinal reportPiper PA-12 · Little Heart Lk, AKThe pilot-in-command called a local pilot in the talkeetna area for weather and the conditions of the lake to determine if the lake's surface had frozen. He then departed for the lake at 1800 adt and was not heard from again. The airplane wreckage was located…Oct 13, 1988 · N3153M · Substantial damageNTSB LAX89DVA01Accident · Serious injuriesFinal reportAyres S2R · Traver, CAWhile spraying a cotton field the engine lost power. The pilot executed a forced landing in an open area but rollout continued into crops. The acft nosed over. Investigation revealed only unuseable fuel on board.Oct 12, 1988 · N3087D · Substantial damageNTSB SEA89LA011Accident · 1 fatalLimited investigationFinal reportRoman LONG-EZ · Salmon, IDThe purpose of the flight was to spot wild game during feeding time (at dusk). The surviving passenger estimated the flight visibility was about one to two mi with smoke. While flying in close proximity to rugged, mountainous terrain, the acft struck a tree…Oct 10, 1988 · N38AJ · DestroyedNTSB FTW89DRG02Accident · 1 fatalFinal reportDouglas A-20G · San Benito, TXIncapacitation of the pilot while flying an aircraft due to loss of consciousness from a cardiac rhythm disturbance.Oct 8, 1988 · N67921 · DestroyedNTSB NYC89FA006Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Renovo, PAImproper VFR procedures the pilot's visual lookout was improper and he collided with a static wire.Oct 7, 1988 · N7293W · DestroyedNTSB ANC89LA006Accident · No injuriesLimited investigationFinal reportCessna 206 · Eagle, AKThe pilot-in-command was attempting to air drop groceries to a mining site and a box of bread hit the horizontal stabilizer. The aircraft returned and landed uneventfully at Eagle airport.Oct 6, 1988 · N734GW · Substantial damageNTSB MIA89LA003Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Fort Pierce, FLWhile practicing maneuvers near a grass airstrip, the left side of the engine cowling opened. The plt elected to perform a low pass to observe wind direction, then a precautionary landing at the airstrip. After touchdown, the acft became airborne and drifted…Oct 5, 1988 · N91323 · Substantial damageNTSB MIA89FA004Accident · No injuriesField investigationFinal reportHughes 269C · Vero Beach, FLThe plt stated that while doing a stuck left pedal maneuver, the helicopter was flown with a 5 degree yaw to the left. As the airspeed zeroed, the collective was brought in to bring the nose around and light contact was made with the ground. He then stated…Oct 5, 1988 · N8602F · DestroyedNTSB LAX89LA009Accident · Minor injuriesLimited investigationFinal reportBellanca 8KCAB · Alpine, CADuring a telephone interview, the pilot stated that he had just recovered from a one turn spin and was in level flight when he felt the airplane pitch up. He added a small amount of nose down trim and the airplane pitched down. He stated that at this point…Oct 5, 1988 · N5508H · DestroyedNTSB SEA89FA006Accident · No injuriesField investigationFinal reportBeech B-99A · East Sound, WAThe crew elected to depart the airport under a special VFR clearance. Wx at the departure airport was 700 ft ovc with visibility 1 and 1/4 miles. The destination airport was within 25 nautical miles of the departure airport and was reporting a bkn ceiling of…Oct 4, 1988 · N803BA · Substantial damageNTSB NYC89FA003Accident · Serious injuriesField investigationFinal reportAeronca 11AC · Barnstead, NHThe Aeronca 11AC was maneuvering downwind for landing. The pilot made a left turn towards the runway to tighten the pattern. While in close proximity to a house and the runway, at a low altitude the pilot elected to make a steep left 270 degree turn, opposite…Oct 3, 1988 · N9569E · DestroyedNTSB LAX89FA006Accident · 2 fatalField investigationFinal reportBeech A24R · Mt. Baldy, CAPilot's improper in-flight decision and altitude.Oct 3, 1988 · N8065R · DestroyedNTSB ANC89LA003Accident · Minor injuriesLimited investigationFinal reportCessna 206 · Kodiak, AKWhile flying through a mountain pass the pilot encountered a high wind condition. The pilot lost control of the airplane, and the airplane crashed at the 900 foot level.Oct 3, 1988 · N122SC · Substantial damageNTSB SEA89LA003Accident · No injuriesLimited investigationFinal reportLet L-13 · Enumclaw, WAThe pilot allowed the aircraft to become too close to terrain while soaring. A steep turn to reverse direction resulted in entry into an accelerated stall at low altitude. The pilot lowered the nose of the aircraft to recover, however, while lowering the nose…Oct 2, 1988 · N9241Z · Substantial damageNTSB MKC89LA002Accident · No injuriesLimited investigationFinal reportCessna 140 · Quinter, KSThe pilot was flying at reduced power without the use of carburetor heat. The aircraft engine began to run rough. The pilot added carburetor heat and full throttle which resulted in the engine backfiring. The pilot elected to execute a precautionary landing.…Oct 2, 1988 · N73051 · Substantial damageNTSB ANC89LA002Accident · Minor injuriesLimited investigationFinal reportPiper PA-11 · Levelock, AKThe airplane was at approximately 250 to 300 feet above sea level, and was executing a 360 degree turn to the left when the airplane stalled and crashed in the river. The pilot reported that he has never held a FAA pilot or medical certificate.Oct 2, 1988 · N4724M · Substantial damageNTSB MIA89LA001Accident · Minor injuriesLimited investigationFinal reportRobinson R22 · Orlando, FLWhile practicing hovering the helicopter began to drift. The instructor plt corrected this & returned control to the student plt. The helicopter then began to descend & the instructor plt attempted to correct this with collective, but the student plt applied…Oct 1, 1988 · N2628B · Substantial damageNTSB DEN89FA001Accident · 2 fatalField investigationFinal reportCessna 152 · Eden, UTBefore takeoff, the plt told ramp psnl that he & his wife were planning to take some pictures of the beautiful fall colors. A witness near the crash site observed an acft (matching the description of N48926) flying at low altitude. Subsequently, the acft…Oct 1, 1988 · N48926 · DestroyedNTSB NYC88LA250Accident · No injuriesLimited investigationFinal reportBellanca 14-13-2 · Sodus Bay, NYWhile on a low level pleasure flt over water the plt failed to maintain adequate terrain clearance and the left wing contacted the water. The acft crashed into the water and remained upright. The plt and pax exited the acft and were picked up by a passing…Sep 30, 1988 · N74425 · Substantial damageNTSB NYC88LA247Accident · Minor injuriesLimited investigationFinal reportCessna 172P · New York, NYWhile on a night personal pleasure flt along the hudson river between New York and new jersey, at 300 feet AGL, the plt turned the acft toward an unlighted shore area and lost visual cues. The plt inadvertently flew the acft into the water. The acft sunk and…Sep 30, 1988 · N98305 · DestroyedNTSB LAX88DVG10Accident · 1 fatalFinal reportCessna A188B · Dixon, CAPlt had completed aerial application of a field several miles south. Witnesses heard sounds of acft. One witness observed acft briefly inverted and 'out of control.' Acft impacted open field upright, wings level and nose down. Fire ensued. No evidence found…Sep 30, 1988 · N21871 · Destroyed