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 CEN16LA303Accident · No injuriesLimited investigationFinal reportHughes 269A · Morris, MNThe pilot's failure to maintain clearance from terrain due to his distraction by the navigation system.NTSB CEN16LA292Accident · 1 fatalLimited investigationFinal reportAir Tractor AT 402 · Sac City, IAThe pilot's failure to maintain adequate clearance from power lines. Contributing to the accident was the pilot's failure to circle over the field to identify hazards before beginning the aerial application.NTSB CEN16LA289Accident · Minor injuriesLimited investigationFinal reportBell OH 58A · Lake Mills, IAThe pilot's inadequate visual lookout, which resulted in a wire strike.NTSB CEN16WA272Accident · 2 fatalForeign investigationRobinson R22 · Madrid, SpainOn July 16, 2016, about 1240 hours universal coordinated time, a Robinson R-22 Beta helicopter, Spain registration EC-IGG, was substantially damaged when it impacted the Valmayor Reservoir near Valdemorillo, Madrid, Spain. Witnesses reported that the…NTSB GAA16CA357Accident · Minor injuriesData collectionFinal reportBeech 23 · Maryville, MOThe pilot's failure to see and avoid power lines on approach during landing, resulting a power line strike, uncontrolled descent, and collision with terrain. Contributing to the accident was the pilot's inadequate pre-flight planning.NTSB ERA16WA243Accident · 1 fatalForeign investigationCessna A188 · Puerto Lopez, ColombiaOn July 2, 2016, about 1810 coordinated universal time, a Cessna A188, Colombian registration HK1398, operated by Comercializadora de Aviacion Agricola - ECO, was destroyed when it collided with a utility tower near Puerto Lopez, Colombia. The certificated…NTSB WPR16FA131Accident · 1 fatalField investigationFinal reportCessna A185F · Coeur d'Alene, IDThe pilot's failure to maintain clearance from trees while maneuvering at low altitude in mountainous terrain.NTSB ERA16WA245Accident · 2 fatalForeign investigationLake LA4 · Región de Los Lagos, ChileOn June 25, 2016, about 2045 coordinated universal time (1645 local time), a Lake L-4-200, amphibious airplane, Chilean registration CC-POK, was substantially damaged when it collided with a powerline during a local flight over the Región de Los Lagos, Chile.…NTSB ANC16LA032Accident · Serious injuriesLimited investigationFinal reportCessna 207 · Goodnews Bay, AKThe pilot’s failure to select the correct route through the mountains as a result of geographic disorientation, and his subsequent visual flight into instrument meteorological conditions, which resulted in collision with terrain.NTSB ERA16FA215Accident · 2 fatalField investigationFinal reportPiper PA31 · State College, PAThe pilot's decision to continue an unstabilized instrument approach in instrument meteorological conditions, which resulted in controlled flight into terrain.NTSB CEN16FA220Accident · 1 fatalField investigationFinal reportPiper PA-38-112 · Madison, INThe pilot’s failure to maintain a proper climb rate after takeoff and the subsequent collision with transmission line structures.NTSB ERA16CA214Accident · Minor injuriesData collectionFinal reportHanson Robert H Pietenpol Aircamper · Dundee, MSThe pilot’s failure to maintain clearance from a power line.NTSB ERA16WA273Accident · No injuriesForeign investigationBAE BAE125 · Yakutia, RussiaOn June 5, 2016, about 1425 coordinated universal time (2325 local time), a British Aerospace (BAE) Hawker 125-800, Russian registration RA-02773, was substantially damaged when it impacted terrain while on approach to Neryungri Airport, Yakutia, Russia, and…NTSB CEN16LA203Accident · 1 fatalLimited investigationFinal reportCessna 150 · Penwell, TXThe pilot’s intentional flight into a silo.NTSB WPR16FA111Accident · 1 fatalField investigationFinal reportCessna R182 · Altadena, CAThe pilot's failure to maintain clearance from rising mountainous terrain while flying in instrument meteorological conditions. Contributing to the accident was the loss of radio communications for a reason that could not be determined because of the…NTSB CEN16WA351Accident · 1 fatalForeign investigationRobinson R22 · Aube, FranceNTSB CEN16WA402Accident · Serious injuriesForeign investigationBell 206 · Mexico City, MexicoNTSB ERA16WA180Accident · 2 fatalForeign investigationRobinson R22 · Sao Paulo, BrazilOn May 5, 2016, about 1515 universal coordinated time, a Robinson R22 Beta, Brazilian registration PR-RCA, operated by AGD Aviation, was substantially damaged when it impacted wires and then terrain while maneuvering in Sao Paulo, Brazil. The flight…NTSB WPR16FA097Accident · 2 fatalField investigationFinal reportExtra Flugzeugproduktions-Und EA 300/L · Henderson, NVThe pilot's failure to monitor and maintain clearance with terrain while maneuvering at low level. Contributing to the accident, was the pilot's failure to conduct an adequate amount of clearing turns while maneuvering at low level.NTSB GAA16CA212Accident · No injuriesData collectionFinal reportCessna 140 · Poplar Grove, ILThe pilot's visual disorientation and failure to monitor the altimeter during a night approach, which resulted in controlled flight into terrain.NTSB GAA16CA168Accident · No injuriesData collectionFinal reportHughes 369 · Jamestown, NDThe pilot's excessive descent rate while flaring during a practice autorotation with a power recovery, which resulted in an impact with terrain.NTSB CEN16LA137Accident · Serious injuriesLimited investigationFinal reportMatthews H Thomas Jodel F11 A · Marathon, TXThe pilot's failure to conduct a go-around in a timely manner, which resulted in impact with trees and a powerline.NTSB ERA16LA139Accident · 1 fatalLimited investigationFinal reportHall, Wendall W Harmon Rocket II · Cheraw, SCThe pilot's decision to fly at low altitude, which resulted in a collision with power lines.NTSB ENG16WA018Accident · 25 fatalForeign investigationViking Air DHC-6 · Soli Ghoptevir, NepalNTSB CEN16WA109Accident · 1 fatalForeign investigationPiper PA28 · Palin, GuatemalaOn February 23, 2016, at 1805 coordinated universal time, a Piper PA28-140, Guatemalian registration TG-PEW, was destroyed when it impacted the terrain near Palin, Guatemala. The pilot was fatally injured. The flight originated from La Aurora Airport,…NTSB GAA16LA128Accident · Serious injuriesLimited investigationFinal reportPiper PA24 · Sturgis, SDThe pilot's failure to execute the published missed approach procedure in a timely manner, which resulted in collision with a light pole and subsequent impact with terrain.NTSB ERA16CA105Accident · No injuriesData collectionFinal reportPiper PA34 · Williamsport, PAThe pilot's failure to maintain altitude in cruise flight due to his diverted attention, which resulted in controlled flight into terrain.NTSB WPR16FA046Accident · 2 fatalField investigationFinal reportAerostar S A YAK 52 · Alpine, WYThe pilot's failure to maintain clearance from snow-covered terrain in flat light conditions.NTSB ERA16WA083Accident · 2 fatalForeign investigationBeech C90 · Parati, BrazilOn January 3, 2016, about 1730 Coordinated Universal Time (UTC), a Beech C90GTi, PP-LMM, registered to Bradesco Leasing S.A., operated by Supermercado Shibata Ltda, experienced controlled flight into mountainous terrain near Parati Airport (SDTK), Parati,…NTSB ANC16LA012Accident · Serious injuriesLimited investigationFinal reportCessna 208B · Anaktuvuk Pass, AKThe pilot’s continued flight into deteriorating, flat light weather conditions, which resulted in impact with mountainous, snow-covered terrain.NTSB WPR16LA043Accident · Serious injuriesClass 3 · LimitedFinal reportAerostar Acft Corp Of Texas M20F · Nogales, AZThe airplane’s impact with a hillside shortly after takeoff for reasons that could not be determined.NTSB DCA16WA236Accident · No injuriesForeign investigationCessna 182 · Plettenberg, Western Cape Province, South AfricaThe South African Civil Aviation Authority (SACAA) has notified the NTSB of an accident involving a Cessna 182@ airplane that occurred on December 16, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the SACAA's investigation under the…NTSB CEN16FA062Accident · 1 fatalField investigationFinal reportPiper PA46 500TP · Council Bluffs, IAThe pilot's failure to maintain clearance from power lines while returning to the airport after becoming distracted by a noncritical flight instrumentation anomaly indication.NTSB CEN16WA056Accident · 1 fatalForeign investigationPiper PA28R · Ljubljana, Slovenia, SloveniaOn December 3, 2015, a Piper PA-28R-201 airplane, OE-DYM, was destroyed after impact with terrain while on approach to the Ljubljana Airport, Slovenia. The pilot was fatally injured. This investigation is under the jurisdiction and control of the Republic of…NTSB ERA16CA056Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Danbury, CTThe pilot's failure to maintain adequate clearance from obstructions while on approach to landing.NTSB WPR16LA028Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Lancaster, CAThe flight instructor's failure to comply with published instrument approach procedures during an instrument approach in dark night, visual meteorological conditions, which resulted in impact with terrain. Contributing to the accident was the controller's…NTSB WPR16WA026Accident · 1 fatalForeign investigationCessna 310 · Mildura, Australia, AustraliaOn November 6, 2015, at 1840 local time, a Cessna 310R, VH-BWZ, operating under the pertinent civil regulation of the Government of Australia, collided with terrain near Mildura, Australia, while on approach. The airplane was destroyed in the post-impact fire…NTSB CEN16FA024Accident · 4 fatalField investigationFinal reportRaytheon A36 · Pottsville, ARThe pilot's failure to maintain a sufficient climb rate during departure in instrument meteorological conditions, which resulted in controlled flight into terrain.NTSB CEN16LA016Accident · Serious injuriesLimited investigationFinal reportCirrus Design SR22 · Lancaster, TXThe pilot’s failure to maintain a proper glidepath during a night visual approach, which resulted in impact with a power line. Contributing to the accident was an inoperative precision approach path indicator.NTSB WPR16FA006Accident · 3 fatalField investigationFinal reportCessna 182 · Hope, IDThe pilot's selection of an inadequate altitude to cross mountainous terrain and her subsequent failure to maintain terrain clearance. Contributing to the accident was the pilot's inadequate preflight evaluation of the weather conditions and flight plan.NTSB ERA16WA025Accident · 2 fatalForeign investigationPiper PA-28R-200 · Brazil, BrazilOn October 6, 2015, about 1433 UTC, A Piper PA-28R-200 (Embraer EMB711C); Brazilian registration PT-NKU, was destroyed when it impacted terrain while flying from Caratinga, Minas Gerais, Brazil to Serra do Caraca, Minas Gerais, Brazil. The two occupants were…NTSB CEN16FA005Accident · 1 fatalField investigationFinal reportBeech P35 · Chadron, NEThe pilot's continued visual flight rules flight into instrument meteorological conditions, which resulted in controlled flight into rising terrain during cruise flight.NTSB DCA15WA198Incident · No injuriesForeign investigationBoeing 777 · Miami, FLThe National Transportation Safety Board (NTSB) has delegated the investigation of an incident involving a Qatar Airways Boeing 777-300, that occurred on September 15, 2015, to the Civil Aviation Authority (CAA) of Qatar. The NTSB has appointed a U.S.…NTSB CEN15FA400Accident · 4 fatalField investigationFinal reportCessna 310H · Silverton, COThe noninstrument-rated pilot's improper judgment and his failure to maintain situational awareness, which resulted in the flight's encounter with instrument meteorological conditions and controlled flight into terrain during cruise flight.NTSB GAA15CA251Accident · Minor injuriesData collectionFinal reportAir Tractor AT 402A · Fort Pierre, SDThe pilot's failure to maintain obstacle clearance, which resulted in the airplane striking guy-wires during aerial application operations.NTSB ERA15FA326Accident · 1 fatalField investigationFinal reportPiper PA44 · Houlton, METhe pilot's descent below the published minimum descent altitude in night instrument meteorological conditions without visual contact with the runway environment, which resulted in a collision with trees and terrain short of the runway. Contributing to the…NTSB ERA15WA347Accident · 3 fatalForeign investigationCessna TU206B · Lib Mandy, PeruNTSB DCA15WA187Accident · 7 fatalForeign investigationCessna 441 · Cape Town, South AfricaThe government of South Africa has notified the NTSB of an accident involving a Cessna 441 airplane that occurred on August 17, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the government of South Africa's investigation under the…NTSB ERA15LA315Accident · Serious injuriesLimited investigationFinal reportPiper PA 28-161 · Bristow, VAThe student pilot’s failure to maintain altitude during approach, which resulted in controlled flight into terrain. Contributing to the accident was the student’s distraction due to other traffic in the airport traffic pattern.NTSB CEN15FA347Accident · 2 fatalField investigationFinal reportGrumman American Avn. AA 5A · Harrisburg, ILThe student pilot's improper decision to conduct a flight in dark, night conditions and his subsequent controlled flight into terrain.