NTSB investigations, 2013, 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\") = 2013
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") = 2013 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 CEN14FA057Accident · 2 fatalField investigationFinal reportCessna 152 · Spring, TXThe flight instructor's failure to maintain airspeed following a partial loss of engine power for reasons that could not be determined during postaccident examination, which resulted in an aerodynamic stall and subsequent loss of airplane control.NTSB CEN14LA058Accident · Serious injuriesLimited investigationFinal reportPiper PA 28-140 · San Antonio, TXA partial loss of engine power after departure due to the collapse of the carburetor air inlet duct, which restricted the airflow to the engine. Contributing to the accident was the overdue annual inspection and the installation of the improper air inlet duct.NTSB CEN14LA003Accident · Serious injuriesLimited investigationFinal reportKenneth M Franz Ultra PUP · Belleville, TXThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane's critical angle-of-attack while turning back to the airport instead of landing straight ahead following a partial loss of engine power, which resulted in an aerodynamic…NTSB CEN13FA476Accident · 2 fatalField investigationFinal reportBeechcraft F33A · Ennis, TXThe loss of engine power for reasons that could not be determined during postaccident examinations due to postcrash fire damage.NTSB CEN13LA478Accident · No injuriesLimited investigationFinal reportDouglas Brian G BA-100 · Killeen, TXThe pilot’s improper management of the fuel mixture, which resulted in an over-rich fuel mixture condition and a subsequent partial loss of engine power.NTSB CEN13LA341Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Farnsworth, TXThe partial loss of engine power for reasons that could not be determined because the postaccident engine examination revealed no anomalies.NTSB CEN13LA325Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · New Braunfels, TXThe pilot's improper flare during an autorotation, which resulted in a hard landing, and a partial loss of engine power for reasons that could not be determined because the examination of the engine did not reveal any anomalies that would have precluded…NTSB CEN13LA305Accident · Minor injuriesLimited investigationFinal reportStinson 108-3 · Beaumont, TXThe lack of a forward clamp on the carburetor heat box rubber boot, which allowed the boot to be ingested into the inlet of the carburetor heat box, restricting the airflow and leading to a subsequent partial loss of engine power.NTSB CEN13LA195Accident · No injuriesLimited investigationFinal reportNew Piper PA-46-500TP · Brenham, TXA lack of available engine power during an attempted go-around for reasons that could not be determined because the postaccident engine examinations did not reveal any anomalies consistent with an inability to produce rated power.NTSB CEN13LA193Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · Seguin, TXThe partial loss of engine power for reasons that could not be undetermined because an examination of the engine did not reveal any malfunctions or failures that would preclude normal operation.NTSB CEN13LA157Accident · No injuriesLimited investigationFinal reportNorth American-Medore SNJ-4 · Garden City, TXThe loss of engine power due to fuel starvation.