NTSB investigations, 2015

674 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 year(c.\"eventDate\") = 2015
    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 ERA15LA294Accident · No injuriesLimited investigationFinal reportCommander 114 · Reading, PAThe improper installation of the fuel supply line fitting at the fuel manifold, which resulted in the line loosening in-flight, fuel leakage, and a subsequent total loss of engine power.Aug 1, 2015 · N6566D · Substantial damageNTSB CEN15LA335Accident · No injuriesLimited investigationFinal reportAir Tractor AT 502B · Virden, ILThe pilot’s failure to establish a proper airspeed during takeoff with the airplane near its maximum gross weight and with a quartering tailwind.Aug 1, 2015 · N502LH · Substantial damageNTSB CEN15LA330Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Emmett, KSThe engine failure due to several loose, damaged cylinder stud nuts and hold-down bolts. Contributing to the accident was maintenance personnel’s failure to detect that the cylinder nuts and hold-down bolts were not properly secured during the engine’s most…Jul 31, 2015 · N963X · Substantial damageNTSB CEN15LA329Accident · 1 fatalLimited investigationFinal reportO'Dell Aeromaster · Sulphur Springs, TXA total loss of engine power for reasons that could not be determined because postimpact damage precluded a thorough examination of the airplane. Contributing to the accident was the pilot's failure to maintain control following the loss of engine power,…Jul 31, 2015 · N55J · DestroyedNTSB GAA15CA210Accident · No injuriesData collectionFinal reportExperimental Amat Built Kitfox III · Jackpot, NVThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and a collision with terrain.Jul 29, 2015 · N991RK · Substantial damageNTSB GAA15CA204Accident · Minor injuriesData collectionFinal reportAirbus AS350-B2 · Tucson, AZThe flight instructor's misperception of the helicopter's altitude in relation to the runway surface during a low altitude maneuver, resulting in ground impact.Jul 29, 2015 · N6095U · Substantial damageNTSB CEN15LA326Accident · No injuriesLimited investigationFinal reportEagle Eagle DW 1 · Hector, MNThe intermittent partial loss of engine power, which resulted in a lower-than-expected approach glidepath and impact with terrain short of the runway. The reason for the intermittent partial loss of engine power could not be determined because postaccident…Jul 29, 2015 · N8806B · Substantial damageNTSB CEN15FA328Accident · 2 fatalField investigationFinal reportSocata TBM 700 · Milwaukee, WIThe pilot's improper pitch control during the landing, which resulted in the propeller striking the runway, and his failure to maintain adequate airspeed during the subsequent go-around, which resulted in the airplane exceeding its critical angle of attack…Jul 29, 2015 · N425KJ · DestroyedNTSB WPR15FA222Accident · 1 fatalField investigationFinal reportBeech F35 · Riverside, CAThe total loss of engine power for reasons that could not be determined during postaccident examination of the airplane and engine. Also causal to the accident was the pilot's decision to attempt to reach the farthest runway and land into the wind instead of…Jul 27, 2015 · N988RH · DestroyedNTSB GAA15CA199Accident · Minor injuriesData collectionFinal reportNorton Claude C Tailwind W8 · Portales, NMThe pilot's failure to maintain adequate airspeed, which resulted in the airplane exceeding its critical angle of attack while maneuvering and a subsequent aerodynamic stall.Jul 26, 2015 · N299CB · Substantial damageNTSB GAA15CA198Accident · No injuriesData collectionFinal reportEvektor-Aerotechnik Sportstar · Eufaula, ALThe pilot's failure to maintain direction control during takeoff, and the pilot's failure to ensure that the canopy of the airplane was secured and locked prior to departure.Jul 26, 2015 · N804EV · Substantial damageNTSB WPR15LA223Accident · No injuriesLimited investigationFinal reportStinson 108 - 3 · North Las Vegas, NVThe partial loss of engine power due to a degraded cylinder exhaust valve seal, which resulted in low cylinder compression.Jul 25, 2015 · N6152M · Substantial damageNTSB GAA15CA202Accident · Minor injuriesData collectionFinal reportBell 47G · De Queen, ARThe pilot's failure to conduct helicopter performance planning, which resulted in an uncontrolled descent and impact with a truck and terrain during takeoff from an elevated platform.Jul 25, 2015 · N1420W · Substantial damageNTSB ERA15LA285Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Perkasie, PAThe pilot's failure to use the mixture control to override a throttle anomaly and reduce engine power, which resulted in excessive airspeed upon landing and a subsequent runway overrun. Contributing to the accident was the pilot’s inability to reduce the…Jul 25, 2015 · N777EX · Substantial damageNTSB ERA15LA281Accident · Minor injuriesClass 3 · LimitedFinal reportCessna A188B · Albertson, NCThe pilot’s failure to maintain clearance from wires during takeoff due to his impairment from alcohol use.Jul 25, 2015 · N731MB · Substantial damageNTSB CEN15LA318Accident · 1 fatalLimited investigationFinal reportPiper PA38 - 112 · Millbury, OHA loss of engine power due to three of the engine valve adjustment mechanisms backing out, which resulted from improper maintenance.Jul 25, 2015 · C-GTAO · Substantial damageNTSB CEN15FA315Accident · 2 fatalField investigationFinal reportSanford Zenith CH 601XL · Bristol, WIThe pilot’s failure to maintain airspeed and airplane control following a loss of engine power during cruise flight. Contributing to the accident was the installation of ignition system coils that were not engine-manufacturer replacement parts, which…Jul 25, 2015 · N9601 · Substantial damageNTSB ERA15LA287Accident · Minor injuriesLimited investigationFinal reportPiper J3C 65 · Southside, WVThe pilot’s exhaustion of the airplane’s fuel supply, which resulted in a total loss of engine power. Contributing to the outcome was the pilot’s failure to secure the engine before the forced landing.Jul 24, 2015 · N92653 · Substantial damageNTSB ANC15CA055Accident · No injuriesData collectionFinal reportChampion 7GCBC · Skweetna, AKThe pilot's improper decision to land on an unsuitable landing surface which resulted in a nose over.Jul 24, 2015 · N3085G · Substantial damageNTSB GAA15CA220Accident · No injuriesData collectionFinal reportCessna 150M · Apopka, FLFollowing a bird strike during takeoff, the pilot's decision to land without sufficient runway remaining to safely stop the airplane, which resulted in an over-run, collision with terrain, and nose over.Jul 23, 2015 · N704SB · Substantial damageNTSB GAA15CA201Accident · No injuriesData collectionFinal reportAeronca 7BCM · Warsaw, MOThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion and a collision with terrain.Jul 23, 2015 · N81686 · Substantial damageNTSB GAA15CA200Accident · No injuriesData collectionFinal reportRobinson Helicopter R-22 · Corona, CAThe flight instructor's delayed remedial action to arrest the descent rate, which resulted in a running landing, the left skid catching rough terrain, and the main rotor blades impacting the ground.Jul 23, 2015 · N520NS · Substantial damageNTSB CEN15CA324Accident · Serious injuriesData collectionFinal reportAero Commander 100 · San Antonio, TXThe pilot's improper decision to attempt flight with an unairworthy airplane and improper starting procedure that resulted in an uncontrolled takeoff without the pilot aboard. Contributing was the inoperative airplane battery/engine starter.Jul 23, 2015 · N5542M · Substantial damageNTSB ANC15CA052Accident · No injuriesData collectionFinal reportCessna 182 · Wasilla, AKThe pilot's failure to ensure adequate fuel was onboard to complete the flight, which resulted in fuel exhaustion and the subsequent loss of engine power. Contributing to the accident was the improperly calibrated fuel quantity indication system.Jul 23, 2015 · N5722B · Substantial damageNTSB ERA15FA277Accident · 1 fatalField investigationFinal reportCirrus Design SR20 · Lake Wales, FLA partial loss of engine power due to oil starvation. Contributing was the flight instructor's failure to maintain control of the airplane during an aborted emergency landing, and his delayed decision to deploy the airplane's parachute system.Jul 22, 2015 · N610DA · DestroyedNTSB CEN15FA311Accident · Serious injuriesField investigationFinal reportPiper PA-46-310P · Oshkosh, WIThe pilot's failure to perform a go-around after receiving a modified landing clearance and his failure to maintain adequate airspeed while maneuvering to land, which resulted in the airplane exceeding its critical angle of attack in a steep bank and entering…Jul 22, 2015 · N4BP · Substantial damageNTSB CEN15FA310Accident · 2 fatalField investigationFinal reportAeronca 7BCM (L-16A) · Auburn, WYThe pilot's failure to maintain airspeed while turning at low altitude, which resulted in the airplane exceeding its critical angle-of-attack and entering an aerodynamic stall.Jul 22, 2015 · N8362H · DestroyedNTSB ANC15CA053Accident · No injuriesData collectionFinal reportCessna U206F · Kasilof, AKThe pilot's selection of unsuitable terrain for takeoff, which resulted in a jammed elevator and subsequent loss of control and collision with terrain.Jul 22, 2015 · N206CL · Substantial damageNTSB WPR15LA219Accident · Minor injuriesLimited investigationFinal reportGarlick UH1H · Walla Walla, WAThe helicopter’s reduction in aerodynamic lift while operating in variable wind conditions for reasons that could not be determined because postaccident examination did not reveal any evidence of preimpact mechanical malfunctions or failures that would have…Jul 21, 2015 · N121PT · DestroyedNTSB ANC15LA056Accident · No injuriesLimited investigationFinal reportPiper PA 18-150 · Dillingham, AKThe pilot's failure to attain adequate airspeed during initial climb after takeoff, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's improper decision to continue a takeoff even though the airplane was not airborne by the…Jul 21, 2015 · N8761C · Substantial damageNTSB ANC15FA050Accident · 1 fatalField investigationFinal reportCessna U206G · Trapper Creek, AKThe pilot's failure to maintain clearance from trees while intentionally maneuvering close to the ground.Jul 20, 2015 · N734VB · DestroyedNTSB GAA15CA193Accident · Minor injuriesData collectionFinal reportLuscombe 8A · Oxford, IAThe pilot's selection of unsuitable terrain for takeoff based on the runway and density altitude conditions, which resulted in a runway excursion and impact with terrain.Jul 19, 2015 · N45508 · Substantial damageNTSB ERA15LA274Accident · No injuriesLimited investigationFinal reportCessna 172S · Linden, NJThe pilot’s delayed decision to reject the takeoff, which resulted in a runway overrun. Contributing to the accident was the pilot’s failure to properly configure the flaps for maximum takeoff performance with the airplane near its maximum gross weight.Jul 19, 2015 · N962SP · Substantial damageNTSB CEN15LA332Accident · Minor injuriesLimited investigationFinal reportAlon A2 · Holland, MIA total loss of engine power due to fuel starvation during cruise flight. Contributing to the accident was the pilot’s inadequate preflight fuel planning.Jul 19, 2015 · N5607F · Substantial damageNTSB GAA15CA192Accident · No injuriesData collectionFinal reportCessna R172K · Fairfield, NCThe pilot's failure to maintain directional control during the takeoff roll, which resulted in a runway excursion and impact with terrain.Jul 18, 2015 · N5453V · Substantial damageNTSB GAA15CA190Accident · No injuriesData collectionFinal reportPiper PA 32-300 · Greensboro, NCThe pilot's decision to continue the approach after realizing the intended parameters were not attainable, resulting in a runway over-shoot, a loss of control on the ground and the consequent collision with trees.Jul 18, 2015 · N96ML · Substantial damageNTSB GAA15CA189Accident · No injuriesData collectionFinal reportCessna 182Q · Hanksville, UTThe pilot's failure to maintain directional control during the takeoff roll, which resulted in a runway excursion and a collision with terrain.Jul 18, 2015 · N735JB · Substantial damageNTSB ERA15CA272Accident · Minor injuriesData collectionFinal reportSmith Steen Skybolt · Junction City, KYThe pilot's inaccurate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.Jul 18, 2015 · N31CS · Substantial damageNTSB CEN15FA307Accident · 4 fatalField investigationFinal reportCessna T310R · Cody, WYThe pilot's loss of airplane control following the loss of power in the left engine; the reason for the loss of power could not be determined during postaccident engine examination.Jul 18, 2015 · N72TP · DestroyedNTSB GAA15CA143Accident · No injuriesData collectionFinal reportAventura II · Fenton, MIThe failure of the student pilot to ensure that the experimental seaplane was airworthy prior to take off.Jul 17, 2015 · N1204A · Substantial damageNTSB CEN15CA373Accident · No injuriesData collectionFinal reportErcoupe 415-C · Alexandria, INThe pilot's failure to maintain/attain adequate airspeed and attitude during landing that resulted in a hard landing. Contributing was the pilot's diverted attention to air traffic and the reduction of perceptible audio cues due to noise attenuating headsets.Jul 17, 2015 · N2765H · Substantial damageNTSB GAA15CA232Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R44 II · Prairie Lea, TXThe pilot's failure to maintain rotor rpm, resulting in an uncontrolled descent and collision with trees.Jul 16, 2015 · N804DF · Substantial damageNTSB GAA15CA207Accident · No injuriesData collectionFinal reportCessna 170B · Rosamond, CAThe pilot's failure to maintain directional control during the takeoff roll, resulting in a collision with terrain.Jul 16, 2015 · N8028A · Substantial damageNTSB GAA15CA188Accident · No injuriesData collectionFinal reportChampion 7GCAA · Kingsland, TXThe pilot's failure to maintain pitch attitude which resulted in an aerodynamic stall, hard landing and a loss of directional control.Jul 15, 2015 · N8305V · Substantial damageNTSB GAA15CA184Accident · No injuriesData collectionFinal reportPiper PA 12 · Buhl, IDThe student/instructed pilot lost directional control during the landing roll, resulting in a runway excursion, and ground loop.Jul 14, 2015 · N3795M · Substantial damageNTSB CEN15LA323Accident · No injuriesLimited investigationFinal reportCessna 182B · Fults, ILThe malfunction of the flap assembly, which resulted in a restriction of aileron control. Contributing to the accident was maintenance personnel’s inadequate inspection of a corroded flap control cable.Jul 14, 2015 · N2764G · DestroyedNTSB CEN15FA305Accident · 2 fatalField investigationFinal reportPiper PA 32-300 · Brazoria, TXThe student pilot's failure to arrest the descent in a timely manner and the flight instructor's failure to safely intervene in the routine training maneuver for reasons that could not be determined based on the information available.Jul 14, 2015 · N555PK · DestroyedNTSB ANC15CA051Accident · No injuriesData collectionFinal reportCessna 140 · Homer, AKThe pilot's decision to fly at a low altitude in mountainous terrain and weather conditions conducive to downdrafts.Jul 14, 2015 · N72784 · Substantial damageNTSB ERA15LA266Accident · No injuriesLimited investigationFinal reportGrumman American Avn. AA 5 · Southbridge, MAThe pilot’s decision to abort the takeoff with insufficient runway remaining, which resulted in a runway excursion.Jul 13, 2015 · N1356R · Substantial damageNTSB CEN15LA357Accident · Minor injuriesLimited investigationFinal reportPiper PA 30 · Clifton, TXThe pilot's failure to maintain control during a precautionary landing following a total loss of power to one engine. The reason for the loss of engine power could not be determined based on available information.Jul 13, 2015 · N7768Y · Destroyed