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 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…NTSB DCA19WA175Incident · No injuriesForeign investigationBoeing 737 · Lagos, NigeriaThe government of Nigeria has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on June 15, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Nigeria's investigation under the provisions of…NTSB GAA19WA341Accident · 2 fatalForeign investigationCessna 172 · Sailagouse, France, FranceThe government of France has notified the NTSB of an accident involving a CESSNA 172 airplane that occurred on June 13, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of France's investigation under the provisions of…NTSB CEN19WA342Accident · 2 fatalForeign investigationBRM Aero Bristell NG5 · Belan, IrelandThe government of Ireland has notified the NTSB of an accident involving an amateur-built BRM Aero Bristell NG5 airplane that occurred on June 13, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Ireland's…NTSB ANC19WA025Accident · No injuriesForeign investigationCirrus SR20 · Yeosu, South KoreaThe government of Korea has notified the NTSB of an accident involving a CIRRUS SR20 airplane that occurred on June 13, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Korea's investigation under the provisions of…NTSB CEN19WA273Accident · No injuriesForeign investigationAgustaWestland AW139 · Albarracín, SpainOn June 12, 2019, about 1330 local time, an AgustaWestland AW139 helicopter, EC-NEH, executed an emergency landing to an open field near Albarracín, Spain, for unknown reasons. The pilot and sole occupant sustained no injury, and the helicopter sustained…NTSB DCA19WA163Accident · No injuriesForeign investigationCasa C212 · Kuinga, KenyaThe Ministry of Transport of the Republic of Kenya has notified the NTSB of an accident involving a CASA 212, which occurred on June 11, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the investigation under the provisions of ICAO…NTSB GAA19WA597Accident · No injuriesClass 4 · ForeignPiper PA28 · Buenos Aires, ArgentinaNTSB GAA19WA391Accident · 3 fatalForeign investigationPiper PA23 · Mulakot, IcelandNTSB GAA19WA541Accident · No injuriesForeign investigationCessna C 680 · Salta, ArgentinaThe government of Argentina has notified the NTSB of an accident involving a CESSNA C 680 airplane that occurred on July 17, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Argentina's investigation under the…NTSB GAA19WA414Incident · No injuriesForeign investigationCessna 207 · Birtingarholt, Iceland