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 GAA16CA138Accident · No injuriesData collectionFinal reportCessna 170 · Enumclaw, WAThe pilot's incorrect brake application during taxi, which resulted in a nose over.NTSB DCA16WA097Accident · Serious injuriesForeign investigationBoeing 737 · Chitose, JapanThe government of Japan has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on February 23, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of Japan's investigation under the provisions of…NTSB DCA16CA094Accident · No injuriesData collectionFinal reportBoeing 737 · Detroit, MIN925NN flight crew's incorrect evaluation of the clearance between the two aircraft, leading to the inadvertent collision of the winglet with the horizontal stabilizer and elevator of N784SW.NTSB GAA16CA132Accident · No injuriesData collectionFinal reportConsolidated Vultee BT 15 · Chino, CAThe taxiing pilot's failure to remain a safe distance from the stopped airplane while taxiing to the run-up area, resulting in a ground collision and substantial damage.NTSB GAA16CA127Accident · No injuriesData collectionFinal reportCessna 150 · Santa Paula, CAThe tailwheel pilot's failure to see and avoid a stationary airplane performing a run-up, which resulted in a ground collision.NTSB GAA16CA119Accident · No injuriesData collectionFinal reportPiper PA 28-161 · Everglades, FLThe pilot's failure to maintain adequate wing clearance while taxiing, which resulted in a collision with two unoccupied airplanes.NTSB ERA16WA099Incident · No injuriesForeign investigationCessna 550 · Istanbul, TürkiyeOn January 15, 2016, at 1103 Universal Coordinated Time (UTC), a Cessna 550 Citation I, Turkish registration TC-AHE, operated by Panjet, received minor damage during taxi after landing at Istanbul Atatürk Airport, Instanbul, Turkey (LTBA). The flight…NTSB GAA16CA096Accident · No injuriesData collectionFinal reportCessna 172 · Punta Gorda, FLThe student pilot's failure to maintain obstacle clearance while taxiing on the ramp, resulting in a collision with an object.NTSB DCA16LA032Accident · No injuriesLimited investigationFinal reportBoeing 737 3H4 · Nashville, TNthe flight crew's early turn towards the assigned gate because taxiway lighting had been inadvertently turned off by the controller-in-charge which resulted in the airplane leaving the paved surface. Contributing to the accident was the operation of the…NTSB GAA16CA051Accident · No injuriesData collectionFinal reportPiper PA 31-350 · Portland, ORThe failure of the fuel truck driver to see and avoid the taxiing airplane.NTSB GAA16CA058Accident · No injuriesData collectionFinal reportCessna 172 · Greeley, COThe pilot of the following airplane failed to maintain adequate spacing during the taxi to the runway, resulting in a collision with the lead airplane.NTSB GAA16CA052Accident · No injuriesData collectionFinal reportCessna 172S · Alcoa, TNThe pilot's failure to identify the taxiway, which resulted in a runway excursion and impact with terrain while turning off the runway at night.NTSB CEN16LA052Accident · No injuriesLimited investigationFinal reportCessna 208B · Chicago, ILThe failure of the driver of the service vehicle to yield to the taxiing airplane, which resulted in a near-collision and tail strike.NTSB DCA16FA013Accident · Serious injuriesField investigationFinal reportBoeing 767 · Fort Lauderdale, FLthe separation of the flexible fuel line coupling and subsequent fuel leak due to the failure of maintenance personnel to install the required safety lockwire. Contributing to the severity of the accident was the initiation of the evacuation before the right…NTSB CEN16LA023Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · New Century, KSThe pilot’s application of excessive brake pressure to maintain a safe taxi speed during a long, slightly downhill taxi with a strong quartering tailwind, which resulted in a brake fire.NTSB GAA16CA042Accident · No injuriesData collectionFinal reportCessna 421 · Amarillo, TXThe loss of directional control during taxi to the runway as a result of insufficient brake fluid level in the right brake master cylinder, resulting in a taxiway excursion and collision with a drainage culvert.NTSB GAA16CA034Accident · No injuriesData collectionFinal reportCessna 182R · Abilene, TXThe pilot's diverted attention while taxiing, which resulted in a collision with a fence post.NTSB CEN16LA008Accident · No injuriesLimited investigationFinal reportBeechcraft A36 · Dallas, TXThe pilot’s improper navigation onto a vehicle service road while taxiing and his subsequent distraction while looking at an airport diagram, which led to the airplane impacting a fence post.NTSB GAA16CA005Accident · No injuriesData collectionFinal reportRaytheon A36 · Monterey, CAThe pilot's failure to see and avoid runway signage during taxi after landing, resulting in a collision and substantial damage to the left wing of the airplane.NTSB ERA16LA004Accident · No injuriesLimited investigationFinal reportBeech 58 · Albany, GAThe mechanic's inadequate inspection of the brake system during the most recent annual inspection, which resulted in the failure of both left and right main landing gear torque plates and a subsequent loss of braking action.NTSB DCA15CA176Accident · Serious injuriesData collectionFinal reportBoeing 737 7H4 · Oakland, CAinadvertent jet blast, resulting in debris striking ground operations personnel.NTSB GAA15CA303Accident · No injuriesData collectionFinal reportMitsubishi MU 2B-25 · Arvin, CAThe pilot's failure to maintain clearance from trees while taxiing into position for takeoff on a narrow private airstrip, resulting in the left wing striking a tree.NTSB GAA15CA233Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 · Prescott, AZThe flight instructor's decision to turn the helicopter downwind during a hover taxi which resulted in an uncontrolled descent and impact with terrain.NTSB DCA15WA180Incident · No injuriesForeign investigationBoeing 747 · Frankfurt, GermanyThe German Federal Bureau of Aircraft Accident Investigation (BFU) has notified the NTSB of an incident involving a Boeing 747 airplane, which occurred on August 11, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the government of…NTSB GAA15CA215Accident · No injuriesData collectionFinal reportCessna 560XL · Spanish Fork, UTThe Captain's decision to taxi on a closed taxiway, which resulted in a collision with a parked construction vehicle. Contributing to the accident was a ground crew employee's decision to move barricades from the closed taxiway.NTSB DCA15WA170Incident · No injuriesForeign investigationAirbus A320 - 214 · Padang, IndonesiaThe National Transportation Safety Committee of Indonesia (KNKT) has notified the NTSB of an incident involving a AIRBUS A320, which occurred on August 02, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the KNKT investigation under…NTSB CEN15LA334Accident · Minor injuriesLimited investigationFinal reportCessna 208B · Chicago, ILAn encounter with a wind gust during ground maneuvering and the captain’s improper flight control positioning to account for wind conditions, which resulted in the airplane being blown onto its left wing.NTSB DCA15WA182Incident · No injuriesForeign investigationBombardier CL600 2E25 · Makassar, IndonesiaThe National Transportation Safety Committee of Indonesia (KNKT) has notified the NTSB of an incident involving a CRJ-1000, which occurred on August 27, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the KNKT investigation under the…NTSB WPR15LA234Accident · No injuriesLimited investigationFinal reportCessna 180J · Dixie, IDThe failure of the right brake hydraulic line during taxi due to fatigue, which caused a loss of hydraulic fluid and rendered the brake inoperative.NTSB CEN15RA446Incident · No injuriesForeign investigationCessna 525 · Geneva, SwitzerlandNTSB ERA15LA288Accident · No injuriesLimited investigationFinal reportCanadair CL-600-2B16 · West Palm Beach, FLThe flight crew's failure to properly use the before start checklist, to monitor the airplane's motion, and to see and avoid objects around the airplane, which resulted in an inadvertent roll into a ground vehicle.NTSB GAA15CA173Accident · No injuriesData collectionFinal reportCessna 182 · Athens, TNThe failure of the taxiway surface due to a sink hole, which resulted in the right main landing gear sinking into terrain causing substantial damage to the fuselage.NTSB GAA15CA167Accident · No injuriesData collectionFinal reportCessna 170B · Durango, COThe pilot's decision to taxi behind a turbojet airplane into jet blast, which resulted in the airplane being blown off an active taxiway and flipped upside down onto terrain.NTSB GAA15CA145Accident · No injuriesData collectionFinal reportBeech D17S · Idaho Falls, IDWhile taxiing as a flight of two, the pilot of the blue Beechcraft became distracted and impacted the red Beechcraft which had stopped.NTSB WPR15LA184Accident · No injuriesLimited investigationFinal reportEclipse EA500 · Sacramento, CAA manufacturing defect that resulted in fatigue failure of the left main landing gear trunnion.NTSB DCA15CA129Accident · Serious injuriesData collectionFinal reportMcdonnell Douglas DC 9 83(MD-83) · St Petersburg, FLevacuation of the aircraft due to reported, but unverified, aircraft condition and poor communication between Aircraft Rescue and Firefighting personnel and the flight crew.NTSB ERA15LA224Accident · No injuriesLimited investigationFinal reportCessna 337 · Melbourne, FLThe pilot’s failure to maintain directional control while taxiing as a result of his impairment due to alcohol ingestion.NTSB GAA15CA110Accident · No injuriesData collectionFinal reportPiper PA 28-181 · Wickenburg, AZThe pilot's failure to monitor the airplane's wing clearance during taxi, which resulted in a collision with a parked airplane.NTSB GAA15CA078Accident · No injuriesData collectionFinal reportConsolidated Aeronautics Lake LA4-200 · Mineral, VAThe pilot's failure to maintain directional control during a high-speed water taxi in rough water conditions, resulting in a collision with a dock.NTSB GAA15CA066Accident · No injuriesData collectionFinal reportCessna 177B · Roxboro, NCThe pilot's failure to monitor the airplane's movement and maintain control of the airplane.NTSB DCA15CA118Accident · No injuriesData collectionFinal reportBombardier CL600 2D24 · Phoenix, AZthe CRJ900 captain's misjudgment of the clearance between their horizontal stabilizer and the B757 winglet.NTSB CEN15CA223Accident · No injuriesData collectionFinal reportPiper J3C-65 · De Kalb, ILThe pilot's loss of positional awareness while taxiing, resulting in a collision with a parked and unoccupied airplane. Contributing to the accident was the pilot's difficulty seeing over the nose of the airplane, his preoccupation with trying to control the…NTSB DCA15WA122Incident · No injuriesForeign investigationAirbus A321 - 211 · Barcelona, SpainThe Comision de Investigacion de Accidentes e Incidentes de Aviacion Civil (CIAIAC) has notified the NTSB of an incident involving an Airbus A321 and a Boeing 737-400 which occurred on April 28, 2015. The NTSB has appointed a U.S. Accredited Representative to…NTSB WPR15LA154Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Ind DA 20 C1 · Van Nuys, CABoth pilots’ failure to see and avoid each other, which resulted in an on ground collision while taxiing. Contributing to the accident was the ground controller’s failure to notify either pilot about the presence of the other airplane on the taxiway.NTSB GAA15CA036Accident · No injuriesData collectionFinal reportPiper PA 22-135 · Drexel, MOThe pilot's failure to maintain airplane control while taxiing in unfavorable wind conditions.NTSB DCA15WA102Accident · No injuriesForeign investigationBoeing Boeing 737-8AS · Dublin, IrelandThe Air Accidents Investigation Unit f Ireland (AAIU-IE) has notified the NTSB of an accident involving a Boeing 737-8AS airplane that occurred on April 01, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the AAIU's investigation under…NTSB ENG15WA016Incident · No injuriesForeign investigationFokker F28 - 0070 · Amsterdam, NetherlandsOn March 05, 2015, about 1215 LCL, a Fokker F28, PH-WXC, On March 5, 2015, a Fokker F28 experienced a braking failure while on the ramp and struck a ground power unit (GPU) at Schiphol Airport (EHAM), Amsterdam, the Netherlands.The incident is being…NTSB ERA15LA135Accident · No injuriesLimited investigationFinal reportCessna 208 · Baltimore, MDThe ground service vehicle operator's failure to yield right of way to the airplane due to distraction, which necessitated the pilot's use of reverse thrust and braking to avoid a collision and resulted in the airplane's empennage striking the ground.NTSB ERA15CA113Accident · No injuriesData collectionFinal reportCessna 172I · Nashua, NHThe student pilot's lack of vigilance during taxi, which resulted in a collision with a parked truck. A factor in the accident was the truck operator's decision to park on the edge of an active taxiway.NTSB ERA15CA093Accident · No injuriesData collectionFinal reportPiper PA-46-350P · Apalachicola, FLThe pilot's inadequate visual lookout while taxiing, which resulted in the airplane striking a pole.