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 GAA17CA522Accident · No injuriesData collectionFinal reportLuscombe 8 · Westminster, TXThe pilot’s failure to maintain directional control during the landing roll in gusting wind conditions.NTSB 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.NTSB 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…NTSB 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.NTSB GAA17CA497Accident · No injuriesData collectionFinal reportBeech A36 · Loman, IDThe pilot’s inadequate compensation for a tailwind, which resulted in a runway overrun.NTSB 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.NTSB 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.NTSB 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…NTSB 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.NTSB 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…NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB GAA17CA427Accident · Minor injuriesData collectionFinal reportLet L23 · Deatsville, ALThe student pilot’s failure to maintain clearance from trees and power lines while landing.NTSB 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.NTSB GAA17CA412Accident · No injuriesData collectionFinal reportMooney M20C · Washington Island, WIThe pilot's failure to maintain a proper approach path, which resulted in impact with trees.NTSB 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…NTSB 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.NTSB 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.NTSB 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.NTSB GAA17CA388Accident · No injuriesData collectionFinal reportCessna 207 · Hope, AKThe pilot’s inadvertent flight into instrument meteorological conditions and subsequent controlled flight into terrain.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB GAA17CA261Accident · No injuriesData collectionFinal reportQuicksilver Manufacturing SPORT2S R582 · Arecibo, PRThe pilot’s failure to see and avoid trees during low-altitude flight.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.