NTSB investigations: Lycoming 0-320 series, 1970
393 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\") = 1970
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") = 1970
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 OAK71DVG33Accident · No injuriesClosedPiper PA-28 · Vacaville, CANTSB NYC71FFD17Accident · No injuriesClosedPiper PA-28 · Norwood, MANTSB MKC71FCD30Accident · No injuriesClosedPiper PA-28 · Earlham, IANTSB FTW71FRA24Accident · No injuriesClosedPiper PA-18 · Conroe, TXNTSB NYC71FGM19Accident · No injuriesClosedBeech 23 · Washington, PANTSB MKC71FCQ22Accident · No injuriesClosedCessna 172K · El Dorado, KSNTSB MIA71FLD29Accident · Minor injuriesClosedCessna 172I · Daytona Beach, FLNTSB MIA71DLD28Accident · No injuriesClosedPiper PA-28 · Melbourne, FLNTSB CHI71DGD27Accident · No injuriesClosedPiper PA-28 · Shelby, OHNTSB NYC71FGM17Accident · Serious injuriesClosedPiper PA-28 · Washington, PANTSB NYC71FFA21Accident · No injuriesClosedPiper PA-22 · Duanesburg, NYNTSB IAD71FIJ09Accident · Minor injuriesClosedCessna 172I · Ronceverte, WVNTSB FTW71FRG36Accident · No injuriesClosedPiper PA-28 · Corpus Chrsti, TXNTSB NYC71DHD30Accident · No injuriesClosedPiper PA-23 · Bridgeton, NJNTSB LAX71AL022Accident · No injuriesClosedPiper PA-28 · Gila Bend, AZNTSB MIA71FKG45Accident · No injuriesClosedChampion 7GCAA · Chamblee, GANTSB NYC71DGM18Accident · Minor injuriesClosedCessna 172K · Russell, PANTSB CHI71FBQ20Accident · No injuriesClosedPitts SC · Decatur, ILNTSB LAX71DUJ32Accident · No injuriesClosedPiper PA-28 · Grnd Canyon, AZNTSB DEN71FQA18Accident · Minor injuriesClosedPiper PA-22 · Bloomfield, NMNTSB MIA71DKG44Accident · No injuriesClosedPiper PA-28 · St Simons Isle, GANTSB DEN71DXA12Accident · No injuriesClosedPiper PA-18 · Shell, WYNTSB DEN71DQG40Accident · No injuriesClosedPiper PA-22 · Clovis, NMNTSB SEA71DXM12Accident · No injuriesClosedCessna 177 · American Falls, IDNTSB MIA71DKJ22Accident · No injuriesClosedCessna 172K · Monroeville, ALNTSB MIA71AKJ20Accident · Minor injuriesClosedPiper PA-28 · Jasper, ALNTSB ANC71DAG31Accident · No injuriesClosedPiper PA-12 · Anchorage, AKNTSB OAK71DVM18Accident · No injuriesClosedPiper PA-18 · Bradley, CANTSB ANC71DAG32Accident · Minor injuriesClosedCessna 172K · Port Alswrth, AKNTSB NYC71DHJ11Accident · Serious injuriesClosedPiper PA-28 · Farmingdale, NYNTSB IAD71DID09Accident · Serious injuriesClosedChampion 7GCBC · Lynchburg, VANTSB CHI71FBA13Accident · No injuriesClosedPiper PA-28 · Seymour, INNTSB SEA71FWG21Accident · No injuriesClosedCessna 172K · Moses Lake, WANTSB LAX71DUJ25Accident · No injuriesClosedCessna 177 · Scottsdale, AZNTSB LAX71FUQ17Accident · No injuriesClosedPiper PA-22 · Lancaster, CANTSB NYC71FFJ12Accident · Minor injuriesClosedPiper PA-22 · Farmersville, NYNTSB MIA71FKJ18Accident · No injuriesClosedPiper PA-28 · Birmingham, ALNTSB CHI71FGA09Accident · No injuriesClosedCessna 172I · Harrison, OHNTSB MIA71FKQ14Accident · Minor injuriesClosedPiper PA-22 · Quitman, MSNTSB ANC71DAG29Accident · No injuriesClosedPiper PA-18 · Ugashik, AKNTSB MIA71AM028Accident · 2 fatalClosedBeech 23 · Gates, TNNTSB FTW71FPD20Accident · No injuriesClosedPiper PA-28 · Saginaw, TXNTSB IAD71DKM14Accident · No injuriesClosedPiper PA-28 · Salisbury, NCNTSB FTW71FPG21Accident · No injuriesClosedPiper PA-22 · N Little Rock, ARNTSB MKC71AK015Accident · 2 fatalClosedCessna 172I · Vichy, MONTSB DEN71FQA11Accident · No injuriesClosedPiper PA-28 · Albuquerque, NMNTSB DEN71DQA12Accident · No injuriesClosedPiper PA-28 · Tecolotito, NMNTSB NYC71DFJ11Accident · No injuriesClosedPiper PA-28 · Batavia, NYNTSB ANC71DAG44Accident · No injuriesClosedCessna 150J · Talkeetna, AKNTSB CHI71FGD16Accident · Minor injuriesClosedPiper PA-28 · Willoughby, OH