NTSB investigations

933 cases where NTSB found Tree(s).

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.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '03022020'))
  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 GAA17CA522Accident · No injuriesData collectionFinal reportLuscombe 8 · Westminster, TXThe pilot’s failure to maintain directional control during the landing roll in gusting wind conditions.Sep 6, 2017 · N1590K · Substantial damageNTSB CEN17FA332Accident · Serious injuriesField investigationFinal reportCessna 180J · Gaylord, MIThe pilot's failure to use carburetor heat while operating in weather conditions that were conducive to carburetor ice formation, which resulted in a total loss of engine power due to carburetor ice accumulation.Aug 28, 2017 · N180LP · Substantial damageNTSB CEN17FA331Accident · 3 fatalClass 3 · FieldFinal reportBeech A36 · Ellabell, GAThe total loss of engine power due to oil starvation to the No. 1 connecting rod, which resulted from the improper torque of the No. 1 cylinder hold-down bolts and through-studs at the time of the cylinder's installation, which resulted in the failure of the…Aug 28, 2017 · N87RY · DestroyedNTSB GAA17CA519Accident · No injuriesData collectionFinal reportPiper J5A · Springfield, VTThe pilot's unstabilized approach, which resulted in landing long and fast, and his subsequent failure to maintain clearance from trees during a go-around.Aug 27, 2017 · N30897 · Substantial damageNTSB GAA17CA497Accident · No injuriesData collectionFinal reportBeech A36 · Loman, IDThe pilot’s inadequate compensation for a tailwind, which resulted in a runway overrun.Aug 19, 2017 · N136BJ · Substantial damageNTSB ERA17LA275Accident · Minor injuriesLimited investigationFinal reportPiper J3C · Salisbury, CTAn improper replacement of the crankshaft by maintenance personnel, which resulted in a failure of the crankshaft gear and total loss of engine power.Aug 13, 2017 · N98550 · Substantial damageNTSB GAA17CA488Accident · Minor injuriesData collectionFinal reportCharles D Walker Walker Curtiss JN4D · Bowling Green, KYThe pilot’s exceedance of the biplane’s critical angle of attack during initial climb, which resulted in an aerodynamic stall and collision with trees.Aug 12, 2017 · N8262 · Substantial damageNTSB ERA17LA267Accident · Serious injuriesLimited investigationFinal reportPiper PA28 · Pittstown, NJThe student pilot's improper decision to conduct a night flight and his failure to maintain adequate altitude during the approach, which resulted in controlled flight into trees and terrain. Contributing to the accident was the student pilot's lack of total…Aug 6, 2017 · N56884 · Substantial damageNTSB ERA17LA270Accident · Serious injuriesLimited investigationFinal reportPipistrel Doo Ajdovscina Virus SW · Immokalee, FLThe pilot's failure to attain adequate airspeed during an attempted go-around, which resulted in an aerodynamic stall.Aug 3, 2017 · N811AW · Substantial damageNTSB WPR17LA175Accident · Serious injuriesLimited investigationFinal reportGrumman AA1 · Phoenix, AZThe partial loss of engine power during initial climb due to the No. 3 cylinder exhaust valve becoming stuck open due to deposit buildup in the exhaust valve stem and guide and the pilot’s exceedance of the airplane’s critical angle of attack while attempting…Aug 1, 2017 · N6216L · Substantial damageNTSB GAA17CA536Accident · Minor injuriesData collectionFinal reportMenzimer Gary Ray Firestar · Westfield, PAThe pilot's improper decision to operate an airplane without recent flight training and his inadvertent application of left electric rudder trim before flight and a subsequent loss of airplane control.Jul 30, 2017 · UNREG · DestroyedNTSB CEN17LA285Accident · Serious injuriesLimited investigationFinal reportHillard Charlie R Hawker FB60 · Breckenridge, TXA total loss of engine power for reasons that could not be determined because postaccident engine examination and testing did not reveal any mechanical malfunctions or anomalies that would have precluded normal operation.Jul 25, 2017 · N254SF · Substantial damageNTSB GAA17CA430Accident · No injuriesData collectionFinal reportPiper PA 28-180 · Whaleyville, VAThe pilot’s inadvertent brake application during the landing roll, which resulted in a loss of directional control.Jul 23, 2017 · N2814T · Substantial damageNTSB WPR17LA160Accident · No injuriesLimited investigationFinal reportCessna 182L · Arbuckle, CAThe pilot’s delayed decision to abort the takeoff and his failure to properly conduct a rejected takeoff, which resulted in a runway overrun.Jul 22, 2017 · N42143 · Substantial damageNTSB GAA17CA427Accident · Minor injuriesData collectionFinal reportLet L23 · Deatsville, ALThe student pilot’s failure to maintain clearance from trees and power lines while landing.Jul 21, 2017 · N342BA · Substantial damageNTSB CEN17LA272Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-235 · Pierce, NEThe pilot’s failure to maintain clearance from trees during a low-level agricultural aerial application flight.Jul 18, 2017 · N7388Z · Substantial damageNTSB GAA17CA412Accident · No injuriesData collectionFinal reportMooney M20C · Washington Island, WIThe pilot's failure to maintain a proper approach path, which resulted in impact with trees.Jul 15, 2017 · N9303V · Substantial damageNTSB ERA17LA242Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Key Biscayne, FLThe nearly complete blockage of the right fuel tank strainer with organic material, which resulted in fuel starvation and the subsequent total loss of engine power. Contributing to the fuel starvation was the pilot receiving instruction’s and the flight…Jul 14, 2017 · N80457 · Substantial damageNTSB GAA17CA408Accident · No injuriesData collectionFinal reportPiper PA 18 · Denali, AKThe pilot’s failure to maintain directional control while landing on a narrow, unimproved airstrip in gusting wind conditions.Jul 13, 2017 · N8560C · Substantial damageNTSB GAA17CA404Accident · Minor injuriesData collectionFinal reportEurocopter AS 350 · King Vale, CAThe pilot’s failure to maintain clearance from trees while landing in a dusty, unimproved landing zone.Jul 11, 2017 · N357PJ · Substantial damageNTSB CEN17LA263Accident · Serious injuriesLimited investigationFinal reportCirrus Design SR22 · Corydon, IAA total loss of engine power for reasons that could not be determined because postaccident examination of the engine and airframe did not reveal any anomalies that would have precluded normal operation.Jul 9, 2017 · N929DE · Substantial damageNTSB GAA17CA388Accident · No injuriesData collectionFinal reportCessna 207 · Hope, AKThe pilot’s inadvertent flight into instrument meteorological conditions and subsequent controlled flight into terrain.Jul 3, 2017 · N9620M · Substantial damageNTSB CEN17LA251Accident · No injuriesLimited investigationFinal reportCody Hawkins JA30 Superstol · Ponca City, OKContamination of the fuel system, resulting in a partial loss of engine power and subsequent off-airport landing.Jul 2, 2017 · N2463H · Substantial damageNTSB ERA17LA215Accident · Serious injuriesLimited investigationFinal reportBeech B23 · Ocean Isle Beach, NCThe pilot's improper positioning of the fuel selector between the left and right fuel tank positions, which resulted in a partial loss of engine power due to fuel starvation and a subsequent forced landing into trees.Jun 28, 2017 · N4023T · Substantial damageNTSB ERA17CA213Accident · Minor injuriesData collectionFinal reportCessna 207 · Vinalhaven, METhe pilot’s failure to maintain a stabilized approach, which resulted in a bounced landing and subsequent go-around with insufficient distance to clear trees during the climb.Jun 26, 2017 · N207GM · Substantial damageNTSB GAA17CA347Accident · Minor injuriesData collectionFinal reportAeronca 11AC · Watervliet, MIThe flight instructor's inadequate preflight planning, which resulted in a takeoff over maximum gross weight from a turf runway in high density altitude conditions and the airplane’s inability to attain a climb rate and subsequent collision with trees.Jun 16, 2017 · N9404E · Substantial damageNTSB ERA17LA205Accident · Minor injuriesLimited investigationFinal reportCessna P206 · West Creek, NJThe pilot's improper fuel management, which resulted in fuel starvation and the subsequent total loss of engine power.Jun 13, 2017 · N206TF · Substantial damageNTSB ERA17LA203Accident · No injuriesLimited investigationFinal reportCessna 172 · Suffolk, NYA loss of preload to the crankshaft gear attachment bolt due to improper installation, which resulted in the fatigue failure of the crankshaft gear alignment dowel and led to the rotation of the crankshaft gear and a subsequent total loss of engine power.Jun 12, 2017 · N13306 · Substantial damageNTSB GAA17CA331Accident · Minor injuriesData collectionFinal reportPiper PA25 · Hood River, ORThe pilot's failure to visually check the fuel level prior to takeoff and subsequent mismanagement of the available fuel supply during numerous glider tow flights.Jun 11, 2017 · N8578L · Substantial damageNTSB GAA17CA334Accident · Minor injuriesData collectionFinal reportPiper PA28R · Geneva, OHThe pilot’s failure to maintain a proper landing flare in variable wind conditions, which resulted in the airplane landing on the left edge of the runway and impacting trees.Jun 9, 2017 · N32088 · Substantial damageNTSB GAA17CA381Accident · No injuriesData collectionFinal reportAeronca 7AC · Soldotna, AKThe pilot’s abrupt maneuver to avoid a moose cow and calf during taxi, which resulted in an impact with a tree.Jun 4, 2017 · N82639 · Substantial damageNTSB GAA17CA320Accident · No injuriesData collectionFinal reportCessna 182 · Elk City, IDThe pilot’s failure to maintain adequate airspeed and his exceedance of the wing’s angle of attack while on short final, which resulted in an aerodynamic stall.Jun 2, 2017 · N5011D · Substantial damageNTSB ERA17CA186Accident · No injuriesData collectionFinal reportPiper PA 28-181 · Bristow, VAThe flight instructor’s and pilot’s mismanagement of the available fuel, which resulted in exhaustion of the fuel in the selected fuel tank and a subsequent total loss of engine power.May 21, 2017 · N8304F · Substantial damageNTSB GAA17CA302Accident · No injuriesData collectionFinal reportCessna 175 · Prospect, ORThe flight instructor’s failure to attain an adequate climb rate during takeoff, which resulted in impact with trees.May 20, 2017 · N175DH · Substantial damageNTSB GAA17CA298Accident · No injuriesData collectionFinal reportSchweizer SGS233 · Springfield, VTThe student pilot’s failure to maintain an adequate glidepath and the flight instructor’s delayed remedial action, which resulted in the glider landing short of the runway in trees.May 20, 2017 · N1242S · Substantial damageNTSB ERA17LA182Accident · Minor injuriesLimited investigationFinal reportStinson 108 · West Creek, NJA total loss of engine power due to the No. 4 cylinder’s exhaust valve getting stuck and the subsequent fracturing of the valve face stem.May 17, 2017 · N9366K · Substantial damageNTSB GAA17CA274Accident · Minor injuriesData collectionFinal reportCessna 177 · Frankston, TXThe pilot’s loss of runway visibility during landing in rain, which resulted in the pilot’s loss of situational awareness and subsequent loss of airplane control.May 10, 2017 · N34207 · Substantial damageNTSB CEN17LA179Accident · Minor injuriesLimited investigationFinal reportBeech 19 · Weatherford, TXThe flight instructor’s inadequate in-flight fuel management, which resulted in fuel starvation and a total loss of engine power.May 8, 2017 · N18925 · Substantial damageNTSB GAA17CA261Accident · No injuriesData collectionFinal reportQuicksilver Manufacturing SPORT2S R582 · Arecibo, PRThe pilot’s failure to see and avoid trees during low-altitude flight.May 5, 2017 · N228KM · Substantial damageNTSB CEN17LA166Accident · No injuriesLimited investigationFinal reportPiper PA 31-350 · Covington, LAThe pilot's improper fuel planning, which resulted in a total loss of power to both engines due to fuel exhaustion.Apr 23, 2017 · N3548J · Substantial damageNTSB WPR17LA088Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA 22-150 · Kernville, CAThe pilot’s exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall/mush.Apr 21, 2017 · N9975D · Substantial damageNTSB GAA17CA240Accident · Minor injuriesData collectionFinal reportParlette Robert L Glastar · Wenatchee, WAThe pilot’s improper landing flare and subsequent failure to adequately compensate for gusting wind conditions during a go-around.Apr 21, 2017 · N661RP · Substantial damageNTSB ERA17FA164Accident · 1 fatalField investigationFinal reportBell-Carson 47G Super C 4 · Timmonsville, SCThe pilot's decision to maneuver the helicopter at a low altitude near trees, which resulted in collision with the trees.Apr 21, 2017 · N865Z · DestroyedNTSB GAA17CA236Accident · Minor injuriesData collectionFinal reportZeiler Bakeng Duce 1976 CZ · Oliver Springs, TNThe pilot’s unstabilized approach and failure to go around, which resulted in impact with trees.Apr 15, 2017 · N122BD · Substantial damageNTSB GAA17CA241Accident · Minor injuriesData collectionFinal reportAmerican AA 1 · New Market, VAThe pilot’s failure to maintain a proper approach path, which resulted in an impact with trees.Apr 9, 2017 · N5690L · Substantial damageNTSB GAA17CA247Accident · No injuriesData collectionFinal reportGrumman American Avn. AA · Flushing, MIThe pilot’s unstabilized approach and subsequent failure to attain the proper touchdown point, which resulted in a runway overrun.Mar 28, 2017 · N9613L · Substantial damageNTSB GAA17CA196Accident · No injuriesData collectionFinal reportSchweizer SGS126 · Bangor, PAThe glider’s encounter with atmospheric conditions where the lift was not sufficient to maintain flight, which resulted in an off-airport landing.Mar 11, 2017 · N17933 · Substantial damageNTSB GAA17CA183Accident · Minor injuriesData collectionFinal reportJohnson Jerry WAG Aero/SPT Trainer · Hendersonville, NCThe pilot’s unstabilized approach and failure to attain the proper touchdown point while attempting to land in gusting crosswind conditions, which resulted in an attempted go-around and collision with trees and power lines.Mar 9, 2017 · N24188 · DestroyedNTSB GAA17CA182Accident · Serious injuriesData collectionFinal reportPedersen Bjarne Martin Sportsman GS-2 · Robbinsville, NJThe pilot’s failure to maintain directional control during the landing roll in gusting wind conditions.Mar 9, 2017 · N237PM · Substantial damageNTSB ERA17LA120Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 150J · Argyle, NYA total loss of engine power for undetermined reasons, which resulted in a forced landing and subsequent impact with trees.Mar 5, 2017 · N60939 · Substantial damage