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 LAX86LA284Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Los Angeles, CAThe private plt had no prior experience at the Los Angeles intl. Arpt. & the plt was unknowledgeable of the existence of arpt motor vehicle traffic service roads. The plt was given an ATC clearance to taxi, & in the darkness the plt mistook a service road for…Jul 3, 1986 · N54203 · Substantial damageNTSB NYC86FHD01Accident · 1 fatalFinal reportPiasecki Acft. Helistat 97-34J · Lakehurst, NJThe helistat, a hybrid a/c with 4 H-34 main fuselages attached to a frame along with a ZPG-2 helium filled envelope had just completed it first hover test flt successfully and landed. A pwr loss was noted on the no. 3 helicopter and the test was terminated…Jul 2, 1986 · N1897Z · DestroyedNTSB MKC86LA146Accident · No injuriesLimited investigationFinal reportCessna T303 · Lake Ozark, MOThe plt stated that the flt was uneventful until after landing when somebody instructed him, over the common traffic advisory frequency on his VHF radio, to park the acft at a new parking area, and he complied. This parking area was congested with extra acft…Jun 27, 1986 · N9571C · Substantial damageNTSB FTW86LA120Accident · No injuriesLimited investigationFinal reportBeech E18S · Oklahoma City, OKA swearingen SA-226TC, N516SS, was lndd at ngt on rwy 17L. After lndg, the flt crew exited onto taxiway-E3 (TWY-E3), where they were instructed by tower to hold. A Beech E18S, N2001C, was then lndd on the same rwy (rwy 17L) & its plt also exited onto TWY-E3.…Jun 24, 1986 · N2001C · 2 aircraft · Minor damageNTSB ANC86LA086Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Bulchitna Lake, AKThe airplane struck a wingtip on the water while step taxiing downwind attempting a left turn.Jun 23, 1986 · N67686 · Substantial damageNTSB CHI86FEP05Accident · No injuriesFinal reportBeech C-23 · Milwaukee, WIDuring taxi for takeoff the plt inadvertently taxied onto an access road and struck and unlit sign. The taxiway had been resurfaced and no taxi guide lines had been repainted.Jun 18, 1986 · N66345 · Substantial damageNTSB SEA86LA151Accident · No injuriesLimited investigationFinal reportNavion A · Boise, IDThe pilot elected to land onto a road to pick up a passenger. The pilot failed to maintain adequate clearance from a wire fence to the right of the road and caught the right wing.Jun 13, 1986 · N5208N · Substantial damageNTSB ANC86LA068Accident · No injuriesLimited investigationFinal reportAeronca 15 AC Sedan · Neal Lake, AKAccording to the pilot-in-command, while step taxiing for takeoff the airplane became airborne inadvertently with insufficient room to takeoff or turn. The pilot-in--command stated he closed the throttle and the airplane touched down on the lake. He was…Jun 9, 1986 · N1450H · Substantial damageNTSB DEN86LA156Accident · No injuriesLimited investigationFinal reportCessna 180 · Cheyenne, WYThe student plt flew from alliance to Cheyenne on his solo x-country and flew locally at Cheyenne to make 3 landings at a twr controlled arpt. While he was in the pattern a cumulonimbus cloud moved into the vicinity of the arpt and the winds became gusty.…Jun 6, 1986 · N3253D · Substantial damageNTSB MKC86LA125Accident · No injuriesLimited investigationFinal reportCessna 150L · Nevada, IAWitnesses stated that the student appeared nervous while performing the preflight inspection for what was to be her second supervised solo flight. After engine start and initial taxi, the student began to exercise the throttle in an erratic fashion, sometimes…Jun 4, 1986 · N11753 · Substantial damageNTSB ANC86LA064Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Anchorage, AKWhile high speed taxiing on a runway in gusting wind conditions, the pilot lost control of his airplane and it veered into a parked airplane adjacent to the runway. The pilot reported the wind was from 130 degrees at 15 gusting 25 knots.May 30, 1986 · N8519Y · Substantial damageNTSB MIA86LA158Accident · No injuriesLimited investigationFinal reportCessna 182A · Winter Haven, FLThe plt stated that as he was taxiing the acft from landing, the nose gear became stuck in soft dirt. The propeller then struck the ground and the acft nosed over.May 14, 1986 · N6155B · Substantial damageNTSB DEN86LA134Accident · No injuriesLimited investigationFinal reportCessna 172H · Great Falls, MTThe plt reported that after landing on rwy 24 he was back taxiing on rwy 06 when he encountered strong, gusty surface winds. He said he stopped and was looking for a place to tie down when a strong gust flipped the acft onto its back. Surface wind at the time…May 14, 1986 · N3749R · Substantial damageNTSB FTW86LA080Accident · No injuriesLimited investigationFinal reportCessna 172M · Dallas, TXThe pilot collided with a fence while taxiing on an airport access road, which he had mistaken for the taxiway. Although the pilot should have exercised better judgement, it has been determined that this same type of mishap has occurred before. After a…May 3, 1986 · N13731 · Substantial damageNTSB ANC86LA053Accident · No injuriesLimited investigationFinal reportCessna 185 · Bethel, AKThe pilot stated that he was taxiing for takeoff on the frozen river when the left main gear broke through the ice. The aircraft's left wing and left gear were damaged.May 2, 1986 · N9706H · Substantial damageNTSB CHI86IA121Incident · No injuriesIncident investigationFinal reportBoeing 727-231 · Detroit, MIWhile taxiing for takeoff a male pax panicked and shouted 'open the door!' During a smoke-in-the-cabin occurrence (overheated a/c pack). The lead fa mistook this 'instruction' as coming from the cockpit and opened an exit door. Passengers interpreted her…Apr 17, 1986 · N64324 · No damageNTSB MIA86LA122Accident · No injuriesLimited investigationFinal reportCessna 172M · Borinquen, PRThe plt stated that after completing a local flt he landed on the rwy and noticed that the taxiway lights were inoperative where he wished to taxi. When he taxied off the rwy the propeller and landing gear struck a concrete culvert that was resting next to an…Apr 16, 1986 · N9194H · Substantial damageNTSB MIA86LA120Accident · No injuriesLimited investigationFinal reportCessna T303 · Bunnell, FLWhile on a dual instructional flight both instructor and the student pilot noted a left brake failure on taxi to takeoff. The instructor attempted to utilize asymmetric power to steer the aircraft but could not control the turn. The aircraft ran off the edge…Apr 14, 1986 · N212ER · Substantial damageNTSB MKC86LA089Accident · No injuriesLimited investigationFinal reportAerotek Pitts S-2A · Springfield, MOThe plt stated that after landing on rwy 28 the left gear folded while taxiing. The acft then fell onto its left wing. The plt reported the gear collapsed without warning. Examination of the gear support found a joint which was cold welded had failed.Apr 12, 1986 · N51WJ · Substantial damageNTSB LAX86LA171Accident · No injuriesLimited investigationFinal reportCessna 172D · Mojave, CAThe acft wing struck a tree during taxi on a dirt road being used for takeoff. The CFI said that he did not make a survey to identify obstructions before the taxi for takeoff. The acft had landed on the road when the CFI could not regain eng power following a…Apr 10, 1986 · N2762U · Substantial damageNTSB FTW86LA055Accident · No injuriesLimited investigationFinal reportCessna 172H · Bristow, OKThe pilot reported encountering strong gusty winds while taxiing for departure at jones memorial airport, Bristow, OK. As a result his aircraft was flipped upside down and substantially damaged. The pilot was not injured.Mar 31, 1986 · N2826L · Substantial damageNTSB DEN86LA106Accident · Serious injuriesLimited investigationFinal reportCessna 150J · Tioga, NDThe plt dept minot, ND, with his son aboard, for a pvt airstrip near his home of windrose, ND. He said because of high winds he landed at Tioga, ND. He said that while taxiing after landing strong gusty winds flipped his acft upside down. The acft was…Mar 29, 1986 · N51156 · Substantial damageNTSB NYC86IA093Incident · Minor injuriesIncident investigationFinal reportBoeing 727-231 · Boston, MATwo of 3 reqd flt attendants (f/a's) were distributing passenger (pax) coats as the acft was being taxied after lndg. Smoke fm an overheated air cond (a/c) pack bgn entering the cabin & the f/a's returned to their duty stations. The flt crew stopped the acft…Mar 27, 1986 · N52311 · No damageNTSB ATL86FLT05Accident · No injuriesFinal reportPiper PA-14 · Memphis, TNThe acft collided with an air compressor and a hangar door during taxi after the plt hand-propped the unoccupied acft. The ptl said that the thought the 'switches were off'.he was pulling the prop to 'loosen' the oil when the eng started and the acft started…Mar 21, 1986 · N4276H · Substantial damageNTSB NYC86LA091Accident · No injuriesLimited investigationFinal reportCessna 140 · Newburyport, MAWhile taxiing on a grass taxiway, the acft contacted a soft spot in the grass and nosed over.Mar 20, 1986 · N2643N · Substantial damageNTSB LAX86LA141Accident · No injuriesLimited investigationFinal reportCessna 172N · Apple Valley, CAA Cessna 172N nosed over on the taxiway after completing a full stop ldg on the rwy. Winds were reported from 180 deg at 18 KTS gusting to 23 KTS with peak gusts from the se at 31 KTS. UNICOM reported winds from the s at 20 KTS gusting to 30 KTS. The plt had…Mar 15, 1986 · N739GB · Substantial damageNTSB MKC86LA066Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Versailles, MOThe plt reports that he was hand propping the eng. He said the eng did not start on the first attempt and he primed it a second time. On the second try the eng started and the acft got away from the plt, taxied about 75 ft and collided with trees. The plt…Mar 9, 1986 · N3673H · Substantial damageNTSB MIA86LA092Accident · No injuriesLimited investigationFinal reportCessna 210J · Jacksonville, FLThe plt stated that while taxiing to the ramp, after landing, he taxied through construction barricades & ran off the taxiway. While attempting to get back on the taxiway, the nose gear got caught in a hole & collapsed.Mar 7, 1986 · N77WG · Substantial damageNTSB NYC86FA076Accident · Serious injuriesField investigationFinal reportLockheed L-1011-385-1 · Jamaica, NYThe no. 3 eng torched during a start attempt and resulted in a internal eng tailcone fire. Several paxs panicked upon seeing the torch flame/tailcone fire and between 30 to 50 paxs made an unauthorized evacuation of the acft via the L3 and L4 exits. Paxs…Feb 15, 1986 · N309EA · No damageNTSB NYC86LA074Accident · No injuriesLimited investigationFinal reportUniversal Aircraft Industries GC-1B · Farmingdale, NYA Piper acft was standing in the runup area that is adjacent to taxiway A5. The plt of the globe acft taxied into the runup area and because the sun was in his eyes and the Piper was in his blind spot he ran into the Piper.Feb 12, 1986 · N80827 · 2 aircraft · Substantial damageNTSB CHI86LA085Accident · No injuriesLimited investigationFinal reportCessna 401B · Milwaukee, WIWhile taxiing to park, the left main landing gear collapsed. Investigation revealed that the left hand gear support had torn from the wing rib to which it was bolted. On the FAA malfunction or defect report submitted by the operator, company officials stated…Feb 9, 1986 · N777CS · Substantial damageNTSB NYC86LA070Accident · No injuriesLimited investigationFinal reportPiper PA-42-720 · Rochester, NYPiper aircraft collided with a parked Cessna aircraft while maneuvering into a parking space at Rochester-monroe airport after landing. The ramp was reported to be ice covered and sanded.Feb 3, 1986 · N777YP · Substantial damageNTSB MIA86LA068Accident · No injuriesLimited investigationFinal reportAerospatiale 350-B · Las Piedras, PRPilot stated that while flaring to enter a hover to reverse direction for takeoff the tail rotor guard struck the ground and separated. The helicopter was nosed over forward and as it was flared a second time the tail rotor struck the ground causing loss of…Jan 31, 1986 · N513HC · Substantial damageNTSB SEA86LA049Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Metlakatla, AKWind was 070 degrees at 20 KTS with 6-12 inch sweels. N127WA was positioned at north side of dock for departure toward east. N1018H was holding at east side of dock. Deck hand cast off N127WA before plt started engine; acft began to drift back into dock. Plt…Jan 30, 1986 · N127WA · 2 aircraft · Substantial damageNTSB MKC86LA057Accident · No injuriesLimited investigationFinal reportCessna 310R · Kansas City, MOThe airplane was being taxied toward a parking spot in front of a hangar and the right brake failed and the left wing contacted the front of the hangar.Jan 26, 1986 · N1905G · Substantial damageNTSB MIA86LA061Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Vero Beach, FLThe plt stated that he was completing his run-up prior to takeoff, looked up & was only able to pull the power off before he was struck by N2361D.Jan 20, 1986 · N2361D · 2 aircraft · Substantial damageNTSB MKC86LA050Accident · No injuriesLimited investigationFinal reportCessna 172 · Des Moines, IAN8036B diverted to Des Moines for fuel after encountering strong head winds enroute. After landing on rwy 30R the plt turned off the rwy onto a taxiway that runs to the north. The plt then stopped to change radio frequencies. While the acft was stopped a…Jan 12, 1986 · N8036B · Substantial damageNTSB CHI86LA061Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Mount Gilead, OHAccording to the arpt manager, the plt was taxiing down the active in gusty wind conditions at a fairly rapid rate of speed. As the plt turned into the run-up pad area the acft nosed over.Jan 11, 1986 · N3003Z · Substantial damageNTSB MKC86LA043Accident · No injuriesLimited investigationFinal reportCessna 172N · Kansas City, MOThe pilot had been at this airport 31 times since 1979. During his taxi to takeoff for a night flight, he mistook a service road for a taxiway. He taxied past one sign without seeing it but struck the second one. This is the third documented accident at this…Jan 2, 1986 · N733NF · Substantial damageNTSB DEN86LA048Accident · No injuriesLimited investigationFinal reportCessna TU-206G · Denver, COWhile gnd taxiing to a general aviation terminal after ldg, the pilot taxied behind and turned downwind into jet thrust from a B737 acft as it was being taxied from a passenger terminal enroute to rwy for takeoff. The acft was blown onto its nose and right…Dec 18, 1985 · N7418N · Substantial damageNTSB LAX86LA101Accident · No injuriesLimited investigationFinal reportCessna 152 · Upland, CAOn December 9, 1985 at 0730 PST a Cessna 152 registered to walter d. cable of upand, California collided with a parked truck while taxiing for takeoff on the paralellel taxiway of rwy 24 at cable airport, Upland, CA. VMC prevailed at the time. The airport was…Dec 9, 1985 · N64851 · Substantial damageNTSB DEN86LA047Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Aurora, COAccording to the plt, the right wing struck a fence while diverting off the taxiway centerline to make room for another oncoming acft. Contact with the fence resulted in a bent spar in the right wing.Dec 8, 1985 · N37550 · Substantial damageNTSB CHI86LA050Accident · No injuriesLimited investigationFinal reportCessna 172RG · East Liverpool, OHAccording to the plt, he was unable to stop the acft at the end of the taxiway after he had taxied through water. The acft came to rest after sliding into a drainage ditch at the end of the taxiway. The plt continued the flt although the acft was damaged. The…Dec 3, 1985 · N6208V · Substantial damageNTSB CHI86IA037Incident · No injuriesIncident investigationFinal reportEmbraer EMB-110P1 · Detroit, MIThe acft suffered a failure of the left rear axle during taxi to takeoff.Dec 2, 1985 · N90427 · Minor damageNTSB CHI86FA036Accident · No injuriesField investigationFinal reportCessna 404 II · Chicago, ILThe tug driver with baggage cart failed to yield to a taxiing acft when crossing an active taxiway. It was dark nite. Acft had position/taxi lites on. Vehicle stop sign to taxi centerline is 70 ft. driver said he stopped at sign. Tug struck rt wg tip, wg…Nov 29, 1985 · N167SA · Substantial damageNTSB LAX86LA055Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Santa Maria, CAAfter completing a nighttime business flight, the plt landed and taxied to parking. Enroute the plt attempted to taxi between two hangars and around a wash rack. The acft collided with an unmarked curb adjacent to the wash rack and the gear collapsed bending…Nov 28, 1985 · N32998 · Substantial damageNTSB DEN86LA032Accident · No injuriesLimited investigationFinal reportPiper PA-31-310 · Fargo, NDThe plt stated that during the ground taxi after landing, the right main gear collapsed. During the investigation, it was determined the down lock mechanism was not engaged. Upon examination, it was determined that the main gear lock activator rod was…Nov 26, 1985 · N537NB · Substantial damageNTSB DEN86LA024Accident · No injuriesLimited investigationFinal reportChampion 7KCAB · Berthoud, COThe plt stated that he made 7-9 high speed taxies to pack the snow on the grass strip, aborting mid-strip when flying speed was not attained. On the final run, the plt said the acft again failed to reach flying speed and decided to abort mid-strip. The plt…Nov 17, 1985 · N1832G · Substantial damageNTSB MIA86IA022Incident · No injuriesIncident investigationFinal reportCessna 402B · St. ThomasAfter landing the pilot made a 270 degree left turn to entera taxiway. After completion of the turn the left main landing gear began to wobble and then collapsed outwardinspection of the aircraft revealed that of six bolts which attach the left gear support…Oct 28, 1985 · N98685 · Minor damageNTSB LAX86LA020Accident · No injuriesLimited investigationFinal reportPiper PA28-181 · Palo Alto, CAThe plt said that after landing and turning onto the parallel taxiway, the engine quit. During an attempted re-start, fire was noticed coming from the engine compartment. The plt and his passenger evacuated the acft, and arpt personnel put out the fire. The…Oct 21, 1985 · N2491Y · Substantial damage