NTSB investigations: Lycoming O&VO-360 series, VA

90 cases on aircraft whose registry engine model is Lycoming O&VO-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, newest first

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\" = 'VA' 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 ('41514'))
  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.

NTSB ATL80F1A06Accident · Serious injuriesClosedPiper PA-28 · Front Royal, VAMay 5, 1980 · N43954 · DestroyedNTSB IAD80DID04Accident · No injuriesClosedPiper PA-28 · Lynchburg, VADec 7, 1979 · N6410J · Substantial damageNTSB IAD79FID29Accident · Minor injuriesClosedPiper PA-28 · Urbanna, VAAug 28, 1979 · N4815T · Substantial damageNTSB IAD79FID27Accident · No injuriesClosedStarduster SA300 · Weirwood, VAAug 17, 1979 · N17FP · DestroyedNTSB IAD79FID07Accident · No injuriesClosedBeech C23 · Chesterfield, VAFeb 6, 1979 · N6576R · Substantial damageNTSB IAD78FA061Accident · 1 fatalClosedBeech C23 · The Plains, VAMay 13, 1978 · N24617 · DestroyedNTSB IAD78FIA01Accident · Minor injuriesClosedCessna 177 · Nokesville, VADec 4, 1977 · N35104 · Substantial damageNTSB IAD78DIJ01Accident · Serious injuriesClosedPiper PA-28 · Abingdon, VAOct 13, 1977 · N38531 · DestroyedNTSB IAD77DID14Accident · No injuriesClosedBeech C23 · Portsmouth, VAMar 4, 1977 · N2259L · Substantial damageNTSB IAD76FID19Accident · No injuriesClosedAir & Space 18A · Collinsville, VAJan 31, 1976 · N6128S · Substantial damageNTSB IAD76FID10Accident · No injuriesClosedPiper PA-24 · South Hill, VASep 15, 1975 · N7571P · Substantial damageNTSB IAD75AI011Accident · No injuriesClosedBeech C23 · Norfolk, VASep 8, 1974 · N2120W · No damageNTSB IAD74FIA15Accident · Minor injuriesClosedCessna 177B · Winchester, VAMay 6, 1974 · N34636 · Substantial damageNTSB IAD73AI011Accident · 2 fatalClosedPiper PA-24 · Orange, VAApr 13, 1973 · N6273P · DestroyedNTSB NYC72FIA11Accident · Minor injuriesClosedPiper PA-28 · Front Royal, VADec 29, 1971 · N1953T · Substantial damageNTSB NYC72DIA08Accident · No injuriesClosedPiper PA-28 · Culpeper, VAOct 15, 1971 · N8803J · Substantial damageNTSB IAD71AI027Accident · No injuriesClosedMooney M20C · Lynchburg, VAOct 21, 1970 · N9170V · Substantial damageNTSB IAD70FIA08Accident · No injuriesClosedPiper PA-28 · Baileys X Road, VAApr 8, 1970 · N8475W · Substantial damageNTSB IAD70DID15Accident · No injuriesClosedPiper PA-28 · Capeville, VAMar 12, 1970 · N6568J · Substantial damageNTSB IAD70DID03Accident · No injuriesClosedPiper PA-28 · Chesapeake, VAJan 25, 1970 · N8177W · Substantial damageNTSB IAD70AI040Accident · No injuriesClosedMooney M20C · Manassas, VAJan 24, 1970 · N9339V · Substantial damageNTSB IAD70D0131Accident · No injuriesClosedPiper PA-28 · S Boston, VADec 26, 1969 · N9712J · Substantial damageNTSB IAD70F0072Accident · No injuriesClosedBrantly B-2 · Centerville, VAAug 29, 1969 · N2125U · DestroyedNTSB DIA69D0141Accident · No injuriesClosedPiper PA-28 · Charlottesvill, VAJan 25, 1969 · N9277J · Substantial damageNTSB DIA69D0072Accident · No injuriesClosedMooney M20C · Baileys Xroads, VAOct 2, 1968 · N6770U · Substantial damageNTSB DIA69F0055Accident · No injuriesClosedPiper PA-24 · Alexandria, VAAug 16, 1968 · N6171P · Substantial damageNTSB DIA68D0222Accident · No injuriesClosedMooney M21 · Culpepper, VAApr 28, 1968 · N9256M · Substantial damageNTSB DIA68D0215Accident · Minor injuriesClosedPiper PA-28 · Manassas, VAApr 18, 1968 · N5256L · Substantial damageNTSB DIA68F0205Accident · Minor injuriesClosedPiper PA-28 · Great Bridge, VAApr 2, 1968 · N8177W · Substantial damageNTSB DIA67D0074Accident · No injuriesClosedPiper PA-28 · Manassas, VAApr 6, 1967 · N7228W · Substantial damageNTSB DIA67F0033Accident · No injuriesClosedMooney M20C · Richmond, VAJan 21, 1967 · N639MA · Substantial damageNTSB NYC66F0588Accident · No injuriesClosedMooney M20C · Gordonsville, VAMar 24, 1966 · N6255U · Substantial damageNTSB NYC66F0271Accident · No injuriesClosedPiper PA-28 · Gloucester, VASep 18, 1965 · N7838W · Substantial damageNTSB NYC66F0162Accident · No injuriesClosedPiper PA-28 · Richmond, VAAug 24, 1965 · N7108W · Substantial damageNTSB NYC65F0215Accident · No injuriesClosedPiper PA-24 · Leesburg, VAMay 15, 1965 · N7374P · Substantial damageNTSB NYC65F0041Accident · No injuriesClosedPiper PA28 · Opewell, VAFeb 20, 1965 · N7461W · Substantial damageNTSB UNK65X0784Accident · No injuriesClosedGlobe GC-1B · White Sulpr Sp, VANov 22, 1964 · N78110 · DestroyedNTSB UNK64X2979Accident · No injuriesClosedPiper PA28 · Chantilly, VAJul 22, 1964 · N7705W · Substantial damageNTSB UNK64X1335Accident · No injuriesClosedMooney M20C · Gretna, VAApr 16, 1964 · N6751U · Substantial damageNTSB UNK64X0185Accident · Serious injuriesClosedMooney M20C · Head Waters, VAJan 8, 1964 · N6886U · Destroyed