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 DCA16WA080Accident · 3 fatalForeign investigationCessna 425 · Windhoek, NamibiaThe Namibia Directorate of Aircraft Accident and Incident Investigation (DAAII) has notified the NTSB of an accident involving a Cessna 425 airplane that occurred on January 29, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the…NTSB DCA16WA076Accident · Minor injuriesForeign investigationMcdonnell Douglas MD80 · Mashad, IranThe government of Iran has notified the NTSB of an accident involving a McDonnell Douglas MD80 airplane that occurred on January 28, 2016. The NTSB has appointed a U.S. Accredited Representative in accordance with the provisions of ICAO Annex 13 as the State…NTSB ERA16WA096Accident · 5 fatalForeign investigationMcdonnell Douglas MD-600 · Taldykorgan, KazakhstanOn January 27, 2016, about 1747 local time, a McDonnell-Douglas MD-600N helicopter, Kazakhstan registration UP-MD004, registered to LLP Svinestroy and operated by JSC Aspan, impacted terrain under unknown circumstances after requesting to air traffic control…NTSB ENG16RA024Incident · No injuriesForeign investigationAirbus A320 · Suvarnabhumi Airport, ThailandThe Aircraft Accident Investigation Committee of Thailand has notified the NTSB of an incident involving an A320-232 that occurred January 25, 2016. The NTSB has appointed a U.S. Accredited Representative to assist in the investigation under the provisions of…NTSB WPR16WA191Accident · No injuriesForeign investigationVans RV8 · Chiang Mai, ThailandOn January 24, 2016, about 1030 local time, a Van RV-8, HS-GMC, initiated a forced landing near Chiang Mai, Thailand after experiencing a total loss of engine power during cruise flight. The owner/pilot, and one passenger, were not injured; the airplane…NTSB CEN16WA165Accident · Serious injuriesForeign investigationDiamond DA42 · Vasteras, SwedenOn January 22, 2016, at 1807 universal coordinate time, a Diamond DA42, Swedish registration SE-LVR, operated by Airways Flygutbildning, collided with the terrain in Vasteras, Sweden, following a loss of control. The flight instructor, the pilot receiving…NTSB CEN16WA099Accident · No injuriesForeign investigationEnstrom 280 · Buttwil, SwitzerlandOn January 22, 2016, about 0845 hours universal coordinated time, an Enstrom model 280C helicopter, Swiss registration HB-XLS, sustained damage to the tail rotor control system before liftoff from the Buttwil Airfield (LSZU), Buttwil, Switzerland. The pilot…NTSB ERA16WA095Accident · 6 fatalForeign investigationAir Tractor AT401 · Londrina, BrazilOn January 20, 2016, about 1910 universal coordinated time, an Air Tractor AT401B, Brazilian registration PT-WFX, was destroyed by collision with a motor vehicle and terrain in Londrina Municipality, State of Parana, Brazil. The Brazilian certificated pilot…NTSB CEN16WA113Accident · No injuriesForeign investigationCirrus Design Cirrus SR20 · Swansea, United KingdomOn January 20, 2016, at 1419 coordinated universal time, a Cirrus SR20, G-GCDC, collided with a parked Piper PA-31-112, G-BLWP, while landing at the Swansea Airport (EGFH), Swansea, Wales. The pilot and two passengers were not seriously injured. The Piper…NTSB DCA16WA095Incident · No injuriesForeign investigationBoeing 737 · Kiev, UkraineThe National Bureau of Air Accident Investigation (NBAAI) of Ukraine has notified the NTSB of an accident involving a Boeing 737 airplane that occurred on January 16, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the NBAAI's…NTSB CEN16WA088Accident · 4 fatalForeign investigationSocata TB20 · Cuenca, Spain, SpainOn January 16, 2016, about 1532 coordinated universal time, a Socata TB-20 single engine airplane, serial number 747, registry EC-ESK, was destroyed after impacting terrain near Cuenca, Spain, during cruise flight. The pilot and three passengers were fatally…NTSB ERA16WA099Incident · No injuriesForeign investigationCessna 550 · Istanbul, TürkiyeOn January 15, 2016, at 1103 Universal Coordinated Time (UTC), a Cessna 550 Citation I, Turkish registration TC-AHE, operated by Panjet, received minor damage during taxi after landing at Istanbul Atatürk Airport, Instanbul, Turkey (LTBA). The flight…NTSB CEN16WA148Accident · No injuriesForeign investigationCessna 402 · Leicestershire, United KingdomThe Air Accidents Investigation Branch (AAIB) United Kingdom has notified the NTSB of an accident involving a Cessna 402B, Registration G-MAPP, that occurred on January 14, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB…NTSB DCA16WA083Incident · No injuriesForeign investigationBoeing 777 · Lisbon, PortugalThe government of Portugal has notified the NTSB of an incident involving a Boeing 777 airplane that occurred on January 13, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of Portugal's investigation under the…NTSB ENG16WA008Incident · No injuriesForeign investigationBoeing 767 · Lima, PeruOn January 11, 2016, a Boeing 767-316ER, powered by two General Electric CF6-80C2B6F turbofan engines experienced an inflight uncommnaded shutdown of the right engine. The engine was successfully restarted and the flight continued to its intended destination.…NTSB DCA16RA045Accident · 2 fatalForeign investigationBombardier CL600 2B19 · Kiruna, SwedenimportNTSB ERA16WA088Accident · 2 fatalForeign investigationCessna T188 · Bom Jesus de Goiás, BrazilOn January 7, 2016, about 1900 coordinated universal time, a Cessna T188C, Brazilian registration PR-INS, operated by Blitz Comercio e Representacoes Ltda, was destroyed when it impacted terrain while spraying insecticides on a sugar cane plantation in Bom…NTSB DCA16WA079Incident · No injuriesForeign investigationBoeing 737 · Gran Canaria, SpainThe Comisión de Investigación de Accidentes e Incidentes de Aviación Civil (CIAIAC) of Spain has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on January 07, 2016. The NTSB has appointed a U.S. Accredited Representative to…NTSB DCA16WA042Incident · No injuriesForeign investigationBoeing 737 · Cluj-Napoca, RomaniaThe government of Romania has notified the NTSB of an incident involving a Boeing B737-400 airplane that occurred on January 07, 2016. The NTSB has appointed a U.S. Accreditd Representative to assist the government of Romania's investigation under the…NTSB DCA16WA047Incident · No injuriesForeign investigationSwearingen SA226 · Saarbrucken, GermanyThe Bundesstelle für Flugunfalluntersuchung (BFU) of Germany has notified the NTSB of an incident involving a Swearingen SA226 airplane that occurred on January 06, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the BFU investigation…NTSB CEN16WA074Accident · 1 fatalForeign investigationCirrus SR20 · Egmond, NetherlandsOn January 4, 2016, about 1356 UTC, a Cirrus Design, Incorporated SR-20, United Kingdom registration G-ZOGT, owned by a private individual, was destroyed when it impacted into the North Sea near Egmond aan Zee, The Netherlands, under unknown circumstances.…NTSB ERA16WA083Accident · 2 fatalForeign investigationBeech C90 · Parati, BrazilOn January 3, 2016, about 1730 Coordinated Universal Time (UTC), a Beech C90GTi, PP-LMM, registered to Bradesco Leasing S.A., operated by Supermercado Shibata Ltda, experienced controlled flight into mountainous terrain near Parati Airport (SDTK), Parati,…NTSB WPR16WA052Accident · No injuriesForeign investigationPiper PA34 · Seletar Airport, Singapore, SingaporeOn January 1, 2016, at 1624 local time, a Piper PA-34, 9M-RBI, operated by a private operator under the pertinent civil regulations of the government of Singapore, was substantially damaged when the airplane landed at the Seletar Airport, Singapore, with the…NTSB ERA16WA081Accident · Serious injuriesForeign investigationBell 429 · Rostov-na-Dony, RussiaSubject: ERA16WA081 Bell 429, RA-01617, Rostov-na-Dony, Russia On January 1, 2016, about 0621 universal coordinated time, a Bell 429, Russian registration RA-01617, was substantially damaged by collision with terrain during an uncontrolled descent following a…NTSB DCA16WA040Incident · No injuriesForeign investigationBoeing 777-333ER · Calgary, CanadaThe NTSB was notified of an incident involving a Boeing B777-333 aircraft, registration C-FRAM, that occurred enroute from Shanghai, China to Toronto, Canada, which resulted in the flight being diverted to Calgary, Canada. The incident is being investigated…NTSB CEN16WA081Incident · No injuriesForeign investigationCessna 172RG · Cascais, PortugalNTSB CEN16WA072Accident · 1 fatalForeign investigationMooney M20K · Mascouche, CanadaOn December 28, 2015, about 2227 universal coordinated time, a Canadian registered Mooney M20K, C-GUXC, impacted terrain while attempting to land at Mascouche (CSK3), Quebec, Canada. The pilot was fatally injured and the passenger was seriously injured. The…NTSB CEN16WA071Accident · 2 fatalForeign investigationSocata TB9 · Malaga, SpainThe Comisión De Investigación De Accidentes E Incidentes De Aviación Civil (CIAIAC) of Spain has notified the NTSB of a fatal accident involving a Socata TB-9 airplane, EC-LIQ, that occurred on December 24, 2015. The NTSB has appointed a U.S. Accredited…NTSB DCA16WA048Incident · No injuriesForeign investigationBoeing 737 · Gwangju-Si, South KoreaThe government of Republic Of Korea has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on December 23, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the government of Republic Of Korea's investigation…NTSB WPR16WA051Accident · 10 fatalForeign investigationBeech 200 · New Delhi, IndiaThe Air Accident Investigation Bureau (AAIB) of India has notified the NTSB of an accident involving a Beech Super King Air B-200, registration VT-BSA, that occurred on December 22, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the…NTSB DCA16WA037Incident · No injuriesForeign investigationBoeing 787 · Darwin, AustraliaThe government of Australia has notified the NTSB of an incident involving a Boeing 787 airplane that occurred on December 21, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's investigation under the…NTSB DCA16WA236Accident · No injuriesForeign investigationCessna 182 · Plettenberg, Western Cape Province, South AfricaThe South African Civil Aviation Authority (SACAA) has notified the NTSB of an accident involving a Cessna 182@ airplane that occurred on December 16, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the SACAA's investigation under the…NTSB CEN16WA066Accident · Serious injuriesForeign investigationBell 407 · Mixco, GuatemalaOn December 16, 2015, about 1710 universal coordinated time, a Bell 407 helicopter, TG-PJV, sustained substantial damage on impact with terrain near Mixco, Guatemala. The pilot sustained a serious injury and the two passengers were uninjured. The local flight…NTSB ERA16WA069Accident · 4 fatalForeign investigationHawker Beech A36TC · Suvorovskaya, RussiaOn December 13, 2015, about 0826 Universal Time Coordinated (UTC), a Beech A36TC, Russian registration RA-2587G, registered to and operated by a private individual, experienced an in-flight loss of control and collided with terrain near Suvorovskaya Village,…NTSB ERA16WA072Accident · 2 fatalForeign investigationBell 206 · Mendoza Province, ArgentinaOn December 12, 2015, about 1100 coordinated universal time, a Bell-206, Argentinian registration LV-VFD, was destroyed during a low altitude cruise flight over a reservoir when the helicopter struck the water for undetermined reasons, and sank in…NTSB DCA16CA050Accident · Serious injuriesData collectionFinal reportBoeing 777 223 · Buenos Aires, Argentinaan inadvertant encounter with convective turbulence.NTSB ENG16WA006Incident · No injuriesForeign investigationAirbus A319 · Bogota, ColombiaOn December 11, 2015, an Avianca Airbus A318-111, N593EL, equipped with CFMI CFM56-5 engines, experienced a loss of power from the No. 1 (left) engine. The airplane was operating as Avianca flight AV9398 from Bogota, Colombia to Pasto, Colombia when the…NTSB CEN16WA063Accident · 1 fatalForeign investigationCessna 208B · Pickle Lake, Ontario, Canada, CanadaOn December 11, 2015, about 0910 eastern standard time, a Canadian registered Cessna 208B, C-FKDL, impacted terrain approximately 15 nautical miles north of Pickle Lake, Ontario, Canada. The pilot, the sole occupant, was fatally injured. The investigation is…NTSB CEN16WA065Accident · No injuriesForeign investigationEnstrom 280 · Salinas Victoria, MexicoOn December 10, 2015, about 1710 universal coordinated time, an Enstrom 280FX helicopter, XB-GRG, sustained substantial damage on impact with terrain near Salenas Victoria, Mexico. The pilot sustained a serious injury and the two passengers were uninjured.…NTSB DCA16WA031Accident · 1 fatalForeign investigationEclipse 500 · Swellendam, South AfricaThe South African Civil Aviation Authority (SACAA) has notified the NTSB of an accident involving a Eclipse Aviation 500 airplane that occurred on December 07, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the SACAA investigation…NTSB ERA16WA079Accident · 3 fatalForeign investigationEmbraer EMB720 · Trindade, BrazilOn December 6, 2015, about 1400 universal coordinated time, an Embraer EMB-720D, Brazilian registration PT-VNC, operated by a private individual, was destroyed when it collided with trees in Trindade, Brazil, while on approach to Aerodromo Nacional Aviacao…NTSB DCA16WA029Incident · No injuriesForeign investigationBoeing 737 · Singapore, SingaporeThe Air Accident Investigation Bureau of Singapore (AAIB) has notified the NTSB of an accident involving a Boeing 737 that occurred on December 06, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB's investigation under the…NTSB DCA16WA028Incident · No injuriesForeign investigationBoeing 777 223 · Madrid, SpainThe Spanish CIAIAC has notified the NTSB of a ground collision involving an Iberia Airlines A330 and an American Airlines 777 that occurred on December 06, 2015, in Madrid, Spain. The NTSB has appointed a U.S. Accredited Representative to assist the CIAIAC…NTSB CEN16WA060Incident · No injuriesForeign investigationSikorsky S92 · Wexford, IrelandOn December 6, 2015, at 1415 universal coordinated time, a Sikorsky S92 helicopter, Irish registration EI-ICG, was involved in an off shore rescue operation. Two victims were being recovered when one of the victims slipped from the recue harness, fell back…NTSB DCA16WA034Incident · No injuriesForeign investigationBoeing · Perth, AustraliaThe Australian Transportation Safety Board (ATSB) has notified the NTSB of an incident involving a Boeing 787 that occurred on December 04, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the ATSB's investigation under the provisions…NTSB DCA16WA072Incident · No injuriesForeign investigationBoeing 737 · Portela, PortugalThe Dutch Safety Board (DSB) has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on December 03, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the DSB investigation under the provisions of ICAO Annex 13…NTSB CEN16WA056Accident · 1 fatalForeign investigationPiper PA28R · Ljubljana, Slovenia, SloveniaOn December 3, 2015, a Piper PA-28R-201 airplane, OE-DYM, was destroyed after impact with terrain while on approach to the Ljubljana Airport, Slovenia. The pilot was fatally injured. This investigation is under the jurisdiction and control of the Republic of…NTSB CEN16WA051Accident · 1 fatalForeign investigationRockwell 114 · Lancashire, England, United KingdomOn December 3, 2015, about 0911 hours universal coordinated time, a Rockwell model 114B airplane, United Kingdom registration 2-ROAM, impacted the Irish Sea while on approach to the Blackpool Airport, Lancashire, England. The pilot was fatally injured. The…NTSB DCA16WA049Incident · No injuriesForeign investigationBombardier BD100 1A10 · Le Bourget, FranceThe BEA of France has notified the NTSB of an incident involving a Bombardier BD100 1A10 that occurred on December 02, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the BEA's investigation under the provisions of ICAO Annex 13 as the…NTSB CEN16WA057Accident · No injuriesForeign investigationCessna 560 · Farnborough, United KingdomThis is preliminary information, subject to change, and may contain errors. The foreign authority was the source of this information. On November 29, 2015, at 1350 UTC, a Cessna Citation 560XL, SE-RHJ, experienced an in-flight cowling departure during descent…