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 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 CEN16LA207Accident · Minor injuriesLimited investigationFinal reportSmith Capella FW2R · Alamo, TXThe total loss of engine power due to fuel exhaustion, which resulted in a forced landing and a collision with a tree.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 ANC16FA023Accident · 1 fatalField investigationFinal reportAirbus AS350 · Skagway, AKThe pilot's decision to continue visual flight into an area of instrument meteorological conditions, which resulted in the pilot experiencing a loss of visual reference and subsequent controlled flight into terrain. Contributing to the accident were the…NTSB ANC16LA022Accident · Serious injuriesLimited investigationFinal reportAirbus AS350 · Juneau, AKThe pilot's failure to maintain terrain clearance while on approach to land in flat light conditions. Contributing to the severity of the pilot's injuries was the inadequately restrained internal cargo, which shifted forward during the impact and struck the…NTSB 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 GAA16CA077Accident · No injuriesData collectionFinal reportPiper PA 28 · California, MDThe student pilot's descent below the prescribed final approach path at night, and flight instructor's failure to correct the student pilot's descent, which resulted in a collision with trees and impact with the ground.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 ERA16FA063Accident · 2 fatalField investigationFinal reportTimothy C Williams CCK-1865 · Linesville, PAThe noninstrument-rated pilot's improper decision to attempt a flight under visual flight rules at night in instrument meteorological conditions to an unlit airstrip, which resulted in controlled flight into terrain.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 GAA16LA031Accident · No injuriesLimited investigationFinal reportAirbus AS350 · Deadhorse, AKThe noninstrument-rated pilot's continued visual flight into adverse weather conditions, which resulted in spatial disorientation, and his subsequent failure to maintain terrain clearance while attempting to land in flat light and whiteout conditions.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 GAA16CA008Accident · No injuriesData collectionFinal reportPiper PA · Glennallen, AKThe pilot's failure to maintain clearance from trees during the approach to land, resulting in a collision with trees.NTSB ERA16LA003Accident · Serious injuriesClass 2 · LimitedFinal reportBeech S35 · Knoxville, TNThe pilot's inadequate preflight weather planning and his improper decision to attempt a visual flight rules flight in night instrument metrological conditions, which resulted in spatial disorientation and subsequent collision with terrain.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 ERA15FA299Accident · 1 fatalField investigationFinal reportPiper PA-28R · Marathon, FLThe pilot's failure to maintain a positive climb rate after takeoff due to spatial disorientation while turning after takeoff in dark night conditions in a sparsely populated area, which resulted in the airplane’s descent into water. Contributing to the…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.NTSB CEN15FA342Accident · 1 fatalField investigationFinal reportPiper PA 32R-300 · Harbor Springs, MIThe pilot's failure to maintain clearance from the trees during the approach in dark, night conditions, which resulted in controlled flight into trees and terrain.NTSB CEN15RA352Accident · 1 fatalForeign investigationDehavilland DHC 2 · Akureyri, IcelandOn August 9, 2015, at an unknown time, a De Havilland DHC-2 airplane, United States registration N610LC, was substantially damaged when it impacted mountainous terrain near Akureyri, Iceland. One occupant sustained fatal injuries, and one occupant sustained…