NTSB investigations: Lycoming 0-320 series, 1964
302 cases on aircraft whose registry engine model is Lycoming 0-320 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\") = 1964
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41508'))
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") = 1964
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41508'))
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 UNK65X0429Accident · No injuriesClosedPiper PA28 · Fairhope, ALNTSB UNK65X0423Accident · No injuriesClosedPiper PA28 · Spokane, WANTSB UNK65X0405Accident · No injuriesClosedPiper PA28 · Beckenridge, TXNTSB UNK65X0372Accident · No injuriesClosedPiper PA23 · Laporte, TXNTSB UNK65X0366Accident · No injuriesClosedPiper PA28 · Oahu, HINTSB UNK65X0303Accident · No injuriesClosedPiper PA22 · Kennett, MONTSB UNK65X0290Accident · No injuriesClosedPiper PA28 · Bessemer, ALNTSB UNK65X0278Accident · No injuriesClosedBeechcraft 23 · Cleveland, OHNTSB UNK65X0262Accident · No injuriesClosedPiper PA28 · Long Beach, CANTSB UNK65X0198Accident · No injuriesClosedPiper PA18A · Socorro, NMNTSB UNK65X0192Accident · No injuriesClosedPiper PA28 · Adams, NYNTSB UNK65X0175Accident · No injuriesClosedPiper PA22 · Plymouth, MINTSB UNK65X0144Accident · No injuriesClosedPiper PA28 · Lumberton, NJNTSB UNK65X0125Accident · No injuriesClosedPiper PA22 · Fresno, CANTSB UNK65X0105Accident · No injuriesClosedPiper PA22 · Beckwourth, CANTSB UNK64X4219Accident · No injuriesClosedPiper PA22 · Kissimmee, FLNTSB UNK64X4193Accident · No injuriesClosedPiper PA22 · Council Bluff, IANTSB UNK64X4174Accident · No injuriesClosedPiper PA22 · Alameda, NMNTSB UNK64X4074Accident · No injuriesClosedPiper PA22 · Chico, CANTSB UNK64X4061Accident · No injuriesClosedPiper PA22 · Sparks, NVNTSB UNK64X4015Accident · No injuriesClosedPiper PA22 · Blawnox, PANTSB UNK64X4002Accident · Minor injuriesClosedBeechcraft M23 · Tacoma, WANTSB UNK64X3993Accident · No injuriesClosedPiper PA22 · Gaylord, MNNTSB UNK64X3988Accident · No injuriesClosedBeechcraft 23 · Ogallala, NENTSB UNK64X3972Accident · No injuriesClosedPiper PA28 · Roselle, ILNTSB UNK64X3961Accident · No injuriesClosedPiper PA28 · Woolstock, IANTSB UNK64X3944Accident · No injuriesClosedPiper PA23 · Broomfield, CONTSB UNK64X3939Accident · No injuriesClosedPiper PA22 · Endicott, NYNTSB UNK64X3938Accident · No injuriesClosedPiper PA22 · Kremlin, MTNTSB UNK64X3929Accident · 1 fatalClosedPiper PA-25 · Hereford, TXNTSB UNK64X3915Accident · Minor injuriesClosedPiper PA28 · Martinsburg, PANTSB UNK64X3911Accident · Minor injuriesClosedPiper PA22 · Chistochina, AKNTSB UNK64X3906Accident · Serious injuriesClosedPiper PA25 · Mclean, TXNTSB UNK64X3859Accident · Minor injuriesClosedPiper PA18 · Highlake, AKNTSB UNK64X3819Accident · No injuriesClosedPiper PA28 · Houston, TXNTSB UNK64X3816Accident · Minor injuriesClosedPiper PA22 · Patten, MENTSB UNK64X3788Accident · No injuriesClosedPiper PA22 · Southport, NCNTSB UNK64X3781Accident · Serious injuriesClosedBeechcraft 23 · Tracy, CANTSB UNK64X3770Accident · No injuriesClosedPiper PA12 · Gulkana, AKNTSB UNK64X3762Accident · Minor injuriesClosedPiper PA18A · Winder, GANTSB UNK64X3757Accident · Minor injuriesClosedPiper PA18A · Midnight, MSNTSB UNK64X3705Accident · Serious injuriesClosedPiper PA25 · Prior Lake, MNNTSB UNK64X3701Accident · No injuriesClosedPiper PA18 · Hendry County, FLNTSB UNK64X3674Accident · No injuriesClosedBeechcraft M23 · Milan, ILNTSB UNK64X3673Accident · No injuriesClosedPiper PA28 · Laurel, MSNTSB UNK64X3642Accident · No injuriesClosedPiper PA28 · Madison, CTNTSB UNK64X3628Accident · No injuriesClosedBeechcraft M23 · Liberal, KSNTSB UNK64X3575Accident · No injuriesClosedPiper PA12 · Plymouth, MINTSB UNK64X3541Accident · Minor injuriesClosedCallair A5 · Camillia, GANTSB UNK64X3513Accident · No injuriesClosedPiper PA22 · Sheffield, TX