NTSB investigations: Lycoming 0-540 series, MO
75 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\" = 'MO' 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" = 'MO' 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 MKC71DCA04Accident · Minor injuriesClosedPiper PA-24 · New Haven, MONTSB MKC70D0237Accident · No injuriesClosedPiper PA-32 · Shelbyville, MONTSB MKC70D0098Accident · Minor injuriesClosedPiper PA-25 · La Plata, MONTSB MKC70F0074Accident · No injuriesClosedPiper PA-24 · Sarcoxie, MONTSB MKC68F0457Accident · No injuriesClosedPiper PA-24 · De Soto, MONTSB MKC68D0435Accident · No injuriesClosedPiper PA-32 · Warrensburg, MONTSB MKC68A0034Accident · 2 fatalClosedPiper PA-24 · Aurora, MONTSB MKC68A0031Accident · No injuriesClosedPiper PA-32 · Kirksville, MONTSB MKC68F0431Accident · No injuriesClosedPiper PA-24 · St.Charles, MONTSB MKC68F0255Accident · No injuriesClosedPiper PA-28 · Rolla, MONTSB MKC68D0138Accident · No injuriesClosedPiper PA-24 · Bigelow, MONTSB MKC67F0591Accident · No injuriesClosedPiper PA-28 · St Joseph, MONTSB MKC67D0550Accident · No injuriesClosedPiper PA-24 · Columbia, MONTSB MKC67F0335Accident · No injuriesClosedPiper PA-24 · Republic, MONTSB MKC67F0218Accident · No injuriesClosedPiper PA-28 · Webb City, MONTSB MKC67F0192Accident · Serious injuriesClosedPiper PA-24 · Mt Vernon, MONTSB MKC66D0492Accident · No injuriesClosedPiper PA-25 · Nevada, MONTSB MKC66D0412Accident · No injuriesClosedPiper PA-32 · Kansas City, MONTSB MKC66D0256Accident · No injuriesClosedPiper PA-28 · Sedalia, MONTSB MKC66F0165Accident · Minor injuriesClosedCallair 9A · Missouri Vly, MONTSB MKC66F0123Accident · No injuriesClosedPiper PA-24 · Cassville, MONTSB MKC66F0013Accident · No injuriesClosedPiper PA-24 · St Charles, MONTSB MKC65D0133Accident · No injuriesClosedPiper PA-24 · Chillicothe, MONTSB UNK64X3719Accident · No injuriesClosedPiper PA24 · Cabool, MONTSB UNK64X1823Accident · Minor injuriesClosedPiper PA24 · Monett, MO