NTSB investigations: Lycoming O&VO-360 series, 1968
152 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\") = 1968
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") = 1968
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 MKC69F0145Accident · No injuriesClosedMooney M20C · Park River, NDNTSB MKC69D0220Accident · Minor injuriesClosedMooney M20C · Gainesville, MONTSB NYC69F0067Accident · Minor injuriesClosedPiper PA-28 · Honesdale, PANTSB FTW69D0107Accident · No injuriesClosedColonial C-2 · Kemp, TXNTSB CHI69D0173Accident · No injuriesClosedPiper PA-28 · Northbrook, ILNTSB NYC69F0103Accident · Minor injuriesClosedPiper PA-24 · Thomasville, PANTSB MIA69D0147Accident · No injuriesClosedPiper PA-28 · Summerton, SCNTSB OAK69D0089Accident · Minor injuriesClosedPiper PA-28 · Del Rey, CANTSB NYC69A0014Accident · No injuriesClosedPiper PA-28 · East Hampton, CTNTSB CHI69F0149Accident · No injuriesClosedMooney M20C · Connersville, INNTSB CHI69F0231Accident · Minor injuriesClosedDyke Delta JD-2 · Rockford, ILNTSB MKC69D0064Accident · No injuriesClosedMooney M20D · Chamberlain, SDNTSB CHI69F0110Accident · No injuriesClosedPiper PA-28 · Hebron, KYNTSB NYC69F0119Accident · No injuriesClosedCessna 170B · Lexington, NYNTSB LAX69F0086Accident · Minor injuriesClosedHughes 269A · Marina Del Ray, CANTSB SEA69F0047Accident · No injuriesClosedPiper PA-24 · Spokane, WANTSB MKC69F0050Accident · No injuriesClosedPiper PA-28 · Schuyler, NENTSB MIA69D0132Accident · No injuriesClosedPiper PA-28 · Chipley, FLNTSB CHI69D0114Accident · No injuriesClosedPiper PA-24 · Trout Lake, MINTSB FTW69F0104Accident · Minor injuriesClosedMooney M20C · Lakeview, ARNTSB NYC69D0081Accident · No injuriesClosedPiper PA-28 · Union, MENTSB FTW69F0095Accident · Minor injuriesClosedCessna 172 · Ainesville, TXNTSB OAK69D0106Accident · No injuriesClosedCessna 177 · Black Springs, CANTSB LAX69F0129Accident · Serious injuriesClosedMooney M20C · Santa Susana, CANTSB DEN69F0045Accident · Serious injuriesClosedPiper PA-28 · Ordway, CONTSB SEA69D0026Accident · No injuriesClosedPiper PA-28 · Chinook, MTNTSB MKC69D0107Accident · No injuriesClosedPiper PA-28 · Hazen, NDNTSB DEN69D0035Accident · No injuriesClosedMooney M20D · Ogden, UTNTSB NYC69F0076Accident · No injuriesClosedBrantly B-2B · Monroeville, PANTSB NYC69F0039Accident · No injuriesClosedPiper PA-28 · Butler, PANTSB CHI69F0051Accident · No injuriesClosedMooney M20D · Boscobel, WINTSB DIA69A0001Accident · 1 fatalClosedPiper PA-28 · Chase, MDNTSB DEN69D0042Accident · Minor injuriesClosedPiper PA-28 · Jackson, WYNTSB LAX69F0017Accident · No injuriesClosedMooney M21 · Yorba Linda, CANTSB SEA69F0024Accident · No injuriesClosedHughes 269A · Medford, ORNTSB FTW69D0256Accident · No injuriesClosedPiper PA-28 · Granbury, TXNTSB OAK68A0074Accident · 5 fatalClosedMdoney M20A · Indian Sprngs, NVNTSB CHI69F0032Accident · No injuriesClosedPiper PA-28 · Rantoul, ILNTSB SEA69D0028Accident · No injuriesClosedMooney M20C · Jefferson, ORNTSB CHI68D0786Accident · No injuriesClosedPiper PA-28 · Milan, MINTSB SEA69F0025Accident · No injuriesClosedBrantly B-2 · Albany, ORNTSB CHI68A0105Accident · No injuriesClosedPiper PA-28 · Michigan City, INNTSB DEN69F0008Accident · No injuriesClosedPiper PA-25 · Montrose, CONTSB NYC69D0014Accident · No injuriesClosedGlobe GC-1B · Farmingdale, NYNTSB MIA68A0102Accident · 2 fatalClosedMooney M20A · Orlando, FLNTSB FTW69F0023Accident · No injuriesClosedMooney M20C · Austin, TXNTSB CHI69F0009Accident · No injuriesClosedPiper PA-28 · Plymouth, MINTSB MKC69D0029Accident · No injuriesClosedMooney M20C · Grand Rapids, MNNTSB OAK69O0013Accident · No injuriesClosedPiper PA-28 · Mexicali, MexicoNTSB OAK68D0382Accident · No injuriesClosedPiper PA-28 · Chico, CA