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.
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" 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 ATL80F1A06Accident · Serious injuriesClosedPiper PA-28 · Front Royal, VANTSB IAD80DID04Accident · No injuriesClosedPiper PA-28 · Lynchburg, VANTSB IAD79FID29Accident · Minor injuriesClosedPiper PA-28 · Urbanna, VANTSB IAD79FID27Accident · No injuriesClosedStarduster SA300 · Weirwood, VANTSB IAD79FID07Accident · No injuriesClosedBeech C23 · Chesterfield, VANTSB IAD78FA061Accident · 1 fatalClosedBeech C23 · The Plains, VANTSB IAD78FIA01Accident · Minor injuriesClosedCessna 177 · Nokesville, VANTSB IAD78DIJ01Accident · Serious injuriesClosedPiper PA-28 · Abingdon, VANTSB IAD77DID14Accident · No injuriesClosedBeech C23 · Portsmouth, VANTSB IAD76FID19Accident · No injuriesClosedAir & Space 18A · Collinsville, VANTSB IAD76FID10Accident · No injuriesClosedPiper PA-24 · South Hill, VANTSB IAD75AI011Accident · No injuriesClosedBeech C23 · Norfolk, VANTSB IAD74FIA15Accident · Minor injuriesClosedCessna 177B · Winchester, VANTSB IAD73AI011Accident · 2 fatalClosedPiper PA-24 · Orange, VANTSB NYC72FIA11Accident · Minor injuriesClosedPiper PA-28 · Front Royal, VANTSB NYC72DIA08Accident · No injuriesClosedPiper PA-28 · Culpeper, VANTSB IAD71AI027Accident · No injuriesClosedMooney M20C · Lynchburg, VANTSB IAD70FIA08Accident · No injuriesClosedPiper PA-28 · Baileys X Road, VANTSB IAD70DID15Accident · No injuriesClosedPiper PA-28 · Capeville, VANTSB IAD70DID03Accident · No injuriesClosedPiper PA-28 · Chesapeake, VANTSB IAD70AI040Accident · No injuriesClosedMooney M20C · Manassas, VANTSB IAD70D0131Accident · No injuriesClosedPiper PA-28 · S Boston, VANTSB IAD70F0072Accident · No injuriesClosedBrantly B-2 · Centerville, VANTSB DIA69D0141Accident · No injuriesClosedPiper PA-28 · Charlottesvill, VANTSB DIA69D0072Accident · No injuriesClosedMooney M20C · Baileys Xroads, VANTSB DIA69F0055Accident · No injuriesClosedPiper PA-24 · Alexandria, VANTSB DIA68D0222Accident · No injuriesClosedMooney M21 · Culpepper, VANTSB DIA68D0215Accident · Minor injuriesClosedPiper PA-28 · Manassas, VANTSB DIA68F0205Accident · Minor injuriesClosedPiper PA-28 · Great Bridge, VANTSB DIA67D0074Accident · No injuriesClosedPiper PA-28 · Manassas, VANTSB DIA67F0033Accident · No injuriesClosedMooney M20C · Richmond, VANTSB NYC66F0588Accident · No injuriesClosedMooney M20C · Gordonsville, VANTSB NYC66F0271Accident · No injuriesClosedPiper PA-28 · Gloucester, VANTSB NYC66F0162Accident · No injuriesClosedPiper PA-28 · Richmond, VANTSB NYC65F0215Accident · No injuriesClosedPiper PA-24 · Leesburg, VANTSB NYC65F0041Accident · No injuriesClosedPiper PA28 · Opewell, VANTSB UNK65X0784Accident · No injuriesClosedGlobe GC-1B · White Sulpr Sp, VANTSB UNK64X2979Accident · No injuriesClosedPiper PA28 · Chantilly, VANTSB UNK64X1335Accident · No injuriesClosedMooney M20C · Gretna, VANTSB UNK64X0185Accident · Serious injuriesClosedMooney M20C · Head Waters, VA