NTSB investigations, 2012
79 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\") = 2012
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") = 2012 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 DCA13WA041Accident · Serious injuriesForeign investigationFokker 100 · Heho, Myanmar (Burma)On December 25, 2102, at 08:50 local time, a Fokker 100, registration XY-AGC operated by Air Bagan as flight W9-11 crashed short of the runway at Heho Myanmar (Burma). The flight was a scheduled passenger flight from Mandalay. There was one fatality and…NTSB CEN13LA110Accident · Minor injuriesLimited investigationFinal reportBeech 95-B55 (T42A) · Las Cruces, NMThe pilot's failure to properly manage the airplane's fuel, which resulted in engine failure due to fuel starvation.NTSB WPR13FA073Accident · 2 fatalField investigationFinal reportBeech B100 · Libby, MTThe noncertificated pilot’s failure to maintain clearance from terrain while maneuvering to land in dark night conditions likely due to his geographic disorientation (lost). Contributing to the accident was the pilot’s improper decision to fly at night with a…NTSB WPR13FA312Accident · 1 fatalField investigationFinal reportMooney M20F · Yosemite Valley, CAThe pilot’s decision to continue flight into instrument meteorological conditions, which resulted in his failure to maintain situational awareness and sufficient altitude to clear mountainous terrain.NTSB ERA13WA089Accident · 4 fatalForeign investigationPiper PA34 · Zulia, ColombiaOn December 12, 2012, about 1530 universal coordinated time (1030 local time), a Piper PA-34-200T, Colombian registration HK4477G, was destroyed when it impacted rising mountainous terrain in the vicinity of La Cuchilla, near Zulia, Norte de Santander,…NTSB WPR13CA064Accident · Serious injuriesData collectionFinal reportRobinson Helicopter R44 II · Roosevelt Lake, AZThe pilot's visual disorientation, which resulted in a collision with the lake.NTSB CEN13LA094Accident · No injuriesLimited investigationFinal reportLsa America Allegro · Adrian, MIThe student pilot’s improper flight control input during a go-around and his interference with the flight instructor’s attempted remedial actions.NTSB CEN13LA088Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Rochester, MNThe pilot’s spatial disorientation during the instrument approach in night, instrument meteorological conditions, which resulted in the airplane descending below decision height and impacting terrain outside the lateral limits of the localizer. Contributing…NTSB ERA13CA077Accident · No injuriesData collectionFinal reportSchweizer SGS 2-33A · Middletown, NYThe pilot's improper altitude management in the landing pattern that caused the glider to impact trees on final approach.NTSB CEN13FA078Accident · 1 fatalField investigationFinal reportTaylorcraft BC12-D · Clutier, IAThe pilot’s failure to monitor, recognize, and identify obstacles on approach to landing, which resulted in an inadvertent collision with power lines. Contributing to the accident was the pilot’s expectation and assumption that there were no above-ground…NTSB WPR13TA051Accident · Minor injuriesFinal reportEurocopter AS350B3 2B1 · Newfield, AZThe pilot's distraction while retrieving an item behind him while the helicopter was on the ground with the engine running, which led to his aggressive overapplication of the flight controls after experiencing a ground resonance condition and subsequent loss…NTSB CEN13FA067Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Hillsdale, MIThe pilot's failure to maintain clearance from terrain during a straight-in night visual flight rules approach to land in hazy weather conditions. Contributing to the accident were the pilot's lack of recent night flying experience, the nonfunctional…NTSB ERA13WA078Accident · 1 fatalForeign investigationCessna R172K · Cuchilla La Laja, ColombiaOn November 19, 2012, about 1030 hours local, a Cessna R172K, Colombian registration HK4890G, collided with mountainous terrain near Cuchilla La Laja – Municipio de San Francisco, Departmento de Cundinamarca, Colombia. Instrument meteorological conditions…NTSB ERA13FA064Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Canton, CTThe pilot’s failure to maintain clearance from terrain while performing a night visual approach to an airport. Contributing to the accident were the dark night and the pilot's lack of recent experience flying at night.NTSB ANC13WA010Accident · 1 fatalForeign investigationCessna 208 · Snow Lake, CanadaOn November 18, 2012, about 1000 central standard time, a Cessna 208B airplane, (Canadian Registration C-GAGP) was on a VFR flight plan from Snow Lake (CJE4) to Winnipeg (CYWG), Manitoba, Canada. The airplane crashed in a wooded area near the Snow Lake…NTSB ERA13WA074Accident · 4 fatalForeign investigationPiper PA-31T · Curitiba, BrazilOn November 6, 2012, at 2030 Coordinated Universal Time (UTC), a Piper PA-31T, Brazilian registration PT-MFW, was destroyed when it impacted terrain while approaching Bacacheri Airport (SBBI), Curitiba, Brazil. The flight was operated by Taxi Aereo Hercules,…NTSB ERA13WA068Accident · 4 fatalForeign investigationEmbraer 810D · Chapada dos Guimaraes, BrazilOn November 1, 2012, at 1950 Universal Coordinated Time (UTC), an Embraer Aircraft model EMB-810D (Piper Design PA-34-220T), Brazilian registration PT-VRV, operated by a private owner, was substantially damaged following an encounter with weather and a…NTSB ERA13LA042Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-300 · Sevierville, TNThe air traffic controller’s failure to comply with the required vectoring and safety alert procedures, which resulted in the airplane’s flight into rising terrain. Contributing to the accident was the Federal Aviation Administration’s continued practice of…NTSB WPR13FA017Accident · 1 fatalField investigationFinal reportCessna 182P · Yucca, AZThe pilot’s failure to take corrective action to avoid terrain during cruise flight for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB CEN13LA016Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Wausau, WIThe pilot's decision to attempt an instrument approach in meteorological conditions below approach minimums and his failure to properly execute a missed approach.NTSB ERA13WA031Accident · 1 fatalForeign investigationRobinson R-44 · Moscow, RussiaNoneNTSB ERA13LA019Accident · 3 fatalLimited investigationFinal reportPiper PA-23-250 · Charlotte AmalieThe pilot's attempted visual flight rules (VFR) flight into marginal VFR conditions on a dark night over water and his failure to maintain sufficient altitude, which resulted in the airplane’s controlled flight into water. Contributing to the accident was the…NTSB CEN13FA009Accident · 1 fatalField investigationFinal reportBell 206B · Crowley, LAThe pilot’s failure to maintain clearance from the broadcast tower guy-wires.NTSB WPR13FA008Accident · 4 fatalField investigationFinal reportPiper PA-32R-301T · Laramie Peak, WYThe noninstrument-rated pilot’s continued visual flight into instrument meteorological conditions, which resulted in his failure to maintain sufficient clearance from rising terrain.NTSB CEN13CA026Accident · Minor injuriesData collectionFinal reportMace Justin I Dragonfly · Durango, COThe pilot’s delayed decision to perform a go-around, which resulted in the airplane impacting trees. Contributing to the accident was the pilot’s inexperience in the accident airplane and his encounter with conditions that exceeded his capabilities.NTSB ERA13WA156Accident · 1 fatalForeign investigationCessna 172S · Izmir, TürkiyeOn October 6, 2012, at 0915 Coordinated Universal Time (UTC), a Cessna 172S, Turkish registration TC-CBI, operated by the Turkish Aeronautical Association, impacted mountainous terrain during an instructional flight, near Izmir, Turkey. The flight instructor…NTSB WPR13WA014Accident · 1 fatalForeign investigationRobinson R22 · Halls Creek, Australia, AustraliaOn October 3, 2012, at about 1100 universal coordinated time, a Robinson Helicopter Company, R-22 Beta, VH-LLF, sustained substantial damage when it collided with the side of a canyon near the Halls Creek Aerodrome, Australia. The pilot was fatally injured.…NTSB WPR13FA001Accident · Serious injuriesField investigationFinal reportPiper PA-28-180 · Beatty, NVThe pilot’s inadequate flight planning, subsequent loss of situational awareness, and failure to maintain clearance from the power lines during a dark night approach to a closed, unlit runway.NTSB CEN12LA661Accident · No injuriesLimited investigationFinal reportLake LA4 · Kenosha, WIThe loss of engine power for reasons that could not be determined because examination and test run of the engine did not reveal any anomalies that would have precluded normal operation.NTSB CEN12LA678Accident · Minor injuriesLimited investigationFinal reportInfinity 2003 · Merrill, MIThe pilot's improper decision to attempt a takeoff from midfield, resulting in a collision with trees at the departure end of the field.NTSB CEN12CA658Accident · No injuriesData collectionFinal reportCessna 175A · Spearfish, SDThe pilot's delayed decision to abandon the landing attempt, which resulted in the airplane colliding with rising terrain.NTSB ERA12LA578Accident · 1 fatalLimited investigationFinal reportCessna 172B · Atlantic Ocean (Atlantic Ocean)The pilot’s suicidal act.NTSB ERA12LA575Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Fort Thomas, KYThe pilot’s failure to periodically add engine power during an extended descent in carburetor icing conditions, which resulted in insufficient carburetor heat, the gradual build-up of carburetor ice, and the subsequent loss of engine power.NTSB WPR12LA433Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Firebaugh, CAThe pilot’s decision to continue the takeoff after the engine stopped producing its full-rated torque while operating in high-density altitude conditions and his subsequent failure to maintain clearance from the power transmission wires.NTSB ERA12FA572Accident · 1 fatalField investigationFinal reportCessna 172S · Land O'Lakes, FLThe pilot’s decision to continue the cross-country flight while fatigued, which resulted in him falling asleep during the initial descent for landing.NTSB CEN12FA639Accident · 2 fatalField investigationFinal reportMooney M20J · Teddys Peak, COThe pilot's decision to continue flight into deteriorating weather conditions, including fog and mountain obscuration, and his failure to maintain clearance with known rising terrain along the route of flight, which resulted in controlled flight into terrain.NTSB WPR12LA406Accident · Minor injuriesLimited investigationFinal reportAviat A-1B · Durham, CAA loss of engine power during takeoff initial climb for reasons that could not be determined because postaccident examination of the engine revealed no anomalies that would have precluded normal operation.NTSB ANC12LA097Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Coldfoot, AKThe pilot's failure to maintain clearance from terrain while maneuvering to reverse course.NTSB ERA12CA548Accident · Serious injuriesData collectionFinal reportHandy James L Buckeye Dream Mach · West Caln, PAThe pilot’s inadequate compensation for the wind during the initial climb, which resulted in collision with a tree and terrain.NTSB ANC12FA095Accident · 1 fatalField investigationFinal reportBellanca 7GCBC · Homer, AKThe pilot's failure to see and avoid high tension power lines.NTSB CEN12FA586Accident · 2 fatalField investigationFinal reportPiper PA-23-150 · Canton, MOThe pilot's improper decision to attempt to execute a forced landing to an open field with obstacles. Contributing to the accident was the left engine’s total loss of power due to fuel starvation as a result of the introduction of air into the fuel system…NTSB WPR12FA369Accident · 5 fatalField investigationFinal reportPiper PA-32-301T · South Lake Tahoe, CAA partial loss of engine power for reasons that could not be determined because examinations revealed no evidence of mechanical anomalies with the airframe or engine that would have precluded normal operation and the pilots’ decision to continue the departure…NTSB ERA12FA527Accident · 1 fatalField investigationFinal reportBell 407 · Abingdon, VAThe pilot's improper decision to make a low-level departure over water in dark night conditions without lights, which resulted in controlled flight into the water. Contributing to the accident was the pilot's likely spatial disorientation due to a vestibular…NTSB WPR12LA365Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · McCall, IDThe flight instructor’s selection of the wrong route while flying in mountainous terrain at a high-density altitude, which resulted in the airplane impacting terrain when the increase in elevation exceeded the airplane’s climb performance.NTSB CEN12FA517Accident · 1 fatalField investigationFinal reportBellanca 7GCBC · Imperial, NEThe pilot’s failure to maintain adequate clearance from rising terrain while flying toward the rising sun, which interfered with his ability to see the terrain.NTSB ERA12CA495Accident · No injuriesData collectionFinal reportPiper PA-25-260 · Alexander, NYThe pilot's inadequate visual lookout and failure to maintain altitude during aerial application, which resulted in controlled flight into terrain.NTSB ANC12FA083Accident · 1 fatalField investigationFinal reportPiper PA-32-301 · Hoonah, AKThe pilot's failure to maintain clearance from trees and terrain while in cruise flight in marginal visual meteorological conditions.NTSB ERA12WA488Accident · 8 fatalForeign investigationBeech 200 · Juiz de Fora, BrazilThis investigation is being conducted by the Brazilian Aeronautical Accident Prevention and Investigation Center This report is for information purposes only and contains only information released by the government Brazil. All inquiries should be directed to…NTSB ERA12FA483Accident · 1 fatalField investigationFinal reportCessna 172P · Plainville, CTThe pilot's failure to maintain the proper glidepath during final approach in visual meteorological conditions, resulting in collision with a berm.NTSB ERA12LA455Accident · Serious injuriesLimited investigationFinal reportBurkhart Grob G 103 Twin II · Hilltown, PAThe improper decision of the flight instructor receiving instruction to attempt a course reversal rather than land straight ahead following a simulated low-level rope break, and the inadequate remedial action of the flight instructor-in-command for allowing…