# NTSB investigations, TX: Approach

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 30 · 1,496 cases

## Latest cases

- [NTSB WPR27LA021](https://openairdocs.org/ntsb/WPR27LA021.md): Cessna 182A · Galveston, TX · Accident · No injuries · Class 4 · Limited · Investigation open · Oct 19, 2026 · N5153D · Substantial damage
- [NTSB CEN26FA197](https://openairdocs.org/ntsb/CEN26FA197.md): Fokker DR1 Replica · Frankston, TX · Accident · 1 fatal · Class 3 · Field · Preliminary report · May 26, 2026 · N54517 · Destroyed
  > On May 26, 2026, about 0810 central daylight time, an experimental Fokker DR1 airplane, N54517, was destroyed when it was involved in an accident near Frankston, Texas. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal…
- [NTSB CEN26LA164](https://openairdocs.org/ntsb/CEN26LA164.md): Piper PA-28-180 · Corpus Christi, TX · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Apr 14, 2026 · N317HM · Destroyed
  > On April 13, 2026, about 19:19 central daylight time, a Piper Cherokee PA-28-180 airplane, N317HM was destroyed when it was involved in an accident near Corpus Christi, Texas. The flight instructor and student pilot were seriously injured. The airplane was…
- [NTSB CEN26LA159](https://openairdocs.org/ntsb/CEN26LA159.md): Piper PA46 · Burke, TX · Accident · No injuries · Class 4 · Limited · Final report · Apr 5, 2026 · N95AG · Substantial damage
  > The airplane’s encounter with unexpected low-level wind shear during final approach, which resulted in a hard impact with the runway.
- [NTSB CEN26LA112](https://openairdocs.org/ntsb/CEN26LA112.md): Socata TBM 700 · Crockett, TX · Accident · Minor injuries · Class 4 · Limited · Final report · Feb 5, 2026 · N313BP · Destroyed
  > The pilot’s failure to maintain airplane control during a go-around that resulted in a collision with terrain.
- [NTSB WPR26FA067](https://openairdocs.org/ntsb/WPR26FA067.md): Beechcraft B300 · Galveston, TX · Accident · 6 fatal · Class 3 · Field · Preliminary report · Dec 22, 2025 · ANX1209 · Destroyed
  > On December 22, 2025, about 1505 central standard time, a Beechcraft B300, ANX1209, was substantially damaged when it was involved in an accident near Galveston, Texas. The pilot, co-pilot, two flight crew, two passengers were fatally injured and two…
- [NTSB CEN26LA060](https://openairdocs.org/ntsb/CEN26LA060.md): Sonerai II · Cresson, TX · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Dec 12, 2025 · N28MD · Substantial damage
  > On December 12, 2025, about 1431 central standard time, a Sonerai II airplane, registration N28MD, was substantially damaged when it was involved in an accident near Cresson, Texas. The pilot was seriously injured. The airplane was operated as a Title 14 Code…
- [NTSB ERA26FA010](https://openairdocs.org/ntsb/ERA26FA010.md): Beech C90 · Fort Worth, TX · Accident · 2 fatal · Class 3 · Field · Preliminary report · Oct 12, 2025 · N291CC · Destroyed
  > On 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 CEN25LA377](https://openairdocs.org/ntsb/CEN25LA377.md): Cessna 172F · Lancaster, TX · Accident · No injuries · Class 4 · Limited · Final report · Sep 13, 2025 · N7774A · Substantial damage
  > The pilot’s inadequate fuel planning and failure to monitor the fuel consumption which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB CEN25LA362](https://openairdocs.org/ntsb/CEN25LA362.md): Cessna 414 · New Braunfels, TX · Accident · No injuries · Class 4 · Limited · Final report · Sep 3, 2025 · N39HC · Substantial damage
  > A in-flight collision with a bird during the descent for landing.
- [NTSB CEN25LA352](https://openairdocs.org/ntsb/CEN25LA352.md): Glasair GlaStar · Hearne, TX · Accident · Minor injuries · Class 4 · Limited · Final report · Aug 28, 2025 · N605MN · Substantial damage
  > The inflight engine compartment fire for reasons that could not be determined.
- [NTSB CEN25LA324](https://openairdocs.org/ntsb/CEN25LA324.md): Cirrus Design SR22 · Cleburne, TX · Accident · No injuries · Class 4 · Limited · Final report · Aug 13, 2025 · N654CD · Substantial damage
  > The student pilot’s failure to maintain airplane directional control during the approach and subsequent go-around.
- [NTSB CEN25LA225](https://openairdocs.org/ntsb/CEN25LA225.md): Tecnam P2010 · Temple, TX · Accident · No injuries · Class 3 · Limited · Final report · Jun 26, 2025 · N258CM · Substantial damage
  > The loss of engine power due to a failed muffler flame tube assembly which resulted in an exhaust blockage.
- [NTSB CEN25LA188](https://openairdocs.org/ntsb/CEN25LA188.md): Piper PA-18 · Vega, TX · Accident · Minor injuries · Class 4 · Limited · Final report · May 26, 2025 · N7175D · Substantial damage
  > The airplane’s inadvertent encounter with a localized low boundary layer, which caused a wind shift, and a gusting tailwind during final approach, that resulted in the pilot deciding to impact a wind cone and a subsequent impact with terrain. Contributing was…
- [NTSB CEN25LA176](https://openairdocs.org/ntsb/CEN25LA176.md): Beech C90 · Lancaster, TX · Accident · Serious injuries · Class 4 · Limited · Final report · Apr 28, 2025 · N501MS · Substantial damage
  > The pilot’s improper fuel planning, which resulted in fuel exhaustion and a total loss of power to both engines.
- [NTSB WPR25FA127](https://openairdocs.org/ntsb/WPR25FA127.md): Azalea Saberwing · Justin, TX · Accident · 1 fatal · Class 3 · Field · Preliminary report · Apr 12, 2025 · N121DF · Destroyed
  > On April 11, 2025, about 1906 central daylight time (CDT), an experimental amateur-built Azalea Aviation LLC Saberwing, N121DF, was destroyed when it was involved in an accident near Justin, Texas. The pilot was fatally injured. The airplane was operated as a…
- [NTSB CEN25LA128](https://openairdocs.org/ntsb/CEN25LA128.md): Cessna 172S · Rusk, TX · Accident · No injuries · Class 4 · Limited · Final report · Mar 16, 2025 · N52243 · Substantial damage
  > The pilot's failure to maintain airplane control and adequate airspeed during the go-around, resulting in an aerodynamic stall and impact with terrain.
- [NTSB CEN25LA103](https://openairdocs.org/ntsb/CEN25LA103.md): Starduster II · Azle, TX · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Feb 24, 2025 · N78WT · Destroyed
  > On February 24, 2025, at 1430 central standard time, a Starduster II airplane, N78WT, was destroyed when it was involved in an accident near Azle, Texas. The private pilot and a passenger received minor injuries. The airplane was operated as a Title 14 Code…
- [NTSB CEN25LA082](https://openairdocs.org/ntsb/CEN25LA082.md): Beech N35 · Plainview, TX · Accident · No injuries · Class 4 · Limited · Final report · Jan 17, 2025 · N1206Z · Substantial damage
  > Fuel starvation due to fuel migration during the pilot induced slipping maneuver.
- [NTSB CEN25LA065](https://openairdocs.org/ntsb/CEN25LA065.md): Piper PA-28 · New Braunfels, TX · Accident · Serious injuries · Class 4 · Limited · Final report · Dec 28, 2024 · N5263W · Substantial damage
  > The pilot’s improper in-flight fuel planning which resulted in a total loss of engine power due to fuel starvation and a subsequent off-field landing on rough terrain.
- [NTSB CEN25LA060](https://openairdocs.org/ntsb/CEN25LA060.md): Piper PA-31-350 · Victoria, TX · Accident · Serious injuries · Class 4 · Limited · Final report · Dec 11, 2024 · N818BR · Substantial damage
  > The pilot’s inadequate preflight planning and preflight inspection, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB CEN25LA036](https://openairdocs.org/ntsb/CEN25LA036.md): Cessna 152 · Bridgeport, TX · Accident · No injuries · Class 4 · Limited · Final report · Nov 9, 2024 · N49785 · Destroyed
  > The student pilot’s delayed go-around from an unstabilized approach and failure to attain/maintain control during the go-around that resulted in an impact with terrain.
- [NTSB CEN24LA367](https://openairdocs.org/ntsb/CEN24LA367.md): Cirrus Design SR22 · Lakeway, TX · Accident · Serious injuries · Class 3 · Limited · Final report · Sep 25, 2024 · N565CP · Substantial damage
  > The pilot’s failure to maintain adequate airspeed during landing, which resulted in an aerodynamic stall and loss of control during a go-around.
- [NTSB DCA24LA328](https://openairdocs.org/ntsb/DCA24LA328.md): Cirrus Design SF50 · Austin, TX · Incident · No injuries · Class 3 · Limited · Final report · Sep 14, 2024 · N442CV · Minor damage
  > The unintended activation of the Emergency Autoland button on the overhead panel due to the airplane’s collision with an unknown object. Contributing to the incident was the pilot’s inability to initially deactivate the Emergency Autoland system due to a…
- [NTSB CEN24LA323](https://openairdocs.org/ntsb/CEN24LA323.md): Piper PA-28-180 · Cut and Shoot, TX · Accident · Minor injuries · Class 4 · Limited · Final report · Aug 21, 2024 · N3591R · Substantial damage
  > The pilot’s failure to maintain directional control during a go-around that resulted in an impact with a fence.
- [NTSB CEN24LA292](https://openairdocs.org/ntsb/CEN24LA292.md): Flight Design Ctsw · Lewisville, TX · Accident · Minor injuries · Class 4 · Limited · Final report · Jul 28, 2024 · N414FS · Substantial damage
  > The pilot’s failure to maintain sufficient airspeed during a go-around, which resulted in an aerodynamic stall and impact with water. Contributing to the accident were crosswind gusts.
- [NTSB CEN24LA178](https://openairdocs.org/ntsb/CEN24LA178.md): Cessna 172M · Midland, TX · Accident · No injuries · Class 4 · Limited · Final report · May 8, 2024 · N69PW · Substantial damage
  > The pilot’s failure to maintain airplane control during a go-around in a gusting crosswind, which resulted in an aerodynamic stall and collision with terrain. Contributing to the accident was the pilot’s lack of system knowledge regarding the operation of the…
- [NTSB CEN24LA152](https://openairdocs.org/ntsb/CEN24LA152.md): Bellanca 17-30A · Galveston, TX · Accident · No injuries · Class 4 · Limited · Final report · Apr 5, 2024 · N9996V · Substantial damage
  > Maintenance personnel’s failure to properly secure the oil filter adapter when replacing the oil filter adapter gasket which resulted in the filter becoming loose, resulting in the loss of engine oil, and the subsequent total loss of engine power.
- [NTSB CEN24LA124](https://openairdocs.org/ntsb/CEN24LA124.md): Searey Classic · Winchester, TX · Accident · Minor injuries · Class 4 · Limited · Final report · Feb 25, 2024 · N360MD · Substantial damage
  > The pilot’s failure to attain/maintain airplane control during a landing approach that resulted in an uncontrolled descent and an impact with the lake.
- [NTSB CEN24LA096](https://openairdocs.org/ntsb/CEN24LA096.md): Lockwood AIR CAM · Liberty Hill, TX · Accident · No injuries · Class 3 · Limited · Final report · Jan 20, 2024 · N1230R · Substantial damage
  > The reported simultaneous and total loss of engine power to both engines during a power reduction for reasons that could not be determined.
- [NTSB CEN24FA073](https://openairdocs.org/ntsb/CEN24FA073.md): Cirrus Design SR22 · Canton, TX · Accident · 1 fatal · Class 3 · Field · Final report · Dec 27, 2023 · N858RC · Destroyed
  > The pilot’s failure to attain the runway while landing at night, which resulted in an impact with trees.
- [NTSB CEN24LA068](https://openairdocs.org/ntsb/CEN24LA068.md): Piper PA-23-250 · Forney, TX · Accident · Minor injuries · Class 4 · Limited · Final report · Dec 18, 2023 · N66RC · Substantial damage
  > The pilot's inadequate fuel planning and improper in-flight decision-making, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB CEN24FA064](https://openairdocs.org/ntsb/CEN24FA064.md): Pilatus PC-12/45 · Christoval, TX · Accident · 2 fatal · Class 3 · Field · Final report · Dec 14, 2023 · N188PC · Substantial damage
  > The instrument-rated pilot and a passenger departed on an instrument flight rules (IFR) flight. After about 4.5 hours, while approaching the first planned fuel stop, the airplane was in instrument meteorological conditions (IMC). According to air traffic…
- [NTSB CEN24FA042](https://openairdocs.org/ntsb/CEN24FA042.md): Mooney M20C · Plano, TX · Accident · 1 fatal · Class 3 · Field · Final report · Nov 21, 2023 · N1204X · Destroyed
  > The pilot’s exceedance of the airplane’s critical angle of attack during a climbing turn during a go-around, which resulted in an aerodynamic stall and loss of control.
- [NTSB CEN24LA035](https://openairdocs.org/ntsb/CEN24LA035.md): Grassman Timothy B RV-14A · Houston, TX · Accident · No injuries · Class 4 · Limited · Final report · Nov 3, 2023 · N5875G · Substantial damage
  > The bird strike to the airplane’s vertical stabilizer during an approach for landing.
- [NTSB CEN24LA003](https://openairdocs.org/ntsb/CEN24LA003.md): Cessna 172 · Arlington, TX · Accident · Minor injuries · Class 3 · Limited · Final report · Oct 2, 2023 · N397ES · Substantial damage
  > A reported loss of engine power during the landing approach due to undetermined reasons, which resulted in a forced landing and collision with a fence.
- [NTSB CEN23LA418](https://openairdocs.org/ntsb/CEN23LA418.md): Beech C23 · Gonzales, TX · Accident · Minor injuries · Class 3 · Limited · Final report · Sep 24, 2023 · N18994 · Substantial damage
  > The loss of engine power during go-around due to a failed muffler flame tube, which resulted in an exhaust blockage. Contributing to the accident was maintenance personnel's inadequate inspection of the exhaust system during the most recent maintenance.
- [NTSB CEN23LA351](https://openairdocs.org/ntsb/CEN23LA351.md): Taylorcraft F21 · Holliday, TX · Accident · No injuries · Class 3 · Limited · Final report · Aug 7, 2023 · N2005J · Substantial damage
  > A loss of engine power for reasons that could not be determined, which resulted in impact with terrain.
- [NTSB CEN23LA318](https://openairdocs.org/ntsb/CEN23LA318.md): Beech H35 · Georgetown, TX · Accident · Minor injuries · Class 3 · Limited · Final report · Jul 23, 2023 · N365B · Substantial damage
  > A loss of engine power for reasons that could not be determined.
- [NTSB CEN23FA315](https://openairdocs.org/ntsb/CEN23FA315.md): Cessna 150 · Houston, TX · Accident · 1 fatal · Class 3 · Field · Final report · Jul 23, 2023 · N17043 · Substantial damage
  > The student pilot’s loss of airplane control in dark night conditions.
- [NTSB CEN23FA284](https://openairdocs.org/ntsb/CEN23FA284.md): Piper PA-30 · Sherman, TX · Accident · 1 fatal · Class 3 · Field · Final report · Jul 8, 2023 · N4743M · Substantial damage
  > The pilot’s failure to maintain control during a forced landing following a loss of engine power. Contributing was the pilot’s failure to feather the left propeller following the loss of engine power.
- [NTSB CEN23LA367](https://openairdocs.org/ntsb/CEN23LA367.md): Cessna 172B · San Angelo, TX · Accident · No injuries · Class 3 · Limited · Final report · Jun 17, 2023 · N7509X · Substantial damage
  > A partial loss of engine power due to loose bolts holding the carburetor throttle body to the fuel bowl.
- [NTSB CEN23FA173](https://openairdocs.org/ntsb/CEN23FA173.md): Cessna 310D · Ennis, TX · Accident · 1 fatal · Class 3 · Field · Final report · May 6, 2023 · N6798T · Destroyed
  > The partial loss of right engine power due to reduced fuel flow as a result of the contamination of the fuel screen.
- [NTSB CEN23LA170](https://openairdocs.org/ntsb/CEN23LA170.md): Luscombe 8F · Palmer, TX · Accident · No injuries · Class 3 · Limited · Final report · Apr 30, 2023 · N1113B · Substantial damage
  > The installation of an unapproved rudder control cable, which resulted in a fatigue failure and subsequent loss of rudder control during cruise flight. Contributing to the accident was the mechanic’s inadequate inspection of the rudder control system.
- [NTSB CEN23FA160](https://openairdocs.org/ntsb/CEN23FA160.md): Aero Vodochody L-139 · Bridgeport, TX · Accident · Serious injuries · Class 3 · Field · Final report · Apr 19, 2023 · N1390A · Substantial damage
  > The pilot’s failure to maintain a stabilized approach path while checking for possible bird strike damage that resulted in a delayed go-around attempt and a collision with terrain. Contributing to the accident was the flight instructor’s distraction while…
- [NTSB DCA23LA196](https://openairdocs.org/ntsb/DCA23LA196.md): Airbus A320-251N · Dallas, TX · Accident · Serious injuries · Class 4 · Limited · Final report · Mar 2, 2023 · N366FR · No damage
  > The flight’s encounter with convective turbulence.
- [NTSB CEN23LA107](https://openairdocs.org/ntsb/CEN23LA107.md): Mooney M20 · Lakeway, TX · Accident · No injuries · Class 3 · Limited · Final report · Feb 12, 2023 · N304MA · Substantial damage
  > A total loss of engine power due to detonation and preignition in the No. 6 cylinder.
- [NTSB WPR23LA104](https://openairdocs.org/ntsb/WPR23LA104.md): Beech F35 · Gladewater, TX · Accident · Minor injuries · Class 3 · Limited · Final report · Feb 5, 2023 · N123JV · Substantial damage
  > The loss of engine power for undetermined reasons.
- [NTSB CEN23LA097](https://openairdocs.org/ntsb/CEN23LA097.md): Cessna 172L · Cleveland, TX · Accident · Minor injuries · Class 4 · Limited · Final report · Jan 29, 2023 · N621EW · Substantial damage
  > The pilot’s decision to attempt the night flight under visual flight rules when instrument meteorological conditions prevailed resulting in the airplane striking trees while on final approach. Contributing to the accident were the unserviceable runway lights…
- [NTSB CEN23FA084](https://openairdocs.org/ntsb/CEN23FA084.md): Piper PA46 · Yoakum, TX · Accident · 4 fatal · Class 3 · Field · Final report · Jan 17, 2023 · N963MA · Substantial damage
  > The 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.

Next page: https://openairdocs.org/ntsb-phases/500/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 = 500)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/500/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.