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 CHI82DA107Accident · No injuriesFinal reportCessna 172K · Fairmont, MNThe pilot encountered adverse weather and elected to land at Fairmont,Minnesota. While taxiing after landing, the aircraft flipped over in strong wind conditions.Mar 30, 1982 · N84344 · Substantial damageNTSB SEA82DYA06Accident · Serious injuriesFinal reportRotorway Scorpion TOO · Jerome, IDThe pilot was familiarizing himself with the home built helicopter. After hovering in one general area for about 45 minutes, he decided to hover to an open area by crossing a fence. He stated that he entered translational lift at about 20 knots while hovering…Mar 25, 1982 · N222RP · DestroyedNTSB NYC82DA066Accident · No injuriesFinal reportBeech A23-24 · Lock Haven, PAWhile taxiing for takeoff the left wing of the aircraft collided with the nose of a parked Piper twin. The pilot stated that during his instrument scan he noticed that the alternator failed to show a charge and that this may have distracted his attention as…Mar 20, 1982 · N6925Q · Substantial damageNTSB FTW82IA146Incident · No injuriesIncident investigationFinal reportRockwell NA-265-80 · Houston, TXDuring taxi for takeoff, nosewheel steering was lost and the aircraft departed the taxiway and went down an embankment and into a drainage ditch causing minor damage. During the hydraulic system check-out, the hydraulic pump motor was found burnt out. The…Mar 20, 1982 · N87Y · Minor damageNTSB NYC82IA058Incident · No injuriesIncident investigationFinal reportPiper J3C-65 · Bayport, NYThe pilot taxied into the parking area and stopped in a position that was facing Cessna 172, N7909G. The pilot of N40627, while sitting in the aft seat, reached forward and accidently caught his coat sleeve on the throttle. The throttle was pushed forward.…Mar 18, 1982 · N40627 · No damageNTSB ANC82DAG17Accident · No injuriesFinal reportCessna 185 · Paxson, AKAfter landing on a snow covered, frozen lake, the pilot began to taxi to the desired parking spot. While taxiing, the aircraft encountered an area of smooth ice under the snow and began to slide sideways. The right ski dropped through an overflow area on the…Mar 15, 1982 · N6978H · Substantial damageNTSB MKC82DA044Accident · No injuriesFinal reportHelio H-295 · Ozark, MOThe driver of the automobile parked on the east end of the east/west runway to watch aircraft taking off and landing on the north/south runway. After landing on the south end of the n/s runway, the pilot taxied to his right around a group of hangars and onto…Mar 13, 1982 · N6475V · Substantial damageNTSB CHI82DA085Accident · No injuriesFinal reportPiper PA-22-150 · Rockford, ILThe pilot had taxied to runway 24. While making a turn to runup, the wind picked up the right wing and tail, and flipped the plane over on its back.Mar 13, 1982 · N2470P · DestroyedNTSB SEA82DYM12Accident · No injuriesFinal reportPiper PA-28-181 · Albany, ORWhile proceeding from a restaurant parking area to the runway, the aircraft had to be taxied across a bridge. The bridge was 30 ft wide and 50 ft long. It had no side rails and was used to cross a drainage ditch. A slight right turn was required just before…Mar 12, 1982 · N2935S · Substantial damageNTSB FTW82DA125Accident · No injuriesFinal reportBellanca 7ECA · Lubbock, TXWhile taxiing to takeoff the pilot noticed an increase in wind and decided to return to the ramp. As he turned left the wind picked up the right wing and flipped the aircraft over. The wind was at 24 KTS. Gusting to 34 KTS.Mar 12, 1982 · N4193Y · Substantial damageNTSB DEN82DA043Accident · No injuriesFinal reportCessna 172 · Broomfield, COAfter landing the aircraft was taxiing to the ramp when a gust of wind lifted the left wing up and tipped the Cessna over on its back. Wind was gusting over 40 KTS.Mar 12, 1982 · N733DU · Substantial damageNTSB LAX82DA104Accident · Serious injuriesFinal reportCessna 172 · Las Vegas, NVWhile preparing to takeoff, the pilot was cautioned to beware of wake turbulence from a departing jet and was cleared into position to hold. Preceding the accident, the winds were reported to be from 230 deg gusting to 29 KTS. While turning to align with the…Mar 11, 1982 · N8542B · Substantial damageNTSB ATL82DKW06Accident · No injuriesFinal reportCessna 310 · Nashville, TNThe aircraft collided with a Cessna 310, N5253J at night after both planes had been cleared to the same runway. The other pilot stated that the Beech 95-55 was taxiing without lights. Reportedly, the Cessna pilot did not see the Beech 95-55 approaching from…Mar 11, 1982 · N5253J · 2 aircraft · Substantial damageNTSB LAX82DA097Accident · No injuriesFinal reportCessna 150 · Half Moon Bay, CAThe pilot of Taylorcraft, N94906, was making mild s-turns as he proceeded down a taxiway. As he was making an s-turn back to the right, he saw a Cessna 150, N5678E, at the right edge of the taxiway on a converging course. He turned left to avoid a collision,…Mar 6, 1982 · N5678E · 2 aircraft · Substantial damageNTSB MIA82DA081Accident · No injuriesFinal reportCessna 152 · Brooksville, FLWhile taxiing for takeoff on a road used for aircraft and vehicles the aircraft collided with a parked garbage truck.Mar 4, 1982 · N25853 · Substantial damageNTSB LAX82DA112Accident · No injuriesFinal reportPiper PA-28-161 · Glendale, AZWhile taxiing for takeoff, the right wing of the aircraft collided with a sign that was located beside the taxiway.Mar 1, 1982 · N2524U · Substantial damageNTSB FTW82DA115Accident · No injuriesFinal reportPiper PA-25-235C · Big Spring, TXThe pilot reported that he had been practicing crosswind landings in winds that were gusting to 25 knots. On the last landing, he used flaps. He reported that he had landed and was taxiing on the runway when a gust of wind raised the right wing. The left wing…Mar 1, 1982 · N8832L · Substantial damageNTSB ATL82DA061Accident · Minor injuriesFinal reportHomebuilt PDQ-2 · Laurel, MSWhile practicing high speed taxiing a gust of wind lifted the aircraft off the ground. The pilot elected to apply full throttle and proceed to takeoff. When he had climbed to 800 feet the engine began to misfire. Unable to control the plane the pilot collided…Mar 1, 1982 · N2263K · DestroyedNTSB LAX82FVG18Accident · No injuriesFinal reportCessna 320C · Sacramento, CAOn the previous flight, the landing gear was cycled two or three times without a safe indication while using the normal gear extension system. The gear was then hand cranked down and a safe light was obtained. After the flight, a gear retraction test was…Feb 27, 1982 · N14MC · Substantial damageNTSB ANC82DA021Accident · No injuriesFinal reportPiper PA-20 · Bethel, AKThe pilot was taxiing to the tie-down area when the right ski/landing gear failed. The pilot attributed the failure to age and noted that ice landings are hard on ski equipped aircraft.Feb 26, 1982 · N3404A · Substantial damageNTSB FTW82DA066Accident · No injuriesFinal reportCessna A185F · Near Patterson, LAAfter landing the pilot began to step taxi on an unfamiliar canal to a drilling rig location. While negotiating a turn in the canal, the left wing struck a tree limb. The aircraft veered to the left and the right wing dropped and hit the water.Feb 22, 1982 · N61766 · Substantial damageNTSB MIA82DA052Accident · No injuriesFinal reportGreat Lakes 2T1A-2 · Pembroke Pines, FLWitnesses observed the pilot taxiing downwind at a speed above normal when the aircraft's tail was seen to raise and the aircraft turned over.Feb 18, 1982 · N3667L · Substantial damageNTSB MIA82DA065Accident · No injuriesFinal reportCessna 152 · Opa Locka, FLWhile doing touch and go landings the pilot observed a squall line approaching the airport. He proceeded to make a full stop landing and was taxiing to operations, when a strong gust of wind picked up the tail of the aircraft and flipped it over. The pilot…Feb 17, 1982 · N757TY · DestroyedNTSB MKC82DA037Accident · No injuriesFinal reportCessna 150 · Grain Valley, MOThe pilot was attempting to taxi his aircraft back to its tiedown space through 6 to 8 inches of snow. While maintaining clearance on an aircraft on his right the left wing tip struck the tail of a Cessna 140.Feb 13, 1982 · N7947Z · Substantial damageNTSB ANC82DA018Accident · No injuriesFinal reportCessna 185 · Fort Yukon, AKThe pilot had landed the wheel/ski equipped aircraft at a field site to pick-up a passenger. While taxiing in snow, estimated to be 14 to 15 inches deep, the right ski hit something in the snow and the plane nosed over.Feb 9, 1982 · N8456Q · Substantial damageNTSB FTW82DA056Accident · No injuriesFinal reportCessna 177RG · Artesia, NMWhile taxiing, the aircraft was lifted up on its right main gear by a gust of wind. When the aircraft settled back down, the left main inboard castering bolt sheared and the left main gear collapsed. The wind was gustng to 20 knots.Feb 7, 1982 · N33281 · Substantial damageNTSB SEA82DA028Accident · No injuriesFinal reportBoeing A75N1 · Medford, ORAfter landing the pilot of Taylorcraft, N9507B, was cleared to proceed to his parking area. At 1054:50, ground control advised him of stearman, N56270, approaching from the opposite direction. The Taylorcraft pilot adjusted his taxi path to the right of the…Feb 6, 1982 · N56270 · 2 aircraft · Minor damageNTSB LAX82DA065Accident · No injuriesFinal reportCessna 180 · San Jose, CABellanca N71681 was awaiting clearance for takeoff when Cessna N3343D taxied into the turning propeller during a positioning maneuver.Feb 6, 1982 · N3343D · 2 aircraft · Substantial damageNTSB LAX82DVG15Accident · No injuriesFinal reportAeronca 7AC · Redding, CAWhen the pilot hand propped the aircraft to start the engine, it began rolling and struck Cessna 206, N732TQ.Jan 30, 1982 · N1669E · Substantial damageNTSB DEN82DA031Accident · No injuriesFinal reportCessna 172N · Broomfield, COPrior to landing, the pilot monitored the ATIS and noted that the wind was from 320 degrees at 15 knots. While on final approach for landing, he heard a radio transmission stating that the wind was gusting to 30 knots. While landing, he thought the right tire…Jan 27, 1982 · N5745T · Substantial damageNTSB MKC82DA025Accident · No injuriesFinal reportCessna 172N · Lee'S Summit, MOPower was added to initiate taxiing. When the aircraft did not turn enough to the left additional power was applied and the aircraft struck a snowbank.Jan 26, 1982 · N9259H · Substantial damageNTSB SEA82DA019Accident · No injuriesFinal reportHughes 269C · S.E. Of Malta, IDThe purpose of the flight was for predator (coyote) control. The pilot was following a coyote at a low-altitude, moderate-speed air taxi over snow and sagebrush covered terrain. One of the aircraft's snowboards caught several sagebrush limbs and the pilot…Jan 15, 1982 · N58203 · Substantial damageNTSB ATL82IA034Incident · No injuriesIncident investigationFinal reportEmbraer EMB-110P1 · Clarksburg, WVDuring taxi out from greensboro, NC, the captain noted that the aircraft was pulling to the right. The problem alleviated itself when the pilot tapped the right brake. After a normal takeoff, the copilot noticed during gear retraction that the right main…Jan 12, 1982 · N615KC · Minor damageNTSB FTW82DA038Accident · No injuriesFinal reportPiper PA-34 · Tomball, TXAfter being cleared by the tower to taxi onto the runway from an unlighted taxiway the right main landing gear fell into a hole. Construction work was being done in the area and no warning lights had been erected. The pilot stated that the tower personnel had…Jan 9, 1982 · N55489 · Substantial damageNTSB LAX82DA039Accident · No injuriesFinal reportAerospatiale SA-316B · Mammoth Lakes, CAThe pilot started to air taxi the helicopter out of a hangar. There was snow in front of the hangar that had been only partially cleared away. As the pilot was exiting the hangar, he raised the aircraft to go over the snow, the tail rotor struck the hangar…Jan 6, 1982 · N608RA · Substantial damageNTSB LAX82DA037Accident · No injuriesFinal reportCessna TR182 · Springerville, AZWhile taxiing to the ramp after landing the wind caught the right wing and turned the aircraft over on its back. The pilot reported that the wind was gusting up to 70 knots.Jan 5, 1982 · N738XP · Substantial damageNTSB MIA82FKA05Accident · 1 fatalFinal reportCessna 206 · Saint CroixAircraft landed during darkness before control tower had opened. While taxiing to ramp, aircraft was struck by an ambulance as aircraft was crossing parallel taxiway. Aircraft immediately burst into flames, and ambulance continued to travel through the…Jan 4, 1982 · N5151U · DestroyedNTSB NYC82DA016Accident · No injuriesFinal reportCessna 172 · Galeton, PAAfter takeoff from the original departure point, the pilot flew to a local airport and landed on runway 28. The runway was covered with snow and the winds were from 270 degrees at 10 knots. After landing, the pilot taxied back for takeoff. While in a right…Jan 2, 1982 · N25084 · Substantial damageNTSB DEN82DTM08Accident · No injuriesFinal reportEnstrom 280C · Midway, UTThe aircraft crashed while being moved about 150 ft from the parking area to a storage building. There was about 2 1/2 ft of fresh snow on the ground. The snow had been cleared from the parking area in front of the storage building. However, a snow cat had…Jan 2, 1982 · N51735 · DestroyedNTSB MIA82DA024Incident · No injuriesClosedHawker Sdly HS-748 · St Thomas, VIDec 27, 1981 · VP-LIP · Minor damageNTSB FTW82DRJ06Accident · No injuriesClosedCessna 175A · Mt.Pleasant, TXDec 26, 1981 · N6994E · Substantial damageNTSB CHI82FEK03Accident · No injuriesClosedPiper PA-28 · Columbus, OHDec 16, 1981 · N28906 · Substantial damageNTSB CHI82DEE11Accident · No injuriesClosedCessna 172M · Chicago, ILDec 11, 1981 · N80118 · Substantial damageNTSB ATL82FKJ07Accident · No injuriesClosedCessna 150 · Birmingham, ALDec 9, 1981 · N11623 · Substantial damageNTSB MIA82FLD09Accident · No injuriesClosedBell 206B · Orlando, FLDec 7, 1981 · N7021J · Substantial damageNTSB FTW82DRA12Accident · No injuriesClosedGrum Amer AA-5B · Conroe, TXDec 4, 1981 · N74667 · Substantial damageNTSB NYC82FFJ09Accident · Minor injuriesClosedPiper PA-28R · Syracuse, NYDec 3, 1981 · N1087H · Substantial damageNTSB DEN81DTG03Accident · No injuriesClosedCessna 150 · Trotter, NDDec 3, 1981 · N61363 · Substantial damageNTSB SEA82DYP06Accident · No injuriesClosedCessna 172G · Mattawa, WADec 2, 1981 · N5757R · Substantial damageNTSB LAX82FVM02Accident · No injuriesClosedBeech 95-B55 · King City, CANov 28, 1981 · N18ER · Substantial damage