NTSB investigations: Lycoming 0-540 series, NY

71 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 c.\"eventStateOrRegion\" = 'NY' AND c.\"eventCountry\" = 'USA'
    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.

NTSB NYC73FHM15Accident · Serious injuriesClosedPiper PA-24 · Spring Valley, NYNov 7, 1972 · N5500P · Substantial damageNTSB NYC73DFA03Accident · No injuriesClosedPiper PA-32 · Delhi, NYJul 1, 1972 · N3701W · Substantial damageNTSB NYC72DFA48Accident · No injuriesClosedPiper PA-24 · Oneonta, NYJun 23, 1972 · N7178P · Substantial damageNTSB NYC72FHJ20Accident · No injuriesClosedPiper PA-28 · Montauk, NYMay 27, 1972 · N9366W · Substantial damageNTSB NYC72DFJ15Accident · No injuriesClosedPiper PA-24 · Moravia, NYSep 17, 1971 · N6514P · Substantial damageNTSB NYC71DFA46Accident · No injuriesClosedPiper PA-32 · Cairo, NYJan 11, 1971 · N4862S · Substantial damageNTSB NYC71DFJ15Accident · No injuriesClosedPiper PA-24 · Weedsport, NYOct 2, 1970 · N6465P · Substantial damageNTSB NYC70F0046Accident · No injuriesClosedPiper PA-24 · White Plains, NYJun 24, 1969 · N5999P · Substantial damageNTSB NYC69F0434Accident · Minor injuriesClosedPiper PA-23 · Schenectady, NYApr 18, 1969 · N4809P · Substantial damageNTSB NYC69F0201Accident · No injuriesClosedPiper PA-28 · Canandaigua, NYSep 22, 1968 · N8809W · Substantial damageNTSB NYC68F0213Accident · Minor injuriesClosedPiper PA-32 · Montour Falls, NYSep 30, 1967 · N3861W · Substantial damageNTSB NYC68D0018Accident · No injuriesClosedPiper PA-24 · Ithaca, NYMay 28, 1967 · N6960P · Substantial damageNTSB NYC67A0116Accident · No injuriesClosedPiper PA-23 · Cooperstown, NYJan 29, 1967 · N5333Y · Substantial damageNTSB NYC67F0469Accident · No injuriesClosedPiper PA-23 · Wappingers Fls, NYJan 6, 1967 · N4086P · Substantial damageNTSB NYC67F0445Accident · No injuriesClosedPiper PA-23 · Amityville, NYJan 3, 1967 · N4985P · Substantial damageNTSB NYC67D0381Accident · No injuriesClosedPiper PA-23 · Jamaica, NYNov 1, 1966 · N309SL · Substantial damageNTSB NYC67D0019Accident · Minor injuriesClosedPiper PA24 · Spring Valley, NYJun 13, 1966 · N7139P · Substantial damageNTSB NYC67D0033Accident · No injuriesClosedPiper PA-24 · Poestenkill, NYJun 3, 1966 · N8190P · Substantial damageNTSB NYC66F0428Accident · No injuriesClosedPiper PA-28 · Montour Falls, NYDec 22, 1965 · N9055W · Substantial damageNTSB NYC66F0094Accident · No injuriesClosedPiper PA-24 · Utica, NYJul 12, 1965 · N6494P · Substantial damageNTSB UNK64X4117Accident · No injuriesClosedPiper PA24 · Flushing, NYSep 23, 1964 · N7451P · Substantial damage