Skip to content

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.

Defining event

Finding

Phase of flight

Aircraft model

Cases, newest first

Query with SQL

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

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 DCA15WA196Incident · No injuriesForeign investigationBoeing 747 · New Delhi, IndiaThe Air Accident Investigation Bureau (AAIB) of India has notified the NTSB of an incident involving a Boeing 747-400 that occurred on July 27, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under the provisions…Jul 27, 2015 · B-HUL · Minor damage NTSB DCA15WA182Incident · No injuriesForeign investigationBombardier CL600 2E25 · Makassar, IndonesiaThe National Transportation Safety Committee of Indonesia (KNKT) has notified the NTSB of an incident involving a CRJ-1000, which occurred on August 27, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the KNKT investigation under the…Jul 27, 2015 · PK-GRC · No damage NTSB ANC15WA061Accident · 1 fatalForeign investigationCessna 182 · Seibert Lake, CanadaOn July 26, 2015, about 1738 mountain daylight time, a Cessna 182 airplane, C-FWVQ, impacted terrain shortly after takeoff from Seibert Lake, Alberta, Canada, under unknown circumstances. The pilot sustained fatal injuries. The Transportation Safety Board…Jul 26, 2015 · C-FWVQ NTSB ANC15WA060Accident · 3 fatalForeign investigationPiper PA46 - 350P · Tokyo, JapanOn July 26, 2015, at 0200 coordinated universal time, a Japanese registered Piper PA46-350P airplane, JA4060, operated by a private individual, impacted a residential area shortly after takeoff from Chofu Airfield, Tokyo, Japan. The pilot, one passenger, and…Jul 26, 2015 · JA4060 · Destroyed NTSB CEN15WA358Incident · No injuriesForeign investigationRobinson Helicopter Robinson R44 · Leixlip, IrelandJul 25, 2015 · G-OCON · 2 aircraft · No damage NTSB CEN15WA317Accident · 1 fatalForeign investigationCox Bede BD-5G · Garranbane, IrelandOn July 25, 2015, at 1745 universal coordinated time (UTC), a Cox model Bede BD-5G amateur-built airplane, Irish registration EI-DNN, serial number HJC4523, was destroyed during a postimpact fire following a forced landing near Garranbane, Ireland. The pilot,…Jul 25, 2015 · EI-DNN · Destroyed NTSB CEN15RA446Incident · No injuriesForeign investigationCessna 525 · Geneva, SwitzerlandJul 24, 2015 · N990FV · 2 aircraft · No damage NTSB ENG15RA028Incident · No injuriesForeign investigationAirbus A330 - 223 · Riyadh, Saudi Arabia, Saudi ArabiaOn July 23, 2015, at about 12:23 UTC, a Korean Air Airbus A330-223, registration number HL8211, experienced a No. 1 (left engine) stall after initial takeoff from the King Khalid International Airport (KSA) in Riyadh, Saudi Arabia. The flight crew received a…Jul 23, 2015 · HL8211 · No damage NTSB DCA15WA209Incident · No injuriesForeign investigationBoeing 737 · Monterrey, MexicoThe government of Mexico has notified the NTSB of an incident involving a Boeing 737 that occurred on July 23, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions of ICAO Annex…Jul 23, 2015 · XA-UTE NTSB WPR15WA231Accident · Minor injuriesForeign investigationBell 407 - NO Series · Tifalmin Village Papua New Guinea, Papua New GuineaOn July 22, 2015, at 1325 local time, a Bell 407, P2-HCB, registered to and operated by Hevilift, experienced a loss of engine power while maneuvering away from a drilling/exploration camp near Tifalmin Village, Papua New Guinea. The helicopter subsequently…Jul 22, 2015 · P2-HCB · Substantial damage NTSB WPR15WA224Accident · 1 fatalForeign investigationGlasair SH-2FT · Wedderburn, AustraliaOn July 19, 2015 about 1700 local time, an amateur built Glasair SH-2FT, Australian registration VH-HRG, collided with terrain near Wedderburn, Victoria, Australia. The airplane sustained substantial damage and the pilot was fatally injured. The investigation…Jul 19, 2015 · VH-HRG · Substantial damage NTSB ERA15WA290Accident · 1 fatalForeign investigationCessna 210D · Rio Verde, BrazilJul 19, 2015 · PR-ITO · Destroyed NTSB ERA15WA275Accident · Serious injuriesForeign investigationCessna 206G · Sucua, EcuadorOn July 19, 2015, about 1515 universal coordinated time, a Cessna 206G, HC-CLR, was destroyed by collision with terrain during a forced landing following a loss of engine power during descent to Edmund Carvajal Airport (XMS), Macas, Santiago, Ecuador. The…Jul 19, 2015 · HC-CLR · Destroyed NTSB CEN15WA440Accident · Serious injuriesForeign investigationMaule MX7 · Munster, SwitzerlandOn July 18, 2015 about 0857 UTC, a Maule MX7-235 airplane, Swiss registration HB-KDF, impacted terrain during a go around near the Munster Airport (LSPU), near Munster, Switzerland. The pilot and two passengers sustained minor injuries and one passenger…Jul 18, 2015 · HB-KDF · Substantial damage NTSB CEN15WA338Accident · 1 fatalForeign investigation3xtrim 450 Ultra · Golub-Dobrzyn City, PolandOn July 17, 2015 about 1615 UTC, a 3Xtrim 450 Ultra, light sport airplane, Poland registration SP-SPRL, impacted terrain while on a sightseeing flight near Golub-Dobrzyn, Poland. The pilot was seriously injured and the passenger was killed. The airplane was…Jul 17, 2015 · SP-SPRL · Destroyed NTSB ENG15WA036Incident · No injuriesForeign investigationBoeing 737 · Quetta, PakistanThe government of Pakistan has notified the NTSB of an accident involving a Boeing 737-400 airplane that occurred on July 16, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the government of Pakistan's investigation under the…Jul 16, 2015 · AP-BJT · Minor damage NTSB CEN15WA368Accident · Minor injuriesForeign investigationPiper PA-32R-300 · Varberg, SwedenOn July 15, 2015, at 1402 coordinated universal time, a Piper PA-32R-300 airplane, Swedish registration SE-MCB, operated by a private individual, collided with the terrain following a loss of lift on takeoff from the Varberg Airport (ESGV), Varberg, Sweden.…Jul 15, 2015 · SE-MCB · Destroyed NTSB ENG15WA027Incident · No injuriesForeign investigationAirbus A330 - 323 · Incheon, Republic of Korea, South KoreaOn July 14, 2015 at about 0832 universal coordinated time, an Airbus A330-300, HL8282, operated by Asiana Airlines experienced No. 2 (right) engine fire and oil pressure warnings shortly after takeoff from Incheon International Airport (ICN), Incheon,…Jul 14, 2015 · HL8282 · No damage NTSB DCA15WA159Incident · No injuriesForeign investigationBoeing 767 - 346 · Singapore, SingaporeThe Aircraft Accident Investigative Bureau (AAIB) of Singapore has notified the NTSB of an incident involving a BOEING 767 airplane that occurred on July 12, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under…Jul 12, 2015 · JA606J · No damage NTSB WPR15WA213Accident · 2 fatalForeign investigationBell 407 - NO Series · Zhejiang Province, P.R. China, ChinaOn July 9, 2015 at 0225 Universal Coordinated Time, a Bell 407, B-7723, was substantially damaged when it crashed at the Qiandao Lake General Aviation airport, Zhejiang Province P. R. China, while conducting a post-repair hovering test. A total of seven…Jul 9, 2015 · B-7723 · Substantial damage NTSB WPR15WA211Accident · 1 fatalForeign investigationAmature Built Pitts · Maitland, Australia, AustraliaOn July 8, 2015, at 1641 local time, an amateur built Pitts 12, VH-JDZ, collided with terrain near Maitland, Australia and was destroyed by postimpact fire. The pilot, the sole occupant, was fatally injured. The airplane was being operated under the pertinent…Jul 8, 2015 · VH-JDZ · Destroyed NTSB ERA15WA284Accident · Serious injuriesForeign investigationRobinson R66 · Baykalsk, RussiaJul 7, 2015 · RA-05773 · Substantial damage NTSB ENG15WA029Incident · No injuriesForeign investigationEmbraer ERJ170 - 200STD · Niigata, JapanOn July 7, 2015, an Embraer ERJ170 experienced a bleed system failure during climb after take-off from New Chitose Airport (RJCC), Chitose, Japan. The aircraft diverted to Niigata Airport (RJSN). No one on board the aircraft was injured. The incident is being…Jul 7, 2015 · JA06FJ · No damage NTSB ERA15WA260Accident · No injuriesForeign investigationQuest Kodiac 100 · Pskov, RussiaOn July 6, 2015, about 1312 universal coordinated time, Quest Kodiak 100, U.S. registration N642RM, was substantially damaged by collision with terrain during a forced landing following a loss of engine power after takeoff from Pskov Airport, Pskov, Russia.…Jul 6, 2015 · N642RM · Substantial damage NTSB CEN15WA299Accident · 1 fatalForeign investigationRockwell International 112TCA · Kempten (Allgäu), GermanyJul 5, 2015 · N4708W · Substantial damage NTSB DCA15WA147Incident · No injuriesForeign investigationBoeing 737 · Tanegashima, JapanThe Japan Transportation Safety Board (JTSB) has notified the NTSB of an incident involving a Boeing 737 that occurred on June 30, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the government of JTSB's investigation under the…Jun 30, 2015 · JA8525 · Minor damage NTSB CEN15WA302Incident · No injuriesForeign investigationRobinson R-22 Beta II · Hradec Kralove, Czech Republic, CzechiaOn June 29, 2015, about 0806 coordinated universal time (UTC), a Robinson R-22 Beta II, OK-ZYZ, experienced an in-flight anomaly and the pilot conducted an emergency autorotation to a field about 10 miles west of Hradec Kralove, Czech Republic. The two pilots…Jun 29, 2015 · OK-ZYZ · Minor damage NTSB ERA15WA255Accident · 3 fatalForeign investigationRobinson R44 - II · Makarakskiy, RussiaOn June 27, 2015, at 0820 coordinated universal time, a Robinson Helicopter R44 II, Russian registration RA-05765, was damaged while attempting to depart from Makarakskiy, Russia. The pilot and two passengers were fatally injured. The flight was destined for…Jun 27, 2015 · RA-05765 · Substantial damage NTSB CEN15WA283Accident · 2 fatalForeign investigationLake LA4 - 200 · Split, CroatiaOn June 25, 2015, at 1735 universal coordinated time (UTC), a Lake Aircraft LA4-200, Croatian Registration 9A-DLA, was destroyed when it contacted the sea near the Split Airport (LDSP), Resnik, Croatia. One pilot and the sole passenger were fatally injured.…Jun 25, 2015 · 9A-DLA · Destroyed NTSB ANC15WA043Accident · 2 fatalForeign investigationCessna 172 · Fort McMurray, CanadaJun 22, 2015 · C-GJSE · 2 aircraft · Substantial damage NTSB ERA15WA247Accident · 1 fatalForeign investigationCessna T303 · Vaupes, ColombiaJun 20, 2015 · HK4677G · Destroyed NTSB ERA15WA250Accident · 3 fatalForeign investigationBell 206B · Ouro Preto, Minas Gerais, BrazilOn June 16, 2015, at 1910 Universal Coordinated Time (UTC), a Bell 206B helicopter, Brazilian registration PT-YDY, operated by a private owner, was destroyed following a controlled flight into terrain near Ouro Preto municipality, State of Minas Gerais,…Jun 16, 2015 · PT-YDY · Destroyed NTSB CEN15WA327Incident · No injuriesForeign investigationRaytheon Corporate Jets BAE 125 800 · Kerry, Ireland, IrelandThe incident investigation is under the jurisdiction and control of the government of Ireland. This report is for information purposes only and contains only information released by or obtained from the government of Ireland. Further information pertaining to…Jun 16, 2015 · N1310H · No damage NTSB WPR15WA188Accident · 1 fatalForeign investigationRobinson R44 - Undesignat · Timber Creek, Australia, AustraliaOn June 14, 2015, at 1100 local time, a Robinson R44, VH-KJJ, collided with terrain under unknown circumstances near Timber Creek, Australia. The helicopter was operated under the pertinent civil regulation of the government of Australia. The helicopter was…Jun 14, 2015 · VH-KJJ · Substantial damage NTSB ERA15WA261Accident · 2 fatalForeign investigationIlyushin IL-103 · Brest, BelarusJun 14, 2015 · EW-041LL · Destroyed NTSB DCA15WA210Incident · No injuriesForeign investigationBoeing 737 · Nauru, NauruThe Australian Transport Safety Board (ATSB) has notified the NTSB of an accident involving a BOEING 737 that occurred on June 12, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the ATSB's investigation under the provisions of ICAO…Jun 12, 2015 · VH-NLK · No damage NTSB CEN15WA273Accident · 3 fatalForeign investigationPiper PA-23-250 · Kangirsuk, CanadaOn June 11, 2015, about 2340 eastern daylight time, a Canadian registered PA-23-250, C-FXPS, impacted terrain about 1.2 nautical miles from the Kangirsuk Airport, Kangirsuk, Quebec, Canada. The pilot and two passengers were fatally injured. The investigation…Jun 12, 2015 · C-FXPS · Substantial damage NTSB ANC15RA074Accident · No injuriesForeign investigationCessna 525 · Okayama Preffecture, JapanOn June 23, 2015, a privately owned Cessna 525A, registered JA021R, took off from Tokyo International Airport at about 14:41 (JST: UTC+9hrs) and landed at Kohnan Aerodrome in Okayama prefecture at about 15:46. The landing ended up a runway overrun. It rested…Jun 10, 2015 · JA021R · Substantial damage NTSB DCA15WA135Incident · No injuriesForeign investigationBoeing 737 - 3S3 · Sao Luis City, BrazilThe Centro de Investigacao Provencao de Accidentes (CENIPA) has notified the NTSB of an incident involving a Boeing 737-300 which occurred on June 9, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the CENIPA investigation under the…Jun 9, 2015 · PR-SDL · Minor damage NTSB ERA15WA236Accident · 3 fatalForeign investigationBeech C90 - GTI · Belo Horizonte City, BrazilOn June 7, 2015, about 1823 UTC, a Textron Aviation C90GTi, Brazil registration PR-AVG, experienced a loss of control shortly after takeoff and crashed into a house near Belo Horizonte-Pampulha Airport (SBBH), Belo Horizonte City, Minas Gerais, Brazil. The…Jun 7, 2015 · PR-AVG · Destroyed NTSB DCA15WA130Incident · No injuriesForeign investigationBoeing 737 - 4D7 · Turin, ItalyThe Agenzia Nazionale per la Sicurezza del Volo (ANSV) has notified the NTSB of an incident involving a Boeing 737-400, which occurred on June 7, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the ANSV investigation under the…Jun 7, 2015 · YR-BAQ · Minor damage NTSB CEN15WA260Accident · 2 fatalForeign investigationVans RV-7A · Zagreb, CroatiaOn June 7, 2015, at 1430 coordinated universal time, a Van's Aircraft RV-7A, Croatian registered 9A-DVM, owned and piloted by the accident pilot, was destroyed when it impacted terrain near Zagreb, Croatia. Visual meteorological conditions prevailed at the…Jun 7, 2015 · 9A-DVM · Destroyed NTSB CEN15WA262Accident · 1 fatalForeign investigationBell Helicopter 206B · Baldwin, United KingdomOn June 6, 2015, about 0810 coordinated universal time, a Bell 206B helicopter, G-RAMY, impacted mountainous terrain near Baldwin, Isle of Man, United Kingdom. The pilot, the sole occupant, was fatally injured.The accident investigation is under the…Jun 6, 2015 · G-RAMY · Substantial damage NTSB ERA15WA246Accident · 1 fatalForeign investigationPiper PA-25-235 · Patrocínio Municipality,Minas Gerais, BrazilOn June 5, 2015, about 1506 universal coordinated time, Piper PA-25-235, Brazilian registration PR-ACH, was substantially damaged by collision with terrain while maneuvering at low altitude in Patrocinio Municipality, Minas Gerais, Brazil. The Brazilian…Jun 5, 2015 · PR-ACH · Substantial damage NTSB DCA15WA169Incident · No injuriesForeign investigationBoeing 737 - 6CT · Montreal, CanadaThe Transportation Safety Board (TSB) of Canada has notified the NTSB of an incident involving a BOEING 737that occurred on June 05, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the TSB investigation under the provisions of ICAO…Jun 5, 2015 · C-GWCT NTSB ERA15WA235Accident · 1 fatalForeign investigationCessna A188 · Puerto Gaitan, ColombiaOn June 4, 2015, about 1715 coordinated universal time, a Cessna A188, Colombian registration HK-1364, was substantially damaged when it impacted power lines and then terrain during an aerial application flight near Puerto Gaitan, Colombia. The commercial…Jun 4, 2015 · HK-1364 · Substantial damage NTSB CEN15WA256Accident · No injuriesForeign investigationCessna 180 - Undesignat · Half Moon Caye, BelizeJun 2, 2015 · V3-HHT NTSB CEN15WA251Accident · 5 fatalForeign investigationM7 Aerospace SA226 - TC · Queretaro, MexicoOn June 2, 2015, about 1425 central daylight time, an M7 Aerospace LLC SA226-TC airplane, XA-UKP, impacted terrain near Queretaro, Mexico. A postimpact ground fire occurred. The pilot, co-pilot, and three passengers were fatally injured and the airplane was…Jun 2, 2015 · XA-UKP · Destroyed NTSB ANC15WA036Accident · 2 fatalForeign investigationCessna 182 · Sikanni Chief, CanadaJun 1, 2015 · N759AS · Destroyed NTSB ERA15WA233Accident · 1 fatalForeign investigationVans RV8 · Corropoli, ItalyOn May 31, 2015, about 1430 universal coordinated time, a Vans RV8, I-LOVI, and a Vans RV7, I-AMEL, were destroyed after colliding midair and then subsequently colliding with the Adriatic Sea, near Corropoli, Italy. The Italian certificated pilot of the RV8…May 31, 2015 · I-LOVI · 2 aircraft · Destroyed