NTSB investigations, 2017, Outside the U.S.
11 cases where the sequence of events included Collision during takeoff/land.
Cases per year
| 2009 | 1 |
|---|---|
| 2010 | 2 |
| 2011 | 3 |
| 2012 | 3 |
| 2013 | 2 |
| 2014 | 4 |
| 2015 | 4 |
| 2016 | 3 |
| 2017 | 11 |
| 2018 | 4 |
| 2019 | 5 |
| 2020 | 4 |
| 2021 | 6 |
| 2022 | 9 |
| 2023 | 8 |
| 2024 | 8 |
| 2025 | 2 |
| 2026 | 1 |
Latest 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.\"eventCountry\" <> 'USA'
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '490' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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."eventCountry" <> 'USA' AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '490' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 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 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 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 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 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 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 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 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 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 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…