NTSB investigations, 2019, Outside the U.S.

180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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 year(c.\"eventDate\") = 2019
    AND 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.

NTSB WPR19WA260Accident · 1 fatalForeign investigationAir Tractor AT502 · Gusap, Papua New GuineaOn August 29, 2019, an Air Tractor AT-502B aircraft, registered P2-SET, operated by Ramu Agriculture Industries, collided with a tree near Gusap, Papua New Guinea. The pilot was fatally injured and the airplane was destroyed. The Papua New Guinea (PNG)…Aug 29, 2019 · P2-SET · DestroyedNTSB ENG19RA033Incident · No injuriesForeign investigationSaab 340 · Merimbula, AustraliaThe Australian Transport Safety Bureau (ATSB) notified the NTSB of an incident involving a SAAB 340B airplane which occurred on August 29, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the ATSB investigation under the provisions of…Aug 29, 2019 · VH-RXX · No damageNTSB WPR19WA254Accident · No injuriesForeign investigationCessna 560 · Azligarh, IndiaOn August 27, 2019, at 0310 universal coordinated time, a Cessna 560 XL airplane, VT-AVV, collided with an electrical cable during the landing at the Aligarh Airport, Aligarh, India. The airplane was destroyed during the post crash fire. The airplane was…Aug 27, 2019 · VT-AVV · DestroyedNTSB DCA19WA211Accident · No injuriesForeign investigationAirbus A330 · Beijing, ChinaThe government of China has notified the NTSB of an incident involving a AIRBUS A330 airplane that occurred on August 27, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of China's investigation under the provisions of…Aug 27, 2019 · B-5958 · Substantial damageNTSB CEN19WA296Accident · Serious injuriesForeign investigationRobinson R44 · Veracruz, MexicoOn August 26, 2019, about 1700 hours universal coordinated time, a Robinson R-44 II helicopter, Mexican registration XB-GIL, was substantially damaged during an emergency landing in a field near Veracruz, Mexico. Two occupants were seriously injured; one…Aug 26, 2019 · XB-GILNTSB GAA19WA540Accident · 3 fatalForeign investigationRobinson R44 · Buriti Alegre, BrazilThe government of Brazil has notified the NTSB of an accident involving a ROBINSON R44 helicopter that occurred on August 25, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions…Aug 25, 2019 · PR-APN · DestroyedNTSB CEN19WA287Accident · 3 fatalForeign investigationPiper PA28RT · Simplon Pass, SwitzerlandThe government of Switzerland has notified the NTSB of an accident involving a Piper PA28RT airplane that occurred on August 25, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Switzerland's investigation under the…Aug 25, 2019 · G-BVDH · DestroyedNTSB CEN19WA283Accident · 7 fatalForeign investigationBell 206 · Inca, Mallorca, SpainOn June 25, 2019, about 1335 local time, a Bell 206L-3 helicopter, D-HOTT, and an Aeroprakt A22L airplane collided in mid-air, near Inca, Mallorca, Spain. The pilot and four passengers aboard the helicopter and the two people on the airplane, received fatal…Aug 25, 2019 · D-HOTT · 2 aircraft · DestroyedNTSB DCA19WA209Incident · No injuriesForeign investigationBoeing 777 · Shannon, IrelandThe AAIB of the United Kingdom has notified the NTSB of an incident involving a Boeing 777 airplane that occurred on August 24, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB's investigation under the provisions of ICAO Annex…Aug 24, 2019 · G-STBB · No damageNTSB CEN19WA286Accident · 2 fatalForeign investigationPitts S2 · Stonor Oxforshire, United KingdomThe government of United Kingdom has notified the NTSB of an accident involving a Pitts S2 airplane that occurred on August 24, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of United Kingdom's investigation under the…Aug 24, 2019 · G-ODDS · Substantial damageNTSB CEN19WA285Accident · 1 fatalForeign investigationRotorway Exec 162F · Herisau, SwitzerlandOn August 24, 2019, about 1400 universal coordinated time, a Rotorway Exec 162F helicopter, Swiss registration HB-YKJ, was destroyed when it crashed in a meadow during an autorotation and caught fire, about 3 miles south of Herisau, Switzerland. The pilot was…Aug 24, 2019 · HB-YKJ · Substantial damageNTSB GAA19WA532Accident · 4 fatalForeign investigationCessna 182 · Warintza, Morona Santiago, EcuadorThe government of Ecuador has notified the NTSB of an accident involving a CESSNA 182 airplane that occurred on August 23, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Ecuador's investigation under the provisions…Aug 23, 2019 · HC-CJN · DestroyedNTSB CEN19WA289Accident · 1 fatalForeign investigationCapella XS · San Juan del Puerto, SpainOn August 23, 2019, about 1905 hours universal coordinated time, an amateur-built Capella XS airplane, Spanish registration EC-YTA, impacted terrain after an inflight separation of a wing near San Juan del Puerto, Spain. The pilot was fatally injured, and the…Aug 23, 2019 · EC-YTA · Substantial damageNTSB CEN19WA284Accident · 1 fatalForeign investigationReims F172 · Schneizlreuth, GermanyThe government of Germany has notified the NTSB of an accident involving a REIMS F172 airplane that occurred on August 22, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Germany's investigation under the provisions…Aug 22, 2019 · D-ECSC · DestroyedNTSB CEN19WA282Accident · 1 fatalForeign investigationCessna 150 · Diepholz, GermanyOn August 22, 2019, at an 1120 UTC, a Cessna 150, D-EHLG, impacted with terrain in cornfield in Steinfeld, Germany. The pilot, the sole occupant, suffered fatal injuries and the airplane was destroyed. The flight had departed Flugplatz Diepholz-Dümmerland on…Aug 22, 2019 · D-EHLG · DestroyedNTSB ERA19WA261Accident · 3 fatalForeign investigationAgusta A109 · Poros, GreeceThe government of the Hellenic Republic, Greece, has notified the NTSB of an accident involving an Agusta A-109C helicopter that occurred on August 20, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Greece's…Aug 20, 2019 · SX-HTO · Substantial damageNTSB DCA19WA217Incident · No injuriesForeign investigationBoeing 737 · Cape Town, South AfricaThe CAA of South Africa has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on August 20, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the CAA of South Africa's investigation under the provisions of…Aug 20, 2019 · ZS-JRM · Minor damageNTSB ENG19WA044Incident · No injuriesForeign investigationAirbus A320 · Guwahati, IndiaThe government of India has notified the NTSB of an incident involving an Airbus A320 airplane that occurred on August 19, 2019. An IndiGo Air Airbus A320-271N Neo powered by two Pratt & Whitney PW1127G-JM geared turbofan engines experienced a No. 1 (left)…Aug 19, 2019 · VT-IVO · No damageNTSB DCA19WA201Incident · No injuriesForeign investigationBoeing 757 · Ponta Delgada, PortugalThe government of Portugal has notified the NTSB of an accident involving a Boeing 757 airplane that occurred on August 18, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Portugal's investigation under the provisions…Aug 18, 2019 · N543US · Minor damageNTSB ENG19WA032Incident · No injuriesForeign investigationAirbus A320 · Nassau, BahamasThe Air Accident Investigation Department (AAID) of the Bahamas has notified the NTSB of an incident involving an Airbus A320-212 that occurred on August 17, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB under the provisions…Aug 17, 2019 · N335NW · No damageNTSB CEN19WA341Accident · No injuriesForeign investigationCessna 150 · Ravna Gora, CroatiaThe government of Croatia has notified the NTSB of an accident involving a CESSNA 150 airplane that occurred on August 17, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Croatia's investigation under the provisions…Aug 17, 2019 · 9A-DMI · No damageNTSB WPR19WA274Accident · 2 fatalForeign investigationCessna 172 · Pretoria, South AfricaOn August 16, 2019, at 1810 universal coordinated time, a Cessna 172M, ZS-LMI, collided with terrain near Pretoria, South Africa. Both occupants were fatally injured and the airplane was substantially damaged. The airplane was being operated under the…Aug 16, 2019 · ZS-LMI · Substantial damageNTSB ENG19WA030Incident · No injuriesForeign investigationMcdonnell Douglas MD11 · Warsaw, PolandThe government of Poland has notified the NTSB of an incident involving a Boeing (McDonnel-Douglas) MD-11F operated by UPS and powered by three Pratt & Whitney PW 4460 turbofan engines. During cruise, the No. 2 engine (right) experienced fluctuations and…Aug 15, 2019 · N270UP · No damageNTSB DCA19WA203Accident · Serious injuriesForeign investigationBoeing 787 · Beijing, ChinaThe Japan Transport Safety Board (JTSB) has notified the NTSB of an accident involving a Boeing 797, which occurred on August 15, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the JTSB investigation under the provisions of ICAO Annex…Aug 15, 2019 · JA808A · No damageNTSB DCA19WA202Incident · Minor injuriesForeign investigationBoeing 767 · Shannon, IrelandThe AAIU of Ireland has notified the NTSB of an accident involving a Boeing 767 airplane that occurred on August 15, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Ireland's investigation under the provisions of ICAO…Aug 15, 2019 · N378AX · Minor damageNTSB CEN19WA272Incident · No injuriesForeign investigationReims Aviation Cessna F172N · Lesnovo, BulgariaOn August 14, 2018, about 0750 coordinated universal time, a Reims Aviation Cessna F172N airplane, Bulgarian registration number LZ-SPB, had a forced landing at the Lesnovo Airport (LBLS), Lesnovo, Bulgaria, following an inflight loss of engine power. The…Aug 14, 2019 · LZ-SPB · No damageNTSB ERA19WA270Accident · 3 fatalClass 5 · ForeignEmbraer EMB710 · Itaituba, BrazilAug 11, 2019 · PT-NKK · DestroyedNTSB DCA19WA197Incident · No injuriesForeign investigationBoeing 787 · Rome, ItalyThe government of Italy has notified the NTSB of an incident involving a BOEING 787 airplane that occurred on August 10, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Italy's investigation under the provisions of…Aug 10, 2019 · LN-LND · Minor damageNTSB CEN19WA274Accident · No injuriesForeign investigationBell 206 · Vuoggatjålme, SwedenOn August 10, 2019, about 0855 hours universal coordinated time, a Bell 206-L1, Swedish registration SE-JOA, was damaged when the rotor blades struck the tail boom during an emergency landing following a loss of engine power after takeoff near Vuoggatjålme,…Aug 10, 2019 · SE-JOA · Substantial damageNTSB WPR21WA102AccidentClass 5 · ForeignCessna 150 · Gan International Airport, MaldivesAug 9, 2019 · 8Q-GAC · Minor damageNTSB GAA19WA573Accident · Serious injuriesForeign investigationBeech 36 · Corse-du-Sud, FranceThe government of France has notified the NTSB of an accident involving a BEECH 36 airplane that occurred on August 09, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of France's investigation under the provisions of…Aug 9, 2019 · OO-JBM · DestroyedNTSB ENG19WA042Incident · No injuriesForeign investigationAirbus A320 · Varanasi, IndiaThe government of India has notified the NTSB of an incident involving an Airbus A320 airplane that occurred on August 9, 2019. An IndiGo Air Airbus A320-271N Neo powered by two Pratt & Whitney PW1127G-JM geared turbofan engines experienced a No. 2 (right)…Aug 9, 2019 · VT-IZT · No damageNTSB ERA19WA242Accident · No injuriesForeign investigationPiper PA34 · Bimini, BahamasThe government of Bahamas has notified the NTSB of an accident involving a Piper PA34 airplane that occurred on August 08, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Bahamas's investigation under the provisions…Aug 8, 2019 · N40702 · Substantial damageNTSB ENG19RA038Incident · No injuriesForeign investigationRaytheon 390 · Hamburg, GermanyOn August 7, 2019, about 1408 coordinated universal time (UTC), a Raytheon 390 Premier 1A airplane, Czech Republic registration OK-EJH, experienced smoke/fire in the cockpit from the windshield heat system during takeoff from Hamburg Airport, Hamburg,…Aug 7, 2019 · OK-EJH · Minor damageNTSB WPR19WA210Accident · 1 fatalForeign investigationLiberty Aerospace XL-2 · Braidwood, AustraliaOn August 6, 2019, at 0138 coordinated universal time, a Liberty Aerospace XL-2, registration VH-XLK, collided with terrain during a landing attempt near Braidwood, New South Wales, Australia. The pilot and sole occupant was fatally injured, and the airplane…Aug 6, 2019 · VH-XLK · Substantial damageNTSB GAA19WA533Accident · 1 fatalForeign investigationPiper PA25 · Totatlan, Jalisco, MexicoThe government of Mexico has notified the NTSB of an accident involving a PIPER PA25 airplane that occurred on August 06, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions of…Aug 6, 2019 · XB-TOP · DestroyedNTSB ANC19WA052Accident · 2 fatalForeign investigationCessna 208 · Mayo, CanadaThe government of Canada has notified the NTSB of an accident involving a CESSNA 208 airplane that occurred on August 06, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Canada's investigation under the provisions of…Aug 6, 2019 · C-FSKFNTSB GAA19WA583Accident · No injuriesForeign investigationCessna 560 · Aarhus airport, DenmarkThe government of Denmark has notified the NTSB of an accident involving a CESSNA 560 airplane that occurred on August 05, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Denmark's investigation under the provisions…Aug 5, 2019 · D-CAWM · DestroyedNTSB GAA19WA547Accident · No injuriesForeign investigationPiper PA28R · Sligo, IrelandThe government of Ireland has notified the NTSB of an accident involving a PIPER PA28R airplane that occurred on August 05, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Ireland's investigation under the provisions…Aug 5, 2019 · G-FBWH · Substantial damageNTSB ENG19WA031Incident · No injuriesForeign investigationAirbus A321 · Valencia, SpainThe government of Spain has notified the NTSB of an incident involving a AIRBUS A321 airplane that occurred on August 5, 2019 operated by British Airways. The airplane was powered by two International Aero Engines V2533-A5 turbofan engines. During landing, it…Aug 5, 2019 · G-MEDN · No damageNTSB CEN19WA256Accident · 1 fatalForeign investigationCessna A185 · Upper Raft Lake, CanadaAug 4, 2019 · C-GBUINTSB DCA19WA195Incident · No injuriesForeign investigationBoeing 737 · El Alto, BoliviaThe government of Bolivia has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on August 03, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Bolivia's investigation under the provisions…Aug 3, 2019 · CP-3077 · Minor damageNTSB WPR19WA234Accident · 3 fatalForeign investigationRobinson R44 · Korotasere, Cakaudrove, FijiOn August 2, 2019, about 1830 local time, a Robinson R44 Helicopter, DQ-HPT, impacted the ocean about 4 nautical miles east of Korotasere, Cakaudrove, Fiji under unknown circumstances. The commercial pilot and two passengers are presumed to be fatally…Aug 2, 2019 · DQ-HPTNTSB ERA19WA241Accident · 1 fatalForeign investigationCessna 510 · Los Angeles, ChileThe government of Chile has notified the NTSB of an accident involving a Cessna 510 airplane that occurred on August 2, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Chile's investigation under the provisions of…Aug 2, 2019 · CC-ANR · DestroyedNTSB CEN19WA301Accident · 2 fatalForeign investigationCessna TU206 · Guachochi, MexicoOn August 2, 2019, about 1600 universal coordinated time, a Cessna TU206G airplane, XB-FZN, impacted terrain near Guachochi, Mexico. The two people on board sustained fatal injuries. The accident investigation is under the jurisdiction and control of the…Aug 2, 2019 · XB-FZN · Substantial damageNTSB GAA19WA579Accident · No injuriesForeign investigationHughes 369 · Follebu, NorwayThe government of Norway has notified the NTSB of an accident involving a HUGHES 369 helicopter that occurred on August 01, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Norway's investigation under the provisions…Aug 1, 2019 · SE-JVJ · Substantial damageNTSB WPR19WA206Accident · 1 fatalForeign investigationBell 47G · Limpopo Province, South AfricaOn July 30, 2019, about 0900 coordinated universal time, a Bell 47G-3B-1 helicopter, ZS-HGY, impacted terrain following a total loss of engine power near Alldays, Limpopo Province, South Africa. The pilot was fatally injured, and the passenger was seriously…Jul 30, 2019 · ZS-HGY · Substantial damageNTSB CEN19WA268Accident · 1 fatalForeign investigationBeech V35 · Senneterre, Quebec, CanadaJul 30, 2019 · N3804X · DestroyedNTSB GAA19WA578Accident · No injuriesForeign investigationCirrus SR22 · Norrtalje, Stickhome, SwedenThe government of Sweden has notified the NTSB of an accident involving a CIRRUS SR22 airplane that occurred on July 29, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Sweden's investigation under the provisions of…Jul 29, 2019 · D-EPFH · Substantial damageNTSB WPR19WA208Accident · Serious injuriesForeign investigationVans RV6 · Williams Creek, AustraliaOn July 28, 2019, at 0537 coordinated universal time, a Van's RV-6A , registration VH-ANU, experienced a collapse of the nose landing gear, nosed over and came to rest near William Creek, Southern Australia. The pilot and passenger were seriously injured, and…Jul 28, 2019 · VH-ANU · Substantial damage