NTSB investigations, 2019, Outside the U.S.
180,604 investigations by the National Transportation Safety Board since 1962: 174,583 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
Cases per year
| 1962 | 9 |
|---|---|
| 1963 | 3 |
| 1964 | 108 |
| 1965 | 99 |
| 1966 | 106 |
| 1967 | 101 |
| 1968 | 64 |
| 1969 | 63 |
| 1970 | 70 |
| 1971 | 56 |
| 1972 | 79 |
| 1973 | 66 |
| 1974 | 65 |
| 1975 | 58 |
| 1976 | 16 |
| 1977 | 24 |
| 1978 | 36 |
| 1979 | 14 |
| 1980 | 5 |
| 1981 | 2 |
| 1982 | 5 |
| 1983 | 3 |
| 1984 | 7 |
| 1985 | 6 |
| 1986 | 8 |
| 1987 | 22 |
| 1988 | 41 |
| 1989 | 25 |
| 1990 | 30 |
| 1991 | 29 |
| 1992 | 36 |
| 1993 | 41 |
| 1994 | 42 |
| 1995 | 66 |
| 1996 | 61 |
| 1997 | 93 |
| 1998 | 134 |
| 1999 | 110 |
| 2000 | 159 |
| 2001 | 152 |
| 2002 | 134 |
| 2003 | 136 |
| 2004 | 154 |
| 2005 | 174 |
| 2006 | 181 |
| 2007 | 174 |
| 2008 | 174 |
| 2009 | 181 |
| 2010 | 227 |
| 2011 | 238 |
| 2012 | 259 |
| 2013 | 248 |
| 2014 | 219 |
| 2015 | 268 |
| 2016 | 319 |
| 2017 | 304 |
| 2018 | 337 |
| 2019 | 323 |
| 2020 | 257 |
| 2021 | 428 |
| 2022 | 429 |
| 2023 | 460 |
| 2024 | 492 |
| 2025 | 475 |
| 2026 | 393 |
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'
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' 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 ERA20WA061Accident · 3 fatalForeign investigationPiper PA-32-301T · Vereda Cuzama, ColombiaThe government of Colombia has notified the NTSB of an accident involving a PIPER PA-32-301T airplane that occurred on December 30, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Colombia's investigation under the…NTSB CEN20WA061Accident · No injuriesForeign investigationRobinson R44 · Wijnendaele, BelgiumThe government of Belgium has notified the NTSB of an accident involving a Robinson R44 helicopter that occurred on December 29, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Belgium's investigation under the…NTSB ERA20WA067Accident · No injuriesForeign investigationCessna 560 · Cmte Nicanor Otamendi, ArgentinaThe government of Argentina has notified the NTSB of an accident involving a CESSNA 560XLS airplane that occurred on December 28, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Argentina's investigation under the…NTSB CEN20WA126Accident · No injuriesForeign investigationCessna 152 · San Salvador, El SalvadorOn December 27, 2019, about 0730 local time, a Cessna 152 airplane, YS-162PE, impacted terrain near San Salvador, El Salvador, and was destroyed. The two occupants were not injured. The accident investigation is under the jurisdiction and control of the…NTSB GAA20WA101Accident · 1 fatalForeign investigationPiper PA25 · Rio Branco, Cerro Largo, UruguayThe government of Uruguay has notified the NTSB of an accident involving a PIPER PA25 airplane that occurred on December 24, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Uruguay's investigation under the provisions…NTSB DCA20WA044Incident · No injuriesForeign investigationBoeing 737 · Manchester, United KingdomThe AAIB of the United Kingdom has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on December 24, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB's investigation under the provisions of ICAO…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 ENG20WA019Incident · No injuriesClass 5 · ForeignEmbraer ERJ190 · New Chitose Airport (RJCC), JapanNTSB ENG20WA011Incident · No injuriesForeign investigationAirbus A320 · Guwahati, IndiaThe government of India has notified the NTSB of an incident involving an Airbus A320 airplane that occurred on December 23, 2019. A GoAir Airbus A320-271N Neo powered by two Pratt & Whitney PW1127G-JM geared turbofan engines experienced an inflight shutdown…NTSB ENG20WA009Incident · No injuriesForeign investigationAirbus A320 · Mumbai, IndiaThe government of India has notified the NTSB of an incident involving an Airbus A320 airplane that occurred on December 22, 2019. A GoAir Airbus A320-271N Neo powered by two Pratt & Whitney PW1127G-JM geared turbofan engines experienced high engine…NTSB GAA20WA104Accident · 2 fatalForeign investigationCirrus SR22 · Salzburg, Austria, AustriaThe government of Austria has notified the NTSB of an accident involving a CIRRUS SR22 airplane that occurred on December 21, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Austria's investigation under the…NTSB ERA20WA066Accident · 9 fatalClass 3 · ForeignBeech A100 · Charallave, VenezuelaNTSB ENG20WA035Accident · Serious injuriesForeign investigationCessna P210 · Moruya, AustraliaNTSB CEN20WA056Incident · No injuriesForeign investigationLearjet 45 · Geneva, SwitzerlandThe government of Switzerland has notified the NTSB of an incident involving a LEARJET 45 airplane that occurred on December 18, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Switzerland's investigation under the…NTSB DCA20WA039Incident · No injuriesForeign investigationBoeing 767 · Shannon, IrelandThe government of Ireland has notified the NTSB of an incident involving a Boeing 767 airplane that occurred on December 16, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Ireland's investigation under the provisions…NTSB ANC20CA014Accident · No injuriesData collectionFinal reportCessna 172 · Tokyo, JapanThe airplane’s encounter with prop wash while taxiing behind a larger airplane that was conducting a high-power engine run on the same taxiway. Contributing to the accident was the air traffic controller’s failure to inform the smaller airplane’s pilot about…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 GAA20WA103Accident · 1 fatalForeign investigationCessna 150 · Region del Bio Bio, ChileThe government of Chile has notified the NTSB of an accident involving a CESSNA 150 airplane that occurred on December 13, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Chile's investigation under the provisions of…NTSB GAA19WA598Accident · Serious injuriesClass 5 · ForeignAerospatiale AS350 · Kitzbühel, AustriaNTSB DCA20WA041Incident · No injuriesForeign investigationBoeing 747 · Auckland, New ZealandThe Transport Safety Investigation Bureau (TSIB) of Singapore has informed the NTSB of an incident involving a Boeing 747-400, which occurred on December 10, 2019. The NTSB has appointed a U.S Accredited Representative to assist the TSIB investigation under…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 WPR20WA081Accident · Minor injuriesForeign investigationOas UH-1H · Williamtown Aerodrome, AustraliaThe government of Australia has notified the NTSB of an accident involving a OAS UH-1H helicopter that occurred on December 07, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's investigation under the…NTSB GAA20WA108Incident · No injuriesForeign investigationDe Havilland DHC6 · Pau Pyrenesse, FranceThe government of France has notified the NTSB of an accident involving a DE HAVILLAND DHC6 airplane that occurred on December 06, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of France's investigation under the…NTSB DCA20WA152IncidentClass 5 · ForeignBoeing 737 · Paris, FranceNTSB WPR20WA037Accident · 1 fatalForeign investigationRobinson R44 · Eschowe, South AfricaThe government of South Africa has notified the NTSB of an accident involving a ROBINSON R44 helicopter that occurred on December 5, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of South Africa's investigation under…NTSB WPR20WA251Incident · No injuriesForeign investigationDe Havilland DHC8 · Eaton, AustraliaThe government of Australia has notified the NTSB of an accident involving a De Havilland DHC8 airplane that occurred on December 03, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's investigation under the…NTSB GAA20WA102Accident · 1 fatalForeign investigationBeech C90 · Caieiras, SP, BrazilThe government of Brazil has notified the NTSB of an accident involving a BEECH C90 airplane that occurred on December 02, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions of…NTSB GAA20WA099Accident · No injuriesForeign investigationPiper PA23 · Shannon, IrelandThe government of Ireland has notified the NTSB of an accident involving a PIPER PA23 airplane that occurred on December 02, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Ireland's investigation under the provisions…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 DCA20WA031Incident · No injuriesForeign investigationBoeing 747 · Sydney, AustraliaThe government of Australia has notified the NTSB of an accident involving a BOEING 747 airplane that occurred on November 28, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's investigation under the…NTSB CEN20WA024Accident · 7 fatalForeign investigationPiper PA32 · Kingston, CanadaNTSB GAA20WA097Accident · 1 fatalForeign investigationCessna 172 · Near Puffin Island, Anglesey, United KingdomThe government of United Kingdom has notified the NTSB of an accident involving a CESSNA 172 airplane that occurred on November 25, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of United Kingdom's investigation under…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 DCA20WA018Accident · No injuriesForeign investigationBoeing 737 · Bogota, ColombiaThe government of Colombia has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on November 23, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Colombia's investigation under the…NTSB DCA20WA025Incident · No injuriesForeign investigationBoeing 787 · Pettirossi, ParaguayThe government of Paraguay has notified the NTSB of an incident involving a BOEING 787 airplane that occurred on November 22, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Paraguay's investigation under the…NTSB DCA20WA030Incident · No injuriesForeign investigationBoeing 737 · Odesa, UkraineThe government of Ukraine has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on November 21, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Ukraine's investigation under the provisions…NTSB GAA20WA100Accident · 4 fatalClass 4 · ForeignBeech V35 · Cascavel, BrazilNTSB GAA20WA098Accident · 1 fatalForeign investigationCessna 172 · Los Andes/San Raphael, ChileThe government of Chile has notified the NTSB of an accident involving a CESSNA 172 airplane that occurred on November 17, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Chile's investigation under the provisions of…NTSB CEN20WA080Accident · No injuriesForeign investigationBeech 95-B55 · Malmo, SwedenThe government of Sweden has notified the NTSB of an accident involving a Beech 95-B55 airplane that occurred on November 17, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Sweden's investigation under the provisions…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 DCA20WA016Incident · No injuriesForeign investigationBoeing 747 · Leipzig, GermanyThe government of Germany has notified the NTSB of an incident involving a BOEING 747 airplane that occurred on November 14, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Germany's investigation under the provisions…NTSB WPR20WA021Accident · 1 fatalForeign investigationRobinson R44 · Tunis, TunisiaThe government of Tunisia has notified the NTSB of an accident involving a ROBINSON R44 helicopter that occurred on November 11, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Tunisia's investigation under the…NTSB DCA20WA017Accident · Serious injuriesForeign investigationBoeing 747 · Ataturk, TürkiyeThe Transport Safety Investigation Center (TSIC) of Turkey has notified the NTSB of an accident involving a Boeing 747-400, which occurred on November 11, 2019. The NTSB has appointed a U.S Accredited Representative to assist under the provisions of ICAO…NTSB GAA20WA123Incident · No injuriesForeign investigationBombardier CL600 2B19 · Madrid, SpainThe government of Spain has notified the NTSB of an accident involving a BOMBARDIER CL600 2B19 airplane that occurred on November 10, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Spain's investigation under the…NTSB ENG20WA008Incident · No injuriesForeign investigationAirbus A321 · Raipur, IndiaThe AAIB of India has notified the NTSB of an incident involving an Airbus A321 airplane with CFMI CFM56-5 engines that occurred on November 8, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB's investigation under the…NTSB WPR20WA020Incident · No injuriesForeign investigationCessna 172 · Vereeniging, South AfricaOn November 6, 2019, about 1740 coordinated universal time, a Cessna 172L, South African registration ZS-DAC, was enroute to the VOR beacon GAV, near Vereeniging, and reported a loss of engine power. The pilot forced landed the airplane in a field. The pilot…NTSB ENG20WA049Occurrence · No injuriesClass 5 · ForeignBoeing 737 · Owerri, NigeriaNTSB CEN20WA065Accident · No injuriesForeign investigationLearjet 35 · Cabo San Lucas, MexicoOn November 5, 2019, at 1942 Mexican pacific standard time, a Learjet 35A airplane, Mexican registration XA-VBD, experienced a runway excursion after landing at Cabo San Lucas International Airport, Cabo San Lucas, Mexico. The four occupants sustained no…