Final NTSB investigations
13,325 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.\"completionStatus\" = 'Completed'
AND 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."completionStatus" = 'Completed'
AND 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 ERA26LA101Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 170 · Summerdale, ALThe pilot’s decision to abort the takeoff with insufficient runway remaining, which resulted in a runway overrun and impact with a fence post.NTSB WPR26LA081Accident · No injuriesClass 4 · LimitedFinal reportCessna 172E · Kingman, AZThe pilot’s failure to use a pre-takeoff checklist, which resulted in the fuel selector being in the off position, and subsequent loss of engine power during takeoff.NTSB CEN26LA092Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · San Marcos, TXThe flight instructor’s failure to properly configure the elevator trim for the takeoff, that resulted in a hard landing. Contributing to the accident was the flight instructor’s failure to follow the before takeoff checklist.NTSB CEN26LA083Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Round Lake Park, ILThe student pilot’s failure to maintain directional control during a soft-field takeoff and the flight instructor’s delayed remedial action.NTSB ERA26LA080Accident · No injuriesClass 4 · LimitedFinal reportVarga 2150A · Frostproof, FLThe pilot’s failure to maintain control of the airplane during takeoff, resulting in a runway excursion and collision with terrain.NTSB CEN26LA084Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Taylor, TXThe pilot’s inadequate preflight inspection that resulted in a loss of engine power due to water contamination.NTSB CEN26LA081Accident · No injuriesClass 4 · LimitedFinal reportEla ELA10 · Morris, ILThe pilot’s failure obtain the proper rotor rpm before applying power for the takeoff roll which resulted in a loss of control.NTSB CEN26LA067Accident · No injuriesClass 4 · LimitedFinal reportMark O Treidel American Ranger AR-1 · Denver, COThe pilot’s failure to attain rotor RPM and maintain proper rotor disc angle during takeoff which resulted in a rotor strike with the rudder.NTSB CEN26LA058Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Conroe, TXThe collision with a deer during takeoff.NTSB ERA26LA058Accident · No injuriesClass 4 · LimitedFinal reportHuebbe Tom MAX TH · Inverness Highlands South, FLThe pilot’s failure to maintain directional control on takeoff. Contributing to the accident was the aircraft design that did not incorporate differential braking.NTSB CEN26LA054Accident · Minor injuriesClass 4 · LimitedFinal reportLou Malinchak Titan T-51D · Bristow, OKThe collision with two deer during takeoff which resulted in a loss of control and impact with terrain.NTSB ERA26LA037Accident · No injuriesClass 4 · LimitedFinal reportBeech 95-A55 · Southern Pines, NCThe pilot’s failure to maintain directional control during takeoff at night, while distracted by an animal approaching the runway, which resulted in collision with a runway light.NTSB WPR26LA038Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 182P · San Andreas, CAThe pilot’s decision to adjust his seat during the takeoff roll, which resulted in the seat sliding aft and a subsequent loss of directional control.NTSB CEN26LA041Accident · No injuriesClass 4 · LimitedFinal reportDouglas B-26B · Ponca City, OKFailure of the nose landing gear link which resulted in a loss of directional.NTSB WPR26LA033Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 152 · Richfield, UTThe pilot’s failure to maintain directional control in gusting wind conditions during the takeoff roll.NTSB WPR26LA029Accident · No injuriesClass 4 · LimitedFinal reportRoderick James Willmore Kitfox S7 Supersport · Kilgore, IDThe pilot's failure to maintain directional control during the takeoff. Contributing to the accident was the separation of the control stick grip.NTSB ERA26LA017Accident · Serious injuriesClass 4 · LimitedFinal reportTricks Trike Storm · Gaffney, SCThe pilot’s failure to maintain aircraft control during the initial climb, which resulted in an impact with terrain.NTSB CEN26LA017Accident · No injuriesClass 4 · LimitedFinal reportRans S20 · Springfield, COThe pilot's failure to maintain directional control during the takeoff with a right crosswind.NTSB ERA26LA021Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Plymouth, CTThe plot’s failure to account sufficiently for the decrease in the airplane’s takeoff performance due to the wet turf runway, which resulted in a collision with a log barrier and subsequent nose over after aborting the takeoff.NTSB ERA26LA015Accident · No injuriesClass 4 · LimitedFinal reportSocata TB 10 · New Milford, CTThe pilot’s decision to depart from an unlit turf runway at night, which resulted in a loss of directional control, and subsequent runway excursion.NTSB WPR26LA018Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 180 · Imnaha, ORThe pilot’s continued application of brakes during an aborted takeoff in a tailwind on down-sloping terrain, which resulted in a nose-over.NTSB ERA26LA005Accident · Minor injuriesClass 3 · LimitedFinal reportBellanca 7GCBC · Reedville, VAThe pilot’s sudden incapacitation by an episode of abnormal heartbeat due to heart disease during a takeoff attempt, which resulted in a loss of directional control and runway excursion.NTSB CEN25LA405Accident · Minor injuriesClass 4 · LimitedFinal reportSukhoi SU-26MX · Longmont, COThe pilot's failure to maintain directional control during takeoff.NTSB ERA25LA371Accident · Minor injuriesClass 4 · LimitedFinal reportNorth American T-6G · Rossville, TNThe pilot’s failure to adequately monitor the airplane’s path during takeoff toward the setting sun. Contributing was the undetected worn and fractured tailwheel locking pin.NTSB CEN25LA397Accident · No injuriesClass 4 · LimitedFinal reportDe Havilland DH82 · Harvard, ILThe pilot’s failure of the pilot to maintain directional control during takeoff which resulted in a collision with cornstalks. Contributing to the accident was the pilot’s partially obscured vision due to sun glare.NTSB ANC25LA110Accident · No injuriesClass 4 · LimitedFinal reportCessna 208B · Healy, AKThe pilot’s failure to maintain directional control during the departure roll resulting in a collision with a tractor/loader.NTSB ERA25LA359Accident · No injuriesClass 4 · LimitedFinal reportEdwin Miller Calidus · Hopkinsville, KYThe pilot’s failure to maintain control of the gyroplane, which resulted in dynamic rollover and impact with terrain.NTSB CEN25LA392Accident · No injuriesClass 4 · LimitedFinal reportDiamond DA20-C1 · Terre Haute, INThe failure of the nose landing gear strut and associated nosewheel separation during takeoff.NTSB WPR25LA306Accident · No injuriesClass 4 · LimitedFinal reportTemco GC-1B · Toledo, WAThe pilot’s failure to maintain control of the airplane during takeoff in crosswind conditions..NTSB CEN25LA387Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA-32R-301 · Oxford, MSThe pilot’s exceedance of the airplane’s critical angle of attack during the initial takeoff climb, which resulted in an aerodynamic stall and impact with terrain.NTSB ANC25LA121Accident · No injuriesClass 4 · LimitedFinal reportMaule M-4-210C · Lime Village, AKA collision with terrain during takeoff.NTSB ANC25LA108Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Delta Junction, AKThe pilot’s failure to maintain clearance from an object during takeoff, which resulted in a collision and ground loop. Contributing was the pilot’s selection of an unsuitable takeoff area.NTSB CEN25LA383Accident · No injuriesClass 4 · LimitedFinal reportQuad City Challenger · Crystal Mountain, MIThe pilot’s failure to maintain aircraft control during initial climb.NTSB ANC25LA120Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · St Mary's, AKThe pilot’s improper decision to takeoff with a tailwind, from a short off-airport strip, which degraded the climb performance of the airplane and led to impact with trees at the end of the strip.NTSB ANC25LA103Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA-11 · Lake Louise, AKThe pilot’s encounter with gusting crosswind conditions during takeoff, which resulted in a loss of control and subsequent impact with terrain.NTSB ANC25LA104Accident · No injuriesClass 4 · LimitedFinal reportJeremy Price Smith Super CUB · Chisana, AKThe pilot’s failure to maintain directional control during the takeoff roll.NTSB ERA25LA347Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 170 · Eustis, METhe pilot’s failure to maintain control of the airplane during takeoff, which resulted in an inadvertent descent, contact with the water, and a subsequent nose over.NTSB ANC25LA101Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Willow, AKThe pilot’s decision to takeoff from an unsuitable runway due to large puddles of water, which resulted in a nose over.NTSB ERA25LA325Accident · No injuriesClass 4 · LimitedFinal reportCessna 182 · Lebanon, OHThe pilot’s failure to maintain directional control of the airplane during takeoff, which resulted in a runway excursion and collision with a sign.NTSB CEN25LA340Accident · No injuriesClass 4 · LimitedFinal reportBurkhart Grob Flugzeugbau G102 Club Astir Iiib · Highland, ILThe pilot’s failure to maintain directional control during takeoff which resulted in a collision with a parked vehicle.NTSB ANC25LA092Accident · No injuriesClass 4 · LimitedFinal reportEurocopter AS 350 B2 · Juneau, AKThe pilot’s failure to maintain adequate obstacle clearance during takeoff from uneven, snow-covered terrain in flat light conditions.NTSB ANC25LA095Accident · No injuriesClass 4 · LimitedFinal reportHelio H-395 · Pilot Point, AKThe pilot's inadequate takeoff performance planning, which resulted in a runway excursion and collision with terrain.NTSB ERA25LA322Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 182 · Edgartown, MAThe accident was the pilot’s failure to properly configure the airplane for a soft-field takeoff, which resulted in his decision to abort the takeoff and the subsequent runway overrun.NTSB ANC25LA088Accident · No injuriesClass 4 · LimitedFinal reportCessna 180G · Delta Junction, AKThe pilot’s failure to maintain a rate of climb sufficient to clear obstacles during takeoff, resulting in a collision with tree-covered terrain.NTSB ANC25LA090Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Willow, AKThe pilot’s loss of control after a rejected takeoff, which resulted in a noseover.NTSB ERA25LA303Accident · Serious injuriesClass 4 · LimitedFinal reportCentrair 101A · Springfield, VTThe pilot’s failure to assemble the glider’s elevator control before takeoff.NTSB CEN25LA316Accident · Serious injuriesClass 4 · LimitedFinal reportXag P100 PRO · Depew, IAThe pilot’s failure to maintain clearance from the unmanned aircraft system during takeoff.NTSB WPR25LA247Accident · Minor injuriesClass 4 · LimitedFinal reportAviat A1 · Etna, WYThe pilot’s premature rotation at insufficient airspeed during takeoff to avoid an unexpected animal on the runway, which resulted in a loss of control and subsequent nose-over during the aborted takeoff. Contributing to the accident was the pilot’s excessive…NTSB ERA25LA291Accident · Minor injuriesClass 4 · LimitedFinal reportBeech 35-C33 · Kingston, TNThe pilot’s failure to maintain directional control during takeoff roll, which resulted in a runway excursion and collision with haybales.NTSB CEN25LA303Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-400A · Lamoni, IAThe pilot’s failure to maintain airplane control during an aborted takeoff.