Ongoing NTSB investigations, TX

21 cases where the phase of flight was Takeoff.

Cases per year

20242026
Ongoing NTSB investigations, TX per year, 2024–2026: 21 cases
20242
20253
202616

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 = 300)
  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 CEN27LA032AccidentClass 3 · LimitedInvestigation openLuscombe 8A · Fredericksburg, TXOct 23, 2026 · N1329KNTSB CEN27FA006Accident · 1 fatalClass 3 · FieldPreliminary reportLancair IV · Haslet, TXOn 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)…Oct 7, 2026 · N5SV · DestroyedNTSB CEN27LA004Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 414A · Boerne, TXOn 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…Oct 2, 2026 · N1245A · Substantial damageNTSB CEN26LA312Accident · Minor injuriesClass 3 · LimitedPreliminary reportCessna 337 · Brenham, TXOn 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…Sep 7, 2026 · N2657S · Substantial damageNTSB CEN26LA306Accident · No injuriesClass 4 · LimitedInvestigation openCirrus Design SR22T · Spicewood, TXAug 31, 2026 · N115JB · Substantial damageNTSB ANC26LA092Accident · Minor injuriesClass 4 · LimitedInvestigation openAutogyro Cavalon · Conroe, TXAug 27, 2026 · N128NR · Substantial damageNTSB WPR26LA319Accident · No injuriesClass 4 · LimitedInvestigation openRotorsport UK Rotorsport UK Cavalo · Brenham, TXAug 22, 2026 · N987AG · Substantial damageNTSB CEN26LA302Accident · Minor injuriesClass 4 · LimitedInvestigation openPiper PA-22-150 · Brenham, TXAug 22, 2026 · N7517D · Substantial damageNTSB CEN26LA265Accident · Minor injuriesClass 3 · LimitedPreliminary reportPiper PA-28-180 · Bulverde, TXOn 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…Jul 20, 2026 · N454MD · Substantial damageNTSB WPR26LA215Accident · Minor injuriesClass 3 · LimitedPreliminary reportCessna 172 · Cleburne, TXOn 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…Jun 9, 2026 · N1330Y · Substantial damageNTSB CEN26LA204Accident · Minor injuriesClass 3 · LimitedPreliminary reportMustang Aeronautics Mustang II · Richmond, TXOn 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…May 28, 2026 · N160MT · Substantial damageNTSB CEN26LA187Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 172S · Denton, TXOn 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…May 13, 2026 · N2134M · Substantial damageNTSB CEN26LA143Accident · Serious injuriesClass 3 · LimitedPreliminary reportCessna 172P · Denton, TXOn 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…Mar 20, 2026 · N65614 · Substantial damageNTSB ANC26LA018Accident · No injuriesClass 3 · LimitedPreliminary reportBell Textron Canada 505 · Fort Worth, TXOn 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…Mar 8, 2026 · N911FW · Substantial damageNTSB CEN26LA137Accident · Minor injuriesClass 3 · LimitedPreliminary reportPiper PA-12 · Lockhart, TXOn 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…Mar 7, 2026 · N2511M · Substantial damageNTSB CEN26LA097Accident · No injuriesClass 3 · LimitedPreliminary reportQuicksilver II · Spring, TXOn 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…Jan 20, 2026 · N4NH · Substantial damageNTSB CEN26LA072Accident · No injuriesClass 3 · LimitedPreliminary reportCirrus Design SR22T · Muleshoe, TXOn 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…Dec 18, 2025 · N53KH · Substantial damageNTSB CEN25LA386Accident · No injuriesClass 3 · LimitedPreliminary reportMooney M20K · Pearland, TXOn 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…Sep 16, 2025 · N305EP · Substantial damageNTSB CEN25FA119Accident · 1 fatalClass 3 · FieldPreliminary reportCessna 525 · Mesquite, TXOn 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…Mar 13, 2025 · N525CZ · DestroyedNTSB CEN24LA361Accident · 1 fatalClass 3 · LimitedPreliminary reportRans S14 · Teague, TXOn 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…Sep 20, 2024 · UNREG · Substantial damageNTSB CEN24FA320Accident · 2 fatalClass 3 · FieldPreliminary reportCessna 550 · Odessa, TXOn 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…Aug 20, 2024 · N689VP · Destroyed