NTSB investigations, 2019, Outside the U.S.
46 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 | 209 |
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\") = 2019
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") = 2019 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 CEN20WA045Accident · No injuriesForeign investigationCessna 208 · San Rafael, MexicoOn December 24, 2019, about 1529 coordinated universal time, a Cessna 208B airplane, XA-TWN, impacted desert terrain near San Rafael, Sonoroa, Mexico, while enroute to the Guerrero Negro Airport (MMGR), Baja California, Mexico. The two occupants sustained…NTSB WPR20WA044Accident · 2 fatalForeign investigationAngel 44 · Mareeba, AustraliaOn December 14, 2019, at 1115 local time, an Angel Aircraft Corporation 44 twin-engine airplane, registration VH-IAZ, collided with terrain near Mareeba Aerodrome, Mareeba Queensland, Australia. Both pilots were fatally injured, and the airplane was…NTSB ANC20WA009Accident · 3 fatalForeign investigationPiper PA60 · Nanaimo, CanadaThe government of Canada has notified the NTSB of an accident involving a Piper PA60 airplane that occurred on December 11, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Canada's investigation under the provisions…NTSB CEN20WA210Accident · 2 fatalForeign investigationPiper PA30 · Kaunas, LithuaniaThe government of Lithuania has notified the NTSB of an accident involving a PIPER PA30 airplane that occurred on December 08, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Lithuania's investigation under the…NTSB ANC20WA008Accident · 1 fatalForeign investigationRobinson R66 · Krasnodarsky Krai, RussiaThe government of Russia has notified the NTSB of an accident involving a ROBINSON R66 helicopter that occurred on November 30, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Russia's investigation under the…NTSB DCA20WA019Accident · 29 fatalForeign investigationDornier 228 · Gomo, Congo - KinshasaThe government of Congo has notified the NTSB of an accident involving a DORNIER 228 airplane that occurred on November 24, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Congo's investigation under the provisions of…NTSB GAA20WA047Accident · 1 fatalForeign investigationRobinson R44 · Tarasenkove, UkraineThe government of Ukraine has notified the NTSB of an accident involving a ROBINSON R44 helicopter that occurred on October 21, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Ukraine's investigation under the…NTSB WPR20WA006Accident · 1 fatalForeign investigationPiper PA-28-140 · Huhudi, South AfricaOn October 6, 2019, about 1547 coordinated universal time, a Piper PA28-140, ZS-EEZ, crashed near, Vryburg Airport, Huhudi, South Africa. The pilot was fatally injured, and the passenger sustained serious injuries. The extent of the airplane's damage is…NTSB ANC19WA056Accident · 1 fatalForeign investigationBell 206 · Campbell River, CanadaThe government of Canada has notified the NTSB of an accident involving a Bell 206 helicopter that occurred on September 24, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Canada's investigation under the provisions…NTSB WPR19WA272Accident · 9 fatalForeign investigationBeech B300 · Calamba, PhilippinesOn September 1, 2019 about 0541 universal coordinated time, a Beech B-300, RP-C2296, collided with terrain near Brgy. Pansol, Calamba, Laguna, Philippines. The two flight crew and seven passengers were fatally injured. Two persons on the ground received minor…NTSB CEN19WA296Accident · Serious injuriesForeign investigationRobinson R44 · Veracruz, MexicoOn August 26, 2019, about 1700 hours universal coordinated time, a Robinson R-44 II helicopter, Mexican registration XB-GIL, was substantially damaged during an emergency landing in a field near Veracruz, Mexico. Two occupants were seriously injured; one…NTSB CEN19WA286Accident · 2 fatalForeign investigationPitts S2 · Stonor Oxforshire, United KingdomThe government of United Kingdom has notified the NTSB of an accident involving a Pitts S2 airplane that occurred on August 24, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of United Kingdom's investigation under the…NTSB CEN19WA284Accident · 1 fatalForeign investigationReims F172 · Schneizlreuth, GermanyThe government of Germany has notified the NTSB of an accident involving a REIMS F172 airplane that occurred on August 22, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Germany's investigation under the provisions…NTSB CEN19WA282Accident · 1 fatalForeign investigationCessna 150 · Diepholz, GermanyOn August 22, 2019, at an 1120 UTC, a Cessna 150, D-EHLG, impacted with terrain in cornfield in Steinfeld, Germany. The pilot, the sole occupant, suffered fatal injuries and the airplane was destroyed. The flight had departed Flugplatz Diepholz-Dümmerland on…NTSB WPR19WA274Accident · 2 fatalForeign investigationCessna 172 · Pretoria, South AfricaOn August 16, 2019, at 1810 universal coordinated time, a Cessna 172M, ZS-LMI, collided with terrain near Pretoria, South Africa. Both occupants were fatally injured and the airplane was substantially damaged. The airplane was being operated under the…NTSB ERA19WA270Accident · 3 fatalClass 5 · ForeignEmbraer EMB710 · Itaituba, BrazilNTSB ANC19WA052Accident · 2 fatalForeign investigationCessna 208 · Mayo, CanadaThe government of Canada has notified the NTSB of an accident involving a CESSNA 208 airplane that occurred on August 06, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Canada's investigation under the provisions of…NTSB WPR19WA234Accident · 3 fatalForeign investigationRobinson R44 · Korotasere, Cakaudrove, FijiOn August 2, 2019, about 1830 local time, a Robinson R44 Helicopter, DQ-HPT, impacted the ocean about 4 nautical miles east of Korotasere, Cakaudrove, Fiji under unknown circumstances. The commercial pilot and two passengers are presumed to be fatally…NTSB CEN19WA301Accident · 2 fatalForeign investigationCessna TU206 · Guachochi, MexicoOn August 2, 2019, about 1600 universal coordinated time, a Cessna TU206G airplane, XB-FZN, impacted terrain near Guachochi, Mexico. The two people on board sustained fatal injuries. The accident investigation is under the jurisdiction and control of the…NTSB ANC19WA043Accident · 4 fatalForeign investigationCessna 208 · Bella Bella, CanadaOn July 26, 2019, about 1100 pacific daylight time, a Canadian registered Cessna 208 airplane, C-GURL, owned and operated by Seair Seaplanes Ltd., was destroyed when it collided with terrain in the vicinity of Addenbroke Island, British Columbia (BC), Canada,…NTSB WPR19WA199Accident · 1 fatalForeign investigationCessna 172 · Cangkring, IndonesiaOn July 22, 2019, about 0810 coordinated universal time, a Cessna 172 airplane, PK-WUG, impacted a river and sunk under unknown circumstances about 2.5 nautical miles northeast of Cangkring, Indonesia. One pilot was seriously injured, and the second was…NTSB ERA19WA236Accident · 2 fatalForeign investigationRobinson R66 · Gorgona Island, ItalyThe government of Italy has notified the NTSB of an accident involving a ROBINSON R66 helicopter that occurred on July 22, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Italy's investigation under the provisions of…NTSB ANC19WA041Accident · 2 fatalForeign investigationRobinson R22 · Moscow, RussiaOn July 14, 2019, at 1551 Moscow time, a Russian registered Robinson R-22M helicopter was destroyed after impacting terrain after takeoff from the Shevlino landing site, Moscow region, Russian Federation. The helicopter was privately owned and operated. The…NTSB WPR19WA211Accident · 1 fatalForeign investigationCessna 172 · Anji, ChinaOn July 10, 2019, at an unknown time, a Cessna 172S, B-10NH, was substantially damaged when it collided with the ground near Anji, Zhejiang, China. One person on board was fatally injured, one sustained serious injury, and one is being assessed. The airplane…NTSB CEN19WA337Accident · 2 fatalForeign investigationRobinson R44 · Mt Tremblank, CanadaThe government of Canada has notified the NTSB of an accident involving a Robinson R-44 helicopter, Canadian registration C-FJLH, that occurred on July 10, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Canada's…NTSB CEN19WA338Incident · No injuriesForeign investigationGulfstream Gulfstream GVI · Waterford, IrelandOn July 7, 2019, about 1645 coordinated universal time, a Gulfstream GVI airplane, EI-JSK, had an uncommanded engine shutdown in flight near Waterford, Ireland. The flight departed from and returned to Shannon Airport. The flight was destined for Farnborough…NTSB CEN19WA208Accident · 1 fatalForeign investigationPiper PA-24-250 · Quetzaltenango, GuatemalaThe government of Guatemala has notified the NTSB of an accident involving a PIPER PA-24-250 airplane that occurred on July 05, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Guatemala's investigation under the…NTSB CEN19WA197Accident · 2 fatalForeign investigationRans S6 · Rougemont, CanadaNTSB CEN19WA200Accident · 1 fatalForeign investigationPiper PA28 · Mandal, NorwayOn June 22, 2019, about 1255 local time, a Piper PA28-161, registration NL-MTJ, impacted the sea about 11 miles south of Mandal, Norway, following a loss of engine power. One person was fatally injured, and two passengers received minor injuries. The Accident…NTSB ANC19WA025Accident · No injuriesForeign investigationCirrus SR20 · Yeosu, South KoreaThe government of Korea has notified the NTSB of an accident involving a CIRRUS SR20 airplane that occurred on June 13, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Korea's investigation under the provisions of…NTSB CEN19WA273Accident · No injuriesForeign investigationAgustaWestland AW139 · Albarracín, SpainOn June 12, 2019, about 1330 local time, an AgustaWestland AW139 helicopter, EC-NEH, executed an emergency landing to an open field near Albarracín, Spain, for unknown reasons. The pilot and sole occupant sustained no injury, and the helicopter sustained…NTSB ANC19WA022Accident · 3 fatalForeign investigationGrumman AA-5B · Medicine Hat, CanadaOn June 2, 2019, at 0440 (UTC) time, a Canadian registered Grumman American Aviation, AA-5B airplane, C-GQIJ, operated by a private individual, was found after it had collided with terrain under unknown circumstances while conducting a VFR flight. A search…NTSB ERA19WA176Accident · 2 fatalForeign investigationBell 206 · La Vega, Dominican RepublicNTSB GAA19WA273Accident · No injuriesForeign investigationCirrus SR20 · Wilhelmshaven, Germany, GermanyThe government of Germany has notified the NTSB of an accident involving a CIRRUS SR20 airplane that occurred on May 19, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Germany's investigation under the provisions of…NTSB CEN19RA145Accident · 5 fatalForeign investigationPiper PA32 · Roatán, HondurasimportNTSB WPR19WA158Accident · 2 fatalForeign investigationJM Kemp RT13B · Mookgopong, South AfricaOn May 10, 2019, about 1105 Coordinated Universal time, a JM Kemp RT13B, South African registry ZU-FUO, was destroyed when it impacted a ridge north of the Mountain View Lodge Airport, near the town of Mookgopong, Limpopo Province, South Africa. The pilot and…NTSB ANC19WA023Accident · 3 fatalForeign investigationCessna 182 · Smithers, CanadaThe government of Canada has notified the NTSB of an accident involving a Cessna 182E airplane that occurred on May 04, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Canada's investigation under the provisions of…NTSB ENG19RA019Incident · No injuriesForeign investigationAvro 146 · Tambo International Airport, South AfricaThe South Africa Accident and Incident Investigation Division (AIID) has notified the United States, as the State of Design and Manufacture for the Engines, of an engine in-flight shut down incident involving a BAE Aero 146 RJ85A, ZS-SSJ, that occurred near…NTSB WPR19WA107Accident · 1 fatalForeign investigationCessna 182 · Wongabel, AustraliaOn April 8, 2019, about 0740 coordinated universal time a Cessna 182G airplane, VH-DJN, impacted terrain in the Wongabel State Forest, Wongabel, Queensland, Australia. The pilot in command was fatally injured, and the airplane was destroyed. The personal…NTSB DCA19RA101Accident · 157 fatalForeign investigationBoeing 737 · Addis Ababa, EthiopiaThe government of Ethiopia has notified the NTSB of an accident involving a BOEING 737 that occurred on March 10, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Ethiopia's investigation under the provisions of ICAO…NTSB WPR19WA164Accident · 5 fatalForeign investigationBell 505X · Londiani, Kericho, KenyaOn March 3, 2019, about 0834 local time, a Bell 505X, 5Y-KDL, collided with terrain near Londiani, Kericho, Kenya. The 1 pilot and 4 passengers were fatally injured; the helicopter was destroyed. The helicopter was owned and operated by KWAE Island…NTSB ERA19WA108Accident · 1 fatalForeign investigationCessna U206 · Eteringbang, GuyanaThe government of Guyana has notified the NTSB of an accident involving a CESSNA U206 airplane that occurred on February 21, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Guyana's investigation under the provisions…NTSB CEN19WA083Accident · 2 fatalForeign investigationRobinson R44 · Roeldal, NorwayThe government of Norway has notified the NTSB of an accident involving a ROBINSON R44 helicopter that occurred on February 17, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Norway's investigation under the…NTSB WPR19WA271Accident · 5 fatalForeign investigationCessna U206G · Londiani, KenyaOn February 13, 2019, at 0729 universal coordinated time a Cessna U206G, 5Y-BSE, crashed into terrain, following a distress signal from the airplane near Londiani, Kericho County, Kenya. The pilot and four passengers were fatally injured. The airplane was…NTSB ERA19WA090Accident · 1 fatalForeign investigationPiper PA25 · Jaguaré County, BrazilThe government of Brazil has notified the NTSB of an accident involving a PIPER PA-25-235 airplane that occurred on January 21, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the…NTSB DCA19WA054Incident · No injuriesForeign investigationMcdonnell Douglas MD11 · Dubai, United Arab EmiratesThe General Civil Aviation Authority (GCAA) of The United Arab Emirates has notified the NTSB of an accident involving a MCDONNELL DOUGLAS MD11 that occurred on January 20, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the GCAA's…