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 ERA19WA103Incident · No injuriesForeign investigationBritten Norman BN2B · Esmeraldas, EcuadorThe government of Ecuador has notified the NTSB of an incident involving a Britten Norman BN2B airplane that occurred on January 25, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Ecuador's investigation under the…NTSB ERA19WA090Accident · 1 fatalForeign investigationPiper PA25 · Jaguaré County, BrazilThe government of Brazil has notified the NTSB of an accident involving a PIPER PA-25-235 airplane that occurred on January 21, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the…NTSB ENG19WA009Incident · No injuriesForeign investigationAirbus A320 · Lucknow, IndiaThe government of India has notified the NTSB of an incident involving a AIRBUS A320 airplane that occurred on January 21, 2019. An Indigo Airbus A320 experienced a No. 2 (right) engine failure while climbing through FL120 after departure from Lucknow Airport…NTSB DCA19WA067Incident · No injuriesForeign investigationBoeing 737 · Ndjili, Congo - KinshasaThe Aviation Accident Investigation Bureau (BPEA) of the Democratic Republic of Congo has notified the NTSB of an incident involving a Boeing 737, which occurred on January 21, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the BPEA…NTSB CEN19WA057Accident · 2 fatalForeign investigationPiper PA46 · St. Peter Port, United KingdomOn January 21, 2013, about 2012 UTC, a Piper PA-46-301P, N264DB, operated by a private individual, disappeared from radar 15 nm north of Guernsey, Channel Island, United Kingdom. The airplane is believed to have crashed in English Channel and is presumed…NTSB DCA19WA054Incident · No injuriesForeign investigationMcdonnell Douglas MD11 · Dubai, United Arab EmiratesThe General Civil Aviation Authority (GCAA) of The United Arab Emirates has notified the NTSB of an accident involving a MCDONNELL DOUGLAS MD11 that occurred on January 20, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the GCAA's…NTSB ERA19WA092Accident · 1 fatalForeign investigationPiper PA25 · Campinas do Sul County, BrazilThe government of Brazil has notified the NTSB of an accident involving a Piper PA25-235 airplane that occurred on January 12, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the…NTSB CEN19WA052Accident · 2 fatalForeign investigationPiper PA28R · Regil, SpainOn January 9, 2019, about 1215 UTC, a Piper PA-28-201 Arrow III, United Kingdom registry G-OARI, impacted mountainous terrain near Regil, Guipuzcoa, Spain. The two persons on board were fatally injured and the airplane was destroyed. Instrument meteorological…NTSB WPR19WA113Accident · No injuriesForeign investigationCirrus SR22 · Lanseria, South AfricaOn January 6, 2019, about 0730 coordinated universal time, a Cirrus SR22T, ZS-ARI, experienced a nose landing gear collapse during the landing roll at Lanseria, Gauteng Province, South Africa. The pilot and passenger were not injured. The airplane was…NTSB WPR19WA059Accident · No injuriesForeign investigationCessna 182 · Tooradin, AustraliaOn January 6, 2019, at 1045 local time, a Cessna 182G, VH-DGF, collided with trees following a loss of engine power during the initial climb near Tooradin, Australia. The pilot and four passengers were not injured. The airplane was substantially damaged. The…NTSB ENG21WA016Incident · No injuriesClass 5 · ForeignBoeing 737 · Lagos, NigeriaNTSB ENG19WA010Incident · No injuriesForeign investigationAirbus A320 · Chennai, IndiaThe government of India has notified the NTSB of an incident involving a AIRBUS A320 airplane that occurred on January 3, 2019. An Indigo Airbus A320 experienced a No. 2 (right) engine failure while climbing while climbing after departure from Chennai Airport…NTSB ERA19WA088Accident · 1 fatalForeign investigationRobinson R44 · Ubatuba, BrazilThe government of Brazil has notified the NTSB of an accident involving a Robinson R44 II that occurred on January 1, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions of ICAO…NTSB ANC19WA013Accident · 4 fatalForeign investigationAgusta A119 · Ulan-Ude, RussiaOn December 30, 2018, about 0230 universal time, an Agusta A119 helicopter, RA-01908, impacted terrain under unknown circumstances about 12 miles from Ulan-Ude, Buryatia, Russia. The pilot and three passenger sustained fatal injuries. The Interstate Aviation…NTSB ENG19IA008IncidentClass 3 · IncidentFinal reportAirbus A220 · Busan, South KoreaThe manufacturer’s inadequate cleaning of the crucible before melting the nickel alloy used in casting the low pressure turbine stage 3 blades that resulted in a casting anomaly from where an intergranular crack occurred became the origin of a fatigue crack…NTSB ERA19RA077Accident · 5 fatalForeign investigationAgusta A109 · Santa Maria Coronango, State of Puebla, MexicoThe government of Mexico has notified the NTSB of an accident involving a AGUSTA A109S helicopter that occurred on December 24, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the…NTSB DCA19WA057Incident · No injuriesForeign investigationBoeing 747-428 · Delhi Airspace, IndiaThe Aircraft Accident Investigation Bureau (AAIB) of India has notified the NTSB of an incident involving a Boeing 747, which occurred on December 21, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under the…NTSB DCA19WA049Incident · No injuriesForeign investigationBoeing 777 · Belo Horizonte, BrazilThe CENIPA of Brazil has notified the NTSB of an incident involving a Boeing 777 airplane that occurred on December 20, 2018. The NTSB has appointed a U.S. Accredited Representative to assist CENIPA's investigation under the provisions of ICAO Annex 13 as…NTSB ERA19WA082Accident · No injuriesForeign investigationRockwell S2R · Orihueca, Magdalena, ColombiaThe government of Colombia has notified the NTSB of an accident involving a ROCKWELL S2R airplane that occurred on December 19, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Colombia's investigation under the…NTSB CEN19WA080Accident · No injuriesForeign investigationCirrus SR22 · Toussus-Le-Noble, FranceThe government of France has notified the NTSB of an accident involving a CIRRUS SR22 airplane that occurred on December 18, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of France's investigation under the provisions…NTSB DCA19WA047Incident · No injuriesForeign investigationBoeing 747 · Taipei, TaiwanThe ASC of Taiwan has notified the NTSB of an incident involving a Boeing 747 airplane that occurred on December 13, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the ASC of Taiwan's investigation under the provisions of ICAO Annex…NTSB DCA19WA044Incident · No injuriesForeign investigationBoeing 737 · Tijuana, MexicoThe DGAC of Mexico has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on December 12, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the DGAC's investigation under the provisions of ICAO Annex 13 as…NTSB ENG19RA007Incident · No injuriesForeign investigationAirbus A330 · Brussels, BelgiumThe Air Accident Investigation Unit of Belgium has notified the NTSB of a serious incident involving an Airbus A330-223 that occurred on December 11, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the Air Accident Investigation Unit…NTSB DCA19WA043Accident · No injuriesForeign investigationBoeing 777 · Hong Kong, Hong Kong SAR ChinaThe Air Accident Investigation Authority (AAIA) of Hong Kong has notified the NTSB of an accident involving a Boeing 777-300ER, which occurred on December 11, 2018. The NTSB has appointed a U.S Accredited Representative to assist under the provisions of ICAO…NTSB ENG19WA011Incident · No injuriesForeign investigationAirbus A320 · Jaipur, IndiaThe government of India has notified the NTSB of an incident involving a AIRBUS A320 airplane that occurred on December 10, 2018. An Indigo Airbus A320 experienced an ECAM warning for 'Lavatory Smoke' while descending through FL170 to land Kolkata Airport…NTSB CEN19WA102Accident · 3 fatalForeign investigationCirrus SR22 · Beauberry, FranceThe government of France has notified the NTSB of an accident involving a Cirrus SR22 airplane that occurred on December 10, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of France's investigation under the provisions…NTSB WPR19WA040Accident · 1 fatalForeign investigationPilatus BN2A-20 · Hobart, AustraliaOn December 7, 2018, at 0929 Universal Time Coordinated, a Pilatus Britten-Norman Ltd, BN2A-20, VH-OBL was destroyed when it collided with terrain near the Hobart Aerodrome, Hobart, Australia. The pilot, who was the sole occupant was fatally injured. The…NTSB CEN19WA043Accident · 2 fatalForeign investigationCessna 177 · Spain, SpainThe government of Spain has notified the NTSB of an accident involving a CESSNA 177 airplane that occurred on December 07, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Spain's investigation under the provisions of…NTSB DCA19CA034Accident · Serious injuriesClass 4 · Data collectionFinal reportBoeing 767 · SUNNS intersection, Osaka, JapanThe airplane’s encounter with severe turbulence.NTSB CEN19WA040Accident · 4 fatalForeign investigationCessna U206 · Culiacan, Sinaloa, MexicoNTSB ERA19WA089Accident · No injuriesForeign investigationEmbraer EMB720 · Almeirim, BrazilThe government of Brazil has notified the NTSB of an accident involving a Embraer EMB720 airplane that occurred on December 02, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the…NTSB ERA19WA087Accident · 2 fatalForeign investigationCessna 210 · São Paulo, BrazilThe government of Brazil has notified the NTSB of an accident involving a Cessna 210 airplane that occurred on November 30, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions…NTSB WPR19WA033Accident · Serious injuriesForeign investigationCessna U206 · Machadodorp, South AfricaOn November 29, 2018, about 1606 universal coordinated time, a Cessna U206D airplane, South African registration ZS-DIV, impacted terrain near the Skoonman Kloff in the Machadodorp area in Mpumalanga Province, South Africa. The pilot and 4 passengers were…NTSB GAA22WA262Accident · 1 fatalClass 5 · ForeignThrush S2R · Bataan, Costa RicaNTSB WPR19WA038Accident · No injuriesForeign investigationBell 407 GX · West Bangkala, IndonesiaOn November 28, 2018, about 0850 coordinated universal time, a Bell Helicopter 407 GX, PK-JPB, executed a precautionary landing following the illumination of the engine chip detector caution light near West Bangkala, Indonesia. There were no injuries to the…NTSB DCA19WA028Incident · No injuriesForeign investigationBoeing 737 · Manaus, BrazilThe government of Brazil has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on November 28, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions…NTSB ERA19WA058Accident · 4 fatalForeign investigationCessna 525 · Jequitaí County, BrazilThe government of Brazil has notified the NTSB of an accident involving a Cessna 525 airplane that occurred on November 26, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions…NTSB ENG19WA005Incident · No injuriesForeign investigationBoeing 767 · Addis Ababa, EthiopiaOn November 26, 2018, a Boeing 767-300 airplane, operated by Ethiopian Airlines, experienced a right engine (No. 2) fan blade failure during takeoff from the Addis Ababa Bole International Airport (ADD), Ethiopia. The airplane returned to ADD where an…NTSB DCA19WA068Incident · No injuriesForeign investigationBoeing 737 · Yogyakarta, IndonesiaThe National Transportation Safety Committee (KNKT) of Indonesia has notified the NTSB of an incident involving a Boeing 737, which occurred on November 25, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the KNKT investigation under…NTSB WPR19WA032Accident · 1 fatalForeign investigationRobinson R22 · Alice Springs, AustraliaOn November 24, 2018, at 1200 local time, a Robinson R22 BETA, VH-KZV, collided with terrain near Alice Springs, NT, Australia. The helicopter sustained substantial damage. The pilot sustained serious injuries and the passenger was fatally injured. The flight…NTSB ERA19WA104Accident · 6 fatalForeign investigationAgusta AW109 · Campos do Jordao, BrazilThe government of Brazil has notified the NTSB of an accident involving a Agusta AW109 helicopter that occurred on November 24, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the…NTSB WPR19WA081Accident · 5 fatalForeign investigationCessna U206 · Chemajenjera Hill, ZimbabweOn November 23, 2018, about 0530 coordinated universal time, a Cessna U206C airplane, Z-BRS, was destroyed when it impacted terrain near Chemajenjera Hill, Zimbabwe. The pilot and four passengers were fatally injured. The airplane was operated under the…NTSB ERA19WA054Accident · 5 fatalForeign investigationEurocopter EC120 · La Romana, Dominican RepublicThe government of Dominican Republic has notified the NTSB of an accident involving a Eurocopter EC120 helicopter that occurred on November 22, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Dominican Republic's…NTSB DCA19WA026Incident · No injuriesForeign investigationBoeing 737 · La Paz, BoliviaThe AIG of Bolivia has notified the NTSB of an accident involving a Boeing 737 airplane that occurred on November 22, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the AIG of Bolivia's investigation under the provisions of ICAO Annex…NTSB ERA19WA053Accident · 2 fatalClass 5 · ForeignCessna TU206 · Puente Alto, ChileNTSB ERA19WA075Accident · 2 fatalForeign investigationCessna 172 · Denizli, TürkiyeThe government of Turkey has notified the NTSB of an accident involving a CESSNA 172 airplane that occurred on November 19, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Turkey's investigation under the provisions…NTSB GAA19WA419Accident · 2 fatalForeign investigationSocata TB20 · Dinard Pleurtuit, FranceThe government of France has notified the NTSB of an accident involving a SOCATA TB20 airplane that occurred on November 17, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of France's investigation under the provisions…NTSB DCA21WA112Incident · No injuriesClass 5 · ForeignBoeing 737 · Buenos Aires, ArgentinaNTSB ERA19WA045Accident · No injuriesForeign investigationPiper PA25 · Ezperanza, Dominican RepublicThe government of the Dominican Republic has notified the NTSB of an accident involving a PIPER PA25 airplane that occurred on November 14, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of the Dominican Republic's…NTSB DCA19WA224Occurrence · No injuriesClass 5 · ForeignBoeing 737 · Hong Kong, China