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 MIA88LA016Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Ft. Myers, FLAccording to a witness the acft was taxiing slowly but at a higher than normal RPM. When the acft was stopped in the runup area, the right main landing gear caught on fire burning the bottoms of both wings. Examination of the brakes revealed that the linings…Oct 22, 1987 · CFZJY · Substantial damageNTSB CHI88LA006Accident · No injuriesLimited investigationFinal reportCessna 150J · Springfield, ILWhile taxiing back to the parking ramp, after a short instructional flight, the student and flight instructor were looking ahead into the parking area for a vacant parking place. While they were searching for a place to park, the right wing of the aircraft…Oct 19, 1987 · N60481 · Substantial damageNTSB MIA88IA011Incident · No injuriesIncident investigationFinal reportCASA C-212-200 · Mayaguez, PRThe commuter flt was taxiing to the gate, when the plt observed a fire warning light for the no 2 eng. The fire bottle was discharged & the fire was extinguished. An exam revealed that a fuel line, p/n 3103385-1, had broken and had started a fire. An exam of…Oct 15, 1987 · N436CA · Minor damageNTSB MIA88LA015Accident · No injuriesLimited investigationFinal reportCessna 310P · Bay St. Louis, MSAccording to the plt, the acft was being taxied to takeoff when it struck a drainage ditch at approximately 65 mph, collapsing the landing gear, damaging both wings, both engines, props & the fuselage structure. After this accident the acft was seized by U.S.…Oct 13, 1987 · N5770M · Substantial damageNTSB SEA88LA005Accident · No injuriesLimited investigationFinal reportCessna 340A · Tacoma, WAAs the plt was taxiing to the active rwy, the acft's right brake became inop due to a loss of hydraulic fluid. Subsequently, the acft went off the side of the taxiway, contd over an embankment & was damaged. The loss of hydraulic fluid was due to a leak in…Oct 11, 1987 · N37358 · Substantial damageNTSB FTW88LA004Accident · No injuriesLimited investigationFinal reportCessna L-19 · San Marcos, TXOn touchdown the aircraft's left main tire was flat. Control was lost when the pilot attempted to taxi off the active runway. The aircraft slid off the runway into some grass causing substantial damage to the aircraft.Oct 7, 1987 · N305DH · Substantial damageNTSB ATL87LA267Accident · No injuriesLimited investigationFinal reportEnstrom F-28A · Mansfield, OHThe plt reported that the helicopter made an uncommanded turn to the right and rolled to the left as she was hover-taxiing away from the hangar toward the takeoff area. The acft subsequently impacted the terrain and came to rest on its left side. Post-crash…Sep 30, 1987 · N29GC · Substantial damageNTSB NYC87LA267Accident · No injuriesLimited investigationFinal reportGrumman AA-5A · Irwin, PADuring taxi operation, the pilot lost directional control of the aircraft and it struck a tree stump which was located to the side of the runway. The aircraft then continued to roll about 500 feet off the rwy where it came to rest with substantial damage.Sep 26, 1987 · N9772U · Substantial damageNTSB MKC87LA176Accident · Minor injuriesLimited investigationFinal reportEllsworth Varieze · Lebanon, MOThe PIC was back-taxiing down rwy 18 with a planned dept to the north. The PIC stated that he applied brakes in order to modify his direction during the taxi, but the brake failed to compensate. The PIC further stated that he applied more pwr in an attempt to…Sep 21, 1987 · N24GE · DestroyedNTSB BFO87FA065Accident · No injuriesField investigationFinal reportBeech 58 · Baltimore, MDDuel alternator failure occurred abt 13 min aft dept. The acft returned and lndd uneventfully. However, while taxiing back to the maint hgr the plt failed to follow the marked taxiway and collided with a ditch. Construction was taking place on the arpt and…Sep 16, 1987 · N150TC · Substantial damageNTSB MIA87LA247Accident · No injuriesLimited investigationFinal reportBeech 200 · Tampa, FLThe plt stated that as he was taxiing to the ramp, his attention was momentarily diverted away from the clearance between the left side of the wing tip & the building's steel support when the trailing edge of the aileron contacted the support.Sep 15, 1987 · N211PD · Substantial damageNTSB FTW87LA217Accident · No injuriesLimited investigationFinal reportCessna 401A · Wichita Falls, TXThe pilot stated that the right engine quit after landing at the Wichita Falls, Texas airport. A witness stated that he attempted to start the engine several times when the right wing exploded during the last attempted engine restart. Damage was concentrated…Sep 14, 1987 · N6249Q · Substantial damageNTSB ATL87FA250Accident · Minor injuriesField investigationFinal reportBritish Aerospace 3101 · Atlanta, GAThe airplane was struck by an eastbound, airline employee bus while taxiing south on the ramp to the assigned gate. The bus impacted the acft rt wing tip. A pax in the bus reported that she warned the bus driver to watch out for the airplane prior to the…Sep 8, 1987 · N407MX · Substantial damageNTSB ANC87LA130Accident · No injuriesLimited investigationFinal reportCessna 180F · Cordova, AKThe wind was blowing from the south at approximately 15 knots gusting 30 knots. As he was turning off the runway, the pilot lost directional control of the aircraft causing the aircraft to ground loop on the taxiway.Aug 31, 1987 · N25722 · Substantial damageNTSB ATL87LA247Accident · No injuriesLimited investigationFinal reportMooney M20F · Put In Bay, OHThe plt heard a loud 'snap' while taxiing to the rwy, and the ldg gear collapsed immediately thereafter. The plt observed that the gear handle was still in the down-and-locked position and that the green 'gear down' light remained illuminated. FAA exam of the…Aug 29, 1987 · N9784M · Substantial damageNTSB ATL87LA242Accident · No injuriesLimited investigationFinal reportCessna 182 · St. Joseph, TNThe plt took off from an arpt that was aprx 27 mi west of his destn. After takeoff, he rcvd an inflt wx briefing & flew north of a line of thunderstorms (tstms). Before lndg at the destn, he noted tstm activity south of the arpt, but contd the apch & lndd.…Aug 27, 1987 · N9065T · Substantial damageNTSB FTW87LA200Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Mc Allen, TXThe right main landing gear collapsed for unknown reasons as the aircraft was taxiing for takeoff. The pilot has not responded to requests to complete an accident report form. According to airman records, the pilot did not have a multiengine rating.Aug 16, 1987 · N5437Y · Substantial damageNTSB NYC87LA231Accident · No injuriesLimited investigationFinal reportCessna 172 · Islip, NYAfter landing on an instructional flight, Cessna 172, N9425D, experienced brake failure due to a broken hydraulic fluid line. N9425D rolled into another Cessna. Both aircraft received sustantial damage.Aug 11, 1987 · N9425D · 2 aircraft · Substantial damageNTSB FTW87DQG02Accident · No injuriesFinal reportPiper PA-25 · Lubbock, TXThe toe of the pilots left boot was rubbing on the dispensing hopper which restricted application of rudder and brake. This resulted in a loss of control when exiting the runway and the resultant collision with a sign. The fiberglass hopper had deep abrasions…Aug 5, 1987 · N6400Z · Substantial damageNTSB CHI87LA184Accident · No injuriesLimited investigationFinal reportCessna 172Q · Belleville, MIAlthough the plt saw a dark wx area apch the arpt he elected to shoot a touch and go before terminating the flt. After touchdown and during taxi twr advised wind was 270 degrees at 40 KTS. The pilot continued taxi to the south and the wind nosed the acft down.Aug 2, 1987 · N96593 · Substantial damageNTSB DEN87LA205Accident · No injuriesLimited investigationFinal reportCessna 172C · Cut Bank, MTThe plt stated that she radioed the Cut Bank fss and was told that the wind was 060 degrees at 41 knots. She then landed the acft uneventfully. However, while turning 90 degrees off the rwy onto a taxiway, the acft nosed over.Aug 1, 1987 · N9748T · Substantial damageNTSB NYC87LA228Accident · No injuriesLimited investigationFinal reportCessna 172 · Groton, CTThe aircraft was taxiing to the ramp after landing. While the pilot was maneuvering the aircraft into a parking space, the aircraft was positioned in such a way that the sun had blinded him temporarily. As the pilot turned the aircraft the left wing contacted…Jul 31, 1987 · N53461 · Substantial damageNTSB DEN87LA202Accident · No injuriesLimited investigationFinal reportRushton Sophwith Camel · Carrington, NDThe canadian private plt made an unscheduled fuel stop while on a cross country flight. During taxi from landing, the aircraft encountered a strong gusting crosswind. The left wing lifted and the aircraft nosed over.Jul 31, 1987 · CGNAT · Substantial damageNTSB DEN87LA204Accident · No injuriesLimited investigationFinal reportBell 47J-2 · Canon City, COThe ATP plt was flying sightseeing rides. There were two adults and two children in the four passenger helicopter. Density altitude was 10000 feet. The acft lost pwr and the plt aborted takeoff and landed. After an eng runup the plt took off again and the…Jul 30, 1987 · N73265 · Substantial damageNTSB MIA87LA214Accident · No injuriesLimited investigationFinal reportBoeing 747-287B · Miami, FLDuring lndg the entire length of the rwy was used due to an inop no 2 eng reverser. Only brakes were used to slow down the acft and taxi to the gate. The plt stated that he had arrived at the gate, set the parking brake, and was notified that the wheel chocks…Jul 25, 1987 · LVOPA · Substantial damageNTSB LAX87LA280Accident · No injuriesLimited investigationFinal reportCessna 320D · Banning, CAWhile taxiing to the runway, the right main and nose gear traveled off of the taxiway. The plt added power to the right engine and applied left brake, however, the plt stated that when power was added, the ground speed also increased. The acft traveled off…Jul 24, 1987 · N3322Q · Substantial damageNTSB LAX87LA273Accident · No injuriesLimited investigationFinal reportGrumman AA-5B · Lake Tahoe, CAWhile taxiing to the rwy, the plt stated that the right brake failed. The acft rolled off the taxiway and collided with a transformer. Inspection of the brake revealed that the brake linings were worn and that the piston in the hydraulic cylinder had traveled…Jul 20, 1987 · N28452 · Substantial damageNTSB CHI87LA174Accident · No injuriesLimited investigationFinal reportCessna 172N · Troy, MIThe plt lndd at ngt & taxied the acft to a hangar area for a passenger stop. After the passenger deplaned, the plt proceeded to make a u-turn around a t-hangar & onto an automobile service road that wasn't normally used for acft. Whilethe plt was attempting…Jul 20, 1987 · N6341D · Substantial damageNTSB MKC87LA142Accident · No injuriesLimited investigationFinal reportCessna 172 · Kansas City, MOAfter lndg, the PIC was clrd to taxi to the g/a ramp. He was not aware of the new g/a ramp & proceeded toward the old ramp. He saw a large acft coming from the opposite drctn on the same twy, so he modified his route by selecting another way. Mistakenly, he…Jul 19, 1987 · N6603H · Substantial damageNTSB MIA87LA210Accident · No injuriesLimited investigationFinal reportCessna 152 · Miami, FLWhile taxiing from landing in reduced visibility the instructor plt stated that he was unable to establish whether or not the acft was on a taxiway. He was then attempting to reverse direction when the rt wing collided with a fence.Jul 17, 1987 · N49817 · Substantial damageNTSB ATL87DEK01Accident · No injuriesFinal reportSmith, Ted Aerostar Aerostar 600 · Columbus, OHThe pilot taxied off an unlighted taxiway into a large drainage ditch while taxiing to a parking ramp. The pilot thought he was on the taxiway but the right landing gear was on a portion of the drainage ditch retaining wall. The rt landing gear collapsed. The…Jul 14, 1987 · N127GS · Substantial damageNTSB LAX87LA250Accident · No injuriesLimited investigationFinal reportde Havilland DHC-6-300 · Grand Canyon, AZWhile taxiing for takeoff, the underside of the left wing struck the boom of a backhoe parked adjacent to the aircraft ramp. The unattended backhoe was parked in a dirt area adjacent to the ramp with the boom in the extended position while the operator was on…Jun 29, 1987 · N74GC · Substantial damageNTSB MKC87LA129Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Bull Shoals, ARThe pilot stated the winds were four to five mph from the sw as he departed and he could see thunderstorms four or five miles to the west. He overflew his destination when he saw large waves on the water. He landed in a smooth-water cove and was taxiing…Jun 28, 1987 · N9161C · Substantial damageNTSB ATL87LA185Accident · No injuriesLimited investigationFinal reportBeech 200C · Madisonville, KYThe acft struck a 2-FT hi avgas pump while the plt was taxiing around another acft that was parked. The nose gear collapsed & a small fire resulted. The plt & pax evacuated the acft. Line psnl were unable to extinguish the fire with hand-held extinguishers.…Jun 24, 1987 · N617MS · DestroyedNTSB NYC87LA176Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Towanda, PAThe Taylorcraft, N43978, collided with the tail of Piper, N4889L while both were taxiing to rwy 22. The plt of the Taylorcraft stated that he was taxiing parallel to the rwy and the Piper came from behind and to the left to cross in front of him. The plt of…Jun 14, 1987 · N4889L · 2 aircraft · Substantial damageNTSB ANC87IA077Incident · Minor injuriesIncident investigationFinal reportBoeing 727-90C · Anchorage, AKThe mechanic in charge of taxiing the Boeing 727 allowed an unauthorized avionics technician to occupy the pilot seat. They inadvertently deactivated the brake pressurization system and struck a passenger jetway at the terminal gate. An ensuing fire destroyed…Jun 9, 1987 · N766AS · DestroyedNTSB MIA87LA174Accident · No injuriesLimited investigationFinal reportCessna 172P · Tallahassee, FLWhile taxiing to take off the left wing collided with an utility pole.Jun 7, 1987 · N109ER · Substantial damageNTSB ATL87FA161Accident · No injuriesField investigationFinal reportCessna 208B · Atlanta, GAThe two acft collided on a ramp while each was taxiing to rwy 8L for t/o. both acft were authorized by ATC to taxi to the rwy; the Cessna was instructed by ATC to follow the Beech. The two acft were hdg in the same general direction on converging paths when…Jun 5, 1987 · N917FE · 2 aircraft · Substantial damageNTSB LAX87FA219Accident · Serious injuriesField investigationFinal reportBoeing 727-264 · Los Angeles, CAThe aircraft landed on rwy 25 left and was holding short of 25 right for a crossing clearance when the flight engineer started the APU. Passengers seated in the area between rows 20 and 22 on the right side of the cabin observed a 'bright' yellow blossoming…Jun 1, 1987 · XAFIE · No damageNTSB DEN87LA136Accident · No injuriesLimited investigationFinal reportCessna 180 · Upton, WYThe plt reported completing a cross wind landing with strong gusts. While taxiing from landing, the wind lifted the acft from the right and it nosed over. The rwy used was 13, and the FBO reported winds as 210 degrees at 20 knots, gusting to 40 knots.May 27, 1987 · N2933C · Substantial damageNTSB DEN87LA132Accident · No injuriesLimited investigationFinal reportCessna 152 · Broomfield, COThe student plt had finished practicing touch and go landings on an unsupervised solo flt. During taxi to parking, a gust of wind lifted the left wing and the acft was pushed off the taxiway to the right. The nose gear dropped off a culvert and the right main…May 23, 1987 · N89834 · Substantial damageNTSB SEA87LA097Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Yakutat, AKWhile taxiing, after landing on a murky river, the pilot did not see a sand bar. The aircraft struck the sand bar and the aircraft then nosed over inverted. The plt did not file an acc rpt and held a canadian pilot certificate.May 18, 1987 · CFCLL · Substantial damageNTSB MKC87LA111Accident · No injuriesLimited investigationFinal reportCessna 150H · Miami, MOThe pilot had completed the landing at a private airport and was taxiing at the edge of the gravel runway. He hit a clump of grass and dirt and partially collapsed the nose gear.May 11, 1987 · N6561S · Substantial damageNTSB FTW87LA115Accident · No injuriesLimited investigationFinal reportCessna 172 · Amarillo, TXAfter landing, the pilot attempted to taxi the aircraft to the ramp when he encountered strong gusty winds. The passenger and four linemen attempted to hold the aircraft down, but the winds blew the aircraft over inverted causing substantial damage.May 3, 1987 · N7259A · Substantial damageNTSB FTW87LA113Accident · Minor injuriesLimited investigationFinal reportBoeing 707-323C · Oklahoma City, OKAfter engine start ground personnel experienced difficulty disconnecting the airstart unit hose. The ground signalman left the view of the crew to assist the other men in an effort to disconnect the unit from the aircraft. The pilot assuming that all was…May 1, 1987 · N8404 · Substantial damageNTSB CHI87LA118Accident · No injuriesLimited investigationFinal reportPiper J3C · Midland, MIWhile taxiing to runway 24 run up area the aircraft flipped over onto its nose. The pilot stated a gust of wind caught the plane from behind. Winds at the tri-city airport, 12 miles southeast of Midland, were reported from 130 degrees at 6 knots.Apr 26, 1987 · N6AJ · Substantial damageNTSB DEN87LA106Accident · Minor injuriesLimited investigationFinal reportShort Brothers SC7 · Denver, COThe plt said that he made a normal crosswind landing on rwy 26L at stapleton international arpt, Denver, Colorado. After leaving the rwy and taxiing parallel to the rwy he observed the wind increasing in velocity. He stopped the acft but a strong gust of wind…Apr 20, 1987 · N20DA · Substantial damageNTSB ATL87LA125Accident · No injuriesLimited investigationFinal reportCessna 150J · Waverly, TNThe plt reported that he was taxiing to the rwy when the 'rudder failed to turn the (airplane) onto the rwy and the left brake failed.' The airplane subsequently ran off the end of the taxiway, traveled approx. 50 ft., went over a steep dropoff and collided…Apr 20, 1987 · N60696 · Substantial damageNTSB MIA87LA140Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Zellwood, FLThe plt stated that after landing he allowed the coplt to taxi the acft though he followed him through on the controls due to his lack of experience on tailwheel acft. The acft veered off the left side of the rwy and before control could be re-established by…Apr 19, 1987 · N33592 · Substantial damageNTSB ATL87LA117Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Columbus, OHWhile taxiing for takeoff on a local flight, the aircraft collided with a parked fuel truck. The pilot said he saw the parked truck and attempted to taxi between it and some parked aircraft. The pilot said he misjudged the clearance and the left wing struck…Apr 17, 1987 · N2183D · Substantial damage