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 GAA24WA020Accident · 1 fatalClass 5 · ForeignBeech C23 · Pretoria, South AfricaOct 21, 2023 · ZK-JKE · Substantial damageNTSB GAA24WA011Accident · 2 fatalClass 5 · ForeignCessna 208 · Pacencia-Yacma, BelizeOct 16, 2023 · V3-HIN · DestroyedNTSB GAA24WA124Accident · 4 fatalClass 5 · ForeignRobin DR400-180 · Propriano, FranceOct 12, 2023 · F-GIKS · DestroyedNTSB CEN24FA010Accident · 2 fatalClass 3 · FieldFinal reportCessna 414 · Patterson, LAThe pilot’s failure to properly set the elevator trim before takeoff, which resulted in an exceedance of the airplane’s critical angle of attack and an aerodynamic stall during takeoff.Oct 12, 2023 · N880A · DestroyedNTSB GAA24WA015Accident · 2 fatalClass 5 · ForeignCessna 172N · Merriton, AustraliaOct 8, 2023 · VH-RSBNTSB ERA24FA003Accident · 1 fatalClass 3 · FieldFinal reportBell Helicopter Textron Canada 407 · Croydon, NHThe pilot’s loss of control during the initial climb in dark night conditions due to spatial disorientation, which resulted in a steep banking descent into trees and terrain. Contributing to the accident was the pilot’s lack of recent night flight experience,…Oct 8, 2023 · N802JR · Substantial damageNTSB ERA24FA001Accident · 2 fatalClass 3 · FieldFinal reportCessna 177RG · Lake Placid, NYA partial loss of engine power for undetermined reasons. Contributing to the accident was the pilot’s inadequate preflight weight and balance planning and his aggressive low altitude maneuvering, which resulted in an aerodynamic stall and loss of control.Oct 1, 2023 · N545PZ · Substantial damageNTSB ERA23FA384Accident · 1 fatalClass 3 · FieldFinal reportCessna 150K · Gilford, NHThe pilot’s loss of control during visual flight rules flight in night instrument meteorological conditions due to spatial disorientation. Contributing to the accident was the pilot’s motivation to depart on the flight despite being made aware that conditions…Sep 30, 2023 · N6312G · Substantial damageNTSB ERA23FA382Accident · 1 fatalClass 3 · FieldFinal reportSmith William S Smith Cozy Mark IV · Cullman, ALThe pilot’s exceedance of the airplane’s critical angle of attack while maneuvering at low altitude, which resulted in an aerodynamic stall and subsequent loss of control. Contributing to the accident was the pilot/owner’s improper installation of engine…Sep 29, 2023 · N95SF · Substantial damageNTSB CEN23LA423Accident · 1 fatalClass 3 · LimitedFinal reportBeech A36 · Broken Bow, OKThe pilot’s failure to maintain the runway centerline during landing and subsequent failure to maintain clearance from the airport grounds worker during the landing roll. Contributing to the accident was the absence of a NOTAM for mowing operations at the…Sep 29, 2023 · N9379Q · Substantial damageNTSB ERA23FA370Accident · 1 fatalClass 3 · FieldFinal reportErcoupe 415 · Fitzgerald, GAThe pilot’s failure to perform pre-takeoff engine runup and carburetor heat check procedures, which resulted in rotation with inadequate climb performance, and his subsequent failure to maintain adequate airspeed and exceedance of the airplane’s critical…Sep 13, 2023 · N2796H · Substantial damageNTSB ANC23FA074Accident · 1 fatalClass 2 · FieldFinal reportPiper PA-18-150 · St. Mary's, AKThe pilot’s decision to operate the airplane above its maximum certificated gross weight, and his installation of an unapproved external load that degraded takeoff performance and flight characteristics resulting in a loss of airplane control during takeoff…Sep 13, 2023 · N109T · Substantial damageNTSB GAA23WA255Accident · 1 fatalClass 5 · ForeignRobinson R44 · Vologda Oblast, RussiaSep 10, 2023 · RA-05823 · Substantial damageNTSB CEN23FA410Accident · 1 fatalClass 3 · FieldFinal reportSonex Sonex · Dowagiac, MIThe total loss of engine power due to the failure of the ignition distributor rotor.Sep 10, 2023 · N569SX · Substantial damageNTSB ERA23FA352Accident · 2 fatalClass 3 · FieldFinal reportEurocopter EC135 · Pompano Beach, FLAn inflight fire outside of the engine firewalls, likely from overheating of the No. 1 engine for undetermined reasons, which resulted in a partial tailboom separation.Aug 28, 2023 · N109BC · DestroyedNTSB WPR23FA323Accident · 1 fatalClass 3 · FieldFinal reportHensler Howard Cassutt · West Jordan, UTA loss of control during the initial climb for reasons that could not be determined.Aug 23, 2023 · N6291N · Substantial damageNTSB ERA23FA346Accident · 2 fatalClass 3 · FieldFinal reportBeech C-99 · Litchfield, MEA horizontal stabilizer pitch trim anomaly that was not identified in the available evidence.Aug 22, 2023 · N55RP · DestroyedNTSB ERA23LA342Accident · 2 fatalClass 3 · LimitedFinal reportBeech C23 · Greer, SCA partial loss of engine power during the initial climb due to the formation of carburetor ice, resulting in reduced climb capability. Contributing to the accident was the pilot’s failure to maintain proper airspeed during the emergency descent, which…Aug 20, 2023 · N9360S · Substantial damageNTSB CEN23FA359Accident · 1 fatalClass 3 · FieldFinal reportVans RV14 · Virden, ILThe pilot/builder’s improper configuration of the canopy latch micro switch, which incorrectly signaled a closed canopy before flight that resulted in an inflight opening of the airplane’s canopy, an upset of the airplane, and a loss of control from which the…Aug 12, 2023 · N6161 · Substantial damageNTSB ERA23FA330Accident · 1 fatalClass 3 · FieldFinal reportCessna P210 · Junction City, GAThe pilot’s continued flight into a known area of adverse weather, which resulted in the penetration of a severe thunderstorm, the pilot’s loss of airplane control, and the airplane’s subsequent in-flight breakup.Aug 10, 2023 · N210JT · DestroyedNTSB CEN23FA352Accident · 1 fatalClass 3 · FieldFinal reportCessna 150 · Caddo Mills, TXThe pilot’s loss of airplane control during an attempted forced landing following a loss of engine power.Aug 7, 2023 · N5610E · DestroyedNTSB WPR23LA305Accident · 1 fatalClass 3 · LimitedFinal reportGrumman Acft ENG Cor-Schweizer G-164A · Davis, CAAn inflight loss of control during a low altitude operation for undetermined reasons.Aug 6, 2023 · N5450 · Substantial damageNTSB WPR23FA301Accident · 1 fatalClass 3 · FieldFinal reportGlasair Glastar · Idaho City, IDThe pilot’s loss of airplane control during takeoff for reasons that could not be determined.Aug 4, 2023 · N617G · Substantial damageNTSB ERA23LA328Accident · 2 fatalClass 3 · LimitedFinal reportCessna 172 · Charlotte Amalie, CBThe pilots’ loss of airplane control due to spatial disorientation. Contributing to the accident was both pilots’ lack of experience in operating in actual instrument meteorological conditions.Aug 4, 2023 · N13384 · DestroyedNTSB ERA23FA323Accident · 2 fatalClass 3 · FieldFinal reportCessna 172 · Pembroke Pines, FLThe flight instructor’s exceedance of the airplane’s critical angle of attack during the initial climb, which resulted in an aerodynamic stall and subsequent rapid descent into terrain.Aug 4, 2023 · N697FL · Substantial damageNTSB ERA23FA321Accident · 1 fatalClass 3 · FieldFinal reportKolb Firestar · McAlpin, FLA collision with trees during takeoff for reasons that could not be determined based on available information.Aug 3, 2023 · Unreg · Substantial damageNTSB ERA23LA320Accident · 1 fatalClass 3 · LimitedFinal reportMesnard Velocity Twin · Sandersville, GAA total loss of power in the right engine due to the right ECU injector wires being severed by the main landing gear actuator piston teeter bar as a result of a lack of clearance and protection of the wiring bundle.Aug 1, 2023 · N106VT · Substantial damageNTSB CEN23FA340Accident · 1 fatalClass 3 · FieldFinal reportRichards Heavylift Helo UH-1H · Oakdale, ILAn in-flight loss of control for undetermined reasons.Jul 31, 2023 · N567VF · Substantial damageNTSB GAA23WA223Accident · 3 fatalClass 5 · ForeignCessna 650 · Veracruz, MexicoJul 28, 2023 · XB-VFJ · DestroyedNTSB ERA23FA313Accident · 1 fatalClass 3 · FieldFinal reportPiper PA28R · Churchville, MDThe pilot’s exceedance of the airplane’s critical angle of attack during initial climb, which resulted in an aerodynamic stall/spin and loss of control that the pilot did not recover from.Jul 25, 2023 · N34PT · Substantial damageNTSB CEN23LA324Accident · 1 fatalClass 3 · LimitedFinal reportAir Tractor AT-402B · Clara City, MNThe pilot’s failure to maintain clearance from a transmission line during an aerial application flight.Jul 25, 2023 · N291DL · Substantial damageNTSB WPR23FA275Accident · 1 fatalClass 3 · FieldFinal reportCessna T310R · Santa Fe, NMA total loss of left engine power as a result of improper installation of the aft-facing crankshaft counterweight retaining rings. Also causal was the pilot’s failure to maintain adequate airspeed following the loss of left engine power, which resulted in the…Jul 18, 2023 · N5251C · Substantial damageNTSB GAA23WA215Accident · 4 fatalClass 5 · ForeignRobinson R44 · Swakopmund, NamibiaJul 17, 2023 · ZS-HLG · DestroyedNTSB CEN23FA304Accident · 2 fatalClass 3 · FieldFinal reportPiper PA28 · Osage Beach, MOThe pilot’s failure to properly set the stabilator trim before takeoff, which resulted in an exceedance of the airplane’s critical angle of attack and an aerodynamic stall during takeoff.Jul 13, 2023 · N8225N · Substantial damageNTSB WPR23FA258Accident · 1 fatalClass 3 · FieldFinal reportCessna 172N · San Rafael, CAThe total loss of engine power due to carburetor icing as a result of the pilot’s failure to activate the carburetor heat in a timely manner during the descent.Jul 9, 2023 · N4922G · Substantial damageNTSB CEN23FA283Accident · 2 fatalClass 3 · FieldFinal reportBeech A36 · Rayville, LAThe pilot’s visual flight rules flight into instrument meteorological conditions, which resulted in a loss of control during the approach to the destination airport and subsequent impact with terrain.Jul 7, 2023 · N15RP · DestroyedNTSB CEN23FA285Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-60-601P · Burlington, COThe pilot’s visual flight rules flight into instrument meteorological conditions, which resulted in a loss of control in flight and subsequent impact with terrain.Jul 6, 2023 · N100PB · DestroyedNTSB GAA23WA193Accident · 1 fatalClass 5 · ForeignBell 47 · Sainte-Marthe, FranceJul 4, 2023 · F-GKTR · DestroyedNTSB ERA23FA280Accident · 5 fatalClass 3 · FieldFinal reportPiper PA-32R-300 · North Myrtle Beach, SCThe pilot’s loss of control during initial climb, which resulted in an aerodynamic stall and impact with terrain. Contributing to the accident was the pilot’s operation of the airplane above its maximum gross weight and near its aft center of gravity limit,…Jul 2, 2023 · N5524F · DestroyedNTSB WPR23FA244Accident · 1 fatalClass 3 · FieldFinal reportCurtiss Wright P-40E · Hamilton, MTA loss of engine power for undetermined reasons.Jun 27, 2023 · N4420K · Substantial damageNTSB GAA23WA180Accident · 1 fatalClass 5 · ForeignRobinson R22 · Buchanan, AustraliaJun 27, 2023 · vh-PSDC · Substantial damageNTSB GAA23WA274Accident · 1 fatalClass 5 · ForeignDB 6R · Ombersley Court, Worcestershire, United KingdomJun 25, 2023 · G-CMFS · Substantial damageNTSB ERA23FA273Accident · 1 fatalClass 3 · FieldFinal reportMooney M20R · Southport, NCThe pilot’s improper decision to fly a known unairworthy airplane, which resulted in a total loss of engine power due to oil starvation.Jun 25, 2023 · N13LV · DestroyedNTSB GAA23WA183Accident · 1 fatalClass 5 · ForeignAir Tractor AT802 · Ngodwana, South AfricaJun 21, 2023 · ZS-TFH · Substantial damageNTSB ERA23FA270Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-30 · Ebensburg, PAThe pilot’s spatial disorientation and subsequent loss of airplane control, which resulted in an uncontrolled descent and collision with terrain.Jun 17, 2023 · N7628Y · DestroyedNTSB CEN23FA239Accident · 2 fatalClass 3 · FieldFinal reportMooney M20R · Watertown, WIThe pilot’s loss of control due to spatial disorientation while operating in instrument meteorological conditions. Contributing to the accident was the pilot’s impairment from the prohibited substance; however, the extent of impairment could not be determined.Jun 14, 2023 · N1025C · DestroyedNTSB ERA23FA266Accident · 1 fatalClass 3 · FieldFinal reportWonder Michael S Harmon Rocket · Porter, NYThe pilot’s failure to maintain control of the airplane while initiating a low-altitude aerobatic maneuver, which resulted in impact with trees and terrain. Contributing to the accident was the pilot’s high-risk behavior.Jun 11, 2023 · N85TP · Substantial damageNTSB ERA23FA265Accident · 1 fatalClass 3 · FieldFinal reportBeech B35 · Orangeburg, SCA stuck No. 3 cylinder intake valve, which resulted in a partial loss of engine power and subsequent forced landing.Jun 10, 2023 · N8725A · DestroyedNTSB ERA23FA260Accident · 2 fatalClass 3 · FieldFinal reportVans RV6 · Colonial Beach, VAThe pilot’s failure to maintain adequate airspeed while maneuvering at low altitude, which resulted in an exceedance of the airplane’s critical angle of attack and a subsequent aerodynamic stall.Jun 7, 2023 · N835BC · DestroyedNTSB ERA23FA258Accident · 2 fatalClass 3 · FieldFinal reportCirrus SR22 · Jamestown, NYThe pilots’ failure to maintain airplane control following an anomalous engine indication during the initial climb, which resulted in a loss of control and parachute deployment at an altitude too low for the system to operate effectively. Contributing to the…Jun 6, 2023 · C-GNMT · Destroyed