NTSB investigations: Volkswagen CONVERSION, 2009
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\") = 2009
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") = 2009
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 WPR09LA454Accident · Minor injuriesLimited investigationFinal reportLewis Jennings Nieuport 11 · Pahrump, NVA total loss of engine power during cruise flight due to a failure of the engine's sole magneto.NTSB CEN09CA593Accident · Minor injuriesData collectionFinal reportLinke KR-2 · Mt. Vernon, ILThe inadequate preflight planning/preparation and fuel management by the pilot which led to fuel exhaustion and a total loss of engine power during approach. Contributing to the accident was the inoperative fuel indicator.NTSB ERA09LA454Accident · 1 fatalLimited investigationFinal reportPongracz John M Nieuport 1 · Brasstown, NCThe pilot’s failure to maintain adequate airspeed during climb after takeoff, resulting in an inadvertent stall.NTSB WPR09LA286Accident · Serious injuriesLimited investigationFinal reportWermling KR-2 Rand Robinson · Anaconda, MTThe non-certificated pilot’s failure to maintain airspeed and aircraft control during initial climb resulting in a stall/spin.NTSB ERA09LA263Accident · 1 fatalLimited investigationFinal reportKeeley/Tidd MK-1 · Demopolis, ALThe pilot's failure to maintain adequate airspeed following a complete loss of engine power resulting in a stall while maneuvering to land. The reason for the loss of engine power was undetermined.NTSB CEN09LA263Accident · 1 fatalLimited investigationFinal reportLaseure Sonerai II · Grantsburg, WIThe pilot's failure to maintain airspeed during initial climb which resulted in a stall/spin. Contributing to the accident was the degraded engine performance.NTSB ERA09LA222Accident · Serious injuriesLimited investigationFinal reportRogers Kenneth J Flaglor Scooter · Griffin, GAA total loss of engine power due to the failure of the engine-driven fuel pump. Contributing to the accident was unsuitable terrain for a forced landing and the pilot’s preexisting medical condition.