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 WPR22FA216Accident · 1 fatalClass 3 · FieldFinal reportCessna 336 · Porterville, CAMaintenance personnel’s failure to properly secure the elevator control assembly hardware, which resulted in an in-flight disconnection of the elevator and elevator counterweight and the pilot’s inability to maintain pitch control.Jun 18, 2022 · N3835U · DestroyedNTSB WPR22FA210Accident · 1 fatalClass 3 · FieldFinal reportMooney M20K · Camarillo, CAThe pilot’s spatial disorientation and loss of airplane control after entering instrument meteorological conditions shortly after takeoff.Jun 10, 2022 · N305L · DestroyedNTSB GAA22WA204Accident · 1 fatalClass 5 · ForeignBell 412 · Timika, IndonesiaJun 8, 2022 · PK-DAR · Substantial damageNTSB WPR22FA198Accident · 1 fatalClass 3 · FieldFinal reportBeech 77 · Hemet, CAThe student pilot’s failure to maintain clearance from a cinderblock wall while performing a go-around.Jun 7, 2022 · N18244 · Substantial damageNTSB ERA22FA262Accident · 2 fatalClass 3 · FieldFinal reportEnstrom F28 · Greenville, OHAn impact with terrain for undetermined reasons.Jun 7, 2022 · N600TA · Substantial damageNTSB CEN22FA232Accident · 2 fatalClass 3 · FieldFinal reportCessna 182G · Kenedy, TXA loss of airplane control on final approach for reasons that could not be determined.Jun 6, 2022 · N2118R · DestroyedNTSB GAA22WA199Accident · 3 fatalClass 5 · ForeignBell 206 · Currais Novos, BrazilJun 5, 2022 · PP-MCJ · DestroyedNTSB WPR22FA197Accident · 1 fatalClass 3 · FieldFinal reportCessna 208B · Oceanside, CAThe right-seated pilot’s failure to correct the left-seated pilot’s mismanagement of the engine thrust, which resulted in undesired speed and thrust oscillations during the final approach and a subsequent descent into terrain.Jun 3, 2022 · N7581F · Substantial damageNTSB CEN22FA223Accident · 2 fatalClass 3 · FieldFinal reportAeronca 7AC · Bowling Green, MOThe pilots’ failure to maintain adequate airspeed while maneuvering, which resulted in an exceedance of the airplane’s critical angle of attack and an aerodynamic stall.Jun 2, 2022 · N1976E · Substantial damageNTSB CEN22FA217Accident · 1 fatalClass 3 · FieldFinal reportCessna 162 · Memphis, TNPilot incapacitation due to an acute cardiac event.May 31, 2022 · N162KG · Substantial damageNTSB CEN22FA216Accident · 1 fatalClass 3 · FieldFinal reportExpress 2000RG · Cheyenne, WYThe pilot's inability to maintain proper airspeed and his exceedance of the airplane’s critical angle of attack while managing a loss of engine power and inflight fire, which resulted in an aerodynamic stall. Contributing factors to the accident were the loss…May 30, 2022 · N44508 · DestroyedNTSB CEN22FA211Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-12 · Seagraves, TXThe pilot’s exceedance of the airplane’s critical angle of attack while maneuvering, which resulted in an aerodynamic stall/spin and loss of control.May 24, 2022 · N78466 · DestroyedNTSB CEN22FA208Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-32-260 · Broomfield, COThe pilot’s failure to abort the takeoff due to degraded engine performance. Contributing to the accident was the reduced performance of the engine, the reason for which could not be determined.May 22, 2022 · N85CT · Substantial damageNTSB GAA22WA298Accident · 5 fatalClass 5 · ForeignRobin D140 · Grenoble, FranceMay 21, 2022 · F-HJLB · Substantial damageNTSB ERA22FA233Accident · 1 fatalClass 3 · FieldFinal reportCessna 140 · Wayne, NEThe pilot’s exceedance of the airplane’s critical angle of attack on final approach while conducting traditional short takeoff and landing operations in gusting wind conditions, which resulted in an aerodynamic stall and spin from which the pilot could not…May 20, 2022 · N76075 · DestroyedNTSB GAA22WA185Accident · 1 fatalClass 5 · ForeignSikorsky S61N · Tongyeong-si, KiribatiMay 16, 2022 · HL9490NTSB ERA22FA223Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-24-250 · Athens, GAA total loss of engine power for reasons that could not be determined based on the available information.May 11, 2022 · N8007P · DestroyedNTSB CEN22FA197Accident · 1 fatalClass 3 · FieldFinal reportCessna 172 · Broomfield, COThe pilot’s failure to maintain control of the airplane for reasons that could not be determined.May 11, 2022 · N73670 · DestroyedNTSB ERA22LA220Accident · 1 fatalClass 3 · LimitedFinal reportCirrus Design SR22 · Tybee Island, GAA loss of airplane control due to pilot incapacitation, which resulted in an overflight of his destination and subsequent descent into water.May 6, 2022 · N24LA · Substantial damageNTSB ERA22FA218Accident · 2 fatalClass 3 · FieldFinal reportCessna 172 · Altha, FLThe pilot’s failure to perform a preflight weight and balance calculation and his operation of the flight at an excessive takeoff weight, resulting in an exceedance of the airplane’s critical angle of attack after liftoff and an aerodynamic stall from which…May 3, 2022 · N6413B · DestroyedNTSB GAA22WA171Accident · 4 fatalClass 5 · ForeignPiper PA28 · Sioux Lookout Ontario, CanadaApr 30, 2022 · C-GLKD · Substantial damageNTSB CEN22LA185Accident · 1 fatalClass 3 · LimitedFinal reportSuperior Culver LFA · Syracuse, KSThe pilot’s exceedance of the airplane’s critical angle of attack, which resulted in an inadvertent aerodynamic stall while returning to the airport following a partial loss of engine power for reasons that could not be determined.Apr 28, 2022 · N37888 · DestroyedNTSB GAA22WA159Accident · 1 fatalClass 5 · ForeignCessna 172 · Coonagarabran, AustraliaApr 18, 2022 · VH-REU · Substantial damageNTSB ERA22FA189Accident · 1 fatalClass 3 · FieldFinal reportSchleicher ASW-19B · Jacksonville, FLThe pilot’s improper preflight assembly of the glider’s elevator control, which resulted in a loss of control on takeoff, and the pilot’s failure to complete a positive control check before the flight, which would have identified the disconnected elevator…Apr 16, 2022 · N19KW · Substantial damageNTSB GAA22WA144Accident · 2 fatalClass 5 · ForeignBell 206 · Adaminaby, AustraliaApr 4, 2022 · VH-PRW · DestroyedNTSB CEN22LA163Accident · 2 fatalClass 3 · LimitedFinal reportKitfox 7 · Crowell, TXThe pilot's exceedance of the airplane's critical angle of attack during low-level flight, which resulted in an aerodynamic stall and loss of control at an altitude too low to recover.Mar 31, 2022 · N789RB · Substantial damageNTSB ERA22FA161Accident · 1 fatalClass 3 · FieldFinal reportCessna 172 · Dahlonega, GAThe pilot’s delay in initiating a go-around and his failure to maintain airplane control during the initial climb, which resulted in the exceedance of the airplane’s critical angle of attack and an aerodynamic stall.Mar 19, 2022 · N1410F · Substantial damageNTSB CEN22FA145Accident · 3 fatalClass 3 · FieldFinal reportPiper PA-30 · Pond Creek, OKThe pilot’s loss of control of the airplane, resulting in an in-flight breakup.Mar 17, 2022 · N8357Y · DestroyedNTSB ERA22FA149Accident · 2 fatalClass 3 · FieldFinal reportCessna 182Q · Panama City, FLThe pilot’s deviation from the final approach course during a night instrument approach with low instrument meterological conditions, which resulted in an impact with heavily wooded terrain. Contributing to the accident was the pilot’s decision to continue…Mar 9, 2022 · N182XT · DestroyedNTSB GAA22WA113Accident · 1 fatalClass 5 · ForeignCessna U206G · Norseman, AustraliaMar 3, 2022 · VH-JVR · DestroyedNTSB ERA22LA142Accident · 2 fatalClass 3 · LimitedFinal reportVans RV-12IS · Big Pine Key, FLThe pilot’s inadequate preflight and in-flight weather planning and his improper decision to continue visual flight rules flight into an area of limited visibility in moderate precipitation, which resulted in a loss of airplane control due to spatial…Feb 27, 2022 · N123RR · DestroyedNTSB GAA22WA112Accident · 14 fatalClass 5 · ForeignCessna 208B · Comoros, ComorosFeb 26, 2022 · 5H-MZANTSB WPR22FA109Accident · 1 fatalClass 3 · FieldFinal reportDistar CZ D 13/15 SUN Dancer · Boulder City, NVThe pilot’s failure to maintain clearance from powerlines while maneuvering, which resulted in a wire strike and impact with terrain. Contributing to the accident was the pilot’s impairment from alcohol consumption and his use of diphenhydramine before the…Feb 24, 2022 · N588V · DestroyedNTSB ERA22FA137Accident · 2 fatalClass 3 · FieldFinal reportBeech 35 · Hilltown Township, PAThe pilots’ exceedance of the airplane’s critical angle of attack while practicing maneuvers during an instructional flight, which resulted in an aerodynamic stall and and a loss of airplane control.Feb 24, 2022 · N6129V · DestroyedNTSB GAA22WA109Accident · 1 fatalClass 5 · ForeignPiper PA-25-235 · Leongatha, AustraliaFeb 22, 2022 · VH-SEH · DestroyedNTSB GAA22WA102Accident · 1 fatalClass 5 · ForeignCessna FA150 · Utrera, SpainFeb 16, 2022 · D-EATUNTSB ERA22FA126Accident · 1 fatalClass 3 · FieldFinal reportBeech 58 · Lexington, NCInadequate maintenance, which led to a partial loss of both right and left engine power during takeoff, and the pilot’s subsequent failure to maintain airspeed while maneuvering with one engine at low altitude. Contributing to the accident was the pilot’s…Feb 16, 2022 · N58LF · DestroyedNTSB ERA22LA120Accident · 8 fatalClass 3 · LimitedFinal reportPilatus PC-12/47E · Beaufort, NCThe pilot’s inadequate preflight planning, inadequate inflight monitoring of the airplane’s flight parameters, and his failure to regain control of the airplane following entry into an inadvertent aerodynamic stall. The pilot’s likely spatial disorientation…Feb 13, 2022 · N79NX · DestroyedNTSB GAA22WA095Accident · 2 fatalClass 5 · ForeignCessna 172 · Region de la Araucania, ChileFeb 4, 2022 · CC-AFA · DestroyedNTSB CEN22FA109Accident · 1 fatalClass 3 · FieldFinal reportChristavia MK1 · Oral, SDThe noncertificated pilot’s failure to maintain control of the airplane, which led to the airplane exceeding its critical angle-of-attack and subsequent aerodynamic stall. Contributing to the accident was the pilot’s decision to attempt a flight with no…Jan 31, 2022 · N3177F · Substantial damageNTSB CEN22FA100Accident · 2 fatalClass 3 · FieldFinal reportBell 407 · Houma, LAThe pilot’s sudden loss of consciousness for undetermined reasons during cruise flight, which resulted in a loss of control and impact with terrain.Jan 14, 2022 · N167RL · DestroyedNTSB ERA22FA096Accident · 1 fatalClass 3 · FieldFinal reportRobinson Helicopter R44 II · Cosby, TNThe pilot’s intentional, continued flight into instrument meteorological conditions in a helicopter that was not certified for instrument conditions, which resulted in a loss of helicopter control and a collision with trees and terrain.Dec 29, 2021 · N544SC · Substantial damageNTSB WPR22FA068Accident · 4 fatalClass 3 · FieldFinal reportGates Learjet 35A · El Cajon, CAThe flight crew’s decision to descend below the published MDA, cancel their IFR clearance to conduct an unauthorized circle-to-land approach to another runway while the airport was in nighttime IFR conditions, and the exceedance of the airplane’s critical…Dec 28, 2021 · N880Z · DestroyedNTSB ERA22FA095Accident · 2 fatalClass 3 · FieldFinal reportMooney M20J · Jacksonville, FLThe pilot’s failure to maintain airspeed during initial climb, which resulted in an aerodynamic stall/spin. Contributing was the pilot’s likely distraction due to the opening of the baggage door.Dec 26, 2021 · N3707H · Substantial damageNTSB CEN22FA082Accident · 2 fatalClass 3 · FieldFinal reportCessna 172 · Hardy, ARThe non-instrument rated pilot’s decision to continue visual flight into an area of instrument meteorological conditions, which resulted in a loss of control due to spatial disorientation. Contributing to the accident was a loss of engine power due to fuel…Dec 26, 2021 · N5798T · DestroyedNTSB GAA22WA056Accident · 1 fatalClass 5 · ForeignAmateur Built D11 · South Mackay, AustraliaDec 24, 2021 · VH-WBL · Substantial damageNTSB GAA22WA052Accident · 1 fatalClass 5 · ForeignPiper 25-260 · Vereda Aparco, Ibague, ColombiaDec 18, 2021 · HK1405 · Substantial damageNTSB CEN22FA080Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-32R-300 · Bloomington, INThe pilot’s failure to follow the instrument landing system (ILS) course guidance, which resulted in the pilot’s loss of airplane control during the instrument approach. Contributing to the accident was the presence of turbulence and low-level wind shear.Dec 18, 2021 · N5677V · DestroyedNTSB GAA22WA050Accident · 9 fatalClass 5 · ForeignGulfstream GIV · Santo Domingo, Dominican RepublicDec 15, 2021 · HI-1050 · DestroyedNTSB CEN22FA073Accident · 1 fatalClass 3 · FieldFinal reportBell Helicopter Textron Canada 407 · LaPlace, LAThe pilot’s failure to maintain clearance from power lines. Contributing to the accident was the pilot’s decision to fly in instrument conditions.Dec 14, 2021 · N150AS · Destroyed