Skip to content

NTSB investigations: Lycoming 0-235 series, WV

16 cases on aircraft whose registry engine model is Lycoming 0-235 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19652026

Where

Latest cases

Query with SQL

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 ('41505')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 ('41505'))
  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 ('41505'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 ERA26LA283Accident · Serious injuriesClass 3 · LimitedPreliminary reportAmerican AA-1 · Kearneysville, WVOn July 23, 2026, at 1440 eastern daylight time, an American AA-1, N6132L, was substantially damaged when it was involved in an accident near Kearneysville, West Virginia. The pilot and pilot-rated passenger were seriously injured. The airplane was being…Jul 23, 2026 · N6132L · Substantial damage NTSB NYC98LA149Accident · No injuriesLimited investigationFinal reportCessna 152 · Philippi, WVWas the failure of an exhaust valve. A factor in the accident was the unsuitable landing area encountered by the pilot.Jul 20, 1998 · N69193 · Substantial damage NTSB IAD97LA074Accident · No injuriesLimited investigationFinal reportAmerican AA-1 · Lewisburg, WVThe pilot's inadequate preflight, which led to the loss of a fuel cap and subsequent fuel exhaustion.May 10, 1997 · N5734L · Destroyed NTSB BFO95LA091Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Martinsburg, WVthe student pilot's failure to maintain control of the airplane during the landing/aborted landing sequence. A related factor is the student pilot's lack of total flight experience.Aug 30, 1995 · N68969 · Substantial damage NTSB BFO91LA005Accident · No injuriesLimited investigationFinal reportCessna C152 · Bridgeport, WVThe pilot's inability to avoid a collision with deer which had moved onto the runway during their takeoff roll. The dark night contributed to the accident by limiting the pilots' visual outlook.Oct 20, 1990 · N757RM · Substantial damage NTSB BFO90LA031Accident · No injuriesLimited investigationFinal reportCessna 152 · Grafton, WVThe pilot's improper use of carburetor heat, when operating at reduced power in conditions which were conducive to carburetor ice.Mar 1, 1990 · N65538 · Substantial damage NTSB ATL84LA049Accident · No injuriesLimited investigationFinal reportCessna 152 · Huntington, WVAcft ballooned during the landing portion of a touch-&-go. The student added power & the acft stalled in a nose high attitude. The acft dropped to the rwy from about 10 ft.Nov 26, 1983 · N49440 · Substantial damage NTSB ATL83FA060Accident · 1 fatalField investigationFinal reportGrumman American AA-1B · Summerville, WVOn 12/10/82, the student plt departed on a supervised solo x-country from moundsville, WV to huntington, WV, white sulpher springs, WV and back to moundsville. Wx conds deteriorated drg the 1st 2 legs of the flt and the student's flt instructor (CFI) told him…Dec 11, 1982 · N1621R · Substantial damage NTSB ATL82FGM01Accident · No injuriesClosedPiper PA-38 · New Cumberland, WVOct 5, 1981 · N9314T · Substantial damage NTSB ATL81DIJ07Accident · No injuriesClosedCessna 152 · Bridgeport, WVMay 8, 1981 · N5440M · Substantial damage NTSB ATL80FIJ04Accident · Minor injuriesClosedGrum Amer AA1-B · Philippi, WVJul 5, 1980 · N9611L · Substantial damage NTSB IAD76FGN39Accident · Minor injuriesClosedGrum Amer AA-1B · New Cumberland, WVJul 13, 1976 · N1609R · Substantial damage NTSB NYC72DIJ35Accident · No injuriesClosedAmer Avco AA-1A · Buckhannon, WVFeb 9, 1972 · N9407L · Substantial damage NTSB IAD70D0096Accident · No injuriesClosedPiper PA-12 · Buckhannon, WVOct 5, 1969 · N3395M · Substantial damage NTSB NYC67D0216Accident · No injuriesClosedPiper PA-22 · Bellington, WVJul 10, 1966 · N5847Z · Destroyed NTSB NYC66D0419Accident · Minor injuriesClosedPiper PA-16 · Spencer, WVDec 1, 1965 · N5977H · Substantial damage