Fatal NTSB investigations, Outside the U.S.
52 cases where the sequence of events included Collision during takeoff/land.
Cases per year
| 2009 | 1 |
|---|---|
| 2010 | 1 |
| 2011 | 3 |
| 2012 | 2 |
| 2013 | 2 |
| 2014 | 4 |
| 2015 | 3 |
| 2016 | 1 |
| 2017 | 8 |
| 2018 | 2 |
| 2019 | 3 |
| 2020 | 3 |
| 2021 | 4 |
| 2022 | 8 |
| 2023 | 2 |
| 2024 | 3 |
| 2025 | 1 |
| 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 c.\"eventCountry\" <> 'USA'
AND c.\"highestInjuryLevel\" = 'Fatal'
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 c."eventCountry" <> 'USA' AND c."highestInjuryLevel" = 'Fatal' 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 GAA26WA101Accident · 3 fatalClass 5 · ForeignCessna 210 · Goolwa, AustraliaNTSB GAA25WA248Accident · 1 fatalClass 5 · ForeignQuicksilver MX II · Phuket, ThailandNTSB DCA25WA046Accident · 1 fatalClass 3 · ForeignBoeing 737 · Vilnius, LithuaniaNTSB GAA24WA246Accident · 1 fatalClass 5 · ForeignZodiac CH601XL · Tambon Khok Kham, ThailandNTSB GAA24WA069Accident · 2 fatalClass 5 · ForeignRobinson R22 · Cannes Mandelieu, FranceNTSB GAA23WA271Accident · 1 fatalClass 5 · ForeignRobinson R44 · Garmen village, BulgariaNTSB GAA23WA188Accident · 2 fatalClass 5 · ForeignCessna 206 · Gracias A Dios, HondurasNTSB GAA23WA084Accident · 1 fatalClass 5 · ForeignSocata TB21 · Saint-Pons, FranceNTSB GAA23WA076Accident · 2 fatalClass 5 · ForeignBanus Mark Glasair Super II FT · Wedderburn, AustraliaNTSB GAA23WA017Accident · 2 fatalClass 5 · ForeignCessna T206G · Guayaquil, EcuadorNTSB GAA23WA015Accident · 1 fatalClass 3 · ForeignCessna 172 · Ulsan, South KoreaNTSB GAA23WA005Accident · 1 fatalClass 5 · ForeignBell 206 · Maitland, AustraliaNTSB GAA22WA283Accident · 5 fatalClass 5 · ForeignCessna 210 · Impalia, NamibiaNTSB GAA22WA197Accident · 1 fatalClass 3 · ForeignPiper PA31 · Deadman's Cay, BahamasNTSB GAA22WA162Accident · 1 fatalClass 5 · ForeignMooney M20K · Springbank, AB, CanadaNTSB GAA21WA165Accident · 2 fatalClass 5 · ForeignIai 1124 · Treasure Cay, BahamasNTSB GAA21WA161Accident · 1 fatalClass 4 · ForeignBeech V35 · Padua, ItalyNTSB GAA21WA099Accident · 6 fatalClass 5 · ForeignPiper PA-32-260 · Monterrey, MexicoNTSB GAA21WA095Accident · 1 fatalClass 5 · ForeignCessna 182 · Fundo, VenezuelaNTSB ERA21WA086Accident · 1 fatalClass 5 · ForeignBell 206 · Mambucaba, BrazilNTSB ERA20WA173Accident · 1 fatalForeign investigationPiper PA25 · Matoes do Norte, BrazilThe government of Brazil has notified the NTSB of an accident involving a PIPER PA25 airplane that occurred on April 18, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions of…NTSB WPR20WA107Accident · 5 fatalForeign investigationCessna 404 · Lockhart River, AustraliaThe government of Australia has notified the NTSB of an accident involving a Cessna 404 airplane that occurred on March 11, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's investigation under the…NTSB ERA20WA041Accident · 3 fatalForeign investigationCessna 550 · Marau, BrazilThe government of Brazil has notified the NTSB of an accident involving a Cessna 550 airplane that occurred on November 14, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions…NTSB ERA19WA271Accident · 7 fatalForeign investigationPiper PA31 · Popayan, ColombiaThe government of Colombia has notified the NTSB of an accident involving a PIPER PA31 airplane that occurred on September 15, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Colombia's investigation under the…NTSB ERA19WA198Accident · 4 fatalForeign investigationDiamond DA 62 · Dubai, United Arab EmiratesThe government of United Arab Emirates has notified the NTSB of an accident involving a Diamond DA 62 airplane that occurred on May 16, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of United Arab Emirates's…NTSB ERA19WA058Accident · 4 fatalForeign investigationCessna 525 · Jequitaí County, BrazilThe government of Brazil has notified the NTSB of an accident involving a Cessna 525 airplane that occurred on November 26, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions…NTSB CEN18WA261Accident · 1 fatalForeign investigationRobinson R44 Raven I · Kanaš, SlovakiaOn July 7, 2018, at 1640 coordinated universal time, a Robinson R22 Raven 1, OM-TTM, impacted powerlines during takeoff near Kanaš, Slovak Republic. The helicopter was destroyed. The pilot sustained fatal injuries. The flight was originating at the time of…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 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 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…NTSB ERA17WA090Accident · 3 fatalForeign investigationAerofab Lake LA 250 · Puerto Plata, Dominican RepublicOn October 17, 2016, about 2200 coordinated universal time, an AeroFab, Inc. Lake-250, N724ST, was substantially damaged when it impacted the ocean while on approach to Gregorio Luperón International Airport (POP), Puerto Plata, Dominican Republic. The pilot…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 ERA15WA309Accident · 3 fatalForeign investigationCessna 172N · Bajo Baudo, ColombiaOn August 9, 2015, about 2200 coordinated universal time, a Cessna 172N, Colombian registration TI-BAA, was destroyed when it impacted terrain during a rejected landing at Pizarro Airport (SK-195), Bajo Baudo, Colombia. The two pilots and one passenger were…NTSB CEN15WA186Accident · 1 fatalForeign investigationRobinson R44 - II · Modrava, CzechiaOn March 29, 2015, at 0920 universal coordinated time (UTC), a Robinson model R44 Raven II helicopter, Czech Republic registration OK-RRJ, serial number 12464, sustained substantial damage when it collided with wooded terrain within Šumava National Park, near…NTSB ERA15WA070Accident · 10 fatalForeign investigationPiper PA-31-350 · Mariquita, ColombiaNTSB WPR14WA191Accident · 1 fatalForeign investigationMaule M-5-235C · Lismore Aerodrome, Australia, AustraliaOn April 12, 2014, at 1230 universal coordinated time, a Maule M-5-235C, VH-HOG, struck a power line and subsequently impacted terrain near Lismore Aerodrome, Australia. The airplane was operated by the pilot under the pertinent civil regulation of the…NTSB CEN14WA169Accident · 2 fatalForeign investigationFritz Neumeyer Glasair II FT / 1865 · Turnau, AustriaOn 22 March 2014, approximately 1126 coordinated universal time, a Glasair II FT, airplane, registration D-EJFN crashed shortly after takeoff from the Lanzen-Turnau Airport, Turnau, Austria. The pilot and passage were fatally injured. The incident is being…NTSB CEN14WA171Accident · 4 fatalForeign investigationAgustawestland Agusta AW139 · Gillingham, Norfolk, United KingdomOn March 13, 2014, about 1927 coordinated universal time, an Agusta/Westland model AW139 helicopter, United Kingdom registration G-LBAL, impacted terrain shortly after takeoff near Gillingham, Norfolk, United Kingdom. The four occupants were fatally injured.…NTSB CEN14WA012Accident · 1 fatalForeign investigationCessna 172R · Krems, AustriaOn October 20, 2013, about 0825 coordinated universal time, a Cessna 172R, OE-KRP, impacted terrain shortly after takeoff from the Krems Langenlois Airport, Krems, Austria. The private pilot was fatally injured and the passenger sustained serious injuries.…NTSB WPR14WA098Accident · 1 fatalForeign investigationAmateur Built KR-2 · Tumut, New South Wales, AustraliaOn October 5, 2013, at 0900 local time, an amateur built aircraft, KR-2, VH-CTE, collided with the terrain shortly after takeoff from a private airstrip near Tumut, New South Wales. The flight was operated by the pilot under the pertinent civil regulations of…NTSB ERA12WA243Accident · 1 fatalForeign investigationBell 407 · Podnovye, RussiaOn March 22, 2012, about 0615 coordinated universal time, a Bell 407, Russian registration RA-01931, was substantially damaged when it impacted electrical utility wires and the Volga River while on approach to a private landing area near Podnovye, Russia. The…NTSB ERA12WA238Accident · 4 fatalForeign investigationBeech 95B55 · Cameta, BrazilOn February 16, 2012, about 1230 universal coordinated time, a Beech 95-B55, Brazilian registration PT-LOU, was destroyed when it impacted trees and terrain shortly after takeoff in Cameta Municipality, State of Mato Para, Brazil. The foreign certificated…NTSB CEN12WA223Accident · 1 fatalForeign investigationPiper PA-31 · Cottens, SwitzerlandThe accident investigation is under the jurisdiction and control of the Swiss government. This report is for informational purposes only and contains only information released by or obtained from the Swiss government or the Swiss Accident Investigation Board.…NTSB CEN11WA587Accident · 2 fatalForeign investigationGardan GY80-160 · Mauterndorf, AustriaUnder the jurisdiction and control of the Austrian Government.NTSB WPR11WA393Accident · 3 fatalForeign investigationAerospatiale AS355 · Marree, Australia, AustraliaOn August 18, 2011, at 1008 universal coordinated time, an Aerospatiale AS 355F2, VH-NTV, operated by Australian Broadcasting Corporation, collided with terrain shortly after takeoff near Marree, Australia. The helicopter was substantially damaged and…