NTSB investigations, 2014, TX
19 cases where the sequence of events included Loss of engine power (total).
Cases per year
| 2008 | 20 |
|---|---|
| 2009 | 21 |
| 2010 | 25 |
| 2011 | 30 |
| 2012 | 23 |
| 2013 | 13 |
| 2014 | 19 |
| 2015 | 22 |
| 2016 | 20 |
| 2017 | 11 |
| 2018 | 22 |
| 2019 | 13 |
| 2020 | 20 |
| 2021 | 17 |
| 2022 | 14 |
| 2023 | 10 |
| 2024 | 10 |
| 2025 | 18 |
| 2026 | 14 |
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 year(c.\"eventDate\") = 2014
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\" = '341' 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") = 2014 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" = '341' 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 CEN15CA067Accident · No injuriesData collectionFinal reportCessna 210 · Edinburg, TXThe loss of engine power due to fuel exhaustion, which resulted from the non-certificated pilot's inadequate preflight planning and inflight decision making.NTSB CEN15FA032Accident · 1 fatalField investigationFinal reportLangston, Frederick L RV 4 · Boerne, TXA total loss of engine power for reasons that could not be determined, because post accident examination did not reveal any mechanical malfunctions or anomalies that would have precluded normal operation.NTSB CEN15LA031Accident · No injuriesLimited investigationFinal reportCessna T210M · Brownsville, TXA loss of engine power due to fuel exhaustion, which resulted from the pilot’s inadequate preflight fuel planning.NTSB CEN15LA018Accident · Serious injuriesLimited investigationFinal reportViguie G/Viguie M Lancair Legacy · Livingston, TXA catastrophic and uncontained engine failure due to oil starvation. Contributing to the accident was the missing No. 3 cylinder intake rocker cover for reasons that could not be determined based on the available evidence.NTSB CEN14LA527Accident · 1 fatalLimited investigationFinal reportButcher Russell A RV9A · Shepherd, TXThe pilot’s loss of airplane control during the landing approach after a loss of engine power, which led to a collision with trees and terrain. Contributing to the accident was the pilot’s inadequate preflight fuel planning, which led to fuel exhaustion and…NTSB CEN14LA495Accident · No injuriesLimited investigationFinal reportNolin Vans RV-10 · Houston, TXThe total loss of engine power for reasons that could not be determined during postaccident examination.NTSB CEN14FA377Accident · 1 fatalField investigationFinal reportOden Weldon Pat Kitfox IV Speedster · Blackwell, TXThe pilot's loss of airplane control following a loss of engine power for reasons that could not be determined based on the available evidence.NTSB CEN14LA350Accident · Serious injuriesLimited investigationFinal reportPiper PA 28R-200 · Mt. Vernon, TXThe pilot’s inadequate preflight inspection, which resulted in a loss of engine power due to fuel exhaustion.NTSB CEN14LA331Accident · No injuriesLimited investigationFinal reportCessna A188 · Arlington, TXThe total loss of engine power due to a loose oil filter adapter, which resulted in oil starvation. Contributing to the accident was maintenance personnel’s failure to comply with a Federal Aviation Administration airworthiness directive.NTSB CEN14LA293Accident · No injuriesLimited investigationFinal reportKnauf RV-7 · Rockwall, TXThe pilot's failure to verify the airplane's actual fuel quantity before departure, which resulted in a total loss of engine power due to fuel exhaustion and the subsequent forced landing.NTSB CEN14LA290Accident · Serious injuriesLimited investigationFinal reportTeunis Starduster TOO SA300 · Fort Worth, TXThe non-certificated pilot’s inadequate preflight planning, which resulted in a loss of engine power during takeoff due to fuel exhaustion.NTSB CEN14LA253Accident · No injuriesLimited investigationFinal reportBeech A36 · Rockdale, TXA loss of engine power for reasons that could not be determined because postaccident testing revealed no anomalies.NTSB CEN14LA234Accident · Serious injuriesLimited investigationFinal reportMooney M20TN · San Antonio, TXThe total loss of engine power for reasons that could not be determined because postaccident examination and testing of the engine revealed no anomalies.NTSB CEN14LA226Accident · Minor injuriesLimited investigationFinal reportFlight Design Ctls · Greenville, TXThe fatigue failure of the No. 4 cylinder exhaust valve due to excessive wear of the corresponding train tappet, which resulted in a total loss of engine power.NTSB CEN14LA217Accident · No injuriesLimited investigationFinal reportCessna 172R · Llano, TXThe total loss of engine power for reasons that could not be determined because examination of the engine did not reveal any evidence of preimpact failures or malfunctions that would have precluded normal operation.NTSB CEN14LA200Accident · Serious injuriesLimited investigationFinal reportCessna O 1E · Fredericksburg, TXThe loss of engine power for reasons that could not be determined because postaccident examination of the engine revealed no anomalies.NTSB CEN14FA198Accident · 1 fatalField investigationFinal reportBeech C24 · Denton, TXThe pilot mistakenly manipulated the airplane's mixture knob rather than the propeller control knob during the descent, reducing the airplane's mixture knob to where the fuel-air mixture to the engine was too lean, which caused the engine to fail, and the…NTSB CEN14LA165Accident · Minor injuriesLimited investigationFinal reportBeech P35 · Wichita Falls, TXThe loss of engine power due to the misrigging of the fuel mixture control.NTSB CEN14LA133Accident · No injuriesLimited investigationFinal reportCessna 182A · Lexington, TXThe pilot’s improper use of the carburetor heat, which resulted in a total loss of engine power due to carburetor icing.