NTSB investigations: Lycoming I0360 series, 1971
65 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\") = 1971
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") = 1971
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 MIA71DKG71Accident · No injuriesClosedPiper PA-28 · Fitzgerald, GANTSB MKC71FCG49Incident · No injuriesClosedPiper PA-28R · Springfield, MONTSB NYC71FHJ22Accident · No injuriesClosedMooney M20F · Flushing, NYNTSB CHI71DBM15Accident · No injuriesClosedBeech A23-24 · Rochester, INNTSB MIA71FLD48Accident · No injuriesClosedHughes 269B · Tampa, FLNTSB LAX71DUM28Accident · Minor injuriesClosedPiper PA-28R · Jacumba, CANTSB NYC71DFA51Accident · No injuriesClosedBeech A23-24 · Rome, NYNTSB CHI71DGD45Accident · No injuriesClosedPiper PA-28R · Painsville, OHNTSB NYC71FHA33Accident · No injuriesClosedPiper PA-28R · Forty Fort, PANTSB OAK71DVG59Accident · No injuriesClosedMooney M20E · Fair Oaks, CANTSB CHI71FDJ40Accident · No injuriesClosedPiper PA-28R · Milwaukee, WINTSB FTW71FPG35Accident · No injuriesClosedMooney M20E · Little Rock, ARNTSB CHI71DBA27Accident · No injuriesClosedMooney M20F · Whitestown, INNTSB NYC71FHM15Accident · Serious injuriesClosedMooney M20F · Morristown, NJNTSB NYC71IN076Incident · No injuriesClosedCessna 150 · Danbury, CT