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 CEN19TA196Accident · No injuriesFinal reportAeronca 65 C · Gilliam, LAThe pilot's failure to see and avoid a dark-colored utility pole while taxiing for takeoff.Jun 26, 2019 · N22173 · Substantial damageNTSB GAA19CA346Accident · No injuriesData collectionFinal reportCessna 152 · Greenville, TXThe passing pilot’s failure to maintain clearance from the airplane that he was attempting to pass during taxi operations. Contributing to the accident was the passing pilot's distraction due to looking at his on-board navigation device while attempting to…Jun 11, 2019 · N152TR · 2 aircraft · Substantial damageNTSB GAA19CA422Accident · No injuriesData collectionFinal reportDaryl Baker Bush Sport · Willimantic, CTThe pilot's failure to maintain directional control during taxi operations, which resulted in a collision with a fuel pump enclosure.May 31, 2019 · N4625D · Substantial damageNTSB CEN19WA203Incident · No injuriesForeign investigationCessna 560 · Elche, SpainThe government of Spain has notified the NTSB of an accident involving a CESSNA 560XL airplane that occurred on May 30, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Spain's investigation under the provisions of…May 30, 2019 · D-CGAANTSB GAA19CA312Accident · No injuriesData collectionFinal reportCessna 172 · Nogalas, AZThe student pilot's failure to maintain adequate clearance from a parked fuel truck. Contributing to the accident were the student’s failure to follow company policy and the flight instructor’s delayed remedial action.May 23, 2019 · N273EB · Substantial damageNTSB GAA19CA239Accident · No injuriesData collectionFinal reportGippsland GA8 · Bethel, AKThe pilot's failure to maintain adequate clearance from a shipping container while taxiing.May 2, 2019 · N524AV · Substantial damageNTSB GAA19CA220Accident · No injuriesData collectionFinal reportCessna 172 · Prescott, AZThe student pilot's failure to maintain clearance from a fence post during taxi operations.Apr 23, 2019 · N1897V · Substantial damageNTSB GAA19CA207Accident · No injuriesData collectionFinal reportNorth American SNJ · Chino, CAThe other pilot's failure to maintain clearance from a stopped airplane while taxiing.Apr 13, 2019 · N3375G · 2 aircraft · Substantial damageNTSB DCA19CA146Accident · Minor injuriesData collectionFinal reportMcdonnell Douglas MD88 · Atlanta, GAfailure of the tug driver to give way to the taxiing airplane.Apr 5, 2019 · N977DL · Substantial damageNTSB GAA19CA196Accident · No injuriesData collectionFinal reportPiper PA32 · Lakeland, FLThe pilot's failure to maintain clearance from a fence post during taxi to parking.Apr 3, 2019 · N4821S · Substantial damageNTSB ERA19TA146Accident · No injuriesClass 3Final reportCessna 172 · Fort Myers, FLThe pilot's failure to remain clear of a light pole while taxiing.Mar 30, 2019 · N4335R · Substantial damageNTSB CEN19LA113Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Spring, TXThe pilot’s failure to maintain airplane directional control while taxiing at an unsafe ground speed.Mar 28, 2019 · N494JB · Substantial damageNTSB CEN19LA108Accident · No injuriesClass 3 · LimitedFinal reportCessna A185 · Lafayette, LAThe pilot’s failure to maintain directional control during the landing roll.Mar 23, 2019 · N2744Q · Substantial damageNTSB GAA19CA190Accident · No injuriesData collectionFinal reportCessna 172 · Hollywood, FLThe other pilot's failure to maintain adequate clearance from the stopped airplane while attempting to taxi around it.Mar 21, 2019 · N20521 · 2 aircraft · Minor damageNTSB GAA19CA174Accident · No injuriesData collectionFinal reportPiper PA32R · Atmautluak, AKThe airplane's encounter with a snow-covered pothole during taxi.Mar 21, 2019 · N5544F · Substantial damageNTSB ERA19TA133Accident · No injuriesClass 3Final reportCessna 650 · Sanford, FLThe pilot's failure to keep the airplane on the taxiway while taxiing at night. Contributing to the accident was a miscommunication between the flight crewmembers about the position of the airplane.Mar 14, 2019 · N220CM · Substantial damageNTSB DCA19CA105Accident · No injuriesClass 4 · Data collectionFinal reportBoeing 737 · Atlanta, GAfailure of the B737 captain to maintain separation with the airplane stopped on the taxiway.Mar 11, 2019 · N3756 · 2 aircraft · Minor damageNTSB ERA19LA125Accident · No injuriesClass 3 · LimitedFinal reportPiper PA31 · Leesburg, FLMaintenance personnel’s improper rigging of the main landing gear actuators, which resulted in the collapse of the right main landing gear.Mar 8, 2019 · N45MJ · Substantial damageNTSB DCA19WA099Accident · No injuriesForeign investigationBeech 1900 · Ourgla, AlgeriaThe Civil Aviation Directorate (CAD) of Algeria has notified the NTSB of an accident involving a Beech 1900D, which occurred on March 3, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the CAD investigation under the provisions of ICAO…Mar 3, 2019 · 7T-VIO · Substantial damageNTSB GAA19CA148Accident · No injuriesData collectionFinal reportCessna 172 · Bellingham, WAThe pilot's improper crosswind correction during taxi operations in gusting crosswind conditions.Feb 25, 2019 · CFHGQ · Substantial damageNTSB GAA19CA149Accident · No injuriesData collectionFinal reportZenair Zenith Stol CH 701 · Springfield, ILThe pilot's improper crosswind correction during taxi operations in gusting crosswind conditions.Feb 24, 2019 · N8436S · Substantial damageNTSB GAA19CA141Accident · No injuriesData collectionFinal reportRobinson R22 · Clearwater, FLThe flight instructor's failure to maintain sufficient altitude over uneven terrain during a hover taxi, which resulted in ground contact and a subsequent dynamic rollover.Feb 19, 2019 · N512GS · Substantial damageNTSB GAA19CA130Accident · No injuriesData collectionFinal reportCessna 172 · Hanover, VAThe student pilot's improper decision to release the seat latch to adjust the seat position during taxi, which resulted in his inability to reach the rudder or brake pedals and a subsequent loss of directional control and impact with a ditch and fence.Feb 4, 2019 · N9525V · Substantial damageNTSB WPR19TA068Accident · Minor injuriesClass 3Final reportPitts S1 · Torrance, CAThe biplane pilot’s inadequate visual lookout while taxing, which resulted in a ground collision.Jan 19, 2019 · N31WK · 2 aircraft · Minor damageNTSB GAA19CA097Accident · No injuriesData collectionFinal reportCessna 180 · Moriarty, NMThe pilot's failure to see and avoid a parked glider while taxiing from the runway.Dec 15, 2018 · N188H · Substantial damageNTSB DCA19CA038Accident · Serious injuriesClass 4 · Data collectionFinal reportBoeing 737 · Chicago, ILan object which fell from an overhead bin struck a flight attendant resulting in a serious injury.Dec 3, 2018 · N868NN · No damageNTSB GAA19CA079Accident · No injuriesData collectionFinal reportPilatus PC12 · Mesa, AZThe other pilot's failure to follow the air traffic controller’s instructions and his subsequent failure to maintain adequate lookout to see and avoid the other airplane on the taxiway.Nov 28, 2018 · N552TC · 2 aircraft · Minor damageNTSB WPR19IA030Incident · Minor injuriesClass 3 · IncidentFinal reportCessna 208 · Bakersfield, CAThe pilot's loss of consciousness while taxiing due to an accumulation of toxic levels of carbon dioxide gas inside the airplane as a result of dry ice sublimation. Also causal was the pilot's decision to fly the airplane in an unventilated configuration, the…Nov 24, 2018 · N781FE · No damageNTSB ERA19LA055Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · North Myrtle Beach, SCThe failure of the right brake while taxiing after landing, which resulted in a loss of directional control and collision with a parked airplane.Nov 23, 2018 · N7081Q · Substantial damageNTSB GAA19CA071Accident · No injuriesData collectionFinal reportPiper PA28 · Miami, FLThe other pilot's improper decision to taxi past another airplane occupying a taxiway and her subsequent failure to maintain clearance from the airplane.Nov 20, 2018 · N607FT · 2 aircraft · Substantial damageNTSB DCA19WA020AccidentClass 5 · ForeignAirbus A330 · Paris, FranceOct 31, 2018 · N817NW · 2 aircraft · Minor damageNTSB GAA19CA082Accident · No injuriesData collectionFinal reportPiper PA28 · Waynesburg, PAThe student pilot's improper decision to maneuver the airplane through an area of construction and his subsequent failure to maintain clearance from a concrete pole barrier while taxiing.Oct 19, 2018 · N8222N · Substantial damageNTSB GAA19CA024Accident · No injuriesData collectionFinal reportCessna 172 · Vergennes, VTThe pilot's failure to maintain clearance from trees while taxiing.Oct 14, 2018 · N73345 · Substantial damageNTSB GAA19CA013Accident · No injuriesData collectionFinal reportCessna 140 · Marina, CAThe pilot’s inadvertent application of the brakes, which resulted in a nose-over.Oct 10, 2018 · N89266 · Substantial damageNTSB GAA19CA018Accident · No injuriesData collectionFinal reportPiper PA 16 · Manchester, WVA vehicle's incursion onto an active runway, which resulted in an evasive action by the pilot landing an airplane on that runway and a subsequent runway excursion.Oct 7, 2018 · N49WV · Substantial damageNTSB GAA19CA003Accident · No injuriesData collectionFinal reportCessna 152 · Farmingdale, NJThe pilot’s failure to maintain clearance from a vehicle while taxiing for departure.Oct 1, 2018 · N94658 · Substantial damageNTSB GAA18CA568Accident · No injuriesData collectionFinal reportCessna U206 · Millbrook, NYThe failure of the other pilot to yield to traffic established on the taxiway, which resulted in a ground collision.Sep 15, 2018 · N756FN · 2 aircraft · Substantial damageNTSB GAA18CA528Accident · No injuriesData collectionFinal reportBeech 200 · Burbank, CAThe flight instructor's and pilot receiving instruction's failure to maintain clearance from a tree while taxiing.Sep 3, 2018 · N97WC · Substantial damageNTSB GAA18CA491Accident · Minor injuriesData collectionFinal reportCessna U206 · Barter Island, AKThe pilot's failure to maintain lateral control while taxiing in gusting wind conditions.Aug 16, 2018 · N206JM · Substantial damageNTSB DCA21WA225AccidentClass 5 · ForeignBoeing 787 · Istanbul, TürkiyeAug 9, 2018 · CN-RGT · 2 aircraft · Substantial damageNTSB CEN18LA315Accident · No injuriesLimited investigationFinal reportColumbia Aircraft Mfg LC41-550FG · Dallas, TXThe pilot's inability to maintain directional control during taxi due to excessively worn brake pads and a deflated right main tire.Aug 3, 2018 · N2546B · Substantial damageNTSB GAA18CA445Accident · No injuriesData collectionFinal reportCirrus SR20 · Sanford, FLThe flight instructor's failure to maintain an appropriate approach speed in crosswind conditions, which resulted in the airplane landing long on the wet runway and his subsequent loss of directional control when he attempted to exit the runway at high speed…Jul 25, 2018 · N482DA · Substantial damageNTSB ERA18LA213Accident · No injuriesLimited investigationFinal reportPiper PA46 · West Columbia, SCThe pilot’s inadvertent navigation onto a service road instead of a taxiway, which resulted in a collision with a stop sign.Jul 25, 2018 · C-GRFF · Substantial damageNTSB CEN18WA393Accident · Minor injuriesForeign investigationAerospatiale AS350 · Wolfsberg, AustriaJul 20, 2018 · N36033 · Substantial damageNTSB GAA18CA588Accident · No injuriesData collectionFinal reportCessna 172 · Chicago, ILThe student pilot's failure to maintain clearance from a truck while taxiing.Jul 17, 2018 · N969RR · Substantial damageNTSB CEN18LA271Accident · No injuriesLimited investigationFinal reportSteen Skybolt · Lexington, TXThe fatigue failure of the main landing gear (MLG) truss, which resulted in the MLG spreading apart.Jul 14, 2018 · N22GL · Substantial damageNTSB ANC18LA049Accident · No injuriesClass 3 · LimitedFinal reportLearjet 60 · Salt Lake City, UTThe flight crew’s failure to fully disengage the parking brake before taxi, which resulted in a brake fire.Jun 26, 2018 · N57 · Substantial damageNTSB GAA18CA374Accident · No injuriesData collectionFinal reportBeech V35B · Chester, CTThe pilot’s failure to maintain clearance from a hangar during taxi.Jun 21, 2018 · N6KG · Substantial damageNTSB GAA18CA360Accident · No injuriesData collectionFinal reportCessna 172 · Salem, ILThe student pilot’s failure to maintain clearance from a pole while taxiing the airplane on the ramp.Jun 14, 2018 · N98395 · Substantial damageNTSB GAA18CA319Accident · Minor injuriesData collectionFinal reportCessna 172 · San Diego, CAThe biplane pilot’s failure to see and avoid the stopped airplane.Jun 3, 2018 · N786SA · 2 aircraft · Substantial damage