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.
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
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 CEN19WA294Accident · 1 fatalForeign investigationAir Tractor AT400 · Namiquipa, MexicoThe government of Mexico has notified the NTSB of an accident involving a AIR TRACTOR AT400 airplane that occurred on July 27, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the…NTSB CEN19WA291Accident · No injuriesForeign investigationSikorsky S76 · Vigo, SpainOn July 26, 2019, about 2130 coordinated universal time, a Sikorsky S76 C+, EC-JES, impacted terrain at the Vigo Airport (LEVX), Vigo, Spain. The accident investigation is under the jurisdiction and control of the government of Spain. This report is for…NTSB ANC19WA043Accident · 4 fatalForeign investigationCessna 208 · Bella Bella, CanadaOn July 26, 2019, about 1100 pacific daylight time, a Canadian registered Cessna 208 airplane, C-GURL, owned and operated by Seair Seaplanes Ltd., was destroyed when it collided with terrain in the vicinity of Addenbroke Island, British Columbia (BC), Canada,…NTSB ENG19IA029Incident · No injuriesClass 3 · IncidentFinal reportAirbus A220 · Perrigny-sur-Armançon, FranceA No. 1 (left) engine low pressure compressor (LPC) stage 1 integrally bladed rotor (IBR) separation due to a high cycle fatigue crack (HCF) that originated at the runout of an airfoil leading edge root radius. The HCF crack developed as a result of a…NTSB GAA19WA458Incident · No injuriesForeign investigationSikorsky S92 · Sable Island, CanadaThe government of Canada has notified the NTSB of an accident involving a SIKORSKY S92 helicopter that occurred on July 24, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Canada's investigation under the provisions…NTSB WPR19WA203Accident · No injuriesForeign investigationRIchards Heavylift UH-1H · Limpopo Province, South AfricaOn July 23, 2019, about 1107 coordinated universal time, a Richards Heavylift Helo Inc., UH-1H, South African registration ZS-HLJ, operated for fire fighting, and equipped with a Textron Lycoming T-53 engine, reported a loss of engine power near Woodbush…NTSB WPR19WA199Accident · 1 fatalForeign investigationCessna 172 · Cangkring, IndonesiaOn July 22, 2019, about 0810 coordinated universal time, a Cessna 172 airplane, PK-WUG, impacted a river and sunk under unknown circumstances about 2.5 nautical miles northeast of Cangkring, Indonesia. One pilot was seriously injured, and the second was…NTSB OPS19WA018Incident · No injuriesForeign investigationAirbus A321 · London, United KingdomThe Air Accidents Investigation Branch (AAIB) of the United Kingdom has notified the NTSB of an incident involving an Airbus A-321-231, which occurred on July 22, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation…NTSB ERA19WA236Accident · 2 fatalForeign investigationRobinson R66 · Gorgona Island, ItalyThe government of Italy has notified the NTSB of an accident involving a ROBINSON R66 helicopter that occurred on July 22, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Italy's investigation under the provisions of…NTSB ENG19WA036Incident · No injuriesForeign investigationAirbus A330 · Islamabad, PakistanThe Aircraft Accident Investigation Board (AAIB) of Pakistan has notified the NTSB of an incident involving an Airbus A330-200 airplane which occurred on July 22, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation…NTSB GAA19WA460Accident · 1 fatalForeign investigationDe Havilland DH82 · Hythe, United KingdomNTSB GAA19WA444Accident · 1 fatalForeign investigationCirrus SR22 · Leutasch, Austria, AustriaThe government of Austria has notified the NTSB of an accident involving a CIRRUS SR22 airplane that occurred on July 18, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Austria's investigation under the provisions of…NTSB GAA19WA455Incident · No injuriesForeign investigationCirrus SR22 · Kolding, DenmarkThe government of Denmark has notified the NTSB of an accident involving a CIRRUS SR22 airplane that occurred on July 17, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Denmark's investigation under the provisions of…NTSB GAA19WA441Accident · 7 fatalForeign investigationDe Havilland DHC2 · Mistastin Lake, NL, CanadaThe government of Canada has notified the NTSB of an accident involving a DE HAVILLAND DHC2 airplane that occurred on July 15, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Canada's investigation under the…NTSB ENG19WA043Incident · No injuriesForeign investigationAirbus A320 · Goa, IndiaThe government of India has notified the NTSB of an incident involving an Airbus A320 airplane that occurred on July 15, 2019. An IndiGo Air Airbus A320-271N Neo powered by two Pratt & Whitney PW1127G-JM geared turbofan engines experienced a No. 1 (left)…NTSB GAA19WA420Accident · 9 fatalForeign investigationAIRvan GA8 · Umea, SwedenThe government of Sweden has notified the NTSB of an accident involving a AIRvan GA8 airplane that occurred on July 14, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Sweden's investigation under the provisions of…NTSB ANC19WA041Accident · 2 fatalForeign investigationRobinson R22 · Moscow, RussiaOn July 14, 2019, at 1551 Moscow time, a Russian registered Robinson R-22M helicopter was destroyed after impacting terrain after takeoff from the Shevlino landing site, Moscow region, Russian Federation. The helicopter was privately owned and operated. The…NTSB GAA19WA442Accident · 2 fatalForeign investigationSteen Skybolt · Enconada, BoliviaThe government of Bolivia has notified the NTSB of an accident involving an amateur-built STEEN Skybolt airplane that occurred on July 13, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Bolivia's investigation under…NTSB GAA19WA417Accident · 3 fatalForeign investigationDe Havilland DHC2 · Chibogamau, CanadaThe government of Canada has notified the NTSB of an accident involving a DE HAVILLAND DHC2 airplane that occurred on July 12, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Canada's investigation under the…NTSB ERA19WA237Accident · 2 fatalForeign investigationPiper PA28 · Atibaia, BrazilThe government of Brazil has notified the NTSB of an accident involving a Piper PA-28-140 airplane that occurred on July 12, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions…NTSB DCA19WA177Incident · No injuriesForeign investigationBoeing 737 · Kiev, UkraineThe NBAAI of Ukraine has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on July 12, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the NBAAI's investigation under the provisions of ICAO Annex 13 as…NTSB GAA19WA478Accident · No injuriesForeign investigationBeech C90 · Bucaramanga, ColombiaNTSB GAA19WA459Accident · 2 fatalForeign investigationDe Havilland DHC2 · Hawk Junction ON-Canada, CanadaThe government of Canada has notified the NTSB of an accident involving a DE HAVILLAND DHC2 airplane that occurred on July 11, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Canada's investigation under the…NTSB DCA19WA184Incident · No injuriesForeign investigationBoeing 737 · San Jose, Costa RicaThe CETAC of Costa Rica has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on July 11, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the CETAC's investigation under the provisions of ICAO Annex 13 as…NTSB WPR19WA211Accident · 1 fatalForeign investigationCessna 172 · Anji, ChinaOn July 10, 2019, at an unknown time, a Cessna 172S, B-10NH, was substantially damaged when it collided with the ground near Anji, Zhejiang, China. One person on board was fatally injured, one sustained serious injury, and one is being assessed. The airplane…NTSB ENG19WA040Accident · Minor injuriesForeign investigationAir Tractor AT301 · Airdrome Jorge Efrain, MexicoOn July 10, 2019, an Air Tractor AT-301, registration XB-GBA, powered by a Pratt & Whitney R1300 radial engine, operator by the owner stuck power cables and crashed during a local flight . The Mexican Direccion De Analisis de Accidentes E Incidentes De…NTSB CEN19WA337Accident · 2 fatalForeign investigationRobinson R44 · Mt Tremblank, CanadaThe government of Canada has notified the NTSB of an accident involving a Robinson R-44 helicopter, Canadian registration C-FJLH, that occurred on July 10, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Canada's…NTSB DCA19WA183Incident · No injuriesForeign investigationBoeing 747 · Harare, ZimbabweThe CAA of Zimbabwe has notified the NTSB of an incident involving a Boeing 747 airplane that occurred on July 09, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the CAAZ's investigation under the provisions of ICAO Annex 13 as State…NTSB CEN19WA338Incident · No injuriesForeign investigationGulfstream Gulfstream GVI · Waterford, IrelandOn July 7, 2019, about 1645 coordinated universal time, a Gulfstream GVI airplane, EI-JSK, had an uncommanded engine shutdown in flight near Waterford, Ireland. The flight departed from and returned to Shannon Airport. The flight was destined for Farnborough…NTSB GAA19WA592Accident · No injuriesForeign investigationBeech B36 · Mexico, MexicoThe government of Mexico has notified the NTSB of an accident involving a BEECH B36 airplane that occurred on July 05, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions of…NTSB CEN19WA208Accident · 1 fatalForeign investigationPiper PA-24-250 · Quetzaltenango, GuatemalaThe government of Guatemala has notified the NTSB of an accident involving a PIPER PA-24-250 airplane that occurred on July 05, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Guatemala's investigation under the…NTSB ERA19FA210Accident · 7 fatalClass 2 · FieldFinal reportAgusta AW139 · Big Grand Cay, BahamasThe pilots’ decision to takeoff over water in dark night conditions with no external visual reference, which resulted in spatial disorientation and subsequent collision with the water. Also causal was the pilots’ failure to adequately monitor their…NTSB DCA19WA190Incident · No injuriesForeign investigationBoeing 777 · London, United KingdomThe Air Accident Investigation Branch (AAIB) of United Kingdom has notified the NTSB of an incident involving a BOEING 777 airplane that occurred on July 03, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of United…NTSB DCA19WA181Incident · No injuriesForeign investigationBoeing 777 · London, United KingdomThe AAIB of the United Kingdom has notified the NTSB of an incident involving a Boeing 777 airplane that occurred on July 03, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB's investigation under the provisions of ICAO Annex…NTSB DCA19WA176Incident · No injuriesForeign investigationBoeing 737 · Mumbai, IndiaThe AAIB of India has notified the NTSB of an accident involving a Boeing 737 airplane that occurred on July 02, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB's investigation under the provisions of ICAO Annex 13 as State of…NTSB CEN19WA197Accident · 2 fatalForeign investigationRans S6 · Rougemont, CanadaNTSB DCA19WA180Incident · No injuriesForeign investigationBoeing 737 · Mangalore, IndiaThe AAIB of India has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on June 30, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB's investigation under the provisions of ICAO Annex 13 as State of…NTSB ERA19WA207Accident · 4 fatalForeign investigationPiper PA 28-180 · Cabo Rojo, Dominican RepublicNTSB ENG19WA028Incident · No injuriesForeign investigationAirbus A320 · Delhi, IndiaThe government of India has notified the NTSB of an incident involving a AIRBUS A320 airplane that occurred on June 26, 2019. An Indigo Airbus A320 powered by two Pratt & Whitney PW1127G-JM geared turbofan engines experienced issues with the No. 1 (left)…NTSB GAA19WA386Accident · 2 fatalForeign investigationCessna 182 · Chimaltenango, GuatemalaNTSB CEN19WA255Accident · No injuriesForeign investigationCessna Cessna 441 · Glasgow, IrelandOn June 25, 2019, about 0800 coordinated universal time, a Cessna 441 airplane, EI-DMG, experienced a propeller strike during landing at the Glasgow Prestwick Airport.The accident investigation is under the jurisdiction and control of the Air Accidents…NTSB WPR19WA277Accident · No injuriesForeign investigationRobinson R22 · Kutchera Station, AustraliaOn June 22, 2019, at 0900 local time, a Robinson R22 helicopter, VH-HHQ, collided with terrain near Kutchera Station, Australia. The pilot was fatally injured and the helicopter was substantially damaged. The flight was conducted under the pertinent civil…NTSB CEN19WA288Accident · 2 fatalForeign investigationZenair CH601 · Pont-A-Celles, BelgiumThe government of Belgium has notified the National Transportation Safety Board (NTSB) of an accident involving a Zenair CH 601XL airplane that occurred on June 22, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of…NTSB CEN19WA200Accident · 1 fatalForeign investigationPiper PA28 · Mandal, NorwayOn June 22, 2019, about 1255 local time, a Piper PA28-161, registration NL-MTJ, impacted the sea about 11 miles south of Mandal, Norway, following a loss of engine power. One person was fatally injured, and two passengers received minor injuries. The Accident…NTSB DCA19WA173Incident · No injuriesForeign investigationBoeing 737 · Bandung, IndonesiaThe government of Indonesia has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on June 20, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Indonesia's investigation under the provisions…NTSB ENG19RA027Accident · No injuriesForeign investigationAerospatiale AS355 · Dryden, Ontario, CanadaThe Transportation Safety Board of Canada (TSB) has notified the NTSB of an accident involving an Aerospatiale AS355 F2 rotorcraft that occurred on June 19, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the TSB under the provisions…NTSB CEN19WA201Accident · Serious injuriesForeign investigationPiper PA28R · Pointe-A-Pitre, GuadeloupeNTSB DCA19WA174Incident · No injuriesForeign investigationBoeing 737 · Birmingham, United KingdomThe government of United Kingdom has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on June 18, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of United Kingdom's investigation under the…NTSB GAA19WA356Accident · 1 fatalForeign investigationPitts S2 · Saint-Jean-Port-Joli, CanadaNTSB ENG19WA039Accident · Minor injuriesForeign investigationAtr ATR42 · Manaus, BrazilThe government of Brazil has notified the NTSB of an accident involving a ATR 42-300 airplane that occurred on June 15, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions of…