NTSB investigations: Volkswagen CONVERSION, 1988
10 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\") = 1988
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") = 1988
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 NYC89DHM03Accident · 1 fatalFinal reportVangorden KR-2 · Allaire, NJThe homebuilt aircraft was being flown on its maiden flight when the accident occurred. A witness stated that he observed the aircraft 'swirling down like a bird with a broken wing.' According to him, the aircraft was intact with no evidence of smoke before…NTSB CHI89DET01Accident · 1 fatalFinal reportVolksplane VP-1 · Coldwater, MIA stall with entry into the incipient stage of a spin with insufficient altitude for recovery.NTSB MKC88DCA01Accident · 1 fatalFinal reportRosenmayer Skyranger S/C · Maryland Hgts, MOWitnesses observed the a/c making a turn when the wings came off and the a/c nose-dived to the ground with the wings 'floating' down after the a/c. examination of the wreckage found a fatigue crack 1/3 the circumference with instantaneous cracking on the…NTSB CHI88DEP08Accident · No injuriesFinal reportMonnett Sonerai II · Wisc Rapids, WIThe plt rprtd that drg takeoff, the eng lost power as the acft was climbing thru about 200' AGL. An emerg lndg was made in the best available area, which was a golf course on rolling terrain. Drg the lndg roll, the plt applied brakes, but was unable to stop…NTSB DEN88LA166Accident · No injuriesLimited investigationFinal reportKrall Dragonfly · Mitchell, SDDrg the 1st attempt to land, the acft bounced several times, then the plt made a go-around. On the 2nd attempt, the acft bounced again & began to porpoise. A witness heard the eng RPM increase to 'what sounded like full power.' The acft lifted off, but…NTSB CHI88DEC04Accident · No injuriesFinal reportPerkins Dragonfly · Fowlerville, MIThe pilot failed to maintain positive control of his homebuilt aircraft by taking appropriate actions for recovery from the bounced landing. The aircraft contacted the ground abruptly on the third bounce and the upper wing spar failed. The pilot's lack of…NTSB CHI88DER10Accident · No injuriesFinal reportAnderson-Tucker Evans VP-1 · Duquette, MNOn the initial flight of this amateur built aircraft the pilot lowered the nose after liftoff to allow the aircraft to accelerate. However, the aircraft settled and the pilot was unable to keep the aircraft from colliding with trees.NTSB ATL88DLQ01Accident · No injuriesFinal reportByron/Sorrell SNS-2 · Morehead, KYInflight separation of both propeller blades from the acft for undetermined reasons.NTSB CHI88DET03Accident · No injuriesFinal reportDavis Heath Model V · Valparaiso, INThe plt rprtd that when he applied power to takeoff, the acft 'pulled to the right.' He said the acft became airborne, but touched down again & contd to go to the right. Also, he said he tried to correct the situation with left rudder, but the rudder seemed…NTSB ATL88DKG04Accident · Serious injuriesFinal reportWeber Evans VF-1 · Fort Payne, AL