NTSB investigations: Volkswagen CONVERSION, 1982
7 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 per year
| 1967 | 1 |
|---|---|
| 1969 | 3 |
| 1970 | 2 |
| 1971 | 2 |
| 1972 | 3 |
| 1973 | 4 |
| 1974 | 6 |
| 1975 | 6 |
| 1976 | 8 |
| 1977 | 6 |
| 1978 | 9 |
| 1979 | 9 |
| 1980 | 6 |
| 1981 | 8 |
| 1982 | 7 |
| 1983 | 7 |
| 1984 | 6 |
| 1985 | 9 |
| 1986 | 10 |
| 1987 | 1 |
| 1988 | 10 |
| 1989 | 4 |
| 1990 | 5 |
| 1991 | 4 |
| 1992 | 9 |
| 1993 | 2 |
| 1994 | 3 |
| 1995 | 3 |
| 1996 | 2 |
| 1997 | 4 |
| 1998 | 11 |
| 1999 | 4 |
| 2000 | 1 |
| 2001 | 9 |
| 2002 | 2 |
| 2003 | 4 |
| 2004 | 3 |
| 2005 | 7 |
| 2006 | 2 |
| 2007 | 1 |
| 2008 | 6 |
| 2009 | 7 |
| 2010 | 3 |
| 2011 | 5 |
| 2012 | 2 |
| 2013 | 1 |
| 2014 | 3 |
| 2015 | 3 |
| 2016 | 2 |
| 2019 | 2 |
| 2021 | 2 |
| 2022 | 1 |
| 2023 | 1 |
| 2026 | 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 year(c.\"eventDate\") = 1982
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 year(c."eventDate") = 1982
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" 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 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…