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 ERA10CA165Accident · No injuriesData collectionFinal reportCessna P210N · Miami, FLThe pilot's failure to see and avoid an unlit and unmarked helicopter dolly while taxiing at night.Mar 6, 2010 · N34VF · Substantial damageNTSB WPR10IA135Incident · No injuriesIncident investigationFinal reportEmbraer EMB-120ER · Los Angeles, CAThe flight crew’s failure to maintain clearance from the jet bridge during taxi. Contributing to the incident was the ramp marshaller's diverted attention and failure to signal the flight crew to stop at the correct position.Feb 16, 2010 · N226SW · Minor damageNTSB ANC10CA015Accident · No injuriesData collectionFinal reportCessna 172H · Nightmute, AKThe pilot's failure to maintain control of the airplane in a strong gusting wind, and his decision to taxi for takeoff in such conditions.Jan 23, 2010 · N3718F · Substantial damageNTSB ANC10LA012Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Gulkana, AKThe pilot's selection of unsuitable terrain for landing, which resulted in structural damage to the airplane during landing.Jan 14, 2010 · N3233M · Substantial damageNTSB CEN10CA082Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Abilene, TXThe pilot's failure to maintain directional control during the air taxi with shifting winds.Dec 18, 2009 · N442RS · Substantial damageNTSB WPR10CA079Accident · No injuriesData collectionFinal reportCurtiss Wright Travel AIR 4000 · Torrance, CAThe Travel Air pilot's failure to maintain an adequate visual lookout during taxi.Nov 29, 2009 · N8700 · 2 aircraft · No damageNTSB ERA10CA065Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Georgetown, KYThe pilot's failure to maintain adequate clearance from the surface during lateral hover, which resulted in dynamic rollover.Nov 14, 2009 · N2374 · Substantial damageNTSB ERA10CA064Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Pahokee, FLThe pilot’s failure to maintain control of the helicopter.Nov 14, 2009 · N74632 · Substantial damageNTSB DCA10IA006Incident · No injuriesIncident investigationFinal reportBoeing 767 · Dulles International Airport, VAThe failure of the lead and left side marshallers to identify the B40 jetway obstacle and stop the airplane's taxi before the wingtip contacted the jetway. Contributing to the cause of this incident were inadequate marshalling procedures used by the ground…Nov 4, 2009 · G-BNWY · Minor damageNTSB ERA10CA039Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Scranton, SCThe pilot’s failure to maintain control of the helicopter.Oct 24, 2009 · N822U · Substantial damageNTSB WPR09CA473Accident · No injuriesData collectionFinal reportAviat A-1B · Toledo, WAThe pilot's failure to maintain clearance from a tree while taxiing. Contributing to the accident was the pilot's distracted attention.Sep 27, 2009 · N445BB · Substantial damageNTSB CEN09CA600Accident · No injuriesData collectionFinal reportCessna 402B · Omaha, NEThe pilot’s improper decision to taxi with an obstructed windscreen and his failure to maintain clearance from the parked airplane.Sep 22, 2009 · N1048 · Substantial damageNTSB WPR09CA461Accident · No injuriesData collectionFinal reportCessna 172S · San Carlos, CAThe student pilot's failure to maintain clearance with a fence post during taxi.Sep 21, 2009 · N21591 · Substantial damageNTSB ERA09CA548Accident · No injuriesData collectionFinal reportPiper PA-20 · Herlong, FLThe pilot’s improper visual lookout while taxing on soft terrain.Sep 13, 2009 · N7705K · Substantial damageNTSB WPR09CA447Accident · No injuriesData collectionFinal reportCessna 172P · Long Beach, CAThe pilot’s failure to maintain clearance from a parked vehicle during taxi.Sep 8, 2009 · N51594 · Substantial damageNTSB WPR09CA438Accident · No injuriesData collectionFinal reportBeech S35 · Fallon, NVThe pilot's failure to maintain clearance from an obstacle during taxi.Sep 8, 2009 · N272D · Substantial damageNTSB WPR09CA433Accident · No injuriesData collectionFinal reportSwalley Mark H CH 701 SP · Bremerton, WAThe pilot's inadequate compensation for the gusty wind conditions and failure to maintain aircraft control.Sep 7, 2009 · N701V · Substantial damageNTSB ERA09LA506Accident · No injuriesLimited investigationFinal reportCessna 140 · Louisa, VAThe Cessna pilot's inadequate visual lookout.Sep 5, 2009 · N3656V · 2 aircraft · Minor damageNTSB ERA09CA508Accident · No injuriesData collectionFinal reportMooney 231 · Charlottesville, VAThe pilot’s inadequate preflight planning and lack of familiarity with the airport diagram, which resulted in a runway excursion onto a grassy area.Sep 4, 2009 · N75PW · Substantial damageNTSB CEN09LA541Accident · Serious injuriesLimited investigationFinal reportCessna CE-560 · Kremmling, COThe lineman’s inadvertent encounter with jet blast.Aug 23, 2009 · N802QS · No damageNTSB WPR09CA416Accident · No injuriesData collectionFinal reportMorgan James E Morgan RV6 · Everett, WAThe pilot’s failure to maintain clearance from objects during taxi. Contributing to the accident was the inadequate marking of the taxiway and obstacles.Aug 21, 2009 · N116JM · Substantial damageNTSB ERA09TA466Accident · No injuriesFinal reportCessna 180 · Spartanburg, SCThe Cessna pilot's inadequate visual lookout.Aug 15, 2009 · N1044Y · 2 aircraft · Substantial damageNTSB ANC09LA069Accident · No injuriesLimited investigationFinal reportCessna 172L · Anchorage, AKThe pilot's unfamiliarity with the airport environment, which resulted in his taxiing the airplane onto a no-taxi section of roadway and into a road sign. Contributing to the accident was the pilot's failure to avail himself of additional information that…Jul 18, 2009 · N7136Q · Substantial damageNTSB CEN09CA493Accident · Minor injuriesData collectionFinal reportDiamond Aircraft Ind DA 40 · Cape Girardeau, MOThe airplane's inoperative brakes while taxiing. Contributing to the accident was the pilot's inadequate preflight.Jul 14, 2009 · N544DS · Substantial damageNTSB CEN09CA457Accident · No injuriesData collectionFinal reportCessna 310 · Fort Worth, TXThe failure of the pivot pin in the side brace of the right main landing gear resulting in the gear collapse during taxi for undetermined reasons.Jul 10, 2009 · N3106L · Substantial damageNTSB ANC09LA064Accident · No injuriesLimited investigationFinal reportDouglas DC-3C · Skwentna, AKA fracture of the airplane's tailwheel shock absorber linkage during taxi, resulting in the collapse of the tailwheel.Jul 7, 2009 · N777YA · Substantial damageNTSB ERA09CA391Accident · No injuriesData collectionFinal reportCessna 172RG · Morristown, NJThe pilot's failure to maintain clearance from a parked aircraft during taxi operations.Jul 4, 2009 · N751DW · Substantial damageNTSB CEN09TA399Accident · No injuriesFinal reportCessna 182 · Cookson, OKThe pilot's failure to maintain clearance with the building while taxiing on a road.Jun 20, 2009 · N60HP · Substantial damageNTSB OPS09IA007Incident · No injuriesIncident investigationFinal reportBoeing 737-7H4 · Cleveland, OHThe ground controller did not issue taxi instructions in accordance with FAA Order 7110.65, paragraph 3-7-2. The local controller did not scan the runways prior to issuing a taxi into position and hold instruction to SWA1080 as required by FAA Order 7110.65…Jun 3, 2009 · N299WN · 2 aircraft · No damageNTSB WPR09CA274Accident · No injuriesData collectionFinal reportPiper PA-38-112 · Grangeville, IDThe pilot's failure to maintain clearance from an obstacle during taxi.May 28, 2009 · N25353 · Substantial damageNTSB WPR09LA255Accident · No injuriesLimited investigationFinal reportEmbraer EMB-135 · Los Angeles, CAThe flight crew's failure to adequately monitor and maintain clearance from a parked aircraft while taxiing. Contributing to the accident was an improperly parked airplane that encroached upon the taxiway area.May 21, 2009 · N843AE · Substantial damageNTSB ANC09CA041Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Kenai, AKThe pilot's failure to maintain clearance from a tree while taxiing.May 14, 2009 · N405TH · Substantial damageNTSB OPS09IA004Incident · No injuriesIncident investigationFinal reportBE20 · Camp Springs, MDThe failure of the ground controller to coordinate the runway crossings with the local controller and her failure to scan the runway prior to issuing the crossing instructions. Contributing to the incident was the combination of the front line manager/tower…May 13, 2009 · VM206 · No damageNTSB ERA09LA266Accident · No injuriesLimited investigationFinal reportDouglas DC3 · San Juan, PRWorn electrical wires and a fuel pressure indicating system hose, which resulted in a ground fire during taxi.Apr 26, 2009 · N136FS · Substantial damageNTSB CEN09CA268Accident · No injuriesData collectionFinal reportLuscombe 8 · Terrell, TXThe failure of the landing gear due to undetected corrosion.Apr 22, 2009 · N2330K · Substantial damageNTSB WPR09LA211Accident · No injuriesLimited investigationFinal reportDe Havilland DHC-8 · Phoenix, AZThe failure of ramp personnel and the flight crew to maintain clearance from ground equipment while taxiing. Contributing to the accident was the improper positioning of the ground equipment.Apr 21, 2009 · N449YV · Substantial damageNTSB ERA09LA269Accident · No injuriesLimited investigationFinal reportCessna 208 · Frederick, MDA loss of engine power due to the failure of one or more compressor turbine blades for an undetermined reason.Apr 21, 2009 · N208JW · Substantial damageNTSB ERA09CA227Accident · No injuriesData collectionFinal reportPiper PA-31-325 · Newark, NJThe pilot's decision to continue to operate the airplane with inoperative brakes on the airplane's right side.Apr 2, 2009 · N707AG · Substantial damageNTSB WPR09FA165Accident · No injuriesField investigationFinal reportBeech 200 · Henderson, NVThe pilot's failure to monitor and maintain clearance from an obstacle during taxi.Mar 23, 2009 · N257NA · Substantial damageNTSB ERA09CA216Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Atlanta, GAThe failure of the pilot to maintain clearance with a parked airplane.Mar 18, 2009 · N748CD · Substantial damageNTSB CEN09IA222Incident · No injuriesIncident investigationFinal reportBell 206 · Springfield, ILThe pilot's failure to maintain clearance from the parked helicopter.Mar 17, 2009 · N595AE · Minor damageNTSB CEN09CA212Accident · No injuriesData collectionFinal reportPiper PA28-151 · Gardner, KSThe pilot's failure to ensure adequate clearance between the airplane's right wing and the building.Mar 15, 2009 · N43181 · Substantial damageNTSB ERA09LA199Accident · No injuriesLimited investigationFinal reportShniderman Ervin Stanley LONG-EZ · Manassas, VAA fire of undetermined origin in the engine compartment.Mar 14, 2009 · N770EZ · Substantial damageNTSB ERA09LA198Accident · 1 fatalLimited investigationFinal reportMcNear Explorer Coupe · Okeechobee, FLThe pilot's failure to maintain directional control of the gyrocopter while taxiing for takeoff.Mar 14, 2009 · N5098L · Substantial damageNTSB ANC09CA033Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Fairbanks, AKThe pilot's selection of unsuitable terrain for landing, which resulted in the main landing gear collapsing during taxi.Feb 27, 2009 · N3578Z · Substantial damageNTSB CEN09CA181Accident · No injuriesData collectionFinal reportCessna 172N · Broomfield, COThe pilot and airplane's inability to compensate for the unforecasted gusting wind conditions.Feb 26, 2009 · N737KR · Substantial damageNTSB CEN09CA179Accident · No injuriesData collectionFinal reportAviat A-1C · Denver, COThe pilot's failure to maintain control during taxi. A contributing factor was the gusty winds.Feb 25, 2009 · N75WY · Substantial damageNTSB WPR09IA128Incident · No injuriesIncident investigationFinal reportCessna 172H · Tucson, AZThe flight instructor’s inadequate situational awareness while taxiing that led to an encounter with jet blast.Feb 22, 2009 · N1408F · Minor damageNTSB WPR09IA123Incident · No injuriesIncident investigationFinal reportEmbraer EMB-120ER · Salt Lake City, UTThe flight crew's failure to maintain clearance from the stationary vehicle while taxiing.Feb 21, 2009 · N270YV · Minor damageNTSB WPR09CA093Accident · No injuriesData collectionFinal reportStemme S-10 · San Jose, CAThe pilot's failure to maintain clearance from an obstacle during taxi.Dec 30, 2008 · N8679 · Substantial damage