# NTSB investigations, TX: Unknown

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 2 · 78 cases

## Latest cases

- [NTSB CEN26LA266](https://openairdocs.org/ntsb/CEN26LA266.md): Piper J3C-65 · Richmond, TX · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Jul 20, 2026 · N92432 · Substantial damage
  > On July 20, 2026, at 0643 central daylight time, a Piper J3C-65 airplane, N92432, sustained substantial damage when it was involved in an accident near Richmond, Texas. The commercial pilot sustained serious injuries. The airplane was operated as a Title 14…
- [NTSB WPR26FA257](https://openairdocs.org/ntsb/WPR26FA257.md): Luscombe 8A · Canton, TX · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jul 14, 2026 · N1164K · Substantial damage
  > On July 14, 2026, sometime between 1252 and 1356 CDT, a Luscombe 8A, N1164K, was substantially damaged when it crashed in a field near Canton, Texas. The pilot, who was the sole occupant, was fatally injured. The airplane was operated as a Title 14 Code of…
- [NTSB CEN26LA061](https://openairdocs.org/ntsb/CEN26LA061.md): Bell Textron Canada 505 · Divot, TX · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Dec 13, 2025 · N865S · Substantial damage
  > On December 13, 2025, about 1345 central standard time, a Bell Helicopter 505, N865S, was substantially damaged when it was involved in an accident near Divot, Texas. The pilot was seriously injured and the passenger sustained minor injuries. The helicopter…
- [NTSB CEN26LA024](https://openairdocs.org/ntsb/CEN26LA024.md): Vans RV8 · McKinney, TX · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Oct 17, 2025 · N3545W · Substantial damage
  > On October 17, 2025, at 0921 central daylight time, an amateur-built RV-8 airplane, N3545W, was substantially damaged when it was involved in an accident near McKinney, Texas. The pilot was seriously injured. The airplane was operated as a Title 14 Code of…
- [NTSB CEN26FA012](https://openairdocs.org/ntsb/CEN26FA012.md): Beech A35 · Skidmore, TX · Accident · 1 fatal · Class 3 · Field · Preliminary report · Oct 7, 2025 · N577B · Destroyed
  > On October 7, 2025, at 1223 central daylight time, a Beech A35 airplane, N577B, was destroyed when it was involved in an accident near Skidmore, Texas. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations (CFR)…
- [NTSB CEN25LA020](https://openairdocs.org/ntsb/CEN25LA020.md): Starship Enterprise · Addison, TX · Accident · No injuries · Class 4 · Limited · Final report · Oct 17, 2024 · N903SC · Substantial damage
  > Foreign object debris damage to the ventral stabilizer.
- [NTSB CEN24LA107](https://openairdocs.org/ntsb/CEN24LA107.md): Edge 540 · La Porte, TX · Accident · No injuries · Class 3 · Limited · Final report · Feb 3, 2024 · N321JA · Substantial damage
  > A loss of engine power after takeoff for undetermined reasons.
- [NTSB CEN23FA352](https://openairdocs.org/ntsb/CEN23FA352.md): Cessna 150 · Caddo Mills, TX · Accident · 1 fatal · Class 3 · Field · Final report · Aug 7, 2023 · N5610E · Destroyed
  > The pilot’s loss of airplane control during an attempted forced landing following a loss of engine power.
- [NTSB CEN23LA136](https://openairdocs.org/ntsb/CEN23LA136.md): Cessna 150F · Hillsboro, TX · Accident · Class 4 · Limited · Final report · Mar 1, 2023 · N3090X · Substantial damage
  > Substantial damage for reasons undetermined based on the available evidence.
- [NTSB CEN22FA224](https://openairdocs.org/ntsb/CEN22FA224.md): Schweizer SGS135 · Midlothian, TX · Accident · 1 fatal · Class 3 · Field · Final report · Jun 5, 2022 · N2817H · No damage
  > The pilot’s incapacitation by an aortic dissection (natural disease).
- [NTSB CEN22LA156](https://openairdocs.org/ntsb/CEN22LA156.md): Cessna 172N · Springtown, TX · Accident · Minor injuries · Class 3 · Limited · Final report · Mar 24, 2022 · N733KP · Substantial damage
  > A total loss of engine power for reasons that could not be determined.
- [NTSB CEN21LA450](https://openairdocs.org/ntsb/CEN21LA450.md): Cessna 140 · Caddo Mills, TX · Accident · No injuries · Class 4 · Limited · Final report · Jul 22, 2021 · N84BC · Substantial damage
  > The missing vertical stabilizer hardware, which resulted in a severe uncommanded yawing motion that necessitated an emergency landing, during which the airplane nosed over and sustained substantial damage to the vertical stabilizer.
- [NTSB CEN21LA088](https://openairdocs.org/ntsb/CEN21LA088.md): Rans S12XL · Port Isabel, TX · Accident · 2 fatal · Class 3 · Limited · Final report · Dec 16, 2020 · N449JP · Substantial damage
  > An exceedance of the airplane’s critical angle of attack and aerodynamic stall following a loss of engine power during an unknown phase of flight, which resulted in an impact with terrain.
- [NTSB CEN21LA035](https://openairdocs.org/ntsb/CEN21LA035.md): Piper PA28 · Crystal Beach, TX · Accident · No injuries · Class 3 · Limited · Final report · Oct 26, 2020 · N32458 · Substantial damage
  > The partial loss of engine power for reasons that could not be determined.
- [NTSB CEN14FA468](https://openairdocs.org/ntsb/CEN14FA468.md): Schafer Rick W Foxtrot 4 · Abilene, TX · Accident · 2 fatal · Field investigation · Final report · Aug 31, 2014 · N729AR · Substantial damage
  > The pilot's decision to attempt a steep turn to return to the airport after reporting an emergency. The reason for the emergency could not be determined because postaccident examination of the airframe and engine did not reveal any mechanical anomalies that…
- [NTSB CEN11FA247](https://openairdocs.org/ntsb/CEN11FA247.md): Stinson 108 · Dickens, TX · Accident · 3 fatal · Field investigation · Final report · Mar 27, 2011 · N97383 · Substantial damage
  > The non-instrument rated pilot's decision to fly in night instrument meteorological conditions.
- [NTSB CEN09IA234](https://openairdocs.org/ntsb/CEN09IA234.md): Bell 206L-3 · Abilene, TX · Incident · No injuries · Incident investigation · Final report · Mar 29, 2009 · N708M · Minor damage
  > The formation and propagation of a fatigue crack in the trailing edge of the main rotor blade due to interconnected porosity and resultant corrosion. The area of interconnected porosity was due to a manufacturing defect which was not detected during the…
- [NTSB CEN09LA201](https://openairdocs.org/ntsb/CEN09LA201.md): Robinson R22 · Midland, TX · Accident · No injuries · Limited investigation · Final report · Mar 10, 2009 · N456PH · Destroyed
  > The pilot's failure to maintain adequate clearance from a pole.
- [NTSB DFW06CA175](https://openairdocs.org/ntsb/DFW06CA175.md): Cessna C340A · San Antonio, TX · Accident · No injuries · Data collection · Final report · Jul 5, 2006 · N2745F · Substantial damage
  > The collapse of the left main landing gear as result of the failure of the gear pivot bolt for undetermined reasons.
- [NTSB FTW04LA085](https://openairdocs.org/ntsb/FTW04LA085.md): Cessna 172K · Angleton, TX · Accident · No injuries · Limited investigation · Final report · Feb 29, 2004 · N79502 · Destroyed
  > The unqualified person's failure to maintain clearance with the power lines. A contributing factor was the night light conditions.
- [NTSB FTW00LA169](https://openairdocs.org/ntsb/FTW00LA169.md): Cecil Thorp T-18 · West, TX · Accident · 1 fatal · Limited investigation · Final report · May 24, 2000 · N856CW · Destroyed
  > The loss of control for an undetermined reason.
- [NTSB FTW99LA086](https://openairdocs.org/ntsb/FTW99LA086.md): Keil Jaeger D-IX · Santa Fe, TX · Accident · 1 fatal · Limited investigation · Final report · Feb 28, 1999 · N257JK · Destroyed
  > The separation of the right upper aileron for an undetermined reason.
- [NTSB FTW98FA340](https://openairdocs.org/ntsb/FTW98FA340.md): Piper J3C-85 · Seminole, TX · Accident · 1 fatal · Field investigation · Final report · Jul 31, 1998 · N7018H · Destroyed
  > The pilot's failure to maintain aircraft control.
- [NTSB FTW98FA307](https://openairdocs.org/ntsb/FTW98FA307.md): Cessna 172N · Lincoln, TX · Accident · Serious injuries · Field investigation · Final report · Jul 11, 1998 · N5632E · Destroyed
  > The #3 cylinder exhaust valve rocker arm fulcrum retaining stud backing out of its stud-tapped hole due to the improper tapping of the stud hole by unknown maintenance personnel. Contributing factors were the transmission wire, sign and gasoline pump.
- [NTSB FTW98FA167](https://openairdocs.org/ntsb/FTW98FA167.md): Bell 206B · Round Top, TX · Accident · 1 fatal · Field investigation · Final report · Apr 2, 1998 · N7734A · Destroyed
  > The pilot's attempted VFR flight into instrument meteorological conditions. Contributing factors were fog, low ceilings, and trees.
- [NTSB FTW96LA044](https://openairdocs.org/ntsb/FTW96LA044.md): Cessna 150M · Port Arthur, TX · Accident · 1 fatal · Limited investigation · Final report · Oct 27, 1995 · N714AS · Destroyed
  > Undetermined.
- [NTSB DEN93LA078](https://openairdocs.org/ntsb/DEN93LA078.md): Cessna 172XP · Allen, TX · Accident · No injuries · Limited investigation · Final report · Jul 14, 1993 · N736TJ · Substantial damage
  > Fuel exhaustion induced power loss. A factor was the lack of suitable terrain for the forced landing.
- [NTSB FTW93TA#07](https://openairdocs.org/ntsb/FTW93TA%2307.md): Piper PA-18-150 · Del Rio, TX · Accident · No injuries · Final report · Jun 12, 1993 · N83325 · Substantial damage
- [NTSB FTW93TA#04](https://openairdocs.org/ntsb/FTW93TA%2304.md): Piper PA-18-150 · Godley, TX · Accident · No injuries · Final report · May 16, 1993 · N2520S · Substantial damage
- [NTSB FTW93TA#03](https://openairdocs.org/ntsb/FTW93TA%2303.md): Bell 206B · Dallas, TX · Accident · No injuries · Final report · Mar 16, 1993 · N3211N · Substantial damage
- [NTSB FTW92FA224](https://openairdocs.org/ntsb/FTW92FA224.md): Robinson R22 · Alpine, TX · Accident · 1 fatal · Field investigation · Final report · Sep 5, 1992 · N4073S · Destroyed
  > Failure by the pilot-in-command, for unknown reasons, to maintain sufficient altitude to clear surrounding terrain. Factors were mountainous terrain and high density altitude.
- [NTSB FTW91LA165](https://openairdocs.org/ntsb/FTW91LA165.md): Piper PA-28-150 · Van Horn, TX · Accident · 1 fatal · Limited investigation · Final report · Sep 21, 1991 · N5330W · Destroyed
  > The pilot's failure to maintain control of the airplane. A factor was the pilot's lack of total experience.
- [NTSB FTW90GA040](https://openairdocs.org/ntsb/FTW90GA040.md): Aerospatiale AS-350B · Liberty Hill, TX · Accident · Serious injuries · Final report · Nov 30, 1989 · N5804T · Destroyed
  > Undetermined.
- [NTSB FTW85FA015](https://openairdocs.org/ntsb/FTW85FA015.md): Piper PA-30 · Port Mansfield, TX · Accident · 2 fatal · Field investigation · Final report · Oct 15, 1984 · N66CF · Destroyed
  > Acft crashed in a marsh area during a night recurrency training flt. Acft appeared to have contacted the terrain in an uncontrolled 90 deg left bank. PIC received his last medical certificate on 5/7/70. Investigation disclosed PIC was under medication for…
- [NTSB FTW84FA374](https://openairdocs.org/ntsb/FTW84FA374.md): Miller Air Sports GEM 260 · Martindale, TX · Accident · 1 fatal · Field investigation · Final report · Sep 1, 1984 · N177M · Destroyed
  > Notes left by plt indicate he had been testing the flight envelope of this experimental racing acft, including operation of the engine beyond prop limit of 4000 RPM. Witnesses heard engine sound suddenly speed up to high RPM then cease altogether. Some…
- [NTSB FTW84LA356](https://openairdocs.org/ntsb/FTW84LA356.md): Gulfstream 520 · Goliad, TX · Accident · Serious injuries · Limited investigation · Final report · Aug 24, 1984 · N4183B · Destroyed
  > Acft was found abandoned. Wreckage scene indicates collision with trees prior to collision with terrain. Acft suspected of being used for illegal cargo operations.
- [NTSB FTW84LA330](https://openairdocs.org/ntsb/FTW84LA330.md): Bellanca 7ECA · San Marcos, TX · Accident · Serious injuries · Limited investigation · Final report · Jul 29, 1984 · N8685V · Destroyed
  > While the plt was on a x-country flt, the acft crashed & came to rest on the shoreline of a large pond. Initial impact was believed to have occurred with the water. No preimpact part failure or malfunction was found during the investigation. There was…
- [NTSB FTW84LA249](https://openairdocs.org/ntsb/FTW84LA249.md): Beech 65 · Zapata, TX · Accident · No injuries · Limited investigation · Final report · May 25, 1984 · N404C · Destroyed
  > According to law enforcement officers, the acft experienced double eng failure and made a forced landing in unimproved terrain. During the landing rollout the acft struck several trees. An intense post crash fire erupted destroying all but one wing tip of the…
- [NTSB FTW84FA193](https://openairdocs.org/ntsb/FTW84FA193.md): Bellanca 8GCBC · Houston, TX · Accident · 2 fatal · Field investigation · Final report · Apr 9, 1984 · N4167Y · Destroyed
  > Witnesses heard the sound of an acft with the eng at high RPM. Shortly after that, they saw the acft in a left spin with the eng remaining at full power. The acft continued spinning until it crashed & burned. The witnesses noticed that when the plane was…
- [NTSB FTW84FA122](https://openairdocs.org/ntsb/FTW84FA122.md): Beech 77 · Fritch, TX · Accident · 2 fatal · Field investigation · Final report · Jan 27, 1984 · N3829D · Destroyed
  > The acft departed on 1/27/84 and failed to return from a 2 hour local flt. Time of departure was 1330 CST. On 1/28/84, afisherman on lake meredith found an acft wheel floating in the water. This wheel was later found to have the same part numbers and paint as…
- [NTSB FTW84FA114](https://openairdocs.org/ntsb/FTW84FA114.md): Bellanca 7ECA · Throckmorton, TX · Accident · 2 fatal · Field investigation · Final report · Jan 11, 1984 · N8646 · Destroyed
  > The acft crashed in a steep left wing down, nose down attitude. The flt had been for the purpose of checking out the front seat plt on pipe line patrol. The front seat plt had only 22 hrs in this make & model. The weather was VMC and no mechanical…
- [NTSB FTW84FA086](https://openairdocs.org/ntsb/FTW84FA086.md): Beech D18S · Brownsville, TX · Accident · 1 fatal · Field investigation · Final report · Dec 6, 1983 · N44609 · Destroyed
  > The plt had just taken off at night on a flt to Mexico when he declared an intent to return & land with some unspecified emergency. While he was using his radio, the sound of both engs, running at hi power, was audible. When asked if he required assistance,…
- [NTSB FTW84FA057](https://openairdocs.org/ntsb/FTW84FA057.md): Cessna 210N · Childress, TX · Accident · 1 fatal · Field investigation · Final report · Nov 16, 1983 · N6616N · Substantial damage
  > The plt contacte fss requesting info as to fuel service. He was advised that the rwy lights at Childress arpt was out of service. About 34 min later the plt stated his eng had quit & he would try to make the arpt. The acft subsequently struck power lines…
- [NTSB FTW83LA422](https://openairdocs.org/ntsb/FTW83LA422.md): Cessna 150G · Freer, TX · Accident · No injuries · Limited investigation · Final report · Sep 6, 1983 · N3374J · Substantial damage
  > Reportedly, the non-rated plt encountered a loss of power after the fuel exhausted near the destination arpt. Subsequently, he made an emergency landing at night on umimproved terrain aprx 1 mi from the arpt. During the landing sequence, the acft bounced, the…
- [NTSB FTW83FA407](https://openairdocs.org/ntsb/FTW83FA407.md): Luscombe 8C · Post, TX · Accident · 2 fatal · Field investigation · Final report · Aug 31, 1983 · N25285 · Destroyed
  > The acft had impacted in a steep right wing down, nose low attitude. No preimpact, mechanical malfunction or failure was found. The plt's blood alcohol level was 0.054%. There were no entries in the plt's log book for previous flts in Luscombe acft.
- [NTSB FTW83FA302](https://openairdocs.org/ntsb/FTW83FA302.md): Cessna 150J · El Campo, TX · Accident · 2 fatal · Field investigation · Final report · Jun 29, 1983 · N60655 · Substantial damage
  > The acft impacted the ground in a steep nose down attitude. After impact, the acft remained in a tail-high attitude. No known witnesses observed the accident. An exam of the eng & prop showed a minimum of power being developed at the time of impact. A…
- [NTSB FTW83LA103](https://openairdocs.org/ntsb/FTW83LA103.md): Cessna P337H · La Porte, TX · Accident · Minor injuries · Limited investigation · Final report · Feb 3, 1983 · N4BX · Substantial damage
  > Shortly after lift-off, the acft started its initial climb, then entered a slow descent. The flight was continued until the acft collided with a tv cable, suspended below telephone cables on the same poles. The acft contacted the ground, bounced & became…
- [NTSB FTW83LA032](https://openairdocs.org/ntsb/FTW83LA032.md): Piper PA-32RT-300 · Houston, TX · Accident · No injuries · Limited investigation · Final report · Nov 1, 1982 · N21136 · Substantial damage
  > The aircraft struck a tree when the pilot was landing on a road. After tree impact, the aircraft spun around and crashed on the road sliding into a culvert and a telephone pole. The aircraft had been stolen and two occupants were observed to exit the aircraft…
- [NTSB FTW83FRA01](https://openairdocs.org/ntsb/FTW83FRA01.md): Piper PA-28-140 · Woodville, TX · Accident · 3 fatal · Final report · Oct 31, 1982 · N3858K · Substantial damage
  > At about 2310 CDT, the owner/pilot and two other persons took off from the tyler county airport at Woodville, TX. About 15 minutes later, the plane crashed at the intersection of the runway (16/34) and a perpendicular taxiway. Impact and propeller strike…
- [NTSB FTW82FPA16](https://openairdocs.org/ntsb/FTW82FPA16.md): Bellanca 7ECA · Plano, TX · Accident · 2 fatal · Final report · Aug 19, 1982 · N10984 · Destroyed
  > During the 1818 departure from addison the plt advised addison tower that he was going to airpark-dallas for touch & go landings. The acft was observed to make at least one touch & go. At 1902 a witness called and reported hearing a noise, seeing a cloud of…

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

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