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 GAA18CA250Accident · Minor injuriesData collectionFinal reportMichael R Alexander Mosquito XE · Iron Station, NCThe noncertificated pilot’s decision to practice hovering the helicopter in a confined space, which resulted in the tail rotor striking a tree.May 2, 2018 · N725JC · DestroyedNTSB CEN18LA157Accident · Minor injuriesLimited investigationFinal reportHartline J Bon Hartline Kitfox III · Marathon, TXThe failure of the flaperon hinge attachment point during takeoff, which resulted in a loss of airplane control. Contributing to the accident was the lack of reinforcement of the hinge attachment point in accordance with the manufacturer’s service bulletin.May 2, 2018 · N73BH · Substantial damageNTSB GAA18CA243Accident · No injuriesData collectionFinal reportCessna 310 · Gainesville, FLThe pilot’s failure to maintain an adequate approach path at night, which resulted in a tree strike.Apr 30, 2018 · N2212A · Substantial damageNTSB GAA18CA244Accident · No injuriesData collectionFinal reportLuscombe 8 · Eunice, LAThe pilot’s failure to maintain clearance from a tree while on approach to land.Apr 28, 2018 · N71261 · Substantial damageNTSB GAA18CA234Accident · No injuriesData collectionFinal reportPiper PA28 · Wickenburg, AZThe student pilot’s failure to relinquish flight controls and premature flap reduction during approach to land.Apr 25, 2018 · N922PA · Substantial damageNTSB CEN18LA148Accident · Serious injuriesLimited investigationFinal reportMaule M 5-235C · Roxbury, KSThe pilot's failure to maintain directional control during takeoff from a road, which resulted in impact with a sign.Apr 24, 2018 · N9281E · Substantial damageNTSB GAA18CA227Accident · No injuriesData collectionFinal reportIrvin Stephen D Rutan Long E Z · Tucson, AZThe pilot’s excessive ground speed and loss of directional control while exiting the taxiway.Apr 22, 2018 · N8714S · Substantial damageNTSB ANC18LA032Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 · Fairbanks, AKThe pilot's failure to maintain helicopter control while in a hovering turn, which resulted in a collision with obstacles.Apr 20, 2018 · N511CC · Substantial damageNTSB GAA18CA247Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · Sonora, TXThe pilot’s failure to maintain clearance from trees while maneuvering at a low altitude.Apr 18, 2018 · N4487D · Substantial damageNTSB GAA18CA211Accident · No injuriesData collectionFinal reportCessna A185 · Sterling, AKThe pilot’s failure to maintain clearance from trees during the approach to land due to the sun glare.Apr 12, 2018 · N8702Z · Substantial damageNTSB GAA18CA191Accident · No injuriesData collectionFinal reportPiper PA18 · Dorris, CAThe pilot’s failure to maintain directional control during takeoff.Mar 30, 2018 · N101EB · Substantial damageNTSB GAA18CA185Accident · No injuriesData collectionFinal reportUltramagic N 300 · Cave Creek, AZThe balloon pilot’s decision to add heat to the envelope with a tree branch protruding into the envelope that caught fire.Mar 28, 2018 · N64EX · DestroyedNTSB ERA18LA115Accident · No injuriesLimited investigationFinal reportCessna 180K · Canton, MSThe pilot's decision to land the airplane with a tailwind, which led to a runway excursion. Contributing to the pilot's decision to land with a tailwind was a partial loss of engine power due to his failure to effectively use carburetor heat in conditions…Mar 23, 2018 · N77NP · Substantial damageNTSB CEN18LA124Accident · Serious injuriesLimited investigationFinal reportWhite Thorpe T 18 · Cleburne, TXThe loss of engine power due to fuel exhaustion.Mar 14, 2018 · N118RG · Substantial damageNTSB GAA18CA161Accident · No injuriesData collectionFinal reportCessna 172 · Green Valley, AZThe pilot’s failure to maintain directional control of the airplane during landing with a tailwind.Mar 12, 2018 · N418DD · Substantial damageNTSB GAA18CA158Accident · Minor injuriesData collectionFinal reportJohnson Gerald CR-1 · Altamont, NYThe pilot’s failure to maintain the runway heading during the approach in gusting crosswind conditions.Mar 11, 2018 · N142DT · Substantial damageNTSB ERA18LA096Accident · Serious injuriesLimited investigationFinal reportPiper PA 28 · Edgewater, FLThe flight instructor's failure to maintain the appropriate glidepath to the runway, which resulted in a collision with trees and terrain during final approach.Mar 6, 2018 · N6764W · Substantial damageNTSB GAA18CA149Accident · Minor injuriesData collectionFinal reportBeech B · Ferris, TXThe pilot’s improper preflight inspection of the fuel level, which resulted in a loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot’s failure to lower the landing gear before the emergency landing.Mar 1, 2018 · N77MM · Substantial damageNTSB WPR18CA096Accident · Serious injuriesData collectionFinal reportBell 47G · Pixley, CAA total loss of engine power due to fuel starvation, which resulted from the pilot’s failure to ensure that adequate fuel was on board for the flight. Contributing to the accident was the pilot’s self-induced pressure to complete the flight due to impending…Feb 28, 2018 · N7800S · Substantial damageNTSB GAA18CA140Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R44 · Woodland, CAThe pilot’s distraction due to her malfunctioning iPad, which led to her inadvertent forward cyclic application.Feb 24, 2018 · N630ML · Substantial damageNTSB GAA18LA131Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R22 · Charleston, SCThe flight instructor’s abrupt evasive maneuver to avoid a reported unmanned aerial system, which resulted in a loss of forward airspeed and settling with power and a subsequent collision with trees and terrain.Feb 14, 2018 · N337H · Substantial damageNTSB CEN18FA088Accident · 1 fatalField investigationFinal reportCessna 172F · Williamsport, INThe pilot's mismanagement of fuel, which resulted in fuel exhaustion and descent and collision with trees.Jan 27, 2018 · N8559U · DestroyedNTSB ERA18LA070Accident · Serious injuriesLimited investigationFinal reportPiper PA32R · Marathon, FLThe pilot's failure to maintain directional control during takeoff.Jan 25, 2018 · N47863 · Substantial damageNTSB CEN18LA080Accident · Minor injuriesLimited investigationFinal reportTomlinson Tracy L Tukan · Erie, COThe student pilot’s inadvertent shutting off of the fuel valve while on approach, which resulted in a loss of engine power due to fuel starvation and impact with terrain.Jan 18, 2018 · N907T · Substantial damageNTSB CEN18LA075Accident · Serious injuriesLimited investigationFinal reportPiper PA 28-236 · Tishomingo, OKThe pilot’s inadequate preflight fuel planning and in-flight fuel monitoring and his decision to take off with an unverified amount of fuel, which resulted in fuel exhaustion and a subsequent impact with trees during an attempted forced landing.Jan 13, 2018 · N4345K · Substantial damageNTSB CEN18LA073Accident · No injuriesLimited investigationFinal reportS.O.C.A.T.A. MS893E · Wadsworth, OHThe pilot’s failure to apply carburetor heat during the approach, which resulted in a loss of engine power due to carburetor icing.Jan 11, 2018 · N353RA · Substantial damageNTSB GAA18CA095Accident · No injuriesData collectionFinal reportCessna 150 · Nampa, IDThe pilot’s geographic disoriention during a night flight, which resulted in an off-airport landing.Jan 2, 2018 · N3229V · Substantial damageNTSB CEN18LA064Accident · No injuriesLimited investigationFinal reportPipistrel Doo Ajdovscina Virus SW · Paulding, OHThe loss of engine power while the motor-powered glider was maneuvering due to the fuel unporting in its fuel tank, which resulted in fuel starvation and a subsequent forced landing on unsuitable terrain.Dec 28, 2017 · N4JW · Substantial damageNTSB ERA18TA059Accident · Minor injuriesFinal reportCessna 172 · Union Mills, NCThe pilot's failure to use carburetor heat in weather conditions conducive to serious carburetor icing, which resulted in a total loss of engine power and a subsequent forced landing.Dec 24, 2017 · N91SP · Substantial damageNTSB ANC18LA016Accident · Serious injuriesLimited investigationFinal reportPiper PA 23-250 · Knoxville, TNThe flight instructor’s failure to comply with published engine-out procedures and recommended airspeeds, which resulted in a lack of directional control, collision with trees, and impact with the ground; the left engine lost total power due to fuel…Dec 19, 2017 · N40285 · Substantial damageNTSB WPR18CA048Accident · Serious injuriesData collectionFinal reportCessna 172P · Valley Springs, CAThe pilot's failure to maintain clearance from trees while maneuvering for landing and his decision to land on a surface with obstructions.Dec 14, 2017 · N54873 · Substantial damageNTSB GAA18CA084Accident · No injuriesData collectionFinal reportCorbeil Shawn Corbeil Shawn SER VI · Rogersburg, ORThe pilot’s improper landing flare and his subsequent failure to see and avoid a tree during a go-around.Dec 12, 2017 · N552EZ · Substantial damageNTSB GAA18CA075Accident · Minor injuriesData collectionFinal reportJones Kent C Vans RV-10 · Limon, COThe pilot’s unstabilized approach and failure to go around at night, which resulted in the airplane impacting a power line and a subsequent hard landing.Dec 8, 2017 · N9738J · Substantial damageNTSB ERA18LA041Accident · No injuriesLimited investigationFinal reportPiper PA28 · Brewton, ALThe pilot's inadequate fuel management, which resulted in a total loss of engine power due to fuel starvation.Dec 5, 2017 · N747KM · Substantial damageNTSB GAA18CA069Accident · No injuriesData collectionFinal reportWeaver David A Pulsar 912XP · Plato Center, ILThe pilot’s decision to continue to land without visual reference to the airport in low light conditions. Contributing to the accident was the pilot’s inability to activate the private airport’s pilot-controlled lighting system due to its configuration.Dec 2, 2017 · N912GR · Substantial damageNTSB GAA18CA074Accident · No injuriesData collectionFinal reportCessna 172 · Bowie, MDThe pilot’s failure to maintain situational awareness during the approach to land. Contributing to the accident was the pilot’s distraction by the instrument panel during the approach.Nov 30, 2017 · N474SP · Substantial damageNTSB CEN18LA040Accident · No injuriesLimited investigationFinal reportCessna 150F · Midland, TXThe improper installation of the generator by unknown personnel, which resulted in a loss of oil and subsequent engine failure.Nov 26, 2017 · N8637S · Substantial damageNTSB CEN18LA038Accident · Serious injuriesLimited investigationFinal reportPiper / Laudeman J3C 65 · Palmyra, WIThe pilot’s inadvertent pulling of the fuel shutoff valve, which resulted in a total loss of engine power and a subsequent forced landing into trees. Contributing to the pilot’s inadvertent pulling of the fuel shutoff valve were habit patterns he had…Nov 26, 2017 · N11188 · Substantial damageNTSB ERA18LA032Accident · Serious injuriesLimited investigationFinal reportPiper PA 34-220T · Ebensburg, PAThe pilot's improper decision to fly an airplane with a known oil leak, which led to a total loss of engine power due to oil starvation. Contributing to the accident was the pilot's decision to land with a tailwind, which led to his attempted go-around and…Nov 25, 2017 · N263DM · Substantial damageNTSB GAA18CA055Accident · No injuriesData collectionFinal reportBellanca 8KCAB · El Dorado, MOThe pilot’s failure to maintain directional control during the landing roll.Nov 21, 2017 · N62979 · Substantial damageNTSB ANC18LA010Accident · No injuriesLimited investigationFinal reportRockwell International 112A · Clearwater, FLA total loss of engine power for reasons that could not be determined based on the available information.Nov 19, 2017 · N1401J · Substantial damageNTSB GAA18CA024Accident · No injuriesData collectionFinal reportCessna 172 · Old Bridge, NJThe student pilot’s failure to maintain directional control during the landing roll.Oct 17, 2017 · N6384D · Substantial damageNTSB CEN18LA014Accident · Serious injuriesLimited investigationFinal reportDiamond Aircraft Ind DA 40 · Gustavus, OHThe pilot’s geographic disorientation while maneuvering in the airport traffic pattern in dark night conditions, which resulted in the airplane descending below a normal approach path and a collision with trees. Contributing to the accident was the pilot's…Oct 17, 2017 · N105MK · Substantial damageNTSB GAA18CA007Accident · No injuriesData collectionFinal reportCessna T210 · Waterford, MIThe pilot's unstabilized approach at night, which resulted in collision with trees.Oct 7, 2017 · N5EC · Substantial damageNTSB GAA18CA004Accident · Minor injuriesData collectionFinal reportMooney M20 · Topping, VAThe pilot’s exceedance of the airplane’s critical angle of attack during takeoff, which resulted in a departure stall.Oct 7, 2017 · N7884V · Substantial damageNTSB CEN18LA010Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Sweetwater, TXThe loss of engine power during a precautionary approach for landing for reasons that could not be determined based on the available information.Oct 6, 2017 · N8234R · Substantial damageNTSB ERA17LA340Accident · Minor injuriesLimited investigationFinal reportWaco UPF 7 · Ocklawaha, FLA failure of both magnetos due to multiple deficiencies, which resulted in a total loss of engine power.Sep 28, 2017 · N29909 · Substantial damageNTSB WPR17LA212Accident · Minor injuriesLimited investigationFinal reportMooney M20E · Glendale, CAThe pilot’s inadequate preflight fuel planning and improper decision to not refuel before the flight, which resulted in fuel exhaustion and the subsequent total loss of engine power.Sep 23, 2017 · N34BE · Substantial damageNTSB GAA17CA530Accident · Minor injuriesData collectionFinal reportCessna 172 · Plainville, CTThe pilot’s failure to properly execute the go-around, which resulted in the airplane failing to maintain a climb, which resulted in collision with a tree.Sep 11, 2017 · N54463 · Substantial damageNTSB GAA17CA526Accident · Serious injuriesData collectionFinal reportCessna 172 · Coolin, IDThe pilot's decision to take off in high-density altitude and gusting quartering tailwind conditions, which resulted in a loss of lift and an inability to gain altitude during the initial climb.Sep 10, 2017 · N5703A · Substantial damage