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 WPR17WA132Accident · No injuriesForeign investigationSikorsky S76 · Nilanga, IndiaOn May 25, 2017, at 0625 Universal Coordinated Time, a Sikorsky S76, VT-CMM, was substantially damaged when it impacted the ground following a collision with powerlines near the Nilana Helipad, Nilanga, Maharashtra, India. The helicopter was operated under…NTSB GAA17CA304Accident · No injuriesData collectionFinal reportMaule MX7 · Sidney, METhe pilot’s delayed application of rudder and failure to maintain directional control during takeoff.NTSB GAA17CA292Accident · Minor injuriesData collectionFinal reportAirtime Cygnet · Casa Grande, AZThe flight instructor's failure to maintain directional control during takeoff in gusting crosswind conditions.NTSB WPR17LA116Accident · No injuriesLimited investigationFinal reportExtra Flugzeugbau EA 300/S · Pendelton, ORThe pilot’s failure to follow checklists to ensure the canopy was secured before takeoff.NTSB GAA17CA302Accident · No injuriesData collectionFinal reportCessna 175 · Prospect, ORThe flight instructor’s failure to attain an adequate climb rate during takeoff, which resulted in impact with trees.NTSB GAA17CA297Accident · Minor injuriesData collectionFinal reportCGS Hawk · Findlay, OHThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack during takeoff, which resulted in an aerodynamic stall.NTSB GAA17CA307Accident · No injuriesData collectionFinal reportCessna U206 · Diamond Point, NYThe pilot’s failure to maintain directional control during the takeoff roll with gusting wind conditions.NTSB CEN17WA187Accident · 2 fatalForeign investigationLearjet 25 · Toluca, MexicoOn May 17, 2017, at 2025 hours universal coordinated time, a Lear 25B airplane, Mexican registration XA-VMC, impacted terrain near Toluca, Mexico. The pilot-in-command and co-pilot were fatally injured. The airplane was destroyed by impact forces and a…NTSB GAA17CA278Accident · Minor injuriesData collectionFinal reportReims Cessna FR172 · De Pere, WIThe pilot’s failure to maintain directional control during takeoff with a tailwind.NTSB CEN17LA182Accident · Serious injuriesLimited investigationFinal reportPipistrel Doo Ajdovscina Virus SW · Weatherford, TXThe pilot's failure to obtain adequate airspeed during takeoff, which resulted in an aerodynamic stall/spin.NTSB ERA17CA177Accident · Serious injuriesData collectionFinal reportReupert Mark Avid Flyer · Reedsville, PAThe sport pilot's failure to maintain airplane control during takeoff, which resulted in an exceedance of the airplane's critical angle of attack and a subsequent aerodynamic stall.NTSB CEN17RA191Accident · 2 fatalForeign investigationBell 429 · Presov, SlovakiaOn May 10, 2017, about 1430 local time, a Bell 429 helicopter, Slovakia registration OM-BYM, impacted terrain shortly after takeoff near Presov, Slovakia. There were four people on board; two people received fatal injuries and two people received serious…NTSB WPR17LA102Accident · Minor injuriesLimited investigationFinal reportPiper PA 18A · Coeur D'Alene, IDThe loss of yaw control due to an inadequately compressed rudder swage, which resulted from inadequate maintenance and led to the separation of the forward right rudder cable.NTSB CEN17LA177Accident · No injuriesLimited investigationFinal reportGrumman G-164C · Beech Grove, ARA tire failure for reasons that could not be determined, which resulted in a loss of directional control during takeoff.NTSB WPR17LA100Accident · No injuriesLimited investigationFinal reportGrumman G164 · Madera, CAThe pilot’s loss of directional control during takeoff with a quartering tailwind, which resulted in a runway excursion and separation of the right landing gear.NTSB GAA17CA264Accident · No injuriesData collectionFinal reportStinson 108 · Pedro Bay, AKThe pilot’s failure to maintain directional control during the takeoff roll.NTSB GAA17CA258Accident · Minor injuriesData collectionFinal reportAutogyro Calidus · Stevensville, MDThe pilot’s improper takeoff procedure, which resulted in a loss of directional control during the takeoff.NTSB CEN17LA190Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT 502 · Tahoka, TXThe partial loss of engine power during takeoff for reasons that could not be determined based on the available information.NTSB GAA17CA268Accident · No injuriesData collectionFinal reportCessna 172 · Kaunakakai, HIThe student pilot’s incorrect flap configuration during the go-around, which resulted in a hard, forced landing.NTSB GAA17CA283Accident · No injuriesData collectionFinal reportCessna 172 · Atlanta, GAThe student’s incorrect use of the go-around procedure, which resulted in an aerodynamic stall, and the flight instructor’s delayed remedial action.NTSB GAA17CA260Accident · Minor injuriesData collectionFinal reportMooney M20 · Olathe, KSThe separated fuel tank selector knob roll pin, which prevented the fuel selector from moving to the fuel tank position for the tank with usable fuel and resulted in fuel starvation and the subsequent total loss of engine power.NTSB GAA17CA239Accident · No injuriesData collectionFinal reportBeech C23 · Fallon, NVThe pilot's inaccurate takeoff performance calculations and failure to maintain directional control during an aborted takeoff.NTSB GAA17CA237Accident · No injuriesData collectionFinal reportBrantly B 2B · Earl Park, INThe pilot’s failure to recognize that he was operating in the weathercock stability flight regime of loss of tail rotor effectiveness, which resulted in a loss of directional control during the execution of a right pedal turn.NTSB DCA17WA097Incident · No injuriesForeign investigationBoeing 777 · Amsterdam, NetherlandsThe government of Netherlands has notified the NTSB of an accident involving a BOEING 777 airplane that occurred on April 17, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Netherlands's investigation under the…NTSB WPR17LA087Accident · Serious injuriesLimited investigationFinal reportTitan Tornado I · Spanaway, WAMaintenance personnel’s improper attachment of the aileron system components, which resulted in the pilot's inability to maintain flight control.NTSB CEN17FA152Accident · 1 fatalField investigationFinal reportTemco GC 1B · Hartsville, INThe pilot's loss of control after exceeding the airplane's critical angle of attack during takeoff, which resulted in an aerodynamic stall.NTSB GAA17CA232Accident · No injuriesData collectionFinal reportCessna 172 · Houston, TXThe pilot’s delayed attempt to abort the takeoff with a tailwind, which resulted in a runway overrun.NTSB GAA17CA234Accident · No injuriesData collectionFinal reportBellanca 8KCAB · Stafford, KSThe pilot's failure to maintain directional control during the takeoff roll.NTSB ERA17FA148Accident · 1 fatalField investigationFinal reportPiper PA 12 · Sanford, FLThe incorrect rigging of the elevator control cables, which resulted in a reversal of elevator control inputs applied by the pilot during the takeoff, an excessive nose-high pitch, and subsequent aerodynamic stall after takeoff. Also causal was the inadequate…NTSB GAA17CA217Accident · Minor injuriesData collectionFinal reportFunk B85C · Cedar City, UTThe pilot’s failure to maintain directional control of the airplane during the takeoff roll.NTSB ERA17LA141Accident · No injuriesLimited investigationFinal reportCessna R182 · Mooresville, NCThe pilot's failure to properly configure the airplane's flaps for takeoff, which resulted in a longer ground roll and subsequent runway excursion.NTSB GAA17CA200Accident · No injuriesData collectionFinal reportDehavilland DHC-2 · Ketchikan, AKThe floatplane pilot's failure to avoid a buoy during takeoff.NTSB GAA17CA193Accident · No injuriesData collectionFinal reportPiper PA 12 · Palmer, AKThe pilot’s failure to maintain directional control during takeoff, which resulted in a ground loop.NTSB CEN17LA145Accident · No injuriesLimited investigationFinal reportCessna 120 · Columbia, ILThe partial loss of engine power due to carburetor icing.NTSB GAA17CA227Accident · No injuriesData collectionFinal reportCubcrafters CC11-160 · Borrego Springs, CAThe pilot’s selection of an unsuitable takeoff area, which resulted in impact with obstacles.NTSB GAA17CA146Accident · No injuriesData collectionFinal reportKaman Aerospace K 1200 · Julian, CAThe pilot’s failure to conduct a thru-flight walkaround inspection, which resulted in the engine cowling remaining open and subsequently separating from the helicopter and striking the main rotor blades and vertical stabilizer during departure.NTSB GAA17CA189Accident · No injuriesData collectionFinal reportPiper PA 28 · Gila Bend, AZThe flight instructor’s failure to review the notices to airmen related to the airport, which resulted in his landing on a closed runway and the airplane striking runway closed markers.NTSB ERA17CA129Accident · Minor injuriesData collectionFinal reportKerns Kenneth H Kens Wingless Wonder · Mount Airy, NCThe pilot’s improper adjustment of the prerotator motor, which resulted in its failure to disengage and the subsequent loss of aircraft control during takeoff.NTSB ERA17WA127Accident · 7 fatalForeign investigationSikorsky S76 · Istanbul, TürkiyeOn March 10, 2017, at 0821 coordinated universal time, a Sikorsky S-76C++ helicopter, Turkish registration TC-HEZ, was destroyed shortly after takeoff from the Istanbul Ataturk Airport (LTBA), Istanbul, Turkey. The two pilots and the five passengers were…NTSB DCA17FA076Accident · Minor injuriesClass 1 · FieldFinal reportMcdonnell Douglas MD80 · Ypsilanti, MIthe jammed condition of the airplane's right elevator, which resulted from exposure to localized, dynamic wind while the airplane was parked and rendered the airplane unable to rotate during takeoff. Contributing to the accident were (1) the effect of a large…NTSB WPR17FA074Accident · 1 fatalField investigationFinal reportQuicksilver MXL II · Hesperia, CAThe pilot's failure to identify and correct his construction error of a critical structural component, which resulted in a loss of airplane control during takeoff. Contributing to the accident was the pilot's impairment due to his combined use of multiple…NTSB GAA17CA164Accident · No injuriesData collectionFinal reportAir Tractor AT 802 · Prentiss, MSThe pilot's decision to take off with a gusting tailwind and his subsequent failure to maintain directional control.NTSB GAA17CA166Accident · No injuriesData collectionFinal reportPiper PA28 · Phoenix, AZThe flight instructor’s incorrect control inputs while taking off with a known quartering tailwind, which resulted in a loss of directional control and runway excursion.NTSB GAA17CA158Accident · No injuriesData collectionFinal reportSocata TBM700 · Bellingham, WAThe pilot’s failure to properly deice the airplane before takeoff, which resulted in an aerodynamic stall during the initial climb.NTSB WPR17WA081Accident · 2 fatalForeign investigationCessna 162 LSA · Faisalabad, PakistanThe foreign authority was the source of this information. On February 24, 2017, at 0738 universal coordinated time, a Cessna 162, AP-ZBQ, collided with terrain shortly after takeoff from Faisalabad, Pakistan. The airplane was operated by M/S. Shaheen Air…NTSB ENG17WA015Incident · No injuriesForeign investigationAirbus A320 · Sao Paulo, BrazilOn February 23, 2017, during takeoff from São Paulo airport, the right hand engine of a Brazilian registered Airbus 320, registration number PT–MZY, lost power, causing a rejected takeoff and a temporary excursion from the runway. The Brazilian Centro de…NTSB DCA17WA115Incident · No injuriesForeign investigationAirbus A321 · Cancun, MexicoThe Direccion General de Aeronautica Civil (DGAC) of Mexico has notified the NTSB of an incident involving a AIRBUS A321 airplane that occurred on February 20, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's…NTSB GAA17CA154Accident · No injuriesData collectionFinal reportCessna 180 · Bally, PAThe pilot’s failure to maintain directional control during takeoff in crosswind conditions.NTSB GAA17CA144Accident · No injuriesData collectionFinal reportPitts Special S 1C · Borger, TXThe pilot’s failure to maintain directional control of the biplane during takeoff.NTSB ERA17CA114Accident · No injuriesData collectionFinal reportCessna 172N · Statesville, NCA loss of airplane control during takeoff for reasons that could not be determined based on the available information.