NTSB investigations: Lycoming I0360 series, 1972
67 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 year(c.\"eventDate\") = 1972
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 year(c."eventDate") = 1972
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 DEN72DTC22Accident · Minor injuriesClosedPiper PA-28R · Gillette, WYNTSB LAX72DUJ82Accident · No injuriesClosedBeech A23-24 · St Johns, AZNTSB NYC72DFJ30Accident · No injuriesClosedPiper PA-28R · Olean, NYNTSB CHI72FEE59Accident · No injuriesClosedMooney M-20E · Northbrook, ILNTSB MIA72FKG77Accident · No injuriesClosedPiper PA-28 · Fairburn, GANTSB MIA72AM088Accident · Serious injuriesClosedCessna 310J · Cartersville, GANTSB OAK72DVG37Accident · No injuriesClosedPiper PA-28R · Napa, CANTSB NYC72FFJ28Accident · No injuriesClosedBeech A23-24 · Penn Yan, NYNTSB SEA72DTI13Accident · No injuriesClosedMooney M20E · Great Falls, MTNTSB MKC72FER38Accident · No injuriesClosedPiper PA-28R · Hopkins, MNNTSB OAK72DVM22Accident · No injuriesClosedMooney M21F · Salinas, CANTSB CHI72DEI31Accident · No injuriesClosedPiper PA-28R · Painesville, OHNTSB NYC72FLJ21Accident · No injuriesClosedMooney M20E · Gates, NCNTSB NYC72FGM28Accident · No injuriesClosedPiper PA-28R · Central City, PANTSB MKC72AK044Accident · No injuriesClosedPiper PA-28 · Fergus Falls, MNNTSB FTW72FRA31Accident · Minor injuriesClosedHughes 269C · Pasadena, TXNTSB LAX72FUM16Accident · No injuriesClosedHughes 269B · Mt.Laguna, CA