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 CEN15WA339Accident · No injuriesForeign investigationKitfox Series 7 · Hundwil, SwitzerlandOn August 5, 2015 about 0840 UTC, a Kitfox Series 7 airplane, Swiss registration HB-YMG, impacted into a forest near Hundwil-Appenzell, Switzerland. The pilot and the passenger were killed, and the airplane was destroyed. Visual Meteorological conditions…NTSB WPR15FA227Accident · 1 fatalField investigationFinal reportCessna P337G · Santa Paula, CAThe noninstrument-rated pilot's decision to conduct a visual flight in instrument meteorological conditions, which resulted in controlled flight into mountainous terrain.NTSB ERA15LA282Accident · Serious injuriesLimited investigationFinal reportNorth American Navion · Waynesboro, VAThe pilot's early rotation of the airplane and his failure to attain a positive climb rate during takeoff with the airplane near its aft center of gravity limit from a runway with little margin for error.NTSB CEN15WA338Accident · 1 fatalForeign investigation3xtrim 450 Ultra · Golub-Dobrzyn City, PolandOn July 17, 2015 about 1615 UTC, a 3Xtrim 450 Ultra, light sport airplane, Poland registration SP-SPRL, impacted terrain while on a sightseeing flight near Golub-Dobrzyn, Poland. The pilot was seriously injured and the passenger was killed. The airplane was…NTSB ANC15FA049Accident · 1 fatalClass 3 · FieldFinal reportCessna 207A · Juneau, AKThe pilot's decision to initiate and continue visual flight into instrument meteorological conditions, which resulted in a loss of situational awareness and controlled flight into terrain. Contributing to the accident were the company's failure to follow its…NTSB WPR15FA215Accident · 2 fatalField investigationFinal reportPiper PA 22-160 · Twin Sisters Mtn, WAThe noninstrument-rated pilot's continued visual flight into instrument meteorological conditions, which resulted in controlled flight into mountainous terrain.NTSB WPR15FA212Accident · 2 fatalField investigationFinal reportBeech A35 · Mazama, WAThe noninstrument-rated pilot’s decision to continue visual flight into instrument meteorological conditions, which resulted in his failure to maintain clearance from mountainous terrain.NTSB GAA15CA171Accident · No injuriesData collectionFinal reportWeatherly 620B · Hatch, NMThe pilot failed to maintain obstacle clearance, and the airplane struck a transmission line wire during aerial application operations.NTSB GAA15CA196Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Forest City, SDThe pilot's failure to monitor the flight environment for adequate terrain/obstacle clearance during takeoff, which resulted in the inflight collision with power transmission line wires.NTSB CEN15LA294Accident · No injuriesLimited investigationFinal reportBoeing A75N1 (PT17) · Louisburg, KSA partial loss of engine power for reasons that could not be determined during postaccident examinations.NTSB ANC15MA041Accident · 9 fatalClass 1 · MajorFinal reportDehavilland DHC-3 · Ketchikan, AK(1) the pilot's decision to continue visual flight into an area of instrument meteorological conditions, which resulted in his geographic disorientation and controlled flight into terrain; and (2) Promech's company culture, which tacitly endorsed flying in…NTSB GAA15CA128Accident · No injuriesData collectionFinal reportBeech C23 · Long Beach, CAThe pilot failed to maintain clearance from trees while maneuvering to land at night, which resulted in a collision with terrain/objects. A factor contributing to the accident was the lack of oversight by ATC; failing to insure that the fully operational VASI…NTSB WPR15LA190Accident · Serious injuriesLimited investigationFinal reportPiper PA 20 · Yellow Pine, IDThe pilot's delayed decision to go around after realizing that the airplane’s airspeed and altitude were too high, which resulted in an inadequate flare and bounced landing and a subsequent go-around in high-density altitude conditions.NTSB ERA15WA250Accident · 3 fatalForeign investigationBell 206B · Ouro Preto, Minas Gerais, BrazilOn June 16, 2015, at 1910 Universal Coordinated Time (UTC), a Bell 206B helicopter, Brazilian registration PT-YDY, operated by a private owner, was destroyed following a controlled flight into terrain near Ouro Preto municipality, State of Minas Gerais,…NTSB CEN15WA273Accident · 3 fatalForeign investigationPiper PA-23-250 · Kangirsuk, CanadaOn June 11, 2015, about 2340 eastern daylight time, a Canadian registered PA-23-250, C-FXPS, impacted terrain about 1.2 nautical miles from the Kangirsuk Airport, Kangirsuk, Quebec, Canada. The pilot and two passengers were fatally injured. The investigation…NTSB ANC15WA036Accident · 2 fatalForeign investigationCessna 182 · Sikanni Chief, CanadaNTSB GAA15LA101Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT 502B · Archer City, TXThe pilot’s failure to maintain adequate clearance from power transmission lines during an aerial application flight.NTSB GAA15CA090Accident · Minor injuriesData collectionFinal reportPiper PA 25-260 · Casselton, NDThe pilot's failure to monitor the flight environment for adequate terrain/obstacle clearance, which resulted in the inflight collision with power transmission line wires.NTSB CEN15WA254Accident · 2 fatalForeign investigationCessna T182 - T · Carlow, IrelandNTSB WPR15FA166Accident · 1 fatalField investigationFinal reportCessna 210F · Pleasanton, CAThe pilot’s continued visual flight into instrument flight rules conditions, which resulted in his failure to maintain sufficient clearance from rising terrain.NTSB WPR15LA156Accident · Minor injuriesLimited investigationFinal reportBuhl LA 1 · Cottage Grove, ORA loss of engine power on downwind for landing due to carburetor icing, which resulted in a forced landing.NTSB ERA15FA204Accident · 1 fatalField investigationFinal reportCessna 182 · Mulberry, TNThe pilot's failure to recover from a controlled descent for reasons that could not be determined during the postaccident investigation.NTSB CEN15LA235Accident · Serious injuriesLimited investigationFinal reportLathrop Steven A B8M · Ravenna, MIA total loss of engine power due to carburetor icing.NTSB WPR15LA150Accident · 1 fatalLimited investigationFinal reportCessna 206H · Redding, CAThe pilot's intentional descent into terrain.NTSB WPR15FA147Accident · 1 fatalField investigationFinal reportRobert C. Hanson Pitts S2E · Lebec, CAThe pilot’s continued visual flight into instrument meteorological conditions, which resulted in his failure to maintain sufficient clearance from rising terrain.NTSB WPR15WA145Accident · 1 fatalForeign investigationBell 206 - B · Ziyang City, China, ChinaOn April 13, 2015, at 0800 local time, a Bell 206 BIII, B-7607, collided with a wire during an aerial application flight near Ziyang City, Sichuan Province, China. The helicopter was operated by Hubei Tongcheng General Aviation Ltd under the pertinent civil…NTSB ERA15WA182Accident · 3 fatalForeign investigationCessna 172S · Santander, ColombiaOn April 12, 2015, about 1915 coordinated universal time, a Cessna 172S, Colombian registration HK5064G, and a Cessna 150M, Colombian registration HK1912G, were substantially damaged after impacting mountainous terrain in the vicinity of the Serrania Los…NTSB ERA15FA181Accident · 4 fatalField investigationFinal reportPiper PA-31T1 · Fort Lauderdale, FLA rapid onset of smoke and/or fire inflight for reasons that could not be determined due to the postimpact fire and the condition of the wreckage.NTSB ERA15FA178Accident · 1 fatalField investigationFinal reportHughes 369D · Cherokee, ALThe pilot's spatial disorientation during a low-level river crossing in rainy, gray, reduced visibility meteorological conditions, which resulted in the helicopter's subsequent descent and impact with the water. Contributing to the accident was the pilot's…NTSB ERA15CA176Accident · Serious injuriesData collectionFinal reportBeech V35B · Wetumpka, ALThe pilot's use of an incorrect radio frequency when attempting to turn on the runway lights, resulting is an attempt to land the airplane while aligned with airport hangar lights.NTSB CEN15FA189Accident · 1 fatalField investigationFinal reportCessna 152 · Batesville, ARThe noninstrument-rated pilot's controlled flight into terrain due to an inadvertent encounter with clouds in dark night conditions. Contributing to the accident was the pilot's decision to fly at night in marginal visual meteorological conditions without the…NTSB ERA15WA180Accident · 4 fatalForeign investigationBell 206 - L4 · Diego de Almagro, ChileOn March 31, 2015, about 2210 universal coordinated time (UTC), a Bell 206L4, Chilean registration CC-APP, operated by a private individual, was destroyed during a collision with power lines and a subsequent postcrash fire, while maneuvering near Diego de…NTSB CEN15FA187Accident · 2 fatalField investigationFinal reportAircraft Mfg & Dvlpmt CH601XL · Pleasanton, KSThe pilot's excessively high angle-of-attack on rotation that prevented the airplane from climbing sufficiently to avoid the approaching trees.NTSB ENG15WA026Accident · Minor injuriesForeign investigationAirbus A320 - 211 · Halifax, CanadaOn 29 March 2015, an Air Canada Airbus A320-200 aircraft (registration C-FTJP) clipped a power line and approach lights short of Runway 05 at the Halifax Stanfield International Airport. The Transportation Safety Board (TSB) of Canada is investigating the…NTSB WPR15FA135Accident · 1 fatalField investigationFinal reportPiper PA32R - 301 · Townsend, MTThe pilot's decision to depart on and to continue a visual flight rules flight over mountainous terrain into instrument meteorological conditions, which resulted in controlled flight into terrain. Contributing to the accident was the pilot's lack of recent…NTSB CEN15FA174Accident · 1 fatalField investigationFinal reportCessna 182Q · El Paso, TXThe pilot's decision to continue a visual flight rules flight into known instrument flight rules conditions, which resulted in controlled flight into terrain.NTSB CEN15FA171Accident · 1 fatalField investigationFinal reportEurocopter AS 350 B2 · Eufaula, OKThe flight's inadvertent encounter with night instrument meteorological conditions, which resulted in the pilot turning the helicopter and subsequently descending into trees and terrain due to spatial disorientation.NTSB ERA15FA144Accident · 3 fatalField investigationFinal reportMooney M20F · Norfolk, VAThe pilot's failure to properly execute the instrument approach procedure. Contributing to the accident were the pilot's improper preflight planning and his decision to conduct the flight in instrument meteorological conditions at night into forecast moderate…NTSB ERA15WA131Accident · 1 fatalForeign investigationCessna A188 · Tapes, BrazilOn February 7, 2015, about 1100 universal coordinated time, a Cessna A188, Brazilian registration PT-LOA, was destroyed when it struck a high-tension powerline and impacted terrain while maneuvering over a soybean field near Tapes, Brazil. The pilot was…NTSB ERA15CA127Accident · No injuriesData collectionFinal reportSchweizer 269C 1 · Carthage, NYThe non-helicopter-rated pilot's improper decision to operate the helicopter at low-level and his inability to adequately see the horizon over snow and ice, which resulted in controlled flight into terrain.NTSB ERA15LA114Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Fernandina Beach, FLThe pilot’s physical impairment due to intense pain, which resulted in his failure to maintain airplane control.NTSB CEN15LA122Accident · Serious injuriesLimited investigationFinal reportCessna 172F · Routt County, COThe pilot’s intentional flight into terrain.NTSB ERA15WA108Accident · 1 fatalForeign investigationCessna A188B · Baixa Grande do Ribeiro, BrazilOn January 14, 2015, about 1050 universal coordinated time, a Cessna A188B, Brazilian registration PT-FFH, was substantially damaged when it collided with a utility pole during an aerial application flight near Baixa Grande do Ribeiro, Brazil. The foreign…NTSB CEN15FA101Accident · 1 fatalField investigationFinal reportPiper PA 28RT-201T · Brighton, COThe pilot's intentional descent into the terrain.NTSB ERA15WA104Accident · 1 fatalForeign investigationRobinson R44 - II · Santa Monica, BrazilOn January 10, 2015, about 2000 universal coordinated time, a Robinson R44 II, Brazilian registration PR-HPR, was destroyed by impact and fire after collision with wires and terrain during cruise flight in Santa Monica, Parana, Brazil. There was a post-crash…NTSB WPR15FA082Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · Tooele, UTThe non-instrument rated pilot’s decision to depart into low visibility conditions, which resulted in spatial disorientation and a loss of control. Contributing to the accident was the pilot’s impaired performance due to his use of the sedating antihistamine,…NTSB WPR15FA072Accident · 2 fatalField investigationFinal reportBell 206 · Benson, AZThe pilot’s continued visual flight into instrument meteorological conditions which resulted in an inflight collision with terrain. Contributing to the accident was the pilot’s inadequate preflight planning, during which he failed to identify forecasted…NTSB CEN15FA090Accident · 1 fatalField investigationFinal reportCessna 404 · Englewood, COThe loss of power to the right engine for reasons that could not be determined during postaccident examination and teardown and the pilot’s failure to properly configure the airplane for single-engine flight.NTSB CEN15LA077Accident · Serious injuriesLimited investigationFinal reportNew Piper PA 32R-301T · Springfield, MOThe pilot’s decision to descend below the recommended altitude during approach for landing in night visual meteorological conditions, and his failure to see and avoid a lighted tower, which resulted in collision with the tower and a subsequent total loss of…NTSB CEN15FA051Accident · 2 fatalField investigationFinal reportMooney M20C · Pagosa Springs, COThe noninstrument-rated pilot's improper decision to fly to the destination airport and into known instrument meteorological conditions, which resulted in his controlled flight into mountainous terrain during a snow storm.