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 GAA16CA105Accident · No injuriesData collectionFinal reportEngineering & Research Ercoupe 415 · Chappell, NEThe pilot's inability to correct for a crosswind during the takeoff roll due to the interlinked flight control design, which resulted in a runway excursion, and a collision with terrain.NTSB CEN16IA091Incident · No injuriesIncident investigationFinal reportMitsubishi MU 300 · Little Rock, ARThe flight crew's inadequate preflight inspection of the airplane, during which they failed to see a fueling mat that had been placed on the inboard trailing edge of the right wing, which the right engine subsequently ingested during the takeoff roll.…NTSB DCA16WA079Incident · No injuriesForeign investigationBoeing 737 · Gran Canaria, SpainThe Comisión de Investigación de Accidentes e Incidentes de Aviación Civil (CIAIAC) of Spain has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on January 07, 2016. The NTSB has appointed a U.S. Accredited Representative to…NTSB ANC16IA013Incident · No injuriesIncident investigationFinal reportRobinson Helicopter R44 II · Anchorage, AKThe overhaul facility's improper and excessive use of an approved lubricant during overhaul of the fuel injection servo, which resulted in a disruption of fuel flow and a total loss of engine power.NTSB CEN16LA078Accident · No injuriesLimited investigationFinal reportCessna 170B · Ingleside, TXThe loss of engine power during takeoff due to carburetor icing, which resulted in a forced landing.NTSB GAA16CA094Accident · Minor injuriesData collectionFinal reportCostruzioni Aeronautiche Tecna P92 Eaglet · Chesapeake, VAThe pilot's loss of directional control during takeoff which resulted in impact with the ground.NTSB WPR16WA051Accident · 10 fatalForeign investigationBeech 200 · New Delhi, IndiaThe Air Accident Investigation Bureau (AAIB) of India has notified the NTSB of an accident involving a Beech Super King Air B-200, registration VT-BSA, that occurred on December 22, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the…NTSB GAA16CA088Accident · No injuriesData collectionFinal reportDay William L Minicoupe · Middle River, MDThe pilot's incorrect installation of the rudder horn and failure to properly inspect the installation, which led to a loss of directional control during takeoff.NTSB WPR16FA035Accident · 2 fatalField investigationFinal reportAero Vodochody L 39C · Apple Valley, CAA total loss of engine power on takeoff, which resulted from a sudden over-temperature condition due to an improperly adjusted fuel control unit and the deteriorated condition of the fuel nozzles.NTSB GAA16CA069Accident · No injuriesData collectionFinal reportPiper PA 46-350P · Mammoth, CAThe pilot's decision to takeoff in high crosswind conditions resulting in the inability to maintain an adequate crosswind correction, consequently failing to maintain directional control and departing the runway, and subsequently colliding with fixed airfield…NTSB DCA16WA049Incident · No injuriesForeign investigationBombardier BD100 1A10 · Le Bourget, FranceThe BEA of France has notified the NTSB of an incident involving a Bombardier BD100 1A10 that occurred on December 02, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the BEA's investigation under the provisions of ICAO Annex 13 as the…NTSB ANC16CA009Accident · No injuriesData collectionFinal reportCessna 172 · Manley Hot Springs, AKThe pilot's decision to depart from an unsuitable, off-airport site, which resulted in a collision with a tree.NTSB CEN16WA049Accident · No injuriesForeign investigationPiper PA31 · Guatemala City, GuatemalaOn November 21, 2015, at 1800 universal coordinated time, a Piper PA-31, C6-TAK, was destroyed on impact with a house following a loss of control during takeoff from La Aurora International Airport, Guatemala City, Guatemala. The airplane was destroyed. The…NTSB GAA16CA054Accident · No injuriesData collectionFinal reportAeronca 7AC · Fowlerville, MIThe pilot's failure to maintain pitch control during the takeoff roll, which resulted in an impact with terrain.NTSB GAA16CA062Accident · No injuriesData collectionFinal reportConsolidated Aeronautics Lake LA-4 · Morganton, NCThe pilot's failure to maintain directional control during the departure, resulting in substantial damage to the airplanes right wing.NTSB GAA16CA050Accident · No injuriesData collectionFinal reportCessna 182Q · Bowstring, MNThe pilot exceeded the critical angle of attack during takeoff which resulted in an aerodynamic stall and impact with a wind sock and terrain.NTSB CEN16FA034Accident · 2 fatalField investigationFinal reportCirrus Design SR22 · Colorado Springs, COThe pilot's loss of airplane control during the turn back to the airport after takeoff in high density altitude conditions, which resulted in an inadvertent aerodynamic stall and subsequent spin. Contributing to the accident was the pilot's impaired…NTSB ERA16CA060Accident · No injuriesData collectionFinal reportEurocopter Deutschland EC 135 · Monongahela, PAThe inadequate securing of the wheeled fire extinguisher's cover which resulted in it being blown off of the fire extinguisher and ingested into the helicopter's fenestron during takeoff, resulting in a loss of directional control.NTSB GAA16CA045Accident · No injuriesData collectionFinal reportSchweizer 269C 1 · Mount Pocono, PAThe student pilot's failure to remove the tension applied to the cyclic before takeoff, which resulted in a loss of directional control and the tail rotor striking the ground.NTSB GAA16CA043Accident · No injuriesData collectionFinal reportCessna 182 · Douglas Bisbee, AZThe student pilot's loss of directional control during takeoff, which resulted in a runway excursion, left main landing gear collapse, and a collision with terrain.NTSB DCA16WA017Incident · No injuriesForeign investigationMcdonnell Douglas DC 9 82(MD-82) · San Luis Potosi, MexicoThe Dirección General de Aeronáutica Civil (DGAC) of Mexico has notified the NTSB of an incident involving a McDonnell Douglas DC-9-82, which occurred on November 2, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the DGAC…NTSB GAA16LA032Accident · Serious injuriesLimited investigationFinal reportPhilip D Anderson 601 · Hemet, CAThe pilot's failure to maintain the airplane's descent rate during a precautionary landing, which resulted in hard landing. Contributing to the accident was the pilot's failure to secure the canopy before takeoff, which precipitated the precautionary landing.NTSB ERA16WA049Accident · 1 fatalForeign investigationRobinson R44 · Guarani Municipality, BrazilOn October 25, 2015, at 1730 local time (1930 coordinated universal time), a Robinson R44, Brazilian registration PP-BAO, was substantially damaged when it impacted trees and a lake after takeoff in the Guarani Municipality, State of Minas Gerais, Brazil. The…NTSB CEN16LA022Accident · 1 fatalLimited investigationFinal reportDelwyn Schmidt No model · Bennington, KSThe unregistered airplane’s loss of engine power due to piston seizure. Contributing to the accident was the pilot’s loss of airplane control while maneuvering back to the runway.NTSB WPR16LA018Accident · No injuriesLimited investigationFinal reportCessna 120 · Lone Pine, CAThe fracture of the left main landing gear (MLG) wheel axle due to fatigue, which resulted in the separation of the left MLG wheel during takeoff from a dirt airstrip.NTSB GAA16CA035Accident · No injuriesData collectionFinal reportBrandon Evans Gyroplane · Buckeye, AZThe student pilot's incorrect control input during takeoff which resulted in a runaway excursion and impact with terrain.NTSB GAA16CA071Accident · No injuriesData collectionFinal reportBell 206 · Christmas Island, KiribatiThe pilot's inadequate preflight inspection and the maintenance crew's failure to remove the tie down.NTSB ERA16WA020Accident · No injuriesForeign investigationLearjet 35A · Buenos Aires, ArgentinaNTSB ERA16LA019Accident · No injuriesLimited investigationFinal reportBeech 23 · Humboldt, TNA partial loss of engine power due to low No. 2 cylinder compression and an inoperative right magneto.NTSB ERA16LA058Accident · No injuriesLimited investigationFinal reportCessna R182 · Sanford, FLA collapse of the nose landing gear due to a separation of the drag attachment fitting from the airframe. The separation was likely due to preexisting damage from an undetermined event.NTSB GAA16CA021Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Old Harbor, AKThe pilot's selection of unsuitable terrain for landing, resulting in a collision with terrain.NTSB ANC16WA004Accident · 2 fatalForeign investigationCessna 207 · Taylor, CanadaOn October 16, 2015, about 2330 Coordinated Universal Time, a Cessna 207 airplane, C-GNVZ, impacted terrain near Taylor, British Columbia, Canada, under unknown circumstances. The pilot and passenger sustained fatal injuries. The Transportation Safety Board…NTSB WPR16LA011Accident · No injuriesLimited investigationFinal reportChristopher Tom Kitfox 5 · Battle Ground, WAThe total loss of engine power for reasons that could not be determined because postaccident examination of the engine revealed no preimpact mechanical malfunctions or failures that would have precluded normal operation.NTSB CEN16LA019Accident · Serious injuriesLimited investigationFinal reportQuest Kodiak 100 · Sheridan, WYThe loss of airplane control during takeoff for reasons that could not be determined based on the available information.NTSB WPR16LA005Accident · Serious injuriesLimited investigationFinal reportPiper PA28 · Compton, CAA total loss of engine power during initial climb for reasons that could not be determined because postaccident engine examination did not reveal any anomalies that would have precluded normal operation.NTSB ERA16WA017Accident · 1 fatalForeign investigationEmbraer EMB721C · Corumba, BrazilOn October 6, 2015, about 1200 universal coordinated time, an Embraer EMB721C, Brazilian registration PT-RAM, was substantially damaged when it encountered a wind gust and struck a tree, during takeoff from Guanabara Farm, Corumba, Brazil. The pilot and one…NTSB GAA16CA006Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Devine, TXThe pilot's failure to maintain obstacle clearance during the takeoff, which resulted in the helicopter striking power lines.NTSB CEN16LA006Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R44 · Parkston, SDThe pilot’s decision to take off from a confined area and his failure to adequately compensate for wind conditions during the takeoff, which resulted in collision with obstacles.NTSB ERA16WA002Accident · 2 fatalForeign investigationPiper PA-31-325 · Chia, ColombiaOn October 3, 2015, about 1715 UTC, a Piper PA-31-325, Colombian registration HK3909G, registered to and operated by El Caminante Air S.A., collided with a structure then rolled inverted during a forced landing in a field near Hipodromo de los Andes, Chia,…NTSB GAA15CA295Accident · No injuriesData collectionFinal reportBeech V35B · Houston, TXThe pilot's failure to properly secure the cabin door prior to takeoff, resulting in the door opening during takeoff, an aborted takeoff, runway overrun, and collision with terrain.NTSB DCA15WA204Accident · No injuriesForeign investigationDe Havilland DHC8 · Saarbrucken, GermanyThe government of Germany has notified the NTSB of an accident involving a DE HAVILLAND DHC8 airplane that occurred on September 30, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the government of Germany's investigation under the…NTSB GAA15CA293Accident · No injuriesData collectionFinal reportCubcrafters CC11-160 · Lake City, COThe pilot's loss of directional control during the takeoff, which resulted in a collision with a parked airplane and impact with terrain.NTSB GAA15CA292Accident · No injuriesData collectionFinal reportCubcrafters CC11-160 · Lake City, COThe pilot's failure during takeoff to attain sufficient airspeed for conditions, and to maintain yaw control and a positive rate of climb, resulting in a loss of directional control, an uncontrolled descent, and collision with trees and terrain.NTSB CEN15WA449Accident · 1 fatalForeign investigationTrendak Tercel · Odorheiul Secuiesc City, RomaniaThis is preliminary information, subject to change, and may contain errors. On September 26, 2015, at an unknown time, a Trendak Tercel gyroplane, A11-DUN, impacted terrain after takeoff from an airfield near Odorheiul Secuiesc city, Harghita County, Romania.…NTSB GAA15CA278Accident · No injuriesData collectionFinal reportCessna 182A · Ama, LAThe pilot's decision to takeoff on a partially obstructed runway, which resulted in a collision with trees.NTSB GAA15CA282Accident · Minor injuriesData collectionFinal reportCessna 170B · Arctic Village, AKThe pilot exceeded the critical angle of attack during takeoff, which resulted in an aerodynamic stall and a collision with terrain.NTSB GAA15LA284Accident · Serious injuriesLimited investigationFinal reportChampion 7ECA · Talkeetna, AKThe pilot's failure to properly calculate the fuel consumption rate and to properly monitor the fuel status in flight and his decision to continue the flight despite signs of an engine problem, which resulted in a total loss of engine power due to fuel…NTSB CEN15LA418Accident · Minor injuriesLimited investigationFinal reportCessna 421B · Platteville, WIThe partial loss of right engine power for undetermined reasons with insufficient runway remaining for the aborted takeoff.NTSB GAA15CA277Accident · No injuriesData collectionFinal reportMooney M20M · Manville, NJThe pilot's failure to maintain directional control during the takeoff roll, which resulted in a runway excursion and collision with a fence.NTSB GAA15CA272Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 20 C1 · Sanford, NCThe student pilots failure to maintain a climb after takeoff, which resulted in an impact with terrain.