NTSB investigations, 2014
56 cases where the defining event was Unknown or undetermined.
Cases per year
| 2008 | 13 |
|---|---|
| 2009 | 20 |
| 2010 | 34 |
| 2011 | 34 |
| 2012 | 36 |
| 2013 | 32 |
| 2014 | 56 |
| 2015 | 72 |
| 2016 | 92 |
| 2017 | 78 |
| 2018 | 94 |
| 2019 | 68 |
| 2020 | 73 |
| 2021 | 89 |
| 2022 | 106 |
| 2023 | 134 |
| 2024 | 115 |
| 2025 | 118 |
| 2026 | 267 |
Where
Open the mapLatest 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.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '000')
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."mKey" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '000') 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 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 WPR15LA048Accident · 1 fatalLimited investigationFinal reportAir Tractor AT 502B · Somerton, AZA loss of airplane control for reasons that could not be determined based on available evidence.NTSB CEN15FAMS1Accident · 2 fatalMissing aircraftFinal reportCessna 172K · Lake Pontchartrain, LAThe airplane's collision with water for reasons that could not be determined because the wreckage was not located.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 ERA15LA028Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Valley Point, WVUndetermined based on a lack of available information.NTSB CEN15WA129Accident · No injuriesForeign investigationSiai-Marchetti S.205 18R · Speck-Fehraltorf, SwitzerlandNTSB CEN15CA065Accident · Serious injuriesData collectionFinal reportHughes Aero Predator · Branson, MOThe pilot's failure to maintain aircraft control when executing a landing with a tailwind, resulting in impact with a retaining wall.NTSB WPR15LA001Accident · 1 fatalLimited investigationFinal reportGaston Thomas D Thunder Mustang · Council, IDThe pilot's failure to maintain control while maneuvering for landing following a loss of oil pressure. Contributing to the accident was foreign material contamination of the oil system due to improper maintenance.NTSB ERA15LA001Accident · 1 fatalLimited investigationFinal reportAir Command 582 · Monongahela, PAThe amateur-built gyroplane’s collision with terrain for reasons that could not be determined based on the available information. Contributing to the accident was the pilot’s decision to conduct the flight without obtaining additional training.NTSB 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 CEN14FA468Accident · 2 fatalField investigationFinal reportSchafer Rick W Foxtrot 4 · Abilene, TXThe pilot's decision to attempt a steep turn to return to the airport after reporting an emergency. The reason for the emergency could not be determined because postaccident examination of the airframe and engine did not reveal any mechanical anomalies that…NTSB 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 ERA14FA396Accident · 2 fatalField investigationFinal reportMcdonnell Douglas Helicopter 369E · Northport, ALAn inadvertent collision with a utility wire for reasons that could not be determined from recorded data and examination of the helicopter and accident site.NTSB CEN14WA531Accident · 2 fatalForeign investigationPiper PA-31 · Manan, CanadaNTSB CEN14LA415Accident · 1 fatalLimited investigationFinal reportBell 47G 2 · Jeanerette, LAThe pilot’s improper decision to operate an unairworthy helicopter, which resulted in a loss of control and subsequent impact with terrain.NTSB ANC14FA062Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Big Lake, AKThe pilot's impairment due to alcohol consumption, which resulted in his failure to maintain clearance from trees.NTSB 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 ERA14LA325Accident · Minor injuriesLimited investigationFinal reportPiper PA 24-250 · Monroeville, ALA loss of engine power for reasons that could not be determined because postaccident examination of the engine and fuel system revealed no anomalies.NTSB 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 CEN14LA537Accident · Minor injuriesLimited investigationFinal reportHughes TH 55A · Hudson, WIThe nonhelicopter-rated pilot’s operation of the helicopter and its subsequent collision with trees during takeoff for reasons that could not be determined based on the available evidence.NTSB CEN14LA273Accident · Serious injuriesLimited investigationFinal reportBeech H35 · Monroe, LAThe loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.NTSB CEN14LA263Accident · No injuriesLimited investigationFinal reportAero Commander 200D · La Grange, TXThe loss of engine power due to oil starvation for reasons that could not be determined based on the available evidence.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 ERA14FA464Accident · 1 fatalField investigationFinal reportFortuna Dave Sonex · Dunnellon, FLThe in-flight collision with a tree in a heavily wooded area during controlled flight while the pilot was attempting a forced landing for reasons that could not be determined based on the available evidence. Contributing to the delay in locating the wreckage…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 WPR14FA135Accident · 2 fatalField investigationFinal reportEvolution Trikes Revo · Kekaha, HIThe pilot's reconfiguration of the fuel venting system, which resulted in a loss of engine power and subsequent loss of aircraft control.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…