Ongoing NTSB investigations, TX
12 cases where the sequence of events included Loss of engine power (partial).
Cases per year
| 2025 | 6 |
|---|---|
| 2026 | 6 |
Where
Open the mapLatest cases
Query with SQL
duckdb -csv -c "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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '342' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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.
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '342' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB 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…NTSB 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…NTSB CEN26LA220Accident · Minor injuriesClass 3 · LimitedPreliminary reportAero Commander 112 · Fabens, TXOn 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 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…NTSB 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…NTSB 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…NTSB 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…NTSB CEN25LA360Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 172H · Goliad, TXOn 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 CEN25LA182Accident · No injuriesClass 3 · LimitedPreliminary reportBeech F33A · Houston, TXOn 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 WPR25FA127Accident · 1 fatalClass 3 · FieldPreliminary reportAzalea Saberwing · Justin, TXOn April 11, 2025, about 1906 central daylight time (CDT), an experimental amateur-built Azalea Aviation LLC Saberwing, N121DF, was destroyed when it was involved in an accident near Justin, Texas. The pilot was fatally injured. The airplane was operated as a…NTSB CEN25LA096Accident · Minor injuriesClass 3 · LimitedPreliminary reportGrumman American Avn. AA-5A · Gladewater, TXOn 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 CEN25LA097Accident · Serious injuriesClass 3 · LimitedPreliminary reportDouglas A-20G · Laredo, TXOn February 16, 2025, about 1239 central standard time, a Douglas A-20G airplane, N747HS, was substantially damaged when it was involved in an accident in Laredo, Texas. The pilot was seriously injured. The airplane was operated as a Title 14 Code of Federal…