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 CEN19WA041Accident · 2 fatalForeign investigationCessna T206H · Tampico, MexicoOn November 12, 2018, about 2016 UTC, a Mexican registered Cessna T206H airplane, XB-ILM, sustained substantial damage during a forced landing to a highway due to a loss of engine power near Tampico, Tamaulipas, Mexico. The pilot and passenger were not…NTSB DCA19WA023Incident · No injuriesForeign investigationEmbraer 190 · Bara, PortugalThe GPIA of Portugal has notified the NTSB of an incident involving a Embraer 190 airplane that occurred on November 11, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the GPIA of Portugal's investigation under the provisions of ICAO…NTSB DCA19RA025Accident · No injuriesForeign investigationBoeing 757 · Georgetown, GuyanaThe Guyana Civil Aviation Authority (GCAA) has notified the NTSB of an accident involving a Boeing 757, which occurred on November 9, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the GCAA investigation under the provisions of ICAO…NTSB ERA19WA040Accident · 1 fatalForeign investigationPiper PA23 · Nassau, BahamasThe government of Bahamas has notified the NTSB of an accident involving a Piper PA23 airplane that occurred on November 08, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Bahamas's investigation under the provisions…NTSB CEN19WA038Accident · 1 fatalForeign investigationPiper PA25 · Pachuca, Mexico, MexicoThe government of Mexico has notified the NTSB of an accident involving a PIPER PA25 airplane that occurred on November 08, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions…NTSB DCA19WA021Accident · No injuriesForeign investigationBoeing 747 · Halifax, CanadaNTSB CEN19WA027Accident · 2 fatalForeign investigationVans (EX) RV-6 · Meraaker, NorwayOn November 7, 2018, about 1410 hours central European standard time, a Vans RV-6 airplane, Norwegian registration LN-AAL, impacted terrain under unknown circumstances near Meråker, Norway. The pilot and passenger were fatally injured. The flight departed…NTSB WPR19RA044Accident · No injuriesForeign investigationAerospatiale AS350 · Dusky Forest, New ZealandThe government of New Zealand has notified the NTSB of an accident involving a AEROSPATIALE AS350 helicopter that occurred on November 06, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of New Zealand's investigation…NTSB DCA19WA022Accident · No injuriesForeign investigationBoeing 737 · Callao, PeruThe CIAA of Peru has notified the NTSB of an accident involving a Boeing 737 airplane that occurred on November 05, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the CIAA of Peru's investigation under the provisions of ICAO Annex 13…NTSB CEN19WA037Accident · 1 fatalForeign investigationRotorway Exec · Saint Pierre, St. Pierre & MiquelonNTSB CEN19WA042Accident · No injuriesForeign investigationPiper PA34 · Uk, United KingdomThe government of United Kingdom has notified the NTSB of an accident involving a PIPER PA34 airplane that occurred on November 02, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of United Kingdom's investigation under…NTSB DCA19WA020AccidentClass 5 · ForeignAirbus A330 · Paris, FranceNTSB ERA19WA288Accident · No injuriesForeign investigationEmbraer EMB-202 · Miranda, BrazilThe government of Brazil has notified the NTSB of an accident involving a Embraer EMB-202 airplane that occurred on October 30, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the…NTSB ERA19WA076Accident · 2 fatalForeign investigationCessna 150 · Manavgat, TürkiyeThe government of Turkey has notified the NTSB of an accident involving a CESSNA 150 airplane that occurred on October 30, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Turkey's investigation under the provisions of…NTSB DCA19RA017Accident · 191 fatalForeign investigationBoeing 737 · Jakarta, IndonesiaimportNTSB ENG19WA004Accident · 5 fatalForeign investigationAgusta Agusta AW169 · Leicester, United KingdomThe United Kingdom's Air Accidents Investigation Branch (AAIB) has notified the NTSB of an accident involving an Agusta AW169, which occurred on October 27, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under…NTSB ERA19WA046Accident · Serious injuriesForeign investigationGarlick UH1D · Valparaiso, ChileThe government of Chile has notified the NTSB of an accident involving a GARLICK UH1D helicopter that occurred on October 24, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Chile's investigation under the provisions…NTSB WPR19WA015Accident · 1 fatalForeign investigationBell UH -1H · Vermaaklikheid, South AfricaOn October 23, 2018, about 0745 Coordinated Universal time, a Bell UH-1H helicopter, ZS-HLP, impacted terrain during a firefighting mission near Vermaaklikheid, South Africa. The pilot sustained fatal injuries and the helicopter was substantially damaged in…NTSB CEN19WA340Accident · No injuriesForeign investigationCessna F152 · Lingreville, FranceThe government of France has notified the NTSB of an accident involving a CESSNA F152 airplane that occurred on October 21, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of France's investigation under the provisions…NTSB DCA19WA015Incident · No injuriesForeign investigationBoeing 787 · Hong Kong, ChinaThe government of China has notified the NTSB of an accident involving a BOEING 787 airplane that occurred on October 20, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of China's investigation under the provisions of…NTSB DCA19WA027Incident · No injuriesForeign investigationBoeing 737 · Bangkok, ThailandThe AAIC of Thailand has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on October 19, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the AAIC of Thailand's investigation under the provisions of ICAO…NTSB WPR19WA012Accident · 3 fatalClass 5 · ForeignHughes 369 · Wanaka, New ZealandNTSB DCA19WA071Incident · No injuriesForeign investigationBoeing 747 · Kolkata, IndiaThe Aircraft Accident Investigation Bureau (AAIB) of India has notified the NTSB of an incident involving a Boeing 747, which occurred on October 16, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under the…NTSB CEN19WA012Accident · 2 fatalForeign investigationCessna 150M · La Paz, MexicoThe government of Mexico has notified the NTSB of an accident involving a CESSNA 150M airplane that occurred on October 16, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions…NTSB DCA19WA196Incident · Serious injuriesForeign investigationBoeing 777 · New Delhi, IndiaThe government of India has notified the NTSB of a serious incident involving a BOEING 777 airplane that occurred on October 15, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of India's investigation under the…NTSB CEN19WA014Accident · No injuriesForeign investigationPiper L4 · Skane County, SwedenThe government of Sweden has notified the NTSB of an accident involving a PIPER L4 airplane that occurred on October 14, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Sweden's investigation under the provisions of…NTSB CEN19WA010Accident · 3 fatalForeign investigationCessna F172 · Wasserkuppe, GermanyOn October 14, 2018, about 1345 coordinated universal time, a Cessna F172N, D-EFJX, experienced a runway excursion during landing which resulted in 3 ground fatalities.This investigation is under the jurisdiction and control of the German Federal Bureau of…NTSB DCA19WA013Incident · No injuriesForeign investigationBoeing 737 · East Midlands, United KingdomThe government of United Kingdom has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on October 12, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of United Kingdom's investigation under…NTSB DCA19WA007Accident · No injuriesForeign investigationBoeing 737 · Tamil Nadu, IndiaThe government of India has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on October 12, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of India's investigation under the provisions of…NTSB DCA19WA008Incident · No injuriesForeign investigationBoeing 787 · Perth, AustraliaThe Australian Transport Safety Bureau (ATSB) has notified the NTSB of an incident involving a BOEING 787 airplane that occurred on October 11, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's investigation…NTSB CEN19WA011Accident · 2 fatalForeign investigationCessna F172 · East Yorkshire, United KingdomOn November 10, 2018, about 1930 hours universal coordinated time, a Reims Cessna F172N, United Kingdom registration G-BGSV, impacted a field near East Yorkshire, United Kingdom. The two occupants on-board were fatally injured. The flight origin and…NTSB DCA19WA011Incident · No injuriesForeign investigationBoeing 737 · Brisbane, AustraliaThe Australian Transport Safety Bureau (ATSB) has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on October 09, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's investigation…NTSB WPR19WA004Accident · 2 fatalForeign investigationCessna 172 · Midrand, South AfricaOn October 8, 2018, at 0920 coordinated universal time, a Cessna 172L airplane, registration ZS-PZT, sustained substantial damage after colliding with the ground during the landing approach at Grand Central Airport, Midrand, South Africa. The pilot and one…NTSB DCA19WA083Incident · No injuriesForeign investigationBoeing 747 · Bangkok, ThailandThe government of Thailand has notified the NTSB of an accident involving a BOEING 747 airplane that occurred on October 08, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Thailand's investigation under the…NTSB CEN19WA019Incident · No injuriesForeign investigationCessna 510 · Lugano, SwitzerlandOn October 6, 2018, about 0945 Universal Coordinated Time, a Cessna Citation 510, OE-FID, experienced a tire failure during landing at the Lugano Airport (LSZA), Lugano, Switzerland. There were no injuries to the 2 crewmembers. The flight originated from the…NTSB WPR19WA036Accident · Minor injuriesForeign investigationAir Tractor 401B · Rukubi, NigeriaOn October 4, 2018, about 0815 coordinated universal time, an Air Tractor AT-401B airplane, 5N-BTV, executed a forced landing following a loss of engine power near Rukubi, Nigeria. The pilot sustained minor injuries and the airplane was substantially damaged.…NTSB WPR19WA090Incident · No injuriesForeign investigationCessna 560 · Bauchi, NigeriaOn October 3, 2018, about 0754 universal coordinated time, a Cessna Citation XLS+/Nigerian 5N-HAR sustained minor damage during takeoff roll at Sir Abubakar Tafawa Balewa / Bauchi State International Airport, Bauchi, Nigeria. The pilot and two passengers were…NTSB ERA19WA038Accident · 2 fatalForeign investigationSiai Marchetti SF260 · Caorle, ItalyThe government of Italy has notified the NTSB of an accident involving a Siai Marchetti SF260 airplane that occurred on October 03, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Italy's investigation under the…NTSB DCA19WA009Incident · Minor injuriesForeign investigationBoeing 737 · Zagreb, CroatiaThe AIN of Croatia has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on October 02, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the AIN of Croatia's investigation under the provisions of ICAO Annex…NTSB CEN19WA001Accident · 3 fatalForeign investigationCessna 210 5 · Yécora, MexicoOn October 1, 2018, about 2110 universal coordinated time (UTC), a Cessna 210, US registration N8388Z, impacted terrain under unknown circumstances near Sonora, Mexico. Under the provisions of ICAO Annex 13, the NTSB has assigned an accredited representative…NTSB ANC19WA001Accident · 2 fatalForeign investigationRobinson R44 · Bodaybo, RussiaOn October 1, 2018, at an undetermined time, a Robinson R-44-II helicopter, RA-05758, impacted water and sank prior to colliding with a power transmission line near Bodaybo, Russia. The pilot and passenger sustained fatal injuries. The Interstate Aviation…NTSB DCA18WA298Incident · No injuriesForeign investigationAirbus A320 · Sydney, AustraliaNTSB DCA18WA300Incident · No injuriesForeign investigationBoeing 737 · Diagoras, HungaryThe government of Hungary has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on September 28, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Hungary's investigation under the…NTSB DCA18RA292Accident · 1 fatalForeign investigationBoeing 737 · Chuuk, MicronesiaThe government of Federated States Of Micronesia (FSM) has notified the NTSB of an accident involving a BOEING 737 that occurred on September 28, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the FSM's investigation under the…NTSB ANC18WA078Accident · 1 fatalForeign investigationCessna 208 · Narita, JapanOn September 27, 2018, at 0626 universal coordinated time, a Cessna 208B airplane, VH-FAY, disappeared from radar during cruise flight over international waters, about 185Km northeast of Narita International Airport. Parts from the destroyed airplane were…NTSB DCA18WA305Incident · No injuriesForeign investigationBoeing 737 · Chattogram, BangladeshThe AAIG of Bangladesh has notified the NTSB of an accident involving a Boeing 737 airplane that occurred on September 26, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the AAIG of Bangladesh's investigation under the provisions of…NTSB DCA18WA296Incident · Minor injuriesForeign investigationAirbus A320 · Tijuana, MexicoThe government of Mexico has notified the NTSB of an incident involving a AIRBUS A320 airplane that occurred on September 26, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions…NTSB CEN18WA390Accident · 1 fatalForeign investigationRobinson R44 · Buttonville, CanadaOn September 25, 2018, about 1800 hours universal coordinated time, a Robinson R44 II helicopter, Canadian registration C-GMCT, impacted terrain while diverting due to deteriorating weather conditions near the Toronto/Buttonville Municipal Airport (CYKZ),…NTSB ENG18WA037Accident · No injuriesForeign investigationHonda HA-420 · Foz do Iguacu, BrazilThe government of Brazil has notified the NTSB of an accident involving a Honda HA-420, which occurred on September 24, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions of…NTSB WPR18WA282Accident · Minor injuriesForeign investigationBell 206 · Yarraden, AustraliaOn September 22, 2018, at 2045 coordinated universal time, a Bell 206B helicopter, registration VH-HZO, sustained substantial damage after colliding with the ground following a total loss of power near Yarraden, Australia. The pilot was not injured. The three…