NTSB investigations, 2014, Outside the U.S.
40 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\") = 2014
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") = 2014 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 WPR15WA075Accident · 2 fatalForeign investigationCessna 172 - S · Port Arthur, Australia, AustraliaOn December 29, 2014, at 1747 local, a Cessna 172S, VH-PFT, collided with water near Port Arthur, Australia during an aerial photography flight. The airplane was operating under the pertinent civil regulations of the government of Australia. The airplane was…NTSB DCA15WA046Accident · 162 fatalForeign investigationAirbus A320 - 216 · Pangkalan Bun, IndonesiaThe National Transportation Safety Committee (NTSC) of Indonesia, has notified the NTSB of an accident involving an Airbus A320-216 that occurred on December 28, 2014. The NTSB has appointed a U.S. Accredited Representative to assist the NTSC investigation…NTSB CEN15WA082Accident · 2 fatalForeign investigationGates Learjet 25D · Champoton, MexicoNTSB CEN15WA108Accident · 4 fatalForeign investigationAirbus Helicopter EC135T2+ · Lake Siutghiol, RomaniaOn December 14, 2014, about 1615 local time, an Airbus Helicopter EC135T2+ helicopter, Romanian registration number 348, impacted Lake Siutghiol, Romania. The four occupants, flight and medical crew, were all fatally injured. The helicopter sustained…NTSB ERA15WA078Accident · 2 fatalForeign investigationCessna U206F · Campo Grande, BrazilNTSB ERA15WA070Accident · 10 fatalForeign investigationPiper PA-31-350 · Mariquita, ColombiaNTSB WPR15WA065Accident · 2 fatalForeign investigationAyres Thrush S2R-T34 · Manado, Indonesia, IndonesiaOn December 2, 2014, about 0250 universal coordinated time, an Ayres Trush, S2R-T34, PK-ELR, ditched in the sea under unknown circumstances. A tail wheel tire, elevator, both main landing gears, and some personal equipment were located 1 mile from the…NTSB WPR15WA064Accident · 2 fatalForeign investigationLiberty Aerospace XL2 · Sumbawa, Indonesia, IndonesiaOn October 30, 2014, about 0330 universal coordinated time, a Liberty Aerospace XL2, PK-LLC, was reported missing after contact was lost with the airplane. A search was initiated and the wreckage was subsequently located on December 15, 2014, South of Moyo…NTSB DCA15RA018Accident · 2 fatalForeign investigationShort Bros Shorts SD3 60 · Sint Maartin -Juliana, NTimportNTSB CEN15WA129Accident · No injuriesForeign investigationSiai-Marchetti S.205 18R · Speck-Fehraltorf, SwitzerlandNTSB CEN15WA102Accident · No injuriesForeign investigationBoeing PT-17 · San Jose, GuatemalaOn September 14, 2014, at 2314 coordinated universal time, a Boeing PT-17, Guatemalian registration TG-JEN, operated by KEHA S.A., was destroyed when it impacted water while performing aerobatic maneuvers near San Jose, Guatemala. The pilot was not injured.…NTSB CEN14WA502Accident · 1 fatalForeign investigationDiamond Aircraft Ind DA 40 · Kulusuk, GreenlandOn September 11, 2014, about 1600 coordinated universal time, a Diamond Aircraft Industries Inc. DA 40 airplane, N39SE, owned and operated by Milou 1 LLC, was substantially damaged when it impacted terrain near Kulusuk, Greenland. Visual meteorological…NTSB DCA14WA181Accident · 2 fatalForeign investigationAgusta AW109 · La Mojonera, MexicoThe government of Mexico has notified the NTSB of an accident involving a AgustaWestland AW109 helicopter that occurred on September 02, 2014. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the…NTSB CEN14WA478Accident · 1 fatalForeign investigationCessna A185F · Baie-Comeau, CanadaNTSB DCA14WA159Accident · No injuriesForeign investigationFokker F27 - 50 · Mugumu, TanzaniaNTSB CEN14WA452Accident · 1 fatalForeign investigationNasdalla Vans RV-7 · Modrava, CzechiaOn August 23, 2014, an experimental amateur-built Nasdalla model Vans RV-7 airplane, Norwegian registration LN-DSF, serial number 71683, sustained substantial damage when it collided with wooded terrain within Šumava National Park, near Modrava, Czech…NTSB CEN14WA531Accident · 2 fatalForeign investigationPiper PA-31 · Manan, CanadaNTSB CEN14WA416Accident · 3 fatalForeign investigationCessna 182P · Lake of the Woods, CanadaNTSB CEN14WA407Accident · 2 fatalForeign investigationSocata TBM 700 · Saint Jean les Deux Jumeaux, FranceNTSB ERA14WA356Accident · 2 fatalForeign investigationRobinson R44 · Ivashka Township, RussiaOn July 23, 2014, at 0809 Coordinated Universal Time (UTC), a Robinson R44, Russian registration RA-1975G, impacted the waters of the Ivashka River, under unknown circumstances, near Ivashka Township, Russia. The pilot and one passenger were fatally injured.…NTSB CEN14WA394Accident · No injuriesForeign investigationMD Helicopter 600N · Kungsangen, SwedenOn July 14, 2014, at 1333 coordinated universal time, an MD Helicopters MD600N, SE-JKJ, was substantially damaged following an autorotation near Kungsängen, Stockholm, Sweden. The pilot was not injured. Visual meteorological conditions prevailed for the…NTSB CEN14WA363Accident · 3 fatalForeign investigationPiper PA 28R-201T · Urtaca, FranceNTSB DCA14WA138Accident · 4 fatalForeign investigationFokker F27 - 50 · Nairobi, KenyaNTSB ERA14RA318Accident · 4 fatalClass 5 · ForeignRobinson R66 · Krasnodar Krai, RussiaOn June 28, 2014, at 1518 Coordinated Universal Time (UTC), a Robinson R66, Russian registration RA-15880, impacted terrain, in Krasnodar Krai, Russia. The pilot and three passengers were fatally injured. The investigation is under the jurisdiction of the…NTSB ERA14WA304Accident · 3 fatalForeign investigationCessna U206E · Cerro Militar, Municipio de Calima, ColombiaNTSB CEN14WA304Accident · No injuriesForeign investigationReims Cessna F150L · Nottingshire, United KingdomThis is preliminary information, subject to change, and may contain errors. On June 14, 2014, about 1240 UTC, a Cessna F150L airplane, G-YIII (s/n 0827) impacted terrain near Hucknall Airfield (EGNA), Nottinghamshire, United Kingdom. The airplane was…NTSB CEN14WA315Incident · No injuriesForeign investigationBeech 76 · Dublin, IrelandOn May 22, 2014, at 1233 hours universal coordinated time, a Beech model 76 Duchess, Ireland registration EI-BUN, was involved in a runway excursion after landing at the Weston Airfield (EIWT), Dublin, Ireland. The flight instructor and pilot receiving…NTSB DCA14WA114Incident · No injuriesForeign investigationBoeing 737-400 · Panama City, PanamaThe Civil Aeronautical Authority of Panama (AAC) has notified the NTSB of an incident involving a Boeing 737-400 that occurred on May 9, 2014. The NTSB has appointed a U.S. Accredited Representative to assist the AAC investigation under the provisions of ICAO…NTSB ERA14WA224Accident · 1 fatalForeign investigationRobinson R44 II · Inta, RussiaOn April 30, 2014, at 0318 Coordinated Universal Time (UTC), a Robinson R44 II, Russian registration RA-06217, impacted terrain, near Inta, Russia. The pilot was fatally injured. The investigation is under the jurisdiction of the Russian Federation Interstate…NTSB CEN14RA212Accident · 8 fatalForeign investigationBritish Aerospace HS 125 700A · Saltillo, MexicoOn April 19, 2014, about 1945 hours central daylight time, a British Aerospace HS 125 700A, XA-UKR, impacted an industrial complex and terrain while on final approach to Plan de Guadalupe International Airport (SLW), near Saltillo, Mexico. A postimpact ground…NTSB WPR14WA189Accident · 1 fatalForeign investigationBell 407 · Beijing, P.R. China, ChinaOn April 10, 2014, at 0323 universal coordinated time, a Bell 407GX, B-7475, was substantially damaged when it impacted water under unknown circumstances near Beijing, P.R. China. The helicopter was operated by Eastern General Aviation Limited Corporation…NTSB CEN14WA190Accident · 1 fatalForeign investigationEnstrom 280 - FX · Kirchham, Austria, AustriaOn April 5, 2014, about 1754 UTC, an Enstrom 280FX Shark helicopter, G-OJMF, (s/n 2086) impacted terrain near Kirchham, Austria. The helicopter was destroyed, the pilot was fatally injured, and the two passengers on board the helicopter were seriously…NTSB DCA14WA109Incident · No injuriesForeign investigationBoeing 737-800 · Kayseri, TürkiyeThe German Federal Bureau of Aircraft Accident Investigation (BFU) has notified the NTSB of an incident involving a Boeing 737-800 that occurred on April 4, 2014. The NTSB has appointed a U.S. Accredited Representative to assist the BFU investigation under…NTSB WPR14WA148Accident · 1 fatalForeign investigationMD Helicopter 500N · Gisborne, New Zealand, New ZealandOn March 19, 2014, at 2030 universal coordinated time, a MD Helicopters 500N, ZK-HQP, was preparing for a fire lighting operation when it crashed in Hawkes Bay near Gisborne, New Zealand. The helicopter was operated by Gisborne Helicopters Limited under the…NTSB ERA14WA148Accident · 1 fatalForeign investigationZivko Aeronautics Edge 540T · Al Khor, QatarOn March 17, 2014, about 1725 local time, a Zivko Aeronautics Edge 540T, N149WA, was substantially damaged when it collided with the ground during an airshow performance at Al Khor Airport (OTBK), Al Khor, Qatar. The commercial pilot was fatally injured. The…NTSB ANC14WA019Accident · 2 fatalForeign investigationCessna 172M · Toyota City, JapanOn March 5, 2014, at 1235 Japan standard time, a single engine Cessna 172M, Japan registered JA3853, sustained substantial damage after impacting terrain near Toyota City, Aichi Prefecture, Japan. Both occupants sustained fatal injuries. This report is for…NTSB WPR14WA126Accident · 1 fatalForeign investigationAmateur Built VAN'S RV-6 · Gatton Airpark, Australia, AustraliaOn March 2, 2014, at 0747 local time, a Van's RV-6, VH-ZMH, collided with an embankment and was destroyed by a postimpact fire near Gatton Airpark, Australia. The flight was operated by the pilot under the pertinent civil regulations of the government of…NTSB CEN14WA117Accident · 7 fatalForeign investigationBritten Norman BN-2A-27 · Horea, RomaniaOn January 20, 2014, about 1400 coordinated universal time, a Britten-Norman BN-2A-27 airplane, YR-BNP, impacted mountainous terrain near Horea, Cluj, Romania. The two pilots, and five passengers were all fatally injured. The airplane was destroyed. The…NTSB WPR14WA108Accident · 4 fatalForeign investigationPiper PA31 - 350 · Maluku, Indonesia, IndonesiaOn January 19, 2014, at 1220 local time, a Piper PA-31-350, PK-IWT, collided with terrain under unknown circumstances while on approach to Dumatubun Airport, Maluku, Indonesia. The pilot and three passengers were fatally injured and the airplane was…NTSB ERA14WA100Accident · 2 fatalForeign investigationCessna 208B · Olive Creek, Guyana