NTSB investigations
794 cases where the sequence of events included 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '220' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\")) 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '220' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 ANC10LA065Accident · Serious injuriesLimited investigationFinal reportCessna 170B · Palmer, AKThe pilot's decision to make a low-altitude pass over a remote airstrip toward rising terrain in weather conducive to downdrafts.NTSB CEN10LA418Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Clyde, OHThe pilot's failure to maintain clearance from a grain auger during aerial application maneuvers.NTSB CEN10CA411Accident · Minor injuriesData collectionFinal reportContinental Copters Tomcat MK6B · Blackstone, ILThe helicopter encountered a dust devil at a low altitude during the aerial application flight.NTSB CEN10CA402Accident · No injuriesData collectionFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Independence, IAThe pilot's failure to pay attention to the power lines and his subsequent failure to maintain clearance from the corn field during the aerial application flight.NTSB ANC10CA060Accident · No injuriesData collectionFinal reportCessna 172N · Palmer, AKThe pilot's decision to fly towards rising terrain that exceeded the climb capability of the airplane.NTSB CEN10CA391Accident · No injuriesData collectionFinal reportAir Tractor AT602 · Lake Village, ARThe pilot's failure to maintain clearance from the wires during the aerial application pass.NTSB CEN10CA406Accident · No injuriesData collectionFinal reportWSK PZL Mielec M-18A · Muncie, INThe pilot's failure to see and avoid the power line during an aerial application flight.NTSB CEN10CA395Accident · No injuriesData collectionFinal reportBell OH-58A · Roswell, NMThe pilot's failure to maintain clearance from transmission wires.NTSB CEN10LA380Accident · Minor injuriesLimited investigationFinal reportChampion 8KCAB · Estes Park, COThe pilot's decision to fly at a low altitude in mountainous terrain and weather conditions conducive to downdrafts.NTSB ERA10LA348Accident · 1 fatalLimited investigationFinal reportRobinson Helicopter R44 · Marion, KYThe pilot's failure to maintain clearance from power lines during an aerial application flight.NTSB WPR10CA320Accident · No injuriesData collectionFinal reportCessna 175 · Huntsville, UTThe pilot's failure to maintain adequate clearance from terrain during climb.NTSB ANC10LA053Accident · 1 fatalLimited investigationFinal reportRobinson Helicopter R44 · Unalaska, AKThe pilot's inappropriate low altitude maneuvering, which resulted in a collision with terrain.NTSB WPR10CA289Accident · Serious injuriesData collectionFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Courtland, CAThe pilot's failure to maintain clearance from terrain during low-altitude maneuvers.NTSB ERA10CA309Accident · No injuriesData collectionFinal reportAir Tractor AT-402B · Alcolu, SCThe pilot’s failure to maintain clearance from a tree. Contributing to the accident was the sunglare.NTSB CEN10FA310Accident · 1 fatalField investigationFinal reportAir Tractor AT602 · Knobel, ARThe pilot did not maintain control of the airplane while maneuvering at low altitude.NTSB CEN10CA307Accident · No injuriesData collectionFinal reportChampion 7ECA · Northwood, NDThe pilot’s failure to maintain adequate clearance from the transmission wire.NTSB WPR10CA279Accident · Minor injuriesData collectionFinal reportCessna 172H · Bountiful, UTThe pilot’s failure to maintain clearance from terrain. Contributing to the accident was the high density altitude.NTSB CEN10CA286Accident · Minor injuriesData collectionFinal reportCessna 150M · Glasco, KSThe pilot’s delay in applying full power to arrest a sink rate at low altitude.NTSB CEN10CA268Accident · Serious injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Pearsall, TXThe pilot's failure to see and avoid the power lines.NTSB CEN10LA250Accident · 1 fatalLimited investigationFinal reportAyres S2R · Rushville, NEThe pilot did not maintain clearance from a power line while maneuvering at low altitude.NTSB ERA10LA266Accident · 2 fatalLimited investigationFinal reportAerostar S A YAK-52 · Jensen Beach, FLThe pilot's decision to perform an aerobatic maneuver at a low altitude, which resulted in insufficient clearance from the water to conduct a recovery. Contributing to the accident was the airplane’s extended landing gear, which resulted in a degradation of…NTSB CEN10CA251Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · Baraboo, WIThe pilot's failure to maintain clearance with crops while maneuvering during aerial application.NTSB ANC10FA038Accident · 1 fatalField investigationFinal reportPiper PA-18-135 · Willow, AKThe pilot's failure to maintain clearance from a tree due to the effects of impairment from alcohol consumption.NTSB WPR10FA228Accident · 1 fatalField investigationFinal reportCessna U206G · Yuma, AZThe pilot's loss of situational awareness and failure to maintain aircraft control while maneuvering at low altitude. Contributing to the accident was glare from the rising sun.NTSB CEN10LA184Accident · 1 fatalLimited investigationFinal reportStutesman Charles Lee RV-6 · Balmorhea, TXThe pilot's failure to maintain clearance from the lake while maneuvering at low altitude.NTSB CEN10CA185Accident · Minor injuriesData collectionFinal reportAir Tractor AT-301 · Malden, MOThe pilot's failure to maintain clearance from a tree during an aerial application flight.NTSB CEN10CA179Accident · Minor injuriesData collectionFinal reportCessna 182M · Hamilton, TXThe pilot’s failure to maintain clearance from a static power line while maneuvering at a low altitude.NTSB WPR10FA162Accident · 2 fatalField investigationFinal reportNorth American AT6 · Bakersfield, CAThe pilots did not maintain clearance from terrain for undetermined reasons.NTSB WPR10FA131Accident · 2 fatalField investigationFinal reportYakovlev YAK 52 · Redlands, CAThe pilot's failure to maintain aircraft control and altitude sufficient to recover from a low-level aerobatic maneuver.NTSB WPR10CA124Accident · Serious injuriesData collectionFinal reportPiper PA-28-235 · Crystal, NVThe pilot's failure to maintain clearance from a ground vehicle during a low-altitude maneuver.NTSB CEN10FA162Accident · No injuriesField investigationFinal reportMaule M-6-235 · Bennett, COThe pilot’s failure to maintain clearance from a utility line while maneuvering.NTSB CEN10LA074Accident · Serious injuriesLimited investigationFinal reportGibson Mark Manta 503 · Magnolia, TXThe pilot's failure to maintain clearance from a static wire while maneuvering and his improper decision to fly with a low overcast sky.NTSB WPR10LA069Accident · Serious injuriesLimited investigationFinal reportMahre Starduster SA300 · Zillah, WAThe pilot’s failure to maintain aircraft control during a low-altitude maneuver.NTSB CEN10LA043Accident · 2 fatalLimited investigationFinal reportMoore Skybolt/BM · Altus, OKThe pilot's poor judgment by performing intentional low-level maneuvers that resulted in an inadvertent stall/spin at an altitude to low to affect a safe recovery.NTSB ERA10CA046Accident · Minor injuriesData collectionFinal reportAmerican AA1 · Lake Placid, FLThe pilot's failure to maintain clearance from a power line.NTSB CEN10LA035Accident · Serious injuriesLimited investigationFinal reportBlanik L-13 · Middlefield, OHThe student pilot's improper control inputs which resulted in the inadvertent stall of the glider.NTSB ERA10FA027Accident · 2 fatalField investigationFinal reportCessna U206G · Elizabethton, TNThe pilot’s failure to remain clear of rising terrain while maneuvering at low altitude.NTSB ANC10FA004Accident · 1 fatalField investigationFinal reportCessna A185E · Healy, AKThe pilot's decision to maneuver at a low altitude over rising terrain in conditions conducive to turbulence/downdrafts, resulting in a loss of control and impact with terrain.NTSB WPR10FA012Accident · 1 fatalField investigationFinal reportMcdonnell Douglas Heli 369FF · Fossil, ORThe pilot's failure to maintain clearance from a power pole to which he was connecting wire-pulling ropes.NTSB CEN10CA010Accident · Serious injuriesData collectionFinal reportAerostar International RX-7 · Albuquerque, NMThe pilot’s failure to maintain adequate clearance from a known obstacle and the pilot’s failure to maintain control of the balloon during the sudden climb following the ejection of the passenger.NTSB CEN10TA006Accident · No injuriesFinal reportBeech E18S · Jones Creek, TXThe pilot's failure to see and avoid the radio tower.NTSB WPR09CA470Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R44 II · Mt Charleston, NVThe pilot's failure to maintain aircraft control and terrain clearance while maneuvering at a low altitude above high terrain. Contributing to the accident was a downdraft and high density altitude.NTSB CEN09CA540Accident · Minor injuriesData collectionFinal reportAir Tractor AT-502 · East Grand Forks, MNThe pilot's failure to maintain clearance with the crops while maneuvering at low altitude.NTSB WPR09CA403Accident · No injuriesData collectionFinal reportRockwell 690 · Wenatchee, WAThe pilot’s failure to maintain situational awareness, and thus clearance from objects, while operating at low altitude.NTSB CEN09LA523Accident · 2 fatalLimited investigationFinal reportFrom Here To There PDQ RV-8 · Tea, SDThe pilot's failure to maintain control of the airplane during recovery from an aerobatic maneuver.NTSB CEN09CA528Accident · No injuriesData collectionFinal reportMorse, Frank L. Kitfox · Crawford, COThe pilot's continued flight into a severe downdraft at low altitude after encountering tailwind over the area.NTSB CEN09CA514Accident · Minor injuriesData collectionFinal reportAir Tractor AT-301 · DeWitt, ILThe pilot's failure to maintain clearance from the tree during the aerial application maneuver.NTSB ERA09LA450Accident · 2 fatalLimited investigationFinal reportStump Bradley Kolb · Calhoun, TNThe pilot’s decision to perform aerobatics at a low altitude and his failure to maintain control of the airplane while performing aerobatics.NTSB CEN09LA488Accident · Serious injuriesLimited investigationFinal reportPiontkowski Challenger · Kankakee, ILThe pilot's failure to maintain clearance from the telephone line and his poor judgment to fly while under the influence of alcohol. Contributing to the accident was the pilot's impairment due to the alcohol consumption.NTSB CEN09CA483Accident · Minor injuriesData collectionFinal reportPiper PA-25-235 · Royal, IAThe pilot's failure to maintain clearance from the crop during an aerial application maneuver.