NTSB investigations
1,074 cases where the sequence of events included Controlled flight into terr/obj (CFIT).
Cases, newest first
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 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 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 CEN11LA323Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-402A · Arriba, COThe pilot’s controlled flight into terrain for undetermined reasons.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 CEN11CA294Accident · Minor injuriesData collectionFinal reportAir Tractor AT-802A · Horseshoe Lake, ARThe pilot's failure to maintain clearance from the tower due to his inadequate visual lookout.NTSB CEN11CA293Accident · No injuriesData collectionFinal reportCessna 172 · Greenville, TXThe pilot's delayed action in performing a go-around maneuver, which resulted in an impact with trees.NTSB WPR11LA181Accident · Serious injuriesLimited investigationFinal reportCessna A188 · Palouse, WAThe pilot did not maintain adequate clearance from obstacles during a low-level aerial application maneuver.NTSB WPR11LA180Accident · Minor injuriesLimited investigationFinal reportWilliam Wright Avid Flyer · Cedar City, UTA loss of engine power during initial climb for reasons that could not be determined because postaccident examination did not reveal a specific anomaly that would have precluded normal operation.NTSB WPR11WA217Accident · No injuriesForeign investigationRobinson R44 · Straubing, GermanyOn March 31, 2011, at 1630 universal coordinated time, a Robinson R44 Raven II Helicopter, D-HBLT, collided with an aircraft storage hangar at Straubing-Wallmühle Airport, Straubing, Germany. The pilot and passenger sustained minor injuries; the helicopter…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 ERA11CA205Accident · Minor injuriesData collectionFinal reportCessna 172M · Statesville, NCThe certified flight instructor's inadequate remedial action during the go-around, which resulted in a collision with trees.NTSB WPR11FA490Accident · 1 fatalField investigationFinal reportRadford RV-6 · Grand Canyon, AZThe pilot's intentional flight into terrain.NTSB WPR11FA145Accident · 3 fatalField investigationFinal reportPiper PA-28-181 · Phoenix, AZThe pilot and flight instructor's failure to adequately monitor the flight task and environment while maneuvering to maintain sufficient altitude with rising terrain in dark night conditions and the flight instructor's improper decision to practice in an area…NTSB ERA11WA211Accident · 6 fatalForeign investigationCessna 340 · Tachira, VenezuelaOn February 22, 2011, about 1915 UTC, a Cessna 340A, Venezulian registration YV2402, operated by Premezolados Agreconsa C.A., collided with mountainous terrain near Tachira, Venezuela. Visual meteorological conditions prevailed at the destination airport…NTSB ERA11WA155Accident · 4 fatalForeign investigationBell 206 · Vereda Galan, ColombiaOn February 18, 2011, about 0415 universal coordinated time, a Bell 206-B, Colombian registration HK-4594, operated by Heliservice LTDA, crashed in mountainous terrain near Vereda Galan, Colombia, and was consumed by a post crash fire. Instrument…NTSB ERA11LA139Accident · Serious injuriesLimited investigationFinal reportCessna 182P · Lincoln Park, NJThe pilot’s inadequate preflight inspection (removal of water contamination from the fuel system), which resulted in a total loss of engine power.NTSB ERA11WA145Accident · 1 fatalForeign investigationScotts-Bell 47 47G-4A · El Tocuyo, VenezuelaOn February 9, 2011, about 1300 UTC, a Scotts-Bell 47, Inc., 47G-4A, YV-447A, collided into mountainous terrain near El Tocuyo, Venezuela. Visual meteorological conditions prevailed at the time and flight plan information is unknown for the foreign non-U.S.…NTSB ERA11WA160Accident · 2 fatalForeign investigationCessna 182 · Novo Repartimento, BrazilOn January 31, 2011, about 1410 Universal Coordinated Time (UTC), a Cessna, 182P, Brazilian registration PT-KAS, operated by a private individual, collided with a tree during a balked landing at the Uniáo Farm, Novo Repartimento, Pará, Brazil. Visual…NTSB WPR11FA116Accident · 3 fatalField investigationFinal reportCessna 182K · Adrian, ORThe non-instrument-rated pilot did not maintain sufficient altitude to clear mountainous terrain while in cruise flight in the dark.NTSB ERA11WA136Accident · 1 fatalForeign investigationCessna 172 · Isola Fossara, Perugia, ItalyOn January 27, 2011, at 1410 universal coordinated time, a Cessna 172N, Italian registration I-AMCO, was substantially damaged when it impacted terrain during cruise flight near Isola Fossara, Perugia, Italy. The certificated private pilot was fatally…NTSB CEN11LA153Accident · Serious injuriesLimited investigationFinal reportCessna 172A · Clarendon, TXThe pilot's failure to correctly set the altimeter, which resulted in his erroneous perception that the airplane was at a safe altitude.NTSB ERA11WA121Accident · 6 fatalForeign investigationBeech B200 · Senador Canedo City, BrazilOn January 14, 2011, at 2010 coordinated universal time (1810 local time), a Beechcraft B200, Brazilian registration PR-ART, was destroyed when it impacted terrain near Senador Canedo City, Goias, Brazil, while approaching Santa Genoveva Airport (SBGO),…NTSB ERA11WA111Accident · 1 fatalForeign investigationAir Tractor AT802 · Santa Juana, ChileOn January 9, 2011, at 1930 universal coordinated time, an Air Tractor AT-802, Spanish registration EC-IOE, registered to FAASA Group Aerodromo Sebastian Almagro Ctra, operated by FAASA Chile Servicios Aeros LTDA, collided with trees near Santa Juana, Chile,…NTSB ERA11LA104Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Benton, PAThe pilot's failure to maintain clearance from terrain during the night flight.NTSB ERA11FA102Accident · 1 fatalField investigationFinal reportCessna 310F · Orange, MAThe pilot did not maintain separation from trees during landing. Contributing to the accident was the pilot’s inadequate preflight planning and lack of recent night flight experience.NTSB WPR11TA083Accident · No injuriesFinal reportQuest Kodiak 100 · Reedsport, ORThe pilot's failure to maintain clearance from power lines during a low-level aerial observation flight. Contributing to the accident was pilot's failure to review a route hazards map prior to initiating the flight.NTSB CEN11CA132Accident · No injuriesData collectionFinal reportCessna T210L · Abilene, TXThe pilot’s improper fuel management, which resulted in a loss of engine power due to fuel exhaustion.NTSB CEN11FA130Accident · 1 fatalField investigationFinal reportCessna 210B · Loveland, COThe pilot's intentional flight into terrain.NTSB WPR11FA082Accident · 3 fatalField investigationFinal reportAero Commander 114B · Lander, WYThe non-instrument-rated pilot's decision to continue visual flight in instrument or marginal visual meteorological conditions in mountainous terrain, which resulted in controlled flight into terrain. Contributing to the accident was the pilot's lack of…NTSB WPR11FA078Accident · 1 fatalField investigationFinal reportAero Commander 680FL · Perris, CAThe pilot’s decision to continue visual flight into instrument meteorological conditions, which resulted in an in-flight collision with mountainous terrain.NTSB CEN11FA110Accident · 2 fatalField investigationFinal reportBeech B60 · Edwards, COControlled flight into terrain, while on an instrument approach in instrument meteorological conditions, for undetermined reasons.NTSB WPR11LA076Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BC12-65 · College Place, WAThe pilot's failure to abort the landing when he lost sight of the runway due to sun glare, and his inadequate compensation for the crosswind.NTSB ERA11FA085Accident · 1 fatalField investigationFinal reportDiamond Aircraft Ind DA 40 · Pearlington, MSThe pilot’s controlled flight into terrain likely due to spatial disorientation, while flying over sparsely lighted terrain at night.NTSB WPR11FA073Accident · Serious injuriesField investigationFinal reportCessna T210M · Ogden, UTThe pilot did not maintain clearance from obstacles after descending below the published approach decision height when visibility was less than published approach minimums due to heavy ground fog and he did not execute a missed approach after failing to…NTSB CEN11CA098Accident · No injuriesData collectionFinal reportAir Tractor AT-602 · Gregory, ARThe pilot’s inadequate preflight inspection and failure to detect water contaminated fuel, which resulted in a loss of engine power during takeoff.NTSB ERA11FA070Accident · 3 fatalField investigationFinal reportPiper PA 46-350P · Destin, FLControlled flight into water due to the pilot's improper descent below the published minimum descent altitude.NTSB CEN11FA079Accident · 2 fatalField investigationFinal reportPiper PA-24-260 · Norfolk, NEThe pilot’s decision to continue the flight into instrumental meteorological conditions which resulted in a collision with a tree.NTSB WPR11FA061Accident · 1 fatalField investigationFinal reportAmerican Champion 8GCBC · Bremerton, WAThe pilot did not maintain clearance from terrain for undetermined reasons. Contributing to the accident were the pilot’s use of oxycodone and his severe coronary artery disease.NTSB WPR11FA047Accident · 1 fatalField investigationFinal reportBeech C35 · Enterprise, ORThe noninstrumented pilot’s inadequate weather planning, which resulted in his failure to maintain visual flight while maneuvering under low ceilings in rainy and foggy conditions and his subsequent failure to maintain clearance from mountainous terrain.NTSB ERA11FA055Accident · 2 fatalField investigationFinal reportMooney M20F · Copake, NYThe pilot's failure to monitor and maintain clearance from mountainous terrain during a visual descent to the destination airport at night, which resulted in controlled flight into terrain.NTSB ERA11WA086Accident · 1 fatalForeign investigationEurocopter AS 350 B2 · Taltal, ChileOn November 6, 2010, at 2330 universal coordinated time, a Eurocopter, AS 350 B2 helicopter, Chilean registration CC-AAN, collided with terrain while in low level cruise flight near Taltal, Chile. The flight was operated by Servicios y Transporte Aereos…NTSB WPR11CA034Accident · No injuriesData collectionFinal reportCessna U206B · Cascade, IDThe pilot's failure to maintain clearance from terrain during a turn onto the final approach leg of the traffic pattern.NTSB WPR11CA036Accident · Minor injuriesData collectionFinal reportAerostar Acft Corp Of Texas M20E · Seligman, AZThe pilot's failure to maintain clearance from terrain while maneuvering. Contributing to the accident was the pilot's inadequate preflight and in-flight planning.NTSB ERA11CA007Accident · Minor injuriesData collectionFinal reportAeronca 11AC · Taylorsville, KYThe pilot’s failure to maintain clearance from an unmarked power line during the final approach to land.NTSB WPR10FA473Accident · 1 fatalField investigationFinal reportHawker Beechcraft F33 · Phoenix, AZA partial loss of engine power during approach for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB WPR10FA459Accident · 2 fatalField investigationFinal reportCessna T210N · Coeur d'Alene, IDThe pilot’s continued flight into instrument meteorological conditions and failure to maintain clearance with mountainous terrain while maneuvering in an area of low cloud ceilings.NTSB CEN10LA556Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Duluth, MNThe pilot's failure to identify and arrest the helicopter's descent due to spatial disorientation.NTSB ERA10WA509Accident · 4 fatalForeign investigationRobinson R44 · Lagoa do Triunfo, Para, BrazilOn September 15, 2010, about 2150 universal coordinated time, a Robinson R-44 II helicopter, Brazilian registration PR-DAN, was substantially damaged when it impacted the terrain in Lagoa do Triunfo, Para, Brazil. The pilot and three passengers were fatally…