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 ANC25LA023Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Cantwell, AKThe pilot’s failure to maintain altitude during a low-altitude maneuver which resulted in inadvertent ground contact and a nose over.NTSB WPR25FA100Accident · 1 fatalClass 3 · FieldFinal reportBell Helicopter Textron Canada 505 · Ririe, IDThe pilot’s inadequate preflight planning and decision to maneuver the helicopter at a low altitude, and his subsequent failure to maintain clearance from power lines.NTSB GAA25WA099Accident · 2 fatalClass 5 · ForeignVans RV7 · Nizhny Novgorodr, RussiaNTSB GAA25WA089Accident · Minor injuriesClass 5 · ForeignPiper PA25 · Santa Cruz, HondurasNTSB GAA25WA247Accident · Serious injuriesClass 3 · ForeignEmbraer EMB203 · Correntina, BrazilNTSB WPR25LA078Accident · No injuriesClass 4 · LimitedFinal reportBell 206A · Lemoore, CAThe pilot’s failure to maintain clearance from power lines while maneuvering at a low altitude.NTSB CEN25LA075Accident · 1 fatalClass 3 · LimitedFinal reportBellanca 7GCBC · Batesville, ARThe pilot’s failure to maintain clearance from powerlines while flying at low altitude.NTSB WPR25LA056Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-12 · Marysvale, UTThe pilot’s failure to maintain clearance from snow covered terrain while maneuvering at low altitude.NTSB CEN25FA019Accident · 4 fatalClass 2 · FieldFinal reportRobinson R44 · Houston, TXThe pilot’s failure to maintain clearance from a lighted radio tower during a visual night flight. Contributing to the accident was the air traffic controller’s failure to issue a safety alert notifying the pilot of the flight’s unsafe proximity to the tower.NTSB GAA25WA281Accident · Serious injuriesClass 4 · ForeignAir Tractor AT-504 · Gizan, Saudi ArabiaNTSB WPR24LA315Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 172P · Kooskia, IDThe pilot’s decision to descend into a canyon that exceeded the performance capabilities of the airplane, which resulted in an impact with trees and terrain.NTSB CEN24LA368Accident · Serious injuriesClass 4 · LimitedFinal reportBell 206 · Lexington, NEThe pilot’s failure to maintain proper clearance from powerlines.NTSB ERA24LA393Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Ravenel, SCThe pilot’s failure to maintain clearance from terrain, which resulted in the right skid contacting the ground and a subsequent rollover.NTSB CEN24FA338Accident · 1 fatalClass 3 · FieldFinal reportAir Tractor AT-602 · Camden, COThe pilot’s failure to maintain adequate clearance from a power transformer that was mounted to a power pole during an aerial application flight.NTSB ANC24LA083Accident · No injuriesClass 4 · LimitedFinal reportPiper PA22 · Aleknagik, AKThe pilot’s failure to maintain clearance from terrain while maneuvering at low altitude.NTSB WPR24LA282Accident · Serious injuriesClass 4 · LimitedFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Durham, CAThe pilot’s failure to maintain clearance from powerlines, which resulted in a wire strike.NTSB CEN24FA287Accident · 1 fatalClass 3 · FieldPreliminary reportBell 206 · Nashua, IAOn July 29, 2024 about 1330 central standard time, a Bell 206-B3 Helicopter, N94XA, was destroyed when it was involved in an accident near Nashua, Iowa. The pilot was fatally injured. The helicopter was operated as a Title 14 Code of Federal Regulations Part…NTSB WPR24FA255Accident · 1 fatalClass 3 · FieldFinal reportAir Tractor AT-802A · Izee, ORThe pilot’s controlled flight into terrain while maneuvering through an area of low visibility due to wildfire smoke and haze.NTSB CEN24LA285Accident · Serious injuriesClass 4 · LimitedFinal reportCessna A188B · Sumner, NEThe pilot’s failure to maintain clearance from a power line during the spray pass.NTSB CEN24LA276Accident · No injuriesClass 4 · LimitedFinal reportBell 206 · Cornland, ILThe pilot was unable to see a wire due to the setting sun and the helicopter subsequently struck the wire.NTSB CEN24LA275Accident · Minor injuriesClass 4 · LimitedFinal reportBell 206B · Cuba City, WIThe pilot’s failure to maintain clearance from a wire during an agricultural application pass.NTSB ERA24LA314Accident · No injuriesClass 4 · LimitedFinal reportBell OH-58A · Hegins, PAThe pilot’s inadequate pre-flight and in-flight planning, which resulted in the helicopter striking a wire hazard during an aerial application flight.NTSB CEN24LA257Accident · Minor injuriesClass 4 · LimitedFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Sedgwick, ARThe pilot’s failure to maintain clearance from a power line during the spray pass.NTSB CEN24LA252Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · New Florence, MOThe pilot’s failure to maintain proper altitude/clearance from a dead tree limb during an aerial application flight.NTSB WPR24FA213Accident · 1 fatalClass 3 · FieldFinal reportGrumman Acft ENG Cor-Schweizer G-164A · Chamberino, NMAn aerodynamic stall and loss of control for reasons that could not be determined based on the available information.NTSB CEN24LA318Accident · No injuriesClass 3 · LimitedFinal reportAyres S2R · Stanwood, MIThe pilot’s failure to maintain terrain clearance during a low-level aerial application flight, which resulted in impact with terrain and a subsequent forced landing. Contributing to the accident was the location of the spray boom pressure gauge, which…NTSB WPR24LA207Accident · Serious injuriesClass 4 · LimitedFinal reportPiper J3C-65 · Scheelite, CAThe pilot’s inadvertent entry to a box canyon where the airplane could not outclimb the rising terrain.NTSB WPR24LA187Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Garrett, WYThe pilot’s failure to maintain clearance from terrain while conducting low-level altitude operations, following an encounter with wake turbulence.NTSB WPR24FA184Accident · 1 fatalClass 3 · FieldFinal reportBeech A45 · Deer Harbor, WAThe pilot’s decision to perform an aerobatic maneuver at low level, and his misjudged entry altitude for the maneuver, which resulted in impact with water.NTSB WPR24LA173Accident · No injuriesClass 4 · LimitedFinal reportSikorsky S-55QT · Benton City, WAThe pilot’s failure to maintain clearance from power lines during a low altitude operation.NTSB CEN24LA209Accident · Serious injuriesClass 4 · LimitedFinal reportArbc Inc DBA Lindstrand 90A · Hebron, INThe pilot’s failure to maintain clearance from powerlines while landing in a field.NTSB CEN24LA205Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Palmyra, MOThe pilot’s failure to maintain clearance from power lines during approach.NTSB ERA24LA220Accident · Minor injuriesClass 4 · LimitedFinal reportAir Tractor AT-602 · New Washington, OHThe pilot’s failure to maintain clearance from powerlines during an aerial application flight.NTSB WPR24FA150Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-18-150 · Thurlow, MTThe pilot’s exceedance of the airplane’s critical angle of attack while maneuvering at low altitude, resulting in an aerodynamic stall and subsequent impact with terrain. Contributing to the accident was the pilot’s distraction by his cell phone use while…NTSB WPR24LA138Accident · Minor injuriesClass 4 · LimitedFinal reportAerospatiale SA315B · Lewiston, IDThe pilot’s failure to maintain clearance from power lines during a low level aerial application.NTSB CEN24LA175Accident · Serious injuriesClass 4 · LimitedFinal reportAir Tractor AT-802A · England, ARThe pilot’s failure to maintain clearance from tower guy wires while maneuvering during a low-level aerial application flight.NTSB ERA24LA172Accident · No injuriesClass 4 · LimitedFinal reportMD Helicopters 369FF · Ceiba, PRThe pilots’ failure to ensure adequate clearance from the taxiway while performing a quick stop maneuver.NTSB ERA24LA171Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · South Kingstown, RIThe pilot’s failure to maintain clearance from the water while maneuvering at low altitude.NTSB WPR24LA113Accident · Minor injuriesClass 4 · LimitedFinal reportKitfox S7 Super Sport · Asotin, WAPilot’s failure to maintain clearance from powerlines during low altitude flying.NTSB WPR24LA115Accident · Minor injuriesClass 4 · LimitedFinal reportZenith Zodiac CH601 · Rawlins, WYThe student pilot’s failure to see and avoid powerlines during an unstabilized approach, which resulted the airplane landing short of the runway and coming to rest inverted.NTSB ANC24LA015Accident · No injuriesClass 4 · LimitedFinal reportCessna R172K · Trapper Creek, AKThe pilot’s exceedance of the airplane’s critical angle of attack while maneuvering at low altitude, which resulted in an aerodynamic stall; loss of airplane control; and impact with terrain.NTSB ERA24LA114Accident · 1 fatalClass 3 · LimitedFinal reportCessna 172M · Brookwood, ALThe pilot’s failure to see and avoid powerlines while maneuvering at low altitude.NTSB GAA24WA093AccidentClass 5 · ForeignAir Tractor AT-502 · Bourke, AustraliaNTSB CEN24FA101Accident · 2 fatalClass 3 · FieldFinal reportLockwood AIR CAM · Ranchitos Las Lomas, TXThe pilot's failure to maintain clearance from a meteorological evaluation tower.NTSB ERA24LA060Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Mount Vernon, ALThe pilot’s decision to operate the airplane at a low altitude over a river, and his failure to maintain clearance from the river while maneuvering.NTSB WPR24LA092Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Calexico, CAThe pilot's failure to maintain clearance from power lines during an aerial application flight.NTSB CEN24FA049Accident · 2 fatalClass 3 · FieldFinal reportMD Helicopters 600 · Sterling City, TXThe pilot’s failure to maintain clearance from a power line pole’s static arm during forecasted gusting wind conditions, un-forecasted light turbulence, and un-forecasted low-level wind shear conditions, resulting in main rotor blade contact with the static…NTSB CEN24LA029Accident · No injuriesClass 4 · LimitedFinal reportAg-Cat G-164B · Abbeville, LAThe pilot’s failure to maintain clearance from a power line during an aerial application flight.NTSB CEN24FA021Accident · 1 fatalClass 3 · FieldFinal reportAir Tractor AT-502B · Vidalia, LAThe pilot’s failure to maintain clearance from power lines during an aerial application flight. Contributing to the accident was the pilot’s cell phone use and the position of the sun, which reduced the pilot’s ability to perceive the location of the power…NTSB CEN24LA006Accident · 1 fatalClass 3 · LimitedFinal reportGyro Technic GT-VX2 · Saint Peter, MNThe pilot's failure to maintain clearance from power lines during low-level maneuvering through a river valley.