NTSB investigations: Lycoming 0-320 series, 1968
424 cases on aircraft whose registry engine model is Lycoming 0-320 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 ('41508'))
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 ('41508'))
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 MIA69F0271Accident · No injuriesClosedBeech A23-19 · West Columbia, SCNTSB FTW69D0255Accident · No injuriesClosedPiper PA-18 · El Paso, TXNTSB MIA69F0296Accident · No injuriesClosedCessna 177 · Spartanburg, SCNTSB MIA69D0206Accident · No injuriesClosedPiper PA-28 · Trenton, TNNTSB LAX69D0153Accident · No injuriesClosedCessna 177 · Santa Barbara, CANTSB CHI69D0284Accident · No injuriesClosedBeech A23-19 · Roselle, ILNTSB NYC69D0231Accident · No injuriesClosedPiper PA-28 · Montpelier, VTNTSB OAK69F0156Accident · 2 fatalClosedPiper PA-28 · Mt View, HINTSB ANC69D0071Accident · Minor injuriesClosedPiper PA-14 · Anchorage, AKNTSB FTW69F0260Accident · No injuriesClosedPiper PA-25 · Woodrow, TXNTSB FTW69D0261Accident · No injuriesClosedPiper PA-22 · Perryton, TXNTSB CHI69D0314Accident · No injuriesClosedCessna 177 · So.Branch, MINTSB MKC69D0217Accident · No injuriesClosedPiper PA-22 · Salina, KSNTSB NYC69D0225Accident · No injuriesClosedPiper PA-28 · Rio Grande, NJNTSB FTW69F0219Accident · No injuriesClosedBeech A23 · Groom, TXNTSB CHI69D0268Accident · No injuriesClosedPiper PA-22 · Salem, MINTSB ANC69D0075Accident · No injuriesClosedPiper PA-18 · Anchorage, AKNTSB DEN69D0106Accident · No injuriesClosedPiper PA-28 · Rangely, CONTSB DEN69D0134Accident · No injuriesClosedPiper PA-18 · Gillette, WYNTSB DIA69F0085Accident · No injuriesClosedPiper PA-22 · Cumberland, MDNTSB CHI69F0299Accident · No injuriesClosedCessna 177 · Xenia, OHNTSB ANC69F0060Accident · No injuriesClosedPiper PA-14 · Talkeetna, AKNTSB CHI69D0308Accident · No injuriesClosedPiper PA-28 · Albion, WINTSB ANC69F0068Accident · Minor injuriesClosedPiper PA-22 · Mcgrath, AKNTSB NYC69A0037Accident · No injuriesClosedPiper PA-28 · Lincoln, RINTSB DEN69F0117Accident · Serious injuriesClosedPiper PA-28 · Grnd Jnction, CONTSB MIA69D0176Accident · No injuriesClosedPiper PA-23 · Opa Locka, FLNTSB DEN69A0012Accident · 1 fatalClosedInterstate S-1A · Bitter Creek, WYNTSB CHI69F0327Accident · Minor injuriesClosedPiper PA-28 · Dowagiac, MINTSB ANC69D0074Accident · No injuriesClosedPiper PA-18 · Montague Isl, AKNTSB OAK69D0135Accident · No injuriesClosedBeech A23-19 · Concord, CANTSB FTW69D0186Accident · Minor injuriesClosedPiper PA-28 · Stigler, OKNTSB OAK69D0116Accident · No injuriesClosedPiper PA-28 · Battle Mtn., NVNTSB NYC69F0169Accident · No injuriesClosedCessna 177 · Kutztown, PANTSB MKC69D0176Accident · No injuriesClosedCessna 172 · Walker, MNNTSB FTW69F0191Accident · 1 fatalClosedPiper PA-25 · Presidio, TXNTSB MKC69D0209Accident · No injuriesClosedCessna 177 · Milford, NENTSB CHI69F0200Accident · No injuriesClosedPiper PA-28 · Cincinnati, OHNTSB MKC69D0170Accident · No injuriesClosedCessna 177 · Eagle Grove, IANTSB MIA69D0145Accident · No injuriesClosedPiper PA-28 · West Palm Bch, FLNTSB FTW69F0183Accident · No injuriesClosedPiper PA-28 · Esperanza, TXNTSB MIA69F0190Accident · No injuriesClosedBeech 23 · Hartsville, SCNTSB CHI69F0207Accident · No injuriesClosedCessna 177 · Detroit, MINTSB MKC69F0227Accident · No injuriesClosedBeech B23 · Pequot Lakes, MNNTSB MKC69D0195Accident · No injuriesClosedCessna 177 · Waukon, IANTSB MIA69F0319Accident · Minor injuriesClosedPiper PA-28 · Blackville, SCNTSB MIA69D0289Accident · No injuriesClosedPiper PA-28 · Hernando, FLNTSB CHI69F0220Accident · No injuriesClosedPiper PA-22 · Mecosta, MINTSB SEA69F0109Accident · No injuriesClosedPiper PA-14 · Silverdale, WANTSB CHI69D0286Accident · No injuriesClosedPiper PA-28 · No.Kingsvlle, OH