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 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 ERA13FA330Accident · 1 fatalField investigationFinal reportCessna 172M · Fredericksburg, VAThe pilot's intentional descent into the ground to commit suicide.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 ANC13CA060Accident · No injuriesData collectionFinal reportPiper PA-12 · Talkeetna, AKThe pilot's loss of situational awareness, which resulted in a wrong turn into a box canyon, and an in flight collision with terrain.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 CEN13CA315Accident · No injuriesData collectionFinal reportCub Crafters CCK · Cookson, OKA total loss of engine power due to water contamination in the fuel. Contributing to the accident was the pilot's failure to check the fuel during the preflight, and failure to check the fuel storage tank’s fuel filter/water separator.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 CEN13CA268Accident · Minor injuriesData collectionFinal reportHook Zodiac CH-650 · Gainesville, MOThe pilot misjudged the landing approach, which resulted in the airplane hitting a tree.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 ERA13LA174Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Panama City, FLA loss of preload to the crankshaft gear attachment bolt, resulting in rotation of the crankshaft gear and a subsequent total loss of engine power. The root cause for the loss of preload could not be determined during a postaccident examination of the…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,…NTSB CEN13WA572Accident · 1 fatalForeign investigationPiper PA28 - 161 · Persan, FranceOn March 6, 2013, about 1920 universal coordinated time, a Piper PA28-161 airplane, F-GHPN, impacted terrain during final approach to land on runway 10, at the Persan-Beaumont Airport (LFPA), near Persan, France. The pilot was fatally injured. This…NTSB WPR13CA136Accident · Serious injuriesData collectionFinal reportBuckeye Dream Machine · Tracy, CAThe pilot’s failure to see and avoid power lines during a climb.NTSB ERA13MA139Accident · 5 fatalMajor investigationFinal reportBeech 390 · Thomson, GAThe pilot's failure to follow airplane flight manual procedures for an antiskid failure in flight and his failure to immediately retract the lift dump after he elected to attempt a go-around on the runway. Contributing to the accident were the pilot's lack of…NTSB ERA13CA142Accident · Minor injuriesData collectionFinal reportDombroski Frank Vans RV-10 · Lake Placid, NYThe pilot's improper in-flight planning and decision making, which resulted in attempted visual flight in night instrument meteorological conditions and subsequent impact with terrain.NTSB CEN13LA164Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Morris, ILThe pilot's improper fuel management, which resulted in a loss of engine power due to fuel exhaustion.NTSB ERA13WA157Accident · 1 fatalForeign investigationCessna 172S · Mersin, TürkiyeOn February 12, 2013, at about 1414 Universal Time Coordinated, a Cessna 172S, Turkish registration TC-CDA, operated by the Turkish Aeronautical Association, impacted terrain during an instructional flight, near Mersin, Turkey. The flight instructor was…NTSB WPR13FA119Accident · 3 fatalField investigationFinal reportBell 206B · Acton, CAThe pilot's decision to conduct a flight in dark night conditions with an illuminated cockpit light that degraded his visibility and his ability to identify and arrest the helicopter's descent while maneuvering, which resulted in controlled flight into…NTSB ANC13LA021Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Kalskag, AKThe pilot’s decision to take off into deteriorating weather conditions, which resulted in a loss of visual reference and the subsequent controlled flight into terrain. Contributing to the severity of the rear seat passenger’s injuries was the incorrect…NTSB WPR13FA095Accident · 2 fatalField investigationFinal reportCessna 140 · Boulder, UTThe pilot’s improper decision to maneuver at a low altitude and failure to adequately monitor the environment to maintain clearance from power lines.NTSB ERA13LA113Accident · 1 fatalLimited investigationFinal reportPiper PA-34-200T · Manteo, NCThe pilot's attempted visual flight in instrument meteorological conditions while maneuvering at a low altitude in the traffic pattern, which resulted in spatial disorientation and impact with the water. Contributing was the pilot's lack of experience flying…NTSB CEN13CA133Accident · No injuriesData collectionFinal reportAmerican General Acft AG5B · Ankeny, IAThe pilot’s failure to maintain a proper glide path to the runway in gusty wind conditions and his failure to maintain clearance from obstructions during the subsequent go-around. Contributing to the accident was the pilot's improper interior lighting…NTSB WPR13CA084Accident · Minor injuriesData collectionFinal reportBell 47G · Five Points, CAThe pilot’s failure to maintain clearance with a telephone pole during a low-level maneuver.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…