NTSB investigations: Lycoming I0360 series, OH
76 cases on aircraft whose registry engine model is Lycoming I0360 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 ('41515'))
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 ('41515'))
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 CHI78FEK20Accident · Minor injuriesClosedHughes 269B · Mechanicsburg, OHNTSB CHI78FEG04Accident · No injuriesClosedPiper PA-28R · Miamisburg, OHNTSB CHI77FEG22Accident · Serious injuriesClosedPiper PA-28 · Piqua, OHNTSB CHI77FEK15Accident · No injuriesClosedPiper PA-28 · Heath, OHNTSB CHI77FEK14Accident · No injuriesClosedBeech A23-24 · Findley, OHNTSB CHI77FEI13Accident · Minor injuriesClosedHughes 269-C · Cleveland, OHNTSB CHI76FEK31Accident · No injuriesClosedMooney M20E · Urbana, OHNTSB CHI76FEG06Accident · Serious injuriesClosedPitts S2A · Harrison, OHNTSB CHI76FEK07Accident · No injuriesClosedMooney M20E · Van Wert, OHNTSB CHI76FEG04Accident · No injuriesClosedLake LA-4 · Batavia, OHNTSB CHI74FEK23Accident · No injuriesClosedPiper PA-28R · Marion, OHNTSB CHI74DEK21Accident · No injuriesClosedEnstrom F28A · Marion, OHNTSB CHI73FEG20Accident · No injuriesClosedBeech A24R · Piqua, OHNTSB CHI72FEI38Accident · Minor injuriesClosedPiper PA-28R · Elyria, OHNTSB CHI72DEI31Accident · No injuriesClosedPiper PA-28R · Painesville, OHNTSB CHI72FEK07Accident · No injuriesClosedPiper PA-28R · Columbus, OHNTSB CHI72DEG23Accident · No injuriesClosedBeech A24R · Jamestown, OHNTSB CHI71DEI54Accident · No injuriesClosedBeech A23-24 · Ravenna, OHNTSB CHI71FGA12Accident · No injuriesClosedMooney M20E · Cincinnati, OHNTSB CHI71DGD45Accident · No injuriesClosedPiper PA-28R · Painsville, OHNTSB CHI69D0337Accident · No injuriesClosedBeech A-24 · Toledo, OHNTSB CHI69F0287Accident · No injuriesClosedPiper PA-28R · Youngstown, OHNTSB CHI68A0077Accident · Serious injuriesClosedHughes 269B · Sinking Spgs, OHNTSB CHI67D0274Accident · No injuriesClosedMooney M21 · Cleveland, OHNTSB CHI67F0064Accident · No injuriesClosedMooney M20E · Saint Paris, OHNTSB CHI66D0050Accident · No injuriesClosedPiper PA-23 · Cleveland, OH