Fatal NTSB investigations, 2011
60 cases where the sequence of events included Controlled flight into terr/obj (CFIT).
Cases per year
| 2008 | 42 |
|---|---|
| 2009 | 38 |
| 2010 | 38 |
| 2011 | 60 |
| 2012 | 47 |
| 2013 | 49 |
| 2014 | 34 |
| 2015 | 47 |
| 2016 | 34 |
| 2017 | 38 |
| 2018 | 37 |
| 2019 | 33 |
| 2020 | 24 |
| 2021 | 27 |
| 2022 | 23 |
| 2023 | 23 |
| 2024 | 27 |
| 2025 | 18 |
| 2026 | 16 |
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\") = 2011
AND c.\"highestInjuryLevel\" = 'Fatal'
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") = 2011 AND c."highestInjuryLevel" = 'Fatal' 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 ERA12WA133Accident · 2 fatalForeign investigationPiper PA28 · Andres Bello,Tachira, VenezuelaOn December 29, 2011, about 1415 universal coordinated time, a Piper PA28-161, Columbian registration HK3934, was substantially damaged when it impacted terrain while in cruise flight near Andres Bello, Tachira, Venezuela. The two pilots were fatally injured.…NTSB ERA12MA122Accident · 3 fatalMajor investigationFinal reportBell 206B · Green Cove Springs, FLThe pilot’s improper decision to continue visual flight into night instrument meteorological conditions, which resulted in controlled flight into terrain. Contributing to the pilot’s improper decision was his self-induced pressure to complete the trip.NTSB CEN12LA109Accident · 1 fatalLimited investigationFinal reportCessna 172R · Denton, TXThe pilot's controlled flight into terrain while maneuvering at a low altitude in instrument meteorological conditions. Contributing to the accident was the pilot's decision to perform a circling maneuver in weather below circling minimums instead of flying…NTSB ERA12WA113Accident · 1 fatalForeign investigationRobinson R44 · Sao Bento do Sul, BrazilOn December 9, 2011 at 1630 universal coordinated time, a Robinson R44, Brazilian registration PR-KLA, operated by SASH Locacao de Veiculos LTDA, as a personal flight, impacted terrain in the vicinity of Fazenda Coqueiros, Sao Bento do Sul, Santa Catarina,…NTSB ERA12WA103Accident · 4 fatalForeign investigationCessna TU206 · Cerro Escalera, PeruOn December 1, 2011, about 2048 UTC, a Cessna TU206G, Peruvian registration OB-1299, registered to and operated by Palmas del Espino S.A., collided with mountainous terrain near Cerro Escalera, Peru. Weather conditions at the altitude, location, and time of…NTSB ANC12FA009Accident · 1 fatalField investigationFinal reportCessna 207 · Chuathbaluk, AKThe pilot’s loss of situational awareness after an inadvertent encounter with instrument meteorological conditions, which resulted in an in-flight collision with tree-covered terrain.NTSB WPR12MA046Accident · 6 fatalMajor investigationFinal reportRockwell 690 · Apache Junction, AZThe pilot's failure to maintain a safe ground track and altitude combination for the moonless night visual flight rules flight, which resulted in controlled flight into terrain. Contributing to the accident were the pilot's complacency and lack of situational…NTSB ERA12WA073Accident · 2 fatalForeign investigationCessna 150 · Santa Rosa, EcuadorOn November 14, 2011, about 2020 coordinated universal time (1520 local time), a Cessna 150M, Ecuadorian registration HC-BJA, was substantially damaged when it impacted rising terrain in the Girón Alto mountains near Santa Rosa, Ecuador. The Ecuadorian pilot…NTSB WPR12FA021Accident · 1 fatalField investigationFinal reportCessna 182R · Lexington, ORThe pilot’s failure to maintain situational awareness and terrain clearance on a dark night during the approach to landing.NTSB ERA12FA030Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · Danbury, CTThe pilot did not maintain clearance from a lighted tower during final approach in night visual conditions.NTSB CEN12FA010Accident · 1 fatalField investigationFinal reportBrinkerhuff Gerald G Q200 · Holland, MIThe pilot failed to maintain sufficient altitude during the landing approach, which resulted in the airplane contacting an approach light. Contributing to the accident was the setting sun, which most likely obscured the pilot’s vision.NTSB ERA12WA026Accident · 4 fatalForeign investigationBeech V35 · Maraba Paulista, BrazilOn October 1, 2011, about 2345 coordinated universal time (2045 local time), a Beechcraft V35, Brazilian registration PT-CTL, was substantially damaged when it impacted terrain between the cities of Maraba Paulista and Presidente Venceslau, Sao Paulo State,…NTSB ERA11WA520Accident · 2 fatalForeign investigationBeech D35 · Avare, BrazilOn September 29, 2011, about 1824 Universal Coordinated Time (UTC), a Beech D35, Brazilian registration PT-AVK, operated by a private owner, was destroyed following a collision with terrain at Santarém Municipality, State of Pará, Brazil. The local flight…NTSB CEN11FA666Accident · 2 fatalField investigationFinal reportRobinson Helicopter R44 · Curren, MIThe non-instrument-rated pilot's decision to continue visual flight into instrument meteorological conditions, which resulted in controlled flight into trees and the ground. Contributing to the accident was the pilot's impairment from multiple drugs.NTSB ANC11FA107Accident · 1 fatalField investigationFinal reportDehavilland DHC-3T · Kodiak, AKThe pilot’s failure to maintain clearance from a tree during a low altitude maneuver and his failure to maintain control of the airplane. Contributing to the accident was the pilot’s use of over-the-counter sedating medications.NTSB CEN11FA663Accident · 1 fatalField investigationFinal reportThorp T-18 · Plainwell, MIThe pilot did not maintain clearance from a semitrailer along the approach path.NTSB ERA11WA499Accident · 3 fatalForeign investigationBeech 99 · Cap Haitien, HaitiOn September 20, 2011, at 2130 universal coordinated time, a Hawker Beechcraft BE-99A, registered in Haiti as HH-APA, was substantially damaged when it impacted terrain while on approach to the Cap Haitien International Airport (MTCH), Cap Haitien, Haiti. The…NTSB WPR11WA475Accident · 2 fatalForeign investigationCessna 208B · Wamean, West Papua, IndonesiaOn September 9, 2011, at 1223 local time (0323 UTC) a Cessna 208B, Indonesia registry PK-VVE, collided with mountainous terrain 8 nautical miles north east of Wamena Airport, Wamena, West Papau, Indonesia. The aircraft was operated by Susi Air under the…NTSB DCA11RA098Accident · 8 fatalForeign investigationM7Aero SW3 · Trinidad, BoliviaOn September 6, 2011, an Aerocon Swearingen SA-227 Metroliner, registration CP-2548 performing flight A4-238 from Santa Cruz to Trinidad (Bolivia) with 7 passengers and 2 crew, was on approach to Trinidad when radio contact was lost. The airplane was located…NTSB WPR11FA430Accident · 2 fatalField investigationFinal reportCessna P210 · Tehachapi, CAThe pilot’s intentional low-altitude maneuvering and failure to maintain clearance from terrain due to distraction.NTSB WPR11WA438Accident · 1 fatalForeign investigationRobinson R44 · Plutonic Aero., Australia, AustraliaOn September 3, 2011, at 0330 universal coordinated time, a Robinson R44, Australia registry VH-HCA, collided with terrain while maneuvering near Plutonic Aerodrome, Australia. The helicopter was operated by Wieland Helicopter Company under the pertinent…NTSB ERA11FA480Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Provincetown, MAThe pilot’s failure to maintain adequate clearance from trees and terrain during the initial climb. Contributing was spatial disorientation due to a vestibular illusion and the pilot’s likely impairment due to alcohol consumption.NTSB ERA11FA467Accident · 2 fatalField investigationFinal reportCessna 172M · Titusville, PAThe flight instructor's improper decision to attempt a visual descent into instrument meteorological conditions while approaching the destination airport, which resulted in an in-flight collision with trees and terrain.NTSB WPR11FA381Accident · 2 fatalField investigationFinal reportBeech A36 · Lander, WYThe pilot’s failure to maintain clearance from mountainous terrain.NTSB ANC11FA077Accident · 2 fatalField investigationFinal reportCessna 207 · McGrath, AKThe pilot's decision to continue visual flight rules flight into instrument meteorological conditions, which resulted in an in-flight collision with mountainous terrain.NTSB WPR11FA354Accident · 2 fatalField investigationFinal reportCirrus SR20 · Fredonia, AZThe non-instrument-rated pilots’ loss of situational awareness during a dark night flight over a remote area, which resulted in their failure to maintain an altitude sufficient to ensure adequate terrain clearnance. Contributing to the accident was the…NTSB CEN11WA592Accident · 1 fatalForeign investigationSocata TB10 · Kufstein, AustriaUnder the jurisdiction and control of the Austrian government.NTSB ERA11LA424Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-602 · Drew, MSThe pilot's improper decision to conduct a visual flight rules aerial application flight in instrument meteorological conditions, which resulted in an in flight collision with the ground while maneuvering.NTSB ERA11FA422Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Berne, NYThe pilot's continued visual flight into instrument meteorological conditions, which resulted in a collision with trees and rising terrain while attempting to reverse course. Contributing to the accident was the pilot's failure to obtain a preflight weather…NTSB ANC11FA069Accident · 2 fatalField investigationFinal reportCessna 182P · Juneau, AKThe pilot's continued visual flight into instrument meteorological conditions, which resulted in an in-flight collision with mountainous terrain. Contributing to the accident was the pilot's self-induced pressure to reach his destination.NTSB ERA11WA439Accident · 1 fatalForeign investigationRobinson R-44 · Istok, RussiaOn July 9, 2011, at 1900 universal coordinated time, a Robinson R-44, Russian registration RA-04304, registered to and operated by a private owner, collided with the Yenisei River, near Istok, Krasnoyarsk Region, Russia, during a repositioning flight at…NTSB WPR11FA319Accident · 2 fatalField investigationFinal reportPiper PA-22-135 · Verlot, WAThe non-instrument rated pilot’s decision to continue visual flight into clouds and his failure to maintain clearance from terrain while maneuvering in an area of reduced visibility, low clouds, and mountain obscuration.NTSB ERA11WA368Accident · 3 fatalForeign investigationCirrus SR20 · Cairo Montenotte, ItalyOn June 23, 2011, about 1000 UTC, a Cirrus SR20, Luxembourg registration LX-MPR, operated by a private individual, collided with mountainous terrain near Cairo Montenotte, Italy. Instrument meteorological conditions prevailed in the area at the time and…NTSB WPR11FA268Accident · 1 fatalField investigationFinal reportTrusty Thorp T-18 · Tehachapi, CAThe pilot’s failure to maintain clearance from mountainous terrain during cruise flight, which resulted from his impairment or incapacitation due to multiple medical conditions and sedating medication.NTSB ERA11FA349Accident · 4 fatalField investigationFinal reportCessna T210N · Armonk, NYThe pilot's decision to depart on the flight with a suspected mechanical deficiency and his subsequent decision to fly the final approach at a reduced power setting. Contributing to the accident was the improper timing of the magneto(s) that resulted in a…NTSB CEN11WA407Accident · 2 fatalForeign investigationPiper PA-39 · Mont Agel, FranceUnder the jurisdiction and control of the French government.NTSB ERA11FA321Accident · 4 fatalField investigationFinal reportBeech V35 · Ellijay, GAThe pilot’s failure to maintain adequate clearance from terrain while maneuvering in a mountainous area.NTSB WPR11FA241Accident · 3 fatalField investigationFinal reportCessna R172K · Cold Springs, NVThe pilot's continued visual flight rules flight into instrument meteorological conditions, which resulted in a controlled collision with terrain.NTSB ERA11WA308Accident · 2 fatalForeign investigationBell 206L-3 · Norte de Santander, ColombiaOn May 23, 2011, about 2105 Universal Coordinated Time (UTC), a Bell 206L-3, Columbian registration HK4448, operated by Aviheco S.A., was destroyed following a collision with terrain near Norte de Santander, Columbia. The local flight originated in Bogota.…NTSB CEN11FA347Accident · 1 fatalField investigationFinal reportBeech F33A · Taos, NMThe pilot’s continued visual flight into instrument meteorological conditions, which resulted in loss of situational awareness, and a possible encounter with icing conditions.NTSB WPR11FA230Accident · 1 fatalField investigationFinal reportCameron Lancair Legacy · Pioneer, CAThe pilot’s continued flight into instrument meteorological conditions at an insufficient altitude to clear terrain.NTSB WPR11WA482Accident · 1 fatalForeign investigationRobinson R22 · Julia Creek, Australia, AustraliaOn May 9, 2011, at 0440 universal coordinated time, a Robinson R-22, Australian registry VH-DSD, operated by Versatile Helicopter Services, impacted terrain during a mustering operation near Julia Creek, Australia. The helicopter was substantially damaged and…NTSB WPR11FA221Accident · 1 fatalField investigationFinal reportAir Tractor AT-802A · Miles City, MTThe pilot's continued visual flight rules flight into deteriorating weather conditions in an airplane not equipped for instrument flight, which resulted in a collision with terrain.NTSB CEN11FA312Accident · 1 fatalField investigationFinal reportCombs Earl W Kitfox Speedster · Elephant Butte, NMThe pilot's loss of control of the airplane for reasons that could not be determined because postaccident examination of the airplane did not reveal any anomalies that would have precluded normal operation.NTSB ERA11WA276Accident · 2 fatalForeign investigationRobinson R22 · Sulmona, ItalyOn April 26, 2011, at 1743 coordinated universal time (1843 local time), a Robinson R22, Italian registration I-ETEC, was destroyed when it impacted power lines near Sulmona, L'Aquila, Italy. The pilot and the observer were fatally injured. The flight, which…NTSB CEN11LA307Accident · 1 fatalLimited investigationFinal reportCessna 320 · Lake Heron, NMThe pilot’s controlled flight into terrain while conducting a flight at low altitude in instrument meteorological conditions.NTSB ERA11FA219Accident · 2 fatalField investigationFinal reportBeech 58 · Greensboro, NCThe pilot’s spatial disorientation due to a somatogravic illusion while conducting a missed approach in instrument meteorological conditions, which resulted in the airplane’s descent into objects and terrain.NTSB ERA11FA218Accident · 2 fatalField investigationFinal reportCessna 310R · Pikeville, KYThe pilot's flight below the published minimum descent altitude in instrument meteorological conditions, which resulted in a collision with trees and the ground. Contributing to the accident was the pilot's use of nighttime cold medication at doses above…NTSB CEN11FA263Accident · 3 fatalField investigationFinal reportPiper PA-32R-300 · Fredricktown, MOThe pilot's decision to attempt to maintain visual flight by descending below an area of deteriorating forecast weather to an altitude that did not provide adequate terrain clearance.NTSB WPR11FA490Accident · 1 fatalField investigationFinal reportRadford RV-6 · Grand Canyon, AZThe pilot's intentional flight into terrain.