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 DFW08LA012Accident · Serious injuriesLimited investigationFinal reportFormhals RV-8 · San Antonio, TXThe automobile driver's failure to yield right-a-way to the airplane before crossing an active runway.NTSB OPS08IA001Incident · No injuriesIncident investigationFinal reportCessna C 525 · Memphis, TNThe probable cause of this incident was the pilot's inadvertent departure from a taxiway instead of a runway.NTSB DFW08CA014Accident · No injuriesData collectionFinal reportAir Tractor 402B · Taft, TXThe pilot's failure to maintain control during takeoff. A contributing factor was the prevailing crosswind.NTSB MIA08LA002Accident · 1 fatalLimited investigationFinal reportBellanca 7GCAA · Toughkenamon, PAThe reason for this accident is undetermined.NTSB DFW08IA002Incident · No injuriesIncident investigationFinal reportBell Helicopter Textron 206L-1 · Galveston, TXThe loss of tail rotor control during initial takeoff climb due to the fracture of a tail rotor blade as result of impact with a foreign object.NTSB CHI08CA010Accident · No injuriesData collectionFinal reportBeech N35 · Elyra, OHThe directional control not maintained by the dual student and the inadequate supervision by the certified flight instructor during takeoff roll. Contributing factors were the precision approach path indicator and the ditch.NTSB CHI08CA015Accident · Minor injuriesData collectionFinal reportCessna 150H · Clarksville, ARFailure of the flight instructor to identify the lack of airplane performance in a timely manner and to reject the takeoff. An additional cause was the partial loss of engine power for undetermined reasons. A contributing factor was the presence of the power…NTSB DEN08CA002Accident · Minor injuriesData collectionFinal reportCessna 172N · Calhan, COThe student pilot's failure to maintain directional control during the takeoff roll.NTSB SEA08CA002Accident · Minor injuriesData collectionFinal reportRobinson R44 II · Lake Powell, UTThe pilot's inadequate preflight inspection and failure to remove a tie-down strap before departure.NTSB CHI07CA306Accident · No injuriesData collectionFinal reportPiper PA-12 · Detroit Lakes, MNThe reduced airplane climb performance capability resulting in the pilot not obtaining a proper climb rate during takeoff and the inadequate flare by the pilot during the aborted takeoff. Additional causes were the inadequate preflight planning/preparation by…NTSB SEA07CA271Accident · Minor injuriesData collectionFinal reportLangley Tri-Quickie · Chino, CAThe premature rotation of the airplane on the takeoff roll as a result of the pilot failing the verify the elevator trim position, resulting in a loss of control and subsequent impact with terrain during an aborted takeoff.NTSB DFW07LA207Accident · No injuriesLimited investigationFinal reportCessna 172S · Tyler, TXThe pilot's failure to maintain control of the airplane during takeoff. A contributing factor was the encounter with wake turbulence.NTSB ANC07CA107Accident · No injuriesData collectionFinal reportPiper J3 · Tyonek, AKThe pilot's selection of unsuitable terrain for takeoff, which resulted in an encounter with soft terrain and a loss of control during the takeoff roll.NTSB CHI07CA303Accident · No injuriesData collectionFinal reportNorth American SNJ-5 · Bloomington, ILThe pilot's failure to maintain directional control during takeoff roll which resulted in a ground loop.NTSB OPS07IA010Incident · No injuriesIncident investigationFinal reportLearjet 35 · Washington, DCThe probable cause of this incident was the IAD tower local controller's failure to ensure that the runway was free of all known ground vehicles, equipment, and personnel before permitting a departing aircraft to start takeoff roll. Additionally, the…NTSB NYC07CA225Accident · No injuriesData collectionFinal reportPiper J3L-65 · Stow, MAA partial loss of engine power for undetermined reasons.NTSB SEA07LA259Accident · 1 fatalLimited investigationFinal reportRose Peregrine · Reno, NVThe overspeed of the modified racing engine during takeoff that created an oil mist on the exhaust and smoke, and the pilot's failure to maintain a speed above stall speed (Vs) during his attempted emergency landing. Contributing to the accident was the…NTSB DEN07LA155Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 · Avondale, COThe pilot's failure to attain translational lift and his improper flare. A contributing factor in this accident was the sudden wind shift.NTSB CHI07CA298Accident · Minor injuriesData collectionFinal reportMaule M-4-220C · Keene, NDThe pilot's failure to maintain control of the airplane during takeoff due to the high crosswind condition. Contributing factors were the high, gusting crosswind, and the tree.NTSB ANC07CA097Accident · No injuriesData collectionFinal reportCessna 185 · McGrath, AKThe pilot's selection of an unsuitable takeoff area which resulted in an overrun and collision with a gravel berm during an aborted takeoff. Factors contributing to the accident were his delay in aborting the takeoff, and the short takeoff area.NTSB LAX07CA266Accident · No injuriesData collectionFinal reportAmerican Air Racing Thunder Mustang · Reno, NVFire resulting from vegetation contacting hot brakes following an aborted takeoff.NTSB LAX07CA264Accident · No injuriesData collectionFinal reportAeronca S15AC · Shelton, WAThe pilot's loss of control during takeoff following the inadvertent encounter with a boat's wake.NTSB DFW07CA192Accident · No injuriesData collectionFinal reportBoeing 1942 · Edmond, OKThe pilot's failure to maintain directional control during takeoff resuting in a nose over. A contributing factor was the soft terrain.NTSB DFW07CA190Accident · No injuriesData collectionFinal reportKitFox Series 5 · Kerrville, TXThe pilot's failure to compensate for the existing wind conditions. A contributing factor was the prevailing crosswind.NTSB SEA07CA244Accident · No injuriesData collectionFinal reportAir Tractor AT-502B · Salome, AZThe pilot's inadequate compensation for the tailwind condition and failure to maintain directional control during the takeoff roll/run, which resulted in a ground loop.NTSB ATL07CA124Accident · No injuriesData collectionFinal reportCessna C172R · Pawtucket, RIThe student pilot's failure to maintain control of the aircraft during the takeoff roll.NTSB CHI07LA280Accident · Serious injuriesLimited investigationFinal reportMcFaul, Daniel D. Quicksilver GT500 · New London, WIThe pilot not maintaining airspeed during the unintentional takeoff and the pilot's inadvertent stall.NTSB CHI07CA278Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Hagerstown, INThe pilot's use of an unsuitable runway for takeoff and delayed aborted takeoff. Factors were the wet grass and the fence the airplane impacted and subsequently nosed over.NTSB ANC07LA090Accident · No injuriesLimited investigationFinal reportCessna 150G · Kenai, AKThe pilot's excessive flap setting during takeoff.NTSB DEN07IA144Incident · No injuriesIncident investigationFinal reportNunn KR2 · Pueblo, COThe pilot's failure to maintain directional control and his inadequate compensation for wind conditions . A contributing factor in this accident was the crosswind.NTSB DEN07CA139Accident · No injuriesData collectionFinal reportCessna A185F · Lake City, COThe pilot's improper preflight planning, his inability to attain short field takeoff performance, and his intentional maneuvering of the airplane into bushes and a fence during the aborted takeoff. Factors contributing to the accident were the high density…NTSB ANC07LA081Accident · Serious injuriesLimited investigationFinal reportMaule M-7-235 · Fairbanks, AKThe reversal of the elevator control cables by maintenance personnel, and the inadequate preflight inspection by the flight instructor and dual student.NTSB LAX07CA249Accident · No injuriesData collectionFinal reportAviat Husky A-1B · Moab, UTThe pilot's failure to maintain directional control that resulted in a ground loop.NTSB SEA07CA235Accident · No injuriesData collectionFinal reportCessna 172B · Seattle, WAThe private pilot's failure to see the approaching large wake swell, both during his landing and the subsequent takeoff, and the failure of the instructor pilot to insure that the private pilot's visual lookout was effective enough to detect the oncoming…NTSB ATL07CA114Accident · No injuriesData collectionFinal reportWaco Classic YMF-5 · Nantucket, MAThe pilot's failure to maintain control of the airplane during takeoff roll, which resulted in an on ground collision with an airport sign.NTSB CHI07CA268Accident · No injuriesData collectionFinal reportAir Tractor AT-502B · Cooksville, ILThe partial loss of engine power during the takeoff roll for undetermined reasons and the pilot's unsuccessful compensation for the tailwind conditions. Factors contributing to the accident were the tailwind and the corn crop.NTSB ANC07CA074Accident · No injuriesData collectionFinal reportPiper PA-18 · King Salmon, AKThe pilot's inadequate compensation for a crosswind during the takeoff roll, which resulted in a loss of control, and an on-ground encounter with terrain. A factor in the accident was a crosswind.NTSB DEN07LA132Accident · Minor injuriesLimited investigationFinal reportBell 206B · Broomfield, COThe pilot's failure to maintain control of the helicopter, resulting in an inadvertent dynamic rollover.NTSB NYC07CA181Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Winchester, VAThe pilot's inadequate preflight planning.NTSB CHI07CA244Accident · Minor injuriesData collectionFinal reportBell 206B · Columbia, MOThe pilot's failure to maintain control of the helicopter, which resulted in impact with terrain during takeoff. A factor in the accident was the tall grass.NTSB DFW07CA174Accident · No injuriesData collectionFinal reportCessna A188B · Garwood, TXThe pilot's failure to maintain proper clearance from terrain/obstacles. A contributing factor was the runway conditions.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 DFW07LA171Accident · Serious injuriesLimited investigationFinal reportBell 206L-1 · Marks, MSThe loss of control and hard landing as result of the loss of tail rotor effectiveness. A contributing factor was the prevailing dark night conditions.NTSB CHI07CA239Accident · No injuriesData collectionFinal reportCessna 150H · Cook, MNThe pilot not maintaining airspeed leading to the stall/mush encountered during takeoff and the unsuitable terrain the pilot selected during the forced landing. Factors were the vehicle encountered during the forced landing and the ditch the pilot steered the…NTSB DFW07CA177Accident · No injuriesData collectionFinal reportAeronca Champion · Kirbyville, TXThe pilot's inability to maintain directional control during takeoff roll as result of the failure of the airplane's tailwheel's steering arm.NTSB CHI07CA230Accident · Minor injuriesData collectionFinal reportGulfstream-Schweizer Gulfstream AM G-164B · Walnut Ridge, ARThe pilot's improper decision to takeoff with a tailwind which resulted in a collision with terrain immediately after liftoff. Factors contributing to the accident were the tailwind and the levee.NTSB DFW07LA169Accident · No injuriesLimited investigationFinal reportBell 206L-3 · High Island 138The loss of control as result of the pilot's failure to maintain rotor RPM during takeoff.NTSB CHI07CA226Accident · No injuriesData collectionFinal reportHamilton Rotorway Exec 90 · Harvey, NDThe pilot's failure to maintain clearance from the airport ramp area during the return for landing, which resulted in the landing skid dragging on the edge of the pavement and causing the helicopter to roll over.NTSB DFW07LA165Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Slaton, TXAn uncontained failure of the turbine engine's power section for undetermined reasons.NTSB DEN07LA135Accident · No injuriesLimited investigationFinal reportCessna T188C · Colby, KSThe pilot's failure to maintain directional control during the take-off roll resulting in a ground loop.