NTSB investigations: Volkswagen CONVERSION, 2001
9 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\") = 2001
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") = 2001
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 LAX02LA010Accident · 1 fatalLimited investigationFinal reportRhoades Jodel D-9 · Waialua, HILoss of engine power for unknown reasons. A factor was the inadvertent stall the pilot encountered while maneuvering to make a forced landing in an open taro field.NTSB NYC01LA192Accident · Serious injuriesLimited investigationFinal reportMontgomery Teenie Two · Cambridge, OHthe pilot's improper maintenance which resulted in the engine retarding to idle, and subsequent forced landing. A factor was the tall grass in the field where the forced landing was performed.NTSB SEA01LA144Accident · No injuriesLimited investigationFinal reportHutton KR-2 · Roseburg, ORA total loss of power for undetermined reasons and the pilot's misjudgment of distance and speed while maneuvering to a forced landing at a nearby airport. Contributing factors were the 8 knot tailwind and the fence which the aircraft impacted when it over…NTSB CHI01LA222Accident · Minor injuriesLimited investigationFinal reportDruine Turbulent D-31 · Lebanon, INThe pilot not maintaining aircraft control while maneuvering during initial climb. Factors to the accident were the improperly serviced propeller that resulted in a pitch setting that was insufficient for normal flight.NTSB LAX01LA238Accident · No injuriesLimited investigationFinal reportSparks KR-2 · San Diego, CAFailure of the pilot to maintain directional control during landing.NTSB IAD01LA077Accident · Minor injuriesLimited investigationFinal reportGarro Sonerai II · Cortland, OHthe pilot's failure to maintain directional control during an aborted take-off. A factor was the pilot's failure to obtain adequate take-off speed.NTSB FTW01LA114Accident · Serious injuriesLimited investigationFinal reportBoykin B J B8M · Clarksville, ARthe pilot's inadequate preflight inspection, which resulted in a loose control stick on takeoff, rendering the aircraft uncontrollable.NTSB MIA01LA115Accident · Minor injuriesLimited investigationFinal reportJerome Wells KR-2 · Nashville, NCthe pilot's improper preflight inspection, which resulted in his operating an aircraft with contaminated fuel that resulted in a loss of engine power and and a forced landing to a field and damage to the aircraft during the forced landing.NTSB LAX01LA086Accident · Minor injuriesLimited investigationFinal reportStorey MK 7 · Marana, AZThe pilot's inadequate preflight preparation with regards to runway choice, terrain, and performance capabilities of the airplane.