NTSB investigations, WV
13 cases where the first occurrence was “Loss of engine power(total) - mech failure/malf”.
Cases per year
| 1982 | 1 |
|---|---|
| 1983 | 1 |
| 1984 | 1 |
| 1988 | 1 |
| 1990 | 2 |
| 1991 | 1 |
| 1992 | 1 |
| 1993 | 1 |
| 1994 | 1 |
| 1997 | 2 |
| 2001 | 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\" = 351)
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" = 351) 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 NYC01IA211Incident · No injuriesIncident investigationFinal reportCessna 210L · Bluefield, WVImproper maintenance which resulted in the installation of an unserviceable piston assembly, and the subsequent catastrophic engine failure. Factors in this accident were the improper inspection by the piston supplier and the softening of the piston.NTSB NYC98LA045Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-200 · Fairplain, WVan improper overhaul of the fuel servo by the manufacturer, which resulted in the loss of engine power. Factors in the accident were the dark night conditions and rough forced landing terrain.NTSB NYC98LA005Accident · No injuriesLimited investigationFinal reportCessna 120 · Mineral Wells, WVA loss of engine power to a blockage in the carburetor resulting in fuel starvation.NTSB NYC94LA172Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-201T · Lockwood, WVAn electrical ground short of the ignition wires which resulted in a loss of engine power.NTSB NYC93FA177Accident · Minor injuriesField investigationFinal reportMitsubishi MU-2B-40 · S. Charleston, WVwas improper emergency procedures by the pilot which resulted in the shutdown of an operative engine, following a power loss due to a failed torque sensor in the other engine, which resulted in a total power loss approach, landing, and overrun.NTSB BFO92FA152Accident · 2 fatalField investigationFinal reportMooney M20K · Weston, WVTotal loss of engine power due to the inadequate torque of the no. 1 cylinder attach bolts and studs, fatique failure of the bolts/studs, and separation of the no. 1 cylinder. Factors related to the accident were: darkness and hilly terrain, which were…NTSB NYC91LA059Accident · No injuriesLimited investigationFinal reportCessna 172P · Charleston, WVTotal loss of engine power in cruise flight due to failure of the accessory drive gear dowel pin resulting in a forced landing over unsuitable terrain and subsequent nose over on landing roll. A factor related to the accident was the improper procedure used…NTSB NYC91LA020Accident · No injuriesLimited investigationFinal reportDassault-Breguet Falcon 50 · Parkersburg, WVCatastrophic failure of the left engine fan disc due to low cycle fatigue.NTSB BFO90IA039Incident · No injuriesIncident investigationFinal reportBellanca 17-30 · Davis, WVThe improper installation of the connecting rod bearings on the number one cylinder.NTSB BFO88FA036Accident · Minor injuriesField investigationFinal reportFokker F28 MK 4000 · Charleston, WVEngine and airframe failure were caused by the the separation of the first stage low pressure turbine disk. The disc interstage seal was installed inadequately, resulting in rubbing between the seal and disk, causing failure of the disk. Inadequate procedure…NTSB ATL85LA035Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Madison, WVFollowing a loss of eng power during a x-country flt, the plt landed on a bridge. During the ldg roll the wing struck a pole. Post crash examination of the engine disclosed that the camshaft gear teeth suffered fatigue failure.NTSB ATL83LA160Accident · No injuriesLimited investigationFinal reportBell 47G-4A · Charleston, WVDuring an approach to land, the engine lost power at aprx 500 ft AGL. The plt reported that during an autorotative landing, he had to maneuver to avoid trees & a ridge in order to land in a suitable area. During this time, rotor RPM dropped & a crash landing…NTSB ATL82DA181Accident · No injuriesFinal reportCessna 172 · Martinsburg, WVShortly after level-off to cruise, the engine began to lose power. The pilot attempted to restore the power, but the engine RPM continued to decrease. A turn was made back toward the airport. While scanning the instruments, zero oil pressure and a high oil…