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 CEN15LA432Accident · 1 fatalLimited investigationFinal reportRans S18 · Shattuck, OKThe noncertificated pilot’s failure to maintain control of the unregistered airplane during initial climb and his subsequent exceedance of the airplane’s critical angle-of-attack, which resulted in a stall/spin.Sep 29, 2015 · UNREG · Substantial damageNTSB WPR15FA268Accident · Serious injuriesField investigationFinal reportCessna 150F · Port Townsend, WAThe loss of engine power due to the mechanic's inadequate tightening of the crankshaft gear retaining bolts during an engine overhaul, which resulted in fatigue failure of the bolts and the crankshaft gear dowel pin that allowed the crankshaft gear to…Sep 28, 2015 · N8529G · Substantial damageNTSB CEN15LA431Accident · Serious injuriesLimited investigationFinal reportEdward M Van Morlan Rans S-12 · Gardner, KSThe pilot's inadequate airspeed control and the airplane’s exceedance of its critical angle-of-attack during the forced landing, which resulted in an aerodynamic stall. Contributing to the accident was the loss of engine power due to fuel starvation caused by…Sep 28, 2015 · N98ES · Substantial damageNTSB CEN15LA428Accident · Serious injuriesLimited investigationFinal reportSukhoi SU-26 · Slidell, TXThe pilot's attempt to recover from an aerobatic maneuver at too low of an altitude to make a safe recovery.Sep 28, 2015 · N596TJ · DestroyedNTSB GAA15CA288Accident · No injuriesData collectionFinal reportCessna 305F · Bentonville, ARThe pilot's failure to maintain yaw control during a go-around, which resulted in a right main landing gear collapse and the right wing impacting terrain during a runway excursion.Sep 27, 2015 · N119BD · Substantial damageNTSB CEN15FA427Accident · 1 fatalField investigationFinal reportCessna 182 · Lexington, TXThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack during a climbing turn, which resulted in an aerodynamic stall/spin at too low of an altitude to recover.Sep 27, 2015 · N3921D · Substantial damageNTSB CEN15LA433Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Fort Wayne, INThe pilot's inadequate preflight planning and fuel management, which resulted in a total loss of engine power due to fuel exhaustion.Sep 26, 2015 · N6922F · Substantial damageNTSB CEN15FA426Accident · 1 fatalField investigationFinal reportJones Ralph D Zodiac CH 601 HD · Ama, LAThe pilot's failure to maintain adequate airspeed and his exceedance of the airplane's critical angle of attack following a loss of engine power for reasons that could not be determined based on available evidence, which resulted in an aerodynamic stall and…Sep 26, 2015 · N401 · Substantial damageNTSB GAA15CA283Accident · No injuriesData collectionFinal reportStinson HW75 · Bremerton, WAThe pilot's failure to maintain directional control during the landing roll, resulting in the left main landing gear collapse and substantial damage to the left wing strut attachment points.Sep 25, 2015 · N22548 · Substantial damageNTSB ERA15LA376Accident · Serious injuriesLimited investigationFinal reportHughes 269 · Eustis, FLThe pilot's failure to maintain yaw control as he slowed the helicopter during a landing approach, which resulted in a loss of helicopter control due to a loss of tail rotor effectiveness.Sep 25, 2015 · N9567F · Substantial damageNTSB CEN15FA424Accident · 2 fatalField investigationFinal reportBeech S35 · Pagosa Springs, COImproper engine assembly by unknown maintenance personnel, which resulted in the failure of the No. 6 connecting rod due to oil starvation from the shifting of the crankshaft's No. 4 main bearing.Sep 25, 2015 · N193Q · DestroyedNTSB CEN15FA422Accident · 2 fatalField investigationFinal reportPierce, Henry Bushby Mustang II · Granbury, TXThe pilot's exceedance of the airplane's critical angle of attack resulting in an aerodynamic stall and collision with terrain.Sep 25, 2015 · N929DS · DestroyedNTSB GAA15LA296Accident · No injuriesLimited investigationFinal reportBell 206 · Ozark, ALThe pilot's failure to maintain clearance from terrain while hovering, which resulted in the helicopter's skid impacting terrain, subsequent abnormal airframe vibrations, and a hard landing during the subsequent hovering autorotation.Sep 24, 2015 · N49660 · 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 GAA15CA282Accident · Minor injuriesData collectionFinal reportCessna 170B · Arctic Village, AKThe pilot exceeded the critical angle of attack during takeoff, which resulted in an aerodynamic stall and a collision with terrain.Sep 24, 2015 · N2528C · Substantial damageNTSB GAA15CA276Accident · No injuriesData collectionFinal reportPiper PA 28 · Van Nuys, CAThe pilot's failure to compensate for turbulence during the landing flare, which resulted in a hard landing and runway excursion.Sep 24, 2015 · N8258S · Substantial damageNTSB ERA15LA375Accident · Serious injuriesLimited investigationFinal reportSchempp-Hirth Ventus 2CT · Blacksburg, VAA loss of thermal lift during a motor glider flight, which resulted in an off-airport landing. Contributing to the accident was the pilot’s failure to maintain adequate clearance from power lines during the off-airport landing attempt.Sep 24, 2015 · N710JC · Substantial damageNTSB ERA15LA373Accident · Minor injuriesLimited investigationFinal reportVanek Jim Sport Copter Vortex · Lake Wales, FLA loss of engine power due to a lean fuel/air mixture as a result of a disconnected fuel primer line.Sep 24, 2015 · N179V · Substantial damageNTSB CEN15LA423Accident · Serious injuriesLimited investigationFinal reportBell 206B · Woodville, TXThe loss of engine power due to water contamination in the fuel system. Contributing to the accident were the pilot’s inadequate preflight inspection of the fuel tanks and the operator’s inadequate inspection of the fuel supply truck that did not detect water…Sep 24, 2015 · N648CA · 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 GAA15CA271Accident · No injuriesData collectionFinal reportCessna 305A · Show Low, AZThe pilot's failure to maintain directional control during landing in quartering tailwind conditions, which resulted in a runway excursion and a right main landing gear collapse.Sep 23, 2015 · N5207G · Substantial damageNTSB WPR15LA265Accident · Serious injuriesLimited investigationFinal reportAero Commander 680 E · Boise, IDThe pilot's failure to maintain airplane control following an engine problem for reasons that could not be determined because postaccident examination of both engines and the rudder revealed no malfunctions or anomalies that would have precluded normal…Sep 21, 2015 · N222JS · Substantial damageNTSB GAA15LA284Accident · Serious injuriesLimited investigationFinal reportChampion 7ECA · Talkeetna, AKThe pilot's failure to properly calculate the fuel consumption rate and to properly monitor the fuel status in flight and his decision to continue the flight despite signs of an engine problem, which resulted in a total loss of engine power due to fuel…Sep 21, 2015 · N9132L · Substantial damageNTSB GAA15CA300Accident · No injuriesData collectionFinal reportCessna 177RG · Aztec, NMThe pilot's failure to maintain directional control during an aborted landing, which resulted in a runway excursion and an impact with shrubs.Sep 21, 2015 · N1875Q · 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 ERA15LA366Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Bally, PAThe pilot's failure to maintain altitude during low-level aerobatic maneuvers. Contributing to the accident were the pilot's improper decision to attempt the low-level aerobatic maneuvers and his impairment due to psychiatric conditions and the medications he…Sep 21, 2015 · N347SP · Substantial damageNTSB GAA15LA265Accident · Serious injuriesLimited investigationFinal reportStinson 108 · Palmer, AKThe pilot's failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle-of-attack during final approach to landing, which resulted in an aerodynamic stall and impact with terrain.Sep 20, 2015 · N6066M · Substantial damageNTSB GAA15CA290Accident · No injuriesData collectionFinal reportCessna 172M · Shiocton, WIThe pilot's decision to continue to land at an unlighted airstrip, at night, after the landing light failed on approach, which resulted in a bounced landing, runway excursion, and collision with terrain.Sep 20, 2015 · N20079 · Substantial damageNTSB ERA15FA362Accident · 2 fatalField investigationFinal reportCessna 150H · Morrisville, NYThe pilot's failure to maintain airspeed and her exceedance of the airplane's critical angle-of-attack, which led to an aerodynamic stall, following a total loss of engine power for reasons that could not be determined because postaccident examination of the…Sep 20, 2015 · N22721 · DestroyedNTSB GAA15CA273Accident · No injuriesData collectionFinal reportPiper PA 20 · Marshfield, MAThe pilot's loss of directional control during the landing roll, which resulted in a ground loop and impact with terrain.Sep 19, 2015 · N6932K · Substantial damageNTSB GAA15CA272Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 20 C1 · Sanford, NCThe student pilots failure to maintain a climb after takeoff, which resulted in an impact with terrain.Sep 19, 2015 · N635DC · Substantial damageNTSB ERA15LA368Accident · No injuriesLimited investigationFinal reportCessna 150M · Mount Airy, MDThe in-flight fatigue failure of the No. 4 cylinder barrel, which resulted in a total loss of engine power.Sep 19, 2015 · N714CW · Substantial damageNTSB ERA15LA367Accident · Serious injuriesLimited investigationFinal reportSchleicher ASW 19B · Saratoga Springs, NYThe pilot's failure to maintain glider control while attempting to land.Sep 19, 2015 · N27XX · Substantial damageNTSB ERA15LA363Accident · Serious injuriesLimited investigationFinal reportCessna 172E · Gettysburg, PAThe total loss of engine power due to carburetor icing. Contributing to the accident was the pilot's failure to maintain a proper approach speed during the forced landing, which resulted in impact with trees.Sep 19, 2015 · N3647S · Substantial damageNTSB ERA15CA364Accident · Minor injuriesData collectionFinal reportHughes 269B · Hartford, ALThe pilot's inadequate preflight planning, and his subsequent failure to attain adequate altitude during takeoff, which resulted in a collision with a wire fence.Sep 19, 2015 · N141LL · Substantial damageNTSB CEN15LA444Accident · No injuriesLimited investigationFinal reportPiper PA 24-250 · New Orleans, LAThe collapse of the landing gear for reasons that could not be determined based on the available information.Sep 19, 2015 · N7803P · Substantial damageNTSB ANC15LA073Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 · Fort Glenn, AKThe separation of the tail rotor gearbox from the tailboom attachment point due to overstress loads imposed by a tail rotor blade imbalance as the result of impact with an undetermined object during low-level flight operations.Sep 19, 2015 · N7162R · Substantial damageNTSB GAA15CA264Accident · No injuriesData collectionFinal reportAviat A1 · Rock Springs, WYThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground loop.Sep 18, 2015 · N288MD · Substantial damageNTSB ERA15FA361Accident · 1 fatalField investigationFinal reportCessna U206 · Spring Hill, FLThe pilot's failure to maintain a stabilized instrument approach, which resulted in a loss of control.Sep 18, 2015 · N8615Z · Substantial damageNTSB GAA15CA299Accident · No injuriesData collectionFinal reportBurkhart Grob Flugzeugbau G103 Twin Astir · Wellington, OHThe pilot's failure to level the wings during the landing flare, which resulted in the left wing striking the runway.Sep 17, 2015 · N3872G · Substantial damageNTSB CEN15LA416Accident · Serious injuriesLimited investigationFinal reportCessna R172 · College Station, TXThe total loss of engine power due to the fatigue failure of the No. 1 connecting rod. Contributing to the accident was the manufacturer’s exclusion of the accident engine (by serial number) in a revision of a service bulletin.Sep 17, 2015 · N180CM · Substantial damageNTSB GAA15CA266Accident · Minor injuriesData collectionFinal reportSchweizer G 164B · Paxton, NEThe pilot's failure to maintain adequate distance from a power line during low altitude flight operations, which resulted in an impact with the power line, and subsequent impact with the ground.Sep 16, 2015 · N3628Z · Substantial damageNTSB GAA15CA267Accident · No injuriesData collectionFinal reportCessna 180H · Delta Junction, AKThe pilot's failure to attain and maintain yaw control during the approach and attempted go around, which resulted in impact with trees and terrain.Sep 13, 2015 · N4763U · Substantial damageNTSB ERA15LA354Accident · Serious injuriesLimited investigationFinal reportCessna 177 · Moneta, VAThe pilot's premature retraction of the wing flaps and his subsequent failure to maintain pitch control during an attempted go-around, which resulted in the airplane exceeding its critical angle-of-attack and an aerodynamic stall. Contributing to the accident…Sep 13, 2015 · N2835X · Substantial damageNTSB ANC15LA070Accident · No injuriesLimited investigationFinal reportHelio H 295 · Delta Junction, AKA partial loss of engine power during takeoff for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.Sep 13, 2015 · N6464V · Substantial damageNTSB ERA15FA353Accident · 1 fatalField investigationFinal reportAero Vodochody L39 · Oneida, TNThe pilot's failure to maintain airplane control following a partial loss of engine power during initial climb. The reason for the partial loss of engine power could not be determined due to extensive postimpact damage.Sep 12, 2015 · N139RT · DestroyedNTSB ERA15FA352Accident · 1 fatalField investigationFinal reportCessna 150 · Atco, NJThe student pilot's improper decision to intentionally maneuver at low altitude while waving to people on the ground, which led to the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall.Sep 12, 2015 · N8185F · DestroyedNTSB CEN15LA412Accident · Minor injuriesLimited investigationFinal reportGuisinger Gary G Baby Belle · Stuart, IAThe failure of the tail rotor driveshaft for reasons that could not be determined due to the mechanically and thermally deformed fracture surface.Sep 12, 2015 · N135PA · Substantial damageNTSB GAA15CA297Accident · No injuriesData collectionFinal reportCzech Sport Piper Sport · Spartanburg, SCThe pilot's failure to maintain pitch control during the landing which resulted in a bounced landing, and an aerodynamic stall during the attempted recovery.Sep 11, 2015 · N442DD · Substantial damageNTSB GAA15CA260Accident · No injuriesData collectionFinal reportRocci Martignoni JA30 Superstol · Santa Rosa, NMThe pilot's failure to maintain directional control during takeoff, which resulted in a runway excursion and a ground loop.Sep 11, 2015 · N508RM · Substantial damage