# NTSB investigations, TX: Maneuvering

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

Page 1 of 35 · 1,740 cases

## Latest cases

- [NTSB ERA26FA294](https://openairdocs.org/ntsb/ERA26FA294.md): Bachem Fritz M Avid Mark IV · Arp, TX · Accident · 1 fatal · Class 3 · Field · Preliminary report · Aug 9, 2026 · N77FB · Substantial damage
  > On August 9, 2026, at about 1655 central daylight time, an experimental amateur-built Avid Mark IV, N77FB, was substantially damaged when it was involved in an accident near Arp, Texas. The private pilot was fatally injured. The airplane was operated as a…
- [NTSB WPR26LA247](https://openairdocs.org/ntsb/WPR26LA247.md): Bell 47G · Springtown, TX · Accident · Serious injuries · Class 4 · Limited · Final report · Jul 3, 2026 · N7985A · Substantial damage
  > The pilot’s failure to maintain clearance from trees while in a low hover.
- [NTSB CEN26LA203](https://openairdocs.org/ntsb/CEN26LA203.md): Robinson Helicopter R66 · Fort Worth, TX · Accident · Serious injuries · Class 4 · Limited · Final report · May 27, 2026 · N5488H · Substantial damage
  > The flight instructor’s delayed remedial action and the student pilot’s failure to maintain helicopter control during hover.
- [NTSB CEN26LA221](https://openairdocs.org/ntsb/CEN26LA221.md): Rockwell International S-2R · Gause, TX · Accident · No injuries · Class 4 · Limited · Final report · May 20, 2026 · N4990X · Substantial damage
  > The loss of engine power due to fuel starvation. Contributing to the accident was the separated wing fuel tank screen and sealant debris in the fuel tank.
- [NTSB CEN26LA185](https://openairdocs.org/ntsb/CEN26LA185.md): Bell 407 · Dallas, TX · Accident · No injuries · Class 3 · Limited · Final report · May 13, 2026 · N652AE · Substantial damage
  > The pilot’s failure to maintain situational awareness and clearance from the helipad surveillance camera during liftoff.
- [NTSB CEN26LA168](https://openairdocs.org/ntsb/CEN26LA168.md): Robinson Helicopter R44 · Mount Blanco, TX · Accident · Minor injuries · Class 4 · Limited · Final report · Apr 17, 2026 · N445JS · Substantial damage
  > The pilot’s failure to maintain proper main rotor rpm during a low-level turn, which resulted in the main rotor rpm drooping, a loss of control at an altitude too low for recovery, and a subsequent impact with terrain.
- [NTSB CEN26LA148](https://openairdocs.org/ntsb/CEN26LA148.md): Robinson Helicopter R44 II · Stonewall, TX · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Mar 24, 2026 · N233JD · Substantial damage
  > On March 24, 2026, about 0930 central daylight time, a Robinson R44 II helicopter, N233JD, was substantially damaged when it was involved in an accident near Stonewall, Texas. The pilot and passenger were seriously injured. The helicopter was operated as a…
- [NTSB CEN26LA070](https://openairdocs.org/ntsb/CEN26LA070.md): Glynn RS-3 · Crabapple, TX · Accident · Serious injuries · Class 4 · Limited · Final report · Dec 19, 2025 · N3012G · Destroyed
  > The pilot's failure to maintain clearance from a fence cable guy-line during low-level maneuvering over a river.
- [NTSB CEN26LA055](https://openairdocs.org/ntsb/CEN26LA055.md): Just Highlander · Brazos, TX · Accident · Serious injuries · Class 4 · Limited · Final report · Nov 27, 2025 · N957DK · Substantial damage
  > The pilot’s failure to maintain clearance from power lines during low-level maneuvering along a river.
- [NTSB CEN25LA396](https://openairdocs.org/ntsb/CEN25LA396.md): Bell 206 · Archer City, TX · Accident · No injuries · Class 4 · Limited · Final report · Sep 27, 2025 · N565VA · Destroyed
  > The pilot’s failure to maintain clearance from power lines while herding livestock.
- [NTSB CEN25FA388](https://openairdocs.org/ntsb/CEN25FA388.md): North American T-6G · Louise, TX · Accident · 2 fatal · Class 3 · Field · Preliminary report · Sep 20, 2025 · N32SZ · Substantial damage
  > On September 20, 2025, about 1724 central daylight time, a North American T-6G airplane, N32SZ, was destroyed when it was involved in an accident near Lousie, Texas. The pilot and passenger sustained fatal injuries. The airplane was operated as a Title 14…
- [NTSB CEN25LA302](https://openairdocs.org/ntsb/CEN25LA302.md): Robinson Helicopter R22 Beta · Taylor, TX · Accident · Minor injuries · Class 4 · Limited · Final report · Aug 3, 2025 · N4684S · Substantial damage
  > The flight instructor’s inadequate supervision and delayed remedial action which resulted in a skid contacting the terrain. Contributing to the accident was the flight instructor’s improper judgement to allow the student pilot to manipulate the flight…
- [NTSB CEN25LA237](https://openairdocs.org/ntsb/CEN25LA237.md): Robinson Helicopter R44 II · Pecos, TX · Accident · Serious injuries · Class 4 · Limited · Final report · Jul 4, 2025 · N992TP · Substantial damage
  > The pilot’s failure to maintain aircraft control during gusty wind conditions.
- [NTSB CEN25FA184](https://openairdocs.org/ntsb/CEN25FA184.md): Rockwell Commander 114A · Hankamer, TX · Accident · 2 fatal · Class 3 · Field · Preliminary report · May 24, 2025 · N5903N · Destroyed
  > On May 24, 2025, about 1658 central daylight time (CDT), a Rockwell Commander 114A airplane, N5903N, was destroyed when it was involved in an accident near Hankamer, Texas. The private pilot and passenger were fatally injured. The airplane was operated under…
- [NTSB CEN25LA155](https://openairdocs.org/ntsb/CEN25LA155.md): Quicksilver MX II · Brady, TX · Accident · Serious injuries · Class 4 · Limited · Final report · Apr 11, 2025 · UNREG · Substantial damage
  > The airplane’s encounter with a dust devil, which resulted in a loss of airplane control at a low altitude.
- [NTSB CEN25FA104](https://openairdocs.org/ntsb/CEN25FA104.md): Robinson Helicopter R44 · Uvalde, TX · Accident · 2 fatal · Class 3 · Field · Preliminary report · Feb 27, 2025 · N144SG · Substantial damage
  > On February 27, 2025, about 1319 central standard time, a Robinson Helicopter Company (RHC) R44 helicopter, N144SG, sustained substantial damage when it was involved in an accident near Uvalde, Texas. The commercial pilot and the passenger sustained fatal…
- [NTSB CEN25LA100](https://openairdocs.org/ntsb/CEN25LA100.md): Cessna 180 · Breckenridge, TX · Accident · No injuries · Class 4 · Limited · Final report · Feb 17, 2025 · N597JC · Destroyed
  > The mechanic’s failure to properly install the throttle cable hardware resulting in a separation of the cable and loss of engine throttle control.
- [NTSB CEN25LA097](https://openairdocs.org/ntsb/CEN25LA097.md): Douglas A-20G · Laredo, TX · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Feb 16, 2025 · N747HS · Substantial damage
  > On February 16, 2025, about 1239 central standard time, a Douglas A-20G airplane, N747HS, was substantially damaged when it was involved in an accident in Laredo, Texas. The pilot was seriously injured. The airplane was operated as a Title 14 Code of Federal…
- [NTSB CEN25LA093](https://openairdocs.org/ntsb/CEN25LA093.md): Robinson Helicopter R22 Beta · Spearman, TX · Accident · Minor injuries · Class 3 · Limited · Final report · Feb 7, 2025 · N7191B · Substantial damage
  > Improperly torqued intake manifold bolts that allowed unmetered air to enter the engine, resulting in an overly lean fuel-air mixture, eventual failure of the No. 3 cylinder intake valve, and a total loss of engine power.
- [NTSB CEN25LA086](https://openairdocs.org/ntsb/CEN25LA086.md): American Champion 7ECA · Longview, TX · Incident · No injuries · Class 3 · Limited · Final report · Jan 16, 2025 · N798L · Substantial damage
  > The failure of the lower hinge barrel due to fatigue cracking. Contributing to the failure of the lower hinge barrel was increased stress from end face contact likely associated with worn bushings or displaced needle bearings.
- [NTSB CEN25LA043](https://openairdocs.org/ntsb/CEN25LA043.md): Pitts S1E · Seguin, TX · Accident · No injuries · Class 3 · Limited · Final report · Nov 17, 2024 · N52B · Substantial damage
  > The improper construction of the rudder cable assembly by the airplane builder, which resulted in the fatigue failure of the left rudder cable during the landing roll and the pilot’s subsequent inability to maintain directional control.
- [NTSB CEN25LA038](https://openairdocs.org/ntsb/CEN25LA038.md): Composite FX Mosquito XE · Waco, TX · Accident · Minor injuries · Class 4 · Limited · Final report · Nov 11, 2024 · N869DJ · Substantial damage
  > The total loss of engine power and subsequent impact with terrain during an autorotation. Contributing to the accident was the improper sealing of the liquid cooling system.
- [NTSB CEN25FA019](https://openairdocs.org/ntsb/CEN25FA019.md): Robinson R44 · Houston, TX · Accident · 4 fatal · Class 2 · Field · Final report · Oct 21, 2024 · N881KE · Destroyed
  > The 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 CEN24LA271](https://openairdocs.org/ntsb/CEN24LA271.md): Mcdonnell Douglas Helicopter 600N · Eagle Lake, TX · Accident · Serious injuries · Class 3 · Limited · Final report · Jul 16, 2024 · N609RP · Destroyed
  > The operator’s improper installation of the fuel system, which resulted in fuel starvation, a loss of engine power, and impact with terrain.
- [NTSB CEN24FA221](https://openairdocs.org/ntsb/CEN24FA221.md): Air Tractor AT502 · Whiteface, TX · Accident · 1 fatal · Class 3 · Field · Final report · Jun 14, 2024 · N2032K · 2 aircraft · Substantial damage
  > Both pilot’s failure to see and avoid the other airplane during simultaneous aerial application operations over the same area. Contributing to the accident was the operator’s poor decision to assign the pilots to conduct separate aerial application operations…
- [NTSB CEN24LA216](https://openairdocs.org/ntsb/CEN24LA216.md): Air Tractor AT-402 · Perryton, TX · Accident · Serious injuries · Class 4 · Limited · Final report · Jun 6, 2024 · N45123 · Destroyed
  > The pilot’s exceedance of the airplane’s critical angle of attack during a low-level turn, which resulted in an aerodynamic stall and loss of airplane control at too low of an altitude to recover.
- [NTSB CEN24FA188](https://openairdocs.org/ntsb/CEN24FA188.md): Cessna 150L · Godley, TX · Accident · 1 fatal · Class 3 · Field · Final report · May 16, 2024 · N1701Q · Destroyed
  > The student pilot’s failure to maintain airplane control while practicing a power-on stall, which resulted in an inadvertent spin at an altitude from which he was unable to recover.
- [NTSB CEN24LA162](https://openairdocs.org/ntsb/CEN24LA162.md): American Champion 7ECA · Longview, TX · Accident · No injuries · Class 3 · Limited · Final report · Apr 12, 2024 · N793L · Substantial damage
  > The rudder post’s failure due to corrosion fatigue. Contributing to the accident were the misalignment of the rudder hinge components, which produced mechanical binding and elevated localized stress, and a compromised the protective coating, which allowed…
- [NTSB CEN24LA137](https://openairdocs.org/ntsb/CEN24LA137.md): Enstrom Helicopter 280C · Port Lavaca, TX · Accident · No injuries · Class 3 · Limited · Final report · Mar 16, 2024 · N280WR · Substantial damage
  > The pilot’s improper manual engine mixture management which resulted in a loss of power. Contributing to the accident was the mechanic’s improper setting of the idle mixture adjustment and the pilot’s decision to take off with a known mechanical deficiency.
- [NTSB CEN24LA110](https://openairdocs.org/ntsb/CEN24LA110.md): Pipistrel Taurus · Waller, TX · Accident · No injuries · Class 4 · Limited · Final report · Feb 1, 2024 · N984TP · 2 aircraft · Substantial damage
  > The failure of both pilots to see and avoid one another while maneuvering, which resulted in a mid-air collision.
- [NTSB CEN24FA101](https://openairdocs.org/ntsb/CEN24FA101.md): Lockwood AIR CAM · Ranchitos Las Lomas, TX · Accident · 2 fatal · Class 3 · Field · Final report · Jan 29, 2024 · N315GW · Substantial damage
  > The pilot's failure to maintain clearance from a meteorological evaluation tower.
- [NTSB CEN24LA099](https://openairdocs.org/ntsb/CEN24LA099.md): Textron 172S · Direct, TX · Accident · 1 fatal · Class 4 · Limited · Final report · Jan 25, 2024 · N23107 · Destroyed
  > The pilot died by suicide.
- [NTSB CEN24FA049](https://openairdocs.org/ntsb/CEN24FA049.md): MD Helicopters 600 · Sterling City, TX · Accident · 2 fatal · Class 3 · Field · Final report · Nov 29, 2023 · N745MB · Substantial damage
  > The 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 CEN24LA025](https://openairdocs.org/ntsb/CEN24LA025.md): Cessna 172R · Riesel, TX · Accident · No injuries · Class 4 · Limited · Final report · Oct 6, 2023 · N2444H · Substantial damage
  > An in-flight collision with a bird.
- [NTSB CEN23LA319](https://openairdocs.org/ntsb/CEN23LA319.md): Alisport Silent 2 Electro · Wallis, TX · Accident · No injuries · Class 3 · Limited · Final report · Jul 22, 2023 · N64JG · Substantial damage
  > The failure of the tail boom structure due to cyclic torsion overloading as of a result of flutter in the empennage. The reason for the flutter could not be determined.
- [NTSB CEN23LA259](https://openairdocs.org/ntsb/CEN23LA259.md): Piper PA-28RT-201T · Baytown, TX · Accident · Minor injuries · Class 3 · Limited · Final report · Jun 23, 2023 · N8446B · Substantial damage
  > The total loss of engine power for undetermined reasons and the subsequent impact with terrain.
- [NTSB CEN23LA245](https://openairdocs.org/ntsb/CEN23LA245.md): Robinson Helicopter R22 Beta · Louise, TX · Accident · Minor injuries · Class 4 · Limited · Final report · Jun 18, 2023 · N932SH · Substantial damage
  > The pilot’s failure to maintain directional control in gusting wind conditions.
- [NTSB CEN23LA178](https://openairdocs.org/ntsb/CEN23LA178.md): Airbus Helicopters EC130 · Carta Valley, TX · Accident · Serious injuries · Class 3 · Limited · Final report · May 6, 2023 · N254DM · No damage
  > The right rear-seat passenger’s improper judgement to release his restraint system and depart the helicopter while in a hover, which resulted in him sustaining serious injuries. Contributing to the accident was his impairment from effects of alcohol…
- [NTSB CEN23LA172](https://openairdocs.org/ntsb/CEN23LA172.md): Piper PA-34-200 · Coldspring, TX · Accident · Serious injuries · Class 3 · Limited · Final report · May 3, 2023 · N28HE · Substantial damage
  > The stabilator trim rod assembly separated from the stabilator link assembly due to a missing connecting bolt, which resulted in the pilot’s inability to maintain pitch control of the airplane.
- [NTSB CEN23LA130](https://openairdocs.org/ntsb/CEN23LA130.md): Robinson Helicopter R44 · De Kalb, TX · Accident · Serious injuries · Class 3 · Limited · Final report · Mar 11, 2023 · N4164T · Substantial damage
  > The pilot’s inability to maintain control of the helicopter due to his failure to maintain rotor speed. Contributing to the accident was the failure of the helicopter’s low rotor speed warning system.
- [NTSB CEN23LA114](https://openairdocs.org/ntsb/CEN23LA114.md): Cessna 150 · Venus, TX · Accident · No injuries · Class 3 · Limited · Final report · Feb 18, 2023 · N6536G · Substantial damage
  > The loss of engine power for undetermined reasons.
- [NTSB CEN23LA081](https://openairdocs.org/ntsb/CEN23LA081.md): Pitts Model 12 · Conroe, TX · Accident · Serious injuries · Class 3 · Limited · Final report · Jan 14, 2023 · N512P · Substantial damage
  > The failure of the engine-driven fuel pump, which resulted in a total loss of engine power. Contributing to the failure of the fuel pump was an unknown non-ferrous metallic debris that was noted throughout the airplane’s fuel system.
- [NTSB CEN23LA086](https://openairdocs.org/ntsb/CEN23LA086.md): Robinson Helicopter R44 · Fowlerton, TX · Accident · Minor injuries · Class 4 · Limited · Final report · Jan 10, 2023 · N811S · Substantial damage
  > The pilot’s failure to maintain clearance with trees, which resulted in an uncontrollable spin due to tail rotor damage.
- [NTSB CEN23LA063](https://openairdocs.org/ntsb/CEN23LA063.md): Rockwell International S2R-G6 · Mission, TX · Accident · No injuries · Class 4 · Limited · Final report · Dec 6, 2022 · N4205X · Substantial damage
  > The pilot's failure to maintain clearance from an electrical box.
- [NTSB CEN23LA047](https://openairdocs.org/ntsb/CEN23LA047.md): Seace David A Gyroplane · Iredell, TX · Accident · Minor injuries · Class 4 · Limited · Final report · Nov 22, 2022 · N44088 · Substantial damage
  > The pilot's failure to maintain clearance from a power line during low-level maneuvering.
- [NTSB CEN23MA034](https://openairdocs.org/ntsb/CEN23MA034.md): Boeing B17 · Dallas, TX · Accident · 6 fatal · Class 1 · Major · Final report · Nov 12, 2022 · N7227C · 2 aircraft · Destroyed
  > the air boss’s and air show event organizer’s lack of an adequate, prebriefed aircraft separation plan for the air show performance, relying instead on the air boss’s real-time deconfliction directives and the see-and-avoid strategy for collision avoidance,…
- [NTSB CEN22LA429](https://openairdocs.org/ntsb/CEN22LA429.md): Commander 114TC · Savoy, TX · Accident · No injuries · Class 3 · Limited · Final report · Sep 22, 2022 · N495TC · Substantial damage
  > A loss of engine power for reasons that could not be determined.
- [NTSB WPR22FA264](https://openairdocs.org/ntsb/WPR22FA264.md): Piper PA-28-235 · Seguin, TX · Accident · 2 fatal · Class 3 · Field · Final report · Jul 22, 2022 · N8542W · Destroyed
  > The pilot’s failure to maintain adequate airspeed while maneuvering at a low altitude after being distracted when the engine cowling opened during flight, which led to a loss of control and subsequent impact with terrain. Contributing to the accident was the…
- [NTSB CEN22FA288](https://openairdocs.org/ntsb/CEN22FA288.md): Robinson Helicopter R44 II · Blackwell, TX · Accident · 1 fatal · Class 3 · Field · Final report · Jun 26, 2022 · N4124D · Destroyed
  > The pilot’s failure to maintain proper altitude and clearance during low-level aerial application, resulting in an in-flight collision with power lines.
- [NTSB CEN22LA248](https://openairdocs.org/ntsb/CEN22LA248.md): Air Tractor AT-602 · Beaumont, TX · Accident · No injuries · Class 4 · Limited · Final report · Jun 14, 2022 · N42590 · Substantial damage
  > The pilot’s failure to maintain clearance from a power line pole while preparing for a low-level aerial application pass.

Next page: https://openairdocs.org/ntsb-phases/450/cases.md?state=TX&page=2

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
WITH phase_names(main, name) AS (VALUES (100, 'Prior to flight'), (150, 'Standing'), (200, 'Pushback/towing'), (250, 'Taxi'), (300, 'Takeoff'), (350, 'Initial climb'), (400, 'Enroute'), (450, 'Maneuvering'), (500, 'Approach'), (550, 'Landing'), (600, 'Emergency descent'), (650, 'Uncontrolled descent'), (700, 'Post-impact'), (750, 'After landing'), (800, 'Other'), (990, 'Unknown')),
  crosswalk(code, main, name) AS (VALUES (500, 150, 'Standing'), (501, 150, 'Standing - pre-flight'), (502, 150, 'Standing - starting engine(s)'), (503, 150, 'Standing - engine(s) operating'), (504, 150, 'Standing - engine(s) not operating'), (505, 150, 'Standing - idling rotors'), (510, 250, 'Taxi'), (511, 200, 'Taxi - pushback/tow'), (512, 250, 'Taxi - to takeoff'), (513, 250, 'Taxi - from landing'), (514, 250, 'Taxi - aerial'), (520, 300, 'Takeoff'), (521, 300, 'Takeoff - roll/run'), (522, 350, 'Takeoff - initial climb'), (523, 300, 'Takeoff - aborted'), (530, 400, 'Climb'), (531, 400, 'Climb - to cruise'), (540, 400, 'Cruise'), (541, 400, 'Cruise - normal'), (542, 400, 'Maneuvering - holding (IFR)'), (550, 400, 'Descent'), (551, 400, 'Descent - normal'), (552, 600, 'Descent - emergency'), (553, 650, 'Descent - uncontrolled'), (560, 500, 'Approach'), (561, 500, 'Approach - VFR pattern - downwind'), (562, 500, 'Approach - VFR pattern - base turn'), (563, 500, 'Approach - VFR pattern - base leg/base to final'), (564, 500, 'Approach - VFR pattern - final approach'), (565, 500, 'Go-around (VFR)'), (566, 500, 'Approach - IAF to FAF/outer marker (IFR)'), (567, 500, 'Approach - FAF/outer marker to threshold (IFR)'), (568, 500, 'Circling (IFR)'), (569, 500, 'Missed approach (IFR)'), (570, 550, 'Landing'), (571, 550, 'Landing - flare/touchdown'), (572, 550, 'Landing - roll'), (573, 550, 'Landing - aborted'), (574, 550, 'Emergency landing'), (575, 550, 'Emergency landing after takeoff'), (576, 600, 'Emergency descent/landing'), (580, 450, 'Maneuvering'), (581, 450, 'Maneuvering - aerial application'), (582, 450, 'Maneuvering - turn to reverse direction'), (583, 450, 'Maneuvering - turn to landing area (emergency)'), (590, 450, 'Hover'), (591, 450, 'Hover - in ground effect'), (592, 450, 'Hover - out of ground effect'), (600, 800, 'Other'), (610, 990, 'Unknown')),
  current_codes AS (
    SELECT e.case_mkey, TRY_CAST(e."tier1Number" AS INTEGER) AS code,
      row_number() OVER (PARTITION BY e.case_mkey ORDER BY coalesce(e."isDefiningEvent", false) DESC, e.position) AS n
    FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e
    WHERE e.aircrafts_position = 1 AND e."tier1Number" GLOB '[1-9][0-9]*'
      AND (e."isDefiningEvent" OR e.case_mkey IN (SELECT "mKey" FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' WHERE "isPre1982"))
  ),
  phases AS (
    SELECT case_mkey, 'current' AS scheme, code, CASE WHEN code >= 990 THEN 990 ELSE code // 50 * 50 END AS main
    FROM current_codes WHERE n = 1
    UNION ALL
    SELECT o.case_mkey, 'older', o."phaseOfFlightCode", w.main
    FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o JOIN crosswalk w ON w.code = o."phaseOfFlightCode"
    WHERE o.aircrafts_position = 1 AND o."occurrenceNumber" = 1 AND o.case_mkey NOT IN (SELECT case_mkey FROM current_codes)
  ),
  case_phases AS (
    SELECT p.*, c."eventDate", c."highestInjuryLevel" = 'Fatal' AS fatal, a.aircraft_model_code
    FROM phases p JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = p.case_mkey
    LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = p.case_mkey AND a.position = 1
    WHERE c."eventDate" >= DATE '1962-01-01' AND p.main IN (SELECT main FROM phase_names)
  )
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 case_mkey FROM case_phases WHERE main = 450)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/450/cases?state=TX

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.