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 CHI96FA318Accident · 2 fatalField investigationFinal reportBeech 35-33 · Brownsburg, INfailure of the pilot to maintain adequate airspeed, while maneuvering at low altitude, which resulted in an inadvertent stall and subsequent impact on a roadway. Buzzing by the pilot was a contributing factor.Aug 28, 1996 · N963T · DestroyedNTSB FTW96LA359Accident · Serious injuriesLimited investigationFinal reportFernandez Baby ACE D · New Raymer, COThe pilot's loss of control for reasons undetermined.Aug 25, 1996 · N316F · DestroyedNTSB SEA96LA204Accident · No injuriesLimited investigationFinal reportPrice Acro Sport II · Coeur D'Alene, IDthe pilot's improper inflight planning/decision, and his failure to properly monitor (manage) the fuel supply, which resulted in fuel exhaustion and a subsequent forced landing. Soft terrain in the forced landing area was a related factor.Aug 24, 1996 · N456HD · Substantial damageNTSB FTW96LA361Accident · No injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Rio Rancho, NMthe pilot's failure to maintain clearance from the power lines. The variable wind condition was a related factor.Aug 24, 1996 · N7414U · Substantial damageNTSB ATL96FA123Accident · 2 fatalField investigationFinal reportBurkhart Grob G-115D · Indiantown, FLfailure of maintenance personnel to rebalance the flight controls after the airplane had been repainted, which resulted in rudder flutter and in-flight breakup of the airplane.Aug 24, 1996 · N234VW · DestroyedNTSB CHI96LA313Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Aitkin, MNthe pilot's failure to maintain clearance from known transmission lines. Factors relating to this accident were the transmission lines and the sunglare which hindered the pilot's ability to see the transmission lines.Aug 23, 1996 · N4797Q · Substantial damageNTSB CHI96LA312Accident · 1 fatalLimited investigationFinal reportPiper J3C-65 · Urbana, ILthe pilot's failure to maintain airspeed. A factor was the diverted attention of the pilot.Aug 21, 1996 · N23176 · Substantial damageNTSB LAX96FA310Accident · 1 fatalField investigationFinal reportBell/Tsirah 209AH-1FT · Palmdale, CAthe first pilot misjudged the distance from the rock outcropping. The pilot's ostentatious display was a factor in this accident.Aug 20, 1996 · N777TZ · DestroyedNTSB CHI96LA310Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Galesburg, ILfailure of the pilot to maintain clearance from trees that protruded into the field that he was spraying.Aug 20, 1996 · N904X · Substantial damageNTSB CHI96LA307Accident · No injuriesLimited investigationFinal reportCessna 180 · Duxbury, MNthe failure of the pilot to maintain airspeed.Aug 19, 1996 · N2814A · Substantial damageNTSB ATL96LA121Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Tuscaloosa, ALThe pilot's failure to see and avoid an antenna during low altitude maneuvering.Aug 18, 1996 · N4405E · Substantial damageNTSB CHI96LA300Accident · Serious injuriesLimited investigationFinal reportCessna 188 · Walnut Grove, MNthe pilot's failure to maintain proper clearance from the transmission wire.Aug 16, 1996 · N2081J · Substantial damageNTSB IAD96FA136Accident · 2 fatalField investigationFinal reportBellanca 8KCAB · Elkton, MDThe pilot's failure to maintain adequate altitude and control of the airplane while performing aerobatic maneuvers.Aug 15, 1996 · N2535Z · DestroyedNTSB NYC96LA167Accident · No injuriesLimited investigationFinal reportBell 206B · Starks, MEthe pilot's improper decision to operate at slow airspeed, and close to the critical relative wind azimuth area in gusty, variable winds, which resulted in an inadvertent loss of tail rotor effectiveness. The gusty crosswind and lack of a suitable terrain for…Aug 13, 1996 · N9913K · Substantial damageNTSB FTW96LA344Accident · 2 fatalLimited investigationFinal reportCessna TR182 · Port Isabel, TXpilot impairment of judgment and performance due to alcohol and drugs, and failure of the pilot(s) to maintain obstacle clearance, during an intentional low altitude flight manueuver (low pass under a bridge).Aug 13, 1996 · N6316T · DestroyedNTSB SEA96LA188Accident · Minor injuriesLimited investigationFinal reportJonas Exec 90 · Hermiston, ORslippage of the drive belts, while hover taxiing in ground effect, which resulted in loss of power to the rotor system; and inadequate remedial action by the pilot, which led to a roll over during touch down (forced landing). A factor relating to the accident…Aug 12, 1996 · N6183P · Substantial damageNTSB SEA96FA187Accident · Serious injuriesField investigationFinal reportGarlick UH-1H · Coeur D'Alene, IDFatigue fracture of the left forward vertical stabilizer spar, resulting in loss of the vertical stabilizer and tail rotor and subsequent loss of control. A factor was insufficient applicability (by make and model) of an existing FAA airworthiness directive…Aug 12, 1996 · N97NW · Substantial damageNTSB LAX96LA305Accident · Serious injuriesLimited investigationFinal reportAmerican AA-1 · Rosamond, CAThe pilot's inadequate preflight planning and his delayed decision to reverse the airplane's direction.Aug 12, 1996 · N5616L · DestroyedNTSB CHI96LA293Accident · No injuriesLimited investigationFinal reportAero Commander 600 · Rhinelander, WIa total loss of engine power for undetermined reasons.Aug 12, 1996 · N1797S · DestroyedNTSB SEA96FA186Accident · 1 fatalField investigationFinal reportLet L-13 · Shelton, WAfailure of the operator to provide its pilots with information essential for an accurate determination of the glider's weight and balance, the resultant operation of the glider with a center-or-gravity that exceeded the aft limit, and the pilot's inadvertent…Aug 11, 1996 · N90865 · Substantial damageNTSB SEA96FA185Accident · 2 fatalField investigationFinal reportAeronca 7CCM · Marsing, IDloss of engine power for undetermined reason(s), and failure of the pilot to maintain adequate airspeed, while maneuvering for a forced landing, which resulted in a stall and collision with terrain.Aug 11, 1996 · N2836E · Substantial damageNTSB MIA96LA210Accident · 1 fatalLimited investigationFinal reportBell 47G-4A · Adel, GAthe pilot's misjudgment of clearance between the helicopter and the antenna. A factor relating to the accident was the pilot's use of a drug (medication) that had sedative effects.Aug 11, 1996 · N9472G · DestroyedNTSB FTW96LA346Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Hatch, NMa loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for a forced landing.Aug 11, 1996 · N8992Q · Substantial damageNTSB MIA96LA209Accident · Serious injuriesLimited investigationFinal reportHughes 269A · Cottondale, FLimproper assembly of the main rotor blade dampners by a mechanic which resulted in the helicopter being damaged by ground resonance.Aug 10, 1996 · N8784F · Substantial damageNTSB IAD96LA131Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Greenfld Twnshp, PAloss of engine power for undetermined reason(s). A high obstruction in the forced landing area was a related factor.Aug 10, 1996 · N6984F · DestroyedNTSB ANC96LA122Accident · No injuriesLimited investigationFinal reportAeronca 7BCM · Northway, AKThe pilot's inadequate in-flight planning during a low pass of a remote airstrip and his inadequate compensation for wind conditions. A factor in the accident was unfavorable wind conditions.Aug 10, 1996 · N2502B · Substantial damageNTSB CHI96LA287Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Wellfleet, NEfailure of the pilot to maintain aircraft control, while maneuvering at low latitude. The hilly (rolling) terrain and unfavorable wind were related factors.Aug 9, 1996 · N6966K · DestroyedNTSB CHI96FA290Accident · 2 fatalField investigationFinal reportAeronca 11AC · Charlotte, MIthe pilot's improper use of engine controls (carburetor heat and/or throttle), while making a relatively high speed approach, low pass, and pull-up, which resulted in partial loss of engine power; and failure of the pilot to maintain sufficient airspeed after…Aug 9, 1996 · N85825 · DestroyedNTSB CHI96LA277Accident · No injuriesLimited investigationFinal reportWeatherly 201B · Fargo, NDthe pilot's failure to maintain clearance from a wire, while crossing under a transmission line. The proximity of wires to the work area was a related factor.Aug 8, 1996 · N1282W · Substantial damageNTSB FTW96FA337Accident · 2 fatalField investigationFinal reportCulbertson Thorp T-18 · Albuquerque, NMthe pilot's failure to maintain control of the airplane while maneuvering. Factors were the high winds and the high density altitude.Aug 7, 1996 · N353 · DestroyedNTSB CHI96LA281Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164 · Grant, NEfatigue failure and subsequent catastrophic failure of the number nine cylinder. A factor was the corn.Aug 7, 1996 · N8842H · Substantial damageNTSB IAD96FA126Accident · 1 fatalField investigationFinal reportAerotek Pitts Special S-1S · Pittsburgh, PAThe pilot's utilization of airspeeds greater than the manufacturer recommended maneuvering airspeeds which exceed the design limits of the airplane and resulted in the subsequent failure of the wing spar.Aug 4, 1996 · N2HT · DestroyedNTSB FTW96LA331Accident · No injuriesLimited investigationFinal reportScott Glass Goose · Aubrey, TXThe owner/builder's design change resulting in in-flight flutter of the flaperon, which led to the fuel tank rupture and separation of the flaperon.Aug 2, 1996 · N96GG · Substantial damageNTSB ATL96LA116Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Mayersville, MSfailure of the pilot to maintain adequate clearance from an object (vehicle) on the ground.Aug 2, 1996 · N7362 · Substantial damageNTSB FTW96LA329Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Burlington, COThe total loss of engine power resulting from a cracked cylinder. A factor was the unsuitable terrain for the forced landing.Jul 31, 1996 · N25SK · Substantial damageNTSB MIA96LA197Accident · No injuriesLimited investigationFinal reportBell 47D1G · West Boca Raton, FLFailure of the pilot to apply carburetor heat following a loss of engine power due to inadequate altitude over a populated area. Contributing to the accident was the encounter with conditions favorable for carburetor icing.Jul 30, 1996 · N1200Z · Substantial damageNTSB FTW96FA324Accident · 2 fatalField investigationFinal reportSlaybaugh Mustang II · Crested Butte, COThe pilot's failure to maintain aircraft control. A factor was the inadequatete altitude in which to effect a safe recovery.Jul 28, 1996 · N16WY · DestroyedNTSB CHI96LA258Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-301 · Liberal, KSthe pilot did not maintain aircraft control. A factor was a low altitude flight maneuver was performed.Jul 28, 1996 · N8837S · DestroyedNTSB SEA96FA171Accident · 2 fatalField investigationFinal reportCessna 340A · Richland, WAThe pilot-in-command's allowing the aircraft's airspeed to decrease below the single-engine minimum control speed (Vmc) resulting in a stall/spin condition. Factors contributing to the accident were the pilot-in-command's allowing the left engine to be shut…Jul 27, 1996 · N341TL · DestroyedNTSB FTW96LA320Accident · 2 fatalLimited investigationFinal reportQualline Hatz CB-1 · Pipe Creek, TXloss of aircraft control in flight for undetermined reason(s).Jul 27, 1996 · N485D · DestroyedNTSB CHI96LA282Accident · No injuriesLimited investigationFinal reportCessna 188-230 · Santanta, KSa loss of power due to a broken number four cylinder exhaust valve push rod and a bent number four cylinder intake valve push rod. The wet, soft cornfield was a factor.Jul 26, 1996 · N8086V · Substantial damageNTSB SEA96LA167Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-235 · Cornelius, ORthe pilot's inadequate preflight planning, and his failure to see-and-avoid the obstruction (inadequate visual lookout). The transmission wire was a related factor.Jul 25, 1996 · N9624P · Substantial damageNTSB IAD96LA122Accident · 1 fatalLimited investigationFinal reportCessna 150L · Philippi, WVthe pilot's impairment of judgment and performance due to alcohol, his resultant improper planning/decision, and his failure to maintain sufficient altitude/clearance from trees, while maneuvering at low altitude. Intentional maneuvering at low altitude was a…Jul 25, 1996 · N21953 · DestroyedNTSB FTW96LA315Accident · Serious injuriesLimited investigationFinal reportHiller UH-12E · Mount Holly, ARFuel exhaustion due to the pilot's failure to refuel the helicopter. A factor was the lack of suitable terrain for the forced landing.Jul 24, 1996 · N9743C · Substantial damageNTSB SEA96FA168Accident · 1 fatalField investigationFinal reportBeech D35 · Yellow Pine, IDfailure of the pilot to maintain adequate airspeed, while maneuvering in mountainous terrain, which resulted in a stall/spin and collision with terrain.Jul 23, 1996 · N2161D · DestroyedNTSB LAX96LA278Accident · 1 fatalLimited investigationFinal reportCessna 172 · Midas, NVthe decision of the pilot to perform a low-level steep turn which resulted in an inadvertent loss of control and subsequent stall/spin. Factors were high density altitude and inadequate altitude for recovery.Jul 19, 1996 · N1958D · DestroyedNTSB ATL96LA111Accident · Minor injuriesLimited investigationFinal reportGrumman G-164 · Montezuma, GAfailure of the pilot to maintain adequate visual look out, while maneuvering on an aerial application run, which result in his failure to see-and-avoid a power line.Jul 19, 1996 · N465RF · DestroyedNTSB ATL96LA110Accident · Minor injuriesLimited investigationFinal reportGrumman-Schweizer 164 · Bainbridge, GAThe pilot's misjudgment of the clearance from the trees during the swath run that resulted in the collision.Jul 19, 1996 · N697Y · DestroyedNTSB NYC96FA152Accident · 1 fatalField investigationFinal reportChampion 7GCBC · Farmingdale, NJthe pilot's improper handling of the airplane during a banner pickup maneuver, which resulted in a stall/mush and collision with the ground. A factor relating to the accident was: the pilot's lack of experience in the type of operation.Jul 18, 1996 · N7557F · DestroyedNTSB SEA96LA159Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Pullman, WAfailure of the pilot to maintain terrain clearance during a swath run. Factors relating to the accident were: unfavorable (variable) wind conditions, low airspeed, and uneven terrain.Jul 16, 1996 · N9336R · Substantial damage