NTSB investigations, TX
11 cases where the defining event was Abrupt maneuver.
Cases per year
| 2010 | 1 |
|---|---|
| 2012 | 1 |
| 2014 | 2 |
| 2015 | 1 |
| 2016 | 1 |
| 2018 | 3 |
| 2021 | 1 |
| 2025 | 1 |
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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '270')
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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '270') 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 ERA26FA010Accident · 2 fatalClass 3 · FieldPreliminary reportBeech C90 · Fort Worth, TXOn October 12, 2025, about 1334 central daylight time, a Beech C90, N291CC, was destroyed when it was involved in an accident near Fort Worth, Texas. The private pilot and pilot-rated passenger were fatally injured. The airplane was operated as a Title 14…NTSB CEN22LA008Accident · 1 fatalClass 3 · LimitedFinal reportSea & Sky Krucker Cygnet · Point Venture, TXThe pilot’s abrupt pitch up maneuver in response to the localized wind conditions which resulted in an aerodynamic stall at low altitude and subsequent impact with water.NTSB GAA19CA011Accident · Minor injuriesData collectionFinal reportBeech 55 · San Antonio, TXThe pilot's improper takeoff trim setting and failure to properly secure his seatbelt, which resulted in a loss of airplane control. Contributing to the accident was the pilot's failure to follow the Before Takeoff checklist.NTSB GAA18CA507Accident · Minor injuriesData collectionFinal reportVans RV10 · Spring Branch, TXThe pilot's failure to maintain the proper glidepath and his subsequent abrupt maneuver to avoid trees, which led to the exceedance of the airplane's critical angle of attack and resulted in an aerodynamic stall during landing and a subsequent loss of…NTSB GAA18CA168Accident · Minor injuriesData collectionFinal reportHughes 269 · San Antonio, TXThe pilot’s decision to relinquish the helicopter flight controls to a non-rated passenger during a 3 ft hover.NTSB GAA16CA283Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · Spring Branch, TXThe pilot's failure to maintain helicopter control while hovering in gusting tailwind conditions, resulting in the tailboom striking a light pole and impact with terrain.NTSB GAA15CA154Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Eagle Lake, TXThe pilot's failure to secure the iPad during flight, resulting in an inadvertent cyclic input, and collision with terrain.NTSB CEN14CA409Accident · Minor injuriesData collectionFinal reportGlasflugel H 301 B Libelle · Brenham, TXThe pilot's attempt to maneuver away from power lines during a forced landing, which resulted in a collision with a tree and a fence.NTSB CEN14CA280Accident · Minor injuriesData collectionFinal reportSchempp-Hirth Nimbus 3/24.5 · Wallis, TXThe pilot's failure to maintain direction control of the glider during takeoff in gusty wind conditions.NTSB CEN12FA378Accident · 4 fatalField investigationFinal reportIar Brasov IS-28B2 · Wallis, TXThe pilot’s failure to maintain adequate airspeed during an emergency situation, which resulted in an aerodynamic stall and subsequent impact with terrain. Contributing to the accident was the pilot’s acute coronary event, which resulted from his severe…NTSB CEN10LA129Accident · 1 fatalLimited investigationFinal reportPiper PA-28-140 · Gatesville, TXThe pilot’s incapacitation as a result of one or more pre-existing medical conditions.