NTSB investigations
675 cases where the defining event was Low altitude operation/event.
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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '220') 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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '220') 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 WPR21LA056Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Howe, IDThe pilot’s failure to maintain clearance from mountainous terrain after an encounter with a downdraft, which resulted in a collision with terrain.NTSB CEN21LA005Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT402 · Egypt, ARThe pilot’s failure to maintain clearance from a tree limb during a low-level aerial application flight.NTSB WPR20LA315Accident · 1 fatalClass 3 · LimitedFinal reportAir Tractor AT-802A · Emmett, IDThe pilot’s descent below surrounding terrain and his delayed decision to initiate a climb which resulted in impact with terrain. Contributing to the accident were terrain and lighting conditions that affected the pilot’s ability to accurately assess terrain…NTSB ERA20LA330Accident · 1 fatalClass 3 · LimitedFinal reportPiper PA25 · Floral City, FLThe pilot’s failure to see and avoid a tree while flying towards the rising sun during an aerial application flight, which resulted in a collision with the tree and a subsequent loss of airplane control.NTSB WPR20WA329Accident · No injuriesClass 5 · ForeignRobinson R44 · Rooibok-Kraal, South AfricaNTSB WPR20LA331Accident · Serious injuriesClass 4 · LimitedFinal reportBell 206 · Randle, WAThe pilot's failure to maintain clearance from a tree while conducting an external load operation.NTSB ERA20LA306Accident · Serious injuriesClass 4 · LimitedFinal reportThrush S2R-H80 · Hawkinsville, GAThe pilot's failure to maintain clearance from an antenna tower while maneuvering during an agricultural application flight while flying directly toward the sun.NTSB CEN20CA347Accident · Minor injuriesClass 4 · Data collectionFinal reportGrumman G164 · Scottsbluff, NEThe pilot’s loss of visual reference during agricultural low-level flight, resulting in collision with power lines.NTSB WPR20CA253Accident · Serious injuriesClass 4 · Data collectionFinal reportRobert D Carr Jr Cavalon · Upper Lake, CAThe pilot’s distraction and failure to maintain adequate airspeed during a low altitude maneuver, which resulted in a loss of aircraft control and collision with terrain.NTSB WPR20WA248Accident · Serious injuriesForeign investigationRobinson R44 · Steam Plains, AustraliaThe government of Australia has notified the NTSB of an accident involving a Robinson R44 helicopter that occurred on July 31, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's investigation under the…NTSB CEN20CA312Accident · No injuriesClass 4 · Data collectionFinal reportAir Tractor AT 602 · Tiro, OHThe pilot's failure to maintain clearance while attempting to fly under power lines during an aerial application pass.NTSB CEN20CA311Accident · Minor injuriesClass 4 · Data collectionFinal reportAir Tractor AT 401 · Burlington, COThe pilot’s failure to maintain clearance from guy-wires during low-altitude agricultural operations.NTSB CEN20CA300Accident · No injuriesClass 4 · Data collectionFinal reportRobinson R44 · Dickeyville, WIThe pilot did not maintain clearance from wires during an aerial application flight.NTSB WPR20CA218Accident · No injuriesClass 4 · Data collectionFinal reportRans S6 · Richland, WAThe pilot's inability to arrest a descent rate or maintain altitude after encountering a downdraft while maneuvering at low altitude near mountainous terrain that resulted in a hard landing.NTSB CEN20LA272Accident · 1 fatalClass 3 · LimitedFinal reportGolden Circle Air T-Bird · Grosse Ile, MIThe noncertificated pilot’s failure to maintain clearance from trees while maneuvering at low altitude in gusting wind conditions. Contributing to the accident was the pilot’s lack of flight experience.NTSB WPR20CA197Accident · No injuriesClass 4 · Data collectionFinal reportRobinson R44 · Pioche, NVThe pilot’s decision to fly at low level over mountainous terrain and his inability to recover when the helicopter encountered a downdraft that resulted in a collision with terrain.NTSB ERA20LA220Accident · 1 fatalClass 3 · LimitedFinal reportRobinson R66 · Pikeville, NCThe pilot’s failure to see and avoid a small diameter wire during low altitude agricultural spraying operations. Contributing to the accident was the pilot’s insufficient property survey.NTSB ERA20LA217Accident · 1 fatalClass 3 · LimitedFinal reportAir Tractor AT502 · Atmore, ALThe pilot’s exceedance of the airplane’s critical angle of attack while maneuvering at low altitude, which resulted in an aerodynamic stall, spin, and loss of control.NTSB CEN20CA230Accident · No injuriesClass 4 · Data collectionFinal reportRobinson R22 · El Campo, TXThe pilot's failure to maintain adequate clearance from the rice vegetation, which resulted in the helicopter's impact with terrain.NTSB WPR20CA179Accident · No injuriesClass 4 · Data collectionFinal reportAyres S2R · Lenore, IDThe pilot's failure to maintain clearance from power lines while maneuvering during an aerial application flight, which resulted in a wire strike.NTSB WPR20LA170Accident · 1 fatalClass 3 · LimitedFinal reportKitfox Kitfox · Lander, WYThe inexperienced pilot’s exceedance of the airplane’s critical angle-of-attack during a turn at high density altitude, which resulted in an accelerated stall and impact with water. Contributing to the accident was the pilot’s poor judgment to continue the…NTSB WPR20CA171Accident · Minor injuriesClass 4 · Data collectionFinal reportEnstrom 480 · Murphy, IDThe pilot's failure to maintain clearance from a power line while maneuvering during an aerial application flight.NTSB WPR20LA163Accident · 3 fatalClass 3 · LimitedFinal reportBell 206 · Fairfield, CAThe pilot’s failure to maintain adequate clearance from powerlines while conducting external load operations, which resulted in the main rotor contacting a wire and a subsequent collision with terrain.NTSB WPR20CA160Accident · No injuriesClass 4 · Data collectionFinal reportChampion 7ECA · Vine Grove, KYAircraft control was not maintained during initial climb with gusting wind that resulted in a collision with power lines and the terrain.NTSB ANC20CA049Accident · No injuriesClass 4 · Data collectionFinal reportCessna 185 · Palmer, AKThe pilot’s decision to attempt to " water ski" atop a remote river in a wheel-equipped airplane, resulting in a loss of control and a nose over.NTSB WPR20CA125Accident · Minor injuriesData collectionFinal reportCessna 172 · Yakima, WAThe pilot's failure to attain sufficient altitude during a go-around, which resulted in impact with hilly terrain.NTSB CEN20LA143Accident · 1 fatalClass 3 · LimitedFinal reportAir Tractor AT 502 · Pecan Gap, TXThe pilot did not maintain adequate clearance from tree, which resulted in a collision with a tree and subsequent impact with terrain.NTSB CEN20CA144Accident · No injuriesData collectionFinal reportRobinson R22 · Seymour, TXThe pilot's failure to maintain clearance from a tree while maneuvering at low altitude.NTSB CEN20CA139Accident · Serious injuriesData collectionFinal reportRans S-12 Airaile · Hillrose, COThe noncertificated pilot's diverted attention while looking at a fire during low-altitude flying, which resulted in a collision with power lines.NTSB CEN20LA442Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Sterling City, TXThe pilot’s failure to maintain clearance from power lines during an aerial application flight.NTSB ERA20CA131Accident · No injuriesData collectionFinal reportAmerican Legand AL18 · Social Circle, GAThe pilot's failure to maintain airplane control while maneuvering at low altitude, which resulted in the collision with terrain.NTSB ERA20CA128Accident · Minor injuriesData collectionFinal reportStolp Starduster Acroduster II SA750 · Senoia, GAThe pilot's failure to see and avoid trees while maneuvering at low altitude, which resulted in a loss of airplane control.NTSB WPR20CA092Accident · No injuriesData collectionFinal reportBell OH 58A · Colexico, CAThe pilot's failure to arrest the descent rate while maneuvering at low altitude, which resulted in impact with terrain.NTSB CEN20CA085Accident · No injuriesData collectionFinal reportRobinson R44 · Marfa, TXThe pilot's failure to maintain clearance from a fence during low-altitude maneuvering.NTSB ANC20CA018Accident · No injuriesData collectionFinal reportCessna 172 · Palmer, AKThe pilot's failure to maintain clearance from snow-covered terrain while maneuvering at low altitude.NTSB WPR20WA076Accident · 3 fatalClass 5 · ForeignLockheed C130 · Cooma, AustraliaNTSB ERA20LA094Accident · Serious injuriesClass 3 · LimitedFinal reportAirborne America AX9-140 · Homestead, FLThe pilot's decision to operate the balloon at low altitude near obstructions, structures, and powerlines, which resulted in the balloon contacting powerlines. Contributing to the accident was the Federal Aviation Administration's inadequate oversight of…NTSB WPR20WA037Accident · 1 fatalForeign investigationRobinson R44 · Eschowe, South AfricaThe government of South Africa has notified the NTSB of an accident involving a ROBINSON R44 helicopter that occurred on December 5, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of South Africa's investigation under…NTSB GAA20CA063Accident · Minor injuriesData collectionFinal reportSikorsky S 58JT · Lebanon, INThe pilot's failure to maintain proper clearance from a tractor trailer during landing.NTSB GAA20CA066Accident · No injuriesData collectionFinal reportAmerican AA 5 · Gilbert, SCThe pilot's improper approach path, which resulted in impact with a tree.NTSB ERA20FA027Accident · 1 fatalClass 3 · FieldFinal reportGrumman OV-1 · Stuart, FLThe pilot’s improper recovery from a low-altitude aerobatic maneuver, which resulted in descent into terrain.NTSB ERA20FA019Accident · 2 fatalClass 3 · FieldFinal reportMooney M20A · Summit Point, WVThe pilot’s decision to conduct a practice stall maneuver at low altitude, which resulted in inadequate altitude remaining in which to recover before impacting terrain.NTSB GAA20CA033Accident · No injuriesData collectionFinal reportWeatherly 620 · Fabens, TXThe pilot's failure to maintain clearance from power wires while maneuvering at a low altitude.NTSB ERA20FA012Accident · 1 fatalClass 3 · FieldFinal reportBell 206 · New Salem, NCThe pilot's inadequate visual lookout, which resulted in impact with a powerline.NTSB GAA20CA020Accident · Minor injuriesData collectionFinal reportAyres S2R · Willacoochee, GAThe pilot's failure to maintain clearance from power lines while maneuvering at low altitude.NTSB GAA20CA018Accident · Serious injuriesData collectionFinal reportFoxworthy Rick A Sonex · Langley, WAThe pilot's failure to maintain a proper approach path, which resulted in impact with a tree.NTSB CEN19LA316Accident · 1 fatalClass 3 · LimitedFinal reportInfinity Powered Parachutes IPP2 · Eustace, TXThe pilot’s failure to see and avoid a power line. Contributing was the pilot’s decision to fly at an altitude too low to avoid obstacles.NTSB ERA19LA263Accident · 1 fatalClass 3 · LimitedFinal reportWeatherly 620 · Russellville, ALThe pilot's failure to see and avoid powerlines during low-altitude agricultural spraying flight operations.NTSB WPR19FA246Accident · 3 fatalClass 3 · FieldFinal reportBeech 33 · St. Ignatius, MTThe pilot’s decision to maneuver the airplane at a low altitude, which resulted in impact with power lines and terrain.NTSB GAA19CA509Accident · Serious injuriesData collectionFinal reportRobinson R44 · Cypress Island, WAThe pilot's failure to maintain adequate clearance from a tree while maneuvering at a low altitude.