Ongoing NTSB investigations, TX
10 cases where the sequence of events included Unknown or undetermined.
Cases per year
| 2024 | 2 |
|---|---|
| 2025 | 3 |
| 2026 | 5 |
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\" = '000' 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" = '000' 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 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)…NTSB CEN26LA301Accident · Serious injuriesClass 4 · LimitedInvestigation openCessna 172M · Frankston, TXNTSB CEN26LA266Accident · Serious injuriesClass 3 · LimitedPreliminary reportPiper J3C-65 · Richmond, TXOn July 20, 2026, at 0643 central daylight time, a Piper J3C-65 airplane, N92432, sustained substantial damage when it was involved in an accident near Richmond, Texas. The commercial pilot sustained serious injuries. The airplane was operated as a Title 14…NTSB 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…NTSB 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…NTSB CEN26LA061Accident · Serious injuriesClass 3 · LimitedPreliminary reportBell Textron Canada 505 · Divot, TXOn December 13, 2025, about 1345 central standard time, a Bell Helicopter 505, N865S, was substantially damaged when it was involved in an accident near Divot, Texas. The pilot was seriously injured and the passenger sustained minor injuries. The helicopter…NTSB 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…NTSB CEN26FA012Accident · 1 fatalClass 3 · FieldPreliminary reportBeech A35 · Skidmore, TXOn October 7, 2025, at 1223 central daylight time, a Beech A35 airplane, N577B, was destroyed when it was involved in an accident near Skidmore, Texas. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations (CFR)…NTSB 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…NTSB 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…