NTSB investigations, 2018, Outside the U.S.
79 cases where the sequence of events included Unknown or undetermined.
Cases per year
| 2008 | 9 |
|---|---|
| 2009 | 9 |
| 2010 | 20 |
| 2011 | 19 |
| 2012 | 16 |
| 2013 | 26 |
| 2014 | 40 |
| 2015 | 60 |
| 2016 | 78 |
| 2017 | 69 |
| 2018 | 79 |
| 2019 | 46 |
| 2020 | 50 |
| 2021 | 49 |
| 2022 | 50 |
| 2023 | 55 |
| 2024 | 59 |
| 2025 | 70 |
| 2026 | 207 |
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\") = 2018
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\" = '000' 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") = 2018 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" = '000' 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 ANC19WA013Accident · 4 fatalForeign investigationAgusta A119 · Ulan-Ude, RussiaOn December 30, 2018, about 0230 universal time, an Agusta A119 helicopter, RA-01908, impacted terrain under unknown circumstances about 12 miles from Ulan-Ude, Buryatia, Russia. The pilot and three passenger sustained fatal injuries. The Interstate Aviation…NTSB ERA19WA089Accident · No injuriesForeign investigationEmbraer EMB720 · Almeirim, BrazilThe government of Brazil has notified the NTSB of an accident involving a Embraer EMB720 airplane that occurred on December 02, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the…NTSB ERA19WA087Accident · 2 fatalForeign investigationCessna 210 · São Paulo, BrazilThe government of Brazil has notified the NTSB of an accident involving a Cessna 210 airplane that occurred on November 30, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions…NTSB WPR19WA033Accident · Serious injuriesForeign investigationCessna U206 · Machadodorp, South AfricaOn November 29, 2018, about 1606 universal coordinated time, a Cessna U206D airplane, South African registration ZS-DIV, impacted terrain near the Skoonman Kloff in the Machadodorp area in Mpumalanga Province, South Africa. The pilot and 4 passengers were…NTSB WPR19WA032Accident · 1 fatalForeign investigationRobinson R22 · Alice Springs, AustraliaOn November 24, 2018, at 1200 local time, a Robinson R22 BETA, VH-KZV, collided with terrain near Alice Springs, NT, Australia. The helicopter sustained substantial damage. The pilot sustained serious injuries and the passenger was fatally injured. The flight…NTSB WPR19WA081Accident · 5 fatalForeign investigationCessna U206 · Chemajenjera Hill, ZimbabweOn November 23, 2018, about 0530 coordinated universal time, a Cessna U206C airplane, Z-BRS, was destroyed when it impacted terrain near Chemajenjera Hill, Zimbabwe. The pilot and four passengers were fatally injured. The airplane was operated under the…NTSB ERA19WA054Accident · 5 fatalForeign investigationEurocopter EC120 · La Romana, Dominican RepublicThe government of Dominican Republic has notified the NTSB of an accident involving a Eurocopter EC120 helicopter that occurred on November 22, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Dominican Republic's…NTSB ERA19WA053Accident · 2 fatalClass 5 · ForeignCessna TU206 · Puente Alto, ChileNTSB ERA19WA075Accident · 2 fatalForeign investigationCessna 172 · Denizli, TürkiyeThe government of Turkey has notified the NTSB of an accident involving a CESSNA 172 airplane that occurred on November 19, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Turkey's investigation under the provisions…NTSB CEN19WA027Accident · 2 fatalForeign investigationVans (EX) RV-6 · Meraaker, NorwayOn November 7, 2018, about 1410 hours central European standard time, a Vans RV-6 airplane, Norwegian registration LN-AAL, impacted terrain under unknown circumstances near Meråker, Norway. The pilot and passenger were fatally injured. The flight departed…NTSB ERA19WA288Accident · No injuriesForeign investigationEmbraer EMB-202 · Miranda, BrazilThe government of Brazil has notified the NTSB of an accident involving a Embraer EMB-202 airplane that occurred on October 30, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the…NTSB ERA19WA076Accident · 2 fatalForeign investigationCessna 150 · Manavgat, TürkiyeThe government of Turkey has notified the NTSB of an accident involving a CESSNA 150 airplane that occurred on October 30, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Turkey's investigation under the provisions of…NTSB DCA19RA017Accident · 191 fatalForeign investigationBoeing 737 · Jakarta, IndonesiaimportNTSB WPR19WA012Accident · 3 fatalClass 5 · ForeignHughes 369 · Wanaka, New ZealandNTSB CEN19WA011Accident · 2 fatalForeign investigationCessna F172 · East Yorkshire, United KingdomOn November 10, 2018, about 1930 hours universal coordinated time, a Reims Cessna F172N, United Kingdom registration G-BGSV, impacted a field near East Yorkshire, United Kingdom. The two occupants on-board were fatally injured. The flight origin and…NTSB WPR19WA004Accident · 2 fatalForeign investigationCessna 172 · Midrand, South AfricaOn October 8, 2018, at 0920 coordinated universal time, a Cessna 172L airplane, registration ZS-PZT, sustained substantial damage after colliding with the ground during the landing approach at Grand Central Airport, Midrand, South Africa. The pilot and one…NTSB ERA19WA038Accident · 2 fatalForeign investigationSiai Marchetti SF260 · Caorle, ItalyThe government of Italy has notified the NTSB of an accident involving a Siai Marchetti SF260 airplane that occurred on October 03, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Italy's investigation under the…NTSB DCA18RA292Accident · 1 fatalForeign investigationBoeing 737 · Chuuk, MicronesiaThe government of Federated States Of Micronesia (FSM) has notified the NTSB of an accident involving a BOEING 737 that occurred on September 28, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the FSM's investigation under the…NTSB ANC18WA078Accident · 1 fatalForeign investigationCessna 208 · Narita, JapanOn September 27, 2018, at 0626 universal coordinated time, a Cessna 208B airplane, VH-FAY, disappeared from radar during cruise flight over international waters, about 185Km northeast of Narita International Airport. Parts from the destroyed airplane were…NTSB CEN18WA388Accident · 3 fatalForeign investigationCessna 210 · Pico de Orizaba, MexicoOn September 21, 2018, about 1440 hours universal coordinated time, a Cessna T210L single-engine airplane, serial number 21060532, Mexican registration XB-NVG, impacted terrain on mount Pico de Orizaba near Veracruz and Puebla, Mexico. The three occupants…NTSB WPR18WA258Accident · 1 fatalForeign investigationYakovlev YAK-9UM · Victoria, AustraliaOn September 7, 2018, about 1933 coordinated universal time a Yakovlev Aircraft YAK-9UM airplane, VH-YIX, impacted terrain during a local flight that departed from the Latrobe Valley Airport, Victoria, Australia. The pilot in command was fatally injured, and…NTSB ERA18WA245Accident · 1 fatalForeign investigationBell 430 · Bostanci, TürkiyeThe government of Turkey has notified the NTSB of an accident involving a Bell 430 that occurred on September 06, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Turkey's investigation under the provisions of ICAO…NTSB WPR18WA254Accident · Serious injuriesForeign investigationCessna 182M · Leshiba Wilderness, South AfricaOn September 1, 2018, at 1247 universal coordinated time, a Cessna 182M, ZS-IAM, collided with trees while on final approach to land at Leshiba Wilderness, South Africa. The pilot and passenger were seriously injured. The airplane was substantially damaged.…NTSB CEN18WA367Accident · 1 fatalForeign investigationCessna 310 · Villa Zaragoza, MexicoThe government of Mexico has notified the NTSB of an accident involving a Cessna 310, XB-KQF that occurred on August 28, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions of…NTSB CEN18WA353Accident · 1 fatalForeign investigationPiper PA34 · Loma Linda, Costa RicaNTSB ERA18WA223Accident · 2 fatalForeign investigationStemme S12 · Santo Domingo Norte, Dominican RepublicThe government of Dominican Republic has notified the NTSB of an accident involving a STEMME S12 glider that occurred on August 19, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Dominican Republic's investigation…NTSB WPR18WA230Accident · 1 fatalForeign investigationKawasaki Heavy Industries BK117 B-2 · Ulladulla, AustraliaOn August 17, 2018, about 1400 local time, a Kawasaki Heavy Industries Ltd. BK117 B-2 helicopter, VH-JWB, was destroyed when it impacted terrain during aerial firefighting operations near Ulladulla, New South Wales, Australia. The helicopter was operated by…NTSB ANC18WA074Accident · 1 fatalForeign investigationCessna 172 · Edson, CanadaOn August 12, 2018, about 1645 Coordinated Universal Time, a Cessna 172 airplane, C-FJCP, impacted terrain near Edson, Alberta, Canada, under unknown circumstances. The pilot sustained fatal injuries.The Transportation Safety Board (TSB) of Canada is…NTSB ANC18WA065Accident · 9 fatalForeign investigationBell 412EP · Nakanojo, JapanThe government of Japan has notified the NTSB of an accident involving a BELL 412EP helicopter that occurred on August 10, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Japan's investigation under the provisions of…NTSB CEN18WA325Accident · 2 fatalForeign investigationBeech 58 · Munster, GermanyOn August 9, 2018, about 1000 UTC, a Beechcraft Baron 58 airplane, Hungarian registration PH-CJX, impacted terrain under unknown circumstances near Münster, Germany. The two occupants inside the airplane sustained fatal injuries. The airplane sustained…NTSB CEN18WA318Accident · 3 fatalForeign investigationCessna 172 · Puy-de-Dome Mazoires, FranceOn August 6, 2018, about 1045 coordinated universal time, a Cessna 172S airplane, French registration F-GTNV, lost radio and radar contact; the wreckage was located near Puy-de-Dôme Mazoires, France. The airplane was destroyed, and the three occupants…NTSB ANC18WA062Accident · 2 fatalForeign investigationCessna 180 · Gold Bridge, CanadaOn August 1, 2018, about 1245 Pacific daylight time, a Canadian registered float-equipped Cessna 180, C-FCDQ, operated by Fort Langley Air Ltd., was substantially damaged after impacting the surface of Lake Tyaughton, British Columbia, shortly after takeoff.…NTSB ANC18WA061Accident · 2 fatalForeign investigationPiper PA-31 · Calgary, CanadaOn August 1, 2018, at 1336 mountain daylight time, a Canadian registered Piper PA-31, C-FNCI, operated by Aries Aviation Services Corp., was substantially damaged after impacting terrain under unknown circumstances 35 miles southwest of Calgary, Canada. The…NTSB ERA18WA218Accident · 3 fatalForeign investigationPiper PA34 · Irineopolis, BrazilThe government of Brazil has notified the NTSB of an accident involving a Piper PA-34-220T that occurred on July 22, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions of ICAO…NTSB ERA18WA196Accident · 2 fatalForeign investigationPiper PA28R · Santiago, ChileThe government of Chile has notified the NTSB of an accident involving a PIPER PA28R airplane that occurred on July 14, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Chile's investigation under the provisions of…NTSB CEN18WA320Accident · 1 fatalForeign investigationChampion 8KCAB · Toronto, CanadaOn July 12, 2018, at 2359 universal coordinated time, a Bellanca 8KCAB, Canadian registration C-GDLP, declared an emergency and impacted terrain shortly after takeoff from the Toronto/Buttonville Airport (CYKZ), Ontario, Canada. The pilot was fatally injured.…NTSB CEN18WA268Accident · 2 fatalForeign investigationRobinson R44 · Domecko, PolandOn July 11, 2018, at 0736 coordinated universal time (UTC), a Robinson Helicopter R-44 II helicopter, SP-MAP, impacted terrain near Opole, Poland. 2 occupants were fatally injured, and 1 occupant was seriously injured.The investigation is under the…NTSB WPR18WA185Accident · 5 fatalForeign investigationBeech C90 · Mumbai, IndiaOn June 28, 2018, at 0740 Universal Coordinated Time, a King Air C90 airplane, VT-UPZ, was destroyed when it impacted the ground near Mumbai, India. The airplane was operated under the pertinent regulations of the Government of India. The two pilots, two…NTSB ERA18WA272Accident · 1 fatalForeign investigationCessna 172 · Adiyaman, TürkiyeThe government of Turkey has notified the NTSB of an accident involving a CESSNA 172 airplane that occurred on June 27, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Turkey's investigation under the provisions of…NTSB WPR18WA202Accident · Serious injuriesForeign investigationZlin Z242L · Hong Kong, ChinaOn June 24, 2018, at 1638 local time, a Zlin Z 242 L airplane, B-LUK, was substantially damaged when it collided with the ground near Ma Shi Chau, Hong Kong, China. The private pilot was seriously injured. The airplane was operated in accordance with the…NTSB WPR18WA180Accident · 5 fatalForeign investigationPiper PA31 · Antananarivo, MadagascarOn June 18, 2018, about 0615 local time, a Piper PA-31 airplane, 5R-MKF, impacted terrain about 5 nautical miles from the Ivato International Airport, Antananarivo, Madagascar. The pilot in command, two pilot observers, pilot monitor, and one passenger were…NTSB WPR18WA169Accident · Serious injuriesForeign investigationMD Helicopter 600 · Waiouru, New ZealandOn June 13, 2018, at 2048 Universal Coordinated time, an MD 600N helicopter, ZK-ILD crashed in a remote area for unknown reasons near Waiouru, New Zealand. The pilot and four passengers were seriously injured. The helicopter was substantially damaged. The…NTSB CEN18WA231Accident · 1 fatalForeign investigationAir Tractor AT802 · Mallorca, SpainOn June 12, 2018, about 1600 hours universal coordinated time, an Air Tractor AT-802 airplane, Spanish registration EC-GVN, was substantially damaged during an agricultural application flight near Mallorca, Spain. The pilot sustained fatal injuries. The local…NTSB CEN18WA355Accident · Minor injuriesForeign investigationCessna R172 · Aude Fraisse-Cabardes, FranceThe government of France has notified the NTSB of an accident involving a Cessna R172 airplane that occurred on June 10, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of France's investigation under the provisions of…NTSB WPR18WA187Accident · 1 fatalForeign investigationCessna 172 · Moorabbin, AustraliaNTSB CEN18WA203Accident · 1 fatalForeign investigationPiper PA25 · Bosschenhoofd, NetherlandsOn May 31, 2018, a Piper PA-25-135 airplane (SE-KHF), crashed while attempting to pick up a banner near Bosschenhoofd, Netherlands. The pilot, who was the sole occupant, was fatally injured. This investigation is under the jurisdiction and control of the…NTSB CEN18WA202Accident · 1 fatalForeign investigationBell Helicopter Textron Bell 206B · North Aldborough, United KingdomOn May 30, 2018, about 1225 coordinated universal time (UTC), a Bell 206B helicopter, registration G-OPEN, s/n 4300, impacted terrain and was destroyed near North Aldborough, North Yorkshire in the United Kingdom. The pilot was the sole occupant and was…NTSB CEN18WA190Accident · 2 fatalForeign investigationReims F172N · Stolwijk, NetherlandsOn May 22, 2018, about 0930 UTC, a Reims Aviation, F172N airplane, PH-SBM, was destroyed when it impacted trees and terrain near Stolwijk, The Netherlands. The two pilots on board the airplane were fatally injured. The foreign, local personal flight departed…NTSB DCA18RA186Accident · 112 fatalForeign investigationBoeing 737 · Havana, CubaThe government of Cuba has notified the NTSB of an accident involving a Boeing 737-200 that occurred on May 18, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Cuba's investigation under the provisions of ICAO Annex…NTSB ENG18WA034Accident · No injuriesForeign investigationSikorsky S76 · Valle Nuevo, Dominican Republic