NTSB investigations, TX
22 cases where the defining event was Collision with terr/obj (non-CFIT).
Cases per year
| 2008 | 6 |
|---|---|
| 2010 | 5 |
| 2018 | 1 |
| 2020 | 1 |
| 2021 | 1 |
| 2023 | 3 |
| 2024 | 1 |
| 2025 | 2 |
| 2026 | 2 |
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.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '470')
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."mKey" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '470') 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 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 CEN26LA112Accident · Minor injuriesClass 4 · LimitedFinal reportSocata TBM 700 · Crockett, TXThe pilot’s failure to maintain airplane control during a go-around that resulted in a collision with terrain.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 CEN25LA188Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-18 · Vega, TXThe airplane’s inadvertent encounter with a localized low boundary layer, which caused a wind shift, and a gusting tailwind during final approach, that resulted in the pilot deciding to impact a wind cone and a subsequent impact with terrain. Contributing was…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…NTSB CEN23LA309Accident · No injuriesClass 4 · LimitedFinal reportPiper J3C-65 · Princeton, TXThe student pilot’s decision to attempt a takeoff from an unimproved field which resulted in an impact with an obstacle.NTSB CEN23LA207Accident · No injuriesClass 4 · LimitedFinal reportAmerican AA-5 · Fort Worth, TXAn inflight collision with a bird.NTSB CEN23LA097Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172L · Cleveland, TXThe pilot’s decision to attempt the night flight under visual flight rules when instrument meteorological conditions prevailed resulting in the airplane striking trees while on final approach. Contributing to the accident were the unserviceable runway lights…NTSB CEN21LA158Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 150H · Paris, TXThe pilot’s decision to takeoff with known obstacles on the runway and his subsequent failure to avoid the windsock on takeoff.NTSB CEN20LA248Accident · 1 fatalClass 3 · LimitedFinal reportPiper PA32R · Zavalla, TXThe non-certificated pilot’s poor decision-making as he attempted to land at an unlit airstrip in night instrument conditions, which resulted in the airplane’s collision with terrain short of the runway.NTSB WPR19LA027Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Presidio, TXThe student pilot’s loss of control at low altitude during a forced landing, which resulted in impact with terrain and substantial damage to the right wing. A contributing factor in the accident was the loss of engine power for undetermined reasons.NTSB CEN11LA083Accident · Minor injuriesLimited investigationFinal reportPiper PA-34-200T · Nocagdoches, TXA total loss of power in both engines for undetermined reasons.NTSB CEN11CA036Accident · Minor injuriesData collectionFinal reportFrederick R Goenne Glastar · Recklaw, TXThe pilot's failure to maintain directional control during the landing roll on a rough runway surface.NTSB CEN10CA229Accident · Minor injuriesData collectionFinal reportThomas Long Long's Paraglider · Amarillo, TXThe pilot’s failure to maintain control of the powered parachute, resulting in an unintentional departure and subsequent collision with power lines and the ground.NTSB CEN10LA222Accident · Serious injuriesLimited investigationFinal reportCross-Capps Breezy · Livingston, TXA loss of engine power for undetermined reasons.NTSB CEN10LA217Accident · No injuriesLimited investigationFinal reportAir Tractor AT-802A · Alpine, TXA total loss of engine power for undetermined reasons.NTSB CEN09IA096Incident · No injuriesIncident investigationFinal reportCessna 182 · Fort Worth, TXCollision with a hidden obstruction while taxiing through a grass field following a forced landing. Contributing to the accident was a loss of engine power due to the pilot's failure to turn on the carburetor heat.NTSB DEN08IA143Incident · No injuriesIncident investigationFinal reportRaytheon C90A · Jasper, TXThe impact with a bird during initial takeoff climb.NTSB DFW08CA191Accident · No injuriesData collectionFinal reportCessna T210M · Van Horn, TXThe pilot's failure to maintain altitude due to his diverted attention. Contributing to the accident was complications manually extending the landing gear.NTSB DEN08LA096Accident · Minor injuriesLimited investigationFinal reportCommonwealth 185 · Roanoke, TXThe pilot's physiologic impairment and failure to attain the proper touchdown point during an intentional off airport landing. Contributing to the accident was the pilot's improper in-flight planning.NTSB DEN08CA087Accident · No injuriesData collectionFinal reportCessna 172H · Brookshire, TXThe pilot's decision to duck under marked transmission lines and his failure to maintain clearance from the fence. Contributing to the accident was the marked transmission lines.NTSB DFW08IA073Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-88 · Austin, TXThe airplane struck a large bird while making a visual approach to the airport.