NTSB investigations: Continental IO-360 series, WV
6 cases on aircraft whose registry engine model is Continental IO-360 series. 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
| 1969 | 1 |
|---|---|
| 1975 | 1 |
| 1982 | 1 |
| 1999 | 1 |
| 2002 | 1 |
| 2015 | 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\" = 'WV' 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 ('17025', '17045'))
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" = 'WV' 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 ('17025', '17045'))
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 ERA16LA070Accident · No injuriesLimited investigationFinal reportCirrus Design SR20 · Charles Town, WVThe flight instructor's inadequate remedial action and the student pilot's failure to maintain yaw control while practicing a stall, which resulted in an unintentional spin.NTSB NYC03LA007Accident · Minor injuriesLimited investigationFinal reportCirrus Design SR-20 · Point Pleasant, WVAn inadvertent collision with wildlife. A factor in the accident was wildlife having access to the runway environment.NTSB IAD00LA007Accident · No injuriesLimited investigationFinal reportCessna 172XP · Phillipi, WVThe pilot's improper flare that resulted in a hard landing.NTSB ATL82DA266Accident · No injuriesFinal reportAero Commander 112 · Fayetteville, WVUpon arrival at the destination arpt, the rwy lights were off & the plt diverted to the fayette arpt. During final the acft struck a tree 200 ft from the displaced threshold of rwy 21. The tree was 13 ft above the rwy end elevation.NTSB IAD76FGM07Accident · Minor injuriesClosedCessna 150G · New Cumberland, WVNTSB DIA70F0035Accident · No injuriesClosedCessna 336 · Taplin, WV