NTSB investigations: Lycoming 0-540 series, OH
82 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 c.\"eventStateOrRegion\" = 'OH' AND c.\"eventCountry\" = 'USA'
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 c."eventStateOrRegion" = 'OH' AND c."eventCountry" = 'USA'
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 CHI74FEI26Accident · Minor injuriesClosedPiper PA-32 · Cleveland, OHNTSB CHI74FEI16Accident · No injuriesClosedPiper PA-24 · Ashland, OHNTSB CHI74DEG04Accident · No injuriesClosedPiper PA-32 · Vandalia, OHNTSB CHI73FEK03Accident · No injuriesClosedPiper PA-24 · Lima, OHNTSB CHI71FGG29Accident · No injuriesClosedPiper PA-28 · Columbus, OHNTSB CHI71FGA18Accident · No injuriesClosedPiper PA-28 · Middletown, OHNTSB CHI71DGG11Accident · No injuriesClosedPiper PA-28 · Columbus Grv, OHNTSB CHI71FGG07Accident · No injuriesClosedPiper PA-32 · Findlay, OHNTSB CHI71FGA02Accident · No injuriesClosedPiper PA-24 · Chilo, OHNTSB CHI70D0381Accident · No injuriesClosedPiper PA-24 · Cleveland, OHNTSB CHI69F0623Accident · No injuriesClosedPiper PA-24 · Napoleon, OHNTSB CHI69A0019Accident · 1 fatalClosedPiper PA-32 · Brunswick, OHNTSB CHI69D0204Accident · Minor injuriesClosedPiper PA-28 · Tiffin, OHNTSB CHI69D0098Accident · No injuriesClosedPiper PA-24 · Port Clinton, OHNTSB CHI69D0057Accident · No injuriesClosedPiper PA-23 · Lorain, OHNTSB CHI69D0001Accident · No injuriesClosedPiper PA-24 · Bowlng Green, OHNTSB CHI68F0610Accident · No injuriesClosedPiper PA-23 · Middletown, OHNTSB CHI68D0613Accident · No injuriesClosedPiper PA-32 · Put-In-Bay, OHNTSB CHI68F0571Accident · No injuriesClosedPiper PA-28 · Bluffton, OHNTSB CHI68D0292Accident · No injuriesClosedPiper PA-24 · E.Rochester, OHNTSB FTW68F0119Accident · No injuriesClosedPiper PA-24 · Guymon, OHNTSB CHI68D0211Accident · No injuriesClosedPiper PA-32 · North Benton, OHNTSB CHI68F0046Accident · No injuriesClosedPiper PA-24 · Xenia, OHNTSB CHI67D0156Accident · No injuriesClosedPiper PA-24 · Sugar Creek, OHNTSB CHI67D0053Accident · No injuriesClosedPiper PA-24 · Put-In-Bay, OHNTSB CHI66F0632Accident · No injuriesClosedPiper PA-24 · Johnstown, OHNTSB CHI66F0624Accident · No injuriesClosedPiper PA-24 · Hamilton, OHNTSB CHI66F0554Accident · No injuriesClosedPiper PA-24 · Granville, OHNTSB CHI66D0051Accident · No injuriesClosedPiper PA-23 · Newark, OHNTSB CHI66D0006Accident · No injuriesClosedPiper PA-24 · Columbus, OHNTSB UNK64X4176Accident · No injuriesClosedPeper PA24 · Wooster, OHNTSB UNK64X3211Accident · Minor injuriesClosedPiper PA28 · Sabina, OH