Final NTSB investigations

99 cases where the phase of flight was Pushback/towing.

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.\"completionStatus\" = 'Completed'
    AND c.\"mKey\" IN (SELECT case_mkey FROM case_phases WHERE main = 200)
  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 DEN03FA070Accident · Minor injuriesField investigationFinal reportMcDonnell Douglas MD-88 · Denver, COthe flight crew's failure to maintain aircraft control, which resulted in engine start with the throttles advanced and the subsequent impact with the tug. Contributing factors include, the flight crew's improper procedures/directives and failure to…Apr 22, 2003 · N974DL · Substantial damageNTSB CHI03IA055Incident · No injuriesIncident investigationFinal reportBoeing 737-83N · Indianapolis, INThe ground tow personnel not maintaining clearance from the de-icing vehicle during the tow back to the gate. Factors were the de-icing vehicle that parked by the airplane's left wing, the ground personnel not following the operator's towing…Jan 16, 2003 · N303TZ · Minor damageNTSB CHI02LA128Accident · No injuriesLimited investigationFinal reportBoeing 757-33N · Chicago, ILThe ground personnel handled the aircraft improperly during pushback from the gate by failing to maintain clearance with the other parked aircraft. The light rain and the parked airplane that was contacted were factors.May 11, 2002 · N552TZ · Substantial damageNTSB ANC02FA023Accident · No injuriesField investigationFinal reportMcDonnell Douglas MD-82 · Anchorage, AKThe MD-11 flight crew's failure to maintain clearance while taxiing and the other's airplane's (MD-82) ground-marshaling personnel's failure to follow procedures/directives when they did not display an emergency stop signal to the crew of the MD-11. Factors…Mar 17, 2002 · N935AS · 2 aircraft · Substantial damageNTSB NYC02LA056Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas DC-9-32 · Dulles, VAThe lack of direction from the operator on how to perform pushbacks on an icy ramp, which led to the tug driver positioning the tug at an angle to the nose of the airplane that allowed the airplane to move forward and strike the tug. Factors were the…Jan 20, 2002 · N837AT · Substantial damageNTSB ATL02LA029Accident · No injuriesLimited investigationFinal reportBoeing 727-200 · Greenville, SCThe tug driver's failure to maintain control of the airplane during pushback resulting in the tug colliding with the airplane. A factor was ice on the ramp.Jan 3, 2002 · N262FE · Substantial damageNTSB CHI01LA331Accident · Serious injuriesLimited investigationFinal reportBoeing 757-222 · Indianapolis, INthe inadequate crew/group coordination and the parking brakes not set by the pilot in command.Sep 24, 2001 · N570UA · No damageNTSB NYC01LA125Accident · No injuriesLimited investigationFinal reportEmbraer EMB-135LR · Cleveland, OHAn overload force being exerted on the nosewheel gear assembly for undetermined reason.Apr 13, 2001 · N735TS · Substantial damageNTSB ATL01LA041Accident · Serious injuriesLimited investigationFinal reportBoeing 727-200 · Memphis, TNThe Powerback Coordinator's failure to follow powerback procedures which resulted in jet blast injuries to the wing walker. A factor was the stuck wheel chock.Mar 23, 2001 · N275US · No damageNTSB NYC00LA267Accident · No injuriesLimited investigationFinal reportBoeing 737-49R · Flushing, NYThe tug operator's inadequate visual lookout. A factor in this accident was the night light condition.Sep 16, 2000 · N461PR · Substantial damageNTSB CHI00FA244Accident · No injuriesField investigationFinal reportBoeing 727-264 · Chicago, ILthe fractured tow bar and the inadequate weld of the tow bar by an unknown person.Aug 16, 2000 · N764AT · Substantial damageNTSB NYC00IA100Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-88 · Boston, MAthe failure of the ground pushback crew to maintain an adequate clearance from a nearby airplane during pushback.Mar 24, 2000 · N944DL · 2 aircraft · Minor damageNTSB NYC00LA086Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas DC-10-30F · Newark, NJThe tug operator's inadequate visual lookout.Mar 1, 2000 · N302FE · Substantial damageNTSB NYC00LA040Accident · No injuriesLimited investigationFinal reportBoeing 727-232 · Flushing, NYwas the use of a defective tow bar, due to the lack of an adequate inspection by contract personnel, the airlines lack of an adequate preventative maintenance program for the tow bars, and the lack of oversight by the airline on the contract personnel who…Nov 27, 1999 · N521DA · Substantial damageNTSB LAX00LA015Accident · No injuriesLimited investigationFinal reportAirbus Industrie A-320-231 · Phoenix, AZThe airline's failure to fully review the obstruction clearances and revise the pushback procedures in an area of the ramp where new construction had impinged on the available ramp space. Also causal was the failure of the tug driver and the wing walkers to…Oct 15, 1999 · N627AW · Substantial damageNTSB LAX99LA302Accident · No injuriesLimited investigationFinal reportBoeing 737-322 · Los Angeles, CAThe lavatory service driver's failure to follow established company procedures and directives. A factor in the accident was the airline's use of a one person pushback procedure.Sep 12, 1999 · N388UA · Substantial damageNTSB LAX99LA322Accident · No injuriesLimited investigationFinal reportBoeing 757-2G7 · Phoenix, AZThe failure of the flight crew and the tug driver to verify that the aircraft was properly configured for pushback. Factors in the accident were the left wing walker's failure to notify the tug driver of his observations that the jet bridge was still in…Jul 24, 1999 · N910AW · Substantial damageNTSB NYC99LA127Accident · No injuriesLimited investigationFinal reportBoeing 727 · Sterling, VAInadequate visual lookout by the tug operator. A factor in this accident was inadequate pushback procedures by the airline which failed to provide proper assistance (wing walkers) to the tug operator.May 28, 1999 · N282SC · Substantial damageNTSB DEN99LA027Accident · No injuriesLimited investigationFinal reportBoeing 727-233 · Denver, COSnow removal not done by other person.Dec 22, 1998 · N269FE · Substantial damageNTSB FTW98FA273Accident · Minor injuriesField investigationFinal reportBoeing 737-322 · Denver, COInadequate visual lookout by ground personnel (tug operator). Factors include failure of the airline to provide proper assistance (wing walkers) to the tug operator, and inadequate pushback procedures by the airline; inattention of the catering truck driver,…Jun 18, 1998 · N364UA · Substantial damageNTSB MIA98LA124Accident · No injuriesLimited investigationFinal reportDouglas DC-10-10F · Memphis, TNThe tug operator's (maintenance representative) inadequate visual lookout during pushback.Apr 4, 1998 · N68053 · Substantial damageNTSB CHI98LA058Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas DC-9-50 · Memphis, TNthe flight attendant lost his balance during pushback and struck his head on a galley door.Dec 7, 1997 · N774NC · No damageNTSB NYC97LA129Accident · Serious injuriesLimited investigationFinal reportLockheed L-1011-385-1 · Covington, KYthe failure of the primary and secondary elevator driveshafts, and the failure of maintenance personnel to detect the failure of the primary shaft during scheduled inspections.Jun 27, 1997 · N723DA · No damageNTSB NYC97LA064Accident · 1 fatalLimited investigationFinal reportLockheed L-1011 · Jamaica, NYThe failure of the right wing walker, also the push back supervisor, to identify and avoid a hazardous condition, which resulted in his activity near the airplane's nose wheel during tow operations, and where he was subsequently caught under the nose wheel. A…Mar 27, 1997 · N762DA · No damageNTSB LAX97LA073Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas DC-10-15 · Las Vegas, NVthe ramp agent's failure to maintain a good situational awareness of the push-back. A factor was the dark night lighting conditions and the general communication failure of the ground push-back crew.Dec 23, 1996 · N151SY · No damageNTSB LAX96LA222Accident · No injuriesLimited investigationFinal reportBoeing 737-322 · San Francisco, CAinadequate visual lookout by the United Airlines tug driver during the pushback operation. Contributing factors were: the driver's reduced ability to observe the American B-767 due to the nighttime condition, and United Airlines management's failure to ensure…Jun 7, 1996 · N371UA · 2 aircraft · Substantial damageNTSB MIA95LA218Accident · No injuriesLimited investigationFinal reportBoeing 737-4Q8 · Miami, FLImproper planning/decision by the company driver of the vehicle (paymover) and uncommanded movement of the paymover for undetermined reasons.Sep 6, 1995 · N405KW · Substantial damageNTSB MIA95LA196Accident · No injuriesLimited investigationFinal reportBoeing 727-264 · Orlando, FLThe failure of the ground crew to follow procedures/directives requiring that the airplane brakes be set before disconnecting the tow bar from the airplane.Aug 6, 1995 · N764AT · Substantial damageNTSB MIA95LA135Accident · No injuriesLimited investigationFinal reportBoeing 727-232 · West Palm Beach, FLThe failure of the ground pushback crew to follow delta airlines pushback procedures and place a signalman forward of the aircraft in view of the captain during pushback. This resulted in the captain not being aware that the tug tow bar had disconnected and…May 24, 1995 · N489DA · Substantial damageNTSB MIA95LA086Accident · No injuriesLimited investigationFinal reportLockheed L-1011-385 · San Juan, PRThe tug operator of another airplane commencing pushback procedures without clearance to do so from the dispatching agent, resulting in an on-ground collision between both airplanes.Mar 12, 1995 · N724DA · 2 aircraft · Minor damageNTSB ATL95LA038Accident · No injuriesLimited investigationFinal reportDouglas DC-9-32 · Memphis, TNThe ground personnel's improper handling of the aircraft while in tow, and the operator's failure to provide sufficient requirements for this situation.Jan 10, 1995 · N922VV · Substantial damageNTSB LAX94LA357Accident · No injuriesLimited investigationFinal reportCanadair CL600 · Burbank, CAthe ground crew's failure to follow company procedures. The failure of the operator to provide headsets to communicate with the flightcrew and the poor lighting conditions were factors in this accident.Sep 8, 1994 · N403SW · Substantial damageNTSB LAX94LA333Accident · Serious injuriesLimited investigationFinal reportBoeing 757-200 · Phoenix, AZthe failure of the headset operator to adhere to established company safety procedures when he diverted his attention during pushback. A factor in the accident was the airline's failure to modify its ground handling procedures and equipment to eliminate the…Aug 19, 1994 · N901AW · No damageNTSB NYC93LA040Accident · 1 fatalLimited investigationFinal reportBoeing 737-300LR · Flushing, NYA lack of adequate clearance between the walker and tug which resulted in the walker being struck by the tug when he fell for unknown reason(s). A factor related to the accident was the lack of a policy to stay clear of the tug, towbar, and nosewheel of the…Dec 8, 1992 · N516AU · No damageNTSB ATL93LA024Accident · Serious injuriesLimited investigationFinal reportBoeing 757-232 · Atlanta, GAThe inadequate procedures and training of ground personnel involved in the aircraft push back operations by company management.Nov 13, 1992 · N619DL · No damageNTSB LAX92LA336Accident · Serious injuriesLimited investigationFinal reportBoeing 737-200 · San Francisco, CAThe improper installation of the towbar. Contributing to the accident was a disconnected tow bar during push back.Aug 6, 1992 · N9010U · No damageNTSB FTW92LA100Accident · Serious injuriesLimited investigationFinal reportBoeing 757-223 · Hayden, COFailure of the ground personnel to follow published procedures/directives. A factor was the inadequate equipment.Mar 27, 1992 · N615AM · No damageNTSB LAX92LA147Accident · Serious injuriesLimited investigationFinal reportBoeing 757-222 · Phoenix, AZThe ground guide's failure to follow established procedures and his improper visual lookout by failing to remain clear of the nose gear during the push back operation.Mar 21, 1992 · N519UA · No damageNTSB CHI91IA073Incident · No injuriesIncident investigationFinal reportBritish Aerospace 146-200 · Chicago, ILCompany procedures and directives not being followed by ground personnel. A factor associated with the accident is complacency by company/operator management.Jan 18, 1991 · N608AW · Minor damageNTSB LAX90LA021Accident · Serious injuriesLimited investigationFinal reportBoeing 757-2S7 · Phoenix, AZThe ground handler improperly crossing under the aircraft while it was moving.Nov 6, 1989 · N902AW · No damageNTSB MIA90FA008Accident · 1 fatalField investigationFinal reportMcdonnell Douglas DC-9-31 · Orlando, FLInadequate weather evaluation and inadequate supervision of the ground guide (mechanic) by company/operator/management personnel, failure of the ground guide to follow safety procedures, and the weather condition (lightning).Oct 7, 1989 · N958VJ · No damageNTSB MIA89FA194Accident · 1 fatalField investigationFinal reportAirbus Industrie A-300 · San Juan, PRFailure of the ramp guide (ground personnel) to follow normal safety procedures. His over confidence in his personal ability was considered to be a contributing factor.Jul 12, 1989 · N7062A · No damageNTSB DEN89IA124Incident · No injuriesIncident investigationFinal reportBoeing 727-247 · Denver, COFailure of the left main landing gear forward trunnion bearing support fitting due to a crack initiating at the forward edge of the bore and propagating by intergranular stress corrosion into the bore surface that resulted in an eventual ductile fracture.May 24, 1989 · N296WA · Minor damageNTSB CHI88FA233Accident · No injuriesField investigationFinal reportBoeing 727-200 · Minneapolis, MNFailure of the captain to follow company pushback procedures and not getting a release before starting to taxi.Sep 9, 1988 · N729RW · Substantial damageNTSB SEA88IA074Incident · No injuriesIncident investigationFinal reportBoeing 727-290 · Portland, ORThe Boeing 727 was pushed back fm the gate counterclockwise through an arc of 90 degrees resulting in mispositioning the acft relative to the intended taxi direction. The ground crew (tug and safety operators) attempted to resolve the out of position…Apr 13, 1988 · N291AS · Minor damageNTSB NYC87LA108Accident · No injuriesLimited investigationFinal reportBoeing 727 · Burlington, VTIn preparation for powering away from the gate, one groundman was stationed off the left nose of the acft and another was positioned by the left wing tip. The plt advanced the throttles and initiated a right turn. The throttles were brought back to idle…Mar 10, 1987 · N780AL · Substantial damageNTSB LAX86IA021Incident · No injuriesIncident investigationFinal reportBoeing 727-200 · Oakland, CAOn October 24, 1985, an American airlines 727 collided with a parked united airlines 727 during a power back operation at Oakland, CA. IMC existed at the time with visibility limited to 0 ft due to fog. The aa ac sustained minor damage to its left wing and…Oct 24, 1985 · N6815A · Minor damageNTSB LAX84IA040Incident · No injuriesIncident investigationFinal reportBoeing 767 · San Francisco, CADuring pushback the right wingtip of the Boeing 767 struck the rudder of a Douglas DC-9 parked at the adjacent gate. The B-767 was being pushed back by two mechanics, one on thetug & one under the left wing.Nov 2, 1983 · N605TW · Minor damageNTSB LAX82FA195Accident · Minor injuriesField investigationFinal reportDouglas DC10-10 · San Francisco, CADuring the initial pushback from the gate prior to eng start a loud noise was heard & the acft nose slowly settled onto the tug that was performing the pushback. The captain ordered the acft evacuated using the emergency slides. The upper jaw of the towbar…May 27, 1982 · N1833U · Substantial damage