NTSB investigations: Lycoming 0-320 series, 1973
316 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\") = 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 ('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") = 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 ('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 SEA74FTI10Accident · No injuriesClosedCallair A-2 · Anaconda, MTNTSB CHI74FEE27Accident · No injuriesClosedCessna 172K · Plainfield, ILNTSB NYC74FFA16Accident · No injuriesClosedCessna 172I · Alexandria Bay, NYNTSB MKC74FTG07Accident · No injuriesClosedPiper PA-28 · Fargo, NDNTSB IAD74FLQ12Accident · No injuriesClosedCessna 172K · Williamsburg, KYNTSB IAD74FLQ11Accident · No injuriesClosedPiper PA-28 · Louisville, KYNTSB MKC74DCD17Accident · Serious injuriesClosedPiper PA-22 · West Branch, IANTSB MIA74DKG36Accident · No injuriesClosedPiper PA-24 · Gainesville, GANTSB NYC74FFA13Accident · No injuriesClosedCessna 172L · Bloomingburg, NYNTSB CHI74AC031Accident · 2 fatalClosedBellanca 7GCBC · Morris, ILNTSB ANC74DAG64Accident · No injuriesClosedPiper PA-14 · Anchorage, AKNTSB NYC74DHD17Accident · No injuriesClosedPiper PA-28 · Berlin, NJNTSB LAX74AL026Accident · 2 fatalClosedPiper PA-18 · Tacna, AZNTSB DEN74DQD06Accident · No injuriesClosedPiper PA-28 · Silver City, NMNTSB SEA74DYC19Accident · Minor injuriesClosedPiper PA-28 · Colton, ORNTSB NYC74FEM08Accident · Serious injuriesClosedMooney M20 · Dubois, PANTSB CHI74FEE24Accident · No injuriesClosedPiper PA-28 · Plainfield, ILNTSB ANC74FAG73Accident · Serious injuriesClosedPiper PA-18 · Gulkana, AKNTSB ANC74DAG60Accident · No injuriesClosedBellanca 7GCBC · Anchorage, AKNTSB SEA74FVC18Accident · No injuriesClosedPiper PA-28 · Salem, ORNTSB SEA74DTA10Accident · No injuriesClosedBellanca 7GCA · Lodge Pole, MTNTSB NYC74DNC75Accident · No injuriesClosedPiper PA-18 · Lebanon, NHNTSB MKC74DCJ11Accident · No injuriesClosedPiper PA-18 · Ainsworth, NENTSB LAX74DUQ14Accident · No injuriesClosedPiper PA-18A · Mojave, CANTSB IAD74DIJ19Accident · No injuriesClosedPiper PA-28 · Burlington, NCNTSB MKC74DCD16Accident · No injuriesClosedPitts S-1C · Washburn, IANTSB CHI74FEP17Accident · No injuriesClosedPiper PA-22 · Arena, WINTSB ANC74FAA15Accident · No injuriesClosedPiper PA-18 · Clear, AKNTSB MKC74DER15Accident · No injuriesClosedBellanca 17-30A · Lake Elmo, MNNTSB OAK74DVW07Accident · No injuriesClosedBeech 19 · Las Vegas, NVNTSB DEN74DTC13Accident · No injuriesClosedPiper PA-18 · Wheatland, WYNTSB MKC74DCJ10Accident · No injuriesClosedPiper PA-25 · Gresham, NENTSB ANC74DAG49Accident · No injuriesClosedPiper PA-14 · Susitna, AKNTSB ANC74DAG56Accident · No injuriesClosedPiper PA-18 · Gulkana, AKNTSB ANC74DAG52Accident · No injuriesClosedPiper PA-18 · Pilot Point, AKNTSB ANC74DAG46Accident · No injuriesClosedPiper PA-18 · Kenai, AKNTSB ANC74DAG54Accident · No injuriesClosedPiper PA-18 · Gulkana, AKNTSB CHI74FEE18Accident · Minor injuriesClosedPiper PA-22 · Glenwood, ILNTSB NYC74DHJ15Accident · No injuriesClosedCessna 150 · Deerpark, NYNTSB MIA74DKJ24Accident · No injuriesClosedPiper PA-22 · Daphne, ALNTSB LAX74DUJ18Accident · No injuriesClosedPiper PA-28 · White Mt Lk, AZNTSB CHI74FEI12Accident · Minor injuriesClosedPiper PA-28 · Gustavus, OHNTSB ANC74DAG47Accident · No injuriesClosedPiper PA-18 · Talchultna R, AKNTSB MKC74DER12Accident · No injuriesClosedPiper PA-28 · Elk River, MNNTSB CHI74DEV19Accident · Minor injuriesClosedPiper PA-28 · Bloomington, ILNTSB OAK74DVA19Accident · No injuriesClosedPiper PA-28 · Madera, CANTSB OAK74DVA18Accident · No injuriesClosedPiper PA-22 · Kettleman, CANTSB NYC74DFA08Accident · No injuriesClosedAmer Avco AA-5 · Mt Upton, NYNTSB ANC74DAG39Accident · No injuriesClosedPiper PA-18 · Palmer, CANTSB ANC74DAG35Accident · Minor injuriesClosedPiper PA-28 · Rainy Pass, AK