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.
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" 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 NYC73FHM15Accident · Serious injuriesClosedPiper PA-24 · Spring Valley, NYNTSB NYC73DFA03Accident · No injuriesClosedPiper PA-32 · Delhi, NYNTSB NYC72DFA48Accident · No injuriesClosedPiper PA-24 · Oneonta, NYNTSB NYC72FHJ20Accident · No injuriesClosedPiper PA-28 · Montauk, NYNTSB NYC72DFJ15Accident · No injuriesClosedPiper PA-24 · Moravia, NYNTSB NYC71DFA46Accident · No injuriesClosedPiper PA-32 · Cairo, NYNTSB NYC71DFJ15Accident · No injuriesClosedPiper PA-24 · Weedsport, NYNTSB NYC70F0046Accident · No injuriesClosedPiper PA-24 · White Plains, NYNTSB NYC69F0434Accident · Minor injuriesClosedPiper PA-23 · Schenectady, NYNTSB NYC69F0201Accident · No injuriesClosedPiper PA-28 · Canandaigua, NYNTSB NYC68F0213Accident · Minor injuriesClosedPiper PA-32 · Montour Falls, NYNTSB NYC68D0018Accident · No injuriesClosedPiper PA-24 · Ithaca, NYNTSB NYC67A0116Accident · No injuriesClosedPiper PA-23 · Cooperstown, NYNTSB NYC67F0469Accident · No injuriesClosedPiper PA-23 · Wappingers Fls, NYNTSB NYC67F0445Accident · No injuriesClosedPiper PA-23 · Amityville, NYNTSB NYC67D0381Accident · No injuriesClosedPiper PA-23 · Jamaica, NYNTSB NYC67D0019Accident · Minor injuriesClosedPiper PA24 · Spring Valley, NYNTSB NYC67D0033Accident · No injuriesClosedPiper PA-24 · Poestenkill, NYNTSB NYC66F0428Accident · No injuriesClosedPiper PA-28 · Montour Falls, NYNTSB NYC66F0094Accident · No injuriesClosedPiper PA-24 · Utica, NYNTSB UNK64X4117Accident · No injuriesClosedPiper PA24 · Flushing, NY