Ongoing NTSB investigations, TX
9 cases where the sequence of events included Collision with terr/obj (non-CFIT).
Cases per year
| 2024 | 1 |
|---|---|
| 2025 | 4 |
| 2026 | 4 |
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\" = '470' 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" = '470' 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 ERA26FA294Accident · 1 fatalClass 3 · FieldPreliminary reportBachem Fritz M Avid Mark IV · Arp, TXOn August 9, 2026, at about 1655 central daylight time, an experimental amateur-built Avid Mark IV, N77FB, was substantially damaged when it was involved in an accident near Arp, Texas. The private pilot was fatally injured. The airplane was operated as a…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 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 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…NTSB CEN26LA024Accident · Serious injuriesClass 3 · LimitedPreliminary reportVans RV8 · McKinney, TXOn October 17, 2025, at 0921 central daylight time, an amateur-built RV-8 airplane, N3545W, was substantially damaged when it was involved in an accident near McKinney, Texas. The pilot was seriously injured. The airplane was operated as a Title 14 Code of…NTSB ERA26FA010Accident · 2 fatalClass 3 · FieldPreliminary reportBeech C90 · Fort Worth, TXOn October 12, 2025, about 1334 central daylight time, a Beech C90, N291CC, was destroyed when it was involved in an accident near Fort Worth, Texas. The private pilot and pilot-rated passenger were fatally injured. The airplane was operated as a Title 14…NTSB 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…NTSB CEN25FA184Accident · 2 fatalClass 3 · FieldPreliminary reportRockwell Commander 114A · Hankamer, TXOn May 24, 2025, about 1658 central daylight time (CDT), a Rockwell Commander 114A airplane, N5903N, was destroyed when it was involved in an accident near Hankamer, Texas. The private pilot and passenger were fatally injured. The airplane was operated under…NTSB 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…