NTSB investigations: Lycoming 0-540 series, 1979
92 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\") = 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 ('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") = 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 ('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 SEA79FYM45Accident · No injuriesClosedPiper PA-24 · Salem, ORNTSB SEA79FYP31Accident · No injuriesClosedHiller Acft UH-12E · Quincy, WANTSB MIA79FKJ46Accident · No injuriesClosedPiper PA-25 · Opp, ALNTSB LAX79DUJ88Accident · No injuriesClosedPiper PA-28 · Douglas, AZNTSB MIA79DKT74Accident · Minor injuriesClosedPiper PA-28 · Miami, FLNTSB IAD79DLT05Accident · No injuriesClosedPiper PA-25 · Covington, TNNTSB MIA79FKG49Accident · 1 fatalClosedPiper PA-25 · Wrightsville, GANTSB DEN79DTE43Accident · No injuriesClosedPiper PA-25 · Eads, CONTSB FTW79DPG52Accident · No injuriesClosedPiper PA-28 · Benton, ARNTSB SEA79FYK15Accident · Serious injuriesClosedPiper PA-25 · Burns, ORNTSB IAD79FIG07Accident · No injuriesClosedPiper PA-22 · College Park, MDNTSB NYC79DFJ20Accident · Minor injuriesClosedPiper PA-25 · Cohocton, NYNTSB FTW79DPD20Accident · No injuriesClosedPiper PA-25 · Anson, TXNTSB FTW79DPJ16Accident · No injuriesClosedPiper PA-25 · Sharon, OKNTSB FTW79FPA16Accident · Serious injuriesClosedPiper PA-25 · Frisco, TXNTSB IAD79DLQ16Accident · Serious injuriesClosedMaule M-5 · Greenville, KYNTSB OAK79DVW13Accident · No injuriesClosedPiper PA-32 · Furnace Creek, CANTSB SEA79FYP15Accident · 1 fatalClosedCallair A-9 · Dayton, WANTSB MKC79FCQ20Accident · 1 fatalClosedPiper PA-25 · Mayday, KSNTSB DEN79DQA27Accident · No injuriesClosedCessna 182RG · Chama, NMNTSB CHI79FEE53Accident · No injuriesClosedPiper PA-28 · Cherry, ILNTSB IAD79FIJ05Accident · No injuriesClosedMaule M5-235 · Daybrook, WVNTSB SEA79DTI13Accident · Serious injuriesClosedPiper PA-24 · Sula, MTNTSB LAX79DVA29Accident · Minor injuriesClosedPiper PA-28 · Avenal, CANTSB NYC79FA038Accident · Serious injuriesClosedPiper PA-24 · Smithville, NJNTSB SEA79DYM27Accident · No injuriesClosedMaule M235C · Lord Flat, ORNTSB OAK79DVD21Accident · No injuriesClosedCessna 182RG · Stockton, CANTSB DEN79FQA22Accident · No injuriesClosedPiper PA-24 · Albuquerque, NMNTSB LAX79FA035Accident · 2 fatalClosedPiper PA-24 · Taft, CANTSB CHI79FA035Accident · 2 fatalClosedPiper PA-28 · Park Forrest, ILNTSB CHI79DEE48Accident · No injuriesClosedCessna 182RG · Crystal Lake, ILNTSB IAD79FKW07Accident · No injuriesClosedPiper PA-25 · Sparta, TNNTSB OAK79FVG19Accident · No injuriesClosedPiper PA-28 · Galt, CANTSB LAX79DUJ52Accident · No injuriesClosedPiper PA-25 · Maricopa, AZNTSB DEN79FTE24Accident · Minor injuriesClosedPiper PA-24 · Silver Cliff, CONTSB MKC79DCQ13Accident · No injuriesClosedCessna R-182 · Greenburg, KSNTSB MIA79FLD36Accident · Minor injuriesClosedPiper PA-32 · Wimauma, FLNTSB CHI79FEP24Accident · No injuriesClosedPiper PA-32 · Milwaukee, WINTSB MIA79DKT41Accident · No injuriesClosedPiper PA-25 · Miami, FLNTSB FTW79FQG15Accident · No injuriesClosedPiper PA-24 · Amarillo, TXNTSB CHI79FEM08Accident · No injuriesClosedPiper PA-23 · Muskegon Hgts, MINTSB MIA79FLA14Accident · Minor injuriesClosedPiper PA-32 · Cross City, FL