NTSB investigations: Lycoming I0360 series, CO
88 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\" = 'CO' 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" = 'CO' 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 DEN80FTE35Accident · No injuriesClosedPiper PA-28R · Denver, CONTSB DEN79FA032Accident · 3 fatalClosedMooney M20F · Crestone, CONTSB DEN79FTE09Accident · No injuriesClosedPiper PA-28R · Ft Collins, CONTSB DEN79FTE08Accident · No injuriesClosedPiper PA28R · Englewood, CONTSB DEN78FTE94Accident · No injuriesClosedHughes 269A · Crook, CONTSB DEN78FTE63Accident · Minor injuriesClosedBeech B24R · Co.Springs, CONTSB MKC77FCQ57Accident · No injuriesClosedMooney M2OF · Holly, CONTSB DEN77DTE56Accident · Minor injuriesClosedMooney M20F · Fredrick, CONTSB DEN77FTE28Accident · Serious injuriesClosedHughes 269B · Erie, CONTSB DEN77FTE29Accident · Minor injuriesClosedPiper PA-28 · Englewood, CONTSB DEN77FTE08Accident · No injuriesClosedPiper PA-28R · Boulder, CONTSB DEN75FTE36Accident · No injuriesClosedPiper PA-28R · Longmont, CONTSB DEN74FTE91Accident · No injuriesClosedAero Comdr 112A · Loveland, CONTSB DEN74FTE58Accident · No injuriesClosedPiper PA-28R · Pueblo, CONTSB DEN74DTE41Accident · No injuriesClosedPiper PA-28R · Denver, CONTSB DEN74DTE13Accident · No injuriesClosedMooney M20F · Meeker, CONTSB DEN73DTE83Accident · No injuriesClosedPiper PA-28R · Cripple Crk, CONTSB DEN73FTE55Accident · No injuriesClosedMooney M20E · Greenwd Vill, CONTSB DEN72FTE70Accident · No injuriesClosedHughes 269B · Fort Collins, CONTSB DEN72DTE68Accident · Minor injuriesClosedPiper PA-28R · Alamosa, CONTSB DEN71FXD40Accident · No injuriesClosedMooney M20F · Aurora, CONTSB DEN70F0092Accident · No injuriesClosedBeech 23 · Aspen, CONTSB DEN69D0224Accident · No injuriesClosedMooney M20E · Woodrow, CONTSB DEN69D0115Accident · Serious injuriesClosedPiper PA-28 · Rangely, CONTSB DEN69F0041Accident · No injuriesClosedHughes 269A · Broomfield, CONTSB DEN68F0002Accident · No injuriesClosedMooney M20E · Littleton, CONTSB DEN67A0057Accident · No injuriesClosedHughes 269B · Broomfield, CONTSB DEN67D0137Accident · No injuriesClosedBeech A23 · Lake George, CONTSB DEN67A0009Accident · No injuriesClosedHughes 269B · Las Animas, CONTSB DEN67F0023Accident · No injuriesClosedBeech A23 · Boulder, CONTSB DEN66A0079Accident · No injuriesClosedHughes 269A · Louisville, CONTSB DEN66A0061Accident · No injuriesClosedHughes 269A · Fort Collins, CONTSB DEN65A0086Accident · No injuriesClosedHughes 269A · Broomfield, CONTSB DEN66D0046Accident · No injuriesClosedMooney M-20E · Slater, CONTSB DEN65A0047Accident · Serious injuriesClosedHughes 269B · Colo Springs, CONTSB UNK65X0576Accident · No injuriesClosedHughes 269A · Broomfield, CONTSB UNK64X2380Accident · No injuriesClosedHughes 269A · Broomfield, CONTSB UNK64X0212Accident · 3 fatalClosedMooney M20E · De Beque, CO