NTSB investigations: Volkswagen CONVERSION
14 cases on aircraft whose registry engine model is Volkswagen CONVERSION, where the first occurrence was “Loss of engine power(total) - nonmechanical”. 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 | 2 |
| 1984 | 1 |
| 1985 | 3 |
| 1986 | 2 |
| 1988 | 1 |
| 1992 | 2 |
| 1998 | 1 |
| 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.\"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\" = 353))
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" = 353))
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 SEA01LA144Accident · No injuriesLimited investigationFinal reportHutton KR-2 · Roseburg, ORA total loss of power for undetermined reasons and the pilot's misjudgment of distance and speed while maneuvering to a forced landing at a nearby airport. Contributing factors were the 8 knot tailwind and the fence which the aircraft impacted when it over…NTSB CHI98LA303Accident · Minor injuriesLimited investigationFinal reportCook Teenie TWO · Stevensville, MIThe pilot's inadequate preflight planning and preparation which resulted in fuel exhaustion and subsequent loss of engine power.NTSB FTW93LA034Accident · No injuriesLimited investigationFinal reportTodd Goudeau KR-2 · San Marcos, TXPower loss due to carburetor icing. Factors were the unsuitable landing area and no carburetor deice system installed on the powerplant.NTSB FTW92LA076Accident · Minor injuriesLimited investigationFinal reportAvions Fairey T-66 · Mineral Wells, TXFuel starvation due to a contaminated fuel filter. A factor was the soft terrain.NTSB CHI88DEP08Accident · No injuriesFinal reportMonnett Sonerai II · Wisc Rapids, WIThe plt rprtd that drg takeoff, the eng lost power as the acft was climbing thru about 200' AGL. An emerg lndg was made in the best available area, which was a golf course on rolling terrain. Drg the lndg roll, the plt applied brakes, but was unable to stop…NTSB ATL87LA026Accident · No injuriesLimited investigationFinal reportMullinax KR-2 · Augusta, GAThe plt stated that the eng always ran rough at full pwr due to a rich mixture setting on the carburetor. Normally the eng roughness could be corrected by retarding the throttle or mixture control. The plt said that he adjusted the mixture on the carburetor…NTSB MKC87LA005Accident · No injuriesLimited investigationFinal reportStahl-Ameter Monnett Sonerai II · Arab, MOThe pilot stated that the aircraft had capacity for ten gallons of usable fuel, and that he flew for less that an hour before landing at columbia, Illinois. According to the pilot, the sight gauges were not accurate on the ground and he did not visually check…NTSB CHI86FEM01Accident · Minor injuriesFinal reportLeone Sonerai II · Traverse City, MIThe acft contacted a tree and impacted the terrain in a nose down attitude during a forced landing following a loss of pwr which resulted from fuel exhaustion.NTSB CHI85LA293Accident · Serious injuriesLimited investigationFinal reportJohn H. MC Clain, JR. Rand KR2 · Mechanicstown, OHThe acft landed short of the rwy after a power loss. The plt said he was approaching to ladn at 1800 RPM when he added power to clear some power lines. The eng did not respond and the acft was flown under the wires where it collided with a tree during landing…NTSB CHI85FA269Accident · 2 fatalField investigationFinal reportChamberlain Viking Dragonfly · Faribault, MNThe acft collided with trees and burst into flames during a forced landing. On the plt's second radio contact with Faribault municipal airport UNICOM he declared, 'I have engine failure. I'm going down in a corn field.' Post accident inspection of the…NTSB CHI84LA233Accident · No injuriesLimited investigationFinal reportRobert Judd Sonerai II · Troy, MIThe plt reported that after a local flt he began a reduced power (1800 RPM) descent from 4500 ft MSL back to the arpt. At 3300 ft MSL the eng quit. The plt was unable to restart the eng as the prop was not windmilling & the acft was not equipped with an eng…NTSB MKC83LA192Accident · Minor injuriesLimited investigationFinal reportBurnett Sonerai 2 · Oxford, IAAfter takeoff, the plt turned to a x-wind leg of the traffic pattern & then the engine lost power. He made a forced landing in an OAT field, but reported that during the approach, he misjudged his height & did not flare in time. Subsequently, the acft landed…NTSB ATL83LA139Accident · Minor injuriesLimited investigationFinal reportBrown Sonera II L · Bowling Green, KYThe acft nosed over during a forced landing after the engine lost power on the base leg of the landing pattern. The weather was VMC and no flight plan was filed. The pilot stated that he had worked on the carburetor prior to this flightand had also moved the…NTSB LAX82DVG31Accident · Serious injuriesFinal reportLindgren Evans VP-1 · Winters, CAAcft ran out of fuel while plt was practicing stalls.