NTSB investigations: Volkswagen CONVERSION, TX
18 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
| 1974 | 1 |
|---|---|
| 1975 | 1 |
| 1976 | 1 |
| 1977 | 1 |
| 1978 | 1 |
| 1982 | 2 |
| 1984 | 2 |
| 1992 | 3 |
| 1998 | 2 |
| 2004 | 1 |
| 2006 | 1 |
| 2008 | 1 |
| 2011 | 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 c.\"eventStateOrRegion\" = 'TX' AND c.\"eventCountry\" = 'USA'
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 c."eventStateOrRegion" = 'TX' AND c."eventCountry" = 'USA'
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 CEN12CA026Accident · Serious injuriesData collectionFinal reportJantzen Evans VP · Terrell, TXThe pilot’s inadequate preflight planning, in that he did not determine whether the airplane’s climb performance would be sufficient to clear obstacles before initiating take off.NTSB DFW08CA211Accident · No injuriesData collectionFinal reportMurray Frank H DA5B · Odessa, TXFailure of the intake manifold when the flexible connectors disconnected from the carburetor after a turbulence encounter. Contributing to the accident was insuitable terrain for a forced landing.NTSB DFW06CA129Accident · Minor injuriesData collectionFinal reportMahoney Evans VP-1 · Corpus Christi, TXThe pilot's failure to maintain control of the airplane. A contributing factor was the dust devil/whirlwind.NTSB DFW05CA005Accident · Minor injuriesData collectionFinal reportMurray DA5B · Odessa, TXThe pilot's improper recovery from a bounced landing. A contributing factor was the unsuitable terrain for landing.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 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 FTW93LA034Accident · No injuriesLimited investigationFinal reportTodd Goudeau KR-2 · San Marcos, TXPower loss due to carburetor icing. Factors were the unsuitable landing area and no carburetor deice system installed on the powerplant.NTSB FTW92DRA04Accident · Serious injuriesFinal reportEvans VP-1 · Friendswood, TXThe pilot's failure to maintain a proper descent rate during the forced landing. A factor was the engine power loss for undetermined reasons.NTSB FTW92LA076Accident · Minor injuriesLimited investigationFinal reportAvions Fairey T-66 · Mineral Wells, TXFuel starvation due to a contaminated fuel filter. A factor was the soft terrain.NTSB FTW85LA046Accident · No injuriesLimited investigationFinal reportReed Bandit 1 · Amarillo, TXThe homebuilt acft, N52957, was observed to land hard, collapse the landing gear & slide into N3376V holding short of the rwy at an intersecting taxiway.NTSB FTW84FA290Accident · 1 fatalField investigationFinal reportGriffin FG-1A · Mt Pleasant, TXAccording to witnesses, the gyrocopter plt took off & turned onto a left downwind to stay in the traffic pattern for rwy 17. One witness stated that the gyrocopter turned onto final apch at about 300 to 400 ft AGL. Two other witnesses, who reside aprx 1/4 mi…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 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 FTW79DPD03Accident · No injuriesClosedHarmon 1 · Gainesville, TXNTSB FTW77FPD25Accident · Minor injuriesClosedSonerai 1 · Fort Worth, TXNTSB FTW76FRG48Accident · No injuriesClosedVolksplane VP-1 · San Antonio, TXNTSB FTW76DRG17Accident · No injuriesClosedVolksplane VP-1 · Marion, TXNTSB FTW75DPA12Accident · Minor injuriesClosedHarmon Monopl · Sherman, TX