# NTSB investigations, TX: Takeoff 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 19 · 933 cases ## Latest cases - [NTSB CEN27LA032](https://openairdocs.org/ntsb/CEN27LA032.md): Luscombe 8A · Fredericksburg, TX · Accident · Class 3 · Limited · Investigation open · Oct 23, 2026 · N1329K - [NTSB CEN27FA006](https://openairdocs.org/ntsb/CEN27FA006.md): Lancair IV · Haslet, TX · Accident · 1 fatal · Class 3 · Field · Preliminary report · Oct 7, 2026 · N5SV · Destroyed > On October 7, 2026, at 0952 central daylight time, an Lancair IV-P airplane, N5SV, was destroyed when it was involved in an accident near Haslet, Texas. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations (CFR)… - [NTSB CEN27LA004](https://openairdocs.org/ntsb/CEN27LA004.md): Cessna 414A · Boerne, TX · Accident · No injuries · Class 3 · Limited · Preliminary report · Oct 2, 2026 · N1245A · Substantial damage > On October 2, 2026, about 1352 central daylight time, a Cessna 414A airplane, N1245A, was destroyed when it was involved in an accident near Boerne, Texas. The pilot and pilot-rated passenger were not injured. The airplane was operated as a Title 14 Code of… - [NTSB CEN26LA312](https://openairdocs.org/ntsb/CEN26LA312.md): Cessna 337 · Brenham, TX · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Sep 7, 2026 · N2657S · Substantial damage > On September 7, 2026, about 1248 central daylight time, a Cessna 337C airplane, N2657S, sustained substantial damage when it was involved in an accident near Brenham, Texas. The pilot sustained minor injuries. The airplane was operated as a Title 14 Code of… - [NTSB CEN26LA304](https://openairdocs.org/ntsb/CEN26LA304.md): Piper PA-28-161 · Hudson Oaks, TX · Accident · No injuries · Class 4 · Limited · Final report · Sep 1, 2026 · N47899 · Substantial damage > The pilot’s loss of directional control during the rejected takeoff, which resulted in a runway excursion. Contributing to the accident was the pilot’s decision to abort the takeoff after the airplane had accelerated above its normal rotation speed. Also… - [NTSB CEN26LA306](https://openairdocs.org/ntsb/CEN26LA306.md): Cirrus Design SR22T · Spicewood, TX · Accident · No injuries · Class 4 · Limited · Investigation open · Aug 31, 2026 · N115JB · Substantial damage - [NTSB ANC26LA092](https://openairdocs.org/ntsb/ANC26LA092.md): Autogyro Cavalon · Conroe, TX · Accident · Minor injuries · Class 4 · Limited · Investigation open · Aug 27, 2026 · N128NR · Substantial damage - [NTSB WPR26LA319](https://openairdocs.org/ntsb/WPR26LA319.md): Rotorsport UK Rotorsport UK Cavalo · Brenham, TX · Accident · No injuries · Class 4 · Limited · Investigation open · Aug 22, 2026 · N987AG · Substantial damage - [NTSB CEN26LA302](https://openairdocs.org/ntsb/CEN26LA302.md): Piper PA-22-150 · Brenham, TX · Accident · Minor injuries · Class 4 · Limited · Investigation open · Aug 22, 2026 · N7517D · Substantial damage - [NTSB CEN26LA298](https://openairdocs.org/ntsb/CEN26LA298.md): Rotor Effects M24 Plus · Waelder, TX · Accident · Minor injuries · Class 4 · Limited · Final report · Aug 15, 2026 · N91JL · Substantial damage > The pilot’s improper execution of rejected takeoff procedures, which resulted in loss of control and subsequent runway excursion. - [NTSB DCA26WA294](https://openairdocs.org/ntsb/DCA26WA294.md): Airbus A380 · Grapevine, TX · Occurrence · No injuries · Class 5 · Foreign · Jul 21, 2026 · G-XLEE · No damage - [NTSB CEN26LA265](https://openairdocs.org/ntsb/CEN26LA265.md): Piper PA-28-180 · Bulverde, TX · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Jul 20, 2026 · N454MD · Substantial damage > On July 20, 2026, about 1340 central daylight time, a Piper PA-28-180, N454MD was substantially damaged when it was involved in an accident near Bulberde, Texas. The flight instructor and student pilot received minor injuries. The airplane was operated as a… - [NTSB WPR26LA215](https://openairdocs.org/ntsb/WPR26LA215.md): Cessna 172 · Cleburne, TX · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Jun 9, 2026 · N1330Y · Substantial damage > On June 9, 2026 at about 1520 central daylight time a Cessna 172C, N1330Y, was substantially damaged when it crashed near Cleburne, Texas. The flight instructor and student pilot received minor injuries. The airplane was operated as a Title 14 Code of Federal… - [NTSB CEN26LA204](https://openairdocs.org/ntsb/CEN26LA204.md): Mustang Aeronautics Mustang II · Richmond, TX · Accident · Minor injuries · Class 3 · Limited · Preliminary report · May 28, 2026 · N160MT · Substantial damage > On May 28, 2026, about 1440 central daylight time, a Mustang Aeronautics Mustang II airplane, N160MT, sustained substantial damage when it was involved in an accident near Richmond, Texas. The pilot sustained minor injuries. The airplane was operated as a… - [NTSB CEN26LA187](https://openairdocs.org/ntsb/CEN26LA187.md): Cessna 172S · Denton, TX · Accident · No injuries · Class 3 · Limited · Preliminary report · May 13, 2026 · N2134M · Substantial damage > On May 13, 2026, about 1815 central daylight time, a Cessna 172S, N2134M, sustained substantial damage when it was involved in an accident near Denton, Texas. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal Regulations Part… - [NTSB CEN26LA177](https://openairdocs.org/ntsb/CEN26LA177.md): Air Tractor AT-602 · El Campo, TX · Accident · No injuries · Class 4 · Limited · Final report · May 5, 2026 · N422TW · Destroyed > The pilot’s failure to maintain aircraft control during takeoff resulting in a collision with a building during takeoff. - [NTSB CEN26LA143](https://openairdocs.org/ntsb/CEN26LA143.md): Cessna 172P · Denton, TX · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Mar 20, 2026 · N65614 · Substantial damage > On March 20, 2026, about 1415 central daylight time, a Cessna 172P airplane, N65614, was substantially damaged when it was involved in an accident near Denton, Texas. The pilot sustained minor injuries, and the pilot-rated sensor operator sustained serious… - [NTSB ANC26LA018](https://openairdocs.org/ntsb/ANC26LA018.md): Bell Textron Canada 505 · Fort Worth, TX · Accident · No injuries · Class 3 · Limited · Preliminary report · Mar 8, 2026 · N911FW · Substantial damage > On March 7, 2026, at 2210 Central daylight time, a Bell Textron 505 helicopter, N911FW, was substantially damaged when it was involved in an accident near Fort Worth, Texas. The pilot and crew member were not injured. The helicopter was operated as a Title 14… - [NTSB CEN26LA137](https://openairdocs.org/ntsb/CEN26LA137.md): Piper PA-12 · Lockhart, TX · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Mar 7, 2026 · N2511M · Substantial damage > On March 7, 2026, about 1323 central standard time, a Piper PA-12, N2511M, was substantially damaged when it was involved in an accident near Lockhart, Texas. The pilot and passenger sustained minor injuries. The airplane was operated as a Title 14 Code of… - [NTSB CEN26LA134](https://openairdocs.org/ntsb/CEN26LA134.md): Piper PA-18-150 · Sonora, TX · Accident · No injuries · Class 4 · Limited · Final report · Mar 4, 2026 · N3695Z · Substantial damage > The pilot’s failure to maintain adequate airspeed during takeoff, which resulted in a loss of control and hard landing. - [NTSB CEN26LA105](https://openairdocs.org/ntsb/CEN26LA105.md): Cessna 441 · Pflugerville, TX · Accident · Minor injuries · Class 4 · Limited · Final report · Jan 31, 2026 · N441EC · Substantial damage > The pilot’s failure to maintain airplane control during a rejected takeoff due to a flat nose wheel tire which resulted in a runway excursion and impact with terrain. Contributing to the accident was pilot fatigue which delayed the rejected takeoff. - [NTSB CEN26LA097](https://openairdocs.org/ntsb/CEN26LA097.md): Quicksilver II · Spring, TX · Accident · No injuries · Class 3 · Limited · Preliminary report · Jan 20, 2026 · N4NH · Substantial damage > On January 20,2026, 1658 central standard time, a Quicksilver II, N4NH, sustained substantial damage when it was involved in an accident at David Wayne Hooks Memorial Airport, DWH, in Spring, Texas. The pilot, sole occupant, sustained no injuries. The… - [NTSB CEN26LA092](https://openairdocs.org/ntsb/CEN26LA092.md): Cessna 172 · San Marcos, TX · Accident · Minor injuries · Class 4 · Limited · Final report · Jan 7, 2026 · N5136E · Substantial damage > The flight instructor’s failure to properly configure the elevator trim for the takeoff, that resulted in a hard landing. Contributing to the accident was the flight instructor’s failure to follow the before takeoff checklist. - [NTSB CEN26LA084](https://openairdocs.org/ntsb/CEN26LA084.md): Cessna 172 · Taylor, TX · Accident · No injuries · Class 3 · Limited · Final report · Dec 26, 2025 · N172BX · Substantial damage > The pilot’s inadequate preflight inspection that resulted in a loss of engine power due to water contamination. - [NTSB CEN26LA072](https://openairdocs.org/ntsb/CEN26LA072.md): Cirrus Design SR22T · Muleshoe, TX · Accident · No injuries · Class 3 · Limited · Preliminary report · Dec 18, 2025 · N53KH · Substantial damage > On December 18, 2025, about 1255 central standard time, a Cirrus SR22T, N53KH, was substantially damaged when it was involved in an accident near Muleshoe, Texas. The pilot was not injured. The airplane was operated under the provisions of Title 14 Code of… - [NTSB CEN26LA058](https://openairdocs.org/ntsb/CEN26LA058.md): Piper PA28 · Conroe, TX · Accident · No injuries · Class 4 · Limited · Final report · Dec 10, 2025 · N6058F · Substantial damage > The collision with a deer during takeoff. - [NTSB CEN25LA386](https://openairdocs.org/ntsb/CEN25LA386.md): Mooney M20K · Pearland, TX · Accident · No injuries · Class 3 · Limited · Preliminary report · Sep 16, 2025 · N305EP · Substantial damage > On September 16, 2025, about 1040 central daylight time, a Mooney Aircraft Corp. M20K, N305EP was substantially damaged when it was involved in an accident at the Pearland Regional Airport, Pearland, Texas. The pilot and certificated flight instructor were… - [NTSB CEN25FA119](https://openairdocs.org/ntsb/CEN25FA119.md): Cessna 525 · Mesquite, TX · Accident · 1 fatal · Class 3 · Field · Preliminary report · Mar 13, 2025 · N525CZ · Destroyed > On March 13, 2025, about 0733 central daylight time, a Cessna 525A airplane, N525CZ, was destroyed when it was involved in an accident near Mesquite, Texas. The pilot was fatally injured. The airplane was operated under the provisions of Title 14 Code of… - [NTSB CEN25LA111](https://openairdocs.org/ntsb/CEN25LA111.md): Piper PA-28-140 · Pearland, TX · Accident · Minor injuries · Class 3 · Limited · Final report · Mar 6, 2025 · N54479 · Substantial damage > Both pilots’ failure to follow emergency procedures pertaining to the partial loss of engine power by either applying carburetor heat to address the carburetor icing or to abort the takeoff when they observed a partial loss of engine power during the takeoff… - [NTSB DCA25LA114](https://openairdocs.org/ntsb/DCA25LA114.md): Airbus Industrie A319 · Houston, TX · Occurrence · No injuries · Class 3 · Limited · Final report · Feb 2, 2025 · N837UA · No damage > The failure of the cabin crew to activate the evacuation alarm and to maintain coordinated communication with the flight crew following the cabin crew’s decision to command an evacuation, which resulted in an engine running during the initial evacuation.… - [NTSB CEN25LA068](https://openairdocs.org/ntsb/CEN25LA068.md): Cirrus Design SR22T · Lubbock, TX · Accident · Minor injuries · Class 4 · Limited · Final report · Jan 3, 2025 · N725DC · Destroyed > The loss of directional control during the takeoff roll for undermined reasons that resulted in an impact with trees. - [NTSB CEN25LA067](https://openairdocs.org/ntsb/CEN25LA067.md): Robinson Helicopter R44 · Galveston, TX · Accident · No injuries · Class 4 · Limited · Final report · Dec 31, 2024 · N441HQ · Substantial damage > The pilot’s failure to maintain terrain clearance during the takeoff from the helipad in high and gusting wind conditions, that resulted in the right skid extension embedding in the artificial turf, and a subsequent dynamic rollover sequence. - [NTSB CEN25LA058](https://openairdocs.org/ntsb/CEN25LA058.md): Vans RV8 · Smithville, TX · Accident · Serious injuries · Class 3 · Limited · Final report · Dec 10, 2024 · N42CS · Substantial damage > A loss of engine power for undetermined reasons. - [NTSB CEN25LA031](https://openairdocs.org/ntsb/CEN25LA031.md): Robinson Helicopter R22 Beta · Pearland, TX · Accident · Minor injuries · Class 3 · Limited · Final report · Oct 27, 2024 · N7521Z · Substantial damage > The pilot’s failure to maintain control of the helicopter during lift off. - [NTSB CEN24LA361](https://openairdocs.org/ntsb/CEN24LA361.md): Rans S14 · Teague, TX · Accident · 1 fatal · Class 3 · Limited · Preliminary report · Sep 20, 2024 · UNREG · Substantial damage > On September 20, 2024, about 1648 central daylight time, an unregistered Rans S-14 Airaile light sport airplane, was substantially damaged when it was involved in an accident near Teague, Texas. The pilot was fatally injured. The airplane was operated as a… - [NTSB CEN24FA320](https://openairdocs.org/ntsb/CEN24FA320.md): Cessna 550 · Odessa, TX · Accident · 2 fatal · Class 3 · Field · Preliminary report · Aug 20, 2024 · N689VP · Destroyed > On August 20, 2024, about 0700 central daylight time, a Cessna 550 airplane, N689VP, was destroyed when it was involved in an accident near Odessa, Texas. The pilot and passenger were fatally injured. A person on the ground was seriously injured. The airplane… - [NTSB CEN24LA297](https://openairdocs.org/ntsb/CEN24LA297.md): Cessna 150F · Castroville, TX · Accident · No injuries · Class 4 · Limited · Final report · Jul 31, 2024 · N8840S · Substantial damage > The pilot’s inadequate recovery from a bounced landing and his failure to maintain proper airplane pitch control and airspeed during the go-around, which resulted in the airplane exceeding its critical angle-of-attack and an aerodynamic stall at a low… - [NTSB CEN24LA290](https://openairdocs.org/ntsb/CEN24LA290.md): Piper J3C-65 · Fort Worth, TX · Accident · No injuries · Class 4 · Limited · Final report · Jul 27, 2024 · N98813 · Substantial damage > The pilot’s decision to allow a non-rated passenger to manipulate the flight controls during the takeoff which resulted in a loss of directional control during the takeoff. - [NTSB CEN24LA256](https://openairdocs.org/ntsb/CEN24LA256.md): Globe GC-1B · Lone Oak, TX · Accident · Minor injuries · Class 4 · Limited · Final report · Jul 5, 2024 · N80740 · Substantial damage > The pilot having to take evasive action during the takeoff run to avoid another airplane being pushed onto the runway in front of him, which resulted in the airplane overrunning the runway and impacting a fence. - [NTSB CEN24LA255](https://openairdocs.org/ntsb/CEN24LA255.md): Air Tractor AT-802 · Brad, TX · Accident · No injuries · Class 4 · Limited · Final report · Jul 4, 2024 · N983LA · Substantial damage > The pilot’s failure to maintain airplane control after encountering a large boat wake. - [NTSB CEN24FA240](https://openairdocs.org/ntsb/CEN24FA240.md): Cessna 414A · McKinney, TX · Accident · 2 fatal · Class 3 · Field · Final report · Jun 27, 2024 · N414BS · Destroyed > The pilot's improper decision to attempt continued flight after a loss of left engine power with usable runway remaining and his subsequent failure to follow the emergency procedures and maintain air minimum control speed, which resulted in a loss of control.… - [NTSB CEN24LA236](https://openairdocs.org/ntsb/CEN24LA236.md): Cirrus Design SR22T · Boerne, TX · Accident · No injuries · Class 3 · Limited · Final report · Jun 23, 2024 · N87AQ · Substantial damage > Maintenance personnel’s inadequate adjustment of fuel flow, which resulted in an excessively rich mixture, a rough-running engine, and a subsequent partial loss of engine power. - [NTSB CEN24LA192](https://openairdocs.org/ntsb/CEN24LA192.md): Cessna 170 · Sealy, TX · Accident · No injuries · Class 4 · Limited · Final report · May 15, 2024 · N74887 · Substantial damage > The pilot’s failure to maintain directional control during the takeoff, that resulted in an impact with a tree and the ground. - [NTSB CEN24LA135](https://openairdocs.org/ntsb/CEN24LA135.md): Robinson Helicopter R44 · Knox City, TX · Accident · No injuries · Class 4 · Limited · Final report · Mar 13, 2024 · N3040P · Substantial damage > The pilot’s failure to maintain directional control during takeoff, which resulted in a rollover and an impact with terrain. - [NTSB CEN24LA132](https://openairdocs.org/ntsb/CEN24LA132.md): Pietenpol Aircamper · Lockhart, TX · Accident · No injuries · Class 4 · Limited · Final report · Mar 6, 2024 · N7710J · Substantial damage > The pilot’s failure to maintain control during after takeoff. - [NTSB CEN24LA131](https://openairdocs.org/ntsb/CEN24LA131.md): Piper PA-28-140 · Lubbock, TX · Accident · No injuries · Class 4 · Limited · Final report · Mar 5, 2024 · N603LH · Substantial damage > The student pilot’s failure to maintain directional control during a touch-and-go. - [NTSB CEN23LA424](https://openairdocs.org/ntsb/CEN23LA424.md): Powrachute Pegasus · Caddo Mills, TX · Accident · Serious injuries · Class 3 · Limited · Final report · Sep 28, 2023 · N31520 · Substantial damage > The pilot’s inadequate rolling preflight, which resulted in a loss of directional control in flight and subsequent collision with an object during landing. - [NTSB CEN23LA386](https://openairdocs.org/ntsb/CEN23LA386.md): Silverlight AR-1 · Granbury, TX · Accident · Serious injuries · Class 4 · Limited · Final report · Aug 20, 2023 · N57AR · Substantial damage > The pilot’s improper takeoff procedure which resulted in a loss of control during takeoff. - [NTSB CEN23LA309](https://openairdocs.org/ntsb/CEN23LA309.md): Piper J3C-65 · Princeton, TX · Accident · No injuries · Class 4 · Limited · Final report · Jul 16, 2023 · N41317 · Substantial damage > The student pilot’s decision to attempt a takeoff from an unimproved field which resulted in an impact with an obstacle. - [NTSB WPR23LA205](https://openairdocs.org/ntsb/WPR23LA205.md): Piaggio Aero Industries P180 · Sugar Land, TX · Accident · No injuries · Class 4 · Limited · Final report · May 27, 2023 · N327A · Substantial damage > The pilot’s failure to complete required preflight checklist items and properly configure the flaps for takeoff. Next page: https://openairdocs.org/ntsb-phases/300/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 = 300) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb-phases/300/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.