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.
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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB WPR18FA261Accident · 2 fatalClass 3 · FieldFinal reportGruber Beelzabub · Rochester, WAThe pilot’s failure to maintain clearance from a tree while maneuvering at a low altitude.NTSB GAA18CA558Accident · No injuriesData collectionFinal reportPiper PA18 · Kenai, AKThe pilot’s improper landing flare, which resulted in a hard, bounced landing and subsequent loss of directional control on an unimproved airstrip.NTSB GAA18CA528Accident · No injuriesData collectionFinal reportBeech 200 · Burbank, CAThe flight instructor's and pilot receiving instruction's failure to maintain clearance from a tree while taxiing.NTSB CEN18TA374Accident · Minor injuriesFinal reportBeech 35 · Harrisville, MIThe pilot’s delayed decision to abort the takeoff, which resulted in the loss of lateral control of the airplane and collision with trees at the end of the runway. Contributing to the accident was the pilot’s decision to depart with a center of gravity…NTSB GAA18CA510Accident · No injuriesData collectionFinal reportMaule MX7 · Post Mills, VTThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion and subsequent impact with trees.NTSB GAA18CA503Accident · Minor injuriesData collectionFinal reportChampion 8GCBC · Elberta, ALThe pilot's failure to use carburetor heat during a low-power setting approach in conditions conducive to carburetor icing, which resulted in a partial loss of engine power.NTSB WPR18LA233Accident · No injuriesLimited investigationFinal reportBlue Oak CCK-1865 · Deadwood, CAA loss of engine power due to fuel exhaustion and the pilot's failure to ensure that the left-wing fuel cap was secure before flight. Contributing to the accident was the pilot's failure to monitor fuel levels while in flight.NTSB CEN18LA341Accident · Minor injuriesLimited investigationFinal reportCirrus SR22 · Granbury, TXThe pilot’s failure to maintain directional control during a crosswind landing, which resulted in the airplane exiting the runway and impacting a ditch, tree, and fence.NTSB CEN18LA340Accident · No injuriesLimited investigationFinal reportBeech B36TC · LaPorte, TXThe loss of engine power due to a torn intercooler hose that resulted in an overly rich fuel mixture, which, when combined with the pilot's activation of the auxiliary fuel pump, flooded the engine.NTSB GAA18CA496Accident · No injuriesData collectionFinal reportCessna A185 · Big Lake, AKThe pilot’s failure to maintain clearance from tree foliage on the left side of the runway during takeoff due to his focus on the right side of the runway.NTSB GAA18CA520Accident · No injuriesData collectionFinal reportPiper PA18 · Tyonek, AKThe pilot’s failure to maintain directional control during landing in gusting wind conditions.NTSB WPR18LA222Accident · Serious injuriesClass 3 · LimitedFinal reportAir Tractor AT802 · Northport, WAA total loss of engine power during a climb due to an accumulation of molten environmental particles, the source of which could not be determined based on the available evidence, which resulted in a forced landing.NTSB GAA18CA490Accident · Serious injuriesData collectionFinal reportCessna 172 · DePere, WIThe pilot’s failure to maintain lateral control and his subsequent failure to maintain the runway heading during an attempted go-around, which resulted in impact with trees.NTSB CEN18TA330Accident · No injuriesFinal reportPiper J3C · Friendswood, TXThe pilot's decision to conduct a flight in an airplane that had a tailwheel with degraded locking pins, which allowed the tailwheel to unlock and swivel out of alignment and precluded the pilot from regaining directional control on the ground during a…NTSB CEN18LA321Accident · Minor injuriesLimited investigationFinal reportCessna A188 · Sedalia, MOA total loss of engine power during low-altitude maneuvering for reasons that could not be determined due to postimpact fire damage.NTSB GAA18CA502Accident · No injuriesData collectionFinal reportWSK PZL Mielec M-18A · Dansville, NYThe pilot’s failure to maintain clearance from crops during an agricultural application flight.NTSB GAA18CA469Accident · Minor injuriesData collectionFinal reportRans S7 · Kenai, AKThe pilot's exceedance of the airplane's climb capability due to his use of full flaps during a short-field takeoff, his failure to attain a positive climb rate after takeoff, and his exceedance of the airplane’s critical angle of attack, which resulted in an…NTSB GAA18CA467Accident · No injuriesData collectionFinal reportBeech 58 · Greenville, SCThe pilot failure to attain the proper touchdown point on a wet runway, which resulted in insufficient runway remaining to safely stop the airplane.NTSB CEN18LA302Accident · No injuriesLimited investigationFinal reportBeech A36 · Brainerd, MNTotal loss of engine power due to a fuel supply interruption from the left tank for reasons that could not be determined, which resulted in the subsequent forced landing into trees.NTSB ERA18LA204Accident · Serious injuriesLimited investigationFinal reportProgressive Aerodyne Searey · Haverhill, NHThe pilot's failure to maintain clearance from trees while maneuvering the airplane at a very low altitude in a confined area while attempting to land on a river.NTSB CEN18LA301Accident · Serious injuriesLimited investigationFinal reportFlightstar SC II · Painesville, OHThe student pilot’s failure to maintain an airspeed below flight speed during a practice taxi run, which resulted in the airplane inadvertently becoming airborne. Once airborne, the reduced engine power due to an improper propeller pitch setting and…NTSB WPR18LA199Accident · Serious injuriesLimited investigationFinal reportCub Crafters CC19 · Hyrum, UTThe pilot’s improper verification of the fuel quantity during the preflight inspection, which resulted in fuel exhaustion and a subsequent loss of engine power. Contributing to the accident was the pilot’s distraction due to a malfunctioning hangar door and a…NTSB GAA18CA561Accident · No injuriesData collectionFinal reportApollo Fox · Chateaugay, NYThe pilot’s failure to maintain clearance from trees during a go-around.NTSB GAA18CA429Accident · No injuriesData collectionFinal reportCessna 170 · Spearfish, SDThe pilot’s improper decision to take off in tailwind conditions, which resulted in an aborted takeoff with insufficient runway remaining.NTSB CEN18LA274Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Lakeview, ARThe student pilot’s impairment by alcohol and multiple medications, which led to his failure to maintain obstacle clearance during takeoff and the subsequent exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall and…NTSB GAA18CA403Accident · No injuriesData collectionFinal reportRockwell 114 · Corsicana, TXThe pilot’s failure to maintain the runway heading during a soft-field takeoff with a tailwind, which resulted in a rejected takeoff.NTSB GAA18CA398Accident · No injuriesData collectionFinal reportAeronca 7CCM · Palmer, AKThe pilot's improper landing flare, which resulted in a hard landing, an attempted go-around, and a subsequent nose-over.NTSB GAA18CA405Accident · Minor injuriesData collectionFinal reportAviat A-1C · Dixie, IDThe pilot’s failure to maintain an adequate approach in gusting tailwind conditions, which resulted in a runway overshoot.NTSB GAA18CA414Accident · No injuriesData collectionFinal reportNorth American AT · Moneta, VAThe pilot's failure to maintain a proper descent rate, which resulted in a bounced landing and his subsequent failure to maintain directional.NTSB GAA18CA394Accident · No injuriesData collectionFinal reportEvektor Aerotechnik Sportstar · Louisburg, NCThe student pilot's distraction due to a previous runway excursion and navigational issues during the accident flight and his failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack during the downwind leg, which…NTSB GAA18CA417Accident · No injuriesData collectionFinal reportTravel Air 2000 · Shelter Island, NYThe pilot's failure to maintain clearance from a tree during taxi.NTSB GAA18CA375Accident · No injuriesData collectionFinal reportTaylorcraft F19 · Goose Bay, AKThe pilot’s failure to maintain a proper approach path during landing in dusky, flat light conditions, which resulted in a tree strike.NTSB ERA18LA177Accident · No injuriesLimited investigationFinal reportCrawford RV-7 · Alexander City, ALA total loss of engine power for reasons that could not be determined because examination of the engine revealed no evidence of any preimpact mechanical malfunctions or failures that would have precluded normal operation.NTSB GAA18CA382Accident · No injuriesData collectionFinal reportPzl-Swidnik PW 5 · Waller, TXThe glider pilot’s failure to maintain clearance from trees during landing.NTSB ANC18LA047Accident · Serious injuriesLimited investigationFinal reportDehavilland DHC-2 · Dillingham, AKThe pilot's failure to maintain directional control while landing in gusting wind conditions.NTSB ERA18LA175Accident · Minor injuriesLimited investigationFinal reportAircraft Mfg & Development CH 2000 · Newburyport, MAThe pilot's failure to adequately compensate for existing crosswind conditions during the final approach and landing flare, which led to the airplane drifting left of the runway, and his delayed decision to go around, which resulted in the airplane touching…NTSB ERA18LA162Accident · No injuriesLimited investigationFinal reportBryan C L/Labrash R D Searey · Englewood, FLThe partial loss of engine power due to carburetor icing.NTSB GAA18CA323Accident · No injuriesData collectionFinal reportCessna 172 · Fuquay Varina, NCThe flight instructor’s failure to maintain adequate clearance from overgrown brush during taxi, which resulted in entanglement with the brush and a subsequent impact with a tree.NTSB ANC18LA040Accident · Serious injuriesLimited investigationFinal reportPiper PA 18-150 · Wasilla, AKA total loss of engine power for reasons that could not be determined based on the available information.NTSB CEN18LA206Accident · Serious injuriesLimited investigationFinal reportHughes Aero Predator "C" · Copemish, MIThe pilot's improper decision to take off with a passenger in high-density altitude conditions from a runway with tall grass present, which resulted in the powered-parachute's poor takeoff performance and its inability to clear a tree line and led to a…NTSB GAA18CA325Accident · Minor injuriesData collectionFinal reportCosentino Garey A Pegasus · Kingston, OKThe pilot’s failure to maintain altitude and the powered parachute’s subsequent impact with trees.NTSB GAA18CA306Accident · No injuriesData collectionFinal reportLite Flight Dragonfly · Mint Hill, NCThe pilot’s exceedance of the airplane’s critical angle of attack during a turn, which resulted in an aerodynamic stall/spin.NTSB GAA18CA343Accident · Serious injuriesData collectionFinal reportAmerican AA · Port Orange, FLThe pilot’s inadequate preflight inspection of the fuel, which resulted in fuel exhaustion and a subsequent total loss of engine power.NTSB CEN18FA186Accident · 1 fatalField investigationFinal reportJames Donald Baker Zenith · Bolivar, MOThe pilot's failure to maintain airplane control after takeoff.NTSB CEN18LA183Accident · Serious injuriesLimited investigationFinal reportHughes 369A · Stoneburg, TXThe pilot's unsafe and aggressive operation of the helicopter at low altitude, which resulted in impact with trees.NTSB CEN18CA185Accident · No injuriesData collectionFinal reportCessna 120 · Harlan, IAThe pilot’s late go-around during a bounced landing, which led to an aerodynamic stall and impact with terrain.NTSB WPR18LA142Accident · Serious injuriesLimited investigationFinal reportKolb Firestar · Atmore, ALThe noncertificated pilot's failure to maintain airplane control, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's lack of flight experience and qualification.NTSB CEN18LA167Accident · Serious injuriesLimited investigationFinal reportEnstrom Helicopter 280C · Kerens, TXThe total loss of engine power due to fuel exhaustion and the pilot’s inadequate in-flight fuel management.NTSB GAA18CA263Accident · Minor injuriesData collectionFinal reportSchweizer SGS 1 26 · Springfield, VTThe pilot’s inability to maintain sufficient altitude after the glider encountered downdrafts during the approach, which resulted in the glider striking trees.NTSB GAA18CA347Accident · No injuriesData collectionFinal reportPiper PA28 · Pine Spring, TXThe pilot’s failure to maintain adequate altitude while flying over mountainous terrain in turbulent wind conditions at night, which resulted in a tree strike.