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 ANC99LA153Accident · No injuriesLimited investigationFinal reportCessna 207 · Bethel, AKThe pilot's failure to maintain a visual lookout for a parked airplane during taxi.Sep 17, 1999 · N36CF · Substantial damageNTSB LAX99LA306Accident · No injuriesLimited investigationFinal reportCessna 172N · San Jose, CAThe pilot's failure to maintain an adequate visual lookout during taxi. Sun glare was a factor in the accident.Sep 12, 1999 · N534CA · Substantial damageNTSB LAX99LA309Accident · No injuriesLimited investigationFinal reportCessna 172N · Carlsbad, CAThe pilot's failure to maintain an adequate clearance from obstacles during taxi in a confined space.Sep 5, 1999 · N733WX · Substantial damageNTSB FTW99LA246Accident · No injuriesLimited investigationFinal reportCessna 170A · Brady, TXThe pilot's failure to maintain clearance from a dirt bank.Sep 3, 1999 · N3865V · Substantial damageNTSB MIA99LA241Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Winter Haven, FLthe pilot-in command/flight instructor allowed the student pilot to get the nose of the airplane too low in the water causing a loss of directional control and a subsequent impact of the right wing in the water.Aug 29, 1999 · N8002H · Substantial damageNTSB LAX99LA284Accident · No injuriesLimited investigationFinal reportAerospatiale AS350B3 · Long Beach, CAThe failure of the pilot to maintain clearance with the fence while landing. A factor was the failure of the helipad to meet the obstacle clearance design criteria specified in FAA Advisory Circular guidance.Aug 26, 1999 · N5224R · Substantial damageNTSB CHI99LA312Accident · No injuriesLimited investigationFinal reportCessna 172M · Bloomington, ILthe pilot's inadequate visual lookout and not performing a maneuver to avoid obstructions. A factor was the road signs.Aug 26, 1999 · N61612 · Substantial damageNTSB IAD99IA059Incident · No injuriesIncident investigationFinal reportBoeing 727-200 · Washington, DCThe inadequate lubrication of the landing gear side strut assembly by company maintenance personnel. A factor in the accident was the inadequate design of the assembly that trapped water and prevented adequate lubrication.Aug 23, 1999 · N926TS · Minor damageNTSB FTW99LA245Accident · No injuriesLimited investigationFinal reportCessna 150K · Springdale, ARThe inadequate visual lookout by both pilots.Aug 23, 1999 · N6015G · 2 aircraft · Substantial damageNTSB SEA99LA147Accident · No injuriesLimited investigationFinal reportCessna 180A · Belgrade, MTClearance from objects was not maintained during taxiing. Factors include the pilot's inadequate visual lookout.Aug 21, 1999 · N5359D · Substantial damageNTSB FTW99LA232Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-151 · Houston, TXThe failure of the pilot to maintain clearance with the person (the airport manager) walking on the taxiway and the inadequate visual lookout by the airport manager. A factor was the airport manager's diverted attention to the aircraft accident.Aug 20, 1999 · N43404 · Minor damageNTSB CHI99LA302Accident · No injuriesLimited investigationFinal reportCessna 150K · Kenosha, WIThe pilot's attention being diverted into the cockpit and not maintaining visual separation with the fuel truck. A factor in the accident was the fuel truck.Aug 14, 1999 · N6001G · Substantial damageNTSB DEN99IA136Incident · No injuriesIncident investigationFinal reportBeech 1900D · Denver, COSee cause/factor narrative for DEN 99-I-A136A.Aug 5, 1999 · N101UX · 2 aircraft · Minor damageNTSB CHI99IA204Incident · No injuriesIncident investigationFinal reportBoeing 767-323 · Chicago, ILthe pilot's failure to maintain clearance from the parked aircraft while taxiing. A factor in the accident was the failure of ATC to issue a traffic advisory.Jun 29, 1999 · N384AA · Minor damageNTSB ANC99LA080Accident · No injuriesLimited investigationFinal reportTaylorcraft BC-12D · North Pole, AKThe pilot's inadvertent ground loop during a high speed taxi. A factor associated with the accident is the pilot's decision to taxi the airplane at an excessive taxi speed.Jun 24, 1999 · N95064 · Substantial damageNTSB DEN99LA100Accident · No injuriesLimited investigationFinal reportButler SX-300 · Hill Afb, UTA failure of the left main landing gear attachment for undetermined reasons.Jun 12, 1999 · N120J · Substantial damageNTSB LAX99FA218Accident · No injuriesField investigationFinal reportBoeing 747-4F6B · Los Angeles, CAAirport management's failure to ensure that its current operating procedure, which required the arriving airplane to power into the terminal gate, was being used. Also causal was (1) the ground service company's utilization of an outdated arrival procedure…Jun 7, 1999 · N751PR · 2 aircraft · Minor damageNTSB LAX99LA195Accident · No injuriesLimited investigationFinal reportBeech A36 · Willows, CAThe failure of the pilot to maintain an adequate clearance with a parked trailer while taxiing the aircraft.May 21, 1999 · N8178N · Substantial damageNTSB ANC99LA063Accident · No injuriesLimited investigationFinal reportTaylorcraft F-19 · Anchorage, AKThe pilot misjudging the taxi clearance between the airplane's wingtip and the parked vehicle.May 19, 1999 · N3585T · Substantial damageNTSB ANC99LA062Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Dillingham, AKThe inadequate preflight by the pilot, who left the rudder gust lock installed, making directional control not possible.May 16, 1999 · N8883C · Substantial damageNTSB CHI99TA149Accident · Minor injuriesFinal reportCessna 180J · Necedah, WIThe pilot's failure to maintain compensation for the wind conditions. A factor was the gusting tailwind.May 10, 1999 · N59DW · Substantial damageNTSB LAX99LA172Accident · No injuriesLimited investigationFinal reportBeech A36 · San Diego, CAThe pilot's failure to maintain a visual lookout while taxiing resulting in the aircraft's colliding with a runway sign. Contributing factors were dusk light conditions, the sign, and the pilot's diverting his attention to aircraft instrumentation during taxi.May 6, 1999 · N6034X · Substantial damageNTSB LAX99LA169Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Lancaster, CAThe pilot's decision to attempt a ground turning maneuver in wind conditions beyond the capability of the aircraft.May 4, 1999 · N2403E · Substantial damageNTSB DEN99LA069Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Fort Collins, COThe pilot's inadequate compensation for wind conditions. A factor was the gusty wind conditions.May 4, 1999 · N6563H · Substantial damageNTSB NYC99LA104Accident · No injuriesLimited investigationFinal reportCessna 172 · Columbus, OHThe pilot's failure to maintain obstacle clearance and his visual perception of the perimeter road as Taxiway Charlie. A factor in the accident was the absence of a sign identifying the perimeter road.May 2, 1999 · N5815E · Substantial damageNTSB SEA99LA055Accident · No injuriesLimited investigationFinal reportPiper J-3 · Vancouver, WAThe failure of the pilot of the other aircraft to maintain clearance from the pilot's stationary aircraft.Apr 22, 1999 · N48612 · 2 aircraft · Substantial damageNTSB LAX99LA132Accident · No injuriesLimited investigationFinal reportCessna 172B · Winslow, AZThe pilot's decision to continue flight into known adverse wind conditions which exceeded the ground handling capability of the aircraft.Mar 31, 1999 · N7882X · Substantial damageNTSB NYC99IA079Incident · No injuriesIncident investigationFinal reportCessna 550 · State College, PAImproper assembly of the left main landing gear (LMLG) actuator by the airplane manufacturer, which resulted in an incorrect 'locked' indication on the LMLG switch, and the subsequent collapse of the LMLG during taxi.Mar 25, 1999 · N37MH · Minor damageNTSB LAX99LA127Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Scottsdale, AZThe failure of the local and ground controller to coordinate the clearances of both aircraft and to maintain separation of the traffic in the taxiway movement area.Mar 22, 1999 · N4188E · 2 aircraft · Substantial damageNTSB CHI99LA107Accident · No injuriesLimited investigationFinal reportPiper J4A · Howell, MIthe pilot's failure to maintain clearance with the snow covered terrain off the side of the runway while turning the airplane around on the runway. A factor associated with the accident was the snow covered terrain.Mar 14, 1999 · N30412 · Substantial damageNTSB LAX99LA117Accident · No injuriesLimited investigationFinal reportPiper PA-28-150 · Rubidoux, CAThe pilot's failure to maintain adequate clearance from parked airplanes while taxiing due to his diverted attention.Mar 13, 1999 · N5346W · Substantial damageNTSB DEN99LA050Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Santa Rosa, NMThe unfavorable wind gust which inverted the airplane while taxiing.Mar 8, 1999 · N8470K · Substantial damageNTSB SEA99FA037Accident · No injuriesField investigationFinal reportHiller UH-12E · Yellow Pine, IDAltitude deviation during aerial taxi for undetermined reasons.Feb 28, 1999 · N2239 · Substantial damageNTSB CHI99LA097Accident · No injuriesLimited investigationFinal reportCessna 182E · East Troy, WIthe collapse of the right main landing gear from a preexisting fatigue crack.Feb 21, 1999 · N3177Y · Substantial damageNTSB MIA99LA083Accident · No injuriesLimited investigationFinal reportBeech A24R · Philadelphia, MSThe failure of the pilot to ensure the aircraft tie down ropes were free from the aircraft prior to taxiing. This resulted in the aircraft turning uncontrolled when taxi was initiated due to a partially tied left wing, the pilot loosing control of the…Feb 13, 1999 · N24624 · Substantial damageNTSB NYC99LA057Accident · No injuriesLimited investigationFinal reportCessna 310R · Monticello, NYThe pilot in command's loss of directional control.Feb 10, 1999 · N87464 · Substantial damageNTSB DEN99LA036Accident · No injuriesLimited investigationFinal reportCessna 208B · Cody, WYThe pilot's inability to maintain aircraft control due to unfavorable winds conditions.Feb 3, 1999 · N980FE · Substantial damageNTSB ANC99TA026Accident · No injuriesFinal reportPiper PA-18-150 · Anchorage, AKThe pilot's use of excessive taxispeed. Factors associated with the accident were an icy taxi area, and the inadvertent activation of the throttle.Feb 3, 1999 · N7875D · Substantial damageNTSB LAX99LA086Accident · No injuriesLimited investigationFinal reportCessna 150L · Madera, CAThe pilot's failure to maintain an adequate visual lookout and to see the stationary airplane on the taxiway ahead.Jan 30, 1999 · N6979G · 2 aircraft · Substantial damageNTSB FTW99LA071Accident · No injuriesLimited investigationFinal reportCessna 172E · Guymon, OKThe pilot's failure to maintain aircraft control. A factor was the gusty crosswind.Jan 26, 1999 · N5606T · Substantial damageNTSB MIA99LA068Accident · No injuriesLimited investigationFinal reportCessna 310N · Clearwater, FLa ground fire in the left wing due to an undetermined ignition source.Jan 25, 1999 · N5080Q · Substantial damageNTSB LAX99LA079Accident · No injuriesLimited investigationFinal reportCessna 152 · Phoenix, AZThe CFI's loss of airplane control upon encountering a dust devil due to his improper in-flight decision to land in proximity to the observed adverse weather conditions.Jan 21, 1999 · N96640 · Substantial damageNTSB ANC99LA020Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Anchorage, AKThe failure of the driver of a vehicle to maintain an adequate visual lookout.Jan 5, 1999 · N6GR · Substantial damageNTSB LAX99LA059Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · North Las Vegas, NVFailure of the pilot-in-command of the other aircraft to see and avoid the stationary Cessna TR182.Dec 28, 1998 · N87714 · 2 aircraft · Minor damageNTSB LAX99LA069Accident · No injuriesLimited investigationFinal reportCessna 182G · San Andreas, CAThe other pilot's failure to maintain an adequate visual lookout while taxiing in a confined area between rows of parked aircraft.Dec 27, 1998 · N3787U · 2 aircraft · Substantial damageNTSB ANC99IA019Incident · No injuriesIncident investigationFinal reportCessna 207 · Kotzebue, AKThe pilot's selection of the wrong taxi route. A factor associated with this incident was the absence of taxiway lighting or marking.Dec 23, 1998 · N1864 · Minor damageNTSB CHI99LA051Accident · No injuriesLimited investigationFinal reportCessna 152 · Evansville, INthe student pilot's inability to gain clearance between the airplane and the hanger. Factors contributing to this accident were the wet, grass landing surface, the student pilot's attempted turn to avoid the embankment drop off at the end of the runway, the…Dec 10, 1998 · N25493 · Substantial damageNTSB LAX99TA043Accident · No injuriesFinal reportPiper PA-18-150 · Imperial, CAThe pilot's inadequate compensation for the gusty wind conditions while taxiing from landing.Dec 4, 1998 · N82325 · Substantial damageNTSB NYC99LA029Accident · Minor injuriesLimited investigationFinal reportBoeing 747-400 · Jamaica, NYThe first officer misjudged the clearance between the right wing and the crane. Factors included the subcontractor's unauthorized placement of the crane in the taxiway safety area and insufficient oversight of the subcontractor's operations.Nov 30, 1998 · HL*** · Substantial damageNTSB CHI99LA038Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Hancock, MIthe pilot became disoriented while taxiing at an unfamiliar airport and his failure to reduce engine power when the airplane departed the paved surface. Factors associated with the accident were the dark night condition, the pilot did not follow the correct…Nov 25, 1998 · N5256T · Substantial damage