NTSB investigations, 2013
76 cases where the defining event was Controlled flight into terr/obj (CFIT).
Cases per year
| 2008 | 41 |
|---|---|
| 2009 | 58 |
| 2010 | 49 |
| 2011 | 80 |
| 2012 | 66 |
| 2013 | 76 |
| 2014 | 45 |
| 2015 | 60 |
| 2016 | 47 |
| 2017 | 44 |
| 2018 | 50 |
| 2019 | 33 |
| 2020 | 32 |
| 2021 | 35 |
| 2022 | 30 |
| 2023 | 29 |
| 2024 | 27 |
| 2025 | 28 |
| 2026 | 26 |
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\") = 2013
AND c.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '120')
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") = 2013 AND c."mKey" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '120') 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 ERA14FA073Accident · 2 fatalField investigationFinal reportRaytheon 390 · Atlanta, GAThe pilot's failure to maintain airplane control while maneuvering the airplane in the traffic pattern at night. Contributing to the accident was the pilot's impairment from the use of illicit drugs.NTSB ANC14MA008Accident · 5 fatalMajor investigationFinal reportCessna 208B · Saint Marys, AKThe pilot's decision to initiate a visual flight rules approach into an area of instrument meteorological conditions at night and the flight coordinators' release of the flight without discussing the risks with the pilot, which resulted in the pilot…NTSB ERA14FA044Accident · 1 fatalField investigationFinal reportFocke-Wulf FWP 149D · Kenansville, NCThe pilot’s loss of control in instrument meteorological conditions for reasons that could not be determined because examination of the airframe and engine revealed no anomalies that would have precluded normal operation. Contributing to the accident was the…NTSB ANC14WA006Accident · 2 fatalForeign investigationSikorsky S76-C++ · Seoul, South KoreaOn November 16, 2013, about 2354 Coordinated Universal Time, a Sikorsky S76 C++ helicopter, Korean registration HL9294, operated by LG Electronics Co. Ltd., sustained substantial damage after colliding with a 26-story apartment building in Seoul, Korea. Both…NTSB ERA14WA063Accident · 3 fatalForeign investigationPiper PA-34-220T · Parati, Brazil, BrazilOn November 10, 2013 about 1600 universal coordinated time, a Piper PA-34-220T, Brazilian registration PR-EAG, was destroyed when it collided during a climb with the peak of Corisco Mountain, located in the Serra do Mar mountain range, near Parati…NTSB WPR14FA044Accident · 3 fatalField investigationFinal reportCessna U206F · Donnelly, IDThe pilot's failure to maintain clearance from terrain while maneuvering in likely low-ceiling and low-visibility conditions in mountainous terrain.NTSB ERA14FA027Accident · 1 fatalField investigationFinal reportCessna 172R · Nashville, TNThe noninstrument-rated pilot’s continued visual flight into night instrument flight rules conditions, which resulted in a collision with the runway during an attempted approach to land. Contributing to the accident was the pilot’s mental state, his…NTSB WPR14CA052Accident · Serious injuriesData collectionFinal reportBell 206B · Milo, ORThe pilot's failure to see and avoid wires while maneuvering at a low-altitude, which resulted in the main rotor blades striking the wires.NTSB WPR14WA034Accident · 2 fatalForeign investigationLancair Legacy · Shepparton, AustraliaOn October 25, 2013 about 1410 local time, an amateur built Lancair Legacy airplane, Australian registration VH-ICZ, collided with terrain near Shepparton, Australia. The airplane sustained substantial damage and the pilot and passenger were fatally injured.…NTSB WPR14WA029Accident · 1 fatalForeign investigationPZL Okecie M18 · Ulladulla, AustraliaOn October 24, 2013 about 1000 local time, a PZL M18A Dromader aircraft, Australian registration VH-TZJ, collided with terrain near Ulladulla, Australia. The airplane was substantially damaged and the pilot was fatally injured. The airplane was operated as an…NTSB WPR14WA032Accident · 1 fatalForeign investigationCessna 182 - Q · Mount Hotham, AustraliaOn October 23, 2013 about 1130 local time, a Cessna 182Q airplane, Australian registration VH-KKM, collided with terrain near Mount Hotham, Australia. The airplane sustained substantial damage and the pilot was fatally injured. The airplane was operated as a…NTSB CEN14LA015Accident · 2 fatalLimited investigationFinal reportNorth American P 51D · Galveston, TXThe pilot's loss of situational awareness while instructing the passenger, which resulted in the controlled flight of the airplane into the water.NTSB WPR14WA030Accident · 1 fatalForeign investigationAyres S2R · Wave Rock, AustraliaOn October 18, 2013 about 1500 local time, an Ayres S2R airplane, Australian registration VH-JAY, collided with terrain near Wave Rock, Australia. The airplane was destroyed and the pilot was fatally injured. The airplane was operated as an agricultural…NTSB CEN14FA010Accident · 1 fatalField investigationFinal reportCessna 177 · Clayton, OKControlled flight into terrain for reasons that could not be determined from the available evidence.NTSB ERA14WA020Accident · 1 fatalForeign investigationBell 407 - NO Series · Gobierno, ArgentinaOn October 11, 2013, at 1900 universal coordinated time, a Bell 407, Argentinian registration LQ-BHT, impacted power lines after takeoff near Gobierno, in the province of San Juan, Argentina. The pilot and three passengers were injured and one passenger was…NTSB CEN14WA115Accident · No injuriesForeign investigationGulfstream 550 · London, United KingdomOn October 12, 2013, at 0325 Universal Coordinated Time, a Saudi Arabia registered Gulfstream 550, HZ-A6, collided with the ILS antenna and localizer array while landing at Stanstead Airport (EGSS), London, United Kingdom. There were no injuries to the…NTSB WPR14CA013Accident · Serious injuriesData collectionFinal reportPiper PA 28-180 · Cody, WYA loss of engine power during climb to cruise for reasons that could not be determined due to no postaccident examination.NTSB WPR14FA012Accident · 2 fatalField investigationFinal reportMooney M20E · Julian, CAThe pilot’s failure to maintain clearance from terrain while maneuvering to avoid clouds in mountainous terrain.NTSB CEN14LA007Accident · Serious injuriesLimited investigationFinal reportCameron Balloons US V 77 · Rio Rancho, NMThe pilot's failure to maintain adequate clearance from power lines on approach to land, resulting in a collision with the wires, a spark, and a subsequent explosion and on-board fire.NTSB WPR14LA007Accident · 3 fatalLimited investigationFinal reportPiper PA32 - 300 · Tinian IslandThe pilot’s failure to maintain terrain clearance while maneuvering at low altitude in dark night conditions.NTSB WPR14CA003Accident · No injuriesData collectionFinal reportAir Tractor AT 402B · Wellton, AZThe pilot’s distracted attention and failure to maintain sufficient altitude to clear terrain while maneuvering in dark night conditions.NTSB WPR13WA433Accident · 5 fatalForeign investigationBell 212 - NO Series · Murbad, Thane District, India, IndiaOn September 29, 2013, at 0820 universal coordinated time, a Bell 212, VT-HGB, collided with terrain during cruise flight near Murbad (Thane District), India. The helicopter was destroyed and two flight crew and three passengers were fatally injured. The…NTSB WPR13WA423Accident · 1 fatalForeign investigationCessna 182 - R · Hamilton Aerodrome, Australia, AustraliaOn September 23, 2013, at 1950 universal coordinated time, a Cessna 182R, VH-AUT, collided with terrain near Hamilton Aerodrome, Australia. The flight was being operated under the pertinent civil regulations of Australia. The solo student pilot was fatally…NTSB WPR13WA410Accident · 2 fatalForeign investigationCessna U206 - G · Croydon, AustraliaOn September 15, 2013, about 1530 Eastern standard time, an Australian registered Cessna 206, VH-WAV, impacted terrain about 95 miles Southeast of Croydon, Queensland, Australia. The airplane was destroyed and the pilot and passenger were fatally injured. The…NTSB ERA13WA411Accident · 2 fatalForeign investigationDornier 228 · Valparaiso, ChileOn September 9, 2013, about 0940 universal coordinated time (UTC), a Dornier 228-202K CC-CNW impacted terrain while on approach for landing at Viña del Mar Airfield/NAS Base Aeronaval Viña del Mar in Chile. The airplane was destroyed, and the commercial pilot…NTSB WPR13CA381Accident · Minor injuriesData collectionFinal reportCessna 172E · Meeteetse, WYThe student pilot's inadequate preflight planning and failure to maintain clearance from rising terrain, which resulted in controlled flight into terrain. Contributing to the accident was the pilot's lack of situational awareness.NTSB ERA13WA367Accident · 4 fatalForeign investigationCessna 172 · Bolzano, ItalyOn August 17, 2013, at 1400 Universal Coordinated Time (UTC), a Cessna FR172J, German registration D-EDQL, operated by a flying club, was destroyed following a collision with mountainous terrain near San Pellegrino, Italy. The local flight originated in…NTSB DCA13MA133Accident · 2 fatalClass 1 · MajorFinal reportAirbus A300 - F4 622R · Birmingham, ALthe flight crew's continuation of an unstabilized approach and their failure to monitor the aircraft's altitude during the approach, which led to an inadvertent descent below the minimum approach altitude and subsequently into terrain. Contributing to the…NTSB ANC13CA077Accident · No injuriesData collectionFinal reportAviat A-1B · Arctic Village, AKThe pilot's failure to maintain clearance from terrain while maneuvering at low altitude.NTSB ERA13WA359Accident · 2 fatalForeign investigationRobinson R-44 · Davidovo, RussiaOn August 6, 2013, at 1506 coordinated universal time (August 7, 2013, 0006 local time), an emergency locator beacon signal was detected for a Robinson R44, RA-06302, which was subsequently found destroyed on rising terrain about 7 nautical miles southwest of…NTSB CEN13FA465Accident · 1 fatalField investigationFinal reportAir Tractor AT-400 · Balko, OKThe pilot's failure maintain clearance from a meteorological tower while en route at a low altitude. Contributing to the accident was the sun's glare.NTSB ERA13FA349Accident · 2 fatalField investigationFinal reportBeech A36 · Alma, GADescent from cruise flight until impact with trees and the ground for reasons that could not be determined because postaccident examination of the wreckage did not reveal any anomalies that would have precluded normal operation and the pilot's autopsy and…NTSB ERA13CA353Accident · Minor injuriesData collectionFinal reportPiper/Cub Crafters PA-18-150 · Eagle Bay, NYThe pilot's failure to set the engine throttle to full power during a go-around.NTSB ERA13TA341Accident · Serious injuriesFinal reportMcdonnell Douglas Helicopter 369E · Jackson, KYThe helicopter pilot's inadvertent collision with an unmarked and uncharted utility wire of which he was unaware.NTSB CEN13LA442Accident · No injuriesLimited investigationFinal reportTexas Helicopter OH-13H/M74A · Streator, ILThe pilot's diverted attention during an agricultural application maneuver, which resulted in the helicopter impacting a corn field.NTSB CEN13LA447Accident · No injuriesLimited investigationFinal reportBell 206B · Tamaroa, ILThe pilot's failure to maintain clearance from terrain during an agricultural application maneuver.NTSB CEN13LA424Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-802A · Huntingburg, INThe pilot's failure to maintain clearance from a power line during an aerial application maneuver. Contributing to the accident was the pilot's failure to identify potential obstructions in the area before beginning low-altitude maneuvers.NTSB ERA13WA322Accident · Serious injuriesForeign investigationCessna 208B · Mathews Ridge, GuyanaOn July 15, 2013, about 1157 coordinated universal time, a Cessna 208B, Guyana registration 8R-AMS, operated by Air Services Limited, was substantially damaged when it impacted terrain during approach at Matthew's Ridge Airport (SYMR), Matthew's Ridge,…NTSB ERA13WA319Accident · 2 fatalForeign investigationDiamond DA40-180 · Ticlio, PeruNTSB DCA13MA120Accident · 3 fatalClass 1 · MajorFinal reportBoeing 777-200ER · San Francisco, CAThe flight crew's mismanagement of the airplane's descent during the visual approach, the pilot flying's unintended deactivation of automatic airspeed control, the flight crew's inadequate monitoring of airspeed, and the flight crew's delayed execution of a…NTSB CEN13LA394Accident · Minor injuriesLimited investigationFinal reportGulfstream-Schweizer A/C Gulfstream AM G-164B · Colfax, LAThe pilot’s failure to maintain clearance from a tree.NTSB ANC13FA058Accident · 3 fatalField investigationFinal reportBeech 95-B55 · Cantwell, AKThe pilot’s continued visual flight into instrument meteorological conditions, which resulted in an in-flight collision with mountainous terrain.NTSB CEN13FA274Accident · 2 fatalField investigationFinal reportBoeing-Stearman IB75A · Dayton, OHThe pilot's controlled flight into terrain. Contributing to the accident was the pilot's modified airshow maneuver, which placed the airplane at low altitude and airspeed and out of position within the performance area.NTSB ERA13WA293Accident · 2 fatalForeign investigationPiper PA-28-161 · Barcis, ItalyOn June 18, 2013 at 1655 Universal Coordinated Time (UTC), a Piper PA-28, French registration F-GHLY, privately operated, was substantially damaged when it impacted with the slope of a mountain near Barcis, Italy during a cross-country flight from Locarno…NTSB ERA13WA290Accident · 1 fatalForeign investigationBeech 58 · Albenga, ItalyNTSB ERA13WA289Accident · 2 fatalForeign investigationBell 212 · Tefe, BrazilOn June 14, 2013, about 0810 universal coordinated time, a Bell 212 helicopter, Brazilian registration PR-HRZ, operated by an oil and gas exploration and production company, was destroyed when it impacted terrain shortly after takeoff from a support base…NTSB ERA13LA281Accident · 1 fatalLimited investigationFinal reportCessna 172K · Newton, MSThe student pilot's failure to increase engine power during the descent for landing when instructed to do so by the flight instructor and the flight instructor's delayed remedial action, which resulted in collision with a static wire. Contributing to the…NTSB CEN13CA316Accident · No injuriesData collectionFinal reportSheldrick John H RV-6 · Brookfield, WIThe pilot's failure to maintain runway alignment and his failure to recognize that the airplane had drifted away from the runway prior to landing.NTSB ERA13CA260Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Ellenville, NYThe student pilot's inadequate preflight planning and failure to maintain clearance from rising terrain, which resulted in controlled flight into terrain.NTSB CEN13FA295Accident · 2 fatalField investigationFinal reportRobinson Helicopter R44 II · Cross Timbers, MOThe pilot's failure to see and avoid a power line during the low-altitude flight.