OpenAirDocs.org

NTSB investigations

6,398 cases where the phase of flight was Taxi.

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 = 250)
  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 NYC04LA099Accident · No injuriesLimited investigationFinal reportBeech 1900D · Windsor Locks, CTThe fuel truck driver's failure to maintain clearance with a taxiing airplane, resulting in the collision between the fuel truck and the airplane. A factor in the accident was the night condition.Apr 1, 2004 · N149CJ · Substantial damageNTSB CHI04CA092Accident · No injuriesData collectionFinal reportCessna 150J · Gardner, KSThe pilot's inadequate visual lookout and failure to maintain clearance from the post. A factor was the post.Mar 22, 2004 · N51365 · Substantial damageNTSB ANC04LA044Accident · No injuriesLimited investigationFinal reportBeech V35B · Jacksonville, FLThe pilot's inadvertent retraction of the landing gear during the taxi from landing, which resulted in structural damage to the airplane.Mar 20, 2004 · N412V · Substantial damageNTSB MIA04LA058Accident · 1 fatalLimited investigationFinal reportOrtmayer/Parson none · Bunnell, FLThe owner/pilot mechanic's failure to comply with a manufacture notice to replace the rotor blades and hub bar assembly, resulting in a failure of the hub bar to hub bar wing attaching bolt and separation of a main rotor blade.Mar 12, 2004 · N69EP · Substantial damageNTSB LAX04LA159Accident · No injuriesLimited investigationFinal reportBeech 65 · Sedona, AZan explosion of the left outboard wing, resulting from a leaking fuel line and the ignition of the flammable fuel/air mixture in the outboard wing bays; the source of ignition energy for the explosion could not be determined. A factor in the accident was an…Mar 9, 2004 · N751T · Substantial damageNTSB DEN04IA050Incident · No injuriesIncident investigationFinal reportAirbus Industrie A320-232 · Denver, COthe failure of the other flight crew to maintain clearance from the airplane and the ground crews failure to follow proper pushback procedures.Mar 6, 2004 · N467UA · 2 aircraft · Minor damageNTSB CHI04LA083Accident · No injuriesLimited investigationFinal reportCessna 195 · Manitowoc, WIThe Cessna 195 pilot's failure to maintain clearance from the Cessna 177RG while taxiing to the ramp after landing. A contributing factor was the restricted forward visibility (blind spot) of the Cessna 195 due to the engine cowling. An additional factor was…Feb 19, 2004 · N4351V · Minor damageNTSB ANC04LA024Accident · Minor injuriesLimited investigationFinal reportRobinson R44 · Daytona Beach, FLThe pilot's inadequate compensation for wind conditions while hover taxiing, which resulted in a loss of control and subsequent in-flight collision with terrain and a rollover of the helicopter. A factor associated with the accident was a gusty wind condition.Feb 18, 2004 · N323TC · Substantial damageNTSB LAX04CA130Accident · No injuriesData collectionFinal reportCessna 172S · Riverside, CAthe pilot's inadequate visual lookout, which resulted in his failure to maintain proper alignment with the taxiway. Factors in the accident were the dusk lighting conditions and pilot not understanding the ground control taxi clearance.Feb 15, 2004 · N262TA · Substantial damageNTSB NYC04LA062Accident · No injuriesLimited investigationFinal reportGates Learjet 35A · Akron, OHAn improperly maintained ramp area, which resulted in a loss of airplane control while taxiing on ice. Factors in this accident were, high winds, and the down-sloping ramp.Jan 30, 2004 · N39WA · Substantial damageNTSB LAX04CA099Accident · No injuriesData collectionFinal reportCessna 152 · San Diego, CAthe pilot's misjudgment of clearance from the vehicle while taxiing. A factor in the accident was the pilot's diverted attention.Jan 11, 2004 · N67844 · Substantial damageNTSB LAX04LA090Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · California City, CAthe pilot's decision to continue taxiing during dark night conditions without an operable taxi/landing light or taxiway lights and his failure to maintain taxiway alignment. Contributing factors to the accident were the dark night light conditions, the failed…Jan 7, 2004 · N3820T · Substantial damageNTSB LAX04CA088Accident · No injuriesData collectionFinal reportPiper PA 28-181 · Groveland, CAthe pilot's inadequate visual lookout, and his failure to maintain obstacle clearance. Factors to the accident were the parked vehicle, and the pilot's diverted attention.Jan 3, 2004 · N9272Q · Substantial damageNTSB DEN04LA033Accident · No injuriesLimited investigationFinal reportAerospatiale AS 365 N-2 · Santa Fe, NMthe pilot's failure to maintain lateral clearance from the hangar. A contributing factor was the gusty crosswind.Dec 27, 2003 · N291LL · DestroyedNTSB DEN04LA030Accident · Minor injuriesLimited investigationFinal reportRobinson R22 · Broomfield, COthe flight instructor's failure to maintain aircraft control. Contributing to the accident was the wind gust.Dec 17, 2003 · N341MK · DestroyedNTSB NYC04LA047Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Buffalo, NYThe pilot's improper procedure with regard to the cabin heater, which resulted in the over temperature of the heater and subsequent fire.Dec 12, 2003 · N40259 · Substantial damageNTSB LAX04CA065Accident · No injuriesData collectionFinal reportBeech 58P · San Diego, CAthe pilot's inadequate lookout, which resulted in his failure to maintain clearance from the vehicle while taxiing.Dec 9, 2003 · N58JG · Substantial damageNTSB DEN04FA027Accident · No injuriesField investigationFinal reportSwearingen SA226-TC · Denver, COthe failure of the pilot of the taxiing aircraft to maintain clearance and adequate visual lookout for the stopped aircraft.Dec 3, 2003 · N60U · 2 aircraft · Substantial damageNTSB IAD04LA003Accident · No injuriesLimited investigationFinal reportCessna C172R · Lexington, KYThe ground controller's failure to advise the relieving controller information regarding an engine run-up, which subsequently resulted in the flight instructor's inadvertent encounter with jet blast during ground taxi.Nov 30, 2003 · N9968F · Substantial damageNTSB NYC04LA046Accident · No injuriesLimited investigationFinal reportCessna 172E · Islip, NYThe pilot's failure to maintain aircraft control, which resulted in a nose over. A factor in this accident was the gusty wind conditions.Nov 13, 2003 · N5329T · Substantial damageNTSB LAX04LA043Accident · No injuriesLimited investigationFinal reportCessna 208B · Phoenix, AZthe pilot's improper decision to taxi behind another airplane conducting an engine run-up, which resulted in a jet blast encounter.Nov 13, 2003 · N717BT · Substantial damageNTSB CHI04FA031Accident · No injuriesField investigationFinal reportCessna 560XL · Wheeling, ILThe flight crew's intentional operation with know deficiencies in the aircraft and their delay in aborting the takeoff when a no-takeoff warning was presented. An additional cause was the crew's failure to comply with flight manual procedures concerning…Nov 11, 2003 · N789CN · Substantial damageNTSB DEN04IA024Incident · No injuriesIncident investigationFinal reportBeech 1900D · Denver, COthe ground personnel’s failure to maintain aircraft clearance, resulting in the collision. Contributing factors include ground communications not coordinated by the ground personnel, the flight crew's inadequate visual outlook and the parked airplane.Nov 10, 2003 · N254GL · Minor damageNTSB LAX04LA027Accident · No injuriesLimited investigationFinal reportPiper PA 28-161 · San Diego, CAthe pilot of the other airplane's inadvertent application of the rudder pedals rather than the brakes, which resulted in the collision with the Cessna 172R.Oct 25, 2003 · N39494 · 2 aircraft · Substantial damageNTSB MIA04LA004Accident · Serious injuriesLimited investigationFinal reportAirbus Industrie A-319-112 · Tampa, FLAn intermittent fault with the airplane's Brake Steering Control Unit (BSCU) for undetermined reasons, which resulted in a momentary loss of brakes and steering, and a serious injury to a flight attendant during the resultant sudden stop during taxi for…Oct 16, 2003 · N764US · No damageNTSB LAX04CA013Accident · No injuriesData collectionFinal reportCleveland Orson Starduster II SA-300 · Stockton, CAthe pilot's inadequate visual lookout resulted in his failure to maintain clearance from the parked airplane.Oct 14, 2003 · N379C · Substantial damageNTSB DCA03IA058Incident · Minor injuriesIncident investigationFinal reportMcDonnell Douglas MD-80 · Dfw, TXThe improper maintenance of the tailcone evacuation system, which prevented the evacuation slide from inflating during an evacuation due to smoke/fumes in the cabin.Sep 25, 2003 · N462AA · No damageNTSB SEA03LA192Accident · No injuriesLimited investigationFinal reportCessna 421B · Driggs, IDThe collapse of the nose landing gear while taxiing due to the failure of the nose wheel bearing. A factor was the lack of lubrication.Sep 20, 2003 · N41053 · Substantial damageNTSB SEA03LA201Accident · No injuriesLimited investigationFinal reportCessna 172S · Anacortes, WAThe pilot attempting to taxi the airplane with a known system deficiency. Factors include worn wheel brakes and a drainage ditch.Sep 18, 2003 · N3555L · Substantial damageNTSB ANC03LA128Accident · No injuriesLimited investigationFinal reportCessna 206 · Fairbanks, AKA failure of an attaching bolt that allowed the nose wheel fork to separate from the nose gear strut, which resulted in the collapse of the nose gear during the landing roll. A factor contributing to the accident was rough/uneven terrain.Sep 18, 2003 · N275F · Substantial damageNTSB MIA03IA168Incident · No injuriesIncident investigationFinal reportBoeing 757-223 · Miami, FLThe failure of maintenance personnel from the aircraft operator to identify a missing left main landing gear truck beam shield and damage to the left main landing gear truck beam which resulted in the fracture of the truck beam as a result of stress corrosion…Aug 24, 2003 · N609AA · Minor damageNTSB CHI03LA280Accident · No injuriesLimited investigationFinal reportCessna 172P · Wichita, KSFailure of the maintenance crew to provide adequate clearance to an active taxiway during the engine run-up. Contributing factors were the failure of the control tower to provide a wake turbulence advisory to the accident aircraft when assigning a taxi route…Aug 23, 2003 · N55326 · Substantial damageNTSB CHI03LA178Accident · No injuriesLimited investigationFinal reportChampion 7GCBC · Buffalo, SDThe instructor pilot's inadequate remedial action to the dual student's loss of aircraft control during high speed taxiing which lead to the inadvertent ground loop/swerve. A factor was the student not maintaining aircraft control.Jul 28, 2003 · N9032L · Substantial damageNTSB SEA03LA156Accident · No injuriesLimited investigationFinal reportHughes 269C · Marblemount, WAThe partial failure of a magneto during hover taxi over water, leading to a forced landing in shallow water near the shoreline. Factors include the aircraft being over a lake at the time that the partial loss of power made it impossible to keep it airborne.Jul 25, 2003 · N500HS · Substantial damageNTSB SEA03LA150Accident · No injuriesLimited investigationFinal reportCessna 185 · Sinclair Is., WAThe pilot's failure to maintain directional control while taxiing for takeoff. Factors contributing to the accident were the ditch and the fence.Jul 19, 2003 · C-FHMY · Substantial damageNTSB MIA03LA144Accident · No injuriesLimited investigationFinal reportCessna 172R · Daytona Beach, FLFailure of the student pilot of N864CP to judge the clearance between his airplane and the stationary N431ER while taxiing for takeoff which resulted in a ground collision.Jul 18, 2003 · N864CP · 2 aircraft · Substantial damageNTSB SEA03CA162Accident · No injuriesData collectionFinal reportCessna R172K · Idaho Falls, IDThe pilot's failure to see and avoid a parked aircraft while taxiing.Jul 17, 2003 · N758LW · Substantial damageNTSB SEA03LA133Accident · No injuriesLimited investigationFinal reportCessna 402 B · Lakeview, ORFailure of the landing gear shaft roll pin resulting in a main gear collapse during the taxi phase of operation.Jul 8, 2003 · N98635 · Substantial damageNTSB DEN03LA115Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Bountiful, UTthe pilot not maintaining aircraft control during the aerial taxi. Factors contributing to the accident were the oscillating cyclic, the pilot's diverted attention, and the gusting crosswind.Jun 28, 2003 · N3623U · Substantial damageNTSB SEA03LA104Accident · No injuriesLimited investigationFinal reportMooney M20C · Boise, IDFailure of the welds on the nose landing gear retraction truss during taxi for takeoff..Jun 14, 2003 · N6806U · Substantial damageNTSB DEN03TA103Accident · No injuriesFinal reportCessna R172E · Albuquerque, NMthe student pilot's inadvertent encounter with the jet blast and the subsequent inability to maintain aircraft control.Jun 12, 2003 · N7867N · Substantial damageNTSB DEN03LA096Accident · No injuriesLimited investigationFinal reportEmbraer EMB-120ER · Denver, COthe ground personnel's failure to maintain aircraft/ground vehicle clearance, resulting in the collision. Contributing factors include ground communications not coordinated by the ground personnel and the airport vehicle.Jun 2, 2003 · N299UX · Substantial damageNTSB NYC03LA114Accident · Minor injuriesLimited investigationFinal reportSaab-Scania 340B · Flushing, NYThe inadequate visual lookout and inadequate crew coordination of the Dassault DA-50 flightcrew while taxiing, which resulted in an on ground collision with a taxing Saab 340B. A factor in the accident was the dark night.May 22, 2003 · N277MJ · 2 aircraft · Substantial damageNTSB LAX03LA167Accident · No injuriesLimited investigationFinal reportBoeing 757-223 · Santa Ana, CAthe vehicle driver's failure to deploy the parking brake or use wheel chocks to secure the vehicle prior to leaving it unattended.May 20, 2003 · N692AA · Substantial damageNTSB LAX03LA157Accident · 1 fatalLimited investigationFinal reportSabre Trike 330 · Jean, NVThe pilot's excessive taxi speed, which resulted in an inadvertent liftoff at an inadequate airspeed and a subsequent stall. A factor was the pilot's lack of experience in the airplane.May 20, 2003 · UNREG · Substantial damageNTSB CHI03LA122Accident · No injuriesLimited investigationFinal reportCessna 182S · Hatton, NDFailure by the flight instructor to maintain clearance to the tree. Contributing factors were the delayed remedial action by the flight instructor and the tree.May 6, 2003 · N182ND · Substantial damageNTSB LAX03LA196Accident · No injuriesLimited investigationFinal reportPiper PA-46-310P · Grand Canyon, AZThe out of rig condition of the landing gear control linkages, which prevented the on-ground antiretraction safety device from working. Also causal was the pilot's inadvertent movement of the gear selector to the up position while taxiing.Apr 26, 2003 · N189ET · Substantial damageNTSB LAX03LA144Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Bullhead City, AZThe pilot's misjudgment of distance resulting in the inadequate clearance between the wing tip and the fuel truck.Apr 25, 2003 · N38137 · Substantial damageNTSB NYC03LA089Accident · No injuriesLimited investigationFinal reportCessna P206 · Newport, RIThe pilot's inadvertent encounter with propeller blast.Apr 24, 2003 · N4624F · Substantial damageNTSB LAX03LA149Accident · No injuriesLimited investigationFinal reportCessna 340A · Boulder City, NVthe airport committee members failure to repair or mark the faulty telephone junction box cover as a hazard. A factor in the accident was the inadequate notification process of the airport and city personnel.Apr 23, 2003 · N100UW · Substantial damage