NTSB investigations, 2010
56 cases where the sequence of events included Low altitude operation/event.
Cases per year
| 2008 | 58 |
|---|---|
| 2009 | 55 |
| 2010 | 56 |
| 2011 | 42 |
| 2012 | 41 |
| 2013 | 47 |
| 2014 | 36 |
| 2015 | 34 |
| 2016 | 32 |
| 2017 | 40 |
| 2018 | 34 |
| 2019 | 53 |
| 2020 | 48 |
| 2021 | 46 |
| 2022 | 39 |
| 2023 | 39 |
| 2024 | 37 |
| 2025 | 35 |
| 2026 | 22 |
Where
Open the mapLatest cases
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 year(c.\"eventDate\") = 2010
AND 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 year(c."eventDate") = 2010 AND 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 WPR11TA083Accident · No injuriesFinal reportQuest Kodiak 100 · Reedsport, ORThe pilot's failure to maintain clearance from power lines during a low-level aerial observation flight. Contributing to the accident was pilot's failure to review a route hazards map prior to initiating the flight.NTSB ERA11LA083Accident · Minor injuriesLimited investigationFinal reportBell 206B · Isom, KYThe pilot's failure to maintain clearance from a known wire hazard during an aerial observation flight.NTSB ERA11CA082Accident · Serious injuriesData collectionFinal reportBell 206L-3 · Canal Point, FLThe pilot's failure to maintain clearance from the ground while maneuvering at a low altitude. Contributing to the accident was the pilot’s fatigue.NTSB WPR11LA056Accident · No injuriesLimited investigationFinal reportBell 407 · Riverdale, UTThe pilot's failure to maintain clearance from a highway marker sign while maneuvering.NTSB CEN11TA064Accident · Minor injuriesFinal reportPartenavia P.68 · Anthony, NMThe pilot's decision to conduct a low-level flight in mountainous terrain in an area where downdrafts were prevalent, resulting in the inadvertent loss of control and the collision with the terrain.NTSB WPR11CA041Accident · No injuriesData collectionFinal reportAviat A-1B · Heber City, UTThe pilot's failure to maintain clearance from the ground during low-level maneuvering in mountainous/hilly terrain.NTSB CEN11FA053Accident · 1 fatalField investigationFinal reportBell 206 · Meeker, COThe pilot's failure to maintain clearance from electrical power lines during the low-altitude flight.NTSB WPR11FA027Accident · 2 fatalField investigationFinal reportReed Glasair III SH-3R · Lake Mathews, CAThe pilot’s failure to maintain clearance from terrain while maneuvering at low altitude beneath a cloud layer.NTSB WPR11LA016Accident · No injuriesLimited investigationFinal reportBell 206B · Auburn, CAThe pilot's failure to maintain clearance from a transmission line during flight.NTSB WPR11CA011Accident · Serious injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Long Beach, CAThe student pilot's failure to maintain an adequate drift control and skid clearance from the ground and the CFI's inadequate supervision while hovering, resulting in dynamic rollover.NTSB WPR11FA005Accident · 2 fatalField investigationFinal reportCessna 172 · Panguitch, UTThe pilot's decision to conduct a low-level flight into a canyon in windy conditions at a high density altitude, which resulted in a collision with trees and terrain.NTSB CEN11CA011Accident · Minor injuriesData collectionFinal reportCessna 175C · Humphrey, ARThe pilot’s failure to maintain clearance from a static wire while maneuvering at a low altitude.NTSB WPR10CA466Accident · Minor injuriesData collectionFinal reportHiller UH-12E · Mecca, CAThe pilot's failure to maintain clearance from an obstacle while maneuvering.NTSB CEN10CA553Accident · Serious injuriesData collectionFinal reportGulfstream-Schweizer A/C Gulfstream AM G-164B · Blessing, TXThe pilot's failure to maintain clearance from wires while maneuvering.NTSB ANC10CA096Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Chicken, AKThe pilot's decision to fly at a low altitude in terrain and weather conditions conducive to turbulence and downdrafts.NTSB CEN10CA536Accident · No injuriesData collectionFinal reportCessna A188B · Hondo, TXThe pilot’s delayed action to arrest the airplane’s descent, which resulted in a collision with terrain.NTSB WPR10CA439Accident · Serious injuriesData collectionFinal reportAyres S2R-G10 · Ligurta, AZThe pilot's failure to maintain clearance from rising terrain. Contributing to the accident was the pilot's decision to orient the application tracks so that they did not provide the maximum possible clearance from the rising terrain, and, the predawn…NTSB WPR10CA410Accident · No injuriesData collectionFinal reportGulfstream-Schweizer A/C Gulfstream AM G-164B · Genesee, IDThe pilot’s failure to maintain clearance from terrain during low-altitude maneuvering.NTSB CEN10RA579Accident · 1 fatalForeign investigationZivko Aeronautics Edge 540 · Toledo, SpainimportNTSB WPR10LA406Accident · Serious injuriesLimited investigationFinal reportBellanca 7GCBC · Douglas, WYThe pilot's failure to maintain clearance from the terrain while maneuvering during an aerial observation flight.NTSB WPR10FA399Accident · 2 fatalField investigationFinal reportPiper PA28R · Emigrant Gap, CAThe pilots’ failure to maintain sufficient altitude to clear terrain while maneuvering. Contributing to the accident was the flight instructor’s delayed remedial action.NTSB CEN10CA454Accident · No injuriesData collectionFinal reportPiper PA-36-285 · Petersburg, TXThe pilot's failure to maintain clearance from a signpost during an aerial application flight.NTSB CEN10CA446Accident · Minor injuriesData collectionFinal reportBell 206 · St. Olaf, IAThe pilot's failure to maintain clearance from wires during the agricultural flight.NTSB CEN10CA445Accident · Minor injuriesData collectionFinal reportAir Tractor AT-502B · Zwingle, IAThe pilot's failure to maintain clearance from wires during the agricultural flight.NTSB CEN10CA428Accident · No injuriesData collectionFinal reportBell 206B · New Hampton, IAThe pilot's failure to maintain clearance from wires.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.