NTSB investigations: Lycoming 0-540 series, 1972
115 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\") = 1972
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") = 1972
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 FTW73FQG07Accident · Serious injuriesClosedPiper PA-25 · Dumas, TXNTSB LAX73FUG03Accident · Minor injuriesClosedPiper PA-24 · Hesperia, CANTSB CHI73FLQ01Accident · No injuriesClosedPiper PA-24 · Erlanger, KYNTSB MIA73FLA05Accident · No injuriesClosedPiper PA-23 · Pensacola, FLNTSB MKC73DCJ07Accident · No injuriesClosedPiper PA-25 · Humbolt, NENTSB FTW73DPD01Accident · Serious injuriesClosedPiper PA-25 · Priddy, TXNTSB DEN73FTE02Accident · No injuriesClosedPiper PA-25 · Mead, CONTSB MKC73DCJ01Accident · No injuriesClosedPiper PA-25 · Oshkosh, NENTSB FTW73AF001Accident · 5 fatalClosedPiper PA-28 · Intrcoastl Cty, LANTSB FTW73FRA03Accident · 1 fatalClosedPiper PA-25 · Caldwell, TXNTSB NYC73DFA03Accident · No injuriesClosedPiper PA-32 · Delhi, NYNTSB CHI73FEK03Accident · No injuriesClosedPiper PA-24 · Lima, OHNTSB MIA72DLT16Accident · Minor injuriesClosedPiper PA-25 · Trimble, TNNTSB FTW72DQG48Accident · No injuriesClosedPiper PA-25 · Wall, TXNTSB NYC72DFA48Accident · No injuriesClosedPiper PA-24 · Oneonta, NYNTSB MKC72FTG24Accident · No injuriesClosedPiper PA-28 · Lisbon, NDNTSB MIA72FKH18Accident · Minor injuriesClosedPiper PA-25 · Ocilla, GANTSB ANC72AA052Accident · No injuriesClosedPiper PA-32 · Kalskag, AKNTSB CHI72FEC48Accident · No injuriesClosedPiper PA-24 · Plymouth, MINTSB NYC72FNA45Accident · No injuriesClosedPiper PA-24 · Hopedale, MANTSB MIA72FLD74Accident · No injuriesClosedPiper PA-24 · Tampa, FLNTSB MIA72DKH23Accident · Serious injuriesClosedPiper PA-24 · Dublin, GANTSB OAK72DVG73Accident · No injuriesClosedPiper PA-28 · Nut Tree, CANTSB MKC72FCA29Accident · Minor injuriesClosedPiper PA-24 · Tyrone, MONTSB CHI72FEE84Accident · Serious injuriesClosedPiper PA-24 · Chicago, ILNTSB DEN72AD059Accident · 6 fatalClosedPiper PA-32 · Nucla, CONTSB MIA72FLG43Accident · No injuriesClosedCallair A-9 · Barnwell, SCNTSB MKC72DCJ71Accident · No injuriesClosedPiper PA-25 · Crawford, NENTSB LAX72FUQ89Accident · Serious injuriesClosedPiper PA-32 · Lake Hughes, CANTSB OAK72DXQ36Accident · No injuriesClosedPiper PA-24 · Mammoth Lks, CANTSB NYC72FHJ20Accident · No injuriesClosedPiper PA-28 · Montauk, NYNTSB MIA72FLD72Accident · No injuriesClosedPiper PA-24 · Lakeland, FLNTSB MKC72DCQ57Accident · No injuriesClosedPiper PA-25 · Laharpe, KSNTSB NYC72FIG26Accident · Serious injuriesClosedPiper PA-32 · Oakland, MDNTSB ANC72DAG14Accident · No injuriesClosedPiper PA-28 · Cold Bay, AKNTSB MKC72FCA27Accident · No injuriesClosedPiper PA-25 · New Madrid, MONTSB MIA72FKH02Accident · Serious injuriesClosedCallair A-9 · Calhoun, GANTSB MIA72FKG99Accident · No injuriesClosedPiper PA-23 · Chamblee, GANTSB CHI72DET26Accident · No injuriesClosedPiper PA-28 · Syracuse, INNTSB OAK72FVG57Accident · Minor injuriesClosedPiper PA-28 · Montague, CANTSB DEN81FA070Accident · 1 fatalClosedPiper PA-23 · Estes Park, CONTSB FTW72DPG73Accident · No injuriesClosedPiper PA-25 · Osceola, ARNTSB CHI72FEA42Accident · Minor injuriesClosedPiper PA-32 · Crawfordsvile, INNTSB MIA72FKJ52Accident · No injuriesClosedPiper PA-24 · Birmingham, ALNTSB DEN72FQG38Accident · 1 fatalClosedPiper PA-25 · Clovis, NMNTSB NYC72FIA20Accident · No injuriesClosedPiper PA-24 · Manassas, VANTSB LAX72DUJ94Accident · No injuriesClosedPiper PA-28 · Kingman, AZNTSB FTW72FPA19Accident · Minor injuriesClosedPiper PA-28 · Dallas, TXNTSB DEN72FTE65Accident · No injuriesClosedPiper PA-25 · Merino, CONTSB MIA72DKJ49Accident · No injuriesClosedPiper PA-24 · Uniontown, AL