NTSB investigations: Lycoming I0360 series, 1973
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 year(c.\"eventDate\") = 1973
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") = 1973
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 SEA73DYA25Accident · No injuriesClosedMooney M20E · American Falls, IDNTSB IAD73DKM37Accident · No injuriesClosedPiper PA-28R · Winston Salem, NCNTSB DEN73DQA38Accident · No injuriesClosedMooney M20F · Ramah, NMNTSB MKC73FCD61Accident · No injuriesClosedEnstrom F-28A · Altoona, IANTSB LAX73FUQ83Accident · No injuriesClosedEnstrom F-28A · Goleta, CANTSB NYC73FHA73Accident · Minor injuriesClosedCessna 177B · Pottstown, PANTSB NYC73FNE31Accident · No injuriesClosedPiper PA-28R · Waterford, CTNTSB FTW73FPJ17Accident · Minor injuriesClosedHughes 269B · Enid, OKNTSB NYC73DNC68Accident · No injuriesClosedMooney M20E · North Conway, NHNTSB CHI73FEE49Accident · Minor injuriesClosedPiper PA-28R · Elgin, ILNTSB IAD73FKW21Accident · No injuriesClosedMooney M20F · Alcoa, TNNTSB DEN73DTC20Accident · No injuriesClosedPiper PA-28R · Laramie, WYNTSB NYC73AN120Accident · 3 fatalClosedPiper PA-28 · Falls Creek, PANTSB MIA73FLA29Accident · No injuriesClosedBeech A24R · Jacksonville, FLNTSB FTW73DRG55Accident · No injuriesClosedPiper PA-28R · Cotulla, TXNTSB FTW73FPG39Accident · Serious injuriesClosedPiper PA-28R · Black Fork, ARNTSB FTW73AF049Accident · 1 fatalClosedPiper PA-28R · Baton Rouge, LANTSB CHI73FEG20Accident · No injuriesClosedBeech A24R · Piqua, OHNTSB NYC73DNC54Accident · No injuriesClosedMooney M20E · Biddeford, MENTSB LAX73AL042Accident · 2 fatalClosedMooney M20E · Phoenix, AZNTSB MKC73FCG29Accident · No injuriesClosedPiper PA-28R · Atchison, KSNTSB FTW73FQD17Accident · Minor injuriesClosedPiper PA-28R · El Paso, TXNTSB DEN73FTE55Accident · No injuriesClosedMooney M20E · Greenwd Vill, CONTSB NYC73FNC52Accident · No injuriesClosedMooney M20F · Caribou, MENTSB DEN73AD037Accident · 3 fatalClosedBeech A24R · Alamogordo, NMNTSB FTW73FPG37Accident · No injuriesClosedMooney M20C · N.Little Rock, AR