Ongoing NTSB investigations, TX
25 cases where the sequence of events included Loss of engine power (total).
Cases per year
| 2024 | 2 |
|---|---|
| 2025 | 11 |
| 2026 | 12 |
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\" = '341' 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" = '341' 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 CEN27LA028Accident · No injuriesClass 3 · LimitedInvestigation openCessna P206 · Nacogdoches, TXNTSB WPR27LA021Accident · No injuriesClass 4 · LimitedInvestigation openCessna 182A · Galveston, TXNTSB ANC26LA107Accident · Serious injuriesClass 3 · LimitedPreliminary reportPiper PA-28-140 · Junction, TXOn 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 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…NTSB 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…NTSB CEN26LA284Accident · Minor injuriesClass 3 · LimitedPreliminary reportCessna 150M · Ferris, TXOn 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 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 CEN26LA202Accident · No injuriesClass 3 · LimitedPreliminary reportPiper PA-32R-300 · Comanche, TXOn 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 CEN26LA164Accident · Serious injuriesClass 3 · LimitedPreliminary reportPiper PA-28-180 · Corpus Christi, TXOn April 13, 2026, about 19:19 central daylight time, a Piper Cherokee PA-28-180 airplane, N317HM was destroyed when it was involved in an accident near Corpus Christi, Texas. The flight instructor and student pilot were seriously injured. The airplane was…NTSB CEN26LA149Accident · No injuriesClass 3 · LimitedPreliminary reportPiper PA28 · Atlanta, TXOn 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 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…NTSB CEN26LA079Accident · No injuriesClass 3 · LimitedPreliminary reportCanard Aero SW-51 Mustang · Fredericksburg, TXOn 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 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…NTSB CEN26LA060Accident · Serious injuriesClass 3 · LimitedPreliminary reportSonerai II · Cresson, TXOn December 12, 2025, about 1431 central standard time, a Sonerai II airplane, registration N28MD, was substantially damaged when it was involved in an accident near Cresson, Texas. The pilot was seriously injured. The airplane was operated as a Title 14 Code…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB CEN25LA300Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 172P · Gainesville, TXOn 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 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…NTSB 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…NTSB 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…NTSB CEN25LA103Accident · Minor injuriesClass 3 · LimitedPreliminary reportStarduster II · Azle, TXOn February 24, 2025, at 1430 central standard time, a Starduster II airplane, N78WT, was destroyed when it was involved in an accident near Azle, Texas. The private pilot and a passenger received minor injuries. The airplane was operated as a Title 14 Code…NTSB 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…NTSB 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…