NTSB investigations: Volkswagen CONVERSION, 1998
11 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\") = 1998
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") = 1998
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 FTW99LA053Accident · Serious injuriesLimited investigationFinal reportDennis Pointer KR-2 · Denton, TXThe pilot's loss of control as result of his improper recovery from a bounced landing.NTSB ATL99LA012Accident · No injuriesLimited investigationFinal reportAeroSport WS-15-2 · Parkton, NCThe collapse of the carburetor heat box hose which starved the carburetor of air resulting in a partial loss of power, forced landing and nose over. Factors were the weeds and stocky stubble in the forced landing zone.NTSB FTW99LA011Accident · No injuriesLimited investigationFinal reportWilson Teenie TWO · Abilene, TXThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.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 CHI98LA281Accident · No injuriesLimited investigationFinal reportLuckey Dragonfly II · Caro, MIan improper inflight decision when he mistook the road for the runway of the nearby airport to land on. A factor in this accident was the total failure of the engine's crankshaft.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 CHI98LA271Accident · Minor injuriesLimited investigationFinal reportVollmers Sonerai II L · Lincoln, NDLoss of engine power due to a corroded ignition wire. Related factors were the tailwind, and ditch.NTSB CHI98LA211Accident · Minor injuriesLimited investigationFinal reportHartzler Nieuport 11 · Gardner, KSthe pilot's inadequate weather evaluation and the aircraft stall. A factor to the accident was the gusting wind.NTSB CHI98FA096Accident · 2 fatalField investigationFinal reportWasielak Sonerai II L · Malta, ILThe pilot's failed to maintain adequate clearance from the other aircraft.NTSB NYC98LA122Accident · Serious injuriesLimited investigationFinal reportGoins Sonerai II LTS · Suffolk, VAThe pilot's failure to maintain directional control during the initial takeoff climb. Factors related to the accident were habit interference, the pilot's lack of experience in the make and model, and the trees.NTSB ATL98LA044Accident · No injuriesLimited investigationFinal reportCharles Holmes Kitfox XL · Homestead, FLThe student pilot's improper touchdown flare during landing.