NTSB investigations, Outside the U.S.
79 cases where the sequence of events included Collision during takeoff/land.
Cases, newest first
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.\"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."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 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…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 CEN16WA398Accident · Serious injuriesForeign investigationCirrus SR22 · Ailly-sur-Somme, FranceNTSB DCA16WA126Accident · Minor injuriesForeign investigationBoeing 737 · Jakarta, IndonesiaThe government of Indonesia has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on April 04, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of Indonesia's investigation under the…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 CEN15WA440Accident · Serious injuriesForeign investigationMaule MX7 · Munster, SwitzerlandOn July 18, 2015 about 0857 UTC, a Maule MX7-235 airplane, Swiss registration HB-KDF, impacted terrain during a go around near the Munster Airport (LSPU), near Munster, Switzerland. The pilot and two passengers sustained minor injuries and one passenger…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 CEN12WA268Accident · Minor injuriesForeign investigationRobinson · Wuppertal-Langerfeld, GermanyOn April 28, 2012, at 1650 coordinated universal time, a Robinson R44 helicopter, D-HARV, impacted terrain near Wuppertal-Langerfeld, Germany. The pilot and 3 passengers sustained minor injuries. Visual meteorological conditions prevailed for the flight. The…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…NTSB WPR10WA460Accident · 1 fatalForeign investigationCessna 188 · Geraldton Aerodrome, Australia, AustraliaOn September 14, 2010, at 0745 universal coordinated time, a Cessna 188 Agwagon, VH-KZF, collided with terrain during takeoff for an aerial application flight near Geraldton Aerodrome, Australia. The airplane was operated by Prestige Helicopters PTY LTD. The…NTSB ERA10WA430Accident · No injuriesForeign investigationPiper PA42 · Mercedes, ArgentinaOn June 13, 2010, about 1840 coordinated universal time (1540 local time), a Piper PA-42-1000, Argentine registration LQ-BLU, was substantially damaged when it overran the end of the runway and impacted a perimeter fence during a takeoff attempt from Mercedes…NTSB ERA09WA253Accident · 1 fatalForeign investigationCessna 208 · Canaima, VenezuelaNone.