NTSB investigations
14,038 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 DFW08CA214Accident · No injuriesData collectionFinal reportBellanca 14-19-2 · Keller, TXThe pilot's inadequate preflight inspection of the airplane which resulted in an attempted takeoff without fuel present in the selected fuel tank.NTSB ANC08LA111Accident · Minor injuriesLimited investigationFinal reportCessna 207A · Kongiganak, AKThe pilot's decision to attempt to takeoff on a short, wet runway with a heavily loaded airplane, and his failure to abort the takeoff before it became impracticable.NTSB NYC08LA291Accident · No injuriesLimited investigationFinal reportCessna 441 · Baltimore, MDThe pilot's delayed decision to abort the takeoff. Contributing to the accident was the pilot's attempted takeoff with a propeller start lock inadvertently engaged.NTSB LAX08CA270Accident · No injuriesData collectionFinal reportCessna 182Q · Mesa, AZThe pilot's failure to maintain directional control during landing.NTSB CHI08CA260Accident · No injuriesData collectionFinal reportCessna A188B · Camanche, IAThe pilot took off on an unsuitable airstrip which resulted in the airplane becoming prematurely airborne with inadequate airspeed after it contacted a rise in the terrain.NTSB ANC08CA110Accident · No injuriesData collectionFinal reportCessna U206G · Igiugig, AKThe pilot's misjudged speed and distance during takeoff, which resulted in the float-equipped airplane colliding with a bank.NTSB ANC08TA107Accident · No injuriesFinal reportPiper PA-18-150 · Slana, AKThe pilot's failure to maintain directional control during an aborted takeoff.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 SEA08CA189Accident · No injuriesData collectionFinal reportAeros Venture · Maricopa, AZThe pilot's selection of unsuitable terrain for a precautionary landing and subsequent takeoff attempt, and his misjudging of the required takeoff distance. The soft terrain was a factor.NTSB CHI08CA256Accident · Minor injuriesData collectionFinal reportCessna 172N · Huntington, INThe pilot's failure to maintain directional control during the takeoff roll. Contributing to the accident was the pilot's inadvertent use of the toe brake.NTSB CHI08CA254Accident · No injuriesData collectionFinal reportBell 47G-3B · Kenyon, MNThe pilot's inadequate preflight planning which resulted in the helicopter settling with power.NTSB ANC08CA108AccidentData collectionFinal reportPiper PA-18-150 · Palmer, AKThe pilot's failure to maintain clearance from a tarp used as a marker at the departure end of the takeoff area.NTSB DEN08CA142Accident · No injuriesData collectionFinal reportAerotek Pitts Special S-1S · Crawford, COthe pilot's failure to maintain directional control during takeoff. Contributing to the accident were wind gusts and rough terrain.NTSB NYC08CA276Accident · No injuriesData collectionFinal reportCessna A188B · Gardner, FLThe pilot's misjudged distance/altitude during takeoff.NTSB CHI08CA249Accident · No injuriesData collectionFinal reportMorane-Saulnier MS-760/B · St Paul, MNRestriction of the elevator controls due to the presence of the seat belt buckled around the co-pilot control stick. An additional cause was the failure of the pilot to verify that the flight controls were unobstructed before flight. Contributing factors were…NTSB ENG08IA038Incident · No injuriesIncident investigationFinal reportBoeing 757 · Las Vegas, NVThe engine experienced an uncontained release of high pressure turbine material due to fatigue cracks that occurred on four consecutive blade retainig lugs on the 2nd stage turbine hub. The cracked lugs resulted in the release of four 2nd stage turbine blades…NTSB ANC08TA099Accident · No injuriesFinal reportPiper PA-18 · Nome, AKThe pilot's failure to maintain directional control of the airplane during the takeoff roll.NTSB NYC08LA271Accident · Serious injuriesLimited investigationFinal reportBeech B35 · Lockport, NYA partial loss of engine power, as reported by the pilot, for undetermined reasons. Contributing to the accident was the pilot's inadequate preflight planning and the overweight condition of the airplane.NTSB DFW08LA209Accident · No injuriesLimited investigationFinal reportEvektor Aerotechnik Sportstar · St Charles, MOThe student pilot's failure to maintain control due to his task saturation as a result of his failure to set the pitch trim to the neutral position before takeoff.NTSB NYC08CA269Accident · Minor injuriesData collectionFinal reportCessna 172M · Jefferson, NCA loss of directional control during the takeoff roll for undetermined reasons. Contributing to the severity of the event was the descending embankment adjacent to the runway.NTSB CHI08CA237Accident · Serious injuriesData collectionFinal reportPowrachute PC 2000 · Goodfield, ILThe insufficient aircraft performance data available to the pilot and the inadequate preflight planning/preparation by the pilot. Contributing to the accident were the trees and density altitude.NTSB CHI08CA233Accident · Minor injuriesData collectionFinal reportErcoupe 415-C · Cedarburg, WIThe pilot not maintaining altitude/clearance from the tree during takeoff. Contributing to the accident were the windshear and the tree.NTSB CHI08CA231Accident · No injuriesData collectionFinal reportWeatherly 201B · Creston, ILThe pilot's selection of the unsuitable terrain next to the runway to avoid the landing traffic. Contributing to the accident was the hill in the middle of the runway that blocked the pilot's view of the other traffic and the high vegetation near the runway.NTSB MIA08LA152Accident · 2 fatalLimited investigationFinal reportMorris George Velocity 173RG · St. Augustine, FLA loss of control in flight due to undetermined reasons.NTSB DFW08CA208Accident · No injuriesData collectionFinal reportGroom Sparrow Hawk · Tulsa, OKThe student pilot's failure to maintain control of the gyroplane. Contributing to the accident was the lack of recent flight instruction prior to the flight.NTSB DFW08CA202Accident · No injuriesData collectionFinal reportNorth American P-51D · Tulsa, OKThe pilot's failure to maintain aircraft control during takeoff.NTSB DCA08WA086AccidentForeign investigationBoeing 767 - 200 · Budapest, HungaryOn July 29, 2008, at 1607 local Budapest time, a Krasnojarsky Airlines Boeing 767-200, EI-GBA, experienced an inadvertent deployment of an emergency escape slide after takeoff from Budapest, Hungary. The flight continued to its destination of Domodedovo…NTSB ANC08IA092Incident · No injuriesIncident investigationFinal reportSaab-Scania Saab 340B · Anchorage, AKThe failure of one of the stage 1 gas generator rotor blades due to high-cycle fatigue, resulting in a contained engine failure during the takeoff roll.NTSB DEN08IA123Incident · No injuriesIncident investigationFinal reportAirbus Industrie A319-114 · Denver, COTotal failure of the right inboard tire. Contributing to this incident were the low pressure of the tire, and the high tire heat generated by the previous rejected takeoff.NTSB CHI08CA208Accident · Serious injuriesData collectionFinal reportErcoupe 415-G · West Jefferson, OHThe improper preflight planning/preparation by the pilot and the loss of engine power due to fuel exhaustion during takeoff. Contributing factors were the pilot’s expired flight review and airman medical, the aircraft weight and balance exceeded by the pilot,…NTSB CHI08CA206Accident · Minor injuriesData collectionFinal reportPiper PA-28-235 · Lowell, MIThe inadequate preflight planning/preparation and the short field takeoff procedure not followed by the pilot. An additional cause was the delayed aborted takeoff by the pilot. A contributing factor was the trees.NTSB SEA08CA166Accident · No injuriesData collectionFinal reportCessna 180 · Lewistown, MTThe pilot's inadequate compensation for the variable and gusting winds, and his failure to maintain directional control. Contributing to the accident were variable winds that were gusting to 25 knots.NTSB LAX08CA234Accident · No injuriesData collectionFinal reportCessna 172M · Leavenworth, WAThe pilot's inadequate preflight planning and failure to attain a sufficient airspeed to continue the takeoff. A contributing factor was the high density altitude and short runway.NTSB LAX08FA233Accident · 3 fatalField investigationFinal reportHughes 369D · Price, UTThe pilot's inadequate preflight performance planning for the takeoff and the loading that exceeded the lift performance capability of the helicopter.NTSB CHI08LA197Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Sparta, WIThe pilot's inadequate preflight planning and the pilot's delay in aborting the takeoff. Contributing to the accident was the airplane's overgross weight condition.NTSB CHI08CA204Accident · Serious injuriesData collectionFinal reportIndy T-Bird II · Independence, IAThe takeoff airspeed not attained and the aborted takeoff not performed by the pilot. An additional cause was the lack of familiarity with the airplane by the pilot.NTSB CHI08CA198Accident · No injuriesData collectionFinal reportRockwell S2R · Carthage, ILThe pilot failed to maintain directional control during the takeoff roll. Contributing to the accident were the uneven runway, the runway edge, and the cornfield.NTSB DFW08CA193Accident · No injuriesData collectionFinal reportPiper PA-30 · Rockport, TXThe pilot's failure to complete all cockpit checklist items prior to takeoff. Contributing to the accident was the pilot's failure to properly configure the landing gear switch.NTSB CHI08CA193Accident · No injuriesData collectionFinal reportAyres S2R-G6 · Kilbourne, ILThe inadequate preflight planning and preparation and the aborted takeoff not performed by the pilot. Contributing to the accident were the trees and transmission wire.NTSB DFW08CA185Accident · Minor injuriesData collectionFinal reportStits SA3A · St Louis, MOThe pilot's failure to maintain control of the airplane during takeoff.NTSB DFW08CA189Accident · No injuriesData collectionFinal reportStinson 108-1 · Alliance, NEThe pilot's failure to maintain directional control on takeoff. Contributing to the accident was a lack of total experience.NTSB ANC08LA088Accident · No injuriesLimited investigationFinal reportCessna 150 · Manley Hot Spgs, AKThe pilot's selection of unsuitable terrain for takeoff, which resulted in a collision with a ditch during the takeoff roll. Factors contributing to the accident were low light conditions at dusk, and soft terrain.NTSB NYC08IA244Incident · No injuriesIncident investigationFinal reportAgusta A109E · Augusta, GAThe lack of available engine power and subsequent loss of rotor rpm due to the pilot’s departing with one engine at idle. Contributing to the incident was a corroded engine control wiring harness.NTSB SEA08LA164Accident · No injuriesLimited investigationFinal reportEvektor-Aerotechnik SportStar · Arlington, WAThe pilot's failure to maintain directional control of the airplane during the takeoff roll in gusty conditions.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 DCA08RA078Accident · 2 fatalForeign investigationBoeing 747-200FM · Madrid, ColombiaOn July 7, 2008, at 0357 local time, a Boeing 747-200FM, N714CK, operated by Kalitta Air as Centurion Airlines flight 164, was destroyed during a forced landing in Madrid, Cundinamarca, Colombia, shortly after taking off from El Dorado International Airport…NTSB CHI08IA182Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas MD-81 · St. Louis, MOThe inadvertent partial inflation of the evacuation slide within the tailcone during takeoff and subsequent binding of the elevator control cables. The partial inflation resulted from the tailcone evacuation slide cover failing to be secured to the floor…NTSB DEN08LA121Accident · Minor injuriesLimited investigationFinal reportCessna 337G · Point Lookout, MOA fuel flange seal leak and water in the fuel resulting in a loss of engine power during takeoff. Contributing to the accident was an inadequate preflight.NTSB CHI08CA178Accident · No injuriesData collectionFinal reportMooney M20K · Howell, MIThe collision with a deer during the takeoff roll. Contributing to the accident was the dusk light condition.