Skip to content

NTSB investigations: Volkswagen CONVERSION, CA

26 cases on aircraft whose registry engine model is Volkswagen CONVERSION. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19692026

Where

Latest cases

Query with SQL

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" = 'CA' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('63501')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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\" = 'CA' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('63501'))
  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" = 'CA' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('63501'))
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 LAX05LA133Accident · Minor injuriesLimited investigationFinal reportClark Aerosport Scamp · Chino, CAa loss of engine power due to the pilot/builder's excessive adjustment (lean) of the mixture setting at the carburetor. The pilot/builder's failure to perform a more comprehensive ground test prior to flight was a factor.Apr 11, 2005 · N234HC · Substantial damage NTSB LAX01LA238Accident · No injuriesLimited investigationFinal reportSparks KR-2 · San Diego, CAFailure of the pilot to maintain directional control during landing.Jul 7, 2001 · N122MS · Substantial damage NTSB LAX96LA033Accident · No injuriesLimited investigationFinal reportRussell KR-2 · Adelanto, CAthe pilot's misjudgement of the height above touchdown and his premature flare, which resulted in a hard landing.Oct 29, 1995 · N14MR · Substantial damage NTSB LAX93LA032Accident · 1 fatalLimited investigationFinal reportR.W. Sherman Turbulent · Adelanto, CAThe pilot's improper emergency decision to attempt to return to the departure area. Contributing to this accident was the undetermined loss of power, inadequate altitude, and failure to maintain the airspeed.Nov 7, 1992 · N84766 · Destroyed NTSB LAX92LA297Accident · No injuriesLimited investigationFinal reportKrug Lincoln Sportplane · Corona, CAThe pilot/builder inadequate propeller component resulting in an inadequate climb performance. Contributing to this accident was the airplane's inability to climb.Jul 14, 1992 · N377JK · Substantial damage NTSB LAX90DUG11Accident · Serious injuriesFinal reportVolksplane WE-1 · El Mirage, CAThe pilot's failure to maintain airspeed.Sep 30, 1990 · N91RR · Substantial damage NTSB LAX90DUG01Accident · 1 fatalFinal reportMannon-Underwood JEANIE'S Teenie · Hemet, CAInadvertent stall experienced by the pilot and his lack of experience.Oct 21, 1989 · N63327 · Destroyed NTSB LAX84LA140Accident · No injuriesLimited investigationFinal reportJodell D-9 · Livermore, CAThe plt stated that after departing on rwy 07 for touch and go landings, the eng 'sagged 400-450 RPM.' With insufficientpower for continued flight, he landed in a plowed field. The plt reported carburetor ice.Jan 15, 1984 · N3411G · Substantial damage NTSB LAX83FUA06Accident · 1 fatalFinal reportRand Robinson KR-1 · Seal Beach, CAAccording to a witness, the acft apchd at about 1000 ft, made 3 circles & headed in an easterly direction. The acft was then observed to make a steep banked turn toward the witness at an estimated altitude of 200 to 300 ft above the water. It then nosed down,…Jul 23, 1983 · N98BB · Destroyed NTSB LAX83FUG08Accident · 2 fatalFinal reportRand KR-2 · Norco, CAExperimental aircraft on demonstration flight spun to the ground from low altitude and was destroyed on impact. Witness saw and heard the aircraft maneuver and crash with the engine at high RPM. Weather was VMC.Dec 12, 1982 · N5RU · Destroyed NTSB LAX82DVG31Accident · Serious injuriesFinal reportLindgren Evans VP-1 · Winters, CAAcft ran out of fuel while plt was practicing stalls.Aug 30, 1982 · N64552 · Substantial damage NTSB LAX81FVD40Accident · 1 fatalClosedMinatre KR-2 · Tracy, CAAug 16, 1981 · N23WM · Destroyed NTSB LAX81FVD35Accident · Minor injuriesClosedJeanie-Teen 02 · Tracy, CAJul 26, 1981 · N9884 · Destroyed NTSB LAX80FVG42Accident · Serious injuriesClosedJodel D-9 · Redding, CAMay 18, 1980 · N7128 · Destroyed NTSB LAX79DVG81Accident · Serious injuriesClosedVolksplane 1 · Potter Valley, CASep 29, 1979 · N37789 · Destroyed NTSB LAX79FVM27Accident · 1 fatalClosedBensen B8M · Paso Robles, CAJun 17, 1979 · N1450 · Destroyed NTSB LAX78FUG57Accident · Minor injuriesClosedWalker-Rand KR-1 · Corona, CASep 30, 1978 · N37891 · Destroyed NTSB OAK78DVM49Accident · No injuriesClosedBenson B8M · Watsonville, CASep 23, 1978 · N1450 · Substantial damage NTSB LAX78FUQ27Accident · Serious injuriesClosedFranks M-1 · Pacoima, CAMay 14, 1978 · N14566 · Destroyed NTSB LAX78FUG25Accident · Serious injuriesClosedRand KR2 · Corona, CAMay 11, 1978 · N31158 · Destroyed NTSB LAX77FUG20Accident · No injuriesClosedKR 1 · Chino, CADec 26, 1976 · N65117 · Substantial damage NTSB LAX77DUG06Accident · No injuriesClosedMurphys MM-1 · Chino, CAOct 9, 1976 · N16CW · Substantial damage NTSB LAX76DUQ47Accident · Serious injuriesClosedRand KR-1 · Lancaster, CAJul 20, 1976 · N1436 · Destroyed NTSB OAK74FVG38Accident · No injuriesClosedBensen B8M · Davis, CAApr 9, 1974 · N73691 · Substantial damage NTSB LAX74FUG43Accident · No injuriesClosedRand KR-1 · Riverside, CAFeb 24, 1974 · N1436 · Destroyed NTSB LAX70D0138Accident · No injuriesClosedAllen Jenie Teeney · Chino, CASep 12, 1969 · N2178 · Substantial damage