NTSB investigations: Volkswagen CONVERSION, FL
12 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
| 1976 | 1 |
|---|---|
| 1980 | 1 |
| 1991 | 2 |
| 1994 | 1 |
| 1998 | 1 |
| 1999 | 1 |
| 2003 | 1 |
| 2005 | 2 |
| 2010 | 1 |
| 2023 | 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\" = 'FL' 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" = 'FL' 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 ERA23LA206Accident · Serious injuriesClass 3 · LimitedFinal reportThatcher CX4 · West Palm Beach, FLThe loss of engine power due to fuel exhaustion.NTSB ERA10CA336Accident · No injuriesData collectionFinal reportSchooley Sonex · Punta Gorda, FLThe pilot's improper flare, resulting in a hard landing.NTSB MIA05LA146Accident · 1 fatalLimited investigationFinal reportGustafson Easy Eagle · Milton, FLA loss of engine power during initial climb after takeoff for an undetermined reason, which resulted in a forced landing and subsequent in-flight collision with tree-covered terrain.NTSB MIA05LA098Accident · Serious injuriesLimited investigationFinal reportGordon E. Brown Nieuport C-1 · Homestead, FLThe reported loss of engine power for undetermined reasons on the downwind leg which resulted in a forced landing, and subsequent in-flight collision with a guy-wire and terrain.NTSB MIA03LA146Accident · 1 fatalLimited investigationFinal reportSonerai Sonerai IIB · Lakeland, FLThe pilot's decision to conduct low level flight and his failure to maintain obstacle clearance.NTSB MIA99LA228Accident · No injuriesLimited investigationFinal reportWilliam John Schulz WJS Jaybird · Tangerine, FLthe pilot's improper torqueing of a rocker arm adjusting jam nut, that resulted in the adjuster loosening, and a partial loss of engine power. This resulted in the pilot making an off airport precautionary landing and subsequent nose over, during which the…NTSB ATL98LA044Accident · No injuriesLimited investigationFinal reportCharles Holmes Kitfox XL · Homestead, FLThe student pilot's improper touchdown flare during landing.NTSB MIA94LA143Accident · Minor injuriesLimited investigationFinal reportAerosport Scamp WT-B1 · Lake Wales, FLThe pilot-in-command's failure to maintain airspeed (vs) while maneuvering resulting in an in-flight loss of control (inadvertent stall) and subsequent in-flight collision with terrain.NTSB MIA91LA194Accident · Minor injuriesLimited investigationFinal reportSchultz Avid Flyer 502 · O'Brien, FLThe pilot in command's improper planned final approach, which resulted in an in flight collision with an electrical service line, and in flight collision with terrain.NTSB MIA91LA145Accident · Serious injuriesLimited investigationFinal reportCorley Hubert KR-2 · Venice, FLThe pilot's improper use of flight controls.NTSB MIA80FLD97Accident · 1 fatalClosedFletcher KR-1 · Sarasota, FLNTSB MIA76FLD66Accident · No injuriesClosedTeenie TWO · Deland, FL