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 GAA15CA141Accident · No injuriesData collectionFinal reportSchweizer SGS 2 32 · Middlefield, OHThe student pilot's incorrect pitch and roll rate control inputs which resulted in an aerodynamic stall and incipient spin at a low altitude.Jun 25, 2015 · N275P · Substantial damageNTSB GAA15CA138Accident · Serious injuriesData collectionFinal reportQuicksilver MXL II Sport · Ute, IAThe pilot's failure to maintain sufficient airspeed to prevent an inadvertent aerodynamic stall, and impact with terrain.Jun 25, 2015 · UNREG · Substantial damageNTSB GAA15CA137Accident · No injuriesData collectionFinal reportPiper PA 24 · Charles City, IAThe pilot's inadequate pre-flight fuel planning resulting in fuel exhaustion and a collision with terrain.Jun 25, 2015 · N5152P · Substantial damageNTSB GAA15CA155Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 20 C1 · Salisbury, MDThe student pilot's loss of directional control during the landing roll, resulting in a runway excursion and collision with terrain.Jun 24, 2015 · N577MA · Substantial damageNTSB GAA15CA152Accident · No injuriesData collectionFinal reportAir Tractor AT 502B · Edna, TXThe pilot's failure to maintain directional control during the takeoff roll, resulting in a runway excursion, and collision with a fence.Jun 24, 2015 · N6107W · Substantial damageNTSB ERA15LA251Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · East Moriches, NYThe pilot's failure to maintain directional control while taking off in a crosswind, which resulted in a collision with a tree.Jun 24, 2015 · N84927 · Substantial damageNTSB WPR15LA198Accident · Serious injuriesLimited investigationFinal reportCessna TU206F · Schafers Meadows, MTThe pilot's failure to maintain directional control of the airplane during the landing roll in variable and gusting wind conditions.Jun 23, 2015 · N8424Q · Substantial damageNTSB GAA15CA135Accident · No injuriesData collectionFinal reportWSK PZL Mielec M 18A · Nyssa, ORThe pilot's failure to maintain directional control during takeoff, resulting in a runway excursion and collision with terrain.Jun 23, 2015 · N2159C · Substantial damageNTSB GAA15CA134Accident · No injuriesData collectionFinal reportQuicksilver MX · Nampa, IDThe student pilot's failure to maintain directional control during the takeoff roll, resulting in a runway excursion, and a collision with terrain.Jun 23, 2015 · UNREG · Substantial damageNTSB GAA15CA133Accident · No injuriesData collectionFinal reportSchempp-Hirth Ventus 2C · Hobbs, NMThe pilot's improper compensation for gusty wind conditions which resulted in impact with terrain short of the runway.Jun 23, 2015 · N172VC · Substantial damageNTSB WPR15FA195Accident · 1 fatalField investigationFinal reportShort Brothers S312 Tucano T MK1 · Maricopa, CAThe pilot's failure to maintain clearance from terrain during low-level airwork, which resulted in uncontrolled collision with terrain. Contributing to the accident was the pilot's impairment from the combined effects of butalbital and codeine.Jun 22, 2015 · N206PZ · DestroyedNTSB GAA15CA169Accident · No injuriesData collectionFinal reportWeatherly 201B · Pemberton, NJThe pilot's failure to maintain directional control during the takeoff roll, which resulted in the airplane's left main landing gear impacting an unknown object, and subsequent collapse during landing.Jun 22, 2015 · N1292W · Substantial damageNTSB GAA15CA151Accident · No injuriesData collectionFinal reportFlight Design Ctls · Andover, MNThe pilot's improper fuel management and preflight planning, which resulted in the total loss of engine power due to fuel exhaustion and a forced landing in a field where the airplane nosed over.Jun 21, 2015 · N799CT · Substantial damageNTSB ERA15FA245Accident · 1 fatalField investigationFinal reportCzech Sport Piper Sport · Holly Ridge, NCThe pilot’s failure to maintain airplane control after the cockpit canopy opened during initial climb. Contributing to the accident was the pilot’s failure to securely lock the canopy before takeoff.Jun 21, 2015 · N35EP · Substantial damageNTSB CEN15LA285Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Danville, ARThe loss of engine power for reasons that could not be determined based on the available information.Jun 21, 2015 · N305CG · Substantial damageNTSB CEN15LA279Accident · No injuriesLimited investigationFinal reportMooney M20K · Sheboygan, WIOil starvation due to preignition in the No. 5 cylinder as a result of failed spark plugs; the top and sides of the piston head were eroded, which allowed the exhaust gases caused by the preignition to pressurize the crankcase and force engine oil out of the…Jun 21, 2015 · N1168Z · Substantial damageNTSB WPR15LA193Accident · 1 fatalLimited investigationFinal reportBell 47G 5 · Salinas, CAThe non-instrument-rated pilot's visual flight rules flight into instrument meteorological conditions, which resulted in his spatial disorientation and loss of helicopter control. Contributing to the accident was the pilot's impairment by high-dose opioid use.Jun 20, 2015 · N4427F · Substantial damageNTSB WPR15LA192Accident · Minor injuriesLimited investigationFinal reportRoberts Super Bear · La Grande, ORA total loss of engine power for reasons that could not be determined because postaccident examinations did not reveal any anomalies that would have precluded normal operation.Jun 20, 2015 · N92MJ · Substantial damageNTSB GAA15CA159Accident · No injuriesData collectionFinal reportVans RV-12 · Oshkosh, WIThe pilot's failure to monitor the airplane's glide path during the final approach, which resulted in a low approach path and impact with terrain.Jun 20, 2015 · N242VA · Substantial damageNTSB WPR15LA191Accident · No injuriesLimited investigationFinal reportCessna 180A · Polson, MTA total loss of engine power during approach for reasons that could not be determined because postaccident examination revealed no anomalies that would have precluded normal operation.Jun 19, 2015 · N9699B · Substantial damageNTSB GAA15CA129Accident · No injuriesData collectionFinal reportLancair ES - NO Series · Hampshire, ILThe failure of the brake master cylinder which resulted in a loss of brake pressure and the subsequent loss of directional control during the landing roll.Jun 19, 2015 · N800TR · Substantial damageNTSB CEN15FA278Accident · 1 fatalField investigationFinal reportCessna 172 · Shreveport, LAThe pilot's loss of airplane control during initial climb after takeoff for reasons that could not be determined because an examination of the airframe and engine did not reveal any preimpact anomalies.Jun 19, 2015 · N5743A · Substantial damageNTSB ERA15FA241Accident · Serious injuriesField investigationFinal reportPiper PA-22 · Laconia, NHA total loss of engine power for reasons that could not be determined because of insufficient evidence found during postaccident examination of the airframe and engine.Jun 18, 2015 · N2569P · Substantial damageNTSB ERA15CA243Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 20 C1 · Moreland, GAThe flight instructor's inaccurate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.Jun 17, 2015 · N353DC · Substantial damageNTSB WPR15LA185Accident · No injuriesLimited investigationFinal reportCessna 182A · Moab, UTThe pilot’s inadequate preflight fuel planning and inflight fuel management, which resulted in a total loss of engine power due to fuel exhaustion.Jun 14, 2015 · N5143D · Substantial damageNTSB ERA15LA239Accident · Serious injuriesLimited investigationFinal reportStinson 108 · Dushore, PAThe total loss of engine power during the initial climb for reasons that could not be determined because postaccident examination of the engine revealed no anomalies that would have precluded normal operation.Jun 14, 2015 · N97505 · Substantial damageNTSB ERA15LA238Accident · No injuriesLimited investigationFinal reportCessna T210 · Palmyra, PAThe pilot's delay in conducting an aborted landing and his subsequent failure to establish a proper airspeed during the attempted go-around on a hot day, which resulted in the airplane’s inability to climb and a subsequent stall/mush.Jun 14, 2015 · N732VN · Substantial damageNTSB ERA15LA237Accident · Serious injuriesLimited investigationFinal reportPiper PA28 · Hampton, NHThe pilot’s failure to properly set the stabilator trim prior to takeoff, which resulted in an exceedance of the airplane’s critical angle of attack and an aerodynamic stall during takeoff.Jun 14, 2015 · N43078 · Substantial damageNTSB CEN15FA269Accident · 1 fatalField investigationFinal reportGrumman American Avn. AA-5 · Fredericksburg, TXThe pilot's failure to maintain adequate airspeed following a partial loss of engine power during initial climb, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. Also causal was the mechanic's…Jun 14, 2015 · N6552L · Substantial damageNTSB CEN15FA267Accident · 4 fatalField investigationFinal reportBeech A36 · Huggins, MOThe pilot's failure to maintain adequate airspeed and his exceedance of the airplane's critical angle-of-attack, which resulted in an aerodynamic stall and loss of control.Jun 12, 2015 · N3193W · DestroyedNTSB WPR15LA183Accident · No injuriesLimited investigationFinal reportBeech E33A · Tucson, AZA loss of left braking action for reasons that could not be determined because postaccident examination did not reveal any evidence of preimpact mechanical failures or malfunctions that would have precluded normal operation, which resulted in a loss of…Jun 11, 2015 · N8401N · Substantial damageNTSB GAA15CA120Accident · No injuriesData collectionFinal reportBeech RC 45J · Everett, WAThe pilot's failure to maintain directional control, which resulted in a runway excursion, and a collision with a sign.Jun 11, 2015 · N585PB · Substantial damageNTSB WPR15FA181Accident · 1 fatalField investigationFinal reportBeech F35 · Everett, WAThe partial loss of engine power during takeoff due to debris within the fuel servo, which restricted fuel flow throughout the engine fuel system and resulted in a partial loss of engine power.Jun 10, 2015 · N4224B · Substantial damageNTSB GAA15CA114Accident · No injuriesData collectionFinal reportPiper PA 16 · Tollville, ARThe pilot's failure to maintain directional control during the landing flare, which resulted in the airplane impacting a rice field and nosing over.Jun 10, 2015 · N5735H · Substantial damageNTSB CEN15LA270Accident · No injuriesLimited investigationFinal reportPiper PA28-200 · Jonesboro, ARMaintenance personnel's improper engine oil drain valve installation, which led to engine oil exhaustion and the subsequent loss of engine power after takeoff at an altitude too low for the pilot to execute a forced landing in a suitable area.Jun 10, 2015 · N872CS · Substantial damageNTSB GAA15CA130Accident · No injuriesData collectionFinal reportPiper PA 28-140 · Swanton, OHThe pilot's failure to maintain directional control during the landing roll, resulting in a runway excursion, and a collision with a sign.Jun 9, 2015 · N6919W · Substantial damageNTSB GAA15CA117Accident · No injuriesData collectionFinal reportAir Tractor AT 401 · Wall, SDThe pilot's failure to adjust the airplane's useful load to compensate for the high temperature, which resulted in an insufficient climb rate to clear surrounding terrain, and a runway excursion.Jun 9, 2015 · N4549E · Substantial damageNTSB GAA15CA113Accident · No injuriesData collectionFinal reportGrumman Acft ENG Cor-Schweizer G 164A · Bakersfield, CAThe pilot's failure to maintain directional control during the landing roll, resulting in a runway excursion, and a collision with terrain.Jun 9, 2015 · N8372 · Substantial damageNTSB CEN15LA266Accident · Serious injuriesLimited investigationFinal reportHunziker Eros 1650R · Quitman, TXThe pilot's failure to maintain adequate airspeed for the approach to landing.Jun 9, 2015 · N104JX · Substantial damageNTSB CEN15FA264Accident · 1 fatalField investigationFinal reportBellanca 7GCBC · Kadoka, SDThe pilot's failure to maintain sufficient airspeed during the initial climb after takeoff, which resulted in the airplane’s wing exceeding its critical angle-of-attack and a subsequent aerodynamic stall.Jun 8, 2015 · N11698 · Substantial damageNTSB GAA15CA109Accident · Minor injuriesData collectionFinal reportKretsinger Bensen B8M · Maple Plain, MNThe pilot's failure to maintain airspeed, resulting in a loss of control, and a collision with terrain.Jun 7, 2015 · N2436 · Substantial damageNTSB GAA15CA136Accident · No injuriesData collectionFinal reportCessna 172H · Cottonwood Falls, KSThe pilot's failure to attain adequate airspeed to climb the airplane out of ground effect, which resulted in an aerodynamic stall and a collision with terrain.Jun 6, 2015 · N2536L · Substantial damageNTSB GAA15CA112Accident · No injuriesData collectionFinal reportCessna 180 · Vichey, MOThe pilot's failure to maintain directional control during the landing, which resulted in a runway excursion and collision with terrain.Jun 6, 2015 · N180SA · Substantial damageNTSB CEN15LA263Accident · Minor injuriesLimited investigationFinal reportBelcher CH601XLB · Alpine, TXThe pilot/builder's failure to properly adjust the fuel flow, which resulted in reduced flow to the engine and a subsequent total loss of engine power.Jun 6, 2015 · N274AJ · Substantial damageNTSB CEN15LA258Accident · Minor injuriesLimited investigationFinal reportFlight Design Ctsw · Haskell, OKThe loss of engine power for reasons that could not be determined because a postaccident engine examination and test run did not reveal any evidence of preimpact malfunctions or failures that would have precluded normal operation.Jun 6, 2015 · N535CT · Substantial damageNTSB CEN15FA257Accident · 1 fatalField investigationFinal reportMorse Frank L Rebel · Eagle, CO, COThe pilot’s failure to maintain control of the airplane while landing in gusty, crosswind conditions that likely exceeded the recommended limitation of the airplane.Jun 5, 2015 · N914FM · Substantial damageNTSB CEN15FA255Accident · 2 fatalField investigationFinal reportCub Crafters CC18-180 · Raton, NMThe pilot's failure to maintain adequate airspeed while maneuvering at a low altitude, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall.Jun 5, 2015 · N162WR · Substantial damageNTSB GAA15CA118Accident · No injuriesData collectionFinal reportCessna 195 · Lancaster, NYA loss of directional control and subsequent ground loop due to an underinflated right tire, which was a result of foreign object debris puncturing the tire.Jun 4, 2015 · N9818A · Substantial damageNTSB CEN15LA276Accident · No injuriesLimited investigationFinal reportAir Tractor AT-602 · Branch, LAAn exceedance of the airplane's takeoff/climb capability, which resulted in a stall during initial climb at an altitude that was too low for recovery.Jun 4, 2015 · N5035R · Substantial damageNTSB GAA15CA105Accident · No injuriesData collectionFinal reportRans S 12XL · Sharpsville, INThe pilot's failure to maintain directional control during takeoff, which resulted in a collision with a building.Jun 3, 2015 · N51120 · Substantial damage