# NTSB investigations, TX: Enroute 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 48 · 2,385 cases ## Latest cases - [NTSB CEN27LA028](https://openairdocs.org/ntsb/CEN27LA028.md): Cessna P206 · Nacogdoches, TX · Accident · No injuries · Class 3 · Limited · Investigation open · Oct 22, 2026 · N2649X - [NTSB CEN26LA314](https://openairdocs.org/ntsb/CEN26LA314.md): Cessna 150F · Weslaco, TX · Accident · No injuries · Class 4 · Limited · Investigation open · Sep 8, 2026 · N8061F · Substantial damage - [NTSB DCA26LA340](https://openairdocs.org/ntsb/DCA26LA340.md): Airbus A319-132 · Houston, TX · Accident · Serious injuries · Class 4 · Limited · Investigation open · Aug 27, 2026 · N884UA · No damage - [NTSB CEN26LA294](https://openairdocs.org/ntsb/CEN26LA294.md): Pipistrel Taurus Electro G2.5 · Hempstead, TX · Accident · Minor injuries · Class 4 · Limited · Final report · Aug 15, 2026 · N984TP · Substantial damage > The pilot’s failure to properly stow the motor in preparation for approach and landing that resulted in a loss of airspeed and an inadvertent aerodynamic stall and spin. - [NTSB CEN26LA287](https://openairdocs.org/ntsb/CEN26LA287.md): Mooney M20G · Luling, TX · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Aug 13, 2026 · N6916N · Substantial damage > On August 13, 2026, about 1302 central daylight time, a Mooney M20G airplane, N6916N, sustained substantial damage when it was involved in an accident near Luling, Texas. The pilot received minor injuries. The airplane was operated as a Title 14 Code of… - [NTSB CEN26LA230](https://openairdocs.org/ntsb/CEN26LA230.md): Zenith 601 XL · O'Donnell, TX · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Jun 20, 2026 · N165TJ · Substantial damage > On June 20, 2026, about 1147 central daylight time, an experimental Zodiac 601XL airplane, N165TJ, was substantially damaged when it was involved in an accident near O’Donnell, Texas. The pilot sustained serious injuries. The airplane was operated as a Title… - [NTSB CEN26FA228](https://openairdocs.org/ntsb/CEN26FA228.md): Textron 680A · Laredo, TX · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jun 17, 2026 · N523QS · Substantial damage > On June 16, 2026, at 2200 central daylight time, a Textron Aviation Inc 680A, N523QS, sustained substantial damage when it was involved in an accident in Laredo, Texas. The captain received serious injuries, the first officer received minor injuries, one… - [NTSB WPR26LA218](https://openairdocs.org/ntsb/WPR26LA218.md): Piper PA-24-400 · Graham, TX · Accident · Minor injuries · Class 4 · Limited · Investigation open · Jun 13, 2026 · N400HL · Substantial damage - [NTSB CEN26LA190](https://openairdocs.org/ntsb/CEN26LA190.md): Downer 14-19-3 · Forney, TX · Accident · 1 fatal · Class 3 · Limited · Preliminary report · May 16, 2026 · N7NL · Substantial damage > On May 16, 2026, about 0010 central daylight time, a Downer 14-19-3 airplane, N7NL, was substantially damaged when it was involved in an accident near Forney, Texas. The pilot and one passenger sustained minor injuries. A second passenger initially survived… - [NTSB CEN26FA174](https://openairdocs.org/ntsb/CEN26FA174.md): Cessna 421 · Wimberley, TX · Accident · 5 fatal · Class 3 · Field · Preliminary report · May 1, 2026 · N291AN · Destroyed > On April 30, 2026, about 2303 central daylight time, a Cessna 421C airplane, N291AN, was destroyed when it was involved in an accident near Wimberley, Texas. The private pilot and four passengers were fatally injured. The airplane was operated under the… - [NTSB CEN26LA144](https://openairdocs.org/ntsb/CEN26LA144.md): Mooney M20 · Northlake, TX · Accident · Serious injuries · Class 4 · Limited · Final report · Mar 18, 2026 · N1374W · Substantial damage > The pilot’s inadequate fuel management which resulted in a total loss of engine power due to fuel starvation. - [NTSB CEN26LA129](https://openairdocs.org/ntsb/CEN26LA129.md): Cameron Balloons US Z-77 · East Mountain, TX · Accident · No injuries · Class 4 · Limited · Investigation open · Feb 28, 2026 · N699DF · Substantial damage - [NTSB CEN26FA086](https://openairdocs.org/ntsb/CEN26FA086.md): Beech A36 · Sabine Pass, TX · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jan 8, 2026 · N5677X · Substantial damage > On January 8, 2026, about 1431 central standard time, a Beech A36 airplane, N5677X, was substantially damaged when it was involved in an accident near Sabine Pass, Texas. The pilot was fatally injured. The airplane was operated under the provisions of Title… - [NTSB CEN26FA071](https://openairdocs.org/ntsb/CEN26FA071.md): Lancair Legacy · Fredericksburg, TX · Accident · 1 fatal · Class 3 · Field · Preliminary report · Dec 30, 2025 · N618AM · Destroyed > On December 30, 2025, about 1623 central standard time, a Lancair Legacy RG airplane, N618AM, was destroyed when it was involved in an accident near Fredericksburg, Texas. The pilot sustained fatal injuries. The airplane was operated as a Title 14 Code of… - [NTSB CEN26LA082](https://openairdocs.org/ntsb/CEN26LA082.md): Wag Aero Cuby · Wimberley, TX · Accident · No injuries · Class 3 · Limited · Preliminary report · Dec 26, 2025 · N437WT · Substantial damage > On December 26, 2025, about 1630 central standard time, a Wag Aero Cuby airplane, N437WT, was substantially damaged when it was involved in an accident near Wimberley, Texas. The airplane was operated as a Title 14 Code of Federal Regulations Part 91 personal… - [NTSB CEN26LA069](https://openairdocs.org/ntsb/CEN26LA069.md): Cessna 172D · Post, TX · Accident · No injuries · Class 4 · Limited · Final report · Dec 19, 2025 · N2536U · Substantial damage > The pilot’s failure to see the blockage in the fuel tank vent tube during the preflight inspection which resulted in the loss of engine power due to fuel starvation. Contributing to the accident was the deterioration of the right fuel cap vent to the point… - [NTSB CEN26LA046](https://openairdocs.org/ntsb/CEN26LA046.md): Cirrus Design SR22 · Teague, TX · Accident · No injuries · Class 3 · Limited · Preliminary report · Nov 13, 2025 · N79EM · Substantial damage > On November 13, 2025, about 1430 central standard time, a Cirrus SR22 airplane, N79EM, was substantially damaged when it was involved in an accident near Teague, Texas. The pilot and passenger were not injured. The airplane was operated as a Title 14 Code of… - [NTSB CEN26LA031](https://openairdocs.org/ntsb/CEN26LA031.md): Denney Kitfox · Chilton, TX · Accident · No injuries · Class 3 · Limited · Preliminary report · Oct 27, 2025 · N5241N · Substantial damage > On October 27, 2025, about 0530 central daylight time, a Denney Kitfox III airplane, N5241N, was substantially damaged when it was involved in an accident near Chilton, Texas. The pilot and passenger were not injured. The airplane was operated as a Title 14… - [NTSB CEN26LA030](https://openairdocs.org/ntsb/CEN26LA030.md): Piper PA-46-310P · El Paso, TX · Accident · No injuries · Class 3 · Limited · Preliminary report · Oct 26, 2025 · N46CR · Substantial damage > On October 26, 2025, about 918 mountain daylight time, a Piper PA46-310P, N46CR, was substantially damaged when it was involved in an accident near El Paso, Texas. The pilot and two passengers were not injured. The airplane was operated as a Title 14 Code of… - [NTSB CEN26LA016](https://openairdocs.org/ntsb/CEN26LA016.md): Rotorway AG162 · Valley View, TX · Accident · No injuries · Class 3 · Limited · Preliminary report · Oct 13, 2025 · N162AD · Substantial damage > On October 13, 2025, at 1229 central daylight time, a Rotorway AG162 helicopter, N162AD, sustained substantial damage when it was involved in an accident near Valley View, Texas. The pilot and passenger were uninjured. The helicopter was operated under Title… - [NTSB CEN25LA391](https://openairdocs.org/ntsb/CEN25LA391.md): Cessna 150G · Seagoville, TX · Accident · No injuries · Class 4 · Limited · Final report · Sep 20, 2025 · N2500Q · Substantial damage > The pilot’s inadequate fuel planning which resulted in a total loss of engine power due to fuel exhaustion. - [NTSB DCA25LA307](https://openairdocs.org/ntsb/DCA25LA307.md): Embraer S A ERJ 170-200 LL · Peaster, TX · Accident · Serious injuries · Class 4 · Limited · Final report · Aug 29, 2025 · N110SY · No damage > The airplane’s encounter with convective turbulence that resulted in serious injuries to a passenger who was out of their seat when the seatbelt sign was illuminated. - [NTSB CEN25LA347](https://openairdocs.org/ntsb/CEN25LA347.md): Beech C35 · Lakeview, TX · Accident · Minor injuries · Class 4 · Limited · Final report · Aug 26, 2025 · N655D · Substantial damage > The pilot’s fuel system mismanagement which resulted in a loss of engine power due to fuel starvation. - [NTSB CEN25LA342](https://openairdocs.org/ntsb/CEN25LA342.md): Cirrus Design SR22 · Granbury, TX · Accident · No injuries · Class 4 · Limited · Final report · Aug 24, 2025 · N376CD · Substantial damage > The pilot’s inadequate fuel management, which resulted in a total loss of engine power due to fuel starvation. - [NTSB CEN25LA317](https://openairdocs.org/ntsb/CEN25LA317.md): Cessna P210 · Zapata, TX · Accident · No injuries · Class 3 · Limited · Preliminary report · Aug 13, 2025 · N92MS · Substantial damage > On August 13, 2025, about 1835 central daylight time, a Cessna P210N airplane, N92MS, was substantially damaged when it was involved in an accident near Zapata, Texas. The pilot and passenger were not injured. The airplane was operated as a Title 14 Code of… - [NTSB CEN25LA291](https://openairdocs.org/ntsb/CEN25LA291.md): Matesi Eugene E Lancair 320 · Wink, TX · Accident · No injuries · Class 3 · Limited · Preliminary report · Jul 28, 2025 · N70337 · Substantial damage > On July 27, 2025, about 2001 central daylight time, a Lancair 320 airplane, N70337, was substantially damaged when it was involved in an accident near Wink, Texas. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal Regulations… - [NTSB CEN25LA301](https://openairdocs.org/ntsb/CEN25LA301.md): Cessna U206G · Kerrville, TX · Accident · No injuries · Class 4 · Limited · Final report · Jul 25, 2025 · N756XY · Substantial damage > The pilot’s failure to confirm the fuel quantity before flight which resulted in a loss of engine power due to fuel starvation. - [NTSB CEN25LA282](https://openairdocs.org/ntsb/CEN25LA282.md): Cessna T210N · Crosby, TX · Accident · No injuries · Class 3 · Limited · Preliminary report · Jul 21, 2025 · N93HP · Substantial damage > On July 21, 2025, about 0745 central daylight time, a Cessna T210N, N93HP, was substantially damaged when it was involved in an accident near Crosby, Texas. The pilot and passenger were not injured. The airplane operated as a Title 14 Code of Federal… - [NTSB CEN25LA271](https://openairdocs.org/ntsb/CEN25LA271.md): PZL Swidnik PW-5 · Kerrick, TX · Accident · No injuries · Class 4 · Limited · Final report · Jul 19, 2025 · N4426Z · Substantial damage > The glider’s encounter with atmospheric conditions where the lift was not sufficient to maintain flight. - [NTSB CEN25LA242](https://openairdocs.org/ntsb/CEN25LA242.md): Sikorsky UH60 · Ingram, TX · Incident · No injuries · Class 3 · Limited · Preliminary report · Jul 7, 2025 · UNREG · Minor damage > On July 7, 2025, about 1557 central daylight time, an unregistered Sikorsky UH-60 Black Hawk helicopter collided with an unregistered DJI Mavic 3T unmanned aerial vehicle (drone) near Ingram, Texas. The UH-60 received substantial damage to the tail rotor… - [NTSB CEN25LA205](https://openairdocs.org/ntsb/CEN25LA205.md): Lancair 360 · Fort Stockton, TX · Accident · No injuries · Class 3 · Limited · Preliminary report · Jun 12, 2025 · N77LH · Destroyed > On June 11, 2025, about 2145 central daylight time, a Lancair 360 airplane, N77LH, was destroyed when it was involved in an accident near Fort Stockton, Texas. The airline transport pilot was not injured. The airplane was operated as a Title 14 Code of… - [NTSB CEN25FA183](https://openairdocs.org/ntsb/CEN25FA183.md): Robinson Helicopter R44 II · Miami, TX · Accident · 1 fatal · Class 3 · Field · Preliminary report · May 23, 2025 · N1195P · Destroyed > On May 23, 2025, about 0718 central daylight time, a Robinson Helicopter Company R44 II helicopter, N1195P, was destroyed when it was involved in an accident near Miami, Texas. The student pilot was fatally injured. The helicopter was operated as a Title 14… - [NTSB CEN25LA156](https://openairdocs.org/ntsb/CEN25LA156.md): Mooney M20J · Edinburg, TX · Accident · No injuries · Class 3 · Limited · Preliminary report · Apr 12, 2025 · N5807T · Substantial damage > On April 12, 2025, at 1010 central daylight time, a Mooney M20J, N5807T, was substantially damaged when it was involved in an accident near Edinburg, Texas. The private pilot and two passengers were uninjured. The airplane was operated under Title 14 Code of… - [NTSB CEN25LA107](https://openairdocs.org/ntsb/CEN25LA107.md): Schweizer 269C-1 · Alvord, TX · Accident · No injuries · Class 3 · Limited · Final report · Feb 28, 2025 · N2027T · Substantial damage > A total loss of engine power for a reason that could not be determined. - [NTSB CEN25LA091](https://openairdocs.org/ntsb/CEN25LA091.md): Aircraft Mfg & Development CH 2000 · Ennis, TX · Accident · No injuries · Class 4 · Limited · Final report · Feb 2, 2025 · N334LF · Substantial damage > The pilot’s improper fuel planning which resulted in the total loss of engine power due to fuel exhaustion. - [NTSB CEN25FA052](https://openairdocs.org/ntsb/CEN25FA052.md): Cozy MK III · Mineola, TX · Accident · 2 fatal · Class 3 · Field · Preliminary report · Nov 28, 2024 · N51810 · Destroyed > On November 27, 2024, about 18:30 central standard time, a Cozy Mark III, N51810 was destroyed when it was involved in an accident near Mineola, Texas. The pilot and passenger were fatally injured. The flight was operated under the provisions of Title 14 Code… - [NTSB CEN25LA018](https://openairdocs.org/ntsb/CEN25LA018.md): Piper PA-32R-301 · Van, TX · Accident · Minor injuries · Class 3 · Limited · Final report · Oct 17, 2024 · N81481 · Substantial damage > The mechanic’s improper maintenance of the engine’s air induction scat duct, which collapsed during the flight and resulted in a loss of engine power. - [NTSB CEN25FA005](https://openairdocs.org/ntsb/CEN25FA005.md): Champion 7EC · Fort Worth, TX · Accident · 1 fatal · Class 3 · Field · Preliminary report · Oct 7, 2024 · N4337C · Substantial damage > On October 7, 2024, about 1240 central daylight time, a Champion 7EC airplane, N4337C, sustained substantial damage when it was involved in an accident near Fort Worth, Texas. The pilot sustained fatal injuries. The airplane was operated as a Title 14 Code of… - [NTSB CEN24LA339](https://openairdocs.org/ntsb/CEN24LA339.md): Piper PA-28-140 · Borger, TX · Accident · No injuries · Class 4 · Limited · Final report · Sep 5, 2024 · N40939 · Substantial damage > The pilot’s inadequate fuel management which led to fuel exhaustion. - [NTSB CEN24LA301](https://openairdocs.org/ntsb/CEN24LA301.md): Tailwind W10 · West Livingston, TX · Accident · Minor injuries · Class 3 · Limited · Final report · Aug 3, 2024 · N129WT · Substantial damage > A partial loss of engine power due to carburetor ice. - [NTSB CEN24LA311](https://openairdocs.org/ntsb/CEN24LA311.md): Piper PA-34-200T · Wills Point, TX · Accident · No injuries · Class 3 · Limited · Preliminary report · Jul 31, 2024 · N2106E · Substantial damage > On July 31, 2024, about 0836 central daylight time, a Piper PA-34-200T, N2106E, was substantially damaged when it was involved in an accident near Wills Point, Texas. The pilot and pilot-rated passenger were not injured. The airplane was operated as a Title… - [NTSB CEN24LA191](https://openairdocs.org/ntsb/CEN24LA191.md): Piper PA-28-180 · Dell City, TX · Accident · No injuries · Class 4 · Limited · Final report · May 18, 2024 · N11NT · Substantial damage > The pilot’s failure to switch fuel tanks while en route which resulted in the loss of engine power due to fuel starvation. - [NTSB CEN24FA167](https://openairdocs.org/ntsb/CEN24FA167.md): Vertical Aviation Technologies Hummingbird · Spring Branch, TX · Accident · 2 fatal · Class 3 · Field · Final report · Apr 29, 2024 · N829SH · Destroyed > A total loss of engine power for undetermined reasons, which resulted in a forced landing and a subsequent impact with terrain. - [NTSB CEN24LA147](https://openairdocs.org/ntsb/CEN24LA147.md): Bellanca 7KCAB · Bluff Dale, TX · Accident · Minor injuries · Class 3 · Limited · Final report · Apr 4, 2024 · N8946 · Destroyed > An engine compartment fire for reasons that could not be determined due to extensive thermal damage. - [NTSB CEN24LA141](https://openairdocs.org/ntsb/CEN24LA141.md): Cozy Mark IV · Gonzales, TX · Accident · No injuries · Class 3 · Limited · Final report · Mar 25, 2024 · N20MN · Substantial damage > Maintenance personnel’s failure to properly torque the crankshaft idler gear hardware according to the engine manufacturer’s service instructions, which resulted in separation of the crankshaft idler gear’s fasteners and disengagement of the camshaft,… - [NTSB CEN24LA140](https://openairdocs.org/ntsb/CEN24LA140.md): Cessna T210 · San Saba, TX · Accident · No injuries · Class 3 · Limited · Final report · Mar 25, 2024 · N498TB · Substantial damage > A total loss of engine power due to multiple connecting rod failures from oil starvation. - [NTSB CEN24LA114](https://openairdocs.org/ntsb/CEN24LA114.md): Piper PA-28-140 · Wayside, TX · Accident · No injuries · Class 4 · Limited · Final report · Feb 9, 2024 · N7586R · Substantial damage > The student pilot’s improper fuel management during the cross-country flight, which resulted in a total loss of engine power due to fuel starvation. - [NTSB CEN24FA089](https://openairdocs.org/ntsb/CEN24FA089.md): Cessna 310R · Poolville, TX · Accident · 3 fatal · Class 3 · Field · Final report · Jan 14, 2024 · N252DL · Destroyed > Pilot incapacitation for undetermined reasons which resulted into controlled descent into terrain. - [NTSB CEN24LA088](https://openairdocs.org/ntsb/CEN24LA088.md): Eurocopter AS 350 B2 · Spofford, TX · Accident · Minor injuries · Class 3 · Limited · Final report · Jan 12, 2024 · N204TX · Substantial damage > The fatigue failure of the fuel control unit control lever arm, which resulted in fuel starvation, and a loss of engine power. - [NTSB CEN24LA092](https://openairdocs.org/ntsb/CEN24LA092.md): Piper PA22 · Dalhart, TX · Accident · No injuries · Class 4 · Limited · Final report · Jan 11, 2024 · N2513P · Substantial damage > The total loss of engine power due to carburetor icing and the pilot’s failure to utilize carburetor heat in meteorological conditions conducive to the formation of carburetor icing. Next page: https://openairdocs.org/ntsb-phases/400/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 = 400) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb-phases/400/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.