# NTSB investigations, TX: Initial climb 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,459 cases ## Latest cases - [NTSB ANC26LA107](https://openairdocs.org/ntsb/ANC26LA107.md): Piper PA-28-140 · Junction, TX · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Sep 21, 2026 · N224BB · Substantial damage > On September 20, 2026 about 2314 central daylight time, a Piper PA-28-140 airplane, N224BB, was substantially damaged when it was involved in an accident near Junction, Texas. The pilot and passenger were seriously injured. The airplane was operated as a… - [NTSB CEN26LA282](https://openairdocs.org/ntsb/CEN26LA282.md): Pzl-Bielsko B1-PW-5 · Briggs, TX · Accident · 1 fatal · Class 3 · Limited · Preliminary report · Aug 6, 2026 · N105WS · Substantial damage > On August 6, 2026, about 1538 central daylight time, a PZL-Bielsko B1-PW-5 glider, N105WS, was substantially damaged when it was involved in an accident near Briggs, Texas. The pilot was fatally injured. The glider was operated as a Title 14 Code of Federal… - [NTSB CEN26LA284](https://openairdocs.org/ntsb/CEN26LA284.md): Cessna 150M · Ferris, TX · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Jul 25, 2026 · N18YZ · Substantial damage > On July 25, 2026, about 1630 central daylight time, a Cessna 150M, N18YZ, was substantially damaged when it was involved in an accident near Ferris, Texas. One pilot sustained minor injuries and the other pilot had no injuries. The airplane was operated as a… - [NTSB CEN26LA244](https://openairdocs.org/ntsb/CEN26LA244.md): Cassutt Iiim · Odessa, TX · Accident · Serious injuries · Class 4 · Limited · Final report · Jul 5, 2026 · N45889 · Substantial damage > The pilot’s exceedance of the airplane’s critical angle of attack during the initial climb, which led to an aerodynamic stall and a loss of airplane control at too low of an altitude to recover. Contributing to the accident was the pilot’s lack of recent… - [NTSB CEN26LA220](https://openairdocs.org/ntsb/CEN26LA220.md): Aero Commander 112 · Fabens, TX · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Jun 6, 2026 · N27007 · Substantial damage > On June 6, 2026, at 0900 central daylight time, an Aero Commander, N27007, sustained substantial damage when it was involved in an accident in Fabens, Texas. The private pilot received minor injuries. The airplane was operated as a Title 14 Code of Federal… - [NTSB CEN26LA202](https://openairdocs.org/ntsb/CEN26LA202.md): Piper PA-32R-300 · Comanche, TX · Accident · No injuries · Class 3 · Limited · Preliminary report · May 22, 2026 · N4556Q · Substantial damage > On May 22, 2026, about 1840 central daylight time, a Piper PA-32R-300 airplane, N4556Q, was substantially damaged during an accident near Comanche, Texas. The pilot and passenger were not injured. The airplane was operated as a Title 14 Code of Federal… - [NTSB CEN26LA149](https://openairdocs.org/ntsb/CEN26LA149.md): Piper PA28 · Atlanta, TX · Accident · No injuries · Class 3 · Limited · Preliminary report · Mar 26, 2026 · N1653J · Substantial damage > On March 26, 2026, about 0720 central daylight time, a Piper PA28-140 airplane, N1653J, was substantially damaged when it was involved in an accident near Atlanta, Texas. The pilot was not injured. The flight was operated under the provisions of Title 14 Code… - [NTSB CEN26LA110](https://openairdocs.org/ntsb/CEN26LA110.md): Glasair GlaStar · Beaumont, TX · Accident · No injuries · Class 3 · Limited · Preliminary report · Feb 7, 2026 · N789BM · Substantial damage > On February 6, 2026, about 1810 central standard time, an experimental Glasair GlaStar airplane, N789BM, was substantially damaged when it was involved in an accident near Beaumont, Texas. The pilot was not injured. The airplane was operated as a Title 14… - [NTSB CEN26LA079](https://openairdocs.org/ntsb/CEN26LA079.md): Canard Aero SW-51 Mustang · Fredericksburg, TX · Accident · No injuries · Class 3 · Limited · Preliminary report · Jan 5, 2026 · N351MT · Substantial damage > On January 5, 2026, about 1545 central standard time, a Canard Aero LLC (Scalewings) SW-51 Mustang, N351MT, was substantially damaged when it was involved in an accident near Fredericksburg, Texas. The pilot was not injured. The airplane was operated as a… - [NTSB CEN26LA077](https://openairdocs.org/ntsb/CEN26LA077.md): Beech B35 · La Casa, TX · Accident · No injuries · Class 4 · Limited · Final report · Jan 2, 2026 · N5174C · Substantial damage > The pilot’s exceedance of the airplane’s critical angle of attack during initial climb after takeoff, leading to an aerodynamic stall and impact with trees. - [NTSB CEN25LA360](https://openairdocs.org/ntsb/CEN25LA360.md): Cessna 172H · Goliad, TX · Accident · No injuries · Class 3 · Limited · Preliminary report · Aug 28, 2025 · N8078L · Substantial damage > On August 27, 2025, about 1904 central daylight time, a Cessna 172H airplane, N8078L, was substantially damaged when it was involved in an accident near Goliad, Texas. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal… - [NTSB CEN25LA355](https://openairdocs.org/ntsb/CEN25LA355.md): Cessna 172M · Lubbock, TX · Accident · Minor injuries · Class 4 · Limited · Final report · Aug 27, 2025 · N92356 · Substantial damage > The pilot’s mismanagement of available fuel, which resulted in a loss of engine power due to fuel starvation. - [NTSB CEN25LA300](https://openairdocs.org/ntsb/CEN25LA300.md): Cessna 172P · Gainesville, TX · Accident · No injuries · Class 3 · Limited · Preliminary report · Aug 1, 2025 · N62296 · Substantial damage > On August 1, 2025, about 0802 central daylight time, a Cessna 172P airplane, N62296, was substantially damaged during an accident near Gainesville, Texas. The flight instructor and pilot-receiving-instruction were not injured. The airplane was operated as a… - [NTSB CEN25LA199](https://openairdocs.org/ntsb/CEN25LA199.md): Cessna 182P · Mineral Wells, TX · Accident · No injuries · Class 4 · Limited · Final report · Jun 8, 2025 · N7376N · Substantial damage > The pilot’s improper fuel tank selection prior to takeoff, which resulted in a total loss of engine power due to fuel starvation. Contributing to the accident was the pilot’s failure to follow the airplane checklist. - [NTSB CEN25LA182](https://openairdocs.org/ntsb/CEN25LA182.md): Beech F33A · Houston, TX · Accident · No injuries · Class 3 · Limited · Preliminary report · May 16, 2025 · N6376S · Destroyed > On May 16, 2025, about 1459 central daylight time, a Beech F33A airplane, N6376S, was destroyed when it was involved in an accident near Houston, Texas. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal Regulations Part 91… - [NTSB CEN25LA117](https://openairdocs.org/ntsb/CEN25LA117.md): Vans RV-7A · Plainview, TX · Accident · No injuries · Class 3 · Limited · Final report · Mar 10, 2025 · N923ZA · Substantial damage > The improper machining of the propeller blade bearing seat, which resulted in an inflight propeller blade fatigue failure. Contributing to the accident was the improper machining of the propeller hub and propeller blade root and machining surface quality… - [NTSB CEN25LA096](https://openairdocs.org/ntsb/CEN25LA096.md): Grumman American Avn. AA-5A · Gladewater, TX · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Feb 18, 2025 · N26071 · Substantial damage > On February 17, 2025, about 2215 central standard time, a Grumman AA-5A airplane, N26071, was substantially damaged when it was involved in an accident near Gladewater, Texas. The pilot sustained minor injuries. The airplane was operated as a Title 14 Code of… - [NTSB CEN25LA099](https://openairdocs.org/ntsb/CEN25LA099.md): Cessna 172N · Pearland, TX · Accident · No injuries · Class 4 · Limited · Final report · Feb 17, 2025 · N2913E · Substantial damage > The pilot’s poor flight planning and decision making, which resulted in a loss of engine power due to fuel exhaustion. - [NTSB CEN25LA079](https://openairdocs.org/ntsb/CEN25LA079.md): Piper PA-24-250 · Tyler, TX · Accident · No injuries · Class 3 · Limited · Final report · Jan 15, 2025 · N8051P · Substantial damage > An electrical system surge for a reason that could not be determined that resulted in an overvoltage event, internal damage to electronics equipment, smoke in the cockpit, and a gear up landing. - [NTSB CEN25LA077](https://openairdocs.org/ntsb/CEN25LA077.md): Piper PA-28-181 · Addison, TX · Accident · No injuries · Class 3 · Limited · Final report · Jan 15, 2025 · N504AF · Substantial damage > A partial loss of engine power during takeoff due to the partial blockage of the fuel diaphragm metering stem and the No. 1 cylinder fuel injector nozzle. Contributing to the accident was maintenance that allowed the introduction of debris that resulted in… - [NTSB CEN25LA054](https://openairdocs.org/ntsb/CEN25LA054.md): American AA-1B · Brenham, TX · Accident · No injuries · Class 3 · Limited · Final report · Dec 1, 2024 · N6242L · Substantial damage > A partial loss of engine power due to an obstructed induction system from a mud dauber nest. - [NTSB CEN25LA042](https://openairdocs.org/ntsb/CEN25LA042.md): Piper PA-23-160 · Manvel, TX · Accident · No injuries · Class 3 · Limited · Final report · Nov 15, 2024 · N4143P · Substantial damage > A loss of left engine power during the initial climb due to restricted fuel flow as a result of a binding fuel control cable. - [NTSB CEN25LA025](https://openairdocs.org/ntsb/CEN25LA025.md): Boeing A75N1 · Denton, TX · Accident · No injuries · Class 4 · Limited · Final report · Oct 21, 2024 · N62394 · Substantial damage > The partial loss of engine power during the initial climb and the pilot’s failure to maintain directional control during the forced landing with a tailwind. - [NTSB CEN25LA009](https://openairdocs.org/ntsb/CEN25LA009.md): Quicksilver GT 400 · Garden Ridge, TX · Accident · Serious injuries · Class 3 · Limited · Final report · Oct 8, 2024 · N2490H · Substantial damage > A loss of engine power that resulted from improper fuel system maintenance and the subsequent fuel starvation due to the leaking fuel pump outlet fuel line. - [NTSB CEN25LA007](https://openairdocs.org/ntsb/CEN25LA007.md): Mooney M20E · Richmond, TX · Accident · No injuries · Class 3 · Limited · Final report · Oct 8, 2024 · N9151V · Substantial damage > The partial separation of a portion of the propeller spinner and its mounting bulkhead along with the upper cowl fairing while in a full-power climb. - [NTSB CEN25LA004](https://openairdocs.org/ntsb/CEN25LA004.md): Boeing E75 · Sanger, TX · Accident · Serious injuries · Class 4 · Limited · Final report · Oct 4, 2024 · N1612M · Substantial damage > The pilot’s failure to maintain airplane control. - [NTSB CEN24LA363](https://openairdocs.org/ntsb/CEN24LA363.md): Kitfox IV 1200 Spdst · Cleburne, TX · Accident · Minor injuries · Class 4 · Limited · Final report · Sep 21, 2024 · N16KR · Substantial damage > The pilot’s failure to maintain aircraft control, which resulted in an aerodynamic stall and impact with terrain. - [NTSB CEN24FA305](https://openairdocs.org/ntsb/CEN24FA305.md): Cessna 172F · Brazoria, TX · Accident · 1 fatal · Class 3 · Field · Final report · Aug 6, 2024 · N7905U · Substantial damage > The pilot’s failure to attain adequate airspeed for takeoff, which led to the airplane exceeding its critical angle-of-attack and an aerodynamic stall. Contributing to the accident was the pilot’s failure to abort the takeoff after not maintaining directional… - [NTSB CEN24LA268](https://openairdocs.org/ntsb/CEN24LA268.md): Piper PA-28-181 · Arcola, TX · Accident · Minor injuries · Class 3 · Limited · Final report · Jul 16, 2024 · N1941V · Substantial damage > Loss of engine power due to fuel starvation as a result of the mechanic’s failure to properly secure the fuel system gascolator strainer bowl following an annual inspection. - [NTSB CEN24FA218](https://openairdocs.org/ntsb/CEN24FA218.md): Cessna 172 · Gainesville, TX · Accident · 1 fatal · Class 3 · Field · Final report · Jun 12, 2024 · N656MA · Substantial damage > The fuel pump manufacturer’s improper torquing of screws on the engine-driven fuel pump, which resulted in a disruption in the fuel system and a loss of engine power on initial climb. - [NTSB CEN24LA208](https://openairdocs.org/ntsb/CEN24LA208.md): Piper PA-38-112 · Dalhart, TX · Accident · No injuries · Class 4 · Limited · Final report · Jun 1, 2024 · N9715T · Substantial damage > The pilot’s improper decision to take off with the airplane over its maximum allowable gross weight at a high density altitude, which degraded its climb performance and led an off airport landing. - [NTSB CEN24LA200](https://openairdocs.org/ntsb/CEN24LA200.md): Piper PA28 · Taylor, TX · Accident · Minor injuries · Class 3 · Limited · Final report · May 27, 2024 · N56466 · Substantial damage > A partial loss of engine power due to an incorrect carburetor air inlet hose, which led to a reduction in air flow to the engine. - [NTSB CEN24FA164](https://openairdocs.org/ntsb/CEN24FA164.md): Lancair Legacy FG · Spicewood, TX · Accident · 1 fatal · Class 3 · Field · Final report · Apr 22, 2024 · N550NL · Destroyed > The pilot’s failure to properly configure the airplane during a go-around in gusting wind conditions, and his subsequent exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall at an altitude too low for recovery. - [NTSB CEN24LA102](https://openairdocs.org/ntsb/CEN24LA102.md): Cessna 172 · Terrell, TX · Accident · Minor injuries · Class 3 · Limited · Final report · Jan 30, 2024 · N8805Z · Substantial damage > The total loss of engine power during the initial climb due to fuel exhaustion. - [NTSB CEN24LA065](https://openairdocs.org/ntsb/CEN24LA065.md): Beech B36TC · Burnet, TX · Accident · Serious injuries · Class 3 · Limited · Final report · Dec 17, 2023 · N70SL · Destroyed > The loss of engine power due an overly rich mixture from an improper adjustment of the fuel pump, which resulted in a forced landing and impact with a car and terrain. - [NTSB CEN23FA401](https://openairdocs.org/ntsb/CEN23FA401.md): Cessna 150K · Huntsville, TX · Accident · 2 fatal · Class 3 · Field · Final report · Sep 6, 2023 · N6059G · Substantial damage > A partial loss of engine power due to fuel starvation caused by a fuel system blockage, and the flight instructor’s subsequent failure to maintain adequate airspeed after the loss of engine power, which resulted in the airplane exceeding its critical angle of… - [NTSB CEN23LA231](https://openairdocs.org/ntsb/CEN23LA231.md): Cessna 207 · Harlingen, TX · Accident · No injuries · Class 3 · Limited · Final report · Jun 6, 2023 · N91157 · Substantial damage > The improper installation of the throttle control arm to the throttle control cable attachment end, which resulted in a failure of the control arm and a loss of engine power in flight. - [NTSB CEN23FA139](https://openairdocs.org/ntsb/CEN23FA139.md): Beech 58P · Lubbock, TX · Accident · 1 fatal · Class 3 · Field · Final report · Mar 17, 2023 · N2061K · Destroyed > The pilot’s failure to ensure a proper fuel selector position before takeoff, which resulted in a loss of left engine power due to fuel starvation. Contributing to the accident was the pilot’s failure to maintain airplane control after the loss of left engine… - [NTSB CEN23LA131](https://openairdocs.org/ntsb/CEN23LA131.md): Beech E-55 · Tomball, TX · Accident · No injuries · Class 4 · Limited · Final report · Mar 6, 2023 · N101BM · Substantial damage > An inflight collision with a bird. - [NTSB CEN23LA108](https://openairdocs.org/ntsb/CEN23LA108.md): Cessna 172H · Crosby, TX · Accident · Serious injuries · Class 3 · Limited · Final report · Feb 12, 2023 · N3238L · Substantial damage > The pilot’s delayed soft-field takeoff procedure, which prevented the pilot from achieving adequate airspeed and a proper climb rate resulting in a collision with a moving train. - [NTSB CEN23FA057](https://openairdocs.org/ntsb/CEN23FA057.md): Cessna 210-5(205) · Cleburne, TX · Accident · 2 fatal · Class 3 · Field · Final report · Dec 5, 2022 · N8149Z · Destroyed > An in-flight loss of control as a result of spatial disorientation in night instrument meteorological conditions. - [NTSB CEN23LA003](https://openairdocs.org/ntsb/CEN23LA003.md): Embraer S A EMB-545 · Houston, TX · Accident · No injuries · Class 3 · Limited · Final report · Oct 3, 2022 · N179SP · Substantial damage > The crew failed to ensure the main entry door was locked before departure. Contributing to the accident was a corroded/jammed door sensor that provided an erroneous locked indication to the crew alerting system. - [NTSB CEN22LA423](https://openairdocs.org/ntsb/CEN22LA423.md): Luscombe 8 · Kingsbury, TX · Accident · Minor injuries · Class 3 · Limited · Final report · Sep 10, 2022 · N25144 · Substantial damage > A total loss of engine power due to a failure of the ignition switch from carbon tracking, which resulted in a forced landing and a subsequent impact with trees. - [NTSB CEN22LA413](https://openairdocs.org/ntsb/CEN22LA413.md): Piper PA32RT · Bulverde, TX · Accident · No injuries · Class 3 · Limited · Final report · Sep 9, 2022 · N31981 · Substantial damage > The partial loss of engine power due to excessive carbon deposits that resulted in one or more stuck exhaust valves. - [NTSB CEN22LA283](https://openairdocs.org/ntsb/CEN22LA283.md): Osprey II · Bulverde, TX · Accident · No injuries · Class 3 · Limited · Final report · Jun 24, 2022 · N10236 · Substantial damage > A loss of engine power due to fuel starvation due to a blockage of the fuel tank outlet port. - [NTSB CEN22LA252](https://openairdocs.org/ntsb/CEN22LA252.md): Meyers Industries 200A · Weslaco, TX · Accident · No injuries · Class 3 · Limited · Final report · Jun 16, 2022 · N489C · Substantial damage > A total loss of engine power for reasons that could not be determined. - [NTSB CEN22LA190](https://openairdocs.org/ntsb/CEN22LA190.md): Cessna 421 · Houston, TX · Accident · Minor injuries · Class 3 · Limited · Final report · May 6, 2022 · XB-FQS · Substantial damage > The fixed-base operator’s incorrect fueling of the airplane, which resulted in a total loss of power in both engines. - [NTSB CEN22LA187](https://openairdocs.org/ntsb/CEN22LA187.md): North American AT-6D · Fredericksburg, TX · Accident · No injuries · Class 3 · Limited · Final report · Apr 30, 2022 · N29947 · Substantial damage > A total loss of engine power due to a failure of the No. 1 cylinder. - [NTSB CEN22LA180](https://openairdocs.org/ntsb/CEN22LA180.md): Globe GC-1B · Huntsville, TX · Accident · Serious injuries · Class 4 · Limited · Final report · Apr 14, 2022 · N78096 · Substantial damage > The pilot’s inadequate fuel management which resulted in a total loss of engine power due to fuel starvation. - [NTSB CEN22LA150](https://openairdocs.org/ntsb/CEN22LA150.md): Sparrow Hawk III · Lubbock, TX · Accident · No injuries · Class 4 · Limited · Final report · Mar 23, 2022 · N430HS · Substantial damage > The pilot’s failure to maintain control of the gyrocopter during takeoff with strong gusty winds. Next page: https://openairdocs.org/ntsb-phases/350/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 = 350) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb-phases/350/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.