NTSB investigations
856 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 ERA14WA020Accident · 1 fatalForeign investigationBell 407 - NO Series · Gobierno, ArgentinaOn October 11, 2013, at 1900 universal coordinated time, a Bell 407, Argentinian registration LQ-BHT, impacted power lines after takeoff near Gobierno, in the province of San Juan, Argentina. The pilot and three passengers were injured and one passenger was…NTSB CEN14WA115Accident · No injuriesForeign investigationGulfstream 550 · London, United KingdomOn October 12, 2013, at 0325 Universal Coordinated Time, a Saudi Arabia registered Gulfstream 550, HZ-A6, collided with the ILS antenna and localizer array while landing at Stanstead Airport (EGSS), London, United Kingdom. There were no injuries to the…NTSB WPR14CA013Accident · Serious injuriesData collectionFinal reportPiper PA 28-180 · Cody, WYA loss of engine power during climb to cruise for reasons that could not be determined due to no postaccident examination.NTSB WPR14FA012Accident · 2 fatalField investigationFinal reportMooney M20E · Julian, CAThe pilot’s failure to maintain clearance from terrain while maneuvering to avoid clouds in mountainous terrain.NTSB CEN14LA007Accident · Serious injuriesLimited investigationFinal reportCameron Balloons US V 77 · Rio Rancho, NMThe pilot's failure to maintain adequate clearance from power lines on approach to land, resulting in a collision with the wires, a spark, and a subsequent explosion and on-board fire.NTSB WPR14LA007Accident · 3 fatalLimited investigationFinal reportPiper PA32 - 300 · Tinian IslandThe pilot’s failure to maintain terrain clearance while maneuvering at low altitude in dark night conditions.NTSB WPR14CA003Accident · No injuriesData collectionFinal reportAir Tractor AT 402B · Wellton, AZThe pilot’s distracted attention and failure to maintain sufficient altitude to clear terrain while maneuvering in dark night conditions.NTSB WPR13WA433Accident · 5 fatalForeign investigationBell 212 - NO Series · Murbad, Thane District, India, IndiaOn September 29, 2013, at 0820 universal coordinated time, a Bell 212, VT-HGB, collided with terrain during cruise flight near Murbad (Thane District), India. The helicopter was destroyed and two flight crew and three passengers were fatally injured. The…NTSB WPR13WA423Accident · 1 fatalForeign investigationCessna 182 - R · Hamilton Aerodrome, Australia, AustraliaOn September 23, 2013, at 1950 universal coordinated time, a Cessna 182R, VH-AUT, collided with terrain near Hamilton Aerodrome, Australia. The flight was being operated under the pertinent civil regulations of Australia. The solo student pilot was fatally…NTSB WPR13WA410Accident · 2 fatalForeign investigationCessna U206 - G · Croydon, AustraliaOn September 15, 2013, about 1530 Eastern standard time, an Australian registered Cessna 206, VH-WAV, impacted terrain about 95 miles Southeast of Croydon, Queensland, Australia. The airplane was destroyed and the pilot and passenger were fatally injured. The…NTSB ERA13WA411Accident · 2 fatalForeign investigationDornier 228 · Valparaiso, ChileOn September 9, 2013, about 0940 universal coordinated time (UTC), a Dornier 228-202K CC-CNW impacted terrain while on approach for landing at Viña del Mar Airfield/NAS Base Aeronaval Viña del Mar in Chile. The airplane was destroyed, and the commercial pilot…NTSB WPR13CA381Accident · Minor injuriesData collectionFinal reportCessna 172E · Meeteetse, WYThe student pilot's inadequate preflight planning and failure to maintain clearance from rising terrain, which resulted in controlled flight into terrain. Contributing to the accident was the pilot's lack of situational awareness.NTSB ERA13WA367Accident · 4 fatalForeign investigationCessna 172 · Bolzano, ItalyOn August 17, 2013, at 1400 Universal Coordinated Time (UTC), a Cessna FR172J, German registration D-EDQL, operated by a flying club, was destroyed following a collision with mountainous terrain near San Pellegrino, Italy. The local flight originated in…NTSB DCA13MA133Accident · 2 fatalClass 1 · MajorFinal reportAirbus A300 - F4 622R · Birmingham, ALthe flight crew's continuation of an unstabilized approach and their failure to monitor the aircraft's altitude during the approach, which led to an inadvertent descent below the minimum approach altitude and subsequently into terrain. Contributing to the…NTSB ANC13CA077Accident · No injuriesData collectionFinal reportAviat A-1B · Arctic Village, AKThe pilot's failure to maintain clearance from terrain while maneuvering at low altitude.NTSB ERA13WA359Accident · 2 fatalForeign investigationRobinson R-44 · Davidovo, RussiaOn August 6, 2013, at 1506 coordinated universal time (August 7, 2013, 0006 local time), an emergency locator beacon signal was detected for a Robinson R44, RA-06302, which was subsequently found destroyed on rising terrain about 7 nautical miles southwest of…NTSB CEN13FA465Accident · 1 fatalField investigationFinal reportAir Tractor AT-400 · Balko, OKThe pilot's failure maintain clearance from a meteorological tower while en route at a low altitude. Contributing to the accident was the sun's glare.NTSB ERA13FA349Accident · 2 fatalField investigationFinal reportBeech A36 · Alma, GADescent from cruise flight until impact with trees and the ground for reasons that could not be determined because postaccident examination of the wreckage did not reveal any anomalies that would have precluded normal operation and the pilot's autopsy and…NTSB ERA13CA353Accident · Minor injuriesData collectionFinal reportPiper/Cub Crafters PA-18-150 · Eagle Bay, NYThe pilot's failure to set the engine throttle to full power during a go-around.NTSB ERA13TA341Accident · Serious injuriesFinal reportMcdonnell Douglas Helicopter 369E · Jackson, KYThe helicopter pilot's inadvertent collision with an unmarked and uncharted utility wire of which he was unaware.NTSB CEN13LA442Accident · No injuriesLimited investigationFinal reportTexas Helicopter OH-13H/M74A · Streator, ILThe pilot's diverted attention during an agricultural application maneuver, which resulted in the helicopter impacting a corn field.NTSB CEN13LA447Accident · No injuriesLimited investigationFinal reportBell 206B · Tamaroa, ILThe pilot's failure to maintain clearance from terrain during an agricultural application maneuver.NTSB CEN13LA424Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-802A · Huntingburg, INThe pilot's failure to maintain clearance from a power line during an aerial application maneuver. Contributing to the accident was the pilot's failure to identify potential obstructions in the area before beginning low-altitude maneuvers.NTSB ERA13WA322Accident · Serious injuriesForeign investigationCessna 208B · Mathews Ridge, GuyanaOn July 15, 2013, about 1157 coordinated universal time, a Cessna 208B, Guyana registration 8R-AMS, operated by Air Services Limited, was substantially damaged when it impacted terrain during approach at Matthew's Ridge Airport (SYMR), Matthew's Ridge,…NTSB ERA13WA319Accident · 2 fatalForeign investigationDiamond DA40-180 · Ticlio, PeruNTSB DCA13MA120Accident · 3 fatalClass 1 · MajorFinal reportBoeing 777-200ER · San Francisco, CAThe flight crew's mismanagement of the airplane's descent during the visual approach, the pilot flying's unintended deactivation of automatic airspeed control, the flight crew's inadequate monitoring of airspeed, and the flight crew's delayed execution of a…NTSB CEN13LA394Accident · Minor injuriesLimited investigationFinal reportGulfstream-Schweizer A/C Gulfstream AM G-164B · Colfax, LAThe pilot’s failure to maintain clearance from a tree.NTSB ANC13FA058Accident · 3 fatalField investigationFinal reportBeech 95-B55 · Cantwell, AKThe pilot’s continued visual flight into instrument meteorological conditions, which resulted in an in-flight collision with mountainous terrain.NTSB CEN13FA274Accident · 2 fatalField investigationFinal reportBoeing-Stearman IB75A · Dayton, OHThe pilot's controlled flight into terrain. Contributing to the accident was the pilot's modified airshow maneuver, which placed the airplane at low altitude and airspeed and out of position within the performance area.NTSB ERA13WA293Accident · 2 fatalForeign investigationPiper PA-28-161 · Barcis, ItalyOn June 18, 2013 at 1655 Universal Coordinated Time (UTC), a Piper PA-28, French registration F-GHLY, privately operated, was substantially damaged when it impacted with the slope of a mountain near Barcis, Italy during a cross-country flight from Locarno…NTSB ERA13WA290Accident · 1 fatalForeign investigationBeech 58 · Albenga, ItalyNTSB ERA13WA289Accident · 2 fatalForeign investigationBell 212 · Tefe, BrazilOn June 14, 2013, about 0810 universal coordinated time, a Bell 212 helicopter, Brazilian registration PR-HRZ, operated by an oil and gas exploration and production company, was destroyed when it impacted terrain shortly after takeoff from a support base…NTSB ERA13LA281Accident · 1 fatalLimited investigationFinal reportCessna 172K · Newton, MSThe student pilot's failure to increase engine power during the descent for landing when instructed to do so by the flight instructor and the flight instructor's delayed remedial action, which resulted in collision with a static wire. Contributing to the…NTSB CEN13CA316Accident · No injuriesData collectionFinal reportSheldrick John H RV-6 · Brookfield, WIThe pilot's failure to maintain runway alignment and his failure to recognize that the airplane had drifted away from the runway prior to landing.NTSB ERA13CA260Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Ellenville, NYThe student pilot's inadequate preflight planning and failure to maintain clearance from rising terrain, which resulted in controlled flight into terrain.NTSB CEN13FA295Accident · 2 fatalField investigationFinal reportRobinson Helicopter R44 II · Cross Timbers, MOThe pilot's failure to see and avoid a power line during the low-altitude flight.NTSB ERA13CA245Accident · Minor injuriesData collectionFinal reportSchweizer SGS 1-23H-15 · Yadkinville, NCThe pilot's improper altitude management while maneuvering for an off-airport landing, which resulted in a collision with trees.NTSB ERA13CA234Accident · Minor injuriesData collectionFinal reportPiper J3C-65 · Selma, NCThe instructor pilot’s inadequate visual lookout, which resulted in a collision with power lines and then the ground.NTSB CEN13CA272Accident · No injuriesData collectionFinal reportCessna 172M · Thief River Falls, MNThe pilot’s failure to maintain clearance from the power line while on approach to landing.NTSB CEN13LA265Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Lyons, KSThe pilot's diverted attention after the door hinge failed and a piece of door glass struck the pilot, resulting in the airplane's descent into the crops and impact with terrain.NTSB WPR13CA219Accident · Serious injuriesData collectionFinal reportPiper PA-28 · Cottonwood, AZThe student pilot's decision to attempt a night landing on an unlit runway, which resulted in a misaligned approach and subsequent collision with a fence. Contributing to the accident was the student pilot's improper set-up of the airplane radios, which…NTSB ANC13CA042Accident · Minor injuriesData collectionFinal reportCessna 207A · Newtok, AKThe pilot's continued flight into adverse weather and his failure to maintain clearance from terrain while on approach in flat light conditions. Contributing to the accident was the pilot's delayed decision to initiate a go-around.NTSB ERA13CA228Accident · Serious injuriesData collectionFinal reportPiper PA-28-140 · Brogue, PAThe flight instructor's inadequate supervision of the student pilot during takeoff, which resulted in a collision with a power line.NTSB WPR13FA208Accident · 1 fatalField investigationFinal reportBell 206B · Shepherd, MTThe pilot’s loss of control while maneuvering during low-altitude operations due to sudden neurological impairment or incapacitation and the helicopter’s subsequent collision with power lines.NTSB ERA13CA218Accident · Serious injuriesData collectionFinal reportCessna 172P · Davis, WVThe pilot’s improper glidepath as he approached the runway and his subsequent delayed decision to abort the landing.NTSB ERA13CA230Accident · No injuriesData collectionFinal reportCessna 152 · Americus, GAThe pilot’s delayed decision to terminate the practice approach during a simulated loss of engine power maneuver, which resulted in an inadvertent collision with utility wires.NTSB WPR13FA201Accident · 2 fatalField investigationFinal reportCessna 182D · Wellington, NVThe pilot’s failure to maintain clearance from mountainous terrain during a night, visual descent to the destination airport, which resulted in controlled flight into terrain.NTSB WPR13CA152Accident · Minor injuriesData collectionFinal reportCessna 172N · Gila Bend, AZThe student pilot's failure to maintain airplane control during an attempted go-around.NTSB ANC13FA030Accident · 2 fatalField investigationFinal reportBeech 1900C · Aleknagik, AKThe flight crew's failure to maintain terrain clearance, which resulted in controlled flight into terrain in instrument meteorological conditions. Contributing to the accident were the flight crew's failure to correctly read back and interpret clearance…NTSB ERA13WA158Accident · 9 fatalForeign investigationBeech B200 · La Libertad, PeruOn March 6, 2013, about 1245 UTC, a Beech B200, OB-1992, registered to Dearborn and Flint Aviation Co, Inc., operated by Aero Transporte Sociedad Anonima ATSA, collided with a wire then terrain during visual approach to Aerodrome Pias (SPIS), La Libertad,…