Ongoing NTSB investigations, TX

27 cases where the phase of flight was Enroute.

Cases per year

20242026
Ongoing NTSB investigations, TX per year, 2024–2026: 27 cases
20243
202513
202611

Latest cases

Query with SQL
duckdb -csv -c "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.\"completionStatus\" = 'Ongoing'
    AND c.\"mKey\" IN (SELECT case_mkey FROM case_phases WHERE main = 400)
  ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

NTSB CEN27LA028Accident · No injuriesClass 3 · LimitedPreliminary reportCessna P206 · Nacogdoches, TXOn October 22, 2026, about 1644 central daylight time, a Cessna P206, N2649X, was substantially damaged when it was involved in an accident near Nacogdoches, Texas. The pilot and passenger were not injured. The airplane was operated as a Title 14 Code of…Oct 22, 2026 · N2649X · Substantial damageNTSB CEN26LA314Accident · No injuriesClass 4 · LimitedInvestigation openCessna 150F · Weslaco, TXSep 8, 2026 · N8061F · Substantial damageNTSB DCA26LA340Accident · Serious injuriesClass 4 · LimitedInvestigation openAirbus A319-132 · Houston, TXAug 27, 2026 · N884UA · No damageNTSB CEN26LA287Accident · Minor injuriesClass 3 · LimitedPreliminary reportMooney M20G · Luling, TXOn 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…Aug 13, 2026 · N6916N · Substantial damageNTSB CEN26LA230Accident · Serious injuriesClass 3 · LimitedPreliminary reportZenith 601 XL · O'Donnell, TXOn 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…Jun 20, 2026 · N165TJ · Substantial damageNTSB CEN26FA228Accident · 1 fatalClass 3 · FieldPreliminary reportTextron 680A · Laredo, TXOn 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…Jun 17, 2026 · N523QS · Substantial damageNTSB WPR26LA218Accident · Minor injuriesClass 3 · LimitedPreliminary reportPiper PA24 · Graham, TXOn June 12, 2026, about 2100 Central Daylight Time, a Piper PA-24-400, N400HL, was substantially damaged when it was involved in an accident near Graham, Texas. The pilot sustained minor injuries. The airplane was operated as a Title 14 Code of Federal…Jun 13, 2026 · N400HL · Substantial damageNTSB CEN26LA190Accident · 1 fatalClass 3 · LimitedPreliminary reportDowner 14-19-3 · Forney, TXOn 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…May 16, 2026 · N7NL · Substantial damageNTSB CEN26FA174Accident · 5 fatalClass 3 · FieldPreliminary reportCessna 421 · Wimberley, TXOn 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…May 1, 2026 · N291AN · DestroyedNTSB CEN26LA129Accident · No injuriesClass 4 · LimitedInvestigation openCameron Balloons US Z-77 · East Mountain, TXFeb 28, 2026 · N699DF · Substantial damageNTSB CEN26FA086Accident · 1 fatalClass 3 · FieldPreliminary reportBeech A36 · Sabine Pass, TXOn 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…Jan 8, 2026 · N5677X · Substantial damageNTSB CEN26FA071Accident · 1 fatalClass 3 · FieldPreliminary reportLancair Legacy · Fredericksburg, TXOn 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…Dec 30, 2025 · N618AM · DestroyedNTSB CEN26LA082Accident · No injuriesClass 3 · LimitedPreliminary reportWag Aero Cuby · Wimberley, TXOn 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…Dec 26, 2025 · N437WT · Substantial damageNTSB CEN26LA046Accident · No injuriesClass 3 · LimitedPreliminary reportCirrus Design SR22 · Teague, TXOn 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…Nov 13, 2025 · N79EM · Substantial damageNTSB CEN26LA031Accident · No injuriesClass 3 · LimitedPreliminary reportDenney Kitfox · Chilton, TXOn 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…Oct 27, 2025 · N5241N · Substantial damageNTSB CEN26LA030Accident · No injuriesClass 3 · LimitedPreliminary reportPiper PA-46-310P · El Paso, TXOn 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…Oct 26, 2025 · N46CR · Substantial damageNTSB CEN26LA016Accident · No injuriesClass 3 · LimitedPreliminary reportRotorway AG162 · Valley View, TXOn 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…Oct 13, 2025 · N162AD · Substantial damageNTSB CEN25LA317Accident · No injuriesClass 3 · LimitedPreliminary reportCessna P210 · Zapata, TXOn 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…Aug 13, 2025 · N92MS · Substantial damageNTSB CEN25LA291Accident · No injuriesClass 3 · LimitedPreliminary reportMatesi Eugene E Lancair 320 · Wink, TXOn 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…Jul 28, 2025 · N70337 · Substantial damageNTSB CEN25LA282Accident · No injuriesClass 3 · LimitedPreliminary reportCessna T210N · Crosby, TXOn 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…Jul 21, 2025 · N93HP · Substantial damageNTSB CEN25LA242Incident · No injuriesClass 3 · LimitedPreliminary reportSikorsky UH60 · Ingram, TXOn 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…Jul 7, 2025 · UNREG · Minor damageNTSB CEN25LA205Accident · No injuriesClass 3 · LimitedPreliminary reportLancair 360 · Fort Stockton, TXOn 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…Jun 12, 2025 · N77LH · DestroyedNTSB CEN25FA183Accident · 1 fatalClass 3 · FieldPreliminary reportRobinson Helicopter R44 II · Miami, TXOn 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…May 23, 2025 · N1195P · DestroyedNTSB CEN25LA156Accident · No injuriesClass 3 · LimitedPreliminary reportMooney M20J · Edinburg, TXOn 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…Apr 12, 2025 · N5807T · Substantial damageNTSB CEN25FA052Accident · 2 fatalClass 3 · FieldPreliminary reportCozy MK III · Mineola, TXOn 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…Nov 28, 2024 · N51810 · DestroyedNTSB CEN25FA005Accident · 1 fatalClass 3 · FieldPreliminary reportChampion 7EC · Fort Worth, TXOn 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…Oct 7, 2024 · N4337C · Substantial damageNTSB CEN24LA311Accident · No injuriesClass 3 · LimitedPreliminary reportPiper PA-34-200T · Wills Point, TXOn 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…Jul 31, 2024 · N2106E · Substantial damage