NTSB investigations: Lycoming 0-290 series, WV
6 cases on aircraft whose registry engine model is Lycoming 0-290 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
| 1966 | 1 |
|---|---|
| 1972 | 1 |
| 1974 | 1 |
| 1985 | 1 |
| 2001 | 1 |
| 2018 | 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 ('41506'))
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 ('41506'))
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 GAA19CA018Accident · No injuriesData collectionFinal reportPiper PA 16 · Manchester, WVA vehicle's incursion onto an active runway, which resulted in an evasive action by the pilot landing an airplane on that runway and a subsequent runway excursion.NTSB NYC01LA070Accident · 1 fatalLimited investigationFinal reportWhittman Tailwind DN-1 · Grafton, WVThe pilot's improper preflight planning, which resulted in fuel exhaustion. A factor was the pilot's lack of familiarity with the airplane.NTSB ATL85FIJ01Accident · Minor injuriesFinal reportStarduster SA-100 · Point Pleasant, WVThe plt stated that she made a normal preflt. She reported that the float type fuel gage indicated that the main fuel tank, which had a capacity of 12 gal, was half full. While climbing thru about 500 ft AGL after takeoff, the eng sputtered & lost power. The…NTSB IAD75FIJ01Accident · No injuriesClosedPiper PA-22 · Fayetteville, WVNTSB NYC73FIJ08Accident · No injuriesClosedPiper PA-22 · Maysel, WVNTSB NYC67A0061Accident · 4 fatalClosedPiper PA-22 · Maysville, WV