NTSB investigations, Outside the U.S.
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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 ERA18WA100Accident · 1 fatalForeign investigationBeech V35B · Brasilandia, Mato Grosso do Sul, BrazilThe government of Brazil has notified the NTSB of an accident involving a Beech V35B airplane that occurred on February 27, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions…NTSB CEN18WA111Incident · No injuriesForeign investigationCirrus Design SF50 · Nuuk, GreenlandOn February 26, 2018, about 1804 coordinated universal time, a Cirrus Design Corporation SF50 Vision Jet, serial number 0034, United States registration N3AD, sustained minor damage during landing roll on runway 23 at Nuuk Airport (BGGH), Nuuk, Greenland. The…NTSB WPR18WA123Accident · 2 fatalForeign investigationCessna T210N · Oudtshoorn, South AfricaNTSB ANC18WA035Accident · Serious injuriesForeign investigationBeech B100 · Abbotsford, CanadaOn February 23, 2018, about 1204 Pacific standard time, a twin engine, turbine-powered Beech King Air B100 airplane, Canadian registration C-GIAE, crashed shortly after takeoff from the Abbotsford International Airport, Abbotsford, British Columbia, Canada.…NTSB ERA18WA090Accident · 4 fatalForeign investigationNeiva EMB-720D · Manaus City, BrazilThe government of Brazil has notified the NTSB of an accident involving a NEIVA EMB-720D airplane that occurred on February 22, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the…NTSB DCA18WA226Accident · No injuriesForeign investigationMcdonnell Douglas MD83 · Omagwa, NigeriaThe Accident Investigation Bureau (AIB) of Nigeria has notified the NTSB of an accident involving a McDonnel Douglas MD-83, which occurred on February 20, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the AIB investigation under the…NTSB WPR18LA092Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Obyan, SarkThe pilot's inadequate preflight fuel planning and inadequate in-flight fuel monitoring which resulted in a total loss of engine power due to fuel exhaustion and an emergency landing and subsequent impact with a ditch.NTSB WPR18CA100Accident · Minor injuriesData collectionFinal reportHughes 369D · Pacific Ocean, Marshall IslandsAn in-flight mechanical malfunction with the helicopter, which necessitated a ditching in the ocean. The reason for the malfunction could be determined because the helicopter sank and was not recovered.NTSB DCA18WA136Incident · No injuriesForeign investigationBoeing 737 · Ballina/Byron Gateway Aerodome, AustraliaThe Australian Transport Safety Bureau (ATSB) has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on February 18, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's…NTSB DCA18WA135Incident · No injuriesForeign investigationAirbus A320 · abeam Cooma Aerodome, AustraliaThe Australian Transport Safety Bureau (ATSB) has notified the NTSB of an incident involving a AIRBUS A320 airplane that occurred on February 18, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's…NTSB CEN18WA103Accident · 3 fatalForeign investigationBeech 95B55 · Saint Laurent La Roche, FranceNTSB ERA18WA217Accident · 1 fatalForeign investigationCessna A188 · La Vega, Dominican RepublicThe government of the Dominican Republic has notified the NTSB of an accident involving a Cessna A188B airplane that occurred on February 14, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Dominican Republic's…NTSB DCA18RA093Incident · Minor injuriesForeign investigationAirbus A330 · Lagos, NigeriaThe AIB of Nigeria has notified the NTSB of an incident involving a Airbus A330 airplane that occurred on February 13, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the AIB of Nigeria's investigation under the provisions of ICAO…NTSB CEN18WA110Accident · 2 fatalForeign investigationCessna 182 · El Pozo, MexicoOn February 12, 2018, about 1815 coordinated universal time, a Cessna 182B airplane, Mexican registration XB-HRG, crashed in a field under unknown circumstances near El Pozo, Mexico. The pilot and passenger were fatally injured. The local flight originated…NTSB CEN18WA104Accident · 2 fatalForeign investigationBeech F33 · Bolderberg, BelgiumNTSB DCA18WA107Accident · 71 fatalForeign investigationAntonov AN148 · Argunovo, RussiaThe Russian Interstate Aviation Committee (MAK) has notified the NTSB of an accident involving a ANTONOV AN-148 airplane that occurred on February 11, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the MAK investigation under the…NTSB CEN18WA096Accident · 2 fatalForeign investigationPiper PA-28-161 · Helle, NorwayOn February 11, 2018, about 2000 UTC, a Piper Aircraft, Inc. PA-28-161 airplane, Norwegian registration LN-TOS, impacted the waters near the Svolvaer Airport (ENSH), Helle, Norway. The pilot and passenger on board were fatally injured and the airplane was…NTSB ERA18WA261Accident · Serious injuriesForeign investigationSkyrunner MK 3.2 · Margham, Dubai, United Arab EmiratesThe government of the United Arab Emirates has notified the NTSB of an accident involving a SkyRunner, MK-3.2 Powered Parachute that occurred on February 09, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of United Arab…NTSB ERA18WA108Accident · 1 fatalForeign investigationPiper PA25 · Ribeirao Cascalheira, BrazilThe government of Brazil has notified the NTSB of an accident involving a Piper PA-25-260 airplane that occurred on February 09, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the…NTSB ENG18WA013Incident · No injuriesForeign investigationBoeing 737-800 · Paris, FranceThe Bureau d'Enquêtes et d'Analyses pour la sécurité de l'aviation civile (BEA) of France has notified the NTSB of an accident involving a Boeing 737-800, which occurred on February 8, 2018. The NTSB has appointed a U.S. Accredited Representative to assist…NTSB ERA18WA085Accident · 3 fatalForeign investigationBeech F35 · Itaituba, BrazilThe government of Brazil has notified the NTSB of an accident involving a BEECH F35 airplane that occurred on February 07, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions of…NTSB ENG18RA015Incident · No injuriesForeign investigationBoeing 757 · Auckland, New ZealandThe Australian Transport Safety Bureau has notified the NTSB of an incident involving a Boeing 757-236, which occurred on February 5,2018. The NTSB has appointed a U.S. Accredited Representative to assist the Australian Transport Safety Bureau investigation…NTSB DCA18WA134Incident · No injuriesForeign investigationBoeing 717 · Melbourne, AustraliaThe Australian Transport Safety Bureau (ATSB) has notified the NTSB of an incident involving a BOEING 717 airplane that occurred on February 05, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's…NTSB DCA18WA122Incident · No injuriesForeign investigationBoeing 737 · IndonesiaThe government of Indonesia has notified the NTSB of an incidentt involving a BOEING 737-800 that occurred on February 05, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Indonesia's investigation under the provisions…NTSB ANC18WA023Accident · 6 fatalForeign investigationSikorsky UH-60M (S-70) · Lanyu, TaiwanThe foreign authority was the source of this information. On February 05, 2018, about 2352 local time, a Sikorsky UH-60M helicopter, NA-706, operated by National Airborne Service Corps. of the Ministry of Interior, Taiwan R.O.C., went missing and is presumed…NTSB CEN18WA134Accident · Minor injuriesForeign investigationBell 206 · Uetersen, GermanyOn April 2, 2018, at 0919 coordinated universal time, a Bell Helicopter 206, D-HHNC, experienced a loss of engine power while airborne.The accident investigation is under the jurisdiction and control of the German government. This report is for information…NTSB CEN18WA098Accident · 3 fatalForeign investigationRobinson R44 · St Joachim de Courval, CanadaOn February 2, 2018, about 0145 UTC, a Robinson R-44 helicopter, Canadian registry C-GYMG, owned and operated by a private operator, impacted in a field at St-Joachim-de-Courval, Quebec, Canada. A post impact fire ensued. The pilot and two passengers on board…NTSB DCA18WA133Incident · Minor injuriesForeign investigationAirbus A330 · Sydney, AustraliaThe Australian Transport Safety Bureau (ATSB) has notified the NTSB of an incident involving an amateur-built AIRBUS A330 airplane that occurred on February 01, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of…NTSB CEN18WA090Accident · No injuriesForeign investigationSikorsky S61 · Marchwood, New Hampshire, United KingdomOn February 1, 2018, a Sikorsky S-61N helicopter (G-ATBJ, s/n 6126930-439), pitched down and stuck the ground while hovering after takeoff near Marchwood, Hampshire in the United Kingdom. There was two persons on board, who were not injured. This…NTSB ERA18WA081Accident · 2 fatalForeign investigationReims F150L · Abrizzano di Negrar, ItalyThe government of Italy has notified the NTSB of an accident involving a Reims Aviation F150L airplane that occurred on January 31, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Italy's investigation under the…NTSB DCA18WA088Incident · No injuriesForeign investigationBoeing 757 23A · Tel Aviv, IsraelThe Israel's Ministry of Transport has notified the NTSB of an incident involving a Boeing 757, which occurred on January 30, 2018. The NTSB has appointed a U.S Accredited Representative to assist under the provisions of ICAO Annex 13, as the State of…NTSB ENG18RA012Incident · No injuriesForeign investigationEmbraer ERJ190 · Mar Del Plata, ArgentinaThe Junta de Investigacion de Accidentes de Avicion Civil (JIAAC) Republica Argentina has notified the NTSB of an incident involving an Embraer ERJ 190 which occurred on January 29, 2018. The NTSB has appointed a US Accredited Representative to assist the…NTSB CEN18WA105Incident · No injuriesForeign investigationSikorsky S-92A · Shetland, United KingdomOn January 14, 2018, about 1413 universal time (UTC), a United Kingdom registered Sikorsky S-92A, G-CHHF, experienced a nose landing gear (NLG) anomaly during landing at Scatsta Airport, Shetland, United Kingdom. The NLG did not extend during the approach to…NTSB CEN18WA091Accident · 1 fatalForeign investigationPiper PA25 · Mocorito, MexicoOn January 26, 2018, at 1930 UTC, a Piper PA25-150, XB-FBN, impacted terrain under unknown circumstances in the Community el Recoveco in Mocorito, Mexico. The aircraft was destroyed, and the pilot was fatally injured. The flight had departed airdrome "El…NTSB ANC18LA020Accident · No injuriesLimited investigationFinal reportEurocopter France SA330J Puma · Pacific Ocean, JapanThe worn rear bearing of the freewheel unit. Contributing to the accident was the delay in analyzing an oil sample, which would have detected the increase in metal contaminants from the worn bearing.NTSB WPR18WA083Accident · No injuriesForeign investigationGulfstream GULFSTREAM200 · Abuja, NigeriaOn January 25, 2018, at 1818 Universal Coordinated Time (UTC), a Nigerian registered Gulfstream G-200, 5N-BTF experienced a runway excursion during the landing rollout at Nnamdi Azikiwe International Airport (DNAA), Abuja, Nigeria. The airplane departed the…NTSB ENG18WA010Incident · No injuriesForeign investigationBoeing 737 · Lima, PeruOn January 25, 2018, a Peruvian Air Lines Boeing 737-530, registered in Peru as OB-2140P, had an uncommanded shutdown of the No. 2 engine, a CFMI CFM56-3B1, after leveling off at FL370. The flight crew declared an emergency and diverted back to Lima, Peru.…NTSB ERA18WA066Accident · 2 fatalForeign investigationRobinson R44 · Recife, BrazilThe government of Brazil has notified the NTSB of an accident involving a ROBINSON R44 helicopter that occurred on January 23, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the…NTSB CEN18WA120Accident · 4 fatalForeign investigationPiper PA-28RT-201T · Oberhausen-Rheinhausen, GermanyOn January 23, 2018, about 1207 coordinated universal time, a Piper PA-28 airplane, Swiss registration HB-PGF, collided with an Airbus-Helicopter EC135P2, German registration D-HDRV near Oberhausen-Rheinhausen, Germany. The pilots and passengers were all…NTSB WPR18WA067Accident · 1 fatalForeign investigationCessna 182 · Bridport, AustraliaOn January 20, 2018, at 1800 local time, a Cessna 182P, VH-TSA, collided with terrain near Bridport, Australia. The airplane sustained substantial damage. The pilot sustained serious injuries and the passenger was fatally injured. The flight was operated…NTSB CEN18WA081Accident · 1 fatalForeign investigationZodiac 601XL · Castellon, SpainOn January 19, 2018, about 0930 UTC, a Zodiac 601XL, Spanish registry EC-XKM, owned and operated by a private individual, impacted mountainous terrain in the municipality of La Pobla de Benifassa, Castellon, Spain. A postimpact fire ensued. The pilot was…NTSB ENG18WA011Incident · No injuriesForeign investigationAirbus A330 · Alice Springs, AustraliaOn January 18, 2018, about 14:25 Western Australian standard time, a Malaysian-registered Airbus A330-323 airplane had the No. 1 engine, a Pratt & Whitney PW4168A engine shutdown by the flight crew after it had compressor stalls. The airplane, which was…NTSB WPR18WA159Accident · Serious injuriesForeign investigationRobinson R44 · Ayers Rock, AustraliaOn January 17, 2018, at 1800 local time, a Robinson R44 helicopter, VH-HGX, experienced a partial loss of engine power shortly after takeoff. The pilot subsequently initiated an autorotation, landed hard and rolled over near Ayres Rock, Australia. The pilot…NTSB ERA18WA063Accident · 6 fatalForeign investigationPiper PA-23-250 · Nicholls Town, BahamasThe government of Bahamas has notified the NTSB of an accident involving a PIPER PA 23-250 airplane that occurred on January 17, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Bahamas's investigation under the…NTSB DCA18WA100Incident · No injuriesForeign investigationBoeing 737 · Auckland, New ZealandThe AAIB of New Zealand has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on January 17, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB of New Zealand's investigation under the provisions of…NTSB DCA18WA080Accident · No injuriesForeign investigationBoeing 737 · Trabzon, TürkiyeThe Turkish Accident Investigation Board (KAIK) has notified the NTSB of an accident involving a Boeing 737 which occurred on January 13, 2018. The NTSB has appointed a U.S Accredited Representative to assist under the provisions of ICAO Annex 13, as the…NTSB WPR18WA068Accident · No injuriesForeign investigationGulfstream GULFSTREAM200 · Albay, PhilippinesJanuary 10, 2018, at 1132 local time, a Gulfstream 200, RP-C280, was substantially damaged while landing at the Legazpi City Airport, Lagazpi, Albay, Philippines. The airplane was owned by the Asian Aerospace Corporation and operated under the pertinent civil…NTSB DCA18WA076Incident · No injuriesForeign investigationBoeing 737 · London, United KingdomThe Air Accidents Investigation Branch (AAIB) of the United Kingdom has notified the NTSB of an incident involving a Boeing 737, which occurred on January 10, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under…NTSB ERA18WA093Accident · 1 fatalForeign investigationAyres S2R · Jaramillo, EcuadorThe government of Ecuador has notified the NTSB of an accident involving a AYRES S2R airplane that occurred on January 9, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Ecuador's investigation under the provisions of…NTSB DCA18WA075Accident · No injuriesForeign investigationBoeing 737 · Toronto, CanadaThe Transportation Safety Board (TSB) of Canada has notified the NTSB of an accident involving a Boeing 737, which occurred on January 5, 2018. The NTSB has appointed a U.S Accredited Representative to assist under the provisions of ICAO Annex 13, as the…