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 ENG19WA017Incident · No injuriesForeign investigationAirbus A320 · Pune, IndiaThe government of India has notified the NTSB of an incident involving a AIRBUS A320 airplane that occurred on April 2, 2019. An Indigo Airbus A320 powered by two Pratt & Whitney PW1127G-JM geared turbofan engines experienced a No. 1 (left) engine failure…NTSB ENG19WA018Incident · No injuriesForeign investigationAirbus A320 · Jaipur, IndiaThe government of India has notified the NTSB of an incident involving a AIRBUS A320 airplane that occurred on April 1, 2019. An Indigo Airbus A320 powered by two Pratt & Whitney PW1127G-JM geared turbofan engines experienced a No. 1 (left) engine failure…NTSB GAA19WA187Accident · 3 fatalForeign investigationEpig 1000LT · Egelsbach (Germany), GermanyThe government of Germany has notified the NTSB of an accident involving an amateur-built EPIG 1000LT airplane that occurred on March 31, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Germany's investigation under…NTSB GAA19WA201Accident · 1 fatalForeign investigationMoravan Z-50LA · Castel Viscardo, ItalyThe government of Italy has notified the NTSB of an accident involving a MORAVAN Z-50LA airplane that occurred on March 30, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Italy's investigation under the provisions of…NTSB GAA19WA188Accident · 1 fatalForeign investigationPiper J3C · Snowshoe Lake, Ontario, CanadaNTSB ENG19WA016Incident · No injuriesForeign investigationBoeing 787 · Osaka, JapanOn March 29, 2019, a Boeing 787, powered by two General Electric GEnx 1B64P2 turbofan engines and operated by Jetstar Airways, experienced a dual engine event while descending to land at the Kansai International Airport (RJBB), Osaka, Japan. During descent,…NTSB DCA19WA144Incident · No injuriesForeign investigationBoeing 737 · Las Palmas, SpainThe CIAIAC of Spain has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on March 26, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the CIAIAC's investigation under the provisions of ICAO Annex 13 as…NTSB ENG19WA025Incident · No injuriesForeign investigationAirbus A320 · Guwahati, IndiaThe government of India has notified the NTSB of an incident involving a AIRBUS A320 airplane that occurred on March 24, 2019. An Indigo Airbus A320 powered by two Pratt & Whitney PW1127G-JM geared turbofan engines experienced issues with the No. 2 (right)…NTSB DCA19WA129Incident · No injuriesForeign investigationBoeing 737 · Santa Cruz de la Sierra, BoliviaThe AIG of Bolivia has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on March 24, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the AIG's investigation under the provisions of ICAO Annex 13 as State…NTSB CEN19WA118Accident · Serious injuriesForeign investigationRobinson R44 · Stavnes, NorwayThe government of Norway has notified the NTSB of an accident involving a Robinson R44 helicopter that occurred on March 23, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Norway's investigation under the provisions…NTSB GAA19WA223Accident · 1 fatalForeign investigationCessna A185 · Bocona, VenezuelaThe government of Venezuela has notified the NTSB of an accident involving a CESSNA A185 airplane that occurred on March 22, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Venezuela's investigation under the…NTSB GAA19WA179Accident · 2 fatalForeign investigationEnstrom 480 · Blazkov village, Czech Republic., CzechiaThe government of Czech Republic has notified the NTSB of an accident involving a ENSTROM 480 helicopter that occurred on March 22, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Czech Republic's investigation under…NTSB DCA19WA131Incident · No injuriesForeign investigationBoeing 737 · Jogyakarta, IndonesiaThe KNKT of Indonesia has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on March 15, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the KNKT's investigation under the provisions of ICAO Annex 13 as…NTSB GAA19WA222Accident · 2 fatalForeign investigationCessna U206 · Bolivar, VenezuelaThe government of Venezuela has notified the NTSB of an accident involving a CESSNA U206 airplane that occurred on March 11, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Venezuela's investigation under the…NTSB GAA19WA175Accident · 1 fatalForeign investigationCessna 188 · Rio Pardo, State of Rio Grande do sul, Brazil, BrazilThe government of Brazil has notified the NTSB of an accident involving a CESSNA 188 airplane that occurred on March 11, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions of…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 CEN19WA096Accident · 2 fatalForeign investigationNorth American T28 · Escuintla, GuatemalaNTSB ERA19WA121Accident · 14 fatalForeign investigationDouglas DC3 · Vereda La Bendicion, ColombiaThe government of Colombia has notified the NTSB of an accident involving a DOUGLAS DC3 airplane that occurred on March 09, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Colombia's investigation under the provisions…NTSB DCA19WA114Incident · No injuriesForeign investigationBoeing 747 · Taiwan, TaiwanAviation Safety Council of Taiwan has notified the NTSB of an incident involving a BOEING 747 airplane that occurred on March 09, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Taiwan's investigation under the…NTSB ENG19WA020Incident · No injuriesForeign investigationAirbus A320 · Lucknow, IndiaThe government of India has notified the NTSB of an incident involving a AIRBUS A320 airplane that occurred on March 7, 2019. A GoAir Airbus A320 powered by two Pratt & Whitney PW1127G-JM geared turbofan engines experienced a No. 1 (left) engine failure while…NTSB DCA19WA108Incident · No injuriesForeign investigationBoeing 767 · Halifax, CanadaThe government of Canada has notified the NTSB of an accident involving a BOEING 767 airplane that occurred on March 04, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Canada's investigation under the provisions of…NTSB CEN19WA105Accident · No injuriesForeign investigationPiper PA34 · Lagunilla, Costa RicaNTSB CEN19WA103Accident · 2 fatalForeign investigationRobinson R66 · Timmins, CYTS, CanadaThe government of Canada has notified the NTSB of an accident involving a Robinson R66 helicopter that occurred on March 04, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Canada's investigation under the provisions…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 DCA19WA099Accident · No injuriesForeign investigationBeech 1900 · Ourgla, AlgeriaThe Civil Aviation Directorate (CAD) of Algeria has notified the NTSB of an accident involving a Beech 1900D, which occurred on March 3, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the CAD investigation under the provisions of ICAO…NTSB ENG19WA045Incident · No injuriesForeign investigationEmbraer ERJ190 · Devon, United Kingdom, United KingdomOn February 28, 2019, an Embraer ERJ 190-200 LR powered by two General Electric CF34 10E7 turbofan engines, experienced smoke filling the cabin during the takeoff roll from Exeter International Airport, Devon, United Kingdom. The takeoff was aborted and an…NTSB DCA19WA182Incident · No injuriesForeign investigationBoeing 737 · London, United KingdomThe AAIB of the United Kingdom has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on February 26, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB's investigation under the provisions of ICAO…NTSB ERA19WA128Accident · 2 fatalForeign investigationCessna T182 · Jacareacanga County, BrazilThe government of Brazil has notified the NTSB of an accident involving a Cessna T182 airplane that occurred on February 23, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions…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 DCA19WA093Incident · No injuriesForeign investigationBoeing 737 · Capetown, South AfricaThe South African Civil Aviation Authority (CAA) has notified the NTSB of an incident involving a Boeing 737, which occurred on February 21, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the CAA investigation under the provisions of…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 DCA19WA087Incident · No injuriesForeign investigationBoeing 737 · Pontianak, IndonesiaThe National Transportation Safety Committee of Indonesia (KNKT) has notified the NTSB of an incident involving a Boeing 737, which occurred on February 16, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the KNKT investigation under…NTSB CEN19WA089Incident · No injuriesForeign investigationPiper PA19 · Brustem Airfield, Belgium, BelgiumThe government of Belgium has notified the NTSB of an accident involving a PIPER PA19 airplane that occurred on February 16, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Belgium's investigation under the provisions…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 ERA19WA127Accident · 1 fatalForeign investigationCessna 210 · Belém City, State of Pará, BrazilThe government of Brazil has notified the NTSB of an accident involving a Cessna 210 airplane that occurred on February 13, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions…NTSB DCA19WA082Incident · No injuriesForeign investigationBoeing 737 · Albania, AlbaniaThe government of Albania has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on February 13, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Albania's investigation under the provisions…NTSB ERA19WA099Accident · 3 fatalForeign investigationBell 206 · Barueri County, BrazilThe government of Brazil has notified the NTSB of an accident involving a Bell 206 helicopter that occurred on February 11, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions…NTSB DCA19WA084Incident · Minor injuriesForeign investigationBoeing 737 · Nurenburg, GermanyThe government of Germany has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on February 10, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Germany's investigation under the provisions…NTSB CEN19WA081Accident · 2 fatalForeign investigationCessna 150 · Atizapán de Zaragoza, México, México, MexicoThe government of Mexico has notified the NTSB of an accident involving a CESSNA 150H airplane that occurred on February 10, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions…NTSB ERA19WA101Accident · 2 fatalForeign investigationGlobe GC1A · Dom Pedrito County, BrazilThe government of Brazil has notified the NTSB of an accident involving a GLOBE GC1A airplane that occurred on February 06, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions…NTSB ENG19WA012Incident · No injuriesForeign investigationAirbus A321 · Lahore, PakistanOn February 2, 2019, a Vietnam Airlines A321-272N Neo, powered by two P&W PW1130G-JM geared fan engines experienced an No. 2 (right ) engine failure while in cruise. It was reported that a stall warning was detected followed by high vibration and an exhaust…NTSB DCA19CA075Accident · Serious injuriesClass 4 · Data collectionFinal reportBoeing 737 · Bluefields, NicaraguaAn inadvertent encounter with clear air turbulence.NTSB DCA19WA072Incident · No injuriesForeign investigationBoeing 787 · Casablanca, MoroccoThe BEA of Morocco has notified the NTSB of an incident involving a Boeing 787 airplane that occurred on February 03, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the BEA of Morocco's investigation under the provisions of ICAO Annex…NTSB GAA19WA342Incident · No injuriesForeign investigationRaytheon B200 · Lausanne-Switzerland, SwitzerlandThe government of Switzerland has notified the NTSB of an accident involving a RAYTHEON B200 airplane that occurred on February 02, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Switzerland's investigation under the…NTSB CEN19WA079Accident · 1 fatalForeign investigationCessna 150 · Durango, MexicoNTSB WPR19WA149Accident · No injuriesForeign investigationPitts S2 · Kliprivier, South AfricaThe government of South Africa has notified the NTSB of an accident involving a Pitts S2 airplane that occurred on January 29, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of South Africa's investigation under the…NTSB DCA19WA127Incident · No injuriesForeign investigationBoeing 737 · Frankfurt, GermanyThe AAIU of Ireland has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on January 29, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the AAIU's investigation under the provisions of ICAO Annex 13.All…NTSB WPR19WA147Accident · Minor injuriesForeign investigationSikorsky S64 · Mount Eliza, AustraliaOn January 28, 2019, at 1956 local time, a Sikorsky S-64E, N173AC, sustained substantial damage after colliding into a pond near Mount Eliza, Australia. The pilot and two crewmembers were not injured. The investigation is under the jurisdiction of the…NTSB CEN19WA077Accident · 2 fatalForeign investigationRans S12 · Bavispe, MexicoNTSB ERA19WA174Accident · 7 fatalForeign investigationEurocopter AS350 · Megeve, ItalyThe government of Italy has notified the NTSB of an accident involving a midair collision between a Eurocopter AS350-B3 helicopter and a Jodel D.140E airplane that occurred on January 25, 2019. The NTSB has appointed a U.S. Accredited Representative to assist…