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 LAX95LA025Accident · No injuriesLimited investigationFinal reportCessna 172F · Tonopah, NVthe pilot's excessive taxi speed and improper remedial action after the nose gear began to shimmy. The nose gear shimmy (nose gear vibration) and the berm were factors in this accident.Oct 31, 1994 · N8210U · Substantial damageNTSB ANC95LA003Accident · No injuriesLimited investigationFinal reportCessna A185F · Kotzebue, AKA failure of the pilot to maintain adequate distance from the terrain (snow bank). Flat lighting and low contrast conditions were factors in the accident.Oct 15, 1994 · N20752 · Substantial damageNTSB CHI95LA010Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T-1A-2 · Mt. Horeb, WIthe pilot's excessive braking while taxiing from landing.Oct 10, 1994 · N933EB · Substantial damageNTSB FTW95LA012Accident · No injuriesLimited investigationFinal reportCessna 172H · Moro, AREngine compartment fire due to undetermined reasons.Oct 9, 1994 · N8181L · DestroyedNTSB SEA94LA218Accident · No injuriesLimited investigationFinal reportBeech 99 · Helena, MTLanding gear locking mechanism overload and improper rigging.Aug 20, 1994 · N14MV · Substantial damageNTSB ANC94LA113Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Skwenta, AKThe failure of the pilot-in-command to maintain adequate clearance from an object (tree).Aug 19, 1994 · N1785R · Substantial damageNTSB CHI94FA262Accident · 1 fatalField investigationFinal reportGrumman HU-16 · St. Ignace, MIThe pilot's failure to follow good seaplane operating practices by taxiing with power at forward thrust, with a tailwind, at a speed that necessitated using reverse thrust to arrest the excessive speed, and the pilot's misjudgment of his distance from the…Aug 2, 1994 · N7025N · Minor damageNTSB SEA94FA199Accident · 2 fatalField investigationFinal reportPiper PA-12 · Salem, ORFailure of the pilot to see-and-avoid the occupied canoe. Factors related to the accident were: the pilot's improper planning/decision and excessive taxi speed.Jul 31, 1994 · N2368M · Minor damageNTSB NYC94LA141Accident · No injuriesLimited investigationFinal reportBoeing Stearman PT-13 · Readington, NJThe failure of both pilots to maintain adequate visual lookout.Jul 31, 1994 · N2313 · 2 aircraft · Minor damageNTSB SEA94LA195Accident · No injuriesLimited investigationFinal reportPitts S-2B · Salt Lake City, UTThe inadequate visual lookout by the instructor and dual student. Factors include sunglare and the tug left on the taxiway.Jul 26, 1994 · N8026 · Substantial damageNTSB MIA94LA184Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Naples, FLFailure of the pilot-in-command to maintain wingtip clearance while taxiing resulting in the on-ground collision with a light pole.Jul 25, 1994 · N9236L · Substantial damageNTSB CHI94LA238Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Harvard, ILthe pilot's excessive taxi speed. A factor in the accident was the wet grass runway.Jul 15, 1994 · N8512C · Substantial damageNTSB MIA94LA166Accident · No injuriesLimited investigationFinal reportBritish Aerospace BAE 3201 · Orlando, FLInadvertent deactivation of the parking brake by the pilot-in-command. Contributing to the accident was the worn condition of the parking brake assembly.Jun 24, 1994 · N495UE · Substantial damageNTSB LAX94LA264Accident · No injuriesLimited investigationFinal reportCessna 210A · Mesquite, NVExhaustion of the brake system hydraulic fluid due to an inadequate annual inspection.Jun 24, 1994 · N6659X · Substantial damageNTSB BFO94FA092Accident · 2 fatalField investigationFinal reportCessna 172H · Millville, NJThe failure of the Cessna's pilot-in-command to perform an adequate visual lookout.Jun 9, 1994 · N4964R · 2 aircraft · DestroyedNTSB SEA94LA130Accident · Minor injuriesLimited investigationFinal reportLatter Christen Eagle II · Jackson Hole, WYThe failure of the pilot of the christen eagle ii, N246RL, to see and avoid the Cessna 172, N62463, and the pilot of the christen eagle ii diverting his attention from operation of his airplane.May 31, 1994 · N246RL · 2 aircraft · Substantial damageNTSB SEA94LA159Accident · Serious injuriesLimited investigationFinal reportde Havilland DHC-2 · Friday Harbor, WAThe pilot's accidental extension of his hand into the arc of the turning propeller. Factors include high winds during the docking process.May 26, 1994 · N6782L · No damageNTSB NYC94LA093Accident · No injuriesLimited investigationFinal reportCessna 172M · Groton, CTthe pilot's inadequate visual lookout during taxi, which resulted in the airplane's wing tip striking ground support equipment.May 24, 1994 · N6891H · Substantial damageNTSB MIA94LA149Accident · Serious injuriesLimited investigationFinal reportBeech 65 · Pensacola, FLImproper installation of nuts on the nosewheel (split rim) through-bolts by unknown personnel, which resulted in a subsequent failure (separation of the wheel halves).May 23, 1994 · N6166Y · Minor damageNTSB LAX94LA223Accident · No injuriesLimited investigationFinal reportGrumman AA-1C · Torrance, CAa fatigue failure of the carburetor fuel inlet fitting. A fuel flow system modification and an inadequate annual inspection were factors in the accident.May 23, 1994 · N9514U · DestroyedNTSB SEA94IA103Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas MD-83 · Seattle, WAThe fatigue fracture of a main gear wheel hub.Apr 18, 1994 · N931AS · Minor damageNTSB BFO94LA064Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Poughkeepsie, NYThe student pilot's failure to maintain control of the airplane immediately after engine start, and his delay in reducing power and applying the brakes.Apr 12, 1994 · N5962U · Substantial damageNTSB LAX94LA195Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Ramona, CAThe pilot of the other aircraft failed to maintain an adequate visual lookout.Apr 10, 1994 · N6319M · 2 aircraft · Substantial damageNTSB CHI94LA129Accident · Minor injuriesLimited investigationFinal reportSchweizer 269C · Hebron, NEThe failure of the student pilot to maintain adequate clearance from obstructions during aerial taxi.Apr 8, 1994 · N100LU · Substantial damageNTSB CHI94LA118Accident · No injuriesLimited investigationFinal reportCessna TU206B · Canton, ILthe pilot's inadequate compensation for wind conditions. A factor associated with the accident was the crosswind.Mar 21, 1994 · N3841G · Substantial damageNTSB CHI94LA109Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Benton, ILThe pilot's inadequate compensation for wind conditions. A factor associated with the accident was the tailwind.Mar 15, 1994 · N3263Z · Substantial damageNTSB CHI94LA107Accident · Minor injuriesLimited investigationFinal reportBeech 18S · Kansas City, MOthe failure of the driver of the ground vehicle to exercise proper visual lookout.Mar 15, 1994 · N90CA · Substantial damageNTSB ANC94LA038Accident · No injuriesLimited investigationFinal reportCessna 152 · Chugiak, AKThe failure of the student pilot to maintain directional control of the aircraft. Factors contributing to the accident were the frozen main landing gear brake shoe, the uncontrolled airport operations by airport personnel and extreme low temperature…Mar 5, 1994 · N6469B · Substantial damageNTSB FTW94IA099Incident · No injuriesIncident investigationFinal reportAerospatiale ATR-72 · Dfw Airport, TXThe blocked numer 1 engine drain manifold.Mar 4, 1994 · N253AT · Minor damageNTSB ATL94IA055Incident · No injuriesIncident investigationFinal reportCessna 421B · Lagrange, GAThe pilot's intentional swerve off the taxiway to avoid a ground collision. A factor in the incident was an undetermined malfunction of the airplane's normal brake system.Feb 28, 1994 · N421HA · Minor damageNTSB LAX94LA144Accident · No injuriesLimited investigationFinal reportCessna 421C · Tulare, CAthe pilot's use of an excessive taxi speed, and his misjudgment of the distance to the approaching intersection. A factor in the accident was the dark night lighting conditions which effected the pilot's perception of the taxiway layout.Feb 23, 1994 · N7039T · Substantial damageNTSB CHI94LA086Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Dowagiac, MIFailure of the pilot to maintain directional control, which resulted in an inadvertent ground swerve. Factors related to the accident were: the pilot's lack of experience in this make and model of aircraft, the crosswind, and snow beside the runway.Feb 13, 1994 · N81616 · Substantial damageNTSB LAX94LA122Accident · No injuriesLimited investigationFinal reportCessna 402C · Grand Canyon, AZThe failure of the other aircraft's left brake system due to a worn master cylinder, and the failure of the other pilot to taxi at a speed and spacing interval which would allow for successful remedial action.Feb 12, 1994 · N812AN · 2 aircraft · Substantial damageNTSB ANC94LA034Accident · No injuriesLimited investigationFinal reportCessna 206 · New Koliganek, AKThe pilot's failure to maintain control of the airplane. Factors in the accident were the strong crosswinds and the icy/snow covered taxi surface.Feb 11, 1994 · N60491 · Substantial damageNTSB MIA94LA068Accident · No injuriesLimited investigationFinal reportCessna 172RG · Orlando, FLThe failure of the student pilot to follow instuctions given by ground control and the failure of both pilots to maintain proper obstruction clearance between aircraft.Feb 6, 1994 · N9346D · 2 aircraft · Substantial damageNTSB MIA94LA065Accident · No injuriesLimited investigationFinal reportOconnell LAZER-200 · St. Petersburg, FLThe failure of the pilot of the conventional gear airplane to maintain a visual lookout for other aircraft.Feb 3, 1994 · N199J · 2 aircraft · Substantial damageNTSB ATL94LA045Accident · No injuriesLimited investigationFinal reportCessna 310R · Memphis, TNThe failure of the pilot of N2069C to follow the ATC directive to give way to N3844C, and the inadequate visual lookout by the pilot of N2069C. A factor was the dark night lighting condition at the time of the accident.Jan 28, 1994 · N3844C · 2 aircraft · Substantial damageNTSB LAX94LA105Accident · No injuriesLimited investigationFinal reportRockwell AC-112 · Modesto, CAthe worn/chafed landing gear wire which provided intermittent electrical power to the hydraulic pump.Jan 23, 1994 · N1084J · Substantial damageNTSB SEA94LA043Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Cheyenne, WYThe pilot's poor in flight decision. Factors include high winds, gusts, and the pilot's lack of total experience operating in high wind conditions.Dec 31, 1993 · N3734F · Substantial damageNTSB LAX94LA078Accident · No injuriesLimited investigationFinal reportBell 206B · Las Vegas, NVthe pilot's failure to properly position the helicopter away from the dolly edge during the initial touchdown.Dec 24, 1993 · N162BC · Substantial damageNTSB CHI94LA055Accident · No injuriesLimited investigationFinal reportCessna 185 · Grand Island, NEthe pilot's failure to maintain directional control of the airplane. A factor related to the accident was the gusty quartering tailwind condition.Dec 20, 1993 · N581JB · Substantial damageNTSB MIA94LA023Accident · No injuriesLimited investigationFinal reportPiper PA-60 · Orlando, FLThe failure of the pilot-in-command of the other aircraft to maintain a visual lookout and clearance between aircraft.Nov 15, 1993 · N91WW · 2 aircraft · Substantial damageNTSB SEA94LA025Accident · No injuriesLimited investigationFinal reportCessna T210F · Sheridan, WYThe pilot did not obtain proper assistance after landing in high wing conditions. Factors contributing to the accident were the strong, gusty wind conditions.Nov 3, 1993 · N6177R · Substantial damageNTSB NYC94LA026Accident · No injuriesLimited investigationFinal reportPiper PA-602P · Falls Of Rough, KYThe pilot's inadequate visual lookout prior to entering the runway, resulting in a taxi off the runway to avoid conflict, onto soft terrain, and the subsequent collapse of the landing gear.Oct 24, 1993 · N6891M · Substantial damageNTSB ANC94LA005Accident · No injuriesLimited investigationFinal reportPiper PA-18-180 · Pilot Point, AKThe Pilot-in-command's failure to compensate for the crosswind during taxi. The crosswind was a factor.Oct 3, 1993 · N3680Z · Substantial damageNTSB FTW94LA003Accident · No injuriesLimited investigationFinal reportCessna 208B · Dfw Airport, TXThe pilot's disregard for the issued safety advisory.Oct 2, 1993 · N9762B · Substantial damageNTSB ATL93LA164Accident · No injuriesLimited investigationFinal reportCessna 210 · Smyrna, TNThe inadequate maintenance of the taxiway.Sep 28, 1993 · N9640T · Substantial damageNTSB FTW93LA265Accident · No injuriesLimited investigationFinal reportPitts S1-T · Sherman, TXFailure to maintain visual lookout by the pilots in command of both aircraft.Sep 23, 1993 · N7FD · 2 aircraft · Substantial damageNTSB ANC93LA169Accident · No injuriesLimited investigationFinal reportCessna 180 · Sweet Lucy Lake, AKThe pilot in command's improper preflight planning and decision making. A factor in the accident was the high wind conditions.Sep 6, 1993 · N180TM · Substantial damageNTSB FTW93IA250Incident · No injuriesIncident investigationFinal reportCessna A185F · Pilottown, LAThe pilot in command becoming physically incapacitated (heart attack).Sep 2, 1993 · N6279E · No damage