Fatal NTSB investigations

655 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.\"highestInjuryLevel\" = 'Fatal'
    AND 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.

NTSB WPR24FA195Accident · 2 fatalClass 3 · FieldFinal reportLuscombe 8A · South Lake Tahoe, CAThe pilot’s decision to continue low-altitude flight toward rising mountainous terrain in high density altitude conditions, which resulted in collision with trees and terrain.Jun 12, 2024 · N37081 · Substantial damageNTSB WPR24FA190Accident · 1 fatalClass 3 · FieldFinal reportCessna 177B · Elk River, IDThe pilot’s failure to maintain clearance from terrain while climbing in mountainous terrain during moderately high density altitude conditions, and conditions conducive to severe carburetor icing.Jun 12, 2024 · N34903 · DestroyedNTSB GAA24WA179Accident · 2 fatalClass 5 · ForeignPiper PA-34-200T · Santa Rosa, EcuadorMay 28, 2024 · HC-BNG · DestroyedNTSB ANC24FA032Accident · 2 fatalClass 3 · FieldFinal reportTaylorcraft BC12-D · Nondalton, AKThe non-certificated pilot’s continued visual flight rules flight into instrument meteorological conditions, which resulted in controlled flight into the water.May 17, 2024 · N95744 · Substantial damageNTSB GAA24WA133Accident · 1 fatalClass 4 · ForeignCessna 172 · La Linea, ChileMar 29, 2024 · CC-PFV · Substantial damageNTSB ERA24FA136Accident · 5 fatalClass 3 · FieldFinal reportIsrael Aircraft Industries 1125 Westwind Astra · Hot Springs, VAThe PIC’s continuation of an unstabilized approach in gusting wind conditions and his failure to monitor the airplane’s altitude during the approach, which led to a descent into terrain short of the runway. Contributing was the flight crew’s failure to set…Mar 10, 2024 · N1125A · DestroyedNTSB ERA24FA120Accident · 3 fatalClass 3 · FieldFinal reportPiper PA32 · Jackson, OHThe non-instrument-rated pilot’s decision to depart under visual flight rules into instrument meteorological conditions, which resulted in an inflight collision with terrain while maneuvering.Feb 24, 2024 · N8963N · DestroyedNTSB GAA24WA095Accident · 2 fatalClass 5 · ForeignCessna U206 · Canaima, VenezuelaFeb 13, 2024 · YV-1396 · Substantial damageNTSB GAA24WA131Accident · 9 fatalClass 5 · ForeignBeech E90 · Lote Ocho, MexicoFeb 11, 2024 · XB-SKANTSB ERA24FA096Accident · 2 fatalClass 3 · FieldFinal reportCessna 172 · Weston, FLThe pilots’ spatial disorientation in dark night visual meteorological conditions, which resulted in their failure to maintain altitude and a subsequent descent and impact with a swamp.Jan 23, 2024 · N737VC · Substantial damageNTSB CEN24FA089Accident · 3 fatalClass 3 · FieldFinal reportCessna 310R · Poolville, TXPilot incapacitation for undetermined reasons which resulted into controlled descent into terrain.Jan 14, 2024 · N252DL · DestroyedNTSB GAA24WA062Accident · 1 fatalClass 5 · ForeignCessna A185 · Dorotea, ColombiaDec 30, 2023 · HK1658G · Substantial damageNTSB GAA24WA052Accident · 5 fatalClass 3 · ForeignBell 412 · Arau, GuyanaDec 6, 2023 · 8R-AYA · DestroyedNTSB ERA24FA053Accident · 1 fatalClass 3 · FieldFinal reportBeech C23 · Midland, VAThe pilot’s decision to descend below the minimum decision altitude of the instrument approach without having the appropriate runway visual references distinctively identified and with the visibility and ceiling below the minimum that was prescribed for the…Dec 3, 2023 · N76SB · DestroyedNTSB WPR24FA037Accident · 1 fatalClass 3 · FieldFinal reportCessna P210N · San Diego, CAA total loss of engine power due to fuel exhaustion. Contributing to the accident were the pilot’s inadequate flight and fuel planning and his decision to fly in night instrument meteorological conditions despite his lack of recent instrument flight.Nov 16, 2023 · N1400 · Substantial damageNTSB WPR24FA024Accident · 1 fatalClass 3 · FieldFinal reportCessna T206H · Orangeville, UTThe pilot's controlled flight into mountainous terrain for reasons that could not be determined.Oct 27, 2023 · N915DV · Substantial damageNTSB CEN24FA024Accident · 1 fatalClass 3 · FieldFinal reportLancair 320 · Manitowoc, WIThe pilot’s decision to continue the visual flight rules flight into instrument meteorological conditions and failure to maintain clearance from trees and terrain during an unapproved instrument approach. Contributing to the accident was the pilot’s…Oct 25, 2023 · N320P · Substantial damageNTSB GAA24WA013Accident · 1 fatalClass 5 · ForeignCessna 208 · Monêtier-Allemont, FranceOct 15, 2023 · F-HSLE · DestroyedNTSB GAA24WA009Accident · 2 fatalClass 5 · ForeignDiamond DA20 · Almeria, SpainOct 10, 2023 · CO493 · Substantial damageNTSB WPR24FA002Accident · 4 fatalClass 3 · FieldFinal reportPiper PA-28-140 · Moab, UTThe pilot’s loss of visual reference to the horizon while departing during dark night, which resulted in the pilot experiencing spatial disorientation and subsequent controlled flight into terrain.Oct 2, 2023 · N7153R · Substantial damageNTSB ERA23FA358Accident · 1 fatalClass 3 · FieldFinal reportCirrus SR20 · Toms River, NJThe pilot's failure to maintain a positive climb rate after takeoff due to spatial disorientation (somatogravic illusion), which resulted in impact with trees and terrain.Sep 3, 2023 · N420PB · DestroyedNTSB WPR23FA296Accident · 1 fatalClass 3 · FieldFinal reportCessna T206H · Yellow Pine, IDThe pilot’s decision to perform a go-around into rising mountainous terrain. Contributing to the accident was the pilot’s failure to follow published airport guidance about go-arounds, and landings and takeoffs with unfavorable winds.Jul 30, 2023 · N918KG · Substantial damageNTSB ANC23FA056Accident · 4 fatalClass 3 · FieldFinal reportBell 206-L4 · Wainwright, AKThe pilot's decision to fly at a low altitude over a large body of water toward featureless terrain, which resulted in a loss of visual clues and controlled flight into terrain.Jul 20, 2023 · N311MH · DestroyedNTSB WPR23FA257Accident · 6 fatalClass 3 · FieldFinal reportCessna 550 · Murrieta, CAThe flight crew’s decision to descend below the decision altitude of an instrument approach without having the appropriate runway visual reference(s) distinctively identified and with the visibility below the minimum that was prescribed for the approach,…Jul 8, 2023 · N819KR · DestroyedNTSB GAA23WA205Accident · 3 fatalClass 5 · ForeignPiper PA28R · GUaratuba, BrazilJul 3, 2023 · PT-JZC · Substantial damageNTSB ANC23FA045Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-32-300 · Old Harbor, AKThe pilot’s failure to maintain clearance from rising terrain. Contributing to the accident was the pilot’s delayed decision to turn away from the terrain.Jul 2, 2023 · N1132Q · Substantial damageNTSB CEN23FA270Accident · 1 fatalClass 3 · FieldFinal reportIcon A5 · Onamia, MNThe pilot’s failure to maintain clearance from the water while flying at a low altitude.Jun 30, 2023 · N239BA · DestroyedNTSB CEN23FA257Accident · 1 fatalClass 3 · FieldFinal reportAvid Magnum · Beaver Island, MIThe pilot’s failure to maintain clearance from the water while maneuvering in low visibility conditions due to smoke and haze.Jun 23, 2023 · N103DG · Substantial damageNTSB CEN23FA187Accident · 1 fatalClass 3 · FieldFinal reportCessna 172 · Chambers, NEThe pilot’s continued VFR flight into instrument meteorological conditions at night and his failure to maintain adequate altitude, which resulted in controlled flight into terrain.May 15, 2023 · N2946U · Substantial damageNTSB WPR23FA172Accident · 1 fatalClass 3 · FieldFinal reportCessna 172S · Los Angeles, CAThe pilot’s failure to maintain clearance with the hilly terrain resulting from his loss of situational awareness due to the deteriorating weather conditions as he descended to approach his destination airport.Apr 30, 2023 · N575ND · Substantial damageNTSB ERA23FA131Accident · 1 fatalClass 3 · FieldFinal reportCessna 150G · Hillsville, VAThe pilot’s continued visual flight rules flight into instrument meteorological conditions, resulting in controlled flight into terrain.Feb 27, 2023 · N2991J · Substantial damageNTSB CEN23FA084Accident · 4 fatalClass 3 · FieldFinal reportPiper PA46 · Yoakum, TXThe pilot’s spatial disorientation during a missed approach in instrument meteorological conditions, which led to an exceedance of the airplane’s critical angle of attack and a subsequent aerodynamic stall.Jan 17, 2023 · N963MA · Substantial damageNTSB ERA23FA108Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-32R-301 · Dayton, VAThe pilot’s controlled flight into terrain while descending over mountainous terrain at night.Jan 11, 2023 · N43156 · DestroyedNTSB GAA23WA055Accident · 1 fatalClass 4 · ForeignCessna 188 · Marabá Paulista, BrazilJan 6, 2023 · PT-BKX · Substantial damageNTSB GAA23WA035Accident · 1 fatalClass 5 · ForeignRotorway unk · Drummondville, CanadaNov 29, 2022 · unknown · DestroyedNTSB ENG23WA004Accident · 7 fatalClass 5 · ForeignAgusta A109 · Apricena, ItalyNov 5, 2022 · I-PIKI · DestroyedNTSB ERA23FA048Accident · 1 fatalClass 3 · FieldFinal reportBeech A36 · Harlan, KYThe pilot’s visual flight rules flight into instrument meteorological conditions during an approach to land at an airport in mountainous terrain, which resulted in controlled flight into terrain. Contributing to the accident was the pilot’s hazardous…Nov 3, 2022 · N84R · DestroyedNTSB ANC23LA002Accident · 1 fatalClass 3 · LimitedFinal reportPiper PA-32-260 · Cordova, AKThe pilot’s improper decision to continue visual flight rules flight into instrument meteorological conditions, which resulted in controlled flight into terrain.Oct 16, 2022 · N3432W · Substantial damageNTSB ERA23FA006Accident · 2 fatalClass 3 · FieldFinal reportBeech A36 · Arundel, METhe pilot’s loss of situational awareness, which resulted in an unstabilized approach, descent below published minimum altitudes, and collision with terrain.Oct 5, 2022 · N902AT · DestroyedNTSB GAA23WA001Accident · 1 fatalClass 5 · ForeignCessna 206 · Vielbrunn, GermanyOct 3, 2022 · F-HMDRNTSB ERA22FA397Accident · 1 fatalClass 3 · FieldFinal reportRotorway Jetexec · Arthur, KYThe pilot’s decision to attempt the cross-country flight in thunderstorm conditions, which resulted in controlled flight into terrain. Contributing to the accident was the pilot’s failure to obtain a weather briefing.Sep 3, 2022 · N162NH · DestroyedNTSB WPR22LA258Accident · 2 fatalClass 3 · LimitedFinal reportEvolution Revolt · Walter Springs, CAThe pilot’s failure to maintain clearance from powerlines, which resulted in a wire strike and impact with terrain.Jul 17, 2022 · N258MH · DestroyedNTSB WPR22FA255Accident · 1 fatalClass 3 · FieldFinal reportAeronca 7BCM · Lake McMurray, WAThe pilot’s decision to continue visual flight into an area of instrument meteorological conditions, which resulted in a loss of visual reference and subsequent controlled flight into terrain.Jul 16, 2022 · N2588C · DestroyedNTSB GAA22WA226Accident · 1 fatalClass 5 · ForeignCessna A188 · Puerto Lopez, ColombiaJul 15, 2022 · HK1368 · DestroyedNTSB ANC22FA053Accident · 1 fatalClass 3 · FieldFinal reportChampion 7EC · Valdez, AKThe pilot’s decision to continue visual flight rules flight into instrument meteorological conditions which resulted in loss of control and collision with terrain.Jul 12, 2022 · N4340C · DestroyedNTSB WPR22LA238Accident · 2 fatalClass 3 · LimitedFinal reportPiper PA20 · Challis, IDThe pilot's turn towards rising terrain with limited climb performance and his subsequent failure to maintain clearance from terrain that resulted in an impact with terrain.Jun 27, 2022 · N1231C · Substantial damageNTSB ENG22WA038Accident · 22 fatalClass 5 · ForeignDe Havilland DHC6 · Near Shikha, NepalMay 29, 2022 · 9N-AET · DestroyedNTSB GAA22WA200Accident · 1 fatalClass 5 · ForeignCessna TU206 · Macizo Del AuyáN-Tepui, VenezuelaMay 20, 2022 · YV1729 · DestroyedNTSB WPR22FA164Accident · 4 fatalClass 3 · FieldFinal reportDiamond Aircraft Ind DA 40 · Cedar City, UTThe pilot’s failure to maintain obstacle clearance, which resulted in controlled flight into terrain. Contributing to the accident was the pilot’s decision to operate the airplane above its maximum gross weight.Apr 24, 2022 · N321PF · DestroyedNTSB GAA22WA140Accident · 1 fatalClass 5 · ForeignCessna 208 · Gruehorn, SwitzerlandMar 30, 2022 · D-FLIC · Substantial damage