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 ANC12CA053Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Skwentna, AKThe pilot’s selection of unsuitable terrain for taxi.Jun 17, 2012 · N9488D · Substantial damageNTSB ANC12CA048Accident · No injuriesData collectionFinal reportCessna 207A · Platinum, AKThe pilot inadvertently taxied the airplane into a ditch.Jun 7, 2012 · N9874M · Substantial damageNTSB DCA12CA082Accident · No injuriesData collectionFinal reportBoeing 747 · Chicago, ILthe B747 Captain's failure to maintain a safe clearance between his wing and the tail of the EMB135 that was stopped on a taxiway.May 30, 2012 · B16481 · 2 aircraft · Minor damageNTSB CEN12CA329Accident · No injuriesData collectionFinal reportBrumbaugh B/Kasowski L Avid Flyer IV · Pryor, OKThe pilot's failure to maintain directional control during a high speed taxi.May 29, 2012 · N85AY · Substantial damageNTSB WPR12CA260Accident · No injuriesData collectionFinal reportCessna 172P · Hemet, CAThe student pilot's failure to monitor and maintain clearance from an obstacle during taxi.May 28, 2012 · N216AF · Substantial damageNTSB CEN12LA325Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Peoria, ILThe pilot’s loss of control while hover-taxiing.May 27, 2012 · N1UB · Substantial damageNTSB CEN12LA335Accident · No injuriesLimited investigationFinal reportShort Bros Shorts SD3-60 · Houston, TXThe pilots’ improper decision to burn fuel during the taxi by operating the engines at a higher-than-normal power setting and using the wheel brakes to control taxi speed, which resulted in a wheel fire.May 17, 2012 · N617FB · Substantial damageNTSB ERA12CA382Accident · No injuriesData collectionFinal reportBeech B90 · Savannah, GAThe pilot's failure to maintain adequate visual lookout while taxiing near a hangar, which resulted in airplane's right wingtip impacting the hangar door.May 12, 2012 · N275LE · Substantial damageNTSB ERA12LA296Accident · No injuriesLimited investigationFinal reportJones SA105 · New Smyrna Beach, FLThe failure of the nose landing gear wooden attachment/support structure, which resulted in collapse of the nose landing gear during taxi. Contributing to the accident was the improper design of the nose landing gear attachment structure.Apr 3, 2012 · N320WJ · Substantial damageNTSB CEN12CA226Accident · No injuriesData collectionFinal reportRuiz E RAF 2000 · Anahuac, TXThe student pilot's improper nosewheel and cyclic positioning during the taxi, which resulted in the gyroplane's main rotor contacting the runway surface. Contributing to the accident was the flight instructor’s inadequate supervision.Mar 31, 2012 · N9012R · Substantial damageNTSB CEN12LA220Accident · No injuriesLimited investigationFinal reportCirrus Design SR22T · Addison, TXMaintenance personnel’s improper maintenance, which resulted in the incorrect wiring of the No. 1 alternator and a subsequent electrical system fire during taxi. Contributing to the accident was the airplane manufacturer's inadequate maintenance documentation…Mar 23, 2012 · N229TX · Substantial damageNTSB ERA12CA216Accident · No injuriesData collectionFinal reportAir Tractor AT-502B · Hollandale, MSThe pilot's failure to maintain directional control while taxiing in gusty wind conditions.Mar 7, 2012 · N9148C · Substantial damageNTSB CEN12LA171Accident · Minor injuriesLimited investigationFinal reportCessna R172E · Denver, COThe pilot's improper decision to taxi in wind conditions that exceeded the airplane’s capability.Feb 27, 2012 · N3196F · Substantial damageNTSB ERA12CA173Accident · No injuriesData collectionFinal reportAeropro CZ Eurofox LSA · Winter Haven, FLThe flight instructor’s delayed remedial action to prevent the airplane from hitting the hangar door. Contributing to the accident was the student pilot's misuse of the airplane's throttle, and his incorrect use of the wheel brakes.Feb 7, 2012 · N701CF · Substantial damageNTSB ERA12LA147Accident · No injuriesLimited investigationFinal reportBoeing DHC-8-102 · Huntington, WVThe inadequate communication among ground crew personnel, which resulted in the airplane’s collision with a deice truck.Jan 16, 2012 · N839EX · Substantial damageNTSB DCA12WA027Incident · No injuriesForeign investigationBoeing 777 · Rio de Janeiro, BrazilThe Brazilian Centro de Investigação e Prevenção deAcidentes Aeronáuticos (CENIPA) has notified the NTSB of an incident involving a Boeing 777 that occurred on January, 14, 2012. The NTSB has appointed a U.S. Accredited Representative to assist the CENIPA…Jan 14, 2012 · N790AN · No damageNTSB DCA12WA103Incident · No injuriesForeign investigationBoeing 737-800 · Stockholm, SwedenOn January 7, 2012, the left winglet of a Boeing 737-800, TC-SNM, operated by SunExpress, impacted the right horizontal stabilizer of a parked airplane while taxiing at the Arlanda Airport (ARN), Stockholm, Sweden. There were no reported injuries to the…Jan 7, 2012 · TC-SNM · Minor damageNTSB WPR12LA074Accident · No injuriesLimited investigationFinal reportCzech Sportplanes Sro Dynamic WT9 · Glendale, AZThe pilot did not shut down the engine upon recognizing a brake malfunction. Contributing to the accident was the airplane's brake malfunction for undetermined reasons.Jan 6, 2012 · N247DY · Substantial damageNTSB ANC12CA015Accident · No injuriesData collectionFinal reportPiper PA-31-350 · Hughes, AKThe pilot did not clear the area surrounding the airplane prior to taxi, resulting in the airplane contacting a piece of baggage.Dec 15, 2011 · N9FW · Substantial damageNTSB CEN12CA084Accident · No injuriesData collectionFinal reportCessna 550 · Moline, ILThe pilot's failure to maintain clearance from the parked, unoccupied airplane while taxiing. Contributing to the accident was the guidance provided by the marshaller.Nov 23, 2011 · N544PS · Substantial damageNTSB WPR12LA045Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Boulder City, NVThe pilot's failure to maintain directional control while taxiing with a gusting crosswind.Nov 19, 2011 · N9016K · Substantial damageNTSB OPS12WA150Incident · No injuriesForeign investigationEmbraer EMB-145LR · Toronto, CanadaOn November 18, 2011, American Eagle (EGF) flight 4125, an EMB-145, landed on runway 24L at Toronto Lester B. Pearson International Airport (CYYZ) and exited the runway at taxiway D4 with instructions to hold short of runway 24R. EGF4125 subsequently crossed…Nov 18, 2011 · N620AE · No damageNTSB ERA12LA066Accident · No injuriesLimited investigationFinal reportCessna 172S · Fort Lauderdale, FLThe Cessna 172 flight instructor and student pilot's inadequate visual lookout and failure to maintain clearance from the stationary Cessna 182.Nov 3, 2011 · N1855Y · 2 aircraft · Substantial damageNTSB CEN12CA017Accident · No injuriesData collectionFinal reportLearjet 60 · Lafayette, INThe pilot's decision to taxi the airplane across an unpaved area after the nosewheel inadvertently departed the ramp pavement.Oct 12, 2011 · N64MG · Substantial damageNTSB WPR12CA003Accident · No injuriesData collectionFinal reportCessna 172P · AganaThe pilot's failure to avoid the jet blast while taxiing and the ground air traffic controller's failure to advise the pilot of the hazard.Oct 6, 2011 · N9853L · Substantial damageNTSB CEN12CA005Accident · No injuriesData collectionFinal reportCampbell John Mustang II · Brush, COThe pilot’s failure to maintain directional control during taxi, which resulted in a runway excursion.Oct 2, 2011 · N287BM · Substantial damageNTSB WPR11LA477Accident · No injuriesLimited investigationFinal reportStarduster II SA-300 · West Jordan, UTThe pilot of the other airplane's inadequate visual lookout, which resulted in a collision with the standing airplane.Sep 24, 2011 · N23UT · 2 aircraft · Minor damageNTSB CEN11CA664Accident · No injuriesData collectionFinal reportBoeing E75 · Houston, TXThe pilot of the other airplane’s failure to maintain visual contact while taxiing.Sep 24, 2011 · N54087 · 2 aircraft · Substantial damageNTSB WPR11CA456Accident · No injuriesData collectionFinal reportCub Crafters CC11-100 · San Jose, CAThe pilot's failure to maintain directional control while taxiing due to his distraction by a cockpit warning light.Sep 17, 2011 · N468CB · Substantial damageNTSB CEN11CA644Accident · No injuriesData collectionFinal reportCessna 120 · Camden, ARThe flight instructor's inadvertent braking during taxi.Sep 12, 2011 · N89954 · Substantial damageNTSB WPR11LA427Accident · No injuriesLimited investigationFinal reportStinson V77 · Tillamook, ORThe pilot’s loss of directional control while taxiing in a gusting tailwind.Sep 3, 2011 · N9112H · Substantial damageNTSB CEN11CA689Accident · Minor injuriesData collectionFinal reportPiper J3L-65 · Gainesville, TXThe pilot’s failure to maintain directional control during taxi, which resulted in a runway excursion.Sep 3, 2011 · N30950 · Substantial damageNTSB ERA11CA486Accident · No injuriesData collectionFinal reportPiper PA-44-180 · Gaithersburg, MDThe pilot's decision to continue taxiing with restricted windshield visibility.Aug 26, 2011 · N3020M · Substantial damageNTSB WPR11CA446Accident · No injuriesData collectionFinal reportCessna 182A · Prescott, AZThe pilot's failure to maintain directional control while taxiing.Aug 20, 2011 · N3723D · Substantial damageNTSB WPR11CA376Accident · No injuriesData collectionFinal reportCessna 172P · San Diego, CAThe student pilot's failure to maintain clearance from obstacles while taxiing.Aug 14, 2011 · N216AF · Substantial damageNTSB CEN11CA523Accident · No injuriesData collectionFinal reportCessna 195 · Oshkosh, WIThe failure of the left brake which resulted in a ground-loop.Jul 28, 2011 · N195SM · Substantial damageNTSB WPR11CA347Accident · No injuriesData collectionFinal reportCessna 182B · Sandy, ORThe pilot's failure to maintain adequate clearance between the airplane and ground obstacles.Jul 24, 2011 · N8426T · Substantial damageNTSB CEN11LA504Accident · No injuriesLimited investigationFinal reportQuasar Acft 214SL · Fort Worth, TXA fuel leak in the engine compartment, which resulted in an engine fire.Jul 22, 2011 · N89QL · Substantial damageNTSB WPR11CA337Accident · No injuriesData collectionFinal reportCessna 172N · Porthill, IDThe pilot's failure to maintain clearance from a pole.Jul 17, 2011 · N733BT · Substantial damageNTSB ERA11CA387Accident · No injuriesData collectionFinal reportCessna 150C · Weirsdale, FLThe pilot's failure to maintain adequate clearance from the stopped trailer while taxiing.Jul 2, 2011 · N1953Z · Substantial damageNTSB WPR11CA294Accident · No injuriesData collectionFinal reportCessna 172N · Olympia, WAThe pilot's failure to maintain clearance from obstacles.Jun 26, 2011 · N5366J · Substantial damageNTSB ERA11LA361Accident · No injuriesLimited investigationFinal reportBeech A60 · Pompano Beach, FLThe pilots of both airplanes did not maintain adequate visual lookout during taxi, which resulted in an on-ground collision.Jun 26, 2011 · N38N · 2 aircraft · Minor damageNTSB ERA11LA357Accident · No injuriesLimited investigationFinal reportCessna 182F · Warrenton, VAThe fatigue failure of the left main landing gear due to inadequate maintenance inspection that did not detect and correct corrosion pitting.Jun 23, 2011 · N3152U · Substantial damageNTSB ERA11CA371Accident · No injuriesData collectionFinal reportCessna 172M · North Adams, MAThe pilot's inadequate visual lookout and subsequent failure to maintain clearance from a light pole while taxiing.Jun 19, 2011 · N12477 · Substantial damageNTSB WPR11CA264Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Prescott, AZThe pilot's inadequate compensation for the wind conditions and failure to maintain directional control of the helicopter during taxi, resulting in a loss of tail rotor effectiveness and a subsequent hard landing.Jun 18, 2011 · N334DC · Substantial damageNTSB ANC11CA053Accident · No injuriesData collectionFinal reportPiper PA-18A · McCarthy, AKThe pilot's failure to maintain control of the airplane while taxiing in gusty wind conditions.Jun 15, 2011 · N1858A · Substantial damageNTSB WPR11CA257Accident · No injuriesData collectionFinal reportMooney M20K · Page, AZThe pilot's selection of the wrong taxi route and failure to follow prescribed taxi procedures.Jun 12, 2011 · N5765D · Substantial damageNTSB WPR11CA252Accident · No injuriesData collectionFinal reportAir Tractor AT-502B · Odessa, WAThe pilot's failure to maintain clearance from the other aircraft.Jun 7, 2011 · N6072X · 2 aircraft · Minor damageNTSB ANC11CA035Accident · No injuriesData collectionFinal reportPiper PA-18A · Coldfoot, AKThe pilot's failure to maintain control of the airplane while taxiing in gusty wind conditions.May 20, 2011 · N9279D · Substantial damageNTSB CEN11CA343Accident · No injuriesData collectionFinal reportMooney M20J · Greenfield, INThe pilot's failure to maintain adequate clearance from a communications cart while taxiing.May 13, 2011 · N10143 · Substantial damage