NTSB investigations
14,035 cases where the phase of flight was Takeoff.
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 = 300)
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 = 300)
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 CEN15LA059Accident · 1 fatalLimited investigationFinal reportRoss H/Herriott M Vans Aircraft RV 3 · Las Cruces, NMThe pilot’s failure to maintain airplane control, which resulted in a stall/spin. Contributing to the accident was the pilot’s failure to obtain adequate familiarization in the accident airplane type before the accident.NTSB CEN15LA050Accident · Serious injuriesLimited investigationFinal reportCessna 401A · Fulton, MOA failure of the right engine magneto distributor drive gears, which resulted in a total loss of engine power during takeoff. Contributing to the accident was the operator’s failure to inspect and maintain the magnetos in accordance with the engine…NTSB WPR15CA041Accident · No injuriesData collectionFinal reportChampion 7ECA · San Diego, CAThe pilot's failure to maintain directional control of the airplane during takeoff roll.NTSB CEN15IA046Incident · No injuriesIncident investigationFinal reportBell 407 · Viosca Knoll 989Engine power surges during takeoff for reasons that could not be determined during postaccident testing of the engine and the engine control unit.NTSB WPR15LA029Accident · No injuriesLimited investigationFinal reportHenry Steven J Just Acft Superstol · Murphy, IDThe pilot’s failure to properly manage the fuel supply, which resulted in a total loss of engine power due to fuel starvation.NTSB CEN15FA030Accident · 1 fatalField investigationFinal reportMooney M20 · Boulder, COThe loss of airplane control for reasons that could not be determined by the postaccident examination, which was limited due to impact damage and postcrash fire.NTSB WPR15LA025Accident · No injuriesLimited investigationFinal reportCessna 172S · Santa Monica, CAThe separation of a section of a propeller blade due to fatigue cracking. Contributing to the accident was the operator’s failure to comply with the manufacturer’s maintenance and inspection instructions.NTSB ERA15CA027Accident · No injuriesData collectionFinal reportCessna A188B · Louisburg, NCThe pilot's failure to maintain directional control during takeoff.NTSB CEN15LA023Accident · Serious injuriesLimited investigationFinal reportTuberville Zodiac XL · Mountain Home, ARThe partial loss of engine power during takeoff for reasons that could not be determined because postaccident engine examinations revealed no anomalies that would have precluded normal operation.NTSB ERA15LA022Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Warren, VTThe glider pilot’s failure to avoid the tow plane after the aborted takeoff due to both pilots’ failure to review the aborted takeoff procedure before the flight, which led to both pilots turning right after the aborted takeoff.NTSB CEN15WA129Accident · No injuriesForeign investigationSiai-Marchetti S.205 18R · Speck-Fehraltorf, SwitzerlandNTSB CEN15LA024Accident · Serious injuriesLimited investigationFinal reportCessna 172K · Xenia, OHThe failure of the seat track mechanism, which led the pilot to inadvertently apply aft yoke and lift his feet off the rudder pedals and resulted in a loss of directional control during takeoff.NTSB CEN15TA019Accident · No injuriesFinal reportBAE Systems Hawk MK 67 · Oklahoma City, OKThe loss of directional control during the takeoff roll for reasons that could not be determined during postaccident examinations and testing.NTSB ENG15WA008Incident · No injuriesForeign investigationAirbus A319 - 132 · Zurich, SwitzerlandOn October 17, 2014, an Air Serbia Airbus 319-132, registration umber YU-APA, powered by two IAE V2524-A5 turbofan engines experienced a right engine oil leak shortly after departure. The flight crew performed an inflight shutdown of the engine and an air…NTSB CEN15TA017Accident · Minor injuriesFinal reportAirbus Helicopters AS 350 B3 · Lordsburg, NMThe pilot’s failure to maintain adequate drift control and skid clearance from the ground during takeoff, which resulted in a dynamic rollover when the aft right skid contacted a rock.NTSB ERA15LA019Accident · No injuriesLimited investigationFinal reportPiper PA32 301FT · Winona, MSA loss of directional control during takeoff for reasons that could not be determined because postaccident examination of the airplane revealed no anomalies.NTSB CEN15IA014Incident · No injuriesIncident investigationFinal reportRaytheon Hawker · Denver, COThe failure of the main landing gear tire, which resulted in separation of the servo block and subsequent total loss of all hydraulic system pressure and prevented the landing gear from extending before landing.NTSB CEN15CA013Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Ann Arbor, MIThe collision with a deer during a night takeoff.NTSB ERA15IA008Incident · No injuriesIncident investigationFinal reportCessna S550 · Tampa, FLThe lack of flat roller bearings in the two elevator trim tab actuators and maintenance personnel’s inadequate lubrication of the left elevator trim tab actuator, both of which resulted in the overstress fracture of the left internal screw and subsequent…NTSB CEN15CA007Accident · Serious injuriesData collectionFinal reportBell 206B · Atlanta, ARThe pilot's inadequate preflight inspection when he did not remove a tie-down strap prior to takeoff, which resulted in a dynamic rollover.NTSB WPR14CA397Accident · No injuriesData collectionFinal reportPiper PA 24-250 · Rancho Murieta, CAThe student pilot's failure to maintain adequate airspeed during takeoff and the certified flight instructors delayed remedial action, which resulted in the stall.NTSB CEN14CA528Accident · Minor injuriesData collectionFinal reportCessna 182G · Port Eads, LAThe pilot's improper decision to depart from a runway not suitable for takeoff, which resulted in a loss of aircraft control.NTSB CEN14CA523Accident · Minor injuriesData collectionFinal reportCessna 182G · Silver City, NMThe pilot overcorrected when the airplane experienced a downdraft during the takeoff which resulted in the airplane stalling and impacting the terrain.NTSB CEN14CA525Accident · No injuriesData collectionFinal reportBell 206B · Nashoba, OKThe pilot's loss of directional control due a loss of tail rotor effectiveness.NTSB WPR14CA383Accident · No injuriesData collectionFinal reportAmerican Champion 7GCBC · Rimrock, WAThe pilot's failure to maintain aircraft control during takeoff from a rough runway surface which resulted in an off-airport forced landing just beyond the runway.NTSB CEN14LA519Accident · No injuriesLimited investigationFinal reportPiper PA 36-285 · Woodburn, INA loss of engine power during takeoff for reasons that could not be determined based on the available information.NTSB ANC14CA087Accident · No injuriesData collectionFinal reportHelio H 250 · Arctic Village, AKThe pilot's selection of an unsuitable landing/takeoff area, resulting in an inflight collision with terrain during takeoff.NTSB ANC14CA084Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Cantwell, AKThe pilot's loss of directional control during takeoff from an off-airport site, which resulted in a collision with terrain.NTSB ANC14CA083Accident · No injuriesData collectionFinal reportCessna 175 · Ambler, AKThe pilot's decision to takeoff from a rough airstrip in gusty wind conditions, which resulted in a loss of control.NTSB ANC14CA082Accident · Minor injuriesData collectionFinal reportHelio H 295 · Prospect Creek, AKThe pilot's loss of directional control during takeoff, in gusty and variable wind conditions, resulting in a collision with terrain.NTSB CEN14CA500Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · Beaumont, TXThe pilot's loss tail rotor effectiveness while attempting a taxiway side-step during landing. Contributing to the accident was another pilot's failure to ensure the runway was clear before occupying the runway for takeoff.NTSB ENG14IA029Incident · No injuriesIncident investigationFinal reportBombardier CRJ700 · Hodeida, YemenThe probable cause of the undercowl engine fire was the burn-through of the combustion chamber inner liner from the accumulation of dust that became molten during operating and infiltrated the combustion chamber thermal barrier coating causing it to spall off…NTSB CEN14CA503Accident · No injuriesData collectionFinal reportMaule MT 7-260 · Largo Vista, TXThe pilot's inadequate compensation for gusting wind conditions during takeoff, which resulted in the nose landing gear impacting the runway and the subsequent collapse of the nose landing gear.NTSB CEN14WA534Incident · No injuriesForeign investigationAgustawestland AW139 · Umea, SwedenOn September 11, 2014, at 1230 coordinated universal time, an Agusta Westland AW139, SE-JRH, experienced a detachment of the slip ring assembly for anti-icing of the tail rotor, near Umea Airport (ESNU), Umea, Sweden. The helicopter landed at ESNU without…NTSB WPR14LA371Accident · No injuriesLimited investigationFinal reportAyres S2R T34 · Buckeye, AZA partial loss of engine power due to water contamination of the fuel.NTSB CEN14LA485Accident · 2 fatalLimited investigationFinal reportCismowski Tierra II · Montevideo, MNThe pilot's impaired judgment due to the use of marijuana, which led to his improper decision to fly the airplane over its maximum gross weight and his subsequent loss of airplane control during takeoff with gusting wind conditions.NTSB ANC14CA077Accident · No injuriesData collectionFinal reportCessna 185 · Gakona, AKThe pilot's inability to maintain directional control after the airplane's main landing gear tire deflated during takeoff.NTSB CEN14WA491Accident · 2 fatalForeign investigationRobinson Helicopter R44 · Roeselare, BelgiumNTSB ERA14LA422Accident · No injuriesLimited investigationFinal reportAckland Jeffrey Dean SH 3R · Columbus, GAThe mechanic’s improper installation of the landing gear extend/retract switch, which resulted in the retraction of the landing gear during the aborted takeoff.NTSB CEN14WA473Incident · No injuriesForeign investigationCessna 560 XL · Geneva, SwitzerlandNTSB WPR14LA356Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Gardnerville, NVThe pilot’s failure to monitor the environment and to maintain clearance from wires during takeoff.NTSB CEN14LA461Accident · No injuriesLimited investigationFinal reportCessna 310K · El Dorado, KSA fatigue failure of the left engine’s throttle cable, which resulted in the loss of left engine power.NTSB CEN14CA464Accident · No injuriesData collectionFinal reportAir Tractor AT 502B · Colusa, ILThe pilot did not maintain control of the airplane during takeoff from a grass strip. Contributing was the airplane being loaded beyond its capability for the runway.NTSB ANC14CA070Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Beluga, AKThe pilot's selection of an unsuitable takeoff area, resulting in an inflight collision with vegetation/brush during takeoff.NTSB CEN14LA458Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Houston, TXThe pilot’s failure to maintain airplane control during takeoff. Contributing to the severity of the accident was the pilot’s retraction of the landing gear before establishing a positive climb rate, which resulted in a gear-up landing.NTSB ERA14CA412Accident · No injuriesData collectionFinal reportCessna 140 · Luray, VAA loss of control and subsequent runway excursion while attempting to avoid a collision with a deer on takeoff.NTSB CEN14LA454Accident · 1 fatalLimited investigationFinal reportRans S17 · Lowell, MIThe pilot’s overconfidence, which led to his improper decision to continue flight in the recently purchased, unregistered airplane without acquiring training and to his continued erratic handling of the airplane and subsequent loss of airplane control.NTSB CEN14LA450Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Natchez, LAThe loss of power due to the failure of the No. 2 exhaust valve and rocker boss during takeoff.NTSB ANC14CA067Accident · Minor injuriesData collectionFinal reportCessna 175 · Talkeetna, AKThe pilot's selection of an unsuitable takeoff area, resulting in a loss of control and subsequent inflight collision with terrain during takeoff. Contributing to the accident was the pilot's failure to use the checklist, resulting in an improper propeller…NTSB WPR14CA352Accident · Minor injuriesData collectionFinal reportRans S 6S · Rigby, IDThe student pilot's loss of directional control during takeoff in gusting wind conditions. Contributing to the accident was the flight instructor's failure to intervene and apply corrective flight control inputs.