NTSB investigations, 2014, TX
11 cases where the sequence of events included Loss of engine power (partial).
Cases per year
| 2008 | 7 |
|---|---|
| 2009 | 12 |
| 2010 | 9 |
| 2011 | 7 |
| 2012 | 15 |
| 2013 | 11 |
| 2014 | 11 |
| 2015 | 10 |
| 2016 | 8 |
| 2017 | 10 |
| 2018 | 9 |
| 2019 | 13 |
| 2020 | 8 |
| 2021 | 9 |
| 2022 | 5 |
| 2023 | 4 |
| 2024 | 6 |
| 2025 | 8 |
| 2026 | 6 |
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\" = '342' 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" = '342' 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 CEN15LA063Accident · Serious injuriesLimited investigationFinal reportSiegel Gerald Long EZ · McGregor, TXA loss of engine power during takeoff due to excessive debris in the fuel system.NTSB CEN15LA038Accident · Minor injuriesLimited investigationFinal reportStol UC 1 · Jacksonville, TXThe loss of right engine power while climbing due to fuel starvation for reasons that could not be determined during postaccident airplane examination and testing, which led to a forced landing on hilly terrain.NTSB CEN14FA494Accident · 1 fatalField investigationFinal reportSmith Aerostar 601P · Austin, TXThe pilot's failure to maintain sufficient clearance from trees during the single-engine landing approach. Contributing to the accident was the loss of power in the left engine due to an improperly installed rubber boot that became dislodged and was then…NTSB CEN14LA385Accident · No injuriesLimited investigationFinal reportEvektor-Aerotechnik Sportstar · Wichita Falls, TXA partial loss of engine power, which resulted in a forced landing on unsuitable terrain. The reason for the loss of engine power could not be determined during postaccident examination.NTSB CEN14CA380Accident · No injuriesData collectionFinal reportDantonio 404 · Wichita Falls, TXThe separation of a spark plug wire resulting in a loss of engine power during climb out and a subsequent forced landing on a field containing trees.NTSB CEN14LA334Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Granbury, TXThe partial loss of engine power due to the failure of the exhaust valve.NTSB CEN14LA287Accident · No injuriesLimited investigationFinal reportAir Tractor AT 301 · Pearsall, TXThe failure of the No. 1 cylinder rod at the link pin. Contributing to the accident was oil starvation to the rod bearing due to the improper flushing of the oil cooler, which allowed metal and other debris in the oil to clog the drain and the led to the…NTSB CEN14LA276Accident · No injuriesLimited investigationFinal reportCessna 172N · Padre Island, TXThe loss of engine power for reasons that could not be determined based on the available evidence.NTSB CEN14LA263Accident · No injuriesLimited investigationFinal reportAero Commander 200D · La Grange, TXThe loss of engine power due to oil starvation for reasons that could not be determined based on the available evidence.NTSB CEN14FA143Accident · 1 fatalField investigationFinal reportHawker SEA Fury ISS 25 · Breckenridge, TXThe pilot’s inadequate emergency response to a runaway propeller and his failure to maintain airspeed, which resulted in the airplane exceeding its critical angle-of-attack and stalling. The cause of the runaway propeller was undetermined.NTSB CEN14LA136Accident · Serious injuriesLimited investigationFinal reportMahon Paul D Capella XS · Houston, TXThe loss of engine power due to carburetor icing.