NTSB investigations: Lycoming O&VO-360 series, 1979
114 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 year(c.\"eventDate\") = 1979
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 year(c."eventDate") = 1979
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 LAX79DUQ43Accident · No injuriesClosedBellanca 8GCBC · Rosamond, CANTSB CHI79DEI36Accident · No injuriesClosedPiper PA-28 · Painesville, OHNTSB FTW79FPG70Accident · No injuriesClosedMooney M20C · Conway, ARNTSB NYC79FHJ27Accident · Minor injuriesClosedBeech C23 · Mattituck, NYNTSB CHI79FEG22Accident · Serious injuriesClosedBeech B23 · Waynesville, OHNTSB CHI79FA061Accident · 1 fatalClosedMooney M20C · Brocton, ILNTSB CHI79DEV28Accident · No injuriesClosedBrantly B-2B · Flanagan, ILNTSB OAK79DVG64Accident · No injuriesClosedMooney M20C · Montague, CANTSB UNK79X0112Accident · Minor injuriesClosedGrumman AA-5B · Polo, ILNTSB IAD79FA060Accident · No injuriesClosedMooney M20G · Bluefield, WVNTSB LAX79DUJ93Accident · Serious injuriesClosedCessna 177 · Bullhead City, AZNTSB NYC79DNC34Accident · No injuriesClosedPiper PA-28 · Vinalhaven, VTNTSB MKC79DCG53Accident · No injuriesClosedMooney M20C · Ava, MONTSB OAK79DVG59Accident · No injuriesClosedBeech C23 · Grass Valley, CANTSB MKC79DCD23Accident · No injuriesClosedCessna 177 · Oelwein, IANTSB IAD79FIG08Accident · No injuriesClosedCessna 177 · Westminster, MDNTSB DEN79FQA32Accident · No injuriesClosedBeech C23 · Albuquerque, NMNTSB LAX79DUJ85Accident · No injuriesClosedCessna 177B · Phoenix, AZNTSB SEA79DYM40Accident · No injuriesClosedBellanca 8GCBC · The Dalles, ORNTSB MKC79FER48Accident · Minor injuriesClosedCessna 177 · Longville, MNNTSB FTW79DPD22Accident · No injuriesClosedPitts S-1 · Roanoke, TXNTSB ANC79DA057Incident · Minor injuriesClosedPiper PA-28 · Ophir, AKNTSB MKC79FCA16Accident · Serious injuriesClosedGrumman AA-5B · Owensville, MONTSB MIA79FA093Accident · 1 fatalClosedBeech 95 · Leesburg, FLNTSB NYC79FHJ19Incident · No injuriesClosedCessna 177B · Amityville, NYNTSB OAK79FVA36Accident · Minor injuriesClosedBeech C-23 · Fresno, CANTSB OAK79DVA35Accident · No injuriesClosedBeech C23 · Fresno, CANTSB SEA79DYE24Accident · No injuriesClosedCessna 177B · Mercer Island, WANTSB DEN79FTM18Accident · No injuriesClosedMooney M20C · Bullfrog, UTNTSB DEN79DTM16Accident · No injuriesClosedPiper PA-28 · Green River, UTNTSB LAX79DUG39Accident · No injuriesClosedPiper PA-28 · El Monte, CANTSB FTW79FRD29Accident · No injuriesClosedPiper PA-28 · Patterson, LANTSB MIA79FKG41Accident · 1 fatalClosedPitts Spec S-1 · Warner Robins, GANTSB SEA79FYK10Accident · Minor injuriesClosedPiper PA-24 · Klamath Falls, ORNTSB NYC79FA045Accident · 2 fatalClosedBeech C-23 · Saltsburg, PANTSB CHI79DEX29Accident · No injuriesClosedPiper PA-28 · Hagertown, INNTSB LAX79FVA31Accident · No injuriesClosedPiper PA-44 · Kernville, CANTSB MIA79FKJ36Accident · No injuriesClosedBeech C-23 · Birmingham, ALNTSB MKC79FCG41Accident · Serious injuriesClosedPiper PA-25 · Camdenton, MONTSB SEA79FYM30Accident · Serious injuriesClosedPiper PA-28 · Sandy, ORNTSB OAK79FA027Accident · Minor injuriesClosedPiper PA-22 · King City, CANTSB LAX79DUJ70Accident · No injuriesClosedBeech C-23 · Phoenix, AZNTSB NYC79FA040Accident · 1 fatalClosedLake LA-4 · Jonesboro, MENTSB CHI79FEX21Accident · Serious injuriesClosedBeech C-23 · Fishers, INNTSB CHI79FA045Accident · 2 fatalClosedPiper PA-28 · Veedersburg, INNTSB MIA79DLD58Accident · No injuriesClosedPiper PA-44 · Useppa Island, FLNTSB DEN79FQA23Accident · Serious injuriesClosedPiper PA-28 · Gallup, NMNTSB FTW79DRA13Accident · No injuriesClosedMooney M20A · Tomball, TXNTSB MIA79FKG25Accident · No injuriesClosedPiper PA-24 · Hawkinsville, GANTSB MIA79FKG24Accident · No injuriesClosedMooney M20C · Peachtree City, GA