NTSB investigations: Volkswagen CONVERSION, NC
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
| 1985 | 1 |
|---|---|
| 1991 | 1 |
| 1992 | 1 |
| 1997 | 1 |
| 1998 | 1 |
| 2001 | 1 |
| 2009 | 1 |
| 2011 | 1 |
| 2019 | 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\" = 'NC' 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" = 'NC' 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 GAA20CA087Accident · No injuriesData collectionFinal reportFisher FP 202 Koala · Erwin, NCThe pilot's failure to maintain directional control during takeoff, which resulted in a runway excursion and impact with vegetation.NTSB ERA12CA043Accident · Minor injuriesData collectionFinal reportFehlner-Shelton Aerosport Scamp WTB1 · Grantham, NCThe pilot's inadequate clearance from unmarked power lines while on approach to land at a private airport.NTSB ERA09LA454Accident · 1 fatalLimited investigationFinal reportPongracz John M Nieuport 1 · Brasstown, NCThe pilot’s failure to maintain adequate airspeed during climb after takeoff, resulting in an inadvertent stall.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 ATL99LA012Accident · No injuriesLimited investigationFinal reportAeroSport WS-15-2 · Parkton, NCThe collapse of the carburetor heat box hose which starved the carburetor of air resulting in a partial loss of power, forced landing and nose over. Factors were the weeds and stocky stubble in the forced landing zone.NTSB MIA97LA204Accident · No injuriesLimited investigationFinal reportMoran Teenie TWO · Pinehurst, NCThe pilot's decision to takeoff with a tailwind and improper recovery from a bounced landing. This resulted in a premature lift off, in-flight collision with terrain, on-ground loss of directional control, and subsequent on-ground collision with a taxiway…NTSB ATL93LA007Accident · 1 fatalLimited investigationFinal reportBensen B-8M · Holly Ridge, NCThe pilot's failure to operate the flight controls properly.NTSB ATL91LA111Accident · 1 fatalLimited investigationFinal reportRider-Charles Aerosport Scamp · Raeford, NCThe pilot's improper adjustment of the engine carburetor, and his operation of the aircraft with a known powerplant deficiency. Factors in this accident were: the lack of spring tension for the fuel mixture, and the fouled condition of the engine spark plugs.NTSB ATL85FMG01Accident · 1 fatalFinal reportMcclellan J. Grote Dragonfly · Morrisville, NCThe owner/builder had prepared the acft for its 1st flt. This preparation included high speed taxi tests, a brake line repair & eng adjustments. Two 17.6 lb barbell weights were tied to the wing lift bulkhead with 5/16 inch hemp rope for purposes of weight &…