NTSB investigations
1,074 cases where the sequence of events included Controlled flight into terr/obj (CFIT).
Cases per year
| 2008 | 57 |
|---|---|
| 2009 | 70 |
| 2010 | 70 |
| 2011 | 99 |
| 2012 | 79 |
| 2013 | 91 |
| 2014 | 61 |
| 2015 | 75 |
| 2016 | 56 |
| 2017 | 68 |
| 2018 | 63 |
| 2019 | 40 |
| 2020 | 35 |
| 2021 | 38 |
| 2022 | 35 |
| 2023 | 38 |
| 2024 | 39 |
| 2025 | 33 |
| 2026 | 27 |
Where
Open the mapLatest cases
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 WPR27FA014Accident · 2 fatalClass 3 · FieldInvestigation openPiper PA-18-150 · Aeneas, WANTSB CEN26LA324Accident · 2 fatalClass 3 · LimitedPreliminary reportMagni M16 · Annapolis, MOOn September 23, 2026, about 1755 central daylight time, an experimental Magni M16 gyroplane, N109MG, was substantially damaged when it was involved in an accident near Annapolis, Missouri. The pilot and passenger were both fatally injured. The gyroplane was…NTSB ERA26LA307Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Altoona, PAThe pilot’s descent below the glidepath and collision with trees during a missed approach.NTSB ERA26LA300Accident · Serious injuriesClass 4 · LimitedFinal reportWaco Classic 2T-1A-2 · Clermont, FLThe pilot’s failure to maintain clearance from trees during the landing approach.NTSB WPR26LA266Accident · No injuriesClass 4 · LimitedInvestigation openMaule M-4-180V · Sapinero, CONTSB ERA26FA271Accident · 3 fatalClass 3 · FieldPreliminary reportSmith Aerostar 601 · Lake Clear, NYOn July 13, 2026, about 2236 eastern daylight time, a Smith Aerostar 601P, N800AA was destroyed when it was involved in an accident near Lake Clear, New York. The private pilot and two passengers were fatally injured. The airplane was operated as a Title 14…NTSB ERA26FA266Accident · 1 fatalClass 3 · FieldPreliminary reportSikorsky S76 · Huntersville, WVOn July 10, 2026, about 0745 eastern daylight time, a Sikorsky S-76D helicopter, N93RT, was destroyed when it was involved in an accident near Huntersville, West Virginia. The commercial pilot was fatally injured. The helicopter was operated as a Title 14…NTSB WPR26LA250Accident · No injuriesClass 4 · LimitedInvestigation openAeronca 7AC · Buffalo, WYNTSB WPR26FA232Accident · 1 fatalClass 3 · FieldPreliminary reportCessna 172 · Willard, UTOn June 23, 2026, at about 2247 mountain daylight time, a Cessna 172S, N387AF, was destroyed when it was involved in an accident near Willard, Utah. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations Part 91…NTSB WPR26LA234Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-12 · Dixie, IDThe pilot's delayed decision to initiate a go-around and subsequent failure to maintain clearance from rising terrain.NTSB ANC26FA057Accident · 1 fatalClass 3 · FieldPreliminary reportPiper PA20 · Cordova, AKOn June 18, 2026, at approximately 1200, an experimental Piper PA-20 airplane, N7635K, was destroyed when it was involved in an accident about 44 miles southeast of Cordova, Alaska. The pilot was fatally injured. The airplane was operated as a Title 14 Code…NTSB WPR26LA196Accident · Serious injuriesClass 4 · LimitedFinal reportDiamond DA40 · Wells, NVThe pilot’s inability to maintain climb performance and clearance from mountainous terrain due to a downdraft.NTSB WPR26FA186Accident · 4 fatalClass 3 · FieldPreliminary reportBeech C90 · Lincoln, NMOn May 14, 2026, at 0015 mountain daylight time, a Beech C90, N249CP, was destroyed when it was involved in an accident near Lincoln, New Mexico. Both pilots and passengers sustained fatal injuries. The airplane was operated by Generation Jets under the…NTSB CEN26LA180Accident · Serious injuriesClass 4 · LimitedFinal reportJust JA-30 · Hartville, MOThe pilot’s failure to maintain clearance from a power line after takeoff.NTSB ERA26FA178Accident · 1 fatalClass 3 · FieldPreliminary reportMooney M20J · Ironton, OHOn April 17, 2026, about 1414 eastern daylight time, a Mooney M20J, N205MK, was destroyed when it was involved in an accident near Ironton, Ohio. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations Part 91…NTSB WPR26LA158Accident · Minor injuriesClass 3 · LimitedPreliminary reportAlexander Schleicher ASH 31 MI · Williams, CAOn April 13, 2026, about 1051 Pacific standard time, an experimental Alexander Schleicher GMBH and Co., Ash 31 Mi Glider, N77UK, was substantially damaged when it was involved in an accident near Williams, California. The pilot sustained minor injuries. The…NTSB DCA26LA159Accident · No injuriesClass 4 · LimitedFinal reportPyka Pelican Cargo · Summit Point, WVThe inaccurate obstacle height entered into mission planning that resulted in the aircraft wing’s impact with a tree during descent, resulting resulted in a loss of control.NTSB GAA26WA130Accident · 1 fatalClass 5 · ForeignRobinson R44 · Drake, AustraliaNTSB ERA26LA143Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Carthage, NCThe pilot’s failure to maintain clearance from trees while on final approach for landing. Contributing to the accident were the flight instructor’s inadequate remedial actions.NTSB CEN26LA129Accident · No injuriesClass 4 · LimitedInvestigation openCameron Balloons US Z-77 · East Mountain, TXNTSB WPR26FA103Accident · 1 fatalClass 3 · FieldPreliminary reportCessna 210B · Camarillo, CAOn February 15, 2026, about 1805 Pacific standard time, a Cessna 210B, N9735X, was substantially damaged when it was involved in an accident near Camarillo, California. The pilot was fatally injured and the passenger sustained serious injuries. The airplane…NTSB CEN26FA115Accident · 4 fatalClass 3 · FieldPreliminary reportEpic E1000 · Steamboat Springs, COOn February 13, 2026, about 0019 mountain standard time, an Epic E1000 airplane, N98FK, was substantially damaged when it was involved in an accident near Steamboat Springs, Colorado. The pilot and three passengers were fatally injured. The airplane was…NTSB DCA26WA113Accident · 2 fatalClass 5 · ForeignEmbraer EMB-110P1 · Les Cayes, HaitiNTSB WPR26LA095Accident · Minor injuriesClass 4 · LimitedFinal reportAmerican Champion 8KCAB · Alpine, WYThe pilot’s inadvertent descent while operating in flat light conditions which resulted in controlled flight into terrain.NTSB DCA26WA105Accident · 15 fatalClass 5 · ForeignBeech 1900 · Santander, ColombiaNTSB GAA26WA086Accident · 2 fatalClass 5 · ForeignVans RV-8A · Norwell, AustraliaNTSB ERA26LA096Accident · No injuriesClass 4 · LimitedFinal reportAmerican General Acft AG5B · Fairfield, NJThe pilot’s failure to maintain an appropriate glide path during the landing approach in gusting wind conditions, resulting in an impact with trees prior to the runway.NTSB WPR26FA067Accident · 6 fatalClass 3 · FieldPreliminary reportBeechcraft B300 · Galveston, TXOn December 22, 2025, about 1505 central standard time, a Beechcraft B300, ANX1209, was substantially damaged when it was involved in an accident near Galveston, Texas. The pilot, co-pilot, two flight crew, two passengers were fatally injured and two…NTSB CEN26FA049Accident · 1 fatalClass 3 · FieldPreliminary reportPiper PA-28R-201 · Pittsfield, ILOn November 23, 2025, about 2137 central standard time (all referenced times are CST), a Piper PA-28R-201 airplane, N47700, was substantially damaged when it was involved in an accident near Pittsfield, Illinois. The pilot was fatally injured, and the 2…NTSB ERA26FA039Accident · 2 fatalClass 3 · FieldPreliminary reportJabiru USA Sport J230-SP · New Bavaria, OHOn November 14, 2025, at 1708 eastern standard time, a Jabiru USA Sport Aircraft LLC J230-SP, N755J, was substantially damaged when it was involved in an accident near New Bavaria, Ohio. The sport pilot and passenger were fatally injured. The airplane was…NTSB ERA26LA036Accident · Minor injuriesClass 4 · LimitedFinal reportCzech Sport Aircraft A S Sportcruiser · Cuthbert, GAThe pilot’s failure to maintain clearance from trees and terrain while maneuvering for a precautionary landing, at low altitude and at night.NTSB ERA26LA022Accident · No injuriesClass 4 · LimitedFinal reportRans Employee Flying Club Rans S-6ES Coyote II · Williston, SCThe pilot’s failure to maintain directional control of the airplane during the initial climb in gusting crosswind conditions.NTSB ERA26FA019Accident · 1 fatalClass 3 · FieldPreliminary reportCirrus SR22 · Ruston, LAOn October 21, 2025, about 0944 central daylight time, a Cirrus SR22, N42BE, was destroyed when it was involved in an accident near Ruston, Louisiana. The private pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations…NTSB GAA26WA010Accident · 3 fatalClass 5 · ForeignCessna TU206 · Tecpan, GuatemalaNTSB ERA26LA004Accident · No injuriesClass 3 · LimitedPreliminary reportPitts S1C · Mount Washington, KYOn October 6, 2025, about 1415 eastern daylight time, a Pitts S-1C Special, C-FAZJ, was substantially damaged when it was involved in an accident in Mt. Washington, Kentucky. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal…NTSB ERA25FA367Accident · 1 fatalClass 3 · FieldPreliminary reportToop Thomas A Glasair Super II FT · Wallkill, NYOn September 27, 2025, at 1418 eastern daylight time, an experimental, amateur-built Glasair Super II FT, N45BT, was destroyed when it was involved in an accident near Wallkill, New York. The pilot sustained fatal injuries. The airplane was operated as a…NTSB ERA25LA363Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32R-300 · White Plains, NYThe pilot’s failure to maintain proper glidepath during a night visual approach, which resulted in a collision with the runway lighting system. Contributing to the outcome was the pilot’s momentary disorientation due to glare from the runway approach lighting…NTSB GAA25WA263Accident · 2 fatalClass 5 · ForeignBell 412 · Talpa de Allende, MexicoNTSB WPR25LA283Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 150F · Rigby, IDThe flight instructor’s improper flap position during takeoff, which resulted in degraded climb performance and a subsequent impact with a building.NTSB GAA25WA280Accident · 4 fatalClass 5 · ForeignDehavilland DHC-2 MK. 1 · St Theresa, CanadaNTSB ERA25FA344Accident · 2 fatalClass 3 · FieldPreliminary reportHughes 369D · Jim Thorpe, PAOn September 11, 2025, about 1402 eastern daylight time, a Hughes (McDonnell Douglas) 369D helicopter, N5072F, was destroyed when it was involved in an accident near Jim Thorpe, Pennsylvania. The commercial pilot and line technician were fatally injured. The…NTSB ERA25LA341Accident · No injuriesClass 4 · LimitedFinal reportGrumman G-44A · Beaver Cove, METhe pilot’s distraction and failure to monitor the airplane’s flight path, which resulted in controlled flight into a lake.NTSB ANC25FA098Accident · 1 fatalClass 3 · FieldPreliminary reportPiper PA-28-180 · Wolf, WYOn September 1, 2025 about 1612 mountain daylight time, a Piper PA-28-180 airplane, N8307W, was substantially damaged when it was involved in an accident near Wolf, Wyoming. The pilot and one passenger were seriously injured; one passenger was fatally…NTSB WPR25FA269Accident · 1 fatalClass 3 · FieldPreliminary reportPiper PA-28R-200 · Alta, UTOn August 31, 2025, about 1720, mountain daylight time a Piper PA28-200R, N1147X, was substantially damaged when it was involved in an accident near Alta, Utah. The pilot was seriously injured, and the passenger sustained fatal injuries. The airplane was…NTSB WPR25LA259Accident · Serious injuriesClass 3 · LimitedPreliminary reportCzech Aircraft Group Sro Sportcruiser · Puyallup, WAOn August 25, 2025, about 1456 Pacific daylight time, a Czech Aircraft Group SRO Sportcruiser, N538SF was substantially damaged when it was involved in an accident near Puyallup, Washington. The pilot sustained serious injuries, and the passenger was not…NTSB WPR25FA256Accident · 2 fatalClass 3 · FieldPreliminary reportBeech M35 · Des Moines, NMOn August 13, 2025, about 2300 mountain daylight time, a Beech M35, N951T, was destroyed when it was involved in an accident near Des Moines, New Mexico. The pilot and passenger were fatally injured. The airplane was operated as a Title 14 Code of Federal…NTSB CEN25LA312Accident · Serious injuriesClass 4 · LimitedFinal reportTaylorcraft BC12 · Ozark, ARThe pilot’s failure to maintain clearance from a tree which resulted in the right wing impacting the tree and a subsequent collision with trees and terrain. Contributing to the accident was the pilot’s decision to operate the airplane at a low altitude over…NTSB CEN25LA311Accident · No injuriesClass 4 · LimitedFinal reportSchweizer SGS 2-33A · Monee, ILThe student pilot’s failure to maintain airspeed and altitude resulting in a collision with the ground during the base to final turn.NTSB WPR25FA232Accident · 1 fatalClass 3 · FieldPreliminary reportSchleicher ASW27-18 · Morgan, UTOn August 1, 2025, about 1358 mountain daylight time, a Schleicher ASW27-18, N929JK, was involved in an accident near Morgan, Utah. The pilot was fatally injured. The glider was operated as a Title 14 Code of Federal Regulations Part 91 personal flight. A…NTSB CEN25LA283Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-301 · Hartsburg, ILThe pilot’s failure to maintain control of the airplane during takeoff with a tailwind from a wet turf airstrip.