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 NYC87LA117Accident · Serious injuriesLimited investigationFinal reportBeech 1900 · Boston, MADuring taxi operations in preparation for a takeoff from Boston logan airport, the Beech aircraft was struck by a ground vehicle and substantially damaged.Apr 7, 1987 · N811BE · Substantial damageNTSB FTW87LA092Accident · No injuriesLimited investigationFinal reportCessna 402B · Altus, OKA 17 year old non rated pilot and 3 of his friends attempted to steal the arcft. After the engines were started power was applied and control of the aircraft was lost immediately. The aircraft struck a hangar and continued across the taxiway where the…Apr 4, 1987 · N402BC · Substantial damageNTSB MKC87IA070Incident · No injuriesIncident investigationFinal reportAgusta A109 · Lincoln, NEThe PIC stated that he was ground taxiing the helo to the ramp area at duncan aviation to shutdown for refueling. During the taxi, the PIC heard a loud 'bang' eminating fm the rear of the helo. The PIC lowered collective pitch and no further noise was heard…Mar 30, 1987 · N4GH · Minor damageNTSB CHI87LA105Accident · No injuriesLimited investigationFinal reportAeronca 15AC · Hibbing, MNThe plt stated that while taxiing on the north taxiway, for takeoff on runway 31, a 'gust of wind caught the tail abruptly and caused plane to veer to the left and strike corner of hangar.' The acft collided with the hangar nose first.Mar 28, 1987 · N1156H · Substantial damageNTSB NYC87LA115Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Bedford, MADuring taxi operation in preparation for takeoff, the left main gear of the aircraft impacted an unmarked open manhole and the aircraft was substantially damaged.Mar 27, 1987 · N40958 · Substantial damageNTSB DEN87LA070Accident · No injuriesLimited investigationFinal reportCessna 152 · Carlsbad, NMThe student plt was on a solo x-country and landed at an intermediate arpt. The acft was taxiing from landing with a 24 kt tailwind. A strong gust of wind hit the acft and it nosed over.Mar 22, 1987 · N6285Q · Substantial damageNTSB DEN87LA067Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Missoula, MTThe plt of the Piper navajo was taxiing to the active rwy for an IFR departure, directed his attention to the departure procedure chart in the cockpit, and collided with the tail of a swearingen acft holding short of the rwy awaiting takeoff clearance.Mar 19, 1987 · N3529W · 2 aircraft · Minor damageNTSB ANC87LA055Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Girdwood, AKThe pilot stated that during taxi for takeoff he lost directional control of the aircraft causing the aircraft to exit the taxiway and strike a snowbank.Mar 18, 1987 · N1472C · Substantial damageNTSB NYC87IA106Incident · No injuriesIncident investigationFinal reportBoeing 727-225A · Jamaica, NYAs EA32 taxied from a stopped position on taxiway na between the outer and inner to the eastern ramp, a U.S. Postal tractor with an empty box traveling NE failed to yield to the aircraft and they collided on the service road and taxiway na.Mar 11, 1987 · N802EA · Minor damageNTSB ANC87LA040Accident · No injuriesLimited investigationFinal reportCessna 170B · Anchorage, AKThe pilot successfully landed his ski equipped tailwheel airplane on a frozen lake in gusty wind conditions but lost control of the airplane while attempting to taxi from upwind to downwind. The airplane struck its left wing and elevator on the lake ice and…Feb 23, 1987 · N4687C · Substantial damageNTSB CHI87LA089Accident · No injuriesLimited investigationFinal reportCessna 182F · Pontiac, MIWhile the acft was being taxied to a hangar after landing, the left main gear collapsed. An investigation revealed the left main landing gear spring strut, pn 0741601-1, had failed where it was clamped to the fuselage. A metallurgical exam of the fracture…Feb 21, 1987 · N3513U · Substantial damageNTSB DEN87IA056Incident · No injuriesIncident investigationFinal reportPiper PA-31 · Denver, COWhile taxiing from a cargo ramp for takeoff on an IFR flt, the acft taxied off the ramp into the infield on the arpt and came to rest with the engines running. Ramp personnel boarded the acft, shut the engines down and summoned medical help for the plt who…Feb 14, 1987 · N7559L · No damageNTSB ANC87LA035Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Clear, AKThe pilot of the ski equipped airplane stated he taxied too fast after landing and damaged the airplane after the right ski toed into a large snow drift on rough surface ice.Feb 7, 1987 · N102TC · Substantial damageNTSB NYC87LA081Accident · No injuriesLimited investigationFinal reportCessna 172 · Beaver Falls, PAThe pilot attempted a turn while taxiing and added power to taxi over soft ground. The pilot did not realize the close proximity of aircraft wing tip to the hanger. The edge of the right wing caught a part of the hanger and was substantially damaged.Feb 6, 1987 · N6539E · Substantial damageNTSB CHI87LA075Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Dodgeville, WIWhile taxiing after landing on runway 12, a tailwind was encountered. The acft spun around, slid backwards off the rwy, down a steep embankment and struck a large rock. The plt reported winds from 270 degrees at 12 knots gusting to 18 knots.Feb 5, 1987 · N86079 · Substantial damageNTSB MIA87IA078Incident · No injuriesIncident investigationFinal reportBritish BAC 1-11 201 · Orlando, FLAfter landing the auxiliary power unit was started and the number one engine was shutdown. The aircraft then began to pressurize and fill with smoke. An emergency evacuation was ordered by the captain through L-1 and R-1 doors. The slide at R-1 did not work…Jan 28, 1987 · N101EX · Minor damageNTSB DEN87LA045Accident · No injuriesLimited investigationFinal reportCessna 172B · Roswell, NMStudent plt obtained wx briefing from fort worth fss and filed VFR flt plan for x-country flt from plainview, tex, to Roswell, NM, via hobbs, NM,. Plt landed at Roswell, refueled, and filed return VFR flt plan. He did not obtain updated wx briefing. Cold…Jan 24, 1987 · N8224X · Substantial damageNTSB LAX87LA083Accident · No injuriesLimited investigationFinal reportCessna 172K · Lanai, HIThe Cessna 172K nosed over in strong winds while taxiing for departure on rwy 3. The plt indicated that he was 'back taxiing' on rwy 3 when the wind 'got under wing, then under tail, and plane turned upside down.' The plt also indicated that the winds were…Jan 12, 1987 · N7459 · Substantial damageNTSB SEA87LA044Accident · No injuriesLimited investigationFinal reportde Havilland Beaver DHC-2 · Shoal Cove, AKThe DHC-2 air taxi acft had landed at Shoal Cove, AK and was step taxiing to th float plane dock. During the taxi the acfts left wing contacted a wire cable attached to an 'a' frame across the path of the acft. The cable had been put up the day before and was…Jan 8, 1987 · N1018H · Substantial damageNTSB ATL87LA056Accident · No injuriesLimited investigationFinal reportCessna 172G · New Philadelphi, OHThe acft right wing tip struck a hangar door while taxiing. The plt reported that he initially estimated the damage to be limited to the fiberglass wing tip fairing. He subsequently flew the aircraft back to his original departure point. Further examination…Dec 23, 1986 · N380LA · Substantial damageNTSB MIA87IA054Incident · Minor injuriesIncident investigationFinal reportBoeing 747-121 · Miami, FLDuring taxi for takeoff the captain of the air carrier became partially incapacitated. The first officer took over and the flight taxied back to the gate. The captain was evacuated to a local hospital where he was treated with glucose for hypoglycemia and…Dec 21, 1986 · N75IPA · No damageNTSB ATL87LA048Accident · No injuriesLimited investigationFinal reportBeech D-17-S · Louisville, KYFollowing a normal landing on runway 06 at bowman field, the acft nosed over while clearing the rwy. The plt reported applying brakes and recalled feeling the tailwheel lift off the ground. The plt did not report any system malfunction, and the investigation…Dec 20, 1986 · N217SD · Substantial damageNTSB SEA87LA037Accident · No injuriesLimited investigationFinal reportCessna T310Q · Medford, ORDuring turn off from the runway to the taxiway the left main gear collapsed. The runway and taxiway were icy and wet. Examination of the landing gear indicated an overload failure.Dec 17, 1986 · N7581Q · Substantial damageNTSB ATL87IA027Incident · No injuriesIncident investigationFinal reportBritish Aerospace BA-31 · Louisville, KYWhile taxiing for takeoff, a jetstream 31 operating as a commuter carrier to dayton, Ohio, collided with the fourth baggage cart of a four car train. The visibility on the ramp was reduced due to rain and fog. The baggage cart driver stated that he was…Nov 26, 1986 · N823JS · Minor damageNTSB NYC87LA037Accident · No injuriesLimited investigationFinal reportPiper J3 · Montgomery, NYWhile taxiing in the middle of the taxiway the propeller of N58380 contacted the wing of N7416T. N58380 then rotated and it's wing contacted the wing of N7416T. N7416T was stopped alongside the taxiway when the accident occurred.Nov 23, 1986 · N58380 · 2 aircraft · Substantial damageNTSB LAX87LA042Accident · No injuriesLimited investigationFinal reportCessna 120 · Columbia, CAAt the beginning of a local pleasure flight, the pilot lost control of the aircraft while practicing high speed taxiing for directional control for takeoffs and landings. Upon reaching liftoff speed, the power was reduced to idle. The aircraft swerved to the…Nov 17, 1986 · N4085N · Substantial damageNTSB CHI87LA025Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Detroit, MIUpon landing at Detroit metropolitan airport, the pilot stated that he was instructed by the tower to make a right turn on runway 3C or taxiway j, and taxi to butler aviation. The pilot then turned onto what he thought was taxiway j, but was actually a paved…Nov 12, 1986 · N8161K · Substantial damageNTSB MKC87LA021Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Chillicothe, MOThe PIC rptd that he was taxiing out fm the ramp area to the runup area of the airport to prepare for takeoff. He stated he had noticed ground equipment operating on the arpt as he taxied out. He had also stated that the windshield had become fogged during…Nov 8, 1986 · N55505 · Substantial damageNTSB FTW87LA008Accident · Minor injuriesLimited investigationFinal reportHughes 269C · Monahans, TXThe acft was destroyed during a forced landing following a partial loss of pwr after liftoff from a trailer. The acft settled back down onto the front of the trailer and subsequently rolled over. The eng continued to run following the roll over. The plt…Oct 24, 1986 · N8970F · DestroyedNTSB ANC87IA011Incident · No injuriesIncident investigationFinal reportCessna 402C · Kivalina, AKThe roll pin and safety wire which retain the main landing gear forward trunnion pin were broken and the forward trunnion pin on the right main landing gear was found 'backed out', thereby releasing the right main landing gear trunnion.Oct 8, 1986 · N1233T · Minor damageNTSB MKC86LA200Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Lexington, MOThe student plt had taken the acft without the owner's permission & taxied onto a sod rwy. He rprtd that the acft almost became mired in mud on the sod rwy, so he added full power. The acft accelerated forward rapidly and the student lost control. The acft…Sep 29, 1986 · N6175B · Substantial damageNTSB MIA86LA257Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Cedar Key, FLDuring taxi after landing the pilot taxied on a parallel roadway that had aircraft parked on it. The left wing of the aircraft struck two parked aircraft causing minor damage to them. The taxiing aircraft sustained substantial damage.Sep 28, 1986 · N40070 · Substantial damageNTSB DEN86LA260Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Wright, WYAcft was taxiing for takeoff from driveway on private ranch. Plt said there was strong x-wing gusting from left to right. Plt said he was holding right rudder when wind velocity decreased. Wing tip struck post beside driveway, acft turned right, and rolled…Sep 26, 1986 · N7289K · Substantial damageNTSB CHI86IA231Incident · No injuriesIncident investigationFinal reportMitsubishi MU-300IA · Chicago, ILAfter landing the corporate jet was cleared to taxi to the general aviation ops to deplane pax. A food service truck crossing the taxiway failed to yield the right of way. The acft was unable to stop before the left wing struck the rear of the vehicle.Sep 25, 1986 · N19R · Minor damageNTSB CHI86IA225Incident · No injuriesIncident investigationFinal reportBoeing 727-25 · Evansville, INAfter the aircrew of eastern flt 254 (a Boeing 727, N8107N) had landed on rwy 22 at night & was slowing, the tower controller (ctlr) instructed them to 'turn right on taxiway bravo, if able, hold short of rwy 18 and remain this frequency.' The crew of flt 254…Sep 18, 1986 · N8107N · No damageNTSB LAX86LA356Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Monterey, CAThe private plt landed her acft & began taxiing toward a parking area. The driver of an acft fuel service truck observed the approaching acft, & he brought his truck to a complete stop in an authorized area for truck traffic. He was clear of the taxiway. The…Sep 17, 1986 · N2116J · Substantial damageNTSB LAX86LA354Accident · No injuriesLimited investigationFinal reportCessna 152 · El Monte, CAThe student pilot was taxiing to the run-up area when his left wing struck the corner of a hangar. The pilot stated he was paying attention to the right wing which was close to another aircraft at the time.Sep 16, 1986 · N95010 · Substantial damageNTSB ANC86LA155Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Naknek, AKDuring the taxi to takeoff phase a strong gust of wind lifted the left wing causing the airplane to flip over on its back.Sep 14, 1986 · N1712P · Substantial damageNTSB ATL86LA256Accident · No injuriesLimited investigationFinal reportCessna 310J · Bessemer, ALWhile taxiing for takeoff the plt attempting to taxi between two rows of parked acft. He used the left brake to maneuver the acft between the rows and could not stop the turn by using the right brake. The acft continued in the turn and struck a parked Cessna…Sep 13, 1986 · N3105L · Substantial damageNTSB ANC86LA164Accident · No injuriesLimited investigationFinal reportCessna 195A · Willow, AKThe pilot reported that while demonstrating high speed taxi, the airplane veered to the left, entered an open trench, and was damaged. An exam of the flight control and brake systems revealed no pre-accident mechanical malfunction or failure.Sep 9, 1986 · N9342A · Substantial damageNTSB MKC86LA178Accident · 1 fatalLimited investigationFinal reportCessna 172 · Emporia, KSThe acft was found stopped in an open field having penetrated the southern boundary of the Emporia airport property. The acft eng was still running when rescuers approached the location. Forced entry was made into the acft to shut the eng down and rescue the…Aug 26, 1986 · N3791R · Minor damageNTSB DEN86LA239Accident · No injuriesLimited investigationFinal reportPiper PA-23E-250 · Grand Forks, NDThe acft was en route from flin flon airport, manitoba, cd, to mason city, IA, and had stopped at Grand Forks, ND, for fuel and to clear customs. During taxi for takeoff, the acft struck a 1-inch concrete lip on the ramp and the right main landing gear…Aug 26, 1986 · N900TS · Substantial damageNTSB FTW86LA155Accident · No injuriesLimited investigationFinal reportCessna 172A · Gainesville, TXThe pilot was taxiing into position for takeoff, when there was a wind shift and a gust of wind inverted the aircraft. The pilot had not obtained any weather reports prior to taxiing out to the runway. There were thunderstorms in the area and a heavy rain…Aug 25, 1986 · N7261T · Substantial damageNTSB ANC86IA137Incident · No injuriesIncident investigationFinal reportCessna 207A · Togiak, AKAfter landing the airplane was taxiing to park and the pilot noticed the steering becoming stiff. He stopped the airplane and examined the nose gear and found it to have pivoted forward with the wheel coming to rest against the nose cowling. The mechanic…Aug 24, 1986 · N1472M · Minor damageNTSB DEN86IA235Incident · Minor injuriesIncident investigationFinal reportLockheed L-1011-385-1 · Denver, COTwa flt 735 landed at Denver stapleton arpt. During the taxi to the passenger terminal, a fire erupted in the tailpipe of the left engine. The flt crew executed the emergency evacuation procedures. Fire was extinguished. With no damage to the acft or engine.…Aug 22, 1986 · N31001 · No damageNTSB ANC86FA126Accident · No injuriesField investigationFinal reportCessna 185 · Anchorage, AKThe plts of Cessna 185 (C-185), N1802R, & Cessna 180 (C-180), N9418C, received clearance fm ground control to taxi to rwy 32 via taxiway-n (twy-n). Both acft were tailwheel (conventional gear) equipped. As the C-185 was proceeding along twy-n, the C-180 plt…Aug 16, 1986 · N1802R · 2 aircraft · Minor damageNTSB DEN86LA230Accident · No injuriesLimited investigationFinal reportCessna A188B · Langdon, NDWhile ground taxiing for takeoff the acft left main gear brake failed. During the ensuing right ground loop the left main gear collapsed and the left wing impacted the asphalt taxiway.Aug 10, 1986 · N2417J · Substantial damageNTSB ANC86FA118Accident · No injuriesField investigationFinal reportCessna 180 · Anchorage, AKA ground control (gnd ctl) trainee clrd Cessna 152 (C-152), N757WV, to taxi to rwy 6, then relinquished the gnd ctl psn to a full performance level (fpl) ctlr, who had just signed on duty. The fpl ctlr was aware of the lctn & taxi destn of the C-152, the fpl…Aug 1, 1986 · N2913C · 2 aircraft · Minor damageNTSB DEN86LA214Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Albuquerque, NMWhile taxiing for takeoff in strong gusty wind conditions the aircraft was blown into an inverted position on the taxiway.Jul 31, 1986 · N3809R · Substantial damageNTSB SEA86LA167Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Boise, IDWhile taxiing for takeoff an inadvertant ground loop occurred during which the acft veered left striking another parked acft. The plt stated it felt as though the tailwheel jammed; however, post accident exam failed to disclose any failure/malfunction.Jul 12, 1986 · N5636D · Substantial damage