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 CEN15WA248Accident · No injuriesForeign investigationPiper PA-28RT-201T · Grenchen, SwitzerlandNTSB WPR15WA172Accident · 1 fatalForeign investigationRobinson R22 - Beta · Mitchell, AustraliaOn May 28, 2015 about 1620 local time, a Robinson R-22 helicopter, Australian registration VH-HRW, collided with terrain near Mitchell, Queensland, Australia. The helicopter sustained substantial damage, and the pilot was fatally injured. The investigation is…NTSB DCA15WA127Incident · No injuriesForeign investigationBoeing 737 - 883 · Oslo, NorwayThe Accident Investigation Board Norway (AIBN) has notified the NTSB of an incident involving a Boeing 737-800, which occurred on May 27, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the AIBN investigation under the provisions of…NTSB CEN15WA254Accident · 2 fatalForeign investigationCessna T182 - T · Carlow, IrelandNTSB ANC15WA029Accident · 1 fatalForeign investigationAir Tractor AT802-A · Cold Lake, CanadaOn May 22, 2015, at 1630 mountain daylight time, a Canadian registered Air Tractor, AT-802A airplane, C-FDHV, operated by the Conair Group Inc., was destroyed when it collided with terrain under unknown circumstances during firefighting operations near Cold…NTSB CEN15WA390Accident · 2 fatalForeign investigationAvions Robin DR400 · Arras, FranceOn May 21, 2015 about 1245 UTC, a Robin DR400-140B airplane, French registration F-GBUP, impacted into a cultivated field near the Arras-Roclincourt Airport (LFQD), Arras, France. One pilot and a passenger were killed. Another pilot was seriously injured. The…NTSB CEN15WA234Accident · Serious injuriesForeign investigationHughes 369 · Bocognano, Corse-du-Sud, France, FranceOn May 18, 2015, about 0810 hours universal coordinated time, a Hughes model 369 helicopter, Finland registration OH-HNR, impacted terrain near Bocognano, Corse-du-Sud, France. The two crew members were seriously injured. The flight itinerary and purpose of…NTSB ERA15WA213Accident · 2 fatalForeign investigationCessna 182 · Bajo Hondo, ArgentinaOn May 13, 2015, about 1835 coordinated universal time (UTC), a Cessna 182, Argentine registration LV-CXM, impacted power lines while maneuvering during an aerial survey flight near Bajo Hondo, Argentina. The pilot and passenger were fatally injured, and the…NTSB DCA15WA126Incident · No injuriesForeign investigationBoeing 737 - 8FE · Christchurch, New ZealandThe Australian Transport Safety Bureau (ATSB) of Australia has notified the NTSB of an incident involving a Boeing 737-8FE, which occurred on May 11, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the ATSB investigation under the…NTSB ERA15WA223Accident · 1 fatalForeign investigationCessna 182J · Novo Progresso, BrazilOn May 9, 2015, about 1430 local time, a Cessna 182J, Brazilian registration PT-CND, was destroyed when it impacted the Baú River, near Novo Progresso, Pará State, Brazil. The Brazilian pilot was fatally injured. The flight, which originated at Novo Progresso…NTSB ANC15WA067Accident · 1 fatalForeign investigationKevin D. Yarnevich Kitfox · Surrey, CanadaNTSB ENG15WA022Incident · Minor injuriesForeign investigationBoeing 727-2F9 · Bogotá, Colombia, ColombiaOn May 6, 2015 at about 1215 coordinated universal time, a Boeing 727-200F, operated by Líneas Aéreas Suramericanas experienced an uncontained No.1 engine failure shortly after takeoff from El Dorado International Airport (SKBO), Bogotá, Colombia. The…NTSB ERA15WA216Accident · 1 fatalForeign investigationThrush S2R-T34 · Puebloviejo, EcuadorOn May 5, 2015, a Thrush Aircraft, Inc., S2R-T34, Ecuador registration HC-CBY, registered to and operated by Aerovic C.A., collided with terrain near Puebloviejo, Ecuador. Meteorological conditions and flight plan information are unknown for the flight from…NTSB CEN15WA221Accident · 2 fatalForeign investigationBeech Beech 95-B55 · Dundee, United KingdomOn May 3, 2015, at 1113 coordinated universal time, a Beech 95-B55 airplane, G-RICK, impacted terrain while on approach to the Dundee Airport (EGPN), Dundee, Scotland. The pilot and one passenger were fatally injured and the airplane was destroyed. Instrument…NTSB ENG15WA040Incident · No injuriesForeign investigationBell 407 · Morobe Province, Papua New GuineaOn May 2, 2015, a Bell Helicopters 407 powered by a Roll-Royce M250-C47B turboshaft experienced an unexpected uncommanded high rate of descent while on approach to the helipad with an external load of two diesel fuel drums. The pilot jettisoned his load and…NTSB DCA15WA178Incident · No injuriesForeign investigationBoeing Boeing 777-228 IGW · Douala, CameroonThe Bureau d'Enquêtes et d'Analyses pour la sécurité de l'aviation civile (BEA) has notified the NTSB of an incident involving a Boeing 777-200, which occurred on May 2, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the BEA…NTSB DCA15WA122Incident · No injuriesForeign investigationAirbus A321 - 211 · Barcelona, SpainThe Comision de Investigacion de Accidentes e Incidentes de Aviacion Civil (CIAIAC) has notified the NTSB of an incident involving an Airbus A321 and a Boeing 737-400 which occurred on April 28, 2015. The NTSB has appointed a U.S. Accredited Representative to…NTSB ERA15WA211Accident · Minor injuriesForeign investigationBell 430 · Aydin, TürkiyeOn April 26, 2015, at 1322 coordinated universal time, a Bell 430, Turkish-registered TC-HSZ, was substantially damaged following a hard landing near Aydin, Turkey. The pilot and co-pilot were not injured. Two passengers sustained minor injuries, and three…NTSB DCA15WA123Incident · No injuriesForeign investigationBoeing 737 - 8B6 · Madrid, SpainThe Director General of Civil Aviation of Morocco has notified the NTSB of an incident involving a Boeing 737-800 airplane, which occurred on April 23, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the Director General of Civil…NTSB DCA15WA115Accident · 2 fatalForeign investigationBell UH1H - NO Series · Bainskloof, South AfricaThe government of South Africa has notified the NTSB of an accident involving a BELL UH-1H helicopter that occurred on April 22, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the government of South Africa's investigation under the…NTSB CEN15WA208Accident · 1 fatalForeign investigationEdge 360 · Norfolk, United KingdomOn April 22, 2015, about 1340 coordinated universal time, an Edge 360 airplane, G-EDGJ, impacted terrain while performing aerobatic maneuvers near Norfolk, United Kingdom. The pilot was fatally injured. The accident investigation is under the jurisdiction and…NTSB ENG15RA023Incident · No injuriesForeign investigationBoeing 400 · Islamabad, Pakistan, PakistanOn April 21, 2015, a Shaheen Air International (SAI) Boeing 737-400, powered by CFMI CFM56-3C1 turbofan engines, experienced a No. 1 (left engine) failure while climbing through 3,200 feet. The flight crew heard a loud band and high exhaust gas temperature…NTSB ERA15WA195Accident · 7 fatalForeign investigationPiper PA-32-300 · Punta Cana, Dominican RepublicNTSB WPR15WA145Accident · 1 fatalForeign investigationBell 206 - B · Ziyang City, China, ChinaOn April 13, 2015, at 0800 local time, a Bell 206 BIII, B-7607, collided with a wire during an aerial application flight near Ziyang City, Sichuan Province, China. The helicopter was operated by Hubei Tongcheng General Aviation Ltd under the pertinent civil…NTSB ERA15RA199Accident · 2 fatalForeign investigationSwearingen SA226-TC · North Vancouver, CanadaOn April 13, 2015, at 0709 Pacific daylight time, a Swearingen SA226-TC, Canadian registration C-GSKC, operating as Carson Air flight 66, was destroyed in an area of mountainous terrain about 10 nautical miles north of North Vancouver, British Columbia. The…NTSB DCA15WA107Accident · No injuriesForeign investigationBoeing 737 - 804 · Khajuraho, IndiaThe Aircraft Accident Investigation Bureau (AAIB) of India has notified the NTSB of an accident involving a BOEING 737 that occurred on April 13, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB's investigation under the…NTSB ERA15WA182Accident · 3 fatalForeign investigationCessna 172S · Santander, ColombiaOn April 12, 2015, about 1915 coordinated universal time, a Cessna 172S, Colombian registration HK5064G, and a Cessna 150M, Colombian registration HK1912G, were substantially damaged after impacting mountainous terrain in the vicinity of the Serrania Los…NTSB DCA15WA156Incident · No injuriesForeign investigationBoeing Boeing 737-530 · Zurich, SwitzerlandThe BFU of Switzerland (BFU-CH) has notified the NTSB of an incident involving a Boeing 737-530 airplane that occurred on April 12, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the BFU-CH's investigation under the provisions of ICAO…NTSB ERA15WA193Accident · 1 fatalForeign investigationCessna 210L · Assuncao do Piaui, BrazilOn April 11, 2015, at 2200 coordinated universal time, a privately owned Cessna 201L, Brazilian registered PR-APG, was destroyed when it impacted terrain under unknown circumstances near Assuncao do Piaui Municipality, State of Piaui, Brazil. The pilot was…NTSB ERA15LA328Accident · No injuriesLimited investigationFinal reportGulfstream Aerospace G IV · Caribbean Sea, A1The in-flight failure of the cabin pressurization relief/safety valve (CPRV) due to an obstruction of the CPRV static port, which allowed the airplane to overpressurize. The reason for the initial overpressurization condition could not be determined.NTSB ENG15WA018Incident · No injuriesForeign investigationShort Brothers & Harland SC-7 Skyvan S3 · Klatovy, Czech Republic, CzechiaAn Austrian registered Shorts SC7 Skyvan, registration number OE-FDN, being operated by Pink Aviation Services Gmbh, suffered an uncontained failure of No.2 turbine wheel on RH engine during descend, resulting in damage to the right-hand forward sidewall fuel…NTSB DCA15WA113Accident · 6 fatalForeign investigationEurocopter AS365N3 · Jalan Sungai Lalang, Kampung Pasir baru, Semenyih, MalaysiaNTSB CEN15WA191Accident · 2 fatalForeign investigationPiper Piper PA-28-140 · Loch Etive, United KingdomOn April 4, 2015, at an unknown time, a United Kingdom registered Piper PA-28-140 airplane, G-BHXK,impacted mountainous terrain near Lock Etive, Oban, Argyll, and Bute, United Kingdom.The two occupants were fatally injured. The investigation is under the…NTSB DCA15WA211Accident · No injuriesForeign investigationAyres S2R · Penja, CameroonThe Cameroon Civil Aviation Authority (CCAA) has notified the NTSB of an accident involving a Ayres S2R-T34 airplane that occurred on April 01, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the CCAA's investigation under the…NTSB DCA15WA102Accident · No injuriesForeign investigationBoeing Boeing 737-8AS · Dublin, IrelandThe Air Accidents Investigation Unit f Ireland (AAIU-IE) has notified the NTSB of an accident involving a Boeing 737-8AS airplane that occurred on April 01, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the AAIU's investigation under…NTSB ERA15WA180Accident · 4 fatalForeign investigationBell 206 - L4 · Diego de Almagro, ChileOn March 31, 2015, about 2210 universal coordinated time (UTC), a Bell 206L4, Chilean registration CC-APP, operated by a private individual, was destroyed during a collision with power lines and a subsequent postcrash fire, while maneuvering near Diego de…NTSB CEN15WA193Accident · 2 fatalForeign investigationRans S6 - ES · Tan Rouge, RéunionOn March 30, 2015, about 0630 universal coordinated time (UTC), a Rans S6-ES airplane, French registration 974-GQ, impacted terrain near Tan Rouge, Reunion. The pilot and passenger on board were fatally injured. The airplane was destroyed. The local flight…NTSB ENG15WA026Accident · Minor injuriesForeign investigationAirbus A320 - 211 · Halifax, CanadaOn 29 March 2015, an Air Canada Airbus A320-200 aircraft (registration C-FTJP) clipped a power line and approach lights short of Runway 05 at the Halifax Stanfield International Airport. The Transportation Safety Board (TSB) of Canada is investigating the…NTSB CEN15WA186Accident · 1 fatalForeign investigationRobinson R44 - II · Modrava, CzechiaOn March 29, 2015, at 0920 universal coordinated time (UTC), a Robinson model R44 Raven II helicopter, Czech Republic registration OK-RRJ, serial number 12464, sustained substantial damage when it collided with wooded terrain within Šumava National Park, near…NTSB ERA15WA185Accident · 1 fatalForeign investigationAerospool Dynamic WT-9 · Cotopaxi Volcano, EcuadorOn March 28, 2015, about 1300 local time, an Aerospool Dynamic WT9, French registration F-JUKE, was destroyed when it impacted terrain on Cotopaxi Volcano, Cotopaxi Province, Ecuador. The Swiss pilot was fatally injured. The flight, which originated at…NTSB ENG15WA021Incident · No injuriesForeign investigationBoeing 737 - 683 · Oslo, NorwayOn March 25, 2015, at approximately 0730 Coordinated Universal Time (UTC), a Boeing 737-683, Norwegian registration LN-RPA, operated by Scandinavian Airlines System (SAS), experienced a pitch control problem while landing on Runway 01R at Oslo Airport,…NTSB DCA15WA106Incident · No injuriesForeign investigationBoeing Boeing 737-8AS · Lametia, ItalyThe ANSV of Italy has notified the NTSB of an accident involving a Boeing 737-8AS airplane that occurred on March 25, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the ANSV's investigation under the provisions of ICAO Annex 13 as the…NTSB DCA15WA103Incident · No injuriesForeign investigationBoeing 737 · Tarapoto, PeruThe CIAA of Peru has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on March 25, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the CIAA's investigation under the provisions of ICAO Annex 13 as the…NTSB DCA15WA093Accident · 152 fatalForeign investigationAirbus Industrie A320-211 · Barcellonette, FranceNTSB WPR15WA171Accident · Serious injuriesForeign investigationSikorsky S76 - C · East Kalimantan, IndonesiaOn March 21, 2015, about 1030 local time, a Sikorsky S-76C+ helicopter, registration PK-FUP, sustained substantial damage following an emergency landing near East Kalimantan, Indonesia. Reports indicate that the two pilots received serious injuries and five…NTSB ERA15WA167Accident · 2 fatalForeign investigationCessna TU206 - G · Mitu, ColombiaOn March 20, 2015, about 1805 coordinated universal time, a Cessna TU206G, Colombian registration HK-2327, was substantially damaged while ditching into the Vaupés River near the Fabio Alberto León Bentley Airport (SKMU), Mitú, Columbia. The pilot and a…NTSB ERA15RA163Accident · 10 fatalForeign investigationBeech B90 · Punta del Este, UruguayOn March 19, 2015, about 20:38 Local Time, a Beech Model B90 King Air, Argentine Registration LV-CEO, operated by Drogueria Meta, S.A., impacted water in Laguna del Sauce, Punta del Este, Uruguay. Night visual meteorological conditions prevailed, and flight…NTSB CEN15WA178Accident · 3 fatalForeign investigationPiper PA32RT - 300T · Sudbury, CanadaNTSB ERA15WA159Accident · 1 fatalForeign investigationPiper PA-34-200T · Macas, EcuadorOn March 15, 2015, at an unknown time, a Piper PA-34, Ecuadorian registration HC-CNC, impacted terrain under unknown circumstances shortly after takeoff from Edmundo Carvajal Airport, Macas, Ecuador. The pilot, the sole occupant, was fatally injured. The…NTSB DCA15WA097Incident · No injuriesForeign investigationBoeing 777-306er 300 · Bangkok, ThailandThe Aircraft Accident Investigation Committee of Thailand has notified the NTSB of an incident involving a Boeing 777-306ER that occurred on March 15, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the Aircraft Accident Investigation…