NTSB investigations, TX
102 cases where NTSB found Altitude.
Cases per year
| 2008 | 8 |
|---|---|
| 2009 | 1 |
| 2010 | 1 |
| 2011 | 4 |
| 2012 | 1 |
| 2013 | 2 |
| 2014 | 10 |
| 2015 | 8 |
| 2016 | 7 |
| 2017 | 7 |
| 2018 | 11 |
| 2019 | 7 |
| 2020 | 7 |
| 2021 | 7 |
| 2022 | 5 |
| 2023 | 6 |
| 2024 | 4 |
| 2025 | 3 |
| 2026 | 3 |
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 c.\"eventStateOrRegion\" = 'TX' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '01062012'))
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."eventStateOrRegion" = 'TX' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '01062012')) 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 CEN26LA196Accident · No injuriesClass 4 · LimitedFinal reportGuenther Glen A Searey LSX · Briarcliff, TXThe pilot's failure to maintain sufficient altitude and aircraft control during the base to final turn, which resulted in the airplane impacting the water. Contributing to the accident was reported downdraft wind conditions.NTSB CEN26LA159Accident · No injuriesClass 4 · LimitedFinal reportPiper PA46 · Burke, TXThe airplane’s encounter with unexpected low-level wind shear during final approach, which resulted in a hard impact with the runway.NTSB CEN26LA153Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R66 · Arlington, TXThe pilot’s failure to maintain clearance from terrain during the hover taxi.NTSB CEN26LA055Accident · Serious injuriesClass 4 · LimitedFinal reportJust Highlander · Brazos, TXThe pilot’s failure to maintain clearance from power lines during low-level maneuvering along a river.NTSB CEN25LA396Accident · No injuriesClass 4 · LimitedFinal reportBell 206 · Archer City, TXThe pilot’s failure to maintain clearance from power lines while herding livestock.NTSB CEN25LA155Accident · Serious injuriesClass 4 · LimitedFinal reportQuicksilver MX II · Brady, TXThe airplane’s encounter with a dust devil, which resulted in a loss of airplane control at a low altitude.NTSB CEN25LA067Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 · Galveston, TXThe pilot’s failure to maintain terrain clearance during the takeoff from the helipad in high and gusting wind conditions, that resulted in the right skid extension embedding in the artificial turf, and a subsequent dynamic rollover sequence.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 CEN24FA101Accident · 2 fatalClass 3 · FieldFinal reportLockwood AIR CAM · Ranchitos Las Lomas, TXThe pilot's failure to maintain clearance from a meteorological evaluation tower.NTSB CEN24FA089Accident · 3 fatalClass 3 · FieldFinal reportCessna 310R · Poolville, TXPilot incapacitation for undetermined reasons which resulted into controlled descent into terrain.NTSB CEN24FA073Accident · 1 fatalClass 3 · FieldFinal reportCirrus Design SR22 · Canton, TXThe pilot’s failure to attain the runway while landing at night, which resulted in an impact with trees.NTSB CEN24LA061Accident · No injuriesClass 3 · LimitedFinal reportCessna 421C · McGregor, TXThe failure of the spring pin in the right propeller governor, which precluded the pilot from controlling the propeller pitch to maintain engine rpm, resulting in a loss of engine thrust, excessive drag, and the subsequent forced landing to a field.NTSB WPR23LA183Accident · No injuriesClass 3 · LimitedFinal reportAero Vodochody L-39ZA · Barnhart, TXA total loss of engine power due to water-contaminated fuel from an undetermined source.NTSB CEN23FA125Accident · 2 fatalClass 3 · FieldFinal reportRobinson Helicopter R44 · Port O'Connor, TXThe pilot’s initiation of the visual flight into instrument meteorological conditions, which resulted in spatial disorientation and a subsequent loss of helicopter control. Contributing to the accident was the pilot’s flicker vertigo during the flight.NTSB CEN23FA084Accident · 4 fatalClass 3 · FieldFinal reportPiper PA46 · Yoakum, TXThe pilot’s spatial disorientation during a missed approach in instrument meteorological conditions, which led to an exceedance of the airplane’s critical angle of attack and a subsequent aerodynamic stall.NTSB CEN23LA086Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 · Fowlerton, TXThe pilot’s failure to maintain clearance with trees, which resulted in an uncontrollable spin due to tail rotor damage.NTSB CEN23LA047Accident · Minor injuriesClass 4 · LimitedFinal reportSeace David A Gyroplane · Iredell, TXThe pilot's failure to maintain clearance from a power line during low-level maneuvering.NTSB CEN23LA024Accident · No injuriesClass 4 · LimitedFinal reportCessna 170A · Hardin, TXThe pilot’s failure to maintain clearance from the powerlines while landing.NTSB CEN22FA299Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-32-300 · Mount Pleasant, TXThe pilot’s failure to maintain the proper glidepath while on final approach in night visual conditions, which resulted in a collision with trees.NTSB CEN22FA288Accident · 1 fatalClass 3 · FieldFinal reportRobinson Helicopter R44 II · Blackwell, TXThe pilot’s failure to maintain proper altitude and clearance during low-level aerial application, resulting in an in-flight collision with power lines.NTSB CEN22LA108Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-150 · Lamesa, TXThe pilot’s failure to maintain clearance from terrain during a descent that resulted in an impact with terrain.NTSB CEN22LA091Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-28-235 · Presidio, TXThe non-certificated pilot’s failure to perform a preflight weight and balance calculation and his decision to operate the airplane beyond the allowable center of gravity limitations, which resulted in a loss of control and impact with terrain.NTSB CEN22LA088Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing A75N1(PT17) · Rainbow, TXThe pilot’s improper decision to conduct an intentional low altitude flight which resulted in a collision with wires and impact with terrain.NTSB CEN22LA034Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Fort Davis, TXThe pilot’s encounter of a downdraft from which there was insufficient altitude to recover.NTSB CEN22LA033Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Freer, TXThe pilot’s encounter with ‘settling with power’ while maneuvering at a low altitude, which resulted in a rapid descent and subsequent hard landing.NTSB CEN21FA410Accident · 1 fatalClass 3 · FieldFinal reportRobinson Helicopter R22 Beta · Mentone, TXThe pilot’s failure to maintain clearance from powerlines while maneuvering at low altitude.NTSB CEN21LA167Accident · Serious injuriesClass 3 · LimitedFinal reportBeech 35 · Bridgeport, TXThe pilots’ failure to maintain adequate airspeed during a simulated power-off approach in gusting wind conditions, which resulted in an exceedance of the airplane’s critical angle of attack, an aerodynamic stall, and loss of control.NTSB CEN21LA139Accident · No injuriesClass 4 · LimitedFinal reportHughes 369 · Kaufman, TXThe pilot’s failure to maintain clearance from a power line during low-level maneuvering.NTSB CEN21LA080Accident · 1 fatalClass 3 · LimitedFinal reportVans RV6 · Hitchcock, TXThe pilot’s impairment by the effects of ingested alcohol, which resulted in the loss of airplane control and impact with terrain.NTSB CEN21LA077Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Marietta, TXThe pilot’s failure to see and avoid a transmission wire during takeoff.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 CEN20CA144Accident · No injuriesData collectionFinal reportRobinson R22 · Seymour, TXThe pilot's failure to maintain clearance from a tree while maneuvering at low altitude.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 CEN20CA085Accident · No injuriesData collectionFinal reportRobinson R44 · Marfa, TXThe pilot's failure to maintain clearance from a fence during low-altitude maneuvering.NTSB WPR20FA067Accident · 1 fatalClass 3 · FieldFinal reportCessna 150 · Jacksonville, TXThe pilot’s failure to maintain clearance from guy wires associated with a tower while maneuvering at low altitude.NTSB GAA20CA013Accident · No injuriesData collectionFinal reportSocata TBM700 · Breckenridge, TXThe pilot's failure to maintain bank control and adequate altitude during the approach, which resulted in his failure to maintain the runway heading and a subsequent collision with trees and terrain.NTSB CEN20TA007Accident · Serious injuriesFinal reportAutoGyro MTO Sport · Montgomery, TXThe pilot's failure to maintain clearance from trees during departure. Contributing to the accident was the pilot's inadequate preflight assessment of the field for takeoff.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 CEN19LA245Accident · No injuriesClass 3 · LimitedFinal reportRobinson R22 · Water Valley, TXThe loss of helicopter performance for undetermined reasons.NTSB GAA19CA277Accident · Serious injuriesData collectionFinal reportGrumman G164 · Pearsall, TXThe pilot's failure to maintain clearance from power lines during low-altitude maneuvering.NTSB GAA19CA270Accident · No injuriesData collectionFinal reportGrumman G164 · Lane City, TXThe pilot's failure to maintain clearance from power lines during low-altitude maneuvering.NTSB GAA19CA216Accident · No injuriesData collectionFinal reportBell 47G · Donna, TXThe pilot's failure to maintain altitude during an agricultural application flight.NTSB CEN19LA070Accident · No injuriesLimited investigationFinal reportCessna 172 · Abilene, TXThe pilot's failure to see and avoid a cell tower wire during a pipeline patrol flight. Contributing to the accident was the pilot's distraction due to writing down observations about the pipeline while flying.NTSB CEN19FA024Accident · 3 fatalField investigationFinal reportBell 206 · Uvalde, TXThe pilot's controlled flight into terrain during night visual meteorological conditions. Contributing to the accident was the pilot improper decision to inhibit the helicopter's terrain warning systems and flight at low altitude.NTSB CEN18FA267Accident · 2 fatalField investigationFinal reportKolb Twinstar · La Porte, TXThe pilot's failure to maintain airspeed during a visual approach for landing, which resulted in an exceedance of the airplane's critical angle of attack and a subsequent aerodynamic stall at an altitude too low for recovery.NTSB GAA18CA382Accident · No injuriesData collectionFinal reportPzl-Swidnik PW 5 · Waller, TXThe glider pilot’s failure to maintain clearance from trees during landing.NTSB CEN18LA183Accident · Serious injuriesLimited investigationFinal reportHughes 369A · Stoneburg, TXThe pilot's unsafe and aggressive operation of the helicopter at low altitude, which resulted in impact with trees.NTSB GAA18CA347Accident · No injuriesData collectionFinal reportPiper PA28 · Pine Spring, TXThe pilot’s failure to maintain adequate altitude while flying over mountainous terrain in turbulent wind conditions at night, which resulted in a tree strike.NTSB CEN18FA147Accident · 2 fatalField investigationFinal reportNorth American SNJ 5 · Kingsville, TXThe pilot's failure to maintain airspeed during a steep turn after takeoff, resulting in an exceedance of the airplane's critical angle of attack and a subsequent accelerated stall at an altitude too low for recovery.NTSB GAA18CA247Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · Sonora, TXThe pilot’s failure to maintain clearance from trees while maneuvering at a low altitude.