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 DCA20WA128Accident · No injuriesForeign investigationBoeing 777 · Shanghai, ChinaThe Civil Aviation Administration (CAAC) of China has notified the NTSB of an accident involving a Boeing 777, which occurred on July 22, 2020. The NTSB has appointed a U.S Accredited Representative to assist under the provisions of ICAO Annex 13 as the State…NTSB GAA20WA118Accident · 1 fatalForeign investigationRobinson R44 · Thorburn Lake, CanadaThe government of Canada has notified the NTSB of an accident involving a ROBINSON R44 helicopter that occurred on July 20, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Canada's investigation under the provisions…NTSB GAA20WA148Accident · 1 fatalClass 4 · ForeignParachute Icarus Crossfire 2 · Juta, HungaryNTSB DCA20WA137Incident · No injuriesForeign investigationBoeing 737 · Palma, SpainThe government of Spain has notified the NTSB of an accident involving a Boeing 737 airplane that occurred on July 19, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Spain's investigation under the provisions of ICAO…NTSB WPR20WA242Accident · Serious injuriesClass 5 · ForeignMD Helicopter 600 · Windhoek, NamibiaNTSB ENG20WA039Incident · No injuriesForeign investigationHawker Siddeley HS125 · Port Harcourt, NigeriaOn July 16, 2020 a Hawker-Siddeley (Textron Aviation), powered by two Honeywell TFE731 5R-1H turbofan engines experienced a No. 1 (left engine) audible fire warning during cruise. The flight crew declared an emergency and made an uneventful landing at Port…NTSB DCA20WA131Accident · Serious injuriesForeign investigationBoeing 737 · Durban, South AfricaThe CAA of South Africa has notified the NTSB of an accident involving a Boeing 737 airplane that occurred on July 14, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the CAA of South Africa's investigation under the provisions of ICAO…NTSB DCA20WA132Incident · No injuriesForeign investigationBoeing 737 · Tijuana, MexicoThe DGAC of Mexico has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on July 11, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the DGAC of Mexico's investigation under the provisions of ICAO Annex…NTSB CEN20WA293Accident · Serious injuriesForeign investigationCessna FR172 · Galway, IrelandThe government of the Ireland has notified the NTSB of an accident involving a Cessna FR172K airplane that occurred on July 11, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Ireland's investigation under the…NTSB GAA20WA124Incident · No injuriesForeign investigationLearjet 45 · Toluca de Lerdo, Méx., Mexico, MexicoThe government of Mexico has notified the NTSB of an accident involving a LEARJET 45 airplane that occurred on July 10, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions of…NTSB GAA20WA121Accident · 1 fatalForeign investigationBeech 58 · Sao Paulo, BrazilThe government of Brazil has notified the NTSB of an accident involving a BEECH 58 airplane that occurred on July 08, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions of ICAO…NTSB GAA20WA122Accident · Minor injuriesClass 4 · ForeignRobinson R22 · Rio De Janeiro, BrazilThe government of Brazil has notified the NTSB of an accident involving a ROBINSON R22 helicopter that occurred on July 06, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions…NTSB WPR20WA210Accident · 2 fatalForeign investigationRobinson R44 · Broome Aerodrome, AustraliaThe government of Australia has notified the NTSB of an accident involving a ROBINSON R44 helicopter that occurred on July 04, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's investigation under the…NTSB CEN20WA437Accident · No injuriesClass 4 · ForeignPiper PA28 · Pointe-à-Pitre, GuadeloupeNTSB ENG20WA042Incident · No injuriesForeign investigationATR ATR72 · Ambon, IndonesiaThe National Transportation Safety Committee of Indonesia (KNKT) has notified the NTSB of an incident involving an ATR 72-600, which occurred on July 3, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the KNKT investigation under the…NTSB GAA20WA119Accident · No injuriesForeign investigationPilatus PC12 · Nice, FranceThe government of France has notified the NTSB of an accident involving a PILATUS PC12 airplane that occurred on June 30, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of France's investigation under the provisions of…NTSB GAA20WA113Accident · 2 fatalForeign investigationRobinson R22 · Strzegom city, PolandThe government of Poland has notified the NTSB of an accident involving a ROBINSON R22 helicopter that occurred on June 30, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Poland's investigation under the provisions…NTSB ANC20WA101AccidentClass 4 · ForeignBell 204 · Hyogo Prefecture, JapanNTSB GAA20WA150Accident · No injuriesClass 4 · ForeignCessna 550 · Vijayanagar, IndiaNTSB GAA20WA127Accident · No injuriesClass 5 · ForeignCessna 150 · Cancun, MexicoNTSB GAA20WA115Incident · No injuriesForeign investigationBeech 900XP · Paris, FranceThe government of France has notified the NTSB of an accident involving a BEECH 900XP airplane that occurred on June 26, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of France's investigation under the provisions of…NTSB GAA20WA117Accident · No injuriesForeign investigationAmerican Champion 8KCAB · Lommis, WZThe government of Swaziland has notified the NTSB of an accident involving a AMERICAN Champion 8KCAB airplane that occurred on June 24, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Swaziland's investigation under…NTSB CEN20WA246Accident · No injuriesForeign investigationBell 407 · Long Marston, United KingdomThe government of the United Kingdom has notified the NTSB of an accident involving a Bell 407 helicopter that occurred on June 24, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of the United Kingdom's investigation…NTSB GAA20WA114Accident · 5 fatalForeign investigationCessna TU206 · Balleza, Chihuahua, MexicoThe government of Mexico has notified the NTSB of an accident involving a CESSNA TU206 airplane that occurred on June 23, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions of…NTSB GAA20WA112Accident · 1 fatalForeign investigationPiper PA25 · Vereda Brisas de Guaiquitia, ColombiaNTSB GAA20WA116Accident · No injuriesForeign investigationCessna FA150 · Doub, FranceThe government of France has notified the NTSB of an accident involving a CESSNA FA150 airplane that occurred on June 20, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of France's investigation under the provisions of…NTSB GAA20WA131Accident · No injuriesForeign investigationDaher TB10 · Visby, SwedenThe government of Sweden has notified the NTSB of an accident involving a DAHER TB10 airplane that occurred on June 19, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Sweden's investigation under the provisions of…NTSB WPR20WA186Accident · 2 fatalForeign investigationBell 206 · Gauteng, South AfricaNTSB CEN20WA237Accident · 1 fatalForeign investigationPiper PA34 · Reinsfeld, GermanyThe government of Germany has notified the NTSB of an accident involving a Piper PA-34 220T airplane, German registration D-GEMZ, that occurred on June 17, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Germany's…NTSB ENG20WA041Incident · No injuriesForeign investigationAirbus A321 · Doncaster, United KingdomThe United Kingdom Air Accidents Investigation Branch (AAIB) has notified the NTSB of an incident which occurred on June 16, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under the provisions of ICAO Annex 13…NTSB ENG20WA037Incident · No injuriesForeign investigationAirbus A320 · Tijuana, MexicoThe Mexican government has notified the NTSB of an incident involving an Airbus A330-202 that occurred June 16, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the Direccion de Analisis de Accidentes e Incidentes de Aviacion (DGAC) of…NTSB DCA20WA119Incident · No injuriesForeign investigationBoeing 737 · Banjarmasin, IndonesiaThe government of Indonesia has notified the NTSB of an incident involving a Boeing 737-800 airplane that occurred on June 11, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Ireland's investigation under the…NTSB WPR20WA264Accident · No injuriesForeign investigationAir Tractor AT802A · Karubaga, IndonesiaThe government of Indonesia has notified the NTSB of an accident involving a AIR TRACTOR AT802A airplane that occurred on June 09, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Indonesia's investigation under the…NTSB WPR20WA182Accident · 2 fatalForeign investigationCessna 152 · Bhubaneswar, IndiaThe government of India has notified the NTSB of an accident involving a CESSNA 152 airplane that occurred on June 08, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of India's investigation under the provisions of ICAO…NTSB ENG20WA036Accident · No injuriesClass 5 · ForeignDornier 228 · North Brabant, NetherlandsNTSB DCA20WA117Incident · No injuriesForeign investigationBoeing 787 · Dubai, United Arab EmiratesThe GCAA of United Arab Emirates has notified the NTSB of an incident involving a Boeing 787 airplane that occurred on June 08, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the GCAA of United Arab Emirates's investigation under the…NTSB DCA20WA112Incident · No injuriesForeign investigationMcdonnell Douglas MD11 · Mumbai, IndiaThe AAIB of India has notified the NTSB of an accident involving a Boeing MD11 airplane that occurred on June 03, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB's investigation under the provisions of ICAO Annex 13.All…NTSB CEN20WA243Incident · No injuriesForeign investigationCessna P210 · Wevelgem, BelgiumThe government of Belgium has notified the NTSB of an accident involving a Cessna P210 airplane that occurred on June 03, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Belgium's investigation under the provisions of…NTSB CEN20WA398Accident · No injuriesForeign investigationCessna U206 · Tallard, FranceThe government of France has notified the NTSB of an accident involving a Cessna U206 airplane that occurred on June 2, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of France's investigation under the provisions of…NTSB CEN20WA433Accident · No injuriesClass 5 · ForeignCirrus SR22 · Foreign, United KingdomNTSB CEN20WA438Accident · 1 fatalClass 5 · ForeignPitts S2 · Carcassonne, FranceNTSB CEN20WA198Accident · 1 fatalForeign investigationCessna 150 · Blomberg, GermanyThe government of Germany has notified the NTSB of an accident involving a CESSNA 150 airplane that occurred on May 27, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Germany's investigation under the provisions of…NTSB ERA20WA196Accident · 1 fatalForeign investigationDiamond DA20 · Rome, ItalyThe government of Italy has notified the NTSB of an accident involving a DIAMOND DA20 airplane that occurred on May 25, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Italy's investigation under the provisions of…NTSB DCA20WA108Accident · 97 fatalForeign investigationAirbus A320 · Karachi, PakistanThe government of Pakistan has notified the NTSB of an accident involving an AIRBUS A320 with CFM56 engines that occurred on May 22, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Pakistan's investigation under the…NTSB WPR21WA018Accident · 1 fatalClass 5 · ForeignOsprey 2 Amphibian · Maitland Aerodrome, AustraliaNTSB WPR20WA143Accident · 1 fatalForeign investigationDaher Kodiak · Papua, IndonesiaThe government of Indonesia has notified the NTSB of an accident involving a Daher Kodiak airplane that occurred on May 12, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Indonesia's investigation under the…NTSB ERA20CA191Accident · Minor injuriesClass 4 · Data collectionFinal reportBell UH 1N · Baghdad, IraqThe flight crew's inadequate situational awareness and failure to maintain adequate clearance from a security barrier during a night takeoff.NTSB CEN20WA209Accident · 2 fatalForeign investigationPiper PA38 · Kena, LithuaniaThe National Transportation Safety Board was notified of an accident involving a Piper PA-38-112 airplane, LY-ATM, near Kena, Lithuania. This investigation is under the jurisdiction of Ministry of Justice of the Republic of Lithuania, Transport Accident and…NTSB ERA20WA170Accident · 1 fatalForeign investigationLearjet 35 · Esquel, ArgentinaThe government of Argentina has notified the NTSB of an accident involving a LEARJET 35 airplane that occurred on May 06, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Argentina's investigation under the provisions…NTSB CEN20WA171Accident · 3 fatalForeign investigationCessna 182 · Area Municipio De Joyabaj, Guatemala