NTSB investigations
855 cases where the defining event was 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 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 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 CEN17WA370Accident · 2 fatalForeign investigationCessna 150J · Goderich, CanadaOn September 20, 2017, about 2036 eastern daylight time, a Cessna 150J single-engine airplane, Canadian registration C-FHPU, serial number 15070602, crashed in Lake Huron about 1.1 nautical miles west of Goderich Municipal Airport (CYGD), Goderich, Ontario,…NTSB WPR17LA206Accident · Minor injuriesClass 3 · LimitedFinal reportBell 47G 5 · Salinas, CAThe pilot’s inadequate visual lookout, which resulted in an in-flight collision with a wire.NTSB CEN17FA355Accident · 1 fatalField investigationFinal reportBell 206L 3 · Ancho, NMThe pilot's distraction by a cell phone during a low-altitude flight, which resulted in controlled flight into terrain.NTSB ERA17WA321Accident · 1 fatalForeign investigationPiper Piper PA-34-200T · Cerrione, ItalyNTSB WPR17FA196Accident · 1 fatalField investigationFinal reportCessna 172N · Bolinas, CAThe non-instrument rated private pilot's improper decision to embark on a flight and continue to fly into forecasted instrument meteorological conditions and mountain obscuration while conducting a visual flight rules flight.NTSB ERA17WA273Accident · 4 fatalForeign investigationBell 206 · Algiers, AlgeriaOn August 10, 2017, about 0930 coordinated universal time, Bell 206L3 helicopter, Algerian registration 7T-WUF, was substantially damaged when it impacted terrain while maneuvering in Algiers, Algeria. The pilot and three passengers were fatally injured. The…NTSB ERA17LA267Accident · Serious injuriesLimited investigationFinal reportPiper PA28 · Pittstown, NJThe student pilot's improper decision to conduct a night flight and his failure to maintain adequate altitude during the approach, which resulted in controlled flight into trees and terrain. Contributing to the accident was the student pilot's lack of total…NTSB CEN17WA310Accident · 3 fatalForeign investigationPiper PA28 · Berghaus Diavolezza, SwitzerlandOn August 4, 2017, at 0720 UTC, a Piper PA-28-181, Swiss registration HB-PER, owned and operated by a private individual, impacted mountainous terrain near Berghaus Diavolezza, Switzerland. The pilot and two passengers on board were fatally injured. A third…NTSB WPR17WA178Accident · 1 fatalForeign investigationRobinson Helicopter R22 Beta · Cloncurry, AustraliaOn August 2, 2017, at 0740 local time, a Robinson R22, VH-HGU, was destroyed by a post-impact fire following a collision with power lines during cruise flight near Cloncurry Aerodrome, Australia. The helicopter was operated under the pertinent civil…NTSB WPR17FA170Accident · 4 fatalField investigationFinal reportBeech 19A · Waipi'o, HIThe pilot's controlled flight into terrain for reasons that could not be determined based on the available evidence. Contributing to the accident was the pilot's decision to fly at low altitude in close proximity to the rising terrain.NTSB GAA17CA454Accident · Serious injuriesData collectionFinal reportAir Tractor AT 802 · Trumann, ARThe pilot’s improper decision to continue flight in deteriorating weather conditions, which resulted in collision with the ground.NTSB CEN17WA289Accident · 7 fatalForeign investigationCessna U206 · Culiacan, MexicoNTSB GAA17CA385Accident · No injuriesData collectionFinal reportAir Tractor AT 502 · Edna, TXThe pilot’s failure to see and avoid a tower during an agricultural application flight.NTSB ERA17FA211Accident · 1 fatalField investigationFinal reportBuckeye Powered Parachutes Dream Machine 582 · Federalsburg, MDThe pilot's failure to maintain aircraft control during takeoff, which resulted in a collision with power lines. Contributing to the accident was the pilot's lack of experience in powered parachutes.NTSB GAA17CA371Accident · No injuriesData collectionFinal reportAero Commander Callair A 9 · Morgan, UTThe pilot’s failure to see and avoid transmission wires.NTSB CEN17WA214Accident · 1 fatalForeign investigationPiper PA-28-140 · Sacatepequez, GuatemalaOn June 1, 2017, at 1824 coordinated universal time, a Piper PA-24-140, Guatemalan registration TG-GYV, owned by a private individual, was destroyed when it impacted mountainous terrain under unknown circumstances near Volcán de Agua, Departamento de…NTSB GAA17CA308Accident · Minor injuriesData collectionFinal reportRobert Hamblin Autogyro Gmbh Cavalo · Fort Worth, TXThe pilot’s failure to maintain clearance from terrain.NTSB ERA17WA192Accident · 1 fatalForeign investigationRobinson R22 · Kwa-Zulu Natal, South AfricaThe South African Civil Aviation Authority (SACAA) has notified the NTSB of an accident involving a Robinson R22 helicopter that occurred on May 20, 2017. The NTSB has appointed a U.S. Accredited Representative to assist SACAA's investigation under the…NTSB GAA17CA279Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · Vevay, INThe pilot’s failure to see and avoid power lines during an agricultural application flight due to distraction when reading a map.NTSB GAA17CA261Accident · No injuriesData collectionFinal reportQuicksilver Manufacturing SPORT2S R582 · Arecibo, PRThe pilot’s failure to see and avoid trees during low-altitude flight.NTSB CEN17WA175Accident · 3 fatalForeign investigationSocata-Groupe Aerospatiale TB 20 · Malaga, SpainOn April 29, 2017, at 1632 UTC, a Socata TB-20, D-ECJP, impacted terrain near Canillas de Aceituno in Malaga, Spain. The aircraft was destroyed, and the pilot and two passengers were fatally injured. The flight departed Mutxamel Airfield (LEMU) in Alicante,…NTSB ERA17FA164Accident · 1 fatalField investigationFinal reportBell-Carson 47G Super C 4 · Timmonsville, SCThe pilot's decision to maneuver the helicopter at a low altitude near trees, which resulted in collision with the trees.NTSB WPR17LA099Accident · No injuriesClass 3 · LimitedFinal reportDiamond Aircraft Ind DA 40 NG · Goodyear, AZLoss of engine power due to the installation of an improper air induction hose, which failed and prevented sufficient air intake to the turbocharger.NTSB GAA17CA215Accident · Minor injuriesData collectionFinal reportCessna 182 · Blue Earth, MNThe pilot's decision to continue the night, visual flight into instrument meteorological conditions, which resulted in controlled flight into terrain while on final approach. Contributing to the accident was the pilot's improper use of an electronic flight…NTSB WPR17LA084Accident · Serious injuriesLimited investigationFinal reportCirrus Design SR22 · Brinnon, WAThe flight instructor's decision to fly into a valley without ensuring adequate clearance to avoid the rising terrain.NTSB CEN17WA143Accident · 5 fatalForeign investigationAerospatiale AS355 · Snowdonia, United KingdomOn March 29, 2017, about 1500 coordinated universal time, an Aerospatiale AS355 F1 helicopter, G-OHCP, collided with Rhinog Fawr mountain in Snowdonia, Wales, United Kingdom. The pilot and four passengers were fatally injured.The accident investigation is…NTSB CEN17WA130Accident · 1 fatalForeign investigationBell 206 · Figeac, FranceOn March 15, 2017, about 2100 universal coordinated time (UTC), a Bell 206 helicopter, F-GPPH, impacted terrain near Figeac, France. The pilot was fatally injured and the helicopter was destroyed. The flight originated from Poiters Biard (LFBI), France, and…NTSB CEN17FA112Accident · 1 fatalField investigationFinal reportBell 407 · Chauvin, LAThe pilot's failure to maintain proper altitude resulting in a collision with water for reasons that could not be determined based on the available information.NTSB CEN17WA213Accident · 1 fatalForeign investigationPiper PA28 · Petit Bourg, GuadeloupeOn February 20, 2017, about 1225 UTC, a Piper PA-28-161, French registration F-OGPJ, owned and operated by Aeroclub Les Ailes Guadeloupeenes, collided with a house while conducting low altitude cruise flight near Petit Bourg, Guadeloupe, French Antilles. The…NTSB WPR17FA063Accident · 1 fatalField investigationFinal reportCessna 172 · Ramona, CAThe flight instructor's failure to ensure that adequate clearance from terrain was maintained after performance of a simulated engine failure maneuver, which resulted in controlled flight into terrain.NTSB CEN17FA100Accident · 1 fatalField investigationFinal reportBell 206B · Galveston, TXThe pilot's failure to recognize the flight had encountered instrument meteorological conditions at night, which resulted in an unrecognized descent and collision with water.NTSB GAA17CA150Accident · No injuriesData collectionFinal reportBeech F90 · Poplar Bluff, MOThe pilot’s descent below the minimum descent altitude during a nonprecision approach, which resulted in a tree strike.NTSB GAA17CA117Accident · No injuriesData collectionFinal reportAir Tractor AT 802 · Vernon, UTThe pilot’s failure to maintain clearance from mountainous terrain.NTSB ERA17FA073Accident · 3 fatalField investigationFinal reportCessna 182 · Gatlinburg, TNThe non-instrument-rated pilot's intentional visual flight rules flight into instrument meteorological conditions, which resulted in controlled flight into terrain. Contributing to the accident was the pilot's established anti-authority attitude.NTSB ERA17WA085Accident · 3 fatalForeign investigationBeech 58 · Tabatinga, BrazilOn December 23, 2016, about 1830 universal coordinated time, a Beech 58, Brazilian registration PT-ICU, was destroyed when it impacted wooded terrain while on approach to Tabatinga International Airport (SBTT), Tabatinga, State of Amazonas, Brazil. The two…NTSB CEN17WA054Accident · 2 fatalForeign investigationGrumman AA1 · Pintendre, CanadaOn December 10, 2016, a Grumman American AA-1B airplane, C-FJEX, impacted terrain near Pintendre, Quebec. The pilot and passenger were fatality injured. The accident investigation is under the jurisdiction and control of the Canadian government. This report…NTSB CEN17LA043Accident · Minor injuriesLimited investigationFinal reportBeech 200 · Moorhead, MNThe pilot's failure to attain a positive climb rate during an attempted missed approach in night instrument meteorological conditions that were at/near approach minimums, which resulted in controlled flight into terrain.NTSB WPR17FA025Accident · 1 fatalField investigationFinal reportPiper PA 28-181 · Upland, CAThe pilot's failure to maintain clearance from rising terrain in dark night conditions, which resulted in controlled flight into terrain.NTSB ERA17WA060Accident · 1 fatalForeign investigationAgusta A109A II · Varese, ItalyOn November 19, 2016, at 1316 universal coordinated time, an Augusta A109 A II, N109W, was destroyed when it impacted terrain while navigating near Varese, Italy. An Italian passenger was fatally injured and the Italian certificated pilot and Swiss passenger…NTSB WPR17WA027Accident · 1 fatalForeign investigationRobinson R44 · Mount Windsor, AustraliaOn November 18, 2016, at 1244 local time, a Robinson R44 II, Australian registration VH-ZNZ, collided with terrain near Mount Windsor, Australia. The helicopter was destroyed by a post impact fire. The pilot sustained serious injuries and the passenger was…NTSB GAA17CA072Accident · No injuriesData collectionFinal reportPiper PA 28R · Payallup, WAThe airport’s failure to issue a NOTAM regarding the deployment of the traffic monitoring camera system before the accident, which resulted in the airplane striking the camera system during a short-field approach and landing.NTSB ANC17FA004Accident · 1 fatalField investigationFinal reportFairchild Heli-Porter Pilatus PC-6 · Port Alsworth, AKThe airplane's collision with mountainous terrain while operating in an area of reduced visibility and icing conditions. Contributing to the accident was the pilot's inadequate preflight planning, which would have identified deteriorating weather conditions…NTSB GAA17CA036Accident · No injuriesData collectionFinal reportCessna 172 · Carrabassett, METhe pilot’s failure to maintain clearance from trees while maneuvering at a low altitude.NTSB ERA17WA021Accident · 2 fatalForeign investigationCessna 172 · Peloponnese, GreeceOn October 16, 2016, about 1415 universal coordinated time, a Cessna 172P, Greek registration 5B-CLB, was destroyed when it impacted mountainous terrain while performing a cross-country training flight near Peloponnese, Greece. The Greek certificated…NTSB CEN16FA373Accident · 2 fatalField investigationFinal reportCessna 182 · Ephraim, WIThe pilot's improper decision to execute a maneuvering approach at low altitude during night conditions, which resulted in controlled flight into terrain.NTSB CEN16LA338Accident · 2 fatalLimited investigationFinal reportCessna 172 · New Orleans, LAThe pilot's improper decision to continue a descent during a night visual approach a for landing which resulted in controlled flight into terrain. Contributing to the accident was the reduced visibility and pilot's disregard of the PAPI indications that the…NTSB ERA16WA307Accident · 1 fatalForeign investigationPiper PA25 · Finca, ColombiaOn August 26, 2016, about 1250 coordinated universal time, a Piper PA-25-260, Colombian registration HK588, operated by Fumigaciones Aereas Del Norte S.A.S., was destroyed when it collided with an electrical wire and terrain near Finca, Colombia. The…NTSB ERA16FA297Accident · 1 fatalField investigationFinal reportHeberlein Ronald Vans RV 9A · Sebring, FLThe pilot's failure to maintain clearance from terrain.NTSB ERA16WA287Accident · 2 fatalForeign investigationCessna 172 · Fredonia, ColombiaOn August 9, 2016, about 2156 universal coordinated time, a Cessna 172N, Colombian registration HK4822G, was substantially damaged when it impacted terrain near Fredonia, Antioquia, Colombia. The flight instructor and student pilot were fatally injured and…NTSB DCA16MA204Accident · 16 fatalClass 1 · MajorFinal reportKubicek BB85 · Lockhart, TXThe pilot's pattern of poor decision-making that led to the initial launch, continued flight in fog and above clouds, and descent near or through clouds that decreased the pilot's ability to see and avoid obstacles. Contributing to the accident were (1) the…