NTSB investigations, NV

163 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.\"eventStateOrRegion\" = 'NV' AND c.\"eventCountry\" = 'USA'
    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 WPR18FA091Accident · 1 fatalField investigationFinal reportPiper PA34 · Minden, NVThe pilot's loss of airplane control due to spatial disorientation while maneuvering in instrument meteorological conditions. Contributing to the accident was the pilot's impairment from the use of a sedating antihistamine.Feb 19, 2018 · N14GQ · DestroyedNTSB GAA18CA123Accident · No injuriesData collectionFinal reportOliver Lawrence R Kitfox IV 1200 · Carson City, NVThe flight instructor’s failure to maintain directional control during the landing roll and lateral control during the go-around in gusting crosswind conditions. Contributing to the accident was the lack of communication between the flight instructor and the…Feb 11, 2018 · N76478 · Substantial damageNTSB GAA18CA132Accident · No injuriesData collectionFinal reportCubcrafters CC11-160 · Carson City, NVThe pilot’s failure to maintain directional control during the landing roll in gusting crosswind conditions.Feb 10, 2018 · N88ZQ · Substantial damageNTSB WPR18LA070Accident · No injuriesLimited investigationFinal reportPiper PA 32-300 · Reno, NVA total loss of engine power due to fuel starvation. Contributing to the accident was the failure of the pilot/owner to ensure that the airplane was airworthy before flight.Jan 17, 2018 · N4027W · Substantial damageNTSB WPR18FA073Accident · 1 fatalField investigationFinal reportPiper PA 23-250 · Elko, NVThe pilot's inadequate preflight weather planning, which resulted in the flight over mountainous terrain into forecast instrument meteorological conditions, icing, and mountain wave, and resulted in an uncontrolled descent and collision with terrain.Jan 12, 2018 · N54857 · DestroyedNTSB WPR18LA023Accident · Minor injuriesClass 3 · LimitedFinal reportBeech B95 · Las Vegas, NVThe flight instructor’s inadequate preflight fuel planning, which resulted in fuel exhaustion, a total loss of power to both engines, and a subsequent forced landing.Nov 3, 2017 · N9628R · Substantial damageNTSB WPR18LA002Accident · No injuriesLimited investigationFinal reportCessna 172S · Tonopah, NVThe pilot's failure to enrich the mixture during the descent, as required by the Pilot's Operating Handbook (POH), and his subsequent failure to follow the POH emergency procedures, which resulted in an excessively lean fuel/air mixture and subsequent loss of…Oct 2, 2017 · N5311H · Substantial damageNTSB GAA17CA495Accident · No injuriesData collectionFinal reportBell 206 · Minden, NVThe pilot’s failure to maintain helicopter control during landing due to a loss of tail rotor effectiveness.Aug 20, 2017 · N6259C · Substantial damageNTSB GAA17CA493Accident · No injuriesData collectionFinal reportBoyd Bruce RV4 · Yerington, NVThe pilot's improper landing flare, which resulted in a bounded landing and subsequent loss of directional control.Aug 17, 2017 · N687BP · Substantial damageNTSB WPR17LA177Accident · No injuriesLimited investigationFinal reportAir Tractor AT 802A · Wells, NVThe pilot's failure to maintain directional control during a period of thermal activity, which led to a runway excursion and impact with terrain.Jul 31, 2017 · N70LA · Substantial damageNTSB WPR17LA163Accident · Minor injuriesClass 3 · LimitedFinal reportBritish BAC Stkmstr MK80 · Henderson, NVThe failure of the pilot to ensure that the flaps were set to the proper position for takeoff which resulted in the airplane becoming airborne and unable to climb or accelerate and subsequently impacting terrain.Jul 24, 2017 · N605GV · DestroyedNTSB GAA17CA386Accident · Minor injuriesData collectionFinal reportAlexander Schleicher ASH 31 MI · Ely, NVThe pilot’s failure to maintain the proper airspeed and his exceedance of the glider’s critical angle of attack, which resulted in a stall/spin.Jul 5, 2017 · N31MX · DestroyedNTSB WPR17LA133Accident · Minor injuriesLimited investigationFinal reportEurocopter EC 130 B4 · Boulder City, NVA loss of engine power due to the failure of the manufacturer to reinstall the oil filter after it was removed for inspection, which led to coke pollution that obstructed the oil jet and resulted in the subsequent oil starvation of the axial compressor rear…Jun 27, 2017 · N151GC · Substantial damageNTSB GAA17CA340Accident · Minor injuriesData collectionFinal reportSportine Aviacija LAK 12 · Reno, NVThe glider pilot’s failure to maintain proper pitch during an aerotow takeoff.Jun 14, 2017 · N4206N · Substantial damageNTSB GAA17CA287Accident · No injuriesData collectionFinal reportJohnson Kenneth W Super CUB Sport · Austin, NVThe pilot’s failure to maintain adequate airspeed during landing in gusting wind conditions, which resulted in a loss of directional control.May 12, 2017 · N1111E · Substantial damageNTSB GAA17CA250Accident · Minor injuriesData collectionFinal reportNorth Wing Uum Sport X2-N · Boulder City, NVThe student pilot’s exceedance of the weight-shift-control aircraft’s critical angle of attack and the flight instructor’s delayed remedial action and failure to maintain the proper airspeed after encountering localized turbulence during approach, which…Apr 30, 2017 · N366DN · Substantial damageNTSB GAA17CA239Accident · No injuriesData collectionFinal reportBeech C23 · Fallon, NVThe pilot's inaccurate takeoff performance calculations and failure to maintain directional control during an aborted takeoff.Apr 19, 2017 · N786KS · Substantial damageNTSB WPR17LA076Accident · No injuriesLimited investigationFinal reportPiper Aerostar 602P · Reno, NVThe failure of the left main landing gear to fully extend for reasons that could not be determined because postaccident examination and testing did not reveal any evidence of preimpact mechanical failures or malfunctions that would have precluded normal…Mar 11, 2017 · N301FW · Substantial damageNTSB GAA17CA174Accident · Minor injuriesData collectionFinal reportLancair Columbia 400 · Henderson, NVThe pilot’s improper decision to land the airplane with a gusting crosswind, which resulted in a loss of airplane control.Mar 5, 2017 · N2516K · Substantial damageNTSB WPR17LA072Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Carson City, NVA total loss of engine power due to internal corrosion of the fuel manifold valve. Also causal was the pilot's decision to return to the runway following the loss of engine power shortly after takeoff, and his exceedance of the airplane's critical angle of…Mar 1, 2017 · N39894 · Substantial damageNTSB GAA17CA167Accident · No injuriesData collectionFinal reportEurocopter EC130 · Las Vegas, NVThe pilot's abrupt cyclic/pitch attitude control movement, which resulted in a Fenestron ground strike.Feb 26, 2017 · N864MH · Substantial damageNTSB GAA17CA054Accident · No injuriesData collectionFinal reportCessna A185 · Winnemucca, NVThe pilot's failure to maintain directional control during the landing roll.Oct 25, 2016 · N7711L · Substantial damageNTSB WPR17LA012Accident · Minor injuriesLimited investigationFinal reportNorthland IVP · Lovelock, NVA total loss of engine power due to the failure of the intake valve in the No. 3 cylinder for reasons that could not be determined based on the available information.Oct 20, 2016 · N4YB · Substantial damageNTSB GAA17CA033Accident · Minor injuriesData collectionFinal reportStinson 108 3 · Boulder City, NVThe pilot’s failure to ensure that the aerial pickup towline was not entangled around the horizontal stabilizer after the banner pickup.Oct 19, 2016 · N818C · Substantial damageNTSB GAA16CA500Accident · No injuriesData collectionFinal reportAerotek Pitts Special · Reno, NVThe pilot’s failure to maintain directional control during the landing roll, which resulted in a ground loop.Sep 17, 2016 · N91JW · Substantial damageNTSB WPR16FA178Accident · 3 fatalField investigationFinal reportPiper PA 28R-201T · Reno, NVThe pilot's decision to depart with the airplane loaded above its maximum gross weight and at or just beyond its aft center of gravity limitations, which resulted in a loss of control during the initial climb. Contributing to the accident was the pressure to…Sep 12, 2016 · N821ET · DestroyedNTSB WPR16FA172Accident · 2 fatalField investigationFinal reportBeech A36 · Sparks, NVThe pilot's selection of a landing runway which, given the wind and traffic conditions, was susceptible to high crosswinds and the translation of wake turbulence across its approach path, and the controller's and pilot's failure to ensure separation from the…Aug 31, 2016 · N985CA · DestroyedNTSB WPR16FA166Accident · Minor injuriesField investigationFinal reportDouglas TA-4K · Las Vegas, NVForeign object debris in the engine's main fuel control unit, which restricted fuel flow and subsequently resulted in the loss of engine power. Contributing to the accident was the installation or addition of an extra seal during the main fuel control unit…Aug 18, 2016 · N140EM · DestroyedNTSB GAA16CA402Accident · No injuriesData collectionFinal reportCirrus Design SR · Henderson, NVThe pilot's failure to maintain directional control during the landing roll in gusty crosswind conditions, which resulted in a runway excursion and a landing gear collapse.Jul 28, 2016 · N341CP · Substantial damageNTSB GAA16CA349Accident · No injuriesData collectionFinal reportCessna 150 · Reno, NVThe student pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion, impact with a sign, and left wing damage.Jun 26, 2016 · N5842E · Substantial damageNTSB GAA16CA279Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · Las Vegas, NVThe pilot receiving instruction's incorrect action of interfering with the flight controls and failure to comply with the flight instructor's commands, which resulted in a loss of lateral bank control and a rollover.Jun 2, 2016 · N441JL · Substantial damageNTSB GAA16CA282Accident · No injuriesData collectionFinal reportG Elwin Halvorsen PA18WB/L21-180 · Gerlach, NVThe pilot's selection of unsuitable terrain for landing, resulting in a nose over.May 30, 2016 · N45EH · Substantial damageNTSB GAA16CA259Accident · No injuriesData collectionFinal reportCessna 182 · Reno, NVThe pilot's inadequate fuel planning, resulting in fuel exhaustion and substantial damage to the firewall during the forced landing.May 24, 2016 · N4793D · Substantial damageNTSB WPR16LA109Accident · No injuriesLimited investigationFinal reportCessna 172RG · Las Vegas, NVThe pilot's loss of directional control during the landing roll, which resulted in a runway excursion.May 13, 2016 · N6281V · Substantial damageNTSB WPR16LA069Accident · Minor injuriesLimited investigationFinal reportBell 47G 3B 1 · Carson City, NVThe pilot's failure to maintain sufficient main rotor rpm, which resulted in a loss of helicopter control and a dynamic rollover.Feb 13, 2016 · N1181W · Substantial damageNTSB WPR16LA056Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R22 · Las Vegas, NVThe loss of helicopter control as a result of the loss of tail rotor effectiveness.Jan 22, 2016 · N7020U · Substantial damageNTSB WPR16LA048Accident · No injuriesLimited investigationFinal reportBeech 35 C33 · Henderson, NVA partial loss of engine power during final approach for reasons that could not be determined based on available information.Jan 5, 2016 · N20XY · Substantial damageNTSB GAA16CA026Accident · No injuriesData collectionFinal reportRans S-7 · Gerlach, NVThe pilot's failure to maintain pitch and airspeed control, in conjunction with full flaps, while maneuvering at a low altitude, resulting in a tail-stall and subsequent impact with the ground.Oct 21, 2015 · N272X · Substantial damageNTSB GAA16CA055Accident · No injuriesData collectionFinal reportBell 47G · Searchlight, NVThe pilot's failure to maintain adequate clearance from a tree during hover flight.Oct 18, 2015 · N73224 · Substantial damageNTSB GAA15CA285Accident · No injuriesData collectionFinal reportCessna T182T · Ely, NVThe pilot's failure to maintain directional control during landing in gusty crosswind conditions, which resulted in a runway excursion and a collision with an airport sign.Sep 24, 2015 · N5918D · Substantial damageNTSB WPR15LA266Accident · Serious injuriesLimited investigationFinal reportPiper PA 28 · Elko, NVThe pilot's failure to sufficiently lean the engine’s fuel-to-air mixture for the given density altitude, which resulted in reduced engine power output and the airplane’s inability to climb.Sep 23, 2015 · N56897 · Substantial damageNTSB GAA15CA270Accident · No injuriesData collectionFinal reportPiper PA 32-260 · Jackpot, NVThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and a collision with a fence.Sep 21, 2015 · N3354W · Substantial damageNTSB 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 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 GAA15CA172Accident · No injuriesData collectionFinal reportSchweizer SGS 1 26B · Silver Springs, NVThe pilot's improper decision making in adverse weather conditions, which resulted in an encounter with weather and impact with terrain.Jul 8, 2015 · N5839V · Substantial damageNTSB WPR15FA163Accident · 3 fatalField investigationFinal reportRockwell Commander 114 · Laughlin, NVA partial loss of engine power due to the turbocharger's seizure as a result of a severely worn turbowheel. Contributing to the accident was the failure of the pilot/owner to have the turbo normalization system inspected every 100 hours as required, which…May 18, 2015 · N4775W · DestroyedNTSB WPR15LA090Accident · Minor injuriesLimited investigationFinal reportCessna 150E · Silver Springs, NVThe loss of engine power for reasons that could not be determined during a postaccident examination of the airplane.Jan 25, 2015 · N4017U · Substantial damageNTSB WPR14CA392Accident · No injuriesData collectionFinal reportCirrus SR22 - NO Series · Elko, NVThe pilot's failure to maintain directional control during landing roll in gusty wind conditions, which resulted in a runway excursion and collision with terrain.Sep 25, 2014 · N73TW · Substantial damageNTSB WPR14FA369Accident · 1 fatalField investigationFinal reportBackovich George C G P 5 · Reno, NVThe failure of the right wing under normal race loads due to an improper repair of the right wing spar that reduced its structural strength following a previous landing accident.Sep 8, 2014 · N501GP · DestroyedNTSB WPR14LA356Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Gardnerville, NVThe pilot’s failure to monitor the environment and to maintain clearance from wires during takeoff.Aug 27, 2014 · N4187W · Substantial damage