NTSB investigations, WV
8 cases where the first occurrence was “Loss of engine power(partial) - mech failure/malf”.
Cases per year
| 1983 | 1 |
|---|---|
| 1985 | 1 |
| 1998 | 1 |
| 2002 | 1 |
| 2003 | 1 |
| 2004 | 1 |
| 2005 | 1 |
| 2007 | 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.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 352)
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."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 352) 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 NYC08FA012Accident · 4 fatalField investigationFinal reportAero Commander 560-F · Wiley Ford, WVA partial power loss in the right engine due to the failure of the number one exhaust valve, and the airplane's inability to maintain a climb on one engine for unknown reasons. Contributing to the accident were fog and rising terrain. [This report was…NTSB NYC06CA012Accident · No injuriesData collectionFinal reportWeber Glastar · Summersville, WVa loss of engine power due to a stuck carburetor float needle.NTSB IAD04LA035Accident · Serious injuriesLimited investigationFinal reportGiles Mustang II · Rainelle, WVThe partial loss of engine power due to a broken throttle mechanism, which resulted in a forced landing over unsuitable terrainNTSB NYC03LA155Accident · Serious injuriesLimited investigationFinal reportBeech BE-56TC · Bethany, WVA total loss of power in the right engine for undetermined reasons. A factor was a partial loss of power in the left engine due to a loose oil line.NTSB IAD02LA053Accident · Minor injuriesLimited investigationFinal reportBeech V35A · Martinsburg, WVInadequate torque of the crankcase through bolts.NTSB NYC98LA149Accident · No injuriesLimited investigationFinal reportCessna 152 · Philippi, WVWas the failure of an exhaust valve. A factor in the accident was the unsuitable landing area encountered by the pilot.NTSB ATL85LA279Accident · No injuriesLimited investigationFinal reportCessna 177RG · Neola, WVWhile leveling at cruise altitude the engine lost power and the pilot attempted a forced landing in a field. During landing roll the aircraft collided with small trees at the end of the field. Post-crash examination of the engine disclosed a 3 inch crack in…NTSB ATL83LA314Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Normantown, WVThe plt noticed smoke in the cockpit, & soon thereafter observed the oil press gage reading zero. The plt was given radar vectors to the nearest arpt but he was unable to reach it. The acft collided with trees & a powerline during the forced landing.…