Fatal NTSB investigations

2,679 cases where the sequence of events included Collision with terr/obj (non-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\" = '470' 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 ERA24FA262Accident · 1 fatalClass 3 · FieldPreliminary reportPiper PA31 · Loudonville, NYOn June 17, 2024, at 0816 eastern daylight time, a Piper PA-31-310, Canadian registration C-GKSI, was destroyed when it was involved in an accident in Loudonville, New York. The airline transport pilot was fatally injured and one person on the ground…Jun 17, 2024 · C-GKSI · DestroyedNTSB CEN24FA228Accident · 2 fatalClass 3 · FieldFinal reportCessna 421 · Steamboat Springs, COThe pilot’s failure to maintain sufficient airspeed following a loss of engine power, which resulted in an inadvertent aerodynamic stall/spin at low altitude.Jun 17, 2024 · N245T · DestroyedNTSB ERA24FA261Accident · 2 fatalClass 3 · FieldFinal reportPiper PA28 · Siler City, NCThe flight instructor’s failure to maintain airplane control during a low-speed, low-altitude left turn after encountering an undetermined issue during takeoff, which resulted in an aerodynamic stall at an altitude too low for recovery.Jun 14, 2024 · N515DH · DestroyedNTSB CEN24FA220Accident · 1 fatalClass 3 · FieldFinal reportAir Tractor AT-602 · Broseley, MOThe pilot’s inflight loss of airplane control for reasons that could not be determined.Jun 14, 2024 · N115AA · DestroyedNTSB CEN24FA218Accident · 1 fatalClass 3 · FieldFinal reportCessna 172 · Gainesville, TXThe fuel pump manufacturer’s improper torquing of screws on the engine-driven fuel pump, which resulted in a disruption in the fuel system and a loss of engine power on initial climb.Jun 12, 2024 · N656MA · Substantial damageNTSB GAA24WA185Accident · 1 fatalClass 4 · ForeignCessna 206 · Haines Junction, CanadaJun 10, 2024 · C-GRSA · Substantial damageNTSB WPR24FA184Accident · 1 fatalClass 3 · FieldFinal reportBeech A45 · Deer Harbor, WAThe pilot’s decision to perform an aerobatic maneuver at low level, and his misjudged entry altitude for the maneuver, which resulted in impact with water.Jun 7, 2024 · N268AF · Substantial damageNTSB WPR24FA182Accident · 1 fatalClass 3 · FieldFinal reportVans RV-12 · Auburn, WAThe pilot’s improper installation of the control stick pushrod assemblies, which resulted in separation of the left pushrod and a total loss of roll control during flight. Contributing to the accident was the failure to detect the installation error during…Jun 6, 2024 · N412JN · Substantial damageNTSB GAA24WA214Accident · 2 fatalClass 5 · ForeignBeech 55 · Santa Catarina, BrazilJun 3, 2024 · PS-BDW · DestroyedNTSB ERA24LA227Accident · 1 fatalClass 3 · LimitedFinal reportBrallier Scott Glasair I · Gulf of Mexico, FLThe non-instrument-rated pilot’s loss of airplane control due to spatial disorientation while flying over water in dark night conditions. Contributing to the accident was the pilot’s decision to conduct the overwater flight in conditions conducive to the…May 26, 2024 · N446KW · DestroyedNTSB ERA24FA221Accident · 1 fatalClass 3 · FieldFinal reportRadley Vincent Quicksilver Sport 2S · Cleveland, GAThe pilot’s failure to maintain control of the airplane during the takeoff and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall and spin at low altitude. Contributing to the accident was the pilot’s lack of…May 20, 2024 · N960B · Substantial damageNTSB CEN24FA188Accident · 1 fatalClass 3 · FieldFinal reportCessna 150L · Godley, TXThe student pilot’s failure to maintain airplane control while practicing a power-on stall, which resulted in an inadvertent spin at an altitude from which he was unable to recover.May 16, 2024 · N1701Q · DestroyedNTSB CEN24FA179Accident · 2 fatalClass 3 · FieldFinal reportPiper PA46-500TP · Marianna, ARThe pilot’s exceedance of the airplane’s design limitations, which resulted in an in-flight breakup.May 13, 2024 · N241PM · Substantial damageNTSB GAA24WA162Accident · 3 fatalClass 5 · ForeignCessna 406 · Windhoek City, NamibiaMay 3, 2024 · V5-ASB · DestroyedNTSB ERA24FA206Accident · 1 fatalClass 3 · FieldFinal reportRaytheon A36 · Augusta, GAThe pilot’s excessive turn rate and bank angle while at low airspeed and altitude, resulting in an accelerated aerodynamic stall, loss of airplane control, and collision with terrain.May 2, 2024 · N629BE · DestroyedNTSB ERA24LA185Accident · 1 fatalClass 3 · LimitedFinal reportBailey-Moyes Dragonfly · Groveland, FLThe pilot’s improper installation and inspection of the right lower wing strut attachment bolt, which resulted in the inflight failure of the right wing.Apr 19, 2024 · UNREG · Substantial damageNTSB WPR24FA124Accident · 1 fatalClass 3 · FieldFinal reportGulfstream 695A · San Bernardino, CAThe pilot’s continued use of the airplane’s autopilot after flight into moderate to severe icing conditions, which resulted in an exceedance of the airplane’s critical angle of attack and an aerodynamic stall.Apr 14, 2024 · N965BC · DestroyedNTSB GAA24WA145Accident · 3 fatalClass 5 · ForeignBell 206 · Meico City, MexicoApr 14, 2024 · XP-PIP · DestroyedNTSB ERA24FA160Accident · 1 fatalClass 3 · FieldFinal reportArthur B Canning Merlin Lite · Mulberry, FLThe pilot/builder’s modifications of the motorglider’s engine, which resulted in an excessively lean fuel air mixture, preignition, piston failure, and a subsequent total loss of engine power during the initial climb. Contributing to the outcome was the…Apr 2, 2024 · N622PC · Substantial damageNTSB CEN24LA144Accident · 1 fatalClass 3 · LimitedFinal reportPiper PA28 · Muncie, INThe pilot’s spatial disorientation and subsequent loss of control while maneuvering outside established instrument approach procedures in instrument meteorological conditions, which resulted in an impact with terrain. Contributing to the accident was the…Apr 1, 2024 · N8438B · DestroyedNTSB WPR24FA119Accident · 2 fatalClass 3 · FieldPreliminary reportDaher TBM700 · Truckee, CAOn March 30, 2024, at 1837 Pacific daylight time, a Daher TBM 700 (960), N960LP, was substantially damaged when it was involved in an accident in Truckee, California. The pilot and passenger were fatally injured. The airplane was operated as a Title 14 Code…Mar 31, 2024 · N960LP · DestroyedNTSB WPR24FA112Accident · 1 fatalClass 3 · FieldFinal reportHolmes William B AIR Creation Twin · Gila Bend, AZThe pilot’s loss of control and subsequent collision with a mesquite tree on approach to land.Mar 17, 2024 · N4425L · Substantial damageNTSB ERA24FA127Accident · 5 fatalClass 3 · FieldFinal reportPiper PA32RT · Nashville, TNThe pilot’s failure to ensure the proper placement of the fuel selector during the approach and landing, which resulted in fuel starvation and a subsequent total loss of engine power.Mar 5, 2024 · C-FBWH · Substantial damageNTSB GAA24WA110Accident · 1 fatalClass 5 · ForeignZenith CH-801 · Bunberry, AustraliaMar 4, 2024 · VH-8OI · Substantial damageNTSB CEN24FA125Accident · 2 fatalClass 3 · FieldFinal reportGlobe GC-1B · Afton, MNThe pilot’s failure to maintain airplane control while maneuvering, which resulted in an aerodynamic stall and spin.Mar 2, 2024 · N2387B · DestroyedNTSB CEN24MA111Accident · 6 fatalClass 2 · MajorFinal reportAirbus Helicopters EC 130 · Halloran Springs, CAThe pilot’s decision to continue the visual flight rules flight into instrument meteorological conditions, which resulted in the pilot’s spatial disorientation and loss of control. Contributing to the accident was the company’s inadequate oversight of its…Feb 10, 2024 · N130CZ · DestroyedNTSB ERA24FA104Accident · 3 fatalClass 3 · FieldFinal reportBeech V35 · Clearwater, FLAn in-flight engine compartment fire due to a partially loose flexible fuel hose b-nut at the fuel metering unit. Contributing to the severity of the accident was the pilot’s inability to visually identify the destination airport at night, which prolonged the…Feb 2, 2024 · N6659L · DestroyedNTSB ERA24FA103Accident · 1 fatalClass 3 · FieldFinal reportGrumman American Avn. GA-7 · Coatesville, PAThe pilot’s inadequate preflight inspection, which resulted in a loss of engine power due to water-contaminated fuel, and his subsequent loss of control. Contributing to the accident was an inadequate annual maintenance inspection, during which maintenance…Feb 1, 2024 · N887CC · Substantial damageNTSB ERA24FA102Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-24 · Eufaula, ALA total loss of engine power due to fuel starvation as a result of the pilot’s inadequate fuel planning/management.Jan 31, 2024 · N5520P · Substantial damageNTSB CEN24FA094Accident · 3 fatalClass 3 · FieldFinal reportBell 206 · Hydro, OKThe helicopter’s inflight collision with cackling geese, resulting in an inflight breakup.Jan 21, 2024 · N295AE · DestroyedNTSB WPR24FA073Accident · 4 fatalClass 3 · FieldFinal reportOstroth Thane L Cozy MK IV · Half Moon Bay, CAThe airplane’s impact with the ocean for undetermined reasons after departing into night, instrument meteorological conditions.Jan 15, 2024 · N656TE · DestroyedNTSB ERA24FA088Accident · 3 fatalClass 3 · FieldFinal reportBeech 95-B55 (T42A) · Leyden, MAThe flight instructor’s failure to maintain airplane control during a stall, which resulted in an inadvertent spin from which the airplane was not recovered. Contributing to the accident were the overall effect of the flight instructor’s use of multiple…Jan 14, 2024 · N7345R · Substantial damageNTSB ERA24FA077Accident · 1 fatalClass 3 · FieldFinal reportZenith Stol CH701 · Marienville, PAThe pilot’s decision to continue visual flight into deteriorating visibility conditions at night, which resulted in spatial disorientation and subsequent descent that continued to ground contact.Dec 30, 2023 · N4209W · DestroyedNTSB ERA24FA075Accident · 1 fatalClass 3 · FieldFinal reportHughes Helicopters 369E · Miami, FLMain rotor contact with the tail boom for unknown reasons, resulting in the separation of the tail boom.Dec 27, 2023 · N757TB · Substantial damageNTSB ERA24FA072Accident · 1 fatalClass 3 · FieldFinal reportHawker Beechcraft G36 · Buford, GAA loss of engine power for reasons that could not be determined due to significant thermal damage from postimpact fire.Dec 21, 2023 · N23VS · DestroyedNTSB WPR24FA057Accident · 3 fatalClass 3 · FieldFinal reportCessna 172G · Independence, ORThe pilot’s decision to continue flight under visual flight rules into instrument meteorological conditions, which resulted in collision with an obstacle while landing.Dec 17, 2023 · N3992L · DestroyedNTSB WPR24FA053Accident · 1 fatalClass 3 · FieldFinal reportBeauchamp Norm Kitfox · Eloy, AZThe separation of a propeller blade during the initial climb due to insufficient blade retention forces. Contributing to the accident was the propeller blade retention design, manufacturing defects that prevented the propeller from achieving adequate grip…Dec 8, 2023 · N66180 · DestroyedNTSB ERA24FA058Accident · 2 fatalClass 3 · FieldFinal reportBeech 35-C33 · Pulaski, TNThe pilot’s failure to maintain airplane control, which resulted in pilot-induced oscillations and a subsequent loss of control and impact with terrain.Dec 7, 2023 · N5891J · DestroyedNTSB ERA24FA055Accident · 2 fatalClass 3 · FieldFinal reportBeech E95 · Elkmont, ALThe flight instructor’s failure to maintain control of the airplane during slow flight, which resulted in an aerodynamic stall and spin from which he was unable to recover.Dec 4, 2023 · N369BB · Substantial damageNTSB GAA24WA068Accident · 4 fatalClass 5 · ForeignCessna 210 · Guayaibi, ParaguayDec 2, 2023 · ZP-BDN · DestroyedNTSB ERA24FA050Accident · 1 fatalClass 3 · FieldFinal reportPiper PA32R · Attalla, ALThe undetected wear of both pawl retaining rivets of the left magneto impulse coupling and fatigue failure of one pawl retaining rivet, which led to cascading fractures of the second pawl retaining rivet, left gear retainer assembly, and gear teeth of…Nov 27, 2023 · N4187Q · DestroyedNTSB GAA24WA044Accident · 1 fatalClass 4 · ForeignRobinson R66 · Ramallo, ArgentinaNov 26, 2023 · LV-FQJ · Substantial damageNTSB CEN24FA046Accident · 2 fatalClass 3 · FieldFinal reportSocata TBM 700 · Ludington, MIThe pilot’s decision to take off with ice/snow contamination on the airplane’s wings, which resulted in an aerodynamic stall and impact with terrain.Nov 26, 2023 · N850JH · DestroyedNTSB ERA24FA038Accident · 2 fatalClass 3 · FieldFinal reportXtremeair XA42 · Union City, TNThe pilot receiving instruction’s loss of airplane control while performing aerobatics, which resulted in a stall/spin at an altitude too low for recovery. Contributing to the accident was the flight instructor’s inadequate supervision.Nov 15, 2023 · N42XM · Substantial damageNTSB WPR24FA035Accident · 2 fatalClass 3 · FieldFinal reportCessna 172G · Provo, UTThe pilot's exceedance of the airplane's critical angle of attack during a chandelle maneuver, which resulted in an aerodynamic stall and descent into trees and terrain. Contributing to the accident was the pilot’s decision to maneuver into a canyon and…Nov 14, 2023 · N3971L · Substantial damageNTSB ERA24FA036Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-28-180 · Micanopy, FLThe non-instrument-rated pilot’s improper inflight decision making and his flight into instrument meteorological conditions, which resulted in spatial disorientation and subsequent loss of airplane control. Contributing to the accident were the pilot’s…Nov 14, 2023 · N7806W · DestroyedNTSB GAA24WA024Accident · 4 fatalClass 3 · ForeignRobinson R44 · Cirque de Salazie, RéunionOct 31, 2023 · F-HLOU · DestroyedNTSB ERA24FA026Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-32-300 · Marion, OHA descent and impact with terrain for undetermined reasons.Oct 31, 2023 · N44601 · DestroyedNTSB CEN24FA021Accident · 1 fatalClass 3 · FieldFinal reportAir Tractor AT-502B · Vidalia, LAThe pilot’s failure to maintain clearance from power lines during an aerial application flight. Contributing to the accident was the pilot’s cell phone use and the position of the sun, which reduced the pilot’s ability to perceive the location of the power…Oct 24, 2023 · N5180W · Substantial damageNTSB CEN24LA020Accident · 1 fatalClass 3 · LimitedFinal reportPiper PA 46-350P · Pierre, SDThe total loss of engine power due to fuel starvation as a result of the pilot’s improper configuration of the automatic fuel transfer system. Contributing to the accident was the pilot’s failure to adequately monitor the header tank’s fuel quantity.Oct 23, 2023 · N92884 · Substantial damage