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 ANC88FA056Accident · No injuriesField investigationFinal reportCessna U206 · Anchorage, AKA deaf-mute adult male, who has a history of mental health problems, and who was a mental health ward of the state of Alaska at the time of the accident, entered a Cessna 206 airplane equipped with amphibious floats without permission while it was parked on…May 14, 1988 · N4844X · Substantial damageNTSB CHI88LA112Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Sault Ste Marie, MIDuring taxi for take-off, the student pilot attempted to apply brakes as he neared the end of the runway. As the aircraft veered to the left, he noted that his right foot was not on the brake pedal. The aircraft left the taxiway and struck a fire hydrant,…May 7, 1988 · N15372 · Substantial damageNTSB DEN88LA103Accident · No injuriesLimited investigationFinal reportCessna 172G · Las Vegas, NMThe private plt and his daughter were on a cross country flight. Landing with a strong headwind and reported gusts to 31 knots, the plt taxied clear of the runway. A 90 degree turn crosswind on the taxiway resulted in wind lifting the left wing and a loss of…May 1, 1988 · N6059R · Substantial damageNTSB LAX88LA170Accident · No injuriesLimited investigationFinal reportCessna 150F · Hayfork, CAAfter landing and taxiing to parking, the pilot heard a noise, the pilot exited the airplane and noticed a fire in the engine compartment area. The airplane was consumed by fire shortly thereafter.Apr 28, 1988 · N6742F · Substantial damageNTSB NYC88LA134Accident · No injuriesLimited investigationFinal reportBeech C17B · Butler, PAAfter landing the airplane was taxiing on runway 08 when it went off the side of the runway and struck a runway light and taxi sign. While attempting to get back on the runway, the left gear collapsed.Apr 27, 1988 · N47024 · Substantial damageNTSB ATL88IA144Incident · No injuriesIncident investigationFinal reportCessna 152 · York, SCThe acft was to be ferried back to the home arpt after an eng overhaul. The plt rprtd it was located on rough/sod & required full power to taxi from the parking area. After the acft began moving, he attempted to make a rgt turn onto the taxiway. However, he…Apr 15, 1988 · N93802 · Minor damageNTSB FTW88LA089Accident · No injuriesLimited investigationFinal reportCessna 172K · Houston, TXThe high-wing, tricycle gear airplane was taxiing out in winds gusting to 29 knots from about 320 degrees. While the airplane was heading 250 degrees, it was overturned to the inverted position. Owner's manual does not list any restrictions for maximum…Apr 11, 1988 · N7116G · Substantial damageNTSB BFO88LA040Accident · No injuriesLimited investigationFinal reportCessna 340 · Pineville, WVThe pilot failed to maintain clearance from obstacles while taxiing the aircraft.Apr 7, 1988 · N340FB · Substantial damageNTSB ATL88LA133Accident · No injuriesLimited investigationFinal reportCessna 152 · Macon, GAThe acft was taxiing for departure when a gust of wind lifted the left wing and the acft overturned. The surface winds were reported at 16 knots with gusts to 27 knots. The plt stated that proper flight control inputs were used for taxiing in windy conditions.Apr 7, 1988 · N49409 · Substantial damageNTSB CHI88LA094Accident · No injuriesLimited investigationFinal reportCessna 172M · Champaign, ILThe pilot had just landed at the airport for refueling and was instructed by the tower to do a 180 degree turn on the runway and then make a left turn on the first taxiway. The pilot executed the 180 degree turn and while attempting to turn left (crosswind)…Apr 6, 1988 · N64508 · Substantial damageNTSB MIA88LA141Accident · No injuriesLimited investigationFinal reportCessna T-188C · Miami, FLWhile taxiing from landing after a maintenance test flight, the rt main wheel assy separated from the rt landing gear strut. The acft then went off the taxiway & came to rest in the grass. Examination of the rt landing gear revealed that the spring strut…Apr 5, 1988 · N2185J · Substantial damageNTSB FTW88LA088Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Bonham, TXOne airplane was taxiing out for departure at the same time two others were coming in to land. The first airplane landed and did a 180 on the runway to taxi back to the parking area. This required the second airplane to go-around. The airplane taxiing in…Apr 3, 1988 · N2044E · 2 aircraft · Substantial damageNTSB DCA88IA044Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-10-40 · Boston, MAThe improper installation of the battery ground connection that resulted in premature loosening of the connection and electrical arc ignition of pooled fuel in the cac bilge. The fuel was not drained overboard due to inoperative cac bilge area drain valves.…Mar 30, 1988 · N154US · Minor damageNTSB CHI88IA088Incident · Minor injuriesIncident investigationFinal reportBoeing 727-251 · Detroit, MIMar 28, 1988 · N277US · No damageNTSB CHI88LA085Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Indianapolis, INFifteen minutes after the pilot had taken off on a tow plane operation he returned to the local arpt. After landing he turned downwind to taxi to the ramp. The wind raised the tail of the tailwheel acft and nosed the acft inverted. The pilot estimated the…Mar 26, 1988 · N5044G · Substantial damageNTSB MKC88LA068Accident · No injuriesLimited investigationFinal reportCessna 172G · Springfield, MOThe pilot reported that while taxiing for takeoff a wind gust caught the wing of the aircraft resulting in loss of aircraft control. Aircraft moved nose down and the propeller and the right wing contacted the runway. Winds at the time of the accident were 180…Mar 24, 1988 · N72PF · Substantial damageNTSB ATL88LA122Accident · No injuriesLimited investigationFinal reportCessna 310Q · Donalsonville, GAThe pilot stated that he had experienced prior brake problems and had repeated maintenance performed. He further stated that not all of the brake problems had been corrected. After landing the pilot noticed that the right brake seemed 'spongy'. He continued…Mar 20, 1988 · N7765Q · DestroyedNTSB FTW88LA079Accident · Minor injuriesLimited investigationFinal reportAerotek Pitts S-2A · La Porte, TXA pitts S-2A taxing from landing collided with a Cessna 150 that was stopped on the taxiway waiting as #2 for takeoff. The pitts CFI said the duel student, a private plt, was taxing the pitts from the rear seat. The Cessna was seen by the pitts plts during…Mar 12, 1988 · N31441 · 2 aircraft · Minor damageNTSB NYC88LA106Accident · No injuriesLimited investigationFinal reportCessna 172 · Old Town, MEFollowing rollout from a normal landing in strong winds, and during a left turn onto the taxiway, the wing of the aircraft was lifted up by a quartering tailwind and flipped over.Mar 11, 1988 · N89219 · Substantial damageNTSB SEA88LA056Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Las Vegas, NVThe student pilot departed the airport for a cross country flight without filing a flight plan or obtaining a weather briefing. Upon returning to the originating airport he discovered that the winds were unfavorable for landing at that airport. The pilot then…Mar 10, 1988 · N98525 · Substantial damageNTSB ATL88IA107Incident · No injuriesIncident investigationFinal reportBoeing 737-232 · Atlanta, GAMar 10, 1988 · N310DA · Minor damageNTSB MIA88LA124Accident · Minor injuriesLimited investigationFinal reportHughes 269A · Opa Locka, FLStudent pilot lost control of helicopter during aerial taxi. The helicopter made ground contact and entered into ground resonance. When the instructor attempted to regain control of the helicopter he found the student frozen on the controls preventing him…Mar 9, 1988 · N8755F · DestroyedNTSB NYC88LA097Accident · No injuriesLimited investigationFinal reportBeech 1900 · Albany, NYThe Beech 1900 was taxiing out at night under the control of a ground taxi director and two wing walkers when its tail made contact with the tail of parked and unoccupied B-737. Both pilots said they did not see a stop signal from the taxi director. The wing…Feb 27, 1988 · N7243R · Substantial damageNTSB ATL88LA093Accident · No injuriesLimited investigationFinal reportErcoupe 415C · Spartanburg, SCWhen the pilot was unable to find assistance to remove the nose wheel chock from the aircraft, he applied enough power to jump the chock. He was unable to retard the throttle before colliding with a parked aircraft and striking a concrete wall.Feb 17, 1988 · N3631H · Substantial damageNTSB ANC88LA031Accident · No injuriesLimited investigationFinal reportCessna 170 · Healy, AKThe pilot stated that he was taxiing for takeoff when he lost directional control of the aircraft causing the plane to strike a small tree next to a snow covered taxiway.Feb 15, 1988 · N2601D · Substantial damageNTSB SEA88LA048Accident · No injuriesLimited investigationFinal reportCessna 172P · Friday Harbor, WAPlt was following taxi line and failed to note parked acft left wing intruding into taxi lane. Contact between left wing tips resulted.Feb 13, 1988 · N52794 · Substantial damageNTSB CHI88LA063Accident · No injuriesLimited investigationFinal reportCessna 152 · Lansing, MIWhile taxiing for takeoff the aircraft experienced a nose over when it contacted a snowbank. The instructor stated that she allowed the student pilot to taxi too fast and was unable to take control of the aircraft soon enough to avoid hitting the snowbank.Feb 13, 1988 · N49540 · Substantial damageNTSB ANC88LA030Accident · No injuriesLimited investigationFinal reportCessna 207 · Brevig Mission, AKThe pilot stated that while taxiing on the ramp perpendicular to the wind direction, a strong wind gust lifted the right wing and tail of the aircraft. The aircraft slowly turned over on its back.Feb 12, 1988 · N9950M · Substantial damageNTSB MKC88LA049Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Burlington, IAWhile taxiing out on a snow covered taxiway, during an air taxi operation, the aircraft struck an unmarked, unlighted, snow covered drainage hole, with the left landing gear. Substantial damage occurred to the left engine nacelle, the left wing spar, and the…Feb 10, 1988 · N2230D · Substantial damageNTSB DEN88LA053Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Casper, WYThe commercial plt was taxiing after landing during a fuel stop while on a long cross country flight. The plt landed on runway 21, a hard surface runway, 10,600 feet long by 150 feet wide. The winds were reported from 230 degrees at 22 knots, with gusts to 31…Jan 14, 1988 · N1879P · Substantial damageNTSB DEN88LA048Accident · No injuriesLimited investigationFinal reportRotorway Executive · Colorado Spring, COThe plt contacted ground control & was cleared to taxi from a hangar on the south end of the arpt to a hangar on the north end via twy-a. twy-a was located 400' west & parallel to rwy 17/35. The plt said he was air taxiing the helicopter just above the…Jan 9, 1988 · N7007B · DestroyedNTSB MIA88LA084Accident · No injuriesLimited investigationFinal reportDouglas C-118A · Miami, FLThe plt stated that while taxiing in the ramp area he turned the aircraft to park it & inadvertantly struck the horizontal stabilizer of a parked aircraft.Jan 6, 1988 · HRAKZ · Substantial damageNTSB MIA88IA079Incident · No injuriesIncident investigationFinal reportCessna U206G · Key West, FLWhile water taxiing nw from the ramp to takeoff with the wind from the north at 22 KTS, the rt wing lifted resulting in the lt float digging into the water. The plt attempted to correct this by turning into the wind and applying full-up right aileron but was…Dec 29, 1987 · N4820R · Minor damageNTSB MIA88IA072Incident · No injuriesIncident investigationFinal reportBoeing 727-231 · Miami, FLPlt was instructed to turn the tail to the right as viewed by the signal man during power back. As power back started the tail was turned to the left as viewed by the signal man. The signal man corrected this turn but the acft was now making a much larger arc…Dec 27, 1987 · N54344 · Minor damageNTSB MIA88LA076Accident · Minor injuriesLimited investigationFinal reportCrusenberry Windwagon · Lantana, FLWhile on a high speed taxi test the acft inadvertently became airborne. While looking out the rt side of the acft the plt rolled it into a rt bank. He then leveled the wings after which the acft stalled, touched down and separated the main landing gear wheels…Dec 26, 1987 · N5223C · Substantial damageNTSB MIA88LA075Accident · No injuriesLimited investigationFinal reportBoeing 727-200 · San Juan, PRN705AA was number two in position for takeoff behind N893AA. N705AA received takeoff clearance first and as it began to taxi to the runway it's left wing tip struck and passed under the right wing tip of N893AA.Dec 26, 1987 · N705AA · 2 aircraft · Substantial damageNTSB NYC88LA060Accident · Minor injuriesLimited investigationFinal reportBeech 58 · Flushing, NYAs the plts were taxiing at dusk to takeoff, the acft was struck by a food svc van at a vehicle svc road. The acdnt occurred as rain was falling & the ramp area was wet with standing water. The van driver said he had just maneuvered his vehicle to the left to…Dec 25, 1987 · N58MH · Substantial damageNTSB NYC88LA063Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Plymouth, MAThe aircraft was taxiing from a shop on the airport to runway 24 for a south end departure. The pilot stated that the left wing of the aircraft made contact with the parked truck causing substantial damage.Dec 24, 1987 · N32560 · Substantial damageNTSB LAX88LA073Accident · No injuriesLimited investigationFinal reportCessna 195A · Burbank, CAWhile holding short of the active rwy, the number one acft,N4309Y, was having radio problems. The tower began to clear other acft for takeoff. Two acft were able to get around the number one acft and takeoff. The third acft cleared to taxi into position did…Dec 21, 1987 · N4026A · 2 aircraft · Minor damageNTSB SEA88LA030Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · Aurora, ORA single engine aircraft was taxiing from the south end of the ramp area to the runway. A twin engine aircraft entered the taxiway in front of the single engine aircraft from the right of the taxiway. The single engine aircraft struck the twin engine aircraft…Dec 12, 1987 · N3275P · 2 aircraft · Substantial damageNTSB LAX88LA069Accident · No injuriesLimited investigationFinal reportCessna 172N · Tracy, CAThe surface wind was strong when the pilot began taxiing for takeoff. He did not obtain a preflight weather briefing for the flight. As the aircraft taxied from behind a hangar the strong wind lifted one of the wings and the aircraft rolled over on its back.Dec 12, 1987 · N734YZ · Substantial damageNTSB ANC88LA018Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Wasilla, AKThe pilot stated that he was taxiing for takeoff when he lost directional control of the aircraft causing the right main ski to break through the ice; the aircraft then ground looped.Dec 6, 1987 · N1237A · Substantial damageNTSB CHI88LA032Accident · No injuriesLimited investigationFinal reportCessna 180 · Carlton, MNThe plt rprtd that the left main gear collapsed as he started to taxi from the ramp area on a smooth grass surface. When the gear collapsed, the left wing dropped to the ground & was substantially dmgd. The plt rprtd the left gear leg had broken off 2 inches…Dec 5, 1987 · N2957C · Substantial damageNTSB NYC88LA048Accident · No injuriesLimited investigationFinal reportPiper PA-28-150 · Middletown, PAAfter landing the pilot was cleared to taxi to the parking area at stanbaugh's general aviation. During a maneuver between a de-icer truck and a parked airplane, the pilot allowed the aircraft to become too close to the truck and caught the wing tip on the…Dec 1, 1987 · N32307 · Substantial damageNTSB LAX88IA064Incident · No injuriesIncident investigationFinal reportBoeing 737-300 · Los Angeles, CADelta flt 1605 landed on rwy 25L. After crossing rwy 25R, the local controller instructed the flt to contact the gnd controller. The ground controller instructed the flt to turn west on the outer taxiway. The capt became disorientated and inadvertently…Dec 1, 1987 · N4571M · No damageNTSB ATL88LA039Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Murfreesboro, TNThe rt wheel brake failed while the airplane was taxiing on a parallel taxiway. The failure occurred near the end of the taxiway, just as the plt was about to turn the airplane onto the rwy. The plt subsequently attempted to turn the airplane using…Nov 14, 1987 · N41298 · Substantial damageNTSB NYC88DNE01Accident · 1 fatalFinal reportLamb Commander Elite · Meriden, CTThe pilot's failure to maintain control of the homebuilt gyrocopter while preforming low level 'fast taxi' maneuvers.Nov 4, 1987 · N501JL · Substantial damageNTSB MIA88LA027Accident · No injuriesLimited investigationFinal reportLearjet 35A · Clearwater, FLDuring taxi up to hangar under direction of lineman after arrival the flt experienced loss of hydraulic pressure and brakes. The plt could not activate the emergency brakes prior to rolling into the hangar and colliding with two acft prior to coming to rest.…Nov 4, 1987 · N900JE · Substantial damageNTSB DEN88LA019Accident · No injuriesLimited investigationFinal reportCessna 152 · Greeley, COThe recently certificated private plt was taxiing his acft to rwy 9 for a night takeoff. Another acft began its takeoff roll on rwy 9. As a courtesy, the taxiing plt switched off his taxi light so as not to blind the other plt. The taxiing plt used the glow…Nov 4, 1987 · N49209 · Substantial damageNTSB NYC88LA020Accident · No injuriesLimited investigationFinal reportAgusta 109A · Spring Valley, NYThe helicopter had been refueled and the pilot was attempting to ground taxi. Prior to turning the aircraft around to taxi to a parking area the helicopter went into ground resonance as soon as the aircraft was moved. Collective was lowered, the engine…Oct 30, 1987 · N109AM · Substantial damage