NTSB investigations: Volkswagen CONVERSION, MO
4 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
| 1985 | 1 |
|---|---|
| 1986 | 1 |
| 1988 | 1 |
| 2002 | 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\" = 'MO' 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" = 'MO' 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 CHI02LA297Accident · No injuriesLimited investigationFinal reportJonas Nieuport · Creve Coeur, MOThe installation of improper carburetor jets resulting in an improper fuel mixture and loss of engine power.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 MKC87LA005Accident · No injuriesLimited investigationFinal reportStahl-Ameter Monnett Sonerai II · Arab, MOThe pilot stated that the aircraft had capacity for ten gallons of usable fuel, and that he flew for less that an hour before landing at columbia, Illinois. According to the pilot, the sight gauges were not accurate on the ground and he did not visually check…NTSB MKC85LA090Accident · Minor injuriesLimited investigationFinal reportLester F.W. West VP-1 · Taylor, MOThe pilot used only half of the available 2900 feet of runway on his first flight in this homebuilt airplane. He lost flying speed climbing over wires at the end of the runway, went around trees and landed hard on a highway median.