NTSB investigations, 2017
38 cases where the defining event was Collision during takeoff/land.
Cases per year
| 2008 | 66 |
|---|---|
| 2009 | 67 |
| 2010 | 44 |
| 2011 | 41 |
| 2012 | 38 |
| 2013 | 27 |
| 2014 | 26 |
| 2015 | 32 |
| 2016 | 32 |
| 2017 | 38 |
| 2018 | 42 |
| 2019 | 50 |
| 2020 | 57 |
| 2021 | 47 |
| 2022 | 59 |
| 2023 | 53 |
| 2024 | 45 |
| 2025 | 28 |
| 2026 | 35 |
Where
Open the mapLatest cases
Query with SQL
duckdb -csv -c "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 year(c.\"eventDate\") = 2017
AND c.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '490')
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.
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 year(c."eventDate") = 2017 AND c."mKey" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '490') ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run 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 GAA18CA094Accident · No injuriesData collectionFinal reportPiper PA32 · Spearfish, SDThe pilot’s inadvertent landing in snow adjacent to the snow-covered runway resulting in a collision with runway signs.NTSB ENG18WA024Accident · No injuriesForeign investigationAntonov TVS-2MS · Naryan-Mar, RussiaA TVS-2MS airplane powered by a Honeywell TPE331-12UHR-702H and equipped with skids impacted unpaved runway after an aborted takeoff. The airplane was completed destroyed. The Russian Interstate Aviation Committee (MAK) is investigating.NTSB GAA18CA075Accident · Minor injuriesData collectionFinal reportJones Kent C Vans RV-10 · Limon, COThe pilot’s unstabilized approach and failure to go around at night, which resulted in the airplane impacting a power line and a subsequent hard landing.NTSB WPR18WA017Accident · 1 fatalForeign investigationCessna 210 · Albany, AustraliaOn October 24, 2017, at 1115 local time, a Cessna 210B, VH-DBU, was destroyed when it impacted the ground following a collision with terrain near Albany, Western Australia. The airplane was operated under the pertinent regulations of the Australian…NTSB GAA18CA017Accident · Serious injuriesData collectionFinal reportYoung David E Pitts S1 C · Farmville, VAThe pilot’s failure to see and avoid the other airplane landing in the opposite direction on the runway. Contributing to the accident was the pilot’s failure to use the correct runway call sign in his radio communications.NTSB CEN18WA007Accident · 1 fatalForeign investigationRobinson R44 · Gramzda, LatviaOn October 8, 2017, about 1014 Coordinated Universal Time (UTC), a Robinson R44 helicopter, YL-HBH, impacted a powerline after takeoff near Gramzda, Latvia. One passenger was fatally injured and the pilot and two other passengers on board were seriously…NTSB GAA18CA007Accident · No injuriesData collectionFinal reportCessna T210 · Waterford, MIThe pilot's unstabilized approach at night, which resulted in collision with trees.NTSB GAA18CA016Accident · Serious injuriesData collectionFinal reportUltramagic T210 · Albuquerque, NMThe pilot's failure to maintain adequate clearance from a balloon on the ground during landing.NTSB CEN18LA002Accident · Serious injuriesLimited investigationFinal reportCharles A Brazil MTO Sport · McCoy, TXThe pilot’s failure to maintain clearance from a powerline during landing.NTSB GAA17CA546Accident · No injuriesData collectionFinal reportCessna 150 · Siler City, NCThe pilot's improper decision to take off with known electrical issues, which distracted him and led to a loss of directional control during the takeoff roll.NTSB ERA17LA337Accident · No injuriesClass 3 · LimitedFinal reportAirmax Construcoes Aeronautica SEAMAX-M22 · New Fairfield, CTCollision with a submerged object during a water landing.NTSB CEN17CA345Accident · No injuriesData collectionFinal reportShiner RV-4 · Ramah, NMThe pilot’s failure to maintain clearance from berms during landing in sun glare conditions.NTSB DCA17WA165Accident · No injuriesForeign investigationBoeing 737 · Medan, IndonesiaThe KNKT of Indonesia has notified the NTSB of an accident involving a Boeing 737 airplane that occurred on August 03, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the KNKT's investigation under the provisions of ICAO Annex 13 as…NTSB ANC17CA041Accident · No injuriesData collectionFinal reportAirbus AS350 · Delta Junction, AKThe pilot’s failure to maintain clearance from a steel frame attached to a tracked drilling unit. Contributing to the accident was the pilot’s failure to visually identify the steel frame during the reconnaissance process.NTSB GAA17CA450Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R44 · Dunlap, ILThe pilot’s failure to visually confirm that the helicopter was disconnected from hoses during refueling operations. Contributing to the accident was the pilot’s and ground crew’s misunderstanding of the hand signals.NTSB ERA17RA260Accident · 1 fatalForeign investigationBritten Norman BN2A · Eteringbang, GuyanaOn July 25, 2017, about 2153 coordinated universal time, a Britten Norman BN2A-26, Guyana Registration 8R-GRA, operated by Roraima Airways Ltd., was substantially damaged when it impacted wooded terrain while on approach to Eteringbang Airstrip (SYET),…NTSB ANC17CA038Accident · No injuriesData collectionFinal reportDehavilland DHC 2 · Dilllingham, AKThe pilot's failure to set the wing flaps to the "takeoff" position, which resulted in a longer-than-normal takeoff run and collision with terrain.NTSB ERA17CA251Accident · No injuriesData collectionFinal reportWeatherly 620 · Pemberton Twp, NJAn in-flight collision with a bird during takeoff, which resulted in a partial loss of engine power and subsequent collision with trees and terrain.NTSB CEN17WA279Accident · 1 fatalForeign investigationPiper Piper J3C-65 · Laukaa, FinlandOn July 19, 2017, about 0903 coordinated universal time, a Piper J3C-65 airplane, Finnish registration OH-PAD, was destroyed when it collided with the trees and terrain near Laukaa, Finland. The pilot was fatally injured. The airplane departed a private…NTSB GAA17CA412Accident · No injuriesData collectionFinal reportMooney M20C · Washington Island, WIThe pilot's failure to maintain a proper approach path, which resulted in impact with trees.NTSB GAA17CA390Accident · Minor injuriesData collectionFinal reportBell 407 · Topeka, KSThe pilot’s failure to maintain clearance from a building during landing.NTSB GAA17CA365Accident · Minor injuriesData collectionFinal reportBeech 58 · Ingleside, TXThe pilot’s inability to avoid a collision with an unauthorized vehicle on the runway during the landing roll and the truck driver’s decision to cross the runway in front of the airplane.NTSB GAA17CA387Accident · No injuriesData collectionFinal reportPiper PA 12 · Chickaloon, AKThe pilot’s improper landing flare on a turf runway, which necessitated a go-around during which he failed to establish a climb.NTSB ANC17LA032Accident · Minor injuriesClass 2 · LimitedFinal reportDehavilland DHC-2 · Ketchikan, AKThe pilot's misjudgment of the takeoff distance needed to depart the lake, and his subsequent failure to maintain clearance from the water during a turn to avoid terrain, which resulted in impact with water.NTSB ERA17WA193Accident · 1 fatalForeign investigationCessna 172 · Chernihiv, UkraineOn May 26, 2017, about 1200 coordinated universal time, a Cessna 172M, Ukrainian registration UR-WTA, was substantially damaged when it impacted a one-story building after takeoff from the Pivtsi Airport, Chernihiv, Ukraine. The pilot was fatally injured. The…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 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 GAA17CA211Accident · No injuriesData collectionFinal reportMooney M20J · Cedar Key, FLThe pilot’s failure to follow the manufacturer’s go-around procedure, which resulted in an aerodynamic stall.NTSB GAA17CA200Accident · No injuriesData collectionFinal reportDehavilland DHC-2 · Ketchikan, AKThe floatplane pilot's failure to avoid a buoy during takeoff.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 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 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 GAA17CA157Accident · No injuriesData collectionFinal reportPiper PA 28-140 · Weiser, IDThe student pilot’s failure to maintain directional control and to maintain clearance from a snow berm during the aborted landing.NTSB ERA17LA109Accident · Minor injuriesLimited investigationFinal reportErcoupe 415 · Dawsonville, GAA decrease in oil pressure due to the pilot's unintentional overfilling of the engine oil sump, and the pilot's subsequent decision to perform an off-airport precautionary landing, which resulted in impact with a tree.NTSB CEN17WA382Accident · 2 fatalForeign investigationCessna 152 · Praia de São João – Caparica – Portugal, PortugalOn August 2, 2017, at 1551 universal coordinated time, a Cessna 152, CS-AVA, experienced a loss of engine power during cruise flight. A forced landing was performed on a beach near Praia de São João da Caparica, Portugal. During the landing, the airplane…NTSB CEN17LA097Accident · Serious injuriesLimited investigationFinal reportBeech BE35 · Ozark, MOThe pilot's failure to adequately monitor the environment and to maintain sufficient altitude to clear power lines.NTSB ERA17CA087Accident · Serious injuriesData collectionFinal reportCessna 170 · Hayden, ALThe pilot’s failure to maintain clearance from trees during the approach.NTSB ERA17WA084Accident · 4 fatalForeign investigationCessna 172 · Tirua, ChileOn January 8, 2017, about 1741 coordinated universal time (1441 local time), a Cessna 172, Chilean registration CC-CMP, was destroyed when it collided with terrain during final approach to Tirua Airport (SCQK), Tirua, Chile. The pilot and three passengers…