NTSB investigations: Lycoming 0-540 series, 1973
83 cases on aircraft whose registry engine model is Lycoming 0-540 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 ('41532'))
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 ('41532'))
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 MKC73DCJ47Accident · Minor injuriesClosedPiper PA-25 · Stamford, NENTSB OAK73DVD39Accident · No injuriesClosedPiper PA-32 · La Paz, MexicoNTSB MIA73FKA10Accident · Minor injuriesClosedPiper PA-32 · Humacao, PRNTSB MKC73DTG14Accident · No injuriesClosedPiper PA-25 · Kindred, NDNTSB CHI73FEC37Accident · No injuriesClosedPiper PA-28 · Flushing, MINTSB IAD73FIJ22Accident · Serious injuriesClosedPiper PA-32 · Fleminton, WVNTSB OAK73FVD35Accident · Minor injuriesClosedCallair A-9 · Clements, CANTSB OAK73DVD36Accident · No injuriesClosedPiper PA-24 · Mazatlan, MexicoNTSB MIA73DKJ56Accident · No injuriesClosedPiper PA-25 · Mccullough, ALNTSB FTW73DRJ32Accident · No injuriesClosedPiper PA-25 · Mer Rouge, LANTSB CHI73FEE56Accident · No injuriesClosedPiper PA-24 · Joliet, ILNTSB NYC73DNA45Accident · No injuriesClosedPiper PA-24 · S.Weymouth, MANTSB MKC73DCD55Accident · No injuriesClosedPiper PA-28 · Wapello, IANTSB LAX73FUQ29Accident · No injuriesClosedPiper PA-24 · Van Nuys, CANTSB OAK73FVD29Accident · No injuriesClosedPiper PA-24 · Lodi, CANTSB LAX73DVA49Accident · No injuriesClosedPiper PA-25 · Pond, CANTSB MKC73DER49Accident · No injuriesClosedPiper PA-32 · Starbuck, MNNTSB MIA73FLG43Accident · No injuriesClosedPiper PA-23 · Cameron, SCNTSB LAX73AL049Accident · No injuriesClosedBoeing 707 · Los Angeles, CANTSB MIA73DLG41Accident · No injuriesClosedPiper PA-28 · Little River, SCNTSB MIA73OKT97Accident · No injuriesClosedPiper PA-32 · G.Harbor C, Burkina FasoNTSB MIA73DLD68Accident · No injuriesClosedPiper PA-24 · Inverness, FLNTSB MKC73FER45Accident · No injuriesClosedPiper PA-24 · Grand Rapids, MNNTSB OAK73FVG53Accident · No injuriesClosedPiper PA-25 · W.Sacramnto, CANTSB DEN73FTE66Accident · Serious injuriesClosedPiper PA-32 · Aurora, CONTSB MIA73FLD62Accident · Minor injuriesClosedPiper PA-32 · Windermere, FLNTSB NYC73AN118Accident · 4 fatalClosedPiper PA-24 · Pontiac, MINTSB CHI73AEM72Accident · No injuriesClosedPiper PA-32 · Charlotte, MINTSB FTW73FPA24Accident · No injuriesClosedPiper PA-28 · Dallas, TXNTSB OAK73DVG46Accident · No injuriesClosedPiper PA-24 · Auburn, CANTSB CHI73FEC22Accident · No injuriesClosedPiper PA-32 · Laingsburg, MINTSB DEN73FTE44Accident · No injuriesClosedPiper PA-32 · Broomfield, CONTSB NYC73FNC45Accident · No injuriesClosedPiper PA-24 · Keene, NH