NTSB investigations: Lycoming I0360 series, NC
66 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\" = 'NC' 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" = 'NC' 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 IAD73FLJ35Accident · No injuriesClosedMooney M20E · Evergreen, NCNTSB IAD73DKM37Accident · No injuriesClosedPiper PA-28R · Winston Salem, NCNTSB NYC72FLJ21Accident · No injuriesClosedMooney M20E · Gates, NCNTSB IAD71FLJ20Accident · No injuriesClosedMooney M20F · Pinehurst, NCNTSB IAD71DKM02Accident · No injuriesClosedMooney M20F · Winston-Salem, NCNTSB IAD70AI052Accident · 1 fatalClosedPiper J3C-65 · Asheboro, NCNTSB IAD70F0065Accident · No injuriesClosedPiper PA-28R · Statesville, NCNTSB DIA70D0037Accident · No injuriesClosedPiper PA-28 · Franklin, NCNTSB DIA69A0035Accident · Minor injuriesClosedPiper PA-28 · Wadesboro, NCNTSB DIA68F0177Accident · No injuriesClosedMooney M20F · Concord, NCNTSB DIA68F0110Accident · No injuriesClosedBeech D95A · Greensboro, NCNTSB DIA68D0021Accident · No injuriesClosedMooney M20E · Coats, NCNTSB DIA68F0011Accident · No injuriesClosedMooney M20E · Greensboro, NCNTSB DIA67F0021Accident · No injuriesClosedBeech A23 · High Point, NCNTSB MIA67F0183Accident · No injuriesClosedMooney M20E · Buies Creek, NCNTSB MIA66F0554Accident · No injuriesClosedBeech D95A · Winston-Salem, NC