NTSB investigations, TX
235 cases where NTSB found Fluids/misc hardware.
Cases per year
| 2008 | 5 |
|---|---|
| 2009 | 15 |
| 2010 | 20 |
| 2011 | 16 |
| 2012 | 9 |
| 2013 | 10 |
| 2014 | 15 |
| 2015 | 12 |
| 2016 | 13 |
| 2017 | 14 |
| 2018 | 20 |
| 2019 | 14 |
| 2020 | 16 |
| 2021 | 11 |
| 2022 | 13 |
| 2023 | 8 |
| 2024 | 10 |
| 2025 | 13 |
| 2026 | 1 |
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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '0107'))
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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '0107')) 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 CEN26LA144Accident · Serious injuriesClass 4 · LimitedFinal reportMooney M20 · Northlake, TXThe pilot’s inadequate fuel management which resulted in a total loss of engine power due to fuel starvation.NTSB CEN26LA084Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Taylor, TXThe pilot’s inadequate preflight inspection that resulted in a loss of engine power due to water contamination.NTSB CEN26LA069Accident · No injuriesClass 4 · LimitedFinal reportCessna 172D · Post, TXThe pilot’s failure to see the blockage in the fuel tank vent tube during the preflight inspection which resulted in the loss of engine power due to fuel starvation. Contributing to the accident was the deterioration of the right fuel cap vent to the point…NTSB CEN25LA391Accident · No injuriesClass 4 · LimitedFinal reportCessna 150G · Seagoville, TXThe pilot’s inadequate fuel planning which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN25LA377Accident · No injuriesClass 4 · LimitedFinal reportCessna 172F · Lancaster, TXThe pilot’s inadequate fuel planning and failure to monitor the fuel consumption which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN25LA355Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172M · Lubbock, TXThe pilot’s mismanagement of available fuel, which resulted in a loss of engine power due to fuel starvation.NTSB CEN25LA347Accident · Minor injuriesClass 4 · LimitedFinal reportBeech C35 · Lakeview, TXThe pilot’s fuel system mismanagement which resulted in a loss of engine power due to fuel starvation.NTSB CEN25LA342Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22 · Granbury, TXThe pilot’s inadequate fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB CEN25LA301Accident · No injuriesClass 4 · LimitedFinal reportCessna U206G · Kerrville, TXThe pilot’s failure to confirm the fuel quantity before flight which resulted in a loss of engine power due to fuel starvation.NTSB CEN25LA199Accident · No injuriesClass 4 · LimitedFinal reportCessna 182P · Mineral Wells, TXThe pilot’s improper fuel tank selection prior to takeoff, which resulted in a total loss of engine power due to fuel starvation. Contributing to the accident was the pilot’s failure to follow the airplane checklist.NTSB CEN25LA176Accident · Serious injuriesClass 4 · LimitedFinal reportBeech C90 · Lancaster, TXThe pilot’s improper fuel planning, which resulted in fuel exhaustion and a total loss of power to both engines.NTSB CEN25LA099Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Pearland, TXThe pilot’s poor flight planning and decision making, which resulted in a loss of engine power due to fuel exhaustion.NTSB CEN25LA091Accident · No injuriesClass 4 · LimitedFinal reportAircraft Mfg & Development CH 2000 · Ennis, TXThe pilot’s improper fuel planning which resulted in the total loss of engine power due to fuel exhaustion.NTSB CEN25LA082Accident · No injuriesClass 4 · LimitedFinal reportBeech N35 · Plainview, TXFuel starvation due to fuel migration during the pilot induced slipping maneuver.NTSB CEN25LA065Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA-28 · New Braunfels, TXThe pilot’s improper in-flight fuel planning which resulted in a total loss of engine power due to fuel starvation and a subsequent off-field landing on rough terrain.NTSB CEN25LA060Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA-31-350 · Victoria, TXThe pilot’s inadequate preflight planning and preflight inspection, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN25LA018Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-32R-301 · Van, TXThe mechanic’s improper maintenance of the engine’s air induction scat duct, which collapsed during the flight and resulted in a loss of engine power.NTSB CEN24LA339Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Borger, TXThe pilot’s inadequate fuel management which led to fuel exhaustion.NTSB CEN24LA271Accident · Serious injuriesClass 3 · LimitedFinal reportMcdonnell Douglas Helicopter 600N · Eagle Lake, TXThe operator’s improper installation of the fuel system, which resulted in fuel starvation, a loss of engine power, and impact with terrain.NTSB CEN24LA268Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-28-181 · Arcola, TXLoss of engine power due to fuel starvation as a result of the mechanic’s failure to properly secure the fuel system gascolator strainer bowl following an annual inspection.NTSB CEN24LA191Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Dell City, TXThe pilot’s failure to switch fuel tanks while en route which resulted in the loss of engine power due to fuel starvation.NTSB CEN24LA140Accident · No injuriesClass 3 · LimitedFinal reportCessna T210 · San Saba, TXA total loss of engine power due to multiple connecting rod failures from oil starvation.NTSB CEN24LA114Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Wayside, TXThe student pilot’s improper fuel management during the cross-country flight, which resulted in a total loss of engine power due to fuel starvation.NTSB CEN24LA102Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Terrell, TXThe total loss of engine power during the initial climb due to fuel exhaustion.NTSB CEN24LA068Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-23-250 · Forney, TXThe pilot's inadequate fuel planning and improper in-flight decision-making, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN23LA345Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Rosenberg, TXThe student pilot’s improper fuel management that resulted in fuel exhaustion, a total loss of engine power, and a subsequent forced landing and landing overrun at an alternate airport.NTSB WPR23LA263Accident · No injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 II · Marble Falls, TXA total loss of engine power due to fuel contamination from an unknown source.NTSB CEN23FA284Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-30 · Sherman, TXThe pilot’s failure to maintain control during a forced landing following a loss of engine power. Contributing was the pilot’s failure to feather the left propeller following the loss of engine power.NTSB CEN23LA185Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22 · Midland, TXThe pilot’s inadequate fuel management which resulted in a total loss of engine power due to fuel starvation.NTSB WPR23LA183Accident · No injuriesClass 3 · LimitedFinal reportAero Vodochody L-39ZA · Barnhart, TXA total loss of engine power due to water-contaminated fuel from an undetermined source.NTSB CEN23LA153Accident · Minor injuriesClass 3 · LimitedFinal reportRyan Navion A · New Waverly, TXA total loss of engine power as a result of fuel contamination.NTSB CEN23LA081Accident · Serious injuriesClass 3 · LimitedFinal reportPitts Model 12 · Conroe, TXThe failure of the engine-driven fuel pump, which resulted in a total loss of engine power. Contributing to the failure of the fuel pump was an unknown non-ferrous metallic debris that was noted throughout the airplane’s fuel system.NTSB CEN23FA038Accident · 1 fatalClass 3 · FieldFinal reportCessna 421C · Decatur, TXA loss of power on the left engine due to fuel starvation and the subsequent loss of power on the right engine for undetermined reasons.NTSB CEN23LA021Accident · No injuriesClass 3 · LimitedFinal reportCessna T210 · Burleson, TXThe pilot’s mismanagement of the fuel supply, which led to fuel starvation and a loss of engine power.NTSB CEN23LA018Accident · No injuriesClass 3 · LimitedFinal reportSea Ray LSX · Lago Vista, TXThe pilot’s inadequate fuel planning and improper in-flight decision making which resulted in a low fuel status and a loss of engine power due to fuel starvation.NTSB CEN22FA405Accident · 1 fatalClass 3 · FieldFinal reportCirrus SR22 · Tomball, TXThe flight instructor’s inadequate supervision of the flight, which allowed for an unintentional movement of the mixture control to the cutoff position that remained unnoticed until the airplane lost engine power due to fuel starvation and descended below the…NTSB CEN22LA355Accident · No injuriesClass 3 · LimitedFinal reportCessna 150 · Marshall, TXThe student pilot’s inadequate fuel planning and improper in-flight decision-making which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN22LA320Accident · No injuriesClass 4 · LimitedFinal reportCessna 210 · Kendleton, TXThe pilot’s improper in-flight planning and fuel management that resulted in the loss of engine power due to fuel exhaustion.NTSB CEN22LA237Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Fort Worth, TXThe student pilot’s inadequate fuel management that resulted in a loss of engine power due to fuel starvation.NTSB CEN22LA229Accident · No injuriesClass 4 · LimitedFinal reportFahey William J CH750 Cruzer · San Antonio, TXThe loss of engine power due to fuel starvation. Contributing to the fuel starvation was a faulty experimental fuel gauge.NTSB CEN22LA225Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-160 · Roanoke, TXInadequate maintenance of the airplane’s brake system that resulted in a hole in the brake line, the loss of brake fluid, and the subsequent loss of brake functionality.NTSB CEN22LA190Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 421 · Houston, TXThe fixed-base operator’s incorrect fueling of the airplane, which resulted in a total loss of power in both engines.NTSB CEN22LA189Accident · No injuriesClass 3 · LimitedFinal reportRaytheon A36 · Blanket, TXThe pilot’s failure to properly manage fuel while enroute, which resulted in a loss of engine power due to fuel starvation and a subsequent forced landing.NTSB CEN22LA180Accident · Serious injuriesClass 4 · LimitedFinal reportGlobe GC-1B · Huntsville, TXThe pilot’s inadequate fuel management which resulted in a total loss of engine power due to fuel starvation.NTSB CEN22LA134Accident · No injuriesClass 3 · LimitedFinal reportCessna 208B · Campbellton, TXThe pilot’s fuel mismanagement, which resulted in a total loss of engine power due to fuel exhaustion and subsequent impact with trees during a forced landing.NTSB CEN22LA071Accident · Serious injuriesClass 3 · LimitedFinal reportVans RV8 · Wichita Falls, TXThe pilot’s improper fuel management that resulted in a total loss of engine power due to fuel starvation.NTSB CEN22LA059Accident · No injuriesClass 3 · LimitedFinal reportBeech A36 · Cleveland, TXA total loss of engine power due to fuel starvation, the reason for which could not be determined.NTSB CEN22LA040Accident · Serious injuriesClass 3 · LimitedFinal reportBeech 23 · Abilene, TXThe flight instructor’s inadequate fuel management, which resulted in a loss of engine power due to fuel starvation. Contributing to the accident was the missing placard showing the usable fuel quantity.NTSB CEN22LA036Accident · No injuriesClass 3 · LimitedFinal reportCessna 177 · Hudson Oaks, TXThe partial loss of engine power due to fuel exhaustion. Contributing was the pilot’s improper fuel planning.NTSB CEN21LA418Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-44-180 · Magnolia, TXA total loss of engine power due to fuel exhaustion, which resulted from the pilot’s inadequate preflight planning.