NTSB investigations, 2008, TX
20 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
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\" = '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") = 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" = '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 CEN09LA113Accident · No injuriesLimited investigationFinal reportCotton Galen M Helicycle · Houston, TXThe loss of engine power during a hover landing which resulted in a hard landing.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 CEN09LA014Accident · No injuriesLimited investigationFinal reportBeech A36 · Houston, TXThe total loss of engine power due to a fracture in the oil filter adapter housing. Contributing to the accident was the lack of suitable terrain for the forced landing.NTSB DEN08LA158Accident · Serious injuriesLimited investigationFinal reportCameron Balloons US N-77 · Plano, TXThe pilot's improper fuel management, resulting in fuel exhaustion and the subsequent hard landing.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 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 DFW08CA211Accident · No injuriesData collectionFinal reportMurray Frank H DA5B · Odessa, TXFailure of the intake manifold when the flexible connectors disconnected from the carburetor after a turbulence encounter. Contributing to the accident was insuitable terrain for a forced landing.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 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 DFW08CA192Accident · No injuriesData collectionFinal reportGrumman G-164A · Bovina, TXLoss of engine power for undetermined reasons.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 DFW08CA146Accident · No injuriesData collectionFinal reportAir Tractor 401-0860 · Mumford, TXA total loss of engine power for undetermined reasons.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 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 DFW08CA142Accident · No injuriesData collectionFinal reportNorth American T-28D · Sherman, TXLoss of engine power for undetermined reasons. A factor was the soft terrain.NTSB DFW08TA066Accident · Minor injuriesFinal reportHughes OH-6 · Valentine, TXThe contract mechanic's failure to properly secure the castellated nut that attached the governor lever control rod to the idler bell crank. Contributing to the accident was the lack of maintenance oversight by the operator.