NTSB investigations: Lycoming 0-540 series, 1971
118 cases on aircraft whose registry engine model is Lycoming 0-540 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\") = 1971
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41532'))
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") = 1971
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41532'))
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 DEN72FQA06Accident · No injuriesClosedPiper PA-32 · Albuquerque, NMNTSB SEA72FTA02Accident · No injuriesClosedCallair A-9 · Laurel, MTNTSB LAX72DVA03Accident · Minor injuriesClosedCallair A-9 · Shafter, CANTSB FTW72DQD04Accident · No injuriesClosedPiper PA-24 · Sierra Blanca, TXNTSB OAK72FVW01Accident · No injuriesClosedPiper PA-24 · Beatty, NVNTSB FTW72FQG05Accident · No injuriesClosedPiper PA-25 · Plainview, TXNTSB DEN72FQA02Accident · No injuriesClosedPiper PA-23 · Albuquerque, NMNTSB FTW72DQG01Accident · No injuriesClosedPiper PA-25 · Springlake, TXNTSB SEA71FTA23Accident · No injuriesClosedCallair A-9 · Opheim, MTNTSB SEA71DYA38Accident · No injuriesClosedPiper PA-25 · Blackfoot, IDNTSB OAK71DVA86Accident · No injuriesClosedPiper PA-24 · Visalia, CANTSB MKC71DCQ44Accident · No injuriesClosedCallair A-9 · Ulysses, KSNTSB FTW71DPG64Accident · No injuriesClosedPiper PA-25 · Tuckerman, ARNTSB DEN71DTE12Accident · No injuriesClosedPiper PA-25 · Breen, CONTSB DEN71FTE10Accident · Serious injuriesClosedCallair A-9 · Firestone, CONTSB MKC71DTG28Accident · Serious injuriesClosedPiper PA-25 · Devils Lake, NDNTSB CHI71DEP52Accident · No injuriesClosedPiper PA-25 · Random Lake, WINTSB FTW71FRH31Accident · No injuriesClosedPiper PA-24 · Mcallen, TXNTSB ANC71AA063Accident · No injuriesClosedPiper PA-32 · Pilot Sta, AKNTSB SEA71DYG55Accident · No injuriesClosedPiper PA-25 · Lind, WANTSB IAD71DLJ26Accident · No injuriesClosedCallair A-9 · Aurora, NCNTSB CHI71FLQ24Accident · No injuriesClosedAero Comdr A-9 · Morganfield, KYNTSB MKC71FCJ62Accident · No injuriesClosedAero Comdr A-9 · St Libory, NENTSB OAK71FVA71Accident · No injuriesClosedPiper PA-32 · Merced, CANTSB LAX71FUG83Accident · No injuriesClosedPiper PA-24 · Chino, CANTSB MKC71DCQ39Accident · No injuriesClosedPiper PA-25 · Yates Center, KSNTSB IAD71AI051Accident · No injuriesClosedPiper PA-32 · Buckhannon, WVNTSB MIA71RM104Accident · No injuriesClosedPiper PA-32 · Santa Domngo, DRNTSB OAK71FVW31Accident · No injuriesClosedPiper PA-24 · Lathrop Wells, NVNTSB MIA71FKT57Accident · Serious injuriesClosedPiper PA-25 · Miami, FLNTSB IAD71DLJ21Accident · No injuriesClosedPiper PA-24 · Hatteras, NCNTSB MKC71DCA33Accident · No injuriesClosedPiper PA-25 · Washington, MONTSB OAK71DVA69Accident · No injuriesClosedPiper PA-25 · Tulare, CANTSB MIA71DKJ53Accident · No injuriesClosedPiper PA-25 · Mccullough, ALNTSB NYC71FNA46Accident · No injuriesClosedPiper PA-23 · Norwood, MANTSB MKC71DCD72Accident · No injuriesClosedPiper PA-32 · Kingsley, IANTSB LAX71DUJ44Accident · No injuriesClosedPiper PA-24 · Yuma, AZNTSB MKC71FCJ59Accident · Minor injuriesClosedCallair A9 · Gibbon, NENTSB FTW71DQG65Accident · No injuriesClosedPiper PA-25 · Spearman, TXNTSB DEN71DXA20Accident · No injuriesClosedPiper PA-25 · Casper, WYNTSB NYC71FFD41Accident · No injuriesClosedPiper PA-24 · Lincoln, RINTSB CHI71FBJ64Accident · No injuriesClosedPiper PA-28 · Alpena, MINTSB ANC71AA047Accident · No injuriesClosedHelio Acft H-250 · Kobuk, AKNTSB CHI71FGG29Accident · No injuriesClosedPiper PA-28 · Columbus, OHNTSB OAK71FXQ31Accident · No injuriesClosedPiper PA-24 · Reno, NVNTSB MKC71DCG47Accident · No injuriesClosedPiper PA-24 · Olathe, KSNTSB MIA71AM081Accident · No injuriesClosedPiper PA-32 · Vieques Island, PRNTSB CHI71FGA18Accident · No injuriesClosedPiper PA-28 · Middletown, OHNTSB FTW71DRF29Accident · No injuriesClosedPiper PA-32 · Georgetown, LANTSB SEA71DWA31Accident · No injuriesClosedPiper PA-32 · Condon, OR