Final NTSB investigations, WV
10 cases where the sequence of events included Loss of engine power (total).
Cases per year
| 2010 | 1 |
|---|---|
| 2011 | 1 |
| 2012 | 2 |
| 2013 | 1 |
| 2014 | 1 |
| 2015 | 1 |
| 2017 | 1 |
| 2022 | 1 |
| 2025 | 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\" = 'WV' AND c.\"eventCountry\" = 'USA'
AND c.\"completionStatus\" = 'Completed'
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 c."eventStateOrRegion" = 'WV' AND c."eventCountry" = 'USA' AND c."completionStatus" = 'Completed' 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 ERA25LA186Accident · Serious injuriesClass 4 · LimitedFinal reportBeech 95-C55 · Lakin, WVThe pilot’s inadequate preflight inspection, and inadequate inflight fuel management, which resulted in a total loss of engine power due to fuel starvation and subsequent forced landing.NTSB ERA22FA279Accident · 6 fatalClass 1 · FieldFinal reportBell UH-1B · Amherstdale, WVthe operator’s failure to adequately inspect the former military turbine powered helicopter, which allowed an engine issue to progress and result in a loss of engine power and a subsequent loss of control after the helicopter struck powerlines during a forced…NTSB ERA17LA209Accident · No injuriesLimited investigationFinal reportHughes 369 · Dennis, WVThe unporting of fuel due to the helicopter's nose-up attitude during long line operations, which resulted in fuel starvation and a total loss of engine power.NTSB ERA15LA287Accident · Minor injuriesLimited investigationFinal reportPiper J3C 65 · Southside, WVThe pilot’s exhaustion of the airplane’s fuel supply, which resulted in a total loss of engine power. Contributing to the outcome was the pilot’s failure to secure the engine before the forced landing.NTSB ERA14LA086Accident · Minor injuriesLimited investigationFinal reportCirrus Design SR22 · Buckhannon, WVThe pilot’s improper in-flight fuel mixture management and failure to use the appropriate checklist or manuals during approach to landing, which resulted in a loss of engine power.NTSB ERA13LA344Accident · Minor injuriesLimited investigationFinal reportHughes 369D · Center Point, WVA total loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.NTSB ERA12LA293Accident · No injuriesLimited investigationFinal reportPrendergast John/Vans RV-7A · Gerrardstown, WVThe pilot/builder's misjudgment of the required spacer width needed after engine housing lap grinding, which resulted in bearing oil hole misalignment and insufficient internal engine lubrication.NTSB ERA12LA285Accident · Serious injuriesLimited investigationFinal reportWilloughby Pete A Streak Shadow · Salem, WVA total loss of engine power due to a piston seizure that resulted from a fuel system restriction and poorly secured fuel lines. Contributing to the accident were the pilot/builder’s failure to follow the engine manufacturer procedures and his use of…NTSB ERA11CA237Accident · No injuriesData collectionFinal reportCessna 182A · Lesage, WVA loss of engine power due to fuel exhaustion. Contributing to the accident was the improper installation of snap fasteners to the rubberized type fuel cells which resulted in wrinkling of the fuel bladders and incorrect fuel quantity for the flight.NTSB ERA10LA485Accident · Minor injuriesLimited investigationFinal reportBeech 58 · Rainelle, WVThe improper rigging of the fuel selector by maintenance personnel, which resulted in a total loss of engine power.