NTSB investigations, ID
255 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.\"eventStateOrRegion\" = 'ID' AND c.\"eventCountry\" = 'USA'
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."eventStateOrRegion" = 'ID' AND c."eventCountry" = 'USA'
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 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 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.NTSB WPR14LA341Accident · No injuriesLimited investigationFinal reportMcdonnell Douglas Helicopter 500N · Idaho Falls, IDThe pilot’s loss of helicopter control for reasons that could not be determined because postaccident examination of the helicopter did not reveal any mechanical malfunctions or failures that would have precluded normal operation.NTSB WPR14CA317Accident · No injuriesData collectionFinal reportAir Tractor AT 802A · Hazelton, IDThe pilot's failure to maintain aircraft control during takeoff roll in variable wind conditions.NTSB WPR14CA294Accident · Minor injuriesData collectionFinal reportThrush S2RHG T65 · Parma, IDThe pilot's decision to take off with a tailwind, which resulted in the airplane not attaining sufficient airspeed for takeoff.NTSB WPR14CA178Accident · Minor injuriesData collectionFinal reportElemdorf 1002 · Rexburg, IDThe pilot's loss of directional control and early rotation during takeoff. Contributing to the accident was the failure of the pilots to exercise adequate communication techniques.NTSB WPR14CA035Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Twin Falls, IDThe pilot's loss of aircraft control during the rejected takeoff.NTSB WPR13CA339Accident · No injuriesData collectionFinal reportPiper PA-18 · Challis, IDThe pilot's failure to maintain directional control during the takeoff roll.NTSB WPR13LA308Accident · No injuriesLimited investigationFinal reportWSK PZL Mielec M-18B · Caldwell, IDThe pilot’s improper decision to continue the takeoff with a tailwind after he recognized a performance problem with the airplane and his delayed action to dump the chemical load.NTSB WPR13CA199Accident · No injuriesData collectionFinal reportCessna A185E · Cottonwood, IDThe pilot’s failure to see and avoid an object on the grass airstrip during the takeoff.NTSB WPR13CA179Accident · No injuriesData collectionFinal reportAeronca 7CCM · Caldwell, IDThe pilot's loss of directional control after an encounter with a wind gust during takeoff.NTSB WPR12LA283Accident · Serious injuriesLimited investigationFinal reportStinson 108 · Stanley, IDThe pilot’s inadequate preflight planning and decision to takeoff at a density altitude outside of the airplane’s takeoff performance envelope, with a tailwind, and near the airplane’s maximum gross weight, which resulted in the airplane’s inability to climb…NTSB WPR12LA289Accident · No injuriesLimited investigationFinal reportCox PA 18 · Soldier Bar, IDThe pilot’s failure to maintain directional control of the airplane during takeoff, which resulted in a runway excursion and the airplane nosing over.NTSB WPR11FA382Accident · 4 fatalField investigationFinal reportCessna P210N · Burley, IDThe pilot's failure to attain sufficient altitude and maintain aircraft control during a turn shortly after liftoff while operating at maximum gross weight, with a tailwind, and in high density altitude conditions.NTSB WPR11LA366Accident · No injuriesLimited investigationFinal reportAyres S2R-600 · Hazelton, IDPartial loss of engine power for undetermined reasons.NTSB WPR11FA349Accident · No injuriesField investigationFinal reportHawker Beechcraft G36 · Hailey, IDThe pilot's inadvertent activation of the auxiliary fuel pump, which resulted in a loss of engine power during takeoff.NTSB WPR11LA269Accident · Minor injuriesLimited investigationFinal reportCessna 402 · Caldwell, IDThe total loss of power in one engine during takeoff due to the blockage of fuel flow by a foreign object in the fuel tank.NTSB WPR11CA088Accident · No injuriesData collectionFinal reportFerkin Kitfox IV · Homedale, IDThe pilot's inadequate compensation for the snow-covered terrain during the takeoff ground roll, which resulted in a nose-over.NTSB WPR10LA483Accident · No injuriesLimited investigationFinal reportBoam Rans S-6S · Roberts, IDA loss of engine power due to the detachment of the left carburetor from the engine inlet manifold. Contributing to the accident was the pilot's failure to address a known engine vibration.NTSB WPR10CA444Accident · Minor injuriesData collectionFinal reportSchweizer 164B · Murtaugh, IDThe pilot’s inadequate compensation for the wind and failure to maintain directional control during the takeoff roll.NTSB WPR10LA407Accident · 1 fatalLimited investigationFinal reportClark RV-6A · Nampa, IDThe pilot's failure to maintain aircraft control, which resulted in a collision with terrain during a rejected inadvertent takeoff.NTSB WPR10CA405Accident · No injuriesData collectionFinal reportCessna T182T · McCall, IDThe pilot's delay in making the decision to abort the takeoff. Contributing to the accident was the condition of the takeoff surface, and the high density altitude.NTSB WPR10CA346Accident · No injuriesData collectionFinal reportPiper PA-32RT-300 · Yellow Pine, IDThe pilot's delayed decision to abort the takeoff. Contributing to the accident was the wet condition of the grass runway.NTSB WPR10CA329Accident · No injuriesData collectionFinal reportCornett Steven M Glastar · Smiley Creek, IDThe pilot's decision to not use all available runway length and his delay in aborting the takeoff, which resulted in the airplane sliding off the end of the grass strip and colliding with a ditch.NTSB WPR10LA274Accident · Serious injuriesLimited investigationFinal reportSmithwick/Treidel Tukan · Prairie, IDThe pilot's loss of control of the weight-shift-controlled airplane during takeoff for undetermined reasons.NTSB SEA08TA188Accident · No injuriesFinal reportHughes 369D · Bonners Ferry, IDThe pilot's inadequate preflight planning for the takeoff and the helicopter loading that exceeded the lift performance capability of the helicopter.NTSB SEA08CA183Accident · Minor injuriesData collectionFinal reportGrumman Acft Eng G-164A · Hazelton, IDThe pilot's inadequate compensation for the tailwind and failure to attain and maintain airspeed, which resulted in an inadvertent stall. The tailwind was a contributing factor.NTSB SEA08LA159Accident · Serious injuriesLimited investigationFinal reportMooney M20E · Big Creek, IDThe pilot's delayed decision to abort the landing and failure to achieve the proper touchdown point. Contributing to the accident was a high density altitude.NTSB LAX08CA210Accident · No injuriesData collectionFinal reportCessna TU206G · Coeur d'Alene, IDThe pilot's failure to maintain proper runway alignment and clearance from a large rock on the side of the runway. Contributing to the accident was the failure of the pilot to maintain the runway environment of his private strip clear of obstructions.NTSB LAX08CA204Accident · No injuriesData collectionFinal reportAeronca 7DC · Elk River, IDThe pilot's failure to maintain directional control.NTSB LAX08CA186Accident · No injuriesData collectionFinal reportAlon A2 · Sandpoint, IDThe airplane struck a deer on the runway while performing touch-and-go landings. Contributing to the accident was the dusk light condition.NTSB SEA08CA086Accident · No injuriesData collectionFinal reportMaule M-4 · Jerome, IDThe failure of both pilots to maintain directional control of the airplane during takeoff.NTSB SEA07CA219Accident · No injuriesData collectionFinal reportCessna 170 B · Arco, IDThe pilot's failure to maintain directional control during takeoff. The crosswind condition was a factor.NTSB SEA07CA186Accident · No injuriesData collectionFinal reportCessna 182 · Bear Lake, IDThe separation of the bolt that holds the nosewheel steering torque arm to the nose wheel strut during the takeoff roll, resulting in no nosewheel steering being available during the landing roll at the pilot's destination. Factors include the pilot's failure…NTSB SEA07CA153Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Hailey, IDThe pilot's failure to maintain directional control during the takeoff ground roll. A tailwind was a factor.NTSB SEA07CA034Accident · No injuriesData collectionFinal reportCessna 172 · Bonners Ferry, IDThe pilot's failure to maintain directional control during the takeoff roll. Contributing factors include icy runway conditions and a snow berm adjacent to the runway.NTSB SEA06CA148Accident · No injuriesData collectionFinal reportCessna 172F · American Falls, IDThe pilot's failure to maintain an airspeed above stall speed. Factors include his improper decision to takeoff with a tailwind, and the effects of the tailwind upon the aircraft's takeoff performance.NTSB SEA06LA140Accident · Serious injuriesLimited investigationFinal reportCessna 182B · Big Creek, IDThe pilot's failure to maintain directional control of the aircraft during takeoff and initial climb out.NTSB SEA06CA136Accident · No injuriesData collectionFinal reportCessna 206G · Stanley, IDThe pilot's failure to maintain directional control during an aborted takeoff. Factors include a tailwind gust, and a large rock near the side of the runway.NTSB SEA06CA090Accident · No injuriesData collectionFinal reportCessna A188B · Minidoka, IDThe pilot's failure to abort the takeoff. A berm at the end of the runway was a factor.NTSB SEA06CA089Accident · No injuriesData collectionFinal reportEly Kitfox III · Lewiston, IDFailure to maintain aircraft control during the landing roll from an aborted takeoff. Excessive use of the rudder to control the airplane, the subsequent inadvertent ground loop, and the inadequate supervision by the flight instructor were factors.NTSB SEA06CA023Accident · No injuriesData collectionFinal reportDiamond Aircraft Industries HK 36 TTC · Sandpoint, IDExcessive speed for the landing roll and inadequate remedial action for the initial takeoff. An object near the end of the runway and snow covered surface were factors.NTSB SEA05CA152Accident · No injuriesData collectionFinal reportCessna 180 · McCall, IDThe pilot's inadequate compensation for wind and his failure to maintain directional control. A factor was the crosswind.NTSB SEA05LA146Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Jerome, IDFailure to maintain clearance from terrain during takeoff and initial climb. A high density altitude was a factor.NTSB SEA05LA147Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Yellow Pine, IDThe pilot's selection of unsuitable terrain for takeoff, and his failure to maintain directional control after the aircraft's right main gear contacted a small dirt mound during the takeoff roll at the remote grass airstrip. Factors include the pilot's…NTSB SEA05CA119Accident · No injuriesData collectionFinal reportAdkins Ridge Runner II · Pocatello, IDThe pilot's failure to maintain directional control during the takeoff roll, which resulted in an inadvertent ground loop/swerve.NTSB SEA05LA009Accident · Minor injuriesLimited investigationFinal reportCessna A185F · White Bird, IDThe pilot's failure to attain the proper airspeed for takeoff and his improper soft-field takeoff procedure. Factors contributing to the accident included the pilot's improper preflight planning, the fence, and the closed exhaust stack.NTSB SEA04LA180Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Picabo, IDThe pilot's failure to set the propeller control for takeoff performance needed to outclimb obstacles. The pilot's failure to use the checklist, trees, and a fence are contributing factors.NTSB SEA04LA172Accident · No injuriesLimited investigationFinal reportTubbs PA-18-225 DD · Salmon, IDDirectional control not maintained during the takeoff roll resulting in a runway excursion and subsequent nose over. Factors include a drainage ditch.NTSB SEA04LA145Accident · No injuriesLimited investigationFinal reportBell 222U · Louie Lake, IDThe failure of the pilot to maintain rotor rpm and his inadequate recovery from a bounced landing. Factors contributing to the accident included the tailwind condition and the tree.