NTSB investigations, Outside the U.S.
79 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 | 8 |
| 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 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 GAA26WA101Accident · 3 fatalClass 5 · ForeignCessna 210 · Goolwa, AustraliaNTSB GAA25WA248Accident · 1 fatalClass 5 · ForeignQuicksilver MX II · Phuket, ThailandNTSB GAA25WA170Accident · No injuriesClass 5 · ForeignPiper PA 46-350P · Kilkeel, United KingdomNTSB DCA25WA046Accident · 1 fatalClass 3 · ForeignBoeing 737 · Vilnius, LithuaniaNTSB DCA25WA032IncidentClass 5 · ForeignBoeing 727 · Bogotá, ColombiaNTSB GAA24WA246Accident · 1 fatalClass 5 · ForeignZodiac CH601XL · Tambon Khok Kham, ThailandNTSB GAA24WA184Accident · No injuriesClass 5 · ForeignCessna 172 · Kagoshima, JapanNTSB GAA24WA203IncidentClass 5 · ForeignCessna 210 · Bankstown, AustraliaNTSB GAA24WA078AccidentClass 5 · ForeignPiper 28 · Spa, BelgiumNTSB DCA24WA080Incident · No injuriesClass 5 · ForeignPilatus PC-12/45 · Gustavia, St. BarthélemyNTSB GAA24WA069Accident · 2 fatalClass 5 · ForeignRobinson R22 · Cannes Mandelieu, FranceNTSB GAA24WA026Accident · No injuriesClass 5 · ForeignAerospatiale SA341G Gazelle · Spalding, United KingdomNTSB GAA24WA306Accident · No injuriesClass 5 · ForeignRaytheon Hawker · Ibadan, NigeriaNTSB GAA23WA271Accident · 1 fatalClass 5 · ForeignRobinson R44 · Garmen village, BulgariaNTSB GAA23WA256Accident · Serious injuriesClass 5 · ForeignLearjet 45XR · Mumbai, IndiaNTSB GAA23WA224Accident · No injuriesClass 5 · ForeignPiper 25 · Caboolture, AustraliaNTSB GAA23WA189AccidentClass 5 · ForeignCygnet sea & Sky · Açores, PortugalNTSB GAA23WA188Accident · 2 fatalClass 5 · ForeignCessna 206 · Gracias A Dios, HondurasNTSB GAA23WA157Accident · No injuriesClass 5 · ForeignPiper PA46-500TP · Saint-Tropez, 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 DCA22WA073IncidentClass 5 · ForeignBoeing 2X6C · Puerto Carreno, ColombiaNTSB GAA21WA198Accident · No injuriesClass 5 · ForeignCessna 182 · Tannheim, GermanyNTSB GAA21WA184Accident · No injuriesClass 5 · ForeignCessna 172 · Almoguera, SpainNTSB 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 ERA20CA191Accident · Minor injuriesClass 4 · Data collectionFinal reportBell UH 1N · Baghdad, IraqThe flight crew's inadequate situational awareness and failure to maintain adequate clearance from a security barrier during a night takeoff.NTSB 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 DCA20WA022Incident · No injuriesForeign investigationBoeing 737 · Lyon, FranceThe government of France has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on November 14, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of France'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 GAA19WA583Accident · No injuriesForeign investigationCessna 560 · Aarhus airport, DenmarkThe government of Denmark has notified the NTSB of an accident involving a CESSNA 560 airplane that occurred on August 05, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Denmark's investigation under the provisions…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 WPR18LA092Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Obyan, SarkThe pilot's inadequate preflight fuel planning and inadequate in-flight fuel monitoring which resulted in a total loss of engine power due to fuel exhaustion and an emergency landing and subsequent impact with a ditch.NTSB ERA18WA261Accident · Serious injuriesForeign investigationSkyrunner MK 3.2 · Margham, Dubai, United Arab EmiratesThe government of the United Arab Emirates has notified the NTSB of an accident involving a SkyRunner, MK-3.2 Powered Parachute that occurred on February 09, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of United Arab…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…