NTSB investigations, 2008, TX
56 cases where the sequence of events included Collision with terr/obj (non-CFIT).
Cases per year
| 2008 | 56 |
|---|---|
| 2009 | 32 |
| 2010 | 49 |
| 2011 | 58 |
| 2012 | 59 |
| 2013 | 49 |
| 2014 | 53 |
| 2015 | 59 |
| 2016 | 68 |
| 2017 | 44 |
| 2018 | 64 |
| 2019 | 53 |
| 2020 | 31 |
| 2021 | 20 |
| 2022 | 22 |
| 2023 | 21 |
| 2024 | 20 |
| 2025 | 14 |
| 2026 | 14 |
Where
Latest 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 year(c.\"eventDate\") = 2008
AND c.\"eventStateOrRegion\" = 'TX' AND c.\"eventCountry\" = 'USA'
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 year(c."eventDate") = 2008 AND c."eventStateOrRegion" = 'TX' AND c."eventCountry" = 'USA' 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 CEN09FA087Accident · 1 fatalField investigationFinal reportBeech C90 · Rocksprings, TXThe pilot's failure to properly configure the pressurization controls, resulting in his impairment and subsequent incapacitation due to hypoxia.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 CEN09LA055Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Nacogdoches, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB CEN09CA037Accident · Serious injuriesData collectionFinal reportCessna R172E · Palo Pinto, TXThe pilot's intentional low-level flight and failure to maintain a visual lookout.NTSB CEN09LA024Accident · No injuriesLimited investigationFinal reportCessna A185F · Angleton, TXThe loss of engine power for undetermined reasons. Contributing to the accident was the lack of suitable terrain for the pilot to execute the forced landing.NTSB CEN09FA012Accident · 2 fatalField investigationFinal reportBell 206 · Conroe, TXA loss of control for undetermined reasons.NTSB CEN09CA020Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Lufkin, TXThe student pilot's improper decision to takeoff with a known brake problem. Contributing to the accident were the malfunctioning brake and the rough terrain in the excursion area.NTSB DFW08FA228Accident · 1 fatalField investigationFinal reportAmerican Champion 7GCBC · Wichita Falls, TXThe pilot's failure to maintain safe flying airspeed resulting in an inadvertent stall during the forced landing. Contributing to the accident was the loss of engine power due to carburetor icing.NTSB DFW08LA226Accident · Serious injuriesLimited investigationFinal reportCessna 182D · Orange Grove, TXA total loss of engine power due to an improperly installed intake manifold tube.NTSB DFW08LA223Accident · No injuriesLimited investigationFinal reportRockwell International S-2R · Uvalde, TXA total loss of engine power due to the improper use of unauthorized replacement parts in the engine and repeated operation of the engine in an over-temperature condition.NTSB DFW08LA220Accident · 1 fatalLimited investigationFinal reportSchleicher ASW-20B · Cleburne, TXLoss of control inflight for undetermined reason.NTSB DFW08CA214Accident · No injuriesData collectionFinal reportBellanca 14-19-2 · Keller, TXThe pilot's inadequate preflight inspection of the airplane which resulted in an attempted takeoff without fuel present in the selected fuel tank.NTSB DFW08LA210Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Caldwell, TXA loss of engine power in flight due to fuel exhaustion as a result of the pilot's failure to secure the right wing's fuel cap, leading to fuel being siphoned from the tank during flight.NTSB DEN08IA143Incident · No injuriesIncident investigationFinal reportRaytheon C90A · Jasper, TXThe impact with a bird during initial takeoff climb.NTSB DEN08FA140Accident · Serious injuriesField investigationFinal reportAircraft Mfg & Dev. CH601XLi · Farmersville, TXThe inadvertent tail stall and subsequent loss of airplane control as a result of the open canopy. Contributing to the accident was the inadequate emergency procedures provided by the airplane manufacturer and the inadequate design of the canopy latching…NTSB DEN08LA137Accident · Serious injuriesLimited investigationFinal reportSchempp-Hirth Ventus 2A · Brackettville, TXThe failure of the pilot of N777UN to exit the thermal upon losing visual contact with the other gliders, resulting in a midair collision.NTSB DFW08CA203Accident · Serious injuriesData collectionFinal reportCollard Dragonfly · Big Sping, TXLoss of aircraft control due to inadvertent penetration of a dust devil.NTSB DEN08LA129Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Athens, TXA partial loss of engine power during initial climb due to undetermined reasons, which led to an uncontrolled descent and subsequent aerodynamic stall. Contributing to the accident was the pilot's improper preflight decision to attempt the flight with a…NTSB DFW08CA198Accident · No injuriesData collectionFinal reportRobinson R22 · Rosharon, TXThe pilot's failure to maintain terrain clearance while maneuvering. Contributing to the accident was the low altitude.NTSB DEN08LA127Accident · 1 fatalLimited investigationFinal reportSchempp-Hirth Ventus A · Midlothian, TXThe pilot's inability to maintain aircraft control due to an incapacitating cardiac event. Contributing to the accident was the pilot's poor decision to fly with known serious medical issues.NTSB DFW08FA190Accident · 3 fatalField investigationFinal reportPiper PA-22 · Kemp, TXThe pilot's failure to maintain adequate airspeed while maneuvering, which led to an aerodynamic stall and subsequent loss of control.NTSB DEN08LA124Accident · 1 fatalLimited investigationFinal reportAerotek Pitts S-2A · Cleveland, TXthe pilot's failure to maintain aircraft control during his attempted performance of aerobatic maneuvers shortly after takeoff.NTSB DFW08CA192Accident · No injuriesData collectionFinal reportGrumman G-164A · Bovina, TXLoss of engine power for undetermined reasons.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 DFW08CA184Accident · No injuriesData collectionFinal reportWright Avid Flyer MK IV · Lake Jackson, TXThe loss of engine power due to a connecting rod failure.NTSB DFW08CA183Accident · No injuriesData collectionFinal reportGrumman American AA-5A · Denton, TXThe pilot's inadequate fuel management, which resulted in fuel starvation and the subsequent loss of engine power.NTSB DEN08LA119Accident · 1 fatalLimited investigationFinal reportShannon Kevin RV-8 · Valera, TXThe pilot's failure to maintain adequate airspeed during a forced landing, which led to an aerodynamic stall, following a loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot's mismanagement of fuel and the low altitude at…NTSB DEN08LA109Accident · No injuriesLimited investigationFinal reportFlight Design Ctsw · Von Ormy, TXThe pilot's inadequate in-flight decision by failing to refuel while en route, resulting in fuel exhaustion. Contributing to the accident were a proper touchdown point was not possible and the inadequate display of the fuel quantity indicator.NTSB DFW08CA179Accident · Serious injuriesData collectionFinal reportHughes Aero Predator · Wharton, TXThe pilot's failure to maintain aircraft control.NTSB DEN08LA102Accident · No injuriesLimited investigationFinal reportCessna 150G · Brenham, TXThe sudden windshift (crosswind gust), rendering directional control impossible. Contributing factors in this accident were the high speed during the aborted takeoff and trees.NTSB DEN08LA098Accident · 2 fatalLimited investigationFinal reportHarms Robert M KIT FOX SE · La Porte, TXThe pilot's failure to maintain adequate airspeed while maneuvering, resulting in an aerodynamic stall and uncontrolled descent.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 DEN08CA091Accident · No injuriesData collectionFinal reportGrumman-Schweizer G-164A · East Bernard, TXTwo engine cylinder exhaust valves stuck open for an undetermined reason, resulting in a loss of engine power.NTSB DFW08CA146Accident · No injuriesData collectionFinal reportAir Tractor 401-0860 · Mumford, TXA total loss of engine power for undetermined reasons.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 DFW08LA140Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R22 Marine · Austin, TXThe pilot's failure to maintain rotor RPM while maneuvering at a low altitude, which resulted in a loss of control.NTSB DFW08CA132Accident · Minor injuriesData collectionFinal reportCessna C-210 · Pleasanton, TXThe pilot's failure to obtain the proper touchdown point resulting in an overrun. Contributing to the accident was the pilot's failure to abort the landing.NTSB DFW08CA149Accident · No injuriesData collectionFinal reportBellanca 14-13-3A · San Marcos, TXThe failure of the throttle cable clevis swage. Contributing to the accident was the uneven terrain available for landing.NTSB DEN08LA082Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Houston, TXLoss of engine power for reasons undetermined. Contributing to the accident was a lack of suitable terrain for a forced landing.NTSB DFW08LA106Accident · Serious injuriesLimited investigationFinal reportTomblingson-Leathers Breezy RLU-1 · Groveton, TXThe loss of engine power for undetermined reasons and the pilot's failure to maintain airspeed during the forced landing. Contributing factors were the non-suitable terrain for the forced landing and the pilot's lack of experience in the airplane.NTSB DFW08LA105Accident · 1 fatalLimited investigationFinal reportBlevens Gary Vortex · Berclair, TXLoss of control for undetermined reasons.NTSB DFW08CA112Accident · Minor injuriesData collectionFinal reportHaecker Spacewalker · Kingsbury, TXThe loss of engine power for undetermined reason. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW08CA102Accident · No injuriesData collectionFinal reportNorth American T-6G · Dallas, TXThe pilot's failure to maintain directional control while landing.NTSB DEN08LA077Accident · Minor injuriesLimited investigationFinal reportGulfstream-Schweizer G-164B · Angleton, TXThe pilot's inadequate visual lookout and his failure to maintain clearance from the tranmission lines. A factor in this accident was the unmarked transmission wires.NTSB DEN08CA075Accident · No injuriesData collectionFinal reportCessna 182N · Amarillo, TXThe pilot's failure to maintain aircraft control during the landing. Contributing to the accident were the crosswind, gusty wind conditions and the pilot's inadequate compensation for the wind conditions.NTSB DEN08LA074Accident · Serious injuriesLimited investigationFinal reportGrumman American AA-5A · Beaumont, TXThe pilot's inability to maintain aircraft control in cruise flight and encounter with a thunderstorm. Contributing to the accident was an inadvertent stall/spin.NTSB DFW08CA096Accident · No injuriesData collectionFinal reportCessna C-182 · Porter, TXThe pilot's loss of directional control due to the partial failure of the left brake.NTSB DEN08LA071Accident · Minor injuriesLimited investigationFinal reportHiller UH-12E · La Porte, TXThe loss of tail rotor effectiveness. Contributing factors were the sudden windshift to a tailwind, and the pilot initiating a hovering turn in ground effect.NTSB DFW08CA142Accident · No injuriesData collectionFinal reportNorth American T-28D · Sherman, TXLoss of engine power for undetermined reasons. A factor was the soft terrain.NTSB DFW08IA073Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-88 · Austin, TXThe airplane struck a large bird while making a visual approach to the airport.