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.
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" DESCRun it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB LAX08CA087Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Bremerton, WAThe pilot's failure to maintain directional control while taxiing. A contributing factor was the control interference on the rudder pedals created by the pilot's footwear.NTSB NYC08CA127Accident · No injuriesData collectionFinal reportCessna 172N · Charlottesville, VAThe pilot's improper engine starting procedures.NTSB MIA08CA074Accident · No injuriesData collectionFinal reportCessna 525B · Stuart, FLThe flight crew's failure to reset the brakes circuit breaker resulting in a loss of brakes during taxi and an on ground collision with an unoccupied parked airplane.NTSB MIA08FA070Accident · 3 fatalField investigationFinal reportUlrich Christen Velocity XL RG · Titusville, FLThe pilot of the Velocity’s failure to see and avoid the flight of four RV-8s that had landed and were in the process of clearing the runway.NTSB DFW08IA074Incident · No injuriesIncident investigationFinal reportBoeing 737-7H4 · Dallas, TXThe failure of the taxiing flight crew to maintain an adequate clearance from the stationary airplane.NTSB DCA08CA041Accident · No injuriesData collectionFinal reportEmbraer ERJ170 · Washington, DCInadequate ground separation maintained by the pilot of the Embraer E170.NTSB CHI08CA081Accident · No injuriesData collectionFinal reportCessna 425 · Cahokia, ILThe pilot not maintaining clearance from the runway sign during taxi for takeoff. A factor contributing to the accident was an icy taxiway.NTSB DFW08CA070Accident · No injuriesData collectionFinal reportCessna 172S · Jenks, OKThe owner of the parking surface's failure to ensure that the parking surface was clear of hazards to taxiing airplanes and the pilot's failure to ensure a safe taxi route in unfamiliar surroundings.NTSB NYC08LA091Accident · Minor injuriesLimited investigationFinal reportNorth American Rockwell NA-265-80 · Ft. Lauderdale, FLThe depletion of pressure in the normal hydraulic system for an undetermined reason, and the pilots' failure to properly operate the emergency braking system. Contributing to the accident was an inoperative hydraulic system aural warning.NTSB NYC08CA088Accident · No injuriesData collectionFinal reportBombardier 35A · Charlotte, NCThe tug driver's failure to stop for a taxiway stop sign.NTSB SEA08LA067Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-32 · Hollister, CAThe dual student's failure to maintain aircraft control while taxiing from the active runway and the delayed remedial action by the flight instructor. A contributing factor was the unfavorable high wind condition.NTSB ANC08IA033Incident · No injuriesIncident investigationFinal reportFairchild SA227-AC · Dutch Harbor, AKThe disengagement of the rudder control cable and loose rudder cable retaining pins. A factor contributing to the accident was a wind gust.NTSB CHI08IA065Incident · No injuriesIncident investigationFinal reportBoeing 737-2H4 · Lincoln, NEThe improper installation of the swivel valve fittings by the operator's mechanic leading to the total loss of both hydraulic systems. Contributing to the incident were the swivel valves leaking and the total failure of the hydraulic system.NTSB SEA08CA052Accident · No injuriesData collectionFinal reportCessna 172S · Fullerton, CAThe pilot's failure to maintain clearance while taxiing. Contributing to the accident was the pilot's diverted attention.NTSB ANC08LA029Accident · No injuriesLimited investigationFinal reportCessna 185 · Skwentna, AKThe pilot's selection of unsuitable terrain for taxi. Contributing to the accident were rough and uneven terrain, and an excessive taxispeed.NTSB MIA08CA040Accident · No injuriesData collectionFinal reportAgusta A109 · ST. Augustine, FLThe pilot's failure to maintain a visual lookout while taxiing.NTSB LAX08CA039Accident · No injuriesData collectionFinal reportCessna 310R · Phoenix, AZThe pilot's selection of a wrong taxi route, inadequate visual lookout, failure to maintain separation from ground obstacles, and excessive taxi speed.NTSB CHI08LA051Accident · Serious injuriesLimited investigationFinal reportBombardier CL-600-2B19 · Chicago, ILThe tug driver's failure to yield the right-of-way to the airplane prior to crossing the active taxiway as required by airport procedures, and his subsequent failure to maintain clearance with the airplane. A contributing factor was the presence of the tug on…NTSB SEA08CA047Accident · No injuriesData collectionFinal reportCessna 172S · El Cajon, CAThe excessive speed while turning off of the runway which resulted in a loss of aircraft control. The ditch was a factor.NTSB NYC08LA062Accident · No injuriesLimited investigationFinal reportBoeing B747-433BCF · New York, NYThe infringement of the parked EMB-190 into the airport movement area, and the B-747 crew's failure to maintain separation between the airplanes in conditions of darkness. Contributing to the accident was the contaminated ramp, which obscured airport markings.NTSB NYC08FA051Accident · 1 fatalField investigationFinal reportBeech 60 · New Castle, DEThe pilot's failure to maintain adequate airspeed during a split flap takeoff, which resulted in an aerodynamic stall. Contributing to the accident were the failure of the right flap drive mechanism and the pilot's failure to verify that both flaps were…NTSB MIA08LA014Accident · No injuriesLimited investigationFinal reportCessna C208B · Opa Locka, FLFailure of the local controller to coordinate with the ground controller and the failure of the pilots to see and avoid each other.NTSB MIA08CA012Accident · No injuriesData collectionFinal reportPiper PA-31-350 · Tuscaloosa, ALThe pilot's failure to maintain a visual look out while taxing resulting in an on-ground collision with a parked airplane.NTSB ANC08CA017Accident · No injuriesData collectionFinal reportCessna 172 · Nashville, TNA propwash encounter during taxi from a four-engine airplane that overturned the pilot's single-engine airplane when he elected to taxi across the larger airplane's propwash.NTSB SEA08CA018Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Stockton, CAThe pilot's failure to maintain clearance from a ditch while taxiing. Contributing factors were the pilot's inadequate visual lookout and the ditch.NTSB SEA08LA015Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Phoenix, AZThe failure of the solo student pilot operating the other airplane to maintain clearance while taxiing for takeoff.NTSB LAX08CA015Accident · No injuriesData collectionFinal reportCessna 172N · Daggett, CAThe flight's encounter with a strong gusty wind condition.NTSB DFW08CA008Accident · No injuriesData collectionFinal reportCub Crafters CC11-100 · Laurel, MSThe single-engine pilot's failure to avoid the jet blast while taxiing and the maintenance personnel's poor judgment to perform the engine ground run with the jet's engine exhaust directed across the taxiway.NTSB NYC08LA004Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Hartford, CTThe pilot's failure to maintain adequate clearance from a parked airplane while taxiing. Contributing to the accident was the proximity of the parked airplanes to the taxiway and the failure of the marshaller to provide adequate guidance.NTSB CHI08CA002Accident · No injuriesData collectionFinal reportPiper PA28-161 · Grand Forks, NDThe lack of experience and the excessive taxi speed by the pilot. A contributing factors was the airport sign.NTSB ATL07LA130Accident · No injuriesLimited investigationFinal reportDassault Mystere Falcon 900 · Teterboro, NJThe steamroller driver's improper decision to operate the vehicle without a wing walker present.NTSB NYC07LA214Accident · No injuriesLimited investigationFinal reportCessna 172R · Boston, MAThe air traffic controller's improper taxi clearance.NTSB ANC07LA094Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 MK1 · Kodiak, AKThe pilot's inadequate compensation for wind conditions while water taxiing. A factor contributing to the accident was wind gusts.NTSB NYC07LA209Accident · No injuriesLimited investigationFinal reportNorth American SNJ-2 · Farmingdale, NYThe number 5 airplane pilot's inadequate visual lookout.NTSB ANC07CA089Accident · No injuriesData collectionFinal reportCessna U206G · Iliamna, AKThe pilot's inadequate compensation for gusty wind conditions, which resulted in the float-equipped airplane's right wing striking the bottom of the shallow lake, while taxiing for takeoff. A factor contributing to the accident was the gusty wind condition.NTSB OPS07IA009Incident · No injuriesIncident investigationFinal reportBoeing 737-700 · Los Angeles, CAThe LAX north ground controller's failure to properly coordinate with the tower local controller prior to providing taxi instructions that permitted an aircraft to cross an active runway while another aircraft was departing. **This report was modified on…NTSB LAX07CA250Accident · No injuriesData collectionFinal reportCessna 182H · Page, AZthe pilot's failure to maintain clearance with obstructions while taxiing behind parked airplanes.NTSB CHI07CA270Accident · No injuriesData collectionFinal reportMooney M20J · Chesterfield, MOThe pilot failed to maintain directional control while taxiing after landing. A factor was the runway sign.NTSB CHI07FA184Accident · No injuriesField investigationFinal reportBoeing 777-222 · Chicago, ILThe 777-222's flight crew not maintaining clearance from the parked/standing MD 83 and the airport not coordinating the taxi chart instructions with air traffic control. Contributing to the accident was the MD 83's flight crew not following the taxi chart…NTSB ATL07CA098Accident · No injuriesData collectionFinal reportAmerican Champion 7GCBC · Coats, NCThe CFI's failure to maintain a visual look out while taxiing resulting in an on ground collision with a hole on the grass runway and collapse of the right main landing gear.NTSB SEA07CA171Accident · No injuriesData collectionFinal reportRobinson R22 Beta II · Park City, UTThe pilot's failure to maintain rotor RPM during hover taxi. A contributing factor was the high density altitude weather condition.NTSB NYC07CA128Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Nashua, NHThe flight instructor's inadvertent entry into a vortex ring state (settling with power). Factors to the accident was the tailwind.NTSB DFW07CA121Accident · No injuriesData collectionFinal reportPiper PA-44-180 · Lubbock, TXThe failure of the engine fuel supply line and the separation of the number one cylinder exhaust pipe resulting in an engine fire.NTSB LAX07CA157Accident · No injuriesData collectionFinal reportPiper PA-38-112 · Mariposa, CAThe pilot's failure to maintain clearance from a vehicle while taxiing.NTSB CHI07CA143Accident · No injuriesData collectionFinal reportPiper PA-28R-200 · Cincinnati, OHThe pilot's improper decision to leave the aircraft unattended while the engine was running. A factor in the accident was the disengagement of the parking brake.NTSB MIA07CA093Accident · No injuriesData collectionFinal reportPiper J5A · Richmond, VAThe improper positioning of the elevator flight control surface by the pilot-in-command while taxiing with a tailwind, resulting in the airplane nosing over.NTSB DFW07CA099Accident · No injuriesData collectionFinal reportCessna 152 · San Antonio, TXThe single-engine pilot's failure to avoid the jet blast while taxiing and the ground controller's inattentiveness to the situation, which resulted in the airplane's being blown over.NTSB NYC07LA104Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Richmond, VAThe improper installation of the right brake assembly by maintenance personnel.NTSB NYC07CA097Accident · No injuriesData collectionFinal reportCessna A185F · Ashland, METhe pilot's failure to maintain aircraft control while taxiing, which resulted in a nose over. A factor in this accident was the frozen, slush covered lake.NTSB ANC07LA028Accident · No injuriesLimited investigationFinal reportCessna 150 · Willow, AKThe student pilot's failure to maintain directional control while taxiing, which resulted in the airplane contacting a snow berm and nosing down. Factors associated with the accident were the snow and ice covered runway, and excessive taxispeed.