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 WPR20FA086Accident · 2 fatalClass 3 · FieldFinal reportCessna 140 · Sonora, CAThe pilot’s failure to maintain clearance from trees during approach for landing.NTSB ANC20FA017Accident · 5 fatalClass 3 · FieldFinal reportPiper PA32R · Tuntutuliak, AKThe pilot's continued visual flight rules flight into reduced visibility, including likely flat light and/or white out conditions, which resulted in a controlled flight into terrain. Contributing to the accident were the operator’s inadequate operational…NTSB CEN20WA102Accident · 1 fatalForeign investigationRobinson R44 · Tuzantan, MexicoOn January 25, 2020, about 1858 hours universal coordinated time, a Robinson R-44II helicopter, Mexican registration XB-KQV, impacted terrain near Tuzantan, Chiapas, Mexico. The pilot was fatally injured. The flight departed Ángel Albino Corzo / Tuxtla…NTSB WPR20WA083Accident · 2 fatalForeign investigationCessna 182 · Tangalooma, AustraliaThe government of Australia has notified the NTSB of an accident involving a CESSNA 182 airplane that occurred on January 22, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's investigation under the…NTSB WPR20FA067Accident · 1 fatalClass 3 · FieldFinal reportCessna 150 · Jacksonville, TXThe pilot’s failure to maintain clearance from guy wires associated with a tower while maneuvering at low altitude.NTSB WPR20FA063Accident · 4 fatalClass 3 · FieldFinal reportCessna TR182 · Billings, MTThe pilot’s failure to maintain clearance due to poor decision making in selecting an unsafe altitude during cruise flight.NTSB GAA20WA101Accident · 1 fatalForeign investigationPiper PA25 · Rio Branco, Cerro Largo, UruguayThe government of Uruguay has notified the NTSB of an accident involving a PIPER PA25 airplane that occurred on December 24, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Uruguay's investigation under the provisions…NTSB GAA20WA104Accident · 2 fatalForeign investigationCirrus SR22 · Salzburg, Austria, AustriaThe government of Austria has notified the NTSB of an accident involving a CIRRUS SR22 airplane that occurred on December 21, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Austria's investigation under the…NTSB ERA20WA066Accident · 9 fatalClass 3 · ForeignBeech A100 · Charallave, VenezuelaNTSB WPR20FA034Accident · 3 fatalClass 3 · FieldFinal reportCirrus SR-22 · North Las Vegas, NVThe pilot’s failure to maintain clearance from terrain during cruise flight in dark night conditions.NTSB GAA20WA100Accident · 4 fatalClass 4 · ForeignBeech V35 · Cascavel, BrazilNTSB GAA20WA083Accident · 1 fatalForeign investigationCessna F150 · Santa Severa Nord, ItalyThe government of Italy has notified the NTSB of an accident involving a CESSNA F150 airplane that occurred on November 01, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Italy's investigation under the provisions of…NTSB ERA20FA014Accident · 2 fatalClass 3 · FieldFinal reportPiper PA32 · Raleigh, NCThe pilot’s failure to maintain a safe glidepath during final approach to the runway, which resulted in a collision with trees and terrain. Contributing was the pilot’s lack of recent instrument flight experience.NTSB CEN20WA011Accident · 2 fatalForeign investigationCessna 172 · San Salvador, El SalvadorNTSB WPR19FA266Accident · 2 fatalClass 3 · FieldFinal reportAmerican AA5 · Cowles, NMThe pilot's decision to fly into terrain that exceeded the performance capabilities of the airplane, which resulted in failure to maintain clearance from trees and terrain.NTSB WPR19WA264Accident · 2 fatalForeign investigationMooney M20J · Coffs Harbour, AustraliaThe government of Australia has notified the NTSB of an accident involving a MOONEY M20J airplane that occurred on September 20, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's investigation under the…NTSB ERA19WA292Accident · 2 fatalForeign investigationVans RV-10 · Guaranta do Norte, BrazilThe government of Brazil has notified the NTSB of an accident involving an amateur-built Vans RV-10 airplane that occurred on September 16, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under…NTSB CEN19LA308Accident · 1 fatalClass 3 · LimitedFinal reportCessna 150 · Whitehall, MIThe pilot’s flight into a water tower while operating below minimum safe altitudes for reasons that could not be determined based on the available evidence for this investigation.NTSB WPR19FA250Accident · 2 fatalClass 3 · FieldFinal reportCessna 210 · Henefer, UTThe pilots’ decision to enter a canyon at low altitude, which resulted in controlled flight into terrain while attempting to exit the canyon.NTSB WPR19WA260Accident · 1 fatalForeign investigationAir Tractor AT502 · Gusap, Papua New GuineaOn August 29, 2019, an Air Tractor AT-502B aircraft, registered P2-SET, operated by Ramu Agriculture Industries, collided with a tree near Gusap, Papua New Guinea. The pilot was fatally injured and the airplane was destroyed. The Papua New Guinea (PNG)…NTSB CEN19FA271Accident · 1 fatalClass 3 · FieldFinal reportCessna U206 · Hopedale, LAThe controlled flight into terrain (CFIT), resulting from the pilot’s failure to maintain proper altitude and continued flight into instrument meteorological conditions.NTSB GAA19WA533Accident · 1 fatalForeign investigationPiper PA25 · Totatlan, Jalisco, MexicoThe government of Mexico has notified the NTSB of an accident involving a PIPER PA25 airplane that occurred on August 06, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions of…NTSB ANC19FA042Accident · 4 fatalField investigationFinal reportPiper PA22-150 · Girdwood, AKThe pilot's failure to maintain clearance from terrain due to his impairment from alcohol consumption.NTSB ERA19WA241Accident · 1 fatalForeign investigationCessna 510 · Los Angeles, ChileThe government of Chile has notified the NTSB of an accident involving a Cessna 510 airplane that occurred on August 2, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Chile's investigation under the provisions of…NTSB ERA19LA229Accident · Serious injuriesClass 3 · LimitedFinal reportProgressive Aerodyne Searey · Crescent, FLThe pilot’s misjudgment of his altitude during landing and subsequent decrease in pitch attitude, which resulted in a collision with the water.NTSB ENG19WA040Accident · Minor injuriesForeign investigationAir Tractor AT301 · Airdrome Jorge Efrain, MexicoOn July 10, 2019, an Air Tractor AT-301, registration XB-GBA, powered by a Pratt & Whitney R1300 radial engine, operator by the owner stuck power cables and crashed during a local flight . The Mexican Direccion De Analisis de Accidentes E Incidentes De…NTSB WPR19FA182Accident · 2 fatalClass 3 · FieldFinal reportCub Crafters CCK-1865 · Moab, UTThe pilots failure to maintain clearance from terrain while maneuvering at a low altitude in mountainous terrain.NTSB ERA19WA207Accident · 4 fatalForeign investigationPiper PA 28-180 · Cabo Rojo, Dominican RepublicNTSB WPR19FA172Accident · 1 fatalClass 3 · FieldFinal reportNanchang CJ6 · Porter Ranch, CAThe pilot’s continued flight into marginal visual meteorological conditions, which resulted in controlled flight into terrain.NTSB GAA19WA334Accident · 2 fatalForeign investigationPiper PA12 · Gillam (Manitoba)-Canada, CanadaThe government of Canada has notified the NTSB of an accident involving a PIPER PA12 airplane that occurred on May 29, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Canada's investigation under the provisions of…NTSB WPR19FA146Accident · 1 fatalClass 3 · FieldFinal reportAviat A1 · Santa Ynez, CAThe pilot’s failure to maintain clearance from mountainous terrain during cruise flight in low visibility and mountainous obscuration conditions.NTSB GAA19CA257Accident · Minor injuriesData collectionFinal reportCessna 182 · Glades Park, COThe pilot's failure to maintain adequate airspeed and climb rate during takeoff in high-density altitude conditions, which resulted in his failure to clear power lines.NTSB GAA19WA248Accident · 1 fatalForeign investigationPiper PA46 · Rigolet, NL, CanadaNTSB ANC19TA017Accident · Serious injuriesClass 3Final reportCessna A185 · Nome, AKThe pilot's decision to continue a visual flight rules flight into an area of mountainous terrain and instrument meteorological conditions, which resulted in spatial disorientation and controlled flight into terrain. Contributing to the accident was the…NTSB CEN19LA116Accident · No injuriesClass 3 · LimitedFinal reportBerkey S-6ES · Lafe, ARThe non-certificated pilot's failure to maintain an appropriate glidepath while landing toward the sun, which resulted in impact with vegetation and a subsequent loss of control.NTSB GAA19WA223Accident · 1 fatalForeign investigationCessna A185 · Bocona, VenezuelaThe government of Venezuela has notified the NTSB of an accident involving a CESSNA A185 airplane that occurred on March 22, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Venezuela's investigation under the…NTSB CEN19FA084Accident · 1 fatalClass 3 · FieldFinal reportPiper PA32R · Goshen, INThe pilot’s failure to maintain adequate altitude for undetermined reasons during a practice circling approach in dark night visual meteorological conditions, which resulted in a collision with power lines.NTSB WPR19FA083Accident · 1 fatalClass 3 · FieldFinal reportMooney M20F · Diablo, CAThe student pilot’s decision to depart on a visual flight rules flight into reduced visibility night conditions and his subsequent failure to maintain clearance from mountainous terrain, which resulted in controlled flight into terrain.NTSB CEN19WA052Accident · 2 fatalForeign investigationPiper PA28R · Regil, SpainOn January 9, 2019, about 1215 UTC, a Piper PA-28-201 Arrow III, United Kingdom registry G-OARI, impacted mountainous terrain near Regil, Guipuzcoa, Spain. The two persons on board were fatally injured and the airplane was destroyed. Instrument meteorological…NTSB ERA19FA070Accident · 3 fatalField investigationFinal reportPiper PA28 · Blairsville, GAThe pilot's failure to maintain clearance from trees during a visual approach for landing in night visual meteorological conditions. Contributing to the accident was the pilot's lack of recent experience flying at night.NTSB CEN19WA043Accident · 2 fatalForeign investigationCessna 177 · Spain, SpainThe government of Spain has notified the NTSB of an accident involving a CESSNA 177 airplane that occurred on December 07, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Spain's investigation under the provisions of…NTSB ERA19FA059Accident · 1 fatalField investigationFinal reportCessna 210 · Apalachicola, FLThe pilot's controlled flight into terrain as a result of his spatial disorientation during departure in dark nighttime conditions.NTSB ERA19WA104Accident · 6 fatalForeign investigationAgusta AW109 · Campos do Jordao, BrazilThe government of Brazil has notified the NTSB of an accident involving a Agusta AW109 helicopter that occurred on November 24, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the…NTSB WPR19FA026Accident · 2 fatalClass 2 · FieldFinal reportZenith CH601 · Overgaard, AZThe pilot’s failure to monitor the airport’s visual approach path indicator during the final approach to the upsloping runway, which resulted in a low approach path and impact with terrain.NTSB CEN19WA038Accident · 1 fatalForeign investigationPiper PA25 · Pachuca, Mexico, MexicoThe government of Mexico has notified the NTSB of an accident involving a PIPER PA25 airplane that occurred on November 08, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions…NTSB CEN19FA024Accident · 3 fatalField investigationFinal reportBell 206 · Uvalde, TXThe pilot's controlled flight into terrain during night visual meteorological conditions. Contributing to the accident was the pilot improper decision to inhibit the helicopter's terrain warning systems and flight at low altitude.NTSB WPR19TA005Accident · Serious injuriesFinal reportBalloon Works Firefly 7 · Placitas, NMThe pilot’s failure to properly estimate the height of terrain while descending the balloon, which resulted in the balloon impacting a hill and passengers sustaining serious injuries.NTSB GAA19CA021Accident · No injuriesData collectionFinal reportAviat S · Hampton, GAThe pilot’s failure to see and avoid power wires during approach.NTSB ERA19FA003Accident · 1 fatalField investigationFinal reportPiper J3C · Fancy Gap, VAThe non-instrument-rated pilot's improper decision to undertake a flight into forecast instrument meteorological conditions (IMC) and his subsequent decision to continue the flight after encountering IMC, which resulted in controlled flight into terrain.…NTSB CEN18FA386Accident · 1 fatalField investigationFinal reportCessna U206 · Rainy Pass, AKThe pilot's improper decision to continue the flight in deteriorating weather conditions, which resulted in an inadvertent entry into a box canyon and subsequent controlled flight into mountainous terrain.