NTSB investigations: Volkswagen CONVERSION
242 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.
Cases, newest first
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'))
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'))
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 CHI84LA389Accident · Minor injuriesLimited investigationFinal reportDenil Sonera II · De Pere, WIPlt stated that on initial climb, he became distracted by an insect in the cockpit and the acft drifted off the right side of the rwy, colliding with telephone lines near the end of the rwy.NTSB MKC84FA225Accident · 1 fatalField investigationFinal reportBobby Wayne Watkins Mini Coupe · Nashville, ARThe builder/owner/plt had flown the home built acft for about 10 mins on its 1st test flt which was made a few days prior to the accident. On third flt, he took off on rwy 01, climbed straight-out for awhile, made a left turn to x-wind leg & started a…NTSB FTW84FA290Accident · 1 fatalField investigationFinal reportGriffin FG-1A · Mt Pleasant, TXAccording to witnesses, the gyrocopter plt took off & turned onto a left downwind to stay in the traffic pattern for rwy 17. One witness stated that the gyrocopter turned onto final apch at about 300 to 400 ft AGL. Two other witnesses, who reside aprx 1/4 mi…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 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.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 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,…NTSB CHI83LA311Accident · No injuriesLimited investigationFinal reportViking Dragonfly · Flying Cloud, MNThe pilot was initiating a high speed taxi run when the acft became airborne for 500-1000 ft. when a landing was attempted the aircraft bounced.NTSB CHI83LA256Accident · Serious injuriesLimited investigationFinal reportQuickie Q2 · Anderson, INThe homebuilt acft veered and nosed over during a landing. Examination of the acft revealed that the cable to the left front rudder attach point became disconnected. The cable had pulled through the nicropress oval sleeve. When the pilot/ builder was…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 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 FTW83LA122Accident · No injuriesLimited investigationFinal reportMonnett Sonerai II · Las Cruces, NMThe new home built acft had only 2.5 hrs total flt time. After a test flt, the plt was on the landing roll when he lost control at aprx 35 mph. Subsequently, the acft ground looped & nosed over on its top. The plt reported that loss of control occurred after…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.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…NTSB CHI83LA011Accident · Minor injuriesLimited investigationFinal reportRand KR2 · Fairview, ILThe pilot overflew his destination and attempted to locate the airport. The pilot realized his fuel supply was low and decided to land in an open field. The aircraft's left wing struck the ground during the landing and the aircraftcartwheeled.NTSB LAX82DVG31Accident · Serious injuriesFinal reportLindgren Evans VP-1 · Winters, CAAcft ran out of fuel while plt was practicing stalls.NTSB CHI82DA143Accident · No injuriesFinal reportBenson BM8 · Batavia, OHThe pilot, on a local flight, was making an approach under visual meteorological conditions to runway 22. While on short final the pilot observed an aircraft taxi into takeoff position for runway 04. This is an uncontrolled airport. The pilot stated that as…NTSB FTW82DA138Accident · No injuriesFinal reportEvans VP-1 · Liberty Hill, TXThe pilot stated that he felt an excess roll tendency and had taken his hand from the throttle. The aircraft would not gain altitude and airspeed could not be maintained. He realized that the throttle had backed off from climb power and reapplied full power…NTSB CHI82DA121Accident · No injuriesFinal reportRand K.R.1 · Plymouth, MIOn takeoff roll the left upwind wing lifted and the pilot lost directional control. The aircraft swerved to the right and struck a parked bonanza, N5587D, causing substantial damage to both aircraft. Investigation revealed that the pilot attempted to takeoff…NTSB CHI82FEE03Accident · 1 fatalClosedSonerai II · Romeoville, ILNTSB LAX81FVD40Accident · 1 fatalClosedMinatre KR-2 · Tracy, CANTSB LAX81FVD35Accident · Minor injuriesClosedJeanie-Teen 02 · Tracy, CANTSB DEN81FTE61Accident · No injuriesClosedRand KR-2 · Rocky Ford, CONTSB NYC81FNA18Accident · 1 fatalClosedRand KR-2 · N Kingstown, RINTSB CHI81FEM23Accident · Serious injuriesClosedSonerai II · Escanaba, MINTSB CHI81FEV20Accident · Serious injuriesClosedRodgers Soneri · Moweaqua, ILNTSB ATL81DLQ17Accident · No injuriesClosedAero Sport Scamp · Ashland, KYNTSB DEN80FTE81Accident · Serious injuriesClosedKriket DK-1 · Ellicott, CONTSB MIA80FLD97Accident · 1 fatalClosedFletcher KR-1 · Sarasota, FLNTSB ATL80FID25Accident · Serious injuriesClosedSonerai M-1 · Matoaca, VANTSB LAX80FVG42Accident · Serious injuriesClosedJodel D-9 · Redding, CANTSB MIA80FKQ05Accident · Serious injuriesClosedAmateur PDQ-2 · Greenville, MSNTSB SEA80FYK04Accident · Serious injuriesClosedRand KR-2 · Brookings, ORNTSB CHI80FEI02Accident · Minor injuriesClosedWalton JD1 · Salem, OHNTSB LAX79DVG81Accident · Serious injuriesClosedVolksplane 1 · Potter Valley, CANTSB CHI79FEE86Accident · 1 fatalClosedVolksplane VP-1 · Plainfield, ILNTSB NYC79FGM47Accident · Minor injuriesClosedTeenie 2 · Greenville, PANTSB NYC79FNC45Accident · Minor injuriesClosedBenson B8MVW · Mars Hill, MENTSB CHI79FEE69Accident · Minor injuriesClosedBenson B-8M · Rockford, ILNTSB LAX79FVM27Accident · 1 fatalClosedBensen B8M · Paso Robles, CANTSB CHI79FEK15Accident · Serious injuriesClosedBenson B8M · Johnstown, OHNTSB CHI79FEP42Accident · No injuriesClosedAnderson Tent 2 · Burlington, WINTSB SEA79DYE03Accident · No injuriesClosedEvans VP-1 · Yelm, WANTSB FTW79DPD03Accident · No injuriesClosedHarmon 1 · Gainesville, TXNTSB LAX78FUG57Accident · Minor injuriesClosedWalker-Rand KR-1 · Corona, CANTSB OAK78DVM49Accident · No injuriesClosedBenson B8M · Watsonville, CANTSB NYC78FHA37Accident · 1 fatalClosedSoneria II · Pipersville, PANTSB SEA78FYM50Accident · 1 fatalClosedMini Coupe Buffum · Independence, ORNTSB MKC79FCD24Accident · No injuriesClosedCampbell KR-1 · Boone, IANTSB LAX78FUQ27Accident · Serious injuriesClosedFranks M-1 · Pacoima, CA