NTSB investigations, 2014
65 cases where the sequence of events included Unknown or undetermined.
Cases per year
| 2008 | 17 |
|---|---|
| 2009 | 31 |
| 2010 | 52 |
| 2011 | 44 |
| 2012 | 47 |
| 2013 | 43 |
| 2014 | 65 |
| 2015 | 82 |
| 2016 | 100 |
| 2017 | 83 |
| 2018 | 98 |
| 2019 | 83 |
| 2020 | 87 |
| 2021 | 95 |
| 2022 | 124 |
| 2023 | 152 |
| 2024 | 122 |
| 2025 | 120 |
| 2026 | 263 |
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 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."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 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 CEN15FA056Accident · 1 fatalField investigationFinal reportAero Commander 500A · McDade, TXThe pilot's failure to maintain adequate airspeed and his exceedance of the airplane's critical angle-of-attack for reasons that could not be determined based on the available evidence, which resulted in an aerodynamic stall/spin. Contributing to the accident…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 CEN15TA019Accident · No injuriesFinal reportBAE Systems Hawk MK 67 · Oklahoma City, OKThe loss of directional control during the takeoff roll for reasons that could not be determined during postaccident examinations and testing.NTSB 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 CEN14LA504Accident · 2 fatalLimited investigationFinal reportSaccio Thomas A Seawind 3000 · Bloomington, INAn in-flight fire for reasons that could not be determined because the examination of the airplane did not reveal the source of the fire.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 CEN14LA346Accident · 1 fatalLimited investigationFinal reportBuckeye Dream Machine · Ansley, NEThe powered parachute's reduced takeoff performance in tailwind conditions for reasons that could not be determined because a postaccident examination of the airframe and engine did not reveal any preimpact anomalies that would have precluded normal…NTSB 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 CEN14LA301Accident · No injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Lake City, ARThe partial loss of engine power for reasons that could not be determined based on the available evidence.NTSB 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 CEN14FA286Accident · 2 fatalField investigationFinal reportBell 206 L4 · South Timbalier PlatformThe pilot's loss of helicopter control for reasons that could not be determined based on the available information.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 ERA14LA279Accident · No injuriesLimited investigationFinal reportFrederick Hays-Roth Velocity Twin · Sebastian, FLThe pilot’s improper landing flare, which resulted in a bounced landing. Also causal to the accident were the pilot’s subsequent delayed decision to abort the landing and his improper execution of the aborted landing, which resulted in the airplane exceeding…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…