# Final NTSB investigations: Pushback/towing

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

Page 1 of 2 · 99 cases

## Latest cases

- [NTSB DCA22LA015](https://openairdocs.org/ntsb/DCA22LA015.md): Embraer S A ERJ 170-200 LR · Miami, FL · Accident · Serious injuries · Class 4 · Limited · Final report · Oct 23, 2021 · N252NN · No damage
  > An abrupt jerk of the airplane as the captain applied the parking brake during the tow that caused a flight attendant to fall and break her wrist.
- [NTSB DCA19CA223](https://openairdocs.org/ntsb/DCA19CA223.md): Bombardier CL 600 2C10 · Chicago OHare, IL · Accident · No injuries · Class 4 · Data collection · Final report · Sep 11, 2019 · N710SK · 2 aircraft · Substantial damage
  > the tug driver's inability to maintain visual contact with the wing walkers and lack of situational awareness during pushback.
- [NTSB DCA19CA102](https://openairdocs.org/ntsb/DCA19CA102.md): Bombardier CL 600 2C10 · Charlotte, NC · Accident · Minor injuries · Class 4 · Data collection · Final report · Mar 10, 2019 · N530EA · 2 aircraft · Substantial damage
  > failure of the ground crew to maintain visual separation and avoid the holding aircraft.
- [NTSB DCA19CA079](https://openairdocs.org/ntsb/DCA19CA079.md): Airbus A320 · Denver, CO · Accident · No injuries · Class 4 · Data collection · Final report · Jan 28, 2019 · N220FR · Substantial damage
  > loss of control of the tug by the driver during pushback operations as a result of the contaminated ramp, angle of the towbar, and the airplane engines being at idle thrust.
- [NTSB DCA19CA035](https://openairdocs.org/ntsb/DCA19CA035.md): Bombardier CL 600 2B19 · New York, NY · Accident · Minor injuries · Class 4 · Data collection · Final report · Dec 1, 2018 · N202PS · Substantial damage
  > the captain initiating a cross bleed start while under tow.
- [NTSB DCA18CA272](https://openairdocs.org/ntsb/DCA18CA272.md): Boeing 757 · Philadelphia, PA · Accident · Serious injuries · Class 4 · Data collection · Final report · Aug 24, 2018 · EI-LBT · No damage
  > The ground service employee's inadvertent fall near the nose wheel during pushback.
- [NTSB DCA16CA207](https://openairdocs.org/ntsb/DCA16CA207.md): Boeing 737 3H4 · Baltimore, MD · Accident · No injuries · Data collection · Final report · Aug 5, 2016 · N368SW · Substantial damage
  > the tug operators excessive speed during pushback.
- [NTSB CEN15IA337](https://openairdocs.org/ntsb/CEN15IA337.md): Boeing 737 · Denver, CO · Incident · Minor injuries · Incident investigation · Final report · Aug 5, 2015 · N779SW · Minor damage
  > The gate lead/pushback driver's failure to recognize that the provisioning truck was within the safety zone of the gate during his walkaround due to distractions, which resulted in the subsequent collision between the airplane and the truck. Contributing to…
- [NTSB ERA15IA206](https://openairdocs.org/ntsb/ERA15IA206.md): Cessna 525B · Teterboro, NJ · Incident · No injuries · Incident investigation · Final report · May 3, 2015 · N784JS · Minor damage
  > The overstress fracture of the nose landing gear actuator (NLG) attachment lug during tow operations, which resulted in the collapse of the NLG.
- [NTSB DCA15CA012](https://openairdocs.org/ntsb/DCA15CA012.md): Embraer-Empresa Brasileira De ERJ 170 200 LR · Minneapolis, MN · Accident · No injuries · Data collection · Final report · Oct 23, 2014 · N622CZ · 2 aircraft · Substantial damage
  > the B757 Captain's failure to maintain a safe clearance between his wing and the wingtip of the ERJ-170. Contributing to the accident was the positioning of the ERJ-170 by the Compass ground personnel.
- [NTSB CEN14LA430](https://openairdocs.org/ntsb/CEN14LA430.md): Bombardier CL600 2D24 - 900 · San Antonio, TX · Accident · No injuries · Limited investigation · Final report · Aug 9, 2014 · N943LR · Substantial damage
  > Failure of the tow bar shear pin, which resulted in the tug operator’s loss of control of the airplane during pushback operations. Contributing to the accident was the tug operator’s inability to communicate to the flight crew to apply the airplane’s brakes.
- [NTSB DCA14CA093](https://openairdocs.org/ntsb/DCA14CA093.md): Mcdonnell Douglas MD90 - 30 · Boston, MA · Accident · No injuries · Data collection · Final report · May 12, 2014 · N933DN · Substantial damage
  > the captain's failure to verify the communications between himself and the tug operator, which resulted in him applying of brakes while the airplane was being pushed back from the gate by the tug with tow bar attached.
- [NTSB WPR13IA226](https://openairdocs.org/ntsb/WPR13IA226.md): Boeing 737-7H4 · Phoenix, AZ · Incident · No injuries · Incident investigation · Final report · May 10, 2013 · N913WN · Minor damage
  > The failure of the tug operator and wing walker to adequately monitor the environment during pushback of the airplane from the gate in preparation for flight, which led to the collision of the airplane with an adjacently parked airplane.
- [NTSB CEN12IA123](https://openairdocs.org/ntsb/CEN12IA123.md): Boeing 737-7H4 · Denver, CO · Incident · No injuries · Incident investigation · Final report · Dec 22, 2011 · N469WN · Minor damage
  > The snowplow operator’s incapacitation due to fatigue, which resulted in the snowplow contacting a parked airplane. Contributing to the incident was the company’s lack of a policy regarding employee fatigue.
- [NTSB ERA12CA038](https://openairdocs.org/ntsb/ERA12CA038.md): Mcdonnell Douglas MD-88 · Atlanta, GA · Accident · No injuries · Data collection · Final report · Oct 7, 2011 · N922DL · Substantial damage
  > The tug driver's inadequate control of the tug while maneuvering the airplane during pushback.
- [NTSB DCA11CA073](https://openairdocs.org/ntsb/DCA11CA073.md): Boeing 757-222 · San Fransico, CA · Accident · No injuries · Data collection · Final report · Jun 12, 2011 · N571UA · Substantial damage
  > The ramp personnel's failure to visually verify the position of the jetway before beginning the airplane pushback.
- [NTSB WPR11LA300](https://openairdocs.org/ntsb/WPR11LA300.md): Boeing 757-222 · Los Angeles, CA · Accident · Serious injuries · Limited investigation · Final report · May 31, 2011 · N526UA · Minor damage
  > The ground crewmembers’ failure to follow proper procedures for removing a stuck or jammed tow bar, which resulted in a ground crew injury.
- [NTSB ERA11LA266](https://openairdocs.org/ntsb/ERA11LA266.md): Airbus A330-323 · New York, NY · Accident · Serious injuries · Limited investigation · Final report · Apr 25, 2011 · N807NW · No damage
  > The flight attendant's inadvertent fall, which resulted in a serious injury.
- [NTSB CEN11IA270](https://openairdocs.org/ntsb/CEN11IA270.md): Embraer EMB-135KL · Dubuque, IA · Incident · No injuries · Incident investigation · Final report · Apr 3, 2011 · N377SK · Minor damage
  > The airport authorities' improper decision to deactivate the jet bridge braking system which created an unsafe condition by the gate agents not being able to stop the bridge from impacting the airplane during a wind gust.
- [NTSB CEN11IA198](https://openairdocs.org/ntsb/CEN11IA198.md): Boeing 737-823 · Southlake, TX · Incident · No injuries · Incident investigation · Final report · Feb 21, 2011 · N945AN · Minor damage
  > The tractor driver’s failure to confirm that the tow bar head/handle was secured correctly to the airplane.
- [NTSB DCA11CA014](https://openairdocs.org/ntsb/DCA11CA014.md): Boeing 737-7H4 · Philadelphia, PA · Accident · No injuries · Data collection · Final report · Dec 18, 2010 · N913WN · 2 aircraft · Substantial damage
  > the failure of the ground operations personnel to maintain awareness of the relative position of the two airplanes.
- [NTSB WPR11LA058](https://openairdocs.org/ntsb/WPR11LA058.md): Bombardier CL-600-2C10 · Salt Lake City, UT · Accident · No injuries · Limited investigation · Final report · Nov 24, 2010 · N614SK · Substantial damage
  > The tug driver’s loss of airplane control during pushback due to a loss of traction in slippery conditions on the ramp. Contributing to the accident was the ground crews’ and airline operators’ inadequate guidance with regard to pushback procedures during low…
- [NTSB WPR10FA199](https://openairdocs.org/ntsb/WPR10FA199.md): Boeing 737-3H4 · Los Angeles, CA · Accident · No injuries · Field investigation · Final report · Apr 10, 2010 · N624SW · Substantial damage
  > The tug operator’s failure to comply with company procedures when parking an unoccupied baggage tug, and the failure of the tug’s seat switch to disengage the electric motor when weight was removed from the driver’s seat.
- [NTSB ENG10IA016](https://openairdocs.org/ntsb/ENG10IA016.md): Douglas DC8 · Cincinnati (CVG), OH · Incident · No injuries · Incident investigation · Final report · Jan 7, 2010 · N803DH · Minor damage
  > Failure of the NLG cylinder occurred by intergranular rupture; coincidental to a chrome plating crack. The failure origin occurred along the inner surface of the cylinder and then propagated by stress corrosion cracking to the outer surface. A secondary crack…
- [NTSB DCA09FA025](https://openairdocs.org/ntsb/DCA09FA025.md): Embraer EMB145 · New York, NY · Accident · No injuries · Field investigation · Final report · Dec 31, 2008 · N844MJ · Substantial damage
  > The tug driver's failure to comply with ramp safety procedures.
- [NTSB WPR09FA068](https://openairdocs.org/ntsb/WPR09FA068.md): Boeing 757-351 · Seattle, WA · Accident · No injuries · Field investigation · Final report · Dec 28, 2008 · N585NW · 2 aircraft · Substantial damage
  > The failure of the tug operator and wing walker of the other airplane to maintain clearance with this aircraft during the pushback process in dark night. Also causal was the ramp controller's misinterpretation of the other airplane's gate location and her…
- [NTSB DCA09FA022](https://openairdocs.org/ntsb/DCA09FA022.md): Mcdonnell Douglas DC-9-83 · Los Angeles Intl Airport, CA · Accident · No injuries · Field investigation · Final report · Dec 26, 2008 · N9617R · Substantial damage
  > The first officer's unannounced advancement of the left engine throttle, which led to a sustained application of high thrust that caused the airplane to impact the tug.
- [NTSB WPR09IA065](https://openairdocs.org/ntsb/WPR09IA065.md): Boeing 737-890 · Seattle, WA · Incident · No injuries · Incident investigation · Final report · Dec 24, 2008 · N516AS · No damage
  > The failure of the deicing crew to follow company procedures by not receiving confirmation from the flight crew before beginning to deice the airplane.
- [NTSB WPR09IA033](https://openairdocs.org/ntsb/WPR09IA033.md): Boeing 737-700 · Salt Lake City, UT · Incident · No injuries · Incident investigation · Final report · Nov 7, 2008 · N254WN · Minor damage
  > The tug driver's failure to maintain situational awareness during the push back operation.
- [NTSB NYC08LA234](https://openairdocs.org/ntsb/NYC08LA234.md): Bombardier CL-600-2C10 · Charlotte, NC · Accident · No injuries · Limited investigation · Final report · Jun 28, 2008 · N725PS · 2 aircraft · Substantial damage
  > The tugdriver and wing walker's lack of communication and the tugdriver's failure to properly monitor the wing walker. Contributing to the accident was the lightning in the vicinity of the airport, which resulted in the ground crewmembers not wearing headsets.
- [NTSB ENG08IA051](https://openairdocs.org/ntsb/ENG08IA051.md): Boeing 737 · Phoenix (PHX), AZ · Incident · No injuries · Incident investigation · Final report · Jun 27, 2008 · N514AU · Minor damage
  > The failure of the MLG was due to cracking in the cylinder wall resulting from a fatigue mechanism which initiated at, and near the inner diameter (ID) surface, with propagation through the wall toward the outer diameter(OD) surface. Crack initiation was due…
- [NTSB SEA08LA061](https://openairdocs.org/ntsb/SEA08LA061.md): Bombardier CL-600-2C10 · San Francisco, CA · Accident · No injuries · Limited investigation · Final report · Jan 14, 2008 · N705SK · 2 aircraft · Substantial damage
  > The company tug operator's failure to maintain clearance with another aircraft during the pushback process. Also causal was the ground controller's failure to alert the pilot of the other aircraft and tug operator of this airplane of the simultaneous pushback…
- [NTSB MIA07CA119](https://openairdocs.org/ntsb/MIA07CA119.md): Boeing 777-232 · Atlanta, GA · Accident · Serious injuries · Data collection · Final report · Jul 12, 2007 · N865DA · No damage
  > The flight attendant's inadvertent misstep on a ladder and falling during pushback resulting in serious injuries.
- [NTSB LAX07LA189](https://openairdocs.org/ntsb/LAX07LA189.md): Boeing 757-24APF · Burbank, CA · Accident · Serious injuries · Limited investigation · Final report · Apr 24, 2007 · N402UP · No damage
  > The tow tractor driver's and mechanic's diverted attention resulting in the airplane rolling over the mechanic's foot. Also causal was the mechanic's failure to maintain clearance from the nose landing gear.
- [NTSB NYC06IA207](https://openairdocs.org/ntsb/NYC06IA207.md): Boeing 737-524 · Newark, NJ · Incident · No injuries · Incident investigation · Final report · Aug 21, 2006 · N14655 · Minor damage
  > An overload failure of the airplane's nose landing gear while being towed for repositioning.
- [NTSB NYC06FA184](https://openairdocs.org/ntsb/NYC06FA184.md): Boeing 737-300 · Pittsburgh, PA · Accident · Minor injuries · Field investigation · Final report · Jul 27, 2006 · N529AU · Substantial damage
  > The airplane tug driver's inadvertent movement of the tug gear shift lever from forward to reverse, which resulted in the nose landing gear collapse. Contributing to the accident was the defective gear shift lever.
- [NTSB NYC06LA191](https://openairdocs.org/ntsb/NYC06LA191.md): Embraer EMB-135LR · Newark, NJ · Accident · No injuries · Limited investigation · Final report · Jul 24, 2006 · N703MR · Substantial damage
  > The captain's failure to follow company procedures, which resulted in pushback with the parking brake set. A factor was the larger than preferred tug.
- [NTSB ATL06LA024](https://openairdocs.org/ntsb/ATL06LA024.md): Boeing 727-2S2F · Memphis, TN · Accident · Serious injuries · Limited investigation · Final report · Dec 14, 2005 · N213FE · Substantial damage
  > The improper towing of the airplane by the tug operator which resulted in the shearing of the towbar shear pin and subsequent collision of the airplane and tug.
- [NTSB CHI05LA179](https://openairdocs.org/ntsb/CHI05LA179.md): Boeing 737-7H4 · Chicago, IL · Accident · No injuries · Limited investigation · Final report · Jul 8, 2005 · N494WN · Substantial damage
  > The pushback tow driver not maintaining visual lookout for the wing walker's visual signal, and the driver not maintaining clearance from the vehicle during the pushback for taxi. Factors to the accident were the standing vehicle behind the airplane, the…
- [NTSB DEN05IA084](https://openairdocs.org/ntsb/DEN05IA084.md): de Havilland DHC-8-202 · Denver, CO · Incident · No injuries · Incident investigation · Final report · May 30, 2005 · N454YV · No damage
  > The improper procedures conducted by the ground personnel and the flight crew's failure to coordinate procedures with the ground personnel during push back operation which resulted in the collision between the ground support vehicle and the airplane. A…
- [NTSB NYC05LA038](https://openairdocs.org/ntsb/NYC05LA038.md): McDonnell Douglas MD-82 · Providence, RI · Accident · No injuries · Limited investigation · Final report · Dec 20, 2004 · N402A · Substantial damage
  > The vehicle driver's failure to maintain directional control, which resulted in a collision with the airplane during push-back. A factor was the icy ramp area.
- [NTSB DFW05LA010](https://openairdocs.org/ntsb/DFW05LA010.md): Saab-Scania SF-340B · Fort Worth, TX · Accident · Serious injuries · Limited investigation · Final report · Oct 25, 2004 · N376AE · No damage
  > The ground personnel's failure to maintain clearance from the propeller. Contributing factors were the ground personnel's failure to comply with procedures/directives and the ground personnel's failure to properly use equipment.
- [NTSB CHI04LA077](https://openairdocs.org/ntsb/CHI04LA077.md): Saab-Scania Saab 340B · Romulus, MI · Accident · No injuries · Limited investigation · Final report · Feb 25, 2004 · N420XJ · Substantial damage
  > The visual lookout not maintained and the procedures not followed by the Push Tug Operator during the pushback. Factors were the parked airplane, the dark night, and the inadequate surveillance of the pushback by airline management.
- [NTSB ATL04LA053](https://openairdocs.org/ntsb/ATL04LA053.md): Canadair CL-600-2B19 · Miami, FL · Accident · No injuries · Limited investigation · Final report · Dec 15, 2003 · N445AW · Substantial damage
  > The tug operator's loss of control and his failure to maintain clearance from the aircraft during pushback operations.
- [NTSB LAX04LA007](https://openairdocs.org/ntsb/LAX04LA007.md): Boeing 777-22B · San Francisco, CA · Accident · No injuries · Limited investigation · Final report · Oct 7, 2003 · N222UA · 2 aircraft · Substantial damage
  > the failure of the taxiing Boeing 777's flight crew to maintain clearance from a Boeing 777 that was being pushed back from the gate. Contributing to the accident was the failure of the local ramp controller to caution either aircrew of a possible movement…
- [NTSB NYC03LA208](https://openairdocs.org/ntsb/NYC03LA208.md): Embraer EMB-135 · Flushing, NY · Accident · No injuries · Limited investigation · Final report · Sep 27, 2003 · N733KR · Substantial damage
  > The inadequate visual lookout by the driver of a ground vehicle, and by ground support personnel, which resulted in a subsequent collision between the airplane and ground vehicle. A factor related to the accident was the failure of the pilot-in-command and…
- [NTSB LAX03LA295](https://openairdocs.org/ntsb/LAX03LA295.md): de Havilland DH-8-202 · Phoenix, AZ · Accident · No injuries · Limited investigation · Final report · Sep 21, 2003 · N455YV · Substantial damage
  > the ground agent's inadequate visual lookout during push back, which resulted in his failure to maintain clearance between the airplanes.
- [NTSB NYC03FA186](https://openairdocs.org/ntsb/NYC03FA186.md): Mcdonnell Douglas DC-9-82 · Jamaica, NY · Accident · No injuries · Field investigation · Final report · Sep 2, 2003 · N454AA · Substantial damage
  > A fractured nose gear spray deflector due to contact with a tow bar during pushback, which subsequently jammed and prevented nose gear extension during landing. A factor in this accident was the tow operator's failure to detect the damaged spray deflector.
- [NTSB ATL03LA124](https://openairdocs.org/ntsb/ATL03LA124.md): Boeing 717-200 · Atlanta, GA · Accident · No injuries · Limited investigation · Final report · Aug 1, 2003 · N970AT · Substantial damage
  > The failure of the ground crew to follow powerback procedures and directives.
- [NTSB NYC03LA135](https://openairdocs.org/ntsb/NYC03LA135.md): Embraer EMB-135-KL · Boston, MA · Accident · No injuries · Limited investigation · Final report · Jun 24, 2003 · N839AE · Substantial damage
  > The tug driver's failure to maintain directional control of the tug, which caused the tug to impact the airplane.

Next page: https://openairdocs.org/ntsb-phases/200/cases.md?status=final&page=2

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
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
```

This list as a web page: https://openairdocs.org/ntsb-phases/200/cases?status=final

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.