NTSB investigations, 2015, Outside the U.S.
60 cases where the sequence of events included Unknown or undetermined.
Cases per year
| 2008 | 9 |
|---|---|
| 2009 | 9 |
| 2010 | 20 |
| 2011 | 19 |
| 2012 | 16 |
| 2013 | 26 |
| 2014 | 40 |
| 2015 | 60 |
| 2016 | 78 |
| 2017 | 69 |
| 2018 | 79 |
| 2019 | 46 |
| 2020 | 50 |
| 2021 | 49 |
| 2022 | 50 |
| 2023 | 55 |
| 2024 | 59 |
| 2025 | 70 |
| 2026 | 207 |
Latest cases
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\") = 2015
AND c.\"eventCountry\" <> 'USA'
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '000' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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") = 2015 AND c."eventCountry" <> 'USA' AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '000' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 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 ANC16WA007Accident · 2 fatalForeign investigationBell 206 · New Taipei City, TaiwanOn November 22, 2015, about 0302 Coordinated Universal Time, a Bell 206 helicopter, Taiwan Island registration number B-31127, operated by Emerald Pacific Airlines, was destroyed following an impact with terrain about 7 nautical miles southwest of Taipei…NTSB CEN16WA044Accident · 3 fatalForeign investigationBell 206 · San Carlos, NicaraguaOn November 17, 2015, about 1140 coordinated universal time, a Bell 206L4 helicopter, Nicaraguan registered YN-ISA, impacted the San Juan River near San Carlos, Rio San Juan, Nicaragua. The pilot and three passengers were fatally injured and the helicopter…NTSB CEN16WA045Accident · 4 fatalForeign investigationPiper PA 46 350P · Taunton, United KingdomNTSB ERA16WA038Accident · 1 fatalForeign investigationAir Tractor AT-502B · Balsas, BrazilOn November 11, 2015, about 1930 universal coordinated time, an Air Tractor AT502B, Brazilian registration PR-RSA, was destroyed when it impacted terrain shortly after takeoff from Balsas Airport, Balsas Brazil. The pilot was fatally injured. The flight was…NTSB DCA16WA016Incident · No injuriesForeign investigationBoeing 737 · Nicosia, CyprusThe Accident Investigation Board of Turkey (AAIB) has notified the NTSB of an incident involving a Boeing 737-800, which occurred on November 2, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under the…NTSB DCA16WA015Accident · 224 fatalForeign investigationAirbus A321 · Sinai Peninsula, EgyptThe Egyptian Ministry of Civil Aviation has notified the NTSB of an accident involving a AIRBUS A321 airplane, with IAE V2533 engines, that occurred on October 31, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the Egyptian's…NTSB ANC16WA002Accident · 1 fatalForeign investigationBell 206B · Asquinth, CanadaOn October 27, 2015, about 2043 central daylight time, a Bell 206B helicopter, C-GIFY, impacted terrain near Asquinth, Saskatchewan, Canada, under unknown circumstances. The pilot sustained fatal injuries. The Transportation Safety Board (TSB) of Canada is…NTSB ERA16WA050Accident · 2 fatalForeign investigationCessna 150H · Rondonopolis Municipality, BrazilOn October 22, 2015, about 1130 coordinated universal time , a Cessna 150H, Brazilian registration PR-DMT, was destroyed when it impacted terrain while on approach to land at Rondonopolis Airport, Rondonopolis, Mato Grosso, Brazil. The two occupants were…NTSB CEN16WA020Accident · 4 fatalForeign investigationLearjet 31 · La Tinaja, MexicoThe Direccion General de Aeronutica Civil (DGAC) of Mexico has notified the NTSB of an fatal accident involving a LearJet 31A, XB-GYB, that occurred on October 22, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the DGAC under the…NTSB ANC16WA004Accident · 2 fatalForeign investigationCessna 207 · Taylor, CanadaOn October 16, 2015, about 2330 Coordinated Universal Time, a Cessna 207 airplane, C-GNVZ, impacted terrain near Taylor, British Columbia, Canada, under unknown circumstances. The pilot and passenger sustained fatal injuries. The Transportation Safety Board…NTSB ERA16WA013Accident · 3 fatalForeign investigationCessna 208B · Yumbillo, ColombiaOn October 14, 2016, about 1645 coordinated universal time, a Cessna 208B, Brazilian registration PR-MIC, operated by Microsurvey Aerogeofisica E Consultoria Cientifica of Brazil, was destroyed when it impacted mountainous terrain during a survey flight near…NTSB CEN16WA009Accident · 2 fatalForeign investigationBell 430 · Xalapa, MexicoOn October 6, 2015, at 2355 coordinated universal time (UTC), a Bell 430 helicopter, Mexican registration XC-VER, collided with terrain after departure from the El Lencero Airport, Xalapa, Mexico. A postimpact fire ensued. The pilot and co-pilot were fatally…NTSB ERA16WA002Accident · 2 fatalForeign investigationPiper PA-31-325 · Chia, ColombiaOn October 3, 2015, about 1715 UTC, a Piper PA-31-325, Colombian registration HK3909G, registered to and operated by El Caminante Air S.A., collided with a structure then rolled inverted during a forced landing in a field near Hipodromo de los Andes, Chia,…NTSB CEN16WA002Accident · 2 fatalForeign investigationBeech 200 · Chigwell, United KingdomThe Air Accidents Investigation Branch (AAIB) United Kingdom has notified the NTSB of an incident involving a Beech B200 that occurred on October 3, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under the…NTSB DCA15WA204Accident · No injuriesForeign investigationDe Havilland DHC8 · Saarbrucken, GermanyThe government of Germany has notified the NTSB of an accident involving a DE HAVILLAND DHC8 airplane that occurred on September 30, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the government of Germany's investigation under the…NTSB ERA15WA370Accident · 4 fatalForeign investigationBell 206 · Maceio, BrazilOn September 23, 2015, at 1350 universal coordinated time, a Bell 206L-3, Brazilian registration PP-ELA, was destroyed when it impacted terrain in Maceio, Brazil. The four occupants were fatally injured. The local police patrol flight originated at Zumbi dos…NTSB DCA15WA197Incident · No injuriesForeign investigationBoeing 737 · Frankfort, GermanyThe German Federal Bureau of Aircraft Accident Investigation (BFU) has notified the NTSB of an incident involving a Boeing 737-800 that occurred on September 14, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the BFU investigation…NTSB WPR15WA271Accident · 4 fatalForeign investigationBell 407 · Chong Qing, China, ChinaOn September 13, 2015, at 0600 local time, a Bell 407 GX, B-7702, operated by Chong Qing General Aviation Corporation, collided with terrain during an aerial photo operation near Chong Qing, P. R. China. The helicopter was being operated under the pertinent…NTSB DCA15WA203Incident · No injuriesForeign investigationAirbus A320 · Perth, AustraliaThe Australian Transport Safety Board (ATSB) has notified the NTSB of an incident involving a AIRBUS A320 airplane, which occurred on September 12, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's…NTSB ERA15WA355Accident · 2 fatalForeign investigationSmith AEROSTAR600 · Santa Fé de Antioquia, ColombiaNTSB CEN15WA406Accident · 1 fatalForeign investigationBeech Beech C 24R · Könnern, GermanyOn September 10, 2015 about 0830 UTC, a Beech C24R Sierra airplane, German registration D-EHZK, crashed into a field under unknown circumstances near Könnern, Germany. The pilot, who was the sole occupant, was fatally injured. The flight departed from the…NTSB CEN15WA454Accident · 2 fatalForeign investigationRobinson R44 · Foleyet, CanadaOn September 9, 2015, about 0015 Universal Time Coordinated, a Robinson R-44, C-GZFX, owned and operated by Apex Helicopters Inc. was found in a heavily wooded area about 17 nautical miles south of Foleyet, Ontario. The pilot and one passenger were fatally…NTSB WPR15WA259Accident · 1 fatalForeign investigationCessna 172 · Ballarat, Australia, AustraliaOn September 8, 2015, at 1542 local time, a Cessna 172S, VH-ZEW, collided with terrain near Ballarat, Australia. The airplane was being operated under the pertinent civil regulations of the Government of Australia. The airplane was destroyed and the pilot,…NTSB DCA15WA188Accident · 7 fatalForeign investigationBoeing 737 · Tambacounda, SenegalNTSB CEN15WA380Accident · 6 fatalForeign investigationDehavilland DHC-2 MK. I · Lac Long, CanadaOn August 23, 2015, about 1530 coordinated universal time, a De Havilland DHC-2 MK. I airplane, collided with wooded mountainous terrain near Lac Long, Quebec, Canada. The pilot and 5 passengers were fatally injured. The accident investigation is under the…NTSB CEN15WA397Accident · Minor injuriesForeign investigationRobinson R44 · Natolin village, PolandOn August 22, 2015 about 1515 UTC, a Robinson R44 helicopter, Poland registration SP-TVN, made a hard landing, during a precautionary landing, following an engine issue near Natolin village, Radom-Sadkow airport, Poland. The pilot was not injured and the…NTSB DCA15RA171Accident · No injuriesForeign investigationSikorsky S76 - C · Lagos, NigeriaThe Nigeria Accident Investigation Bureau (NAIB) has notified the NTSB of an accident involving a SIKORSKY S76 - C helicopter that occurred on August 12, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the NAIB investigation under the…NTSB CEN15WA420Accident · 4 fatalForeign investigationEmbraer EMB505 · Blackbushe Airport, United KingdomOn July 31, 2015, at 1408 universal coordinated time (UTC), a Embraer EMB-505, Phenom 300, airplane, registered HZ-IBN, impacted a terrain during landing at the Blackbushe Airport (EGLK), United Kingdom. The pilot and three passengers were fatally injured.…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…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…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…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…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…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.…NTSB ERA15WA247Accident · 1 fatalForeign investigationCessna T303 · Vaupes, ColombiaNTSB ERA15WA261Accident · 2 fatalForeign investigationIlyushin IL-103 · Brest, BelarusNTSB 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…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…NTSB ANC15WA029Accident · 1 fatalForeign investigationAir Tractor AT802-A · Cold Lake, CanadaOn May 22, 2015, at 1630 mountain daylight time, a Canadian registered Air Tractor, AT-802A airplane, C-FDHV, operated by the Conair Group Inc., was destroyed when it collided with terrain under unknown circumstances during firefighting operations near Cold…NTSB CEN15WA234Accident · Serious injuriesForeign investigationHughes 369 · Bocognano, Corse-du-Sud, France, FranceOn May 18, 2015, about 0810 hours universal coordinated time, a Hughes model 369 helicopter, Finland registration OH-HNR, impacted terrain near Bocognano, Corse-du-Sud, France. The two crew members were seriously injured. The flight itinerary and purpose of…NTSB ERA15WA223Accident · 1 fatalForeign investigationCessna 182J · Novo Progresso, BrazilOn May 9, 2015, about 1430 local time, a Cessna 182J, Brazilian registration PT-CND, was destroyed when it impacted the Baú River, near Novo Progresso, Pará State, Brazil. The Brazilian pilot was fatally injured. The flight, which originated at Novo Progresso…NTSB CEN15WA221Accident · 2 fatalForeign investigationBeech Beech 95-B55 · Dundee, United KingdomOn May 3, 2015, at 1113 coordinated universal time, a Beech 95-B55 airplane, G-RICK, impacted terrain while on approach to the Dundee Airport (EGPN), Dundee, Scotland. The pilot and one passenger were fatally injured and the airplane was destroyed. Instrument…NTSB ERA15RA199Accident · 2 fatalForeign investigationSwearingen SA226-TC · North Vancouver, CanadaOn April 13, 2015, at 0709 Pacific daylight time, a Swearingen SA226-TC, Canadian registration C-GSKC, operating as Carson Air flight 66, was destroyed in an area of mountainous terrain about 10 nautical miles north of North Vancouver, British Columbia. The…NTSB ERA15WA193Accident · 1 fatalForeign investigationCessna 210L · Assuncao do Piaui, BrazilOn April 11, 2015, at 2200 coordinated universal time, a privately owned Cessna 201L, Brazilian registered PR-APG, was destroyed when it impacted terrain under unknown circumstances near Assuncao do Piaui Municipality, State of Piaui, Brazil. The pilot was…NTSB DCA15WA113Accident · 6 fatalForeign investigationEurocopter AS365N3 · Jalan Sungai Lalang, Kampung Pasir baru, Semenyih, MalaysiaNTSB ERA15WA185Accident · 1 fatalForeign investigationAerospool Dynamic WT-9 · Cotopaxi Volcano, EcuadorOn March 28, 2015, about 1300 local time, an Aerospool Dynamic WT9, French registration F-JUKE, was destroyed when it impacted terrain on Cotopaxi Volcano, Cotopaxi Province, Ecuador. The Swiss pilot was fatally injured. The flight, which originated at…NTSB ERA15WA159Accident · 1 fatalForeign investigationPiper PA-34-200T · Macas, EcuadorOn March 15, 2015, at an unknown time, a Piper PA-34, Ecuadorian registration HC-CNC, impacted terrain under unknown circumstances shortly after takeoff from Edmundo Carvajal Airport, Macas, Ecuador. The pilot, the sole occupant, was fatally injured. The…