NTSB investigations
270 cases where NTSB found Sloped/uneven terrain.
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\", '03021017')) 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", '03021017')) 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 GAA20CA036Accident · No injuriesData collectionFinal reportTitan Titan Tornado II · Marble Canyon, AZThe pilot's failure to maintain directional control during takeoff in gusting wind conditions, which resulted in a runway excursion and impact with sand hummocks.NTSB GAA20CA028Accident · Minor injuriesData collectionFinal reportLuscombe 8 · Lebanon, NHThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion and impact with a ditch.NTSB GAA20CA009Accident · No injuriesData collectionFinal reportAeronca 7AC · Waynesburg, PAThe student pilot's failure to maintain directional control during the landing roll due to his foot slipping off the right pedal and becoming stuck between the pedal and fuselage frame, which resulted in a runway excursion and impact with a ditch.NTSB GAA20CA042Accident · No injuriesData collectionFinal reportBeech 19 · Somerville, TNThe pilot's failure to move the fuel selector position to the "on" position before takeoff, which resulted in a total loss of engine power and necessitated a forced landing to a field shortly after takeoff, and his subsequent improper decision to take off…NTSB GAA19CA586Accident · No injuriesData collectionFinal reportPiper PA 12 · Williams, CAThe pilot's over application of power during recovery from a runway excursion, which resulted in a ground loop and nose over.NTSB GAA19CA576Accident · No injuriesData collectionFinal reportPiper PA 22 · Pollock, LAThe pilot's improper landing flare, which resulted in a bounced landing and subsequent ground loop.NTSB GAA19CA580Accident · No injuriesData collectionFinal reportCessna 172 · Plant City, FLThe student pilot's failure to maintain directional control during the aborted landing, which resulted in a runway excursion and impact with a ditch.NTSB GAA19CA544Accident · No injuriesData collectionFinal reportCessna 172F · Hemet, CAThe flight instructor's improper decision to perform a precautionary landing on unsuitable terrain, which resulted in a noseover.NTSB GAA19CA525Accident · Minor injuriesData collectionFinal reportCessna 182 · Charleston, WVThe pilot's improper approach path at night and his misjudgment of the landing point, which resulted in landing short of the runway and impact with the runway's engineered materials arrestor system.NTSB CEN19CA336Accident · No injuriesData collectionFinal reportPiper PA38 · Taylor, TXThe flight instructor's inadequate supervision of the student's soft-field takeoff, which resulted in an excessive pitch attitude, settling effect, and impact with a ditch off the end of the runway.NTSB GAA19CA522Accident · No injuriesData collectionFinal reportStinson 108 · Bandera, WAThe pilot's selection of unsuitable terrain for a simulated rejected takeoff, which resulted in a runway overrun and noseover.NTSB GAA19CA508Accident · No injuriesData collectionFinal reportPiper PA28 · Hemet, CAThe student pilot's failure to maintain directional control while attempting to go around, which resulted in a runway excursion and impact with a ditch.NTSB GAA19CA517Accident · Minor injuriesData collectionFinal reportCessna 180 · Arlington, WAThe pilot's failure to properly secure the seat before takeoff, which resulted in it sliding back during takeoff and rendering him unable to reach the rudder pedals and throttle lever, a subsequent runway excursion, ground loop, and impact with a berm.NTSB GAA19CA512Accident · No injuriesData collectionFinal reportPiper PA28 · Chickasha, OKThe student pilot's failure to maintain crosswind correction during landing and his subsequent loss of directional control during the landing roll, which resulted in a runway excursion and impact with uneven terrain.NTSB GAA19CA492Accident · No injuriesData collectionFinal reportDouglas DC3C · Kenai, AKThe pilot's failure to maintain a proper approach path in gusting crosswind wind conditions, which resulted in landing short of the runway and impact with a ditch and runway light.NTSB GAA19CA465Accident · No injuriesData collectionFinal reportBeech 36 · Richmond, VAThe pilot's failure to maintain lateral control and attain sufficient altitude to clear rising terrain during an attempted go-around.NTSB WPR19LA226Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 177RG · Fall City, WAThe failure of the No. 3 cylinder intake valve that resulted in a partial loss of engine power and a forced landing on uneven terrain.NTSB CEN19LA240Accident · Minor injuriesClass 3 · LimitedFinal reportRobinson R44 · Blair, NEThe failure of the lower actuator bearing support bracket, which resulted in the misalignment of the clutch actuator, the loss of belt tension on the main rotor drive system, and the subsequent forced landing on sloped terrain.NTSB GAA19CA463Accident · No injuriesData collectionFinal reportHughes 269A · Springfield, TNThe pilot’s failure to maintain helicopter control and a loss of tail rotor effectiveness while hover-taxiing and turning toward a taxiway in gusting crosswind conditions, which resulted in a dynamic rollover.NTSB ANC19LA036Accident · Serious injuriesClass 3 · LimitedFinal reportStoddard Hamilton Glasair II · Chattanooga, TNThe pilot's failure to switch to the secondary electrical system after the primary electrical system failed for unknown reasons.NTSB GAA19CA383Accident · No injuriesData collectionFinal reportPiper PA28 · Milton, FLThe flight instructor's intentional overapplication of rudder to avoid a ditch during landing with a tailwind, which resulted in a runway excursion and landing gear collapse.NTSB GAA19CA365Accident · No injuriesData collectionFinal reportCessna 182 · Burley, IDThe pilot's improper landing flare during landing in a gusting, right quartering tailwind, which resulted in the airplane wheel barrowing and a subsequent runway overrun, impact with terrain, and noseover.NTSB GAA19CA289Accident · No injuriesData collectionFinal reportAir Tractor AT802 · Fisher, ARThe pilot's failure to maintain directional control during takeoff in gusting wind conditions, which resulted in a runway excursion and impact with a ditch.NTSB GAA19CA253Accident · No injuriesData collectionFinal reportStearman A75N1(PT17) · Gila Bend, AZThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion and impact with a ditch.NTSB ERA19CA147Accident · Minor injuriesData collectionFinal reportGaskins Safari 400 · Gallatin, TNThe pilot/owner's improper decision to make a right turn instead of terminating the approach to a hover and his subsequent loss of helicopter control while attempting to land on sloping terrain, which resulted in a roll-over.NTSB GAA19CA170Accident · No injuriesData collectionFinal reportPiper PA 11 · Moberly, MOThe pilot's failure to maintain directional control during the landing roll in gusting wind conditions.NTSB GAA19CA159Accident · Minor injuriesData collectionFinal reportPiper PA18 · Pullman, WAThe pilot's selection of unsuitable terrain for landing, which resulted in a nose-over.NTSB GAA19CA152Accident · No injuriesData collectionFinal reportCessna 185 · Ridgeland, SCThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and impact with a ditch.NTSB WPR19LA087Accident · Serious injuriesClass 3 · LimitedFinal reportMD Helicopter 369 · Kukuihaele, HIThe partial loss of engine power due to corrosion in the engine bleed valve due to wash solution intrusion. Contributing to the accident was the installation of a bushing manufactured to incorrect dimensions in the bleed valve, and the uneven terrain at the…NTSB GAA19CA141Accident · No injuriesData collectionFinal reportRobinson R22 · Clearwater, FLThe flight instructor's failure to maintain sufficient altitude over uneven terrain during a hover taxi, which resulted in ground contact and a subsequent dynamic rollover.NTSB GAA19CA130Accident · No injuriesData collectionFinal reportCessna 172 · Hanover, VAThe student pilot's improper decision to release the seat latch to adjust the seat position during taxi, which resulted in his inability to reach the rudder or brake pedals and a subsequent loss of directional control and impact with a ditch and fence.NTSB GAA19CA113Accident · No injuriesData collectionFinal reportCessna 172 · Reno, NVThe student pilot's failure to maintain directional control during a rejected takeoff, which resulted in a runway excursion and impact with a ditch.NTSB GAA19CA104Accident · No injuriesData collectionFinal reportPiper PA28 · Bowling Green, OHThe student pilot's failure to maintain directional control upon touchdown, which resulted in a runway excursion and impact with a ditch.NTSB GAA19CA106Accident · No injuriesData collectionFinal reportCessna 172 · Caldwell, NJThe student pilot's failure to maintain directional control during the takeoff roll.NTSB GAA19CA091Accident · No injuriesData collectionFinal reportZlin Z143 · Chester, CTThe pilot's loss of airplane control during the engine start.NTSB WPR19TA034Accident · Minor injuriesClass 3Final reportCessna 172 · Colorado Springs, COThe pilot's decision to perform a touch-and-go landing at a high-density altitude airport, with a tailwind, and on an upsloping runway, which resulted in decreased airplane performance and the airplane’s inability to become airborne within the available…NTSB GAA19CA081Accident · No injuriesData collectionFinal reportCessna 172 · Inverness, FLThe pilot receiving instruction's failure to maintain directional control during landing.NTSB GAA19CA012Accident · No injuriesData collectionFinal reportBearden Biplane Sopwith Camel · Bolivar, MOThe pilot's failure to maintain directional control during landing.NTSB ERA18LA269Accident · No injuriesLimited investigationFinal reportRobinson R44 · Westminster, MDThe pilot's attempt to move the helicopter from a sloped surface after an overspeed event, which resulted in a loss of helicopter control and impact with a car. The overspeed event resulted from misrouted and damaged wiring in the magneto, which subsequently…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 GAA18CA553Accident · Minor injuriesData collectionFinal reportPiper PA28 · Spanish Fork, UTThe student pilot’s failure to maintain the runway heading during takeoff and the flight instructor’s decision to conduct primary flight instruction in an airplane without dual controls.NTSB GAA18CA532Accident · No injuriesData collectionFinal reportCessna 206 · London, KYThe pilot’s failure to maintain directional control during takeoff with a tailwind.NTSB GAA18CA511Accident · No injuriesData collectionFinal reportMooney M20J · Rochester, NHThe pilot’s failure to maintain directional control during takeoff.NTSB ANC18CA068Accident · Minor injuriesData collectionFinal reportPiper PA18 · Wasilla, AKThe pilot's failure to maintain directional control during the landing roll when the left main landing gear wheel got caught in a ditch, which resulted in a subsequent nose-over.NTSB GAA18CA492Accident · No injuriesData collectionFinal reportCessna 180 · Ambler, AKThe pilot's selection of unsuitable terrain for landing, which resulted in the left wing and horizontal stabilizer striking the ground.NTSB GAA18CA468Accident · No injuriesData collectionFinal reportCessna 185 · Lovelock, NVThe pilot's improper in-flight fuel planning, which resulted in fuel exhaustion and a subsequent total loss of engine power.NTSB GAA18CA456Accident · No injuriesData collectionFinal reportLuscombe 8 · Pottsville, PAThe pilot’s failure to maintain directional control during landing.NTSB CEN18CA293Accident · Minor injuriesData collectionFinal reportJust JA30 Superstol · Oshkosh, WIThe pilot's failure to maintain adequate airspeed during the initial climb and his exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall.NTSB WPR18FA198Accident · 2 fatalField investigationFinal reportRyan Navion · Truckee, CAA loss of engine power for reasons that could not be determined.NTSB GAA18CA392Accident · No injuriesData collectionFinal reportSchempp Hirth Discus CS · Pomfret, VTThe glider pilot’s selection of an unsuitable landing area, which resulted in a collision with a ditch during the landing roll.