NTSB investigations, 2014
61 cases where the sequence of events included Controlled flight into terr/obj (CFIT).
Cases per year
| 2008 | 57 |
|---|---|
| 2009 | 70 |
| 2010 | 70 |
| 2011 | 99 |
| 2012 | 79 |
| 2013 | 91 |
| 2014 | 61 |
| 2015 | 75 |
| 2016 | 56 |
| 2017 | 68 |
| 2018 | 63 |
| 2019 | 40 |
| 2020 | 35 |
| 2021 | 39 |
| 2022 | 35 |
| 2023 | 38 |
| 2024 | 39 |
| 2025 | 33 |
| 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\") = 2014
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '120' 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" = '120' 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 CEN15FA090Accident · 1 fatalField investigationFinal reportCessna 404 · Englewood, COThe loss of power to the right engine for reasons that could not be determined during postaccident examination and teardown and the pilot’s failure to properly configure the airplane for single-engine flight.NTSB CEN15LA077Accident · Serious injuriesLimited investigationFinal reportNew Piper PA 32R-301T · Springfield, MOThe pilot’s decision to descend below the recommended altitude during approach for landing in night visual meteorological conditions, and his failure to see and avoid a lighted tower, which resulted in collision with the tower and a subsequent total loss of…NTSB CEN15FA051Accident · 2 fatalField investigationFinal reportMooney M20C · Pagosa Springs, COThe noninstrument-rated pilot's improper decision to fly to the destination airport and into known instrument meteorological conditions, which resulted in his controlled flight into mountainous terrain during a snow storm.NTSB ERA15RA047Accident · 9 fatalForeign investigationGates Learjet 35A · Freeport, BahamasNTSB ERA15FA046Accident · 1 fatalField investigationFinal reportCessna 172 · Hinton, VAThe flight instructor’s decision to conduct a night training flight in mountainous terrain without conducting or allowing the student to conduct appropriate preflight planning and his lack of situational awareness of the surrounding terrain altitude, which…NTSB CEN15LA042Accident · Minor injuriesLimited investigationFinal reportMosier Robert S Mosquito XET · Angleton, TXThe pilot’s failure to maintain adequate clearance from trees during a precautionary landing. Contributing to the accident was the pilot’s inadequate preflight inspection during which he failed to detect a loose drive belt, which resulted in an in-flight…NTSB ERA15CA036Accident · Serious injuriesData collectionFinal reportSix Chuter SR7 XL · Fairview, NCThe non-certificated pilot's delayed go-around procedure, which resulted in collision with trees. Contributing to the accident was the pilot's lack of total flying experience.NTSB CEN15CA005Accident · No injuriesData collectionFinal reportCessna 152 · Arlington, TXThe pilot's inadequate flight preparation and navigation during a training flight resulting in collision with low wires.NTSB ERA15CA002Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Toccoa, GAThe private pilot's failure to maintain proper altitude and the flight instructor's failure to provide correction action, which resulted in a collision with terrain during landing.NTSB CEN14FA522Accident · 1 fatalField investigationFinal reportCessna T337G · Plano, ILThe pilot’s failure to recognize the airplane’s low altitude and arrest the airplane’s descent on approach to the airport in dark night conditions, which resulted in controlled flight into terrain. Contributing to the accident was the pilot’s degraded night…NTSB ERA14LA462Accident · Serious injuriesLimited investigationFinal reportQuicksilver Eipper Acft GT 400 · Lebanon, CTThe pilot’s misjudgment of the takeoff distance needed to clear trees at the end of the runway.NTSB WPR14FA382Accident · 2 fatalField investigationFinal reportPiper PA 28R-180 · Saratoga, WYThe pilot’s failure to maintain a positive climb rate after takeoff in dark, night conditions, which resulted in his controlled flight into terrain due to the lack of ground references or natural horizon.NTSB WPR14CA375Accident · No injuriesData collectionFinal reportEurocopter AS 350 B2 · Kahului, Maui, HIThe pilot's failure to maintain clearance from the cart while hovering. Contributing to the accident was the failure of ground personnel to remove the cart from the helipad.NTSB ERA14LA433Accident · Serious injuriesLimited investigationFinal reportPiper J3C 65 · Carrol County, VAThe pilot’s failure to maintain clearance from trees during an emergency landing after encountering deteriorating weather conditions. Contributing to the accident was the pilot’s poor preflight weather planning, which resulted in an inadvertent encounter with…NTSB ERA14CA430Accident · Minor injuriesData collectionFinal reportCessna 172M · Watertown, CTThe pilot's decision to takeoff from a field which resulted in a collision with trees and the ground. Contributing to the accident was the pilot's failure to correctly identify the destination airport and runway, which resulted in an off-airport landing in…NTSB CEN14LA487Accident · 1 fatalLimited investigationFinal reportRobinson Helicopter R44 II · Macedonia, IAThe pilot’s inadequate visual lookout, which resulted in a collision with a static line.NTSB WPR14FA362Accident · 1 fatalField investigationFinal reportCessna 177B · Neihart, MTThe pilot's failure to maintain clearance from terrain while maneuvering at low altitude in turbulent conditions over mountainous terrain. Contributing to the accident was the pilot's improper decision to traverse the mountainous area with the airplane over…NTSB ERA14LA409Accident · 1 fatalLimited investigationFinal reportCessna A188B · Middleton, TNThe pilot’s failure to see and avoid power lines during a low-level aerial application operation.NTSB ANC14FA068Accident · Serious injuriesField investigationFinal reportRyan Navion A · Coldfoot, AKThe pilot’s improper inflight planning and improper decision to deliberately operate the airplane at low altitude in close proximity to obstructions and rising terrain. Contributing to the accident were the pilot’s improper preflight planning and the Federal…NTSB WPR14FA349Accident · 1 fatalField investigationFinal reportBeech V35B · Novato, CAThe instrument-rated pilot's decision to conduct a visual approach to the airport in night, instrument meteorological conditions, which resulted in controlled flight into terrain. Contributing to the accident was the pilot's loss of situational awareness, the…NTSB WPR14FA348Accident · 1 fatalField investigationFinal reportCliff Starduster II SA300 · Placerville, CAThe pilot's failure to maintain control of the airplane during a go-around in gusting wind conditions following a partial loss of engine power for reasons that could not be determined, because postaccident examination of the airframe and engine did not reveal…NTSB CEN14FA414Accident · 2 fatalField investigationFinal reportPiper PA 28R-201 · Steamboat Springs, COThe pilot’s inability to maintain a climb while attempting to cross over a mountain pass in high-density altitude conditions that degraded the airplane’s climb performance. Contributing to the accident was the pilot’s decision to attempt the flight in…NTSB ERA14FA372Accident · 2 fatalField investigationFinal reportCessna 182F · Gansevoort, NYThe pilot’s failure to maintain directional control during initial climb following a banner pick-up, resulting in collision with a tree.NTSB ERA14CA366Accident · Minor injuriesData collectionFinal reportCessna 150M · Waterloo, NYThe pilot's failure to maintain adequate clearance from obstructions while on approach to the runway.NTSB CEN14CA429Accident · No injuriesData collectionFinal reportAir Tractor AT 502B · Minden, NEThe pilot's inadequate survey of the aerial application field which resulted in a collision with a windmill.NTSB ERA14FA359Accident · 1 fatalField investigationFinal reportPiper PA-46-310P · Clayton, GAThe pilot’s decision to begin a flight with fog and low clouds present at the airport, which resulted in an encounter with instrument meteorological conditions immediately after takeoff and a controlled flight into terrain.NTSB ERA14LA347Accident · Serious injuriesLimited investigationFinal reportColt Balloons 160A · Clinton, MAThe pilot's inadequate preflight and inflight planning and improper landing site selection and approach path, which resulted in the balloon contacting powerlines during landing. Contributing to the accident was the Federal Aviation Administration's inadequate…NTSB WPR14LA300Accident · Serious injuriesLimited investigationFinal reportLuscombe 8A · Rancho Cucamonga, CAThe loss of engine power during cruise flight for reasons that could not be determined because postaccident examination revealed no anomalies that would have precluded normal operation.NTSB CEN14CA382Accident · Serious injuriesData collectionFinal reportGremminger Greg Magni M 16 · Cape Girardeau, MOThe pilot's failure to maintain sufficient altitude while maneuvering which led to a collision with power lines.NTSB ERA14LA355Accident · No injuriesLimited investigationFinal reportPipistrel Alpha Trainer · Pompano Beach, FLThe pilot’s miscalculation of the fuel quantity requirements, which resulted in fuel exhaustion.NTSB WPR14FA286Accident · 1 fatalField investigationFinal reportCessna 182 · Fall City, WAThe pilot’s decision to depart in low-ceiling conditions and his continued visual flight rules flight into instrument meteorological conditions, which resulted in controlled flight into terrain.NTSB WPR14WA318Accident · 1 fatalForeign investigationCessna T210N · Inverell, Australia, AustraliaOn July 4, 2014, at 1325 local time, a Cessna T210N, VH-ZFW, collided with terrain shortly after takeoff from Inverell, Australia. The airplane was operated by the pilot under the pertinent civil regulations of the government of Australia. The airplane was…NTSB CEN14LA379Accident · 1 fatalLimited investigationFinal reportKolb Mark III · Jonesville, LAThe noncertificated pilot's failure to maintain clearance from trees.NTSB WPR14FA262Accident · 2 fatalField investigationFinal reportMooney M20B · Page, AZThe pilot’s failure to maintain adequate clearance from terrain while maneuvering in a canyon in high-density altitude conditions.NTSB ERA14LA308Accident · No injuriesLimited investigationFinal reportTaylor J-2 · Lock Haven, PAThe airplane owner’s failure to clean and lubricate the engine valve guides and stems, which resulted in a partial loss of engine power during the initial climb due to an exhaust valve failure.NTSB ERA14WA287Accident · 3 fatalForeign investigationCessna 172N · Premana Lecco, ItalyNTSB CEN14LA244Accident · Minor injuriesLimited investigationFinal reportCrawford Preceptor Ultra PUP · Mabel, MNThe loss of engine power as a result of carburetor icing.NTSB ERA14WA246Accident · Serious injuriesForeign investigationCessna T206H · Macas, EcuadorOn May 14, 2014, about 1600 local time, a Cessna T206H, Ecuadorian registration HC-CFE, was substantially damaged when it impacted power lines while returning to land at Edmundo Carvajal Airport (SEMC), Macas, Ecuador, with smoke in the cockpit. The…NTSB ERA14FA232Accident · 1 fatalField investigationFinal reportNavion G · Hamilton Township, NJThe pilot's mismanagement of the onboard fuel supply, which resulted in fuel starvation to the engine and a subsequent loss of engine power. Contributing to the death of the right front passenger was the inadequate occupant restraint.NTSB ERA14FA231Accident · 3 fatalField investigationFinal reportEagle C-7 · Ruther Glen, VAThe pilot’s inadequate approach and his failure to maintain clearance from power lines, which resulted in a subsequent fire.NTSB WPR14FA188Accident · 2 fatalField investigationFinal reportMooney M20C · Cody, WYThe non-instrument rated pilots’ decision to continue flight into known instrument meteorological conditions over mountainous terrain, which resulted in controlled flight into terrain.NTSB ERA14WA221Accident · 2 fatalForeign investigationPiper PA-31 · Santander, ColombiaOn May 3, 2014, about 1500 coordinated universal time, a Piper PA-31, Canadian registration C-GSVM, was substantially damaged when it impacted terrain near Santander, Colombia. The pilot and passenger were fatally injured. The local survey flight departed…NTSB WPR14LA177Accident · Serious injuriesLimited investigationFinal reportAirplane Factory Ltd The Sling · Daggett, CAThe pilots’ failure to maintain clearance from terrain while operating in dark night, visual meteorological conditions. Contributing to the accident was the pilots’ failure to enable the aural terrain warning system.NTSB CEN14FA224Accident · 4 fatalField investigationFinal reportPiper PA 32R-300 · Highmore, SDThe pilot's decision to continue the flight into known deteriorating weather conditions at a low altitude and his subsequent failure to remain clear of an unlit wind turbine. Contributing to the accident was the inoperative obstruction light on the wind…NTSB CEN14CA209Accident · No injuriesData collectionFinal reportPiper PA 28-181 · Put in Bay, OHAn inflight collision with a goose while on an approach.NTSB WPR14CA168Accident · Minor injuriesData collectionFinal reportLinstrand 240A · Mayer, AZThe balloon's encounter with unexpected increased wind, which resulted in a hard landing on rough terrain.NTSB ERA14WA207Accident · 4 fatalForeign investigationEmbraer EMB-720D · Aripuanã, BrazilOn April 6, 2014, about 1130 universal coordinated time, an Embraer EMB-720D, Brazilian registration PT-ROS, was destroyed when it impacted trees and terrain near Aripuanã, Brazil. The pilot and three passengers were fatally injured. The flight originated…NTSB ERA14WA187Accident · 1 fatalForeign investigationPiper PA-30 · Collagna, ItalyOn April 4, 2014, at 0920 Coordinated Universal Time (UTC), a Piper PA-30, N678AL, was destroyed when it impacted terrain during cruise flight near Collagna, Italy. The pilot, the sole occupant, was fatally injured. The flight was operated by a private…NTSB CEN14WA184Accident · 2 fatalForeign investigationCessna T210L · San Marcos, GuatemalaOn April 1, 2014, about 1340 local time, a Cessna T210L, single engine airplane, N732JY, was destroyed after impacting mountainous terrain near San Marcos, Guatemala. The pilot and passenger were fatally injured. About 1318 the airplane departed from…NTSB ERA14CA175Accident · Minor injuriesData collectionFinal reportBeech S35 · Marathon, FLThe pilot's distraction in the cockpit while on a visual approach over water during a dark night resulting in the airplane descending until impact with the water.