NTSB investigations, Outside the U.S.
180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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, 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' 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' 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 GAA20WA140Accident · No injuriesForeign investigationMudry CAP10 · BAN Lanveoc-Poulmic, FranceThe government of France has notified the NTSB of an accident involving a MUDRY CAP10 airplane that occurred on May 04, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of France's investigation under the provisions of…NTSB ERA20WA167Accident · 2 fatalForeign investigationGrumman AA5 · Dnipropetrovsk, UkraineThe government of Ukraine has notified the NTSB of an accident involving a GRUMMAN AA5 airplane that occurred on May 01, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Ukraine's investigation under the provisions of…NTSB ANC20WA072Accident · 2 fatalForeign investigationSikorsky S76 · Cheonwangbong, South KoreaThe government of Korea, Republic Of has notified the NTSB of an accident involving a SIKORSKY S76 helicopter that occurred on May 01, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Korea, Republic Of's investigation…NTSB CEN20WA200Accident · 1 fatalForeign investigationPiper PA 25-235 · Angostura, MexicoNTSB ERA20WA174Accident · 2 fatalForeign investigationVans RV7 · Toledo, BrazilThe government of Brazil has notified the NTSB of an accident involving an amateur-built VANS RV7 airplane that occurred on April 23, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the…NTSB ERA20WA154Accident · 1 fatalForeign investigationGarlick UH1H · del Curepto, ChileThe government of Chile has notified the NTSB of an accident involving a GARLICK UH1H helicopter that occurred on April 20, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Chile's investigation under the provisions of…NTSB DCA20LA100Accident · Serious injuriesClass 3 · LimitedFinal reportSikorsky S61 · Camp Dwyer, AfghanistanFatigue cracking of the auxiliary servo cylinder’s pedal damper check valve housing and its bolts, which caused the sudden and uncommanded movement of the helicopter’s left pedal and a subsequent left yaw that continued until ground impact. Contributing to…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 ERA20WA172Accident · 1 fatalForeign investigationComp Air CA-8 · Campo Verde, BrazilThe government of Brazil has notified the NTSB of an accident involving an amateur-built COMP AIR CA-8 airplane that occurred on April 13, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under…NTSB DCA20WA110Accident · Serious injuriesForeign investigationBoeing 737 · Matsuyama, JapanThe JTSB of Japan has notified the NTSB of an accident involving a Boeing 737 airplane that occurred on April 12, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the JTSB's investigation under the provisions of ICAO Annex 13.All…NTSB CEN21WA076Accident · Serious injuriesClass 5 · ForeignCessna T303 · Annecy Meythetf, FranceNTSB CEN20WA157Incident · No injuriesForeign investigationCessna 650 · Ciudad Juarez, MexicoOn April 7, 2020, about 1640 hours universal coordinated time, a Cessna 650 airplane, Mexican registration XA-SDU, was involved in an incident at the Abraham González International Airport (MMCS), located in Ciudad Juárez, Chihuahua, Mexico, The NTSB has…NTSB CEN20WA183Accident · No injuriesForeign investigationSocata TB9 · Nyköping, SwedenThe government of Sweden has notified the NTSB of an accident involving a SOCATA TB9 airplane that occurred on April 06, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Sweden's investigation under the provisions of…NTSB WPR20WA317Accident · No injuriesClass 5 · ForeignRobinson R44 · Mareeba Aerodrome, AustraliaNTSB CEN20WA142Accident · Serious injuriesForeign investigationLancair LC41 · Gotha, GermanyNTSB WPR20WA114Accident · 8 fatalForeign investigationIsrael Aircraft Industries 1124A · Manilla, PhilippinesThe government of the Philippines has notified the NTSB of an accident involving an Israel Aircraft Industries 1124A airplane that occurred on March 29, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of the…NTSB ENG20WA029Incident · No injuriesForeign investigationAirbus A300 · Brussles, BelgiumOn March 27, 2020, the Danish Aviation Accident Investigation Board (AAIB) informed the NTSB of an Airbus A300-622RF cargo airplane, powered by two Pratt & Whitney PW4158 turbofan engines, that experienced a right (No. 2) engine failure during approach to…NTSB DCA21WA016IncidentClass 5 · ForeignBoeing 787-800 · Mexico City, MexicoNTSB WPR20WA202Accident · No injuriesForeign investigationRotorcraft Development Corpora UH1-D · Tsumeb, NamibiaThe government of Namibia has notified the NTSB of an accident involving a Rotorcraft Development Corporation UH1-D helicopter, registration V5-HOZ, that occurred on March 24, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the…NTSB ERA20WA137Accident · 1 fatalForeign investigationBell 206 · Chicureo, ChileNTSB ANC20WA035Accident · 1 fatalForeign investigationBell 206 · Konstantinovsky Cape, RussiaThe government of Russia has notified the NTSB of an accident involving a BELL 206 helicopter that occurred on March 23, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Russia's investigation under the provisions of…NTSB ERA20WA133Accident · No injuriesForeign investigationPiper PA23 · Eleuthera, BahamasThe government of Bahamas has notified the NTSB of an accident involving a Piper PA23 airplane that occurred on March 21, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Bahamas's investigation under the provisions of…NTSB ENG20WA021Incident · No injuriesForeign investigationAirbus A321 · Tan Son Nhat Int’L Airport, VietnamThe government of Vietnam has notified the NTSB of an incident involving an Airbus A321 airplane that occurred on March 18, 2020. A Vietnam Airbus A321-231 powered by two International Aero Engines V2533-A5 turbofan engines experienced a No. 2 (right) engine…NTSB GAA21WA049Accident · 1 fatalClass 4 · ForeignCessna 177 · Ebermannstadt, GermanyNTSB CEN20WA135Accident · 1 fatalForeign investigationPiper PA25 · Tepalcatepec, Michoacán, MexicoThe government of Mexico has notified the NTSB of an accident involving a PIPER PA25 airplane that occurred on March 15, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions of…NTSB GAA20WA143Accident · 1 fatalClass 5 · ForeignPiper PA28 · Paquera, Province of Puntarenas, Costa RicaNTSB ERA20WA193Accident · 2 fatalClass 3 · ForeignCessna 525 · El Yaque, VenezuelaNTSB ERA20WA136Accident · 2 fatalForeign investigationCessna 310 · Tefe, BrazilThe government of Brazil has notified the NTSB of an accident involving a Cessna 310 airplane that occurred on March 13, 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 DCA20WA093Accident · No injuriesClass 5 · ForeignBoeing 767 · Shannon, IrelandNTSB DCA20WA096Incident · No injuriesForeign investigationEmbraer ERJ170-200LR · Apodaca, MexicoNTSB DCA20WA089Incident · No injuriesForeign investigationBoeing 737 · Brazzaville, Congo - KinshasaThe government of Congo has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on March 01, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Congo's investigation under the provisions of…NTSB DCA20WA099Incident · No injuriesForeign investigationBoeing 737 · Crawley, United KingdomUnited Kingdom Air Accidents Investigation Branch (AAIB) notified the NTSB of an incident involving a BOEING 737 airplane that occurred on February 28, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of United Kingdom's…NTSB ANC20WA031Accident · 1 fatalForeign investigationRobinson R44 · Astrakhan, RussiaThe government of Russia has notified the NTSB of an accident involving a ROBINSON R44 helicopter that occurred on February 28, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Russia's investigation under the…NTSB DCA20WA094Incident · No injuriesForeign investigationBoeing 737 · Monterrey, MexicoThe DGAC of Mexico has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on February 27, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the DGAC's investigation under the provisions of ICAO Annex 13.All…NTSB ENG20WA018Incident · No injuriesForeign investigationAirbus A321 · London, United KingdomOn February 26, 2020, an Airbus A321-211, powered by two CFM International CFM56-5B3/3 turbofan engines experienced a left (No. 1) engine surge on departure from London Gatwick Airport (LGW) and an ECAM alert for the right engine (No. 2) stall condition. The…NTSB DCA20WA085Accident · No injuriesForeign investigationBoeing 737 · Papua, IndonesiaThe government of Indonesia has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on February 25, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Indonesia's investigation under the…NTSB GAA20WA144Accident · No injuriesClass 4 · ForeignBeech 58 · Buenos Aires, ArgentinaNTSB CEN20WA441Accident · 2 fatalClass 5 · ForeignRyan Aeronautical ST3KR · Les Chariots, FranceNTSB ANC20WA033Accident · No injuriesForeign investigationBombardier CL600 2B16 · Calgary, CanadaThe government of Canada has notified the NTSB of an accident involving a BOMBARDIER CL600 2B16 airplane that occurred on February 23, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Canada's investigation under the…NTSB CEN20WA097Accident · 1 fatalForeign investigationPiper PA60 · Pamplona, SpainThe National Transportation Safety Board was notified of an accident involving a Piper PA-60-602P, EC-HRJ, in Pamplona, Spain. This investigation is under the jurisdiction of the Comisión de Investigación de Accidentes e Incidentes de Aviación Civil in Spain.NTSB WPR20WA091Accident · 4 fatalForeign investigationPiper PA44 · Mangalore, AustraliaNTSB CEN20WA121Accident · 1 fatalForeign investigationLavia Argentina PA-25-235 · Etchoja, MexicoThe government of Mexico has notified the NTSB of an accident involving a LAVIA ARGENTINA PA-25-235 airplane that occurred on February 18, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under…NTSB DCA20WA106Incident · No injuriesForeign investigationEmbraer ERJ190 · Rosario, ArgentinaThe Junta de Seguridad en el Transporte (JST) Republica Argentina Direccion Nacional de Investigaciones (JIAAC) has notified the NTSB of an incident involving a EMBRAER ERJ190 airplane that occurred on February 17, 2020. The NTSB has appointed a U.S.…NTSB CEN20WA124Accident · 2 fatalForeign investigationCessna 150 · Les Cedres, CanadaThe government of Canada has notified the NTSB of an accident involving a CESSNA 150 airplane that occurred on February 17, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Canada's investigation under the provisions…NTSB GAA20WA135Accident · No injuriesForeign investigationPiper PA32 · Fort-de-France, MartiniqueNTSB ANC20WA026Accident · No injuriesForeign investigationAgustawestland AW139 · Ishikari-City, Hokkaido, JapanThe government of Japan has notified the NTSB of an accident involving a AGUSTAWESTLAND AW139 helicopter that occurred on February 16, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Japan's investigation under the…NTSB DCA20WA086Accident · Serious injuriesForeign investigationBoeing 737 · Incheon, North KoreaThe government of Korea, Democratic People's Republic Of has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on February 15, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Korea,…NTSB GAA20WA111Accident · 4 fatalForeign investigationPiper PA31 · Guaymaral, ColombiaThe government of Colombia has notified the NTSB of an accident involving a PIPER PA31 airplane that occurred on February 12, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Colombia's investigation under the…NTSB ENG20LA015Incident · No injuriesClass 4 · LimitedFinal reportAirbus A220 · Bordeaux, FranceA No. 1 (left) engine low pressure compressor (LPC) stage 1 integrally bladed rotor (IBR) separation due to a high cycle fatigue crack (HCF) that originated at the runout of an airfoil leading edge root radius. The HCF crack developed because of a…