NTSB investigations: Volkswagen CONVERSION
9 cases on aircraft whose registry engine model is Volkswagen CONVERSION, where the first occurrence was “Loss of engine power(total) - mech failure/malf”. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.
Cases per year
| 1982 | 1 |
|---|---|
| 1983 | 1 |
| 1986 | 1 |
| 1989 | 1 |
| 1991 | 1 |
| 1994 | 2 |
| 1995 | 1 |
| 1998 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('63501')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND 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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('63501')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 351))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 SEA98LA192Accident · Minor injuriesLimited investigationFinal reportMayala Dragonfly · Avon, MTFailure of the engine crankshaft aft oil seal resulting in the loss of engine oil, and rough terrain during the forced landing.NTSB CHI95LA211Accident · 1 fatalLimited investigationFinal reportFirst Strike Bobcat · Burlington, IAfatigue failure of a copper fuel line at the carburetor ferrule fitting, which resulted in fuel starvation. The proximity of trees was a related factor.NTSB MIA94LA194Accident · Minor injuriesLimited investigationFinal reportAerosport Quail · Waynesboro, MSAn engine failure due to improper maintenance [overhaul] of the engine crankshaft.NTSB NYC94LA131Accident · No injuriesLimited investigationFinal reportDonovan DER Kricket 17K-1 · Brockport, NYThe loss of engine power as a result of a sticking valve in the carburetor due to dirt contamination.NTSB ATL91LA111Accident · 1 fatalLimited investigationFinal reportRider-Charles Aerosport Scamp · Raeford, NCThe pilot's improper adjustment of the engine carburetor, and his operation of the aircraft with a known powerplant deficiency. Factors in this accident were: the lack of spring tension for the fuel mixture, and the fouled condition of the engine spark plugs.NTSB ATL89DKJ05Accident · Minor injuriesFinal reportHadley Teenie TWO · Guntersville, ALUndetermined. Factors related to the accident were: lack of a suitable landing area, high obstructions, and a dirt bank.NTSB MIA86FLT01Accident · Serious injuriesFinal reportAmateur Built Eenie TWO · Waynesboro, MSThe acft nosed over during a forced landing after a power loss. According to witnesses the acft made a climbing turn after takeoff followed by a low pass near the witnesses. The acft then disappeared behind some trees and when it reappeared the engine was not…NTSB ATL83LA207Accident · No injuriesLimited investigationFinal reportRand KR-2 · Dayton, TNThe acft had been airborne for over 1 hr & was descending onto base leg when the eng quit running as the plt went to add power. A forced landing was made in a grassy area near the rwy. After the acft touched down, it hit a ditch during the roll-out, then…NTSB FTW83LA016Accident · Minor injuriesLimited investigationFinal reportVolksplane VP-2 · Houston, TXAfter taking off, the pilot flew back by the airport and then began to climb again. While climbing through about 700 ft, the engine lost power. The pilot was unable to reach the airport. During a landing, he cleared over an area with trees but struck a power…