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.

NTSB MKC71DCA04Accident · Minor injuriesClosedPiper PA-24 · New Haven, MOJul 25, 1970 · N5695P · Substantial damageNTSB MKC70D0237Accident · No injuriesClosedPiper PA-32 · Shelbyville, MOOct 8, 1969 · N3539W · Substantial damageNTSB MKC70D0098Accident · Minor injuriesClosedPiper PA-25 · La Plata, MOJul 8, 1969 · N4838Y · Substantial damageNTSB MKC70F0074Accident · No injuriesClosedPiper PA-24 · Sarcoxie, MOJul 7, 1969 · N487SC · Substantial damageNTSB MKC68F0457Accident · No injuriesClosedPiper PA-24 · De Soto, MOFeb 19, 1968 · N5915P · Substantial damageNTSB MKC68D0435Accident · No injuriesClosedPiper PA-32 · Warrensburg, MODec 3, 1967 · N3385W · Substantial damageNTSB MKC68A0034Accident · 2 fatalClosedPiper PA-24 · Aurora, MONov 23, 1967 · N6275P · DestroyedNTSB MKC68A0031Accident · No injuriesClosedPiper PA-32 · Kirksville, MOOct 26, 1967 · N3841W · Substantial damageNTSB MKC68F0431Accident · No injuriesClosedPiper PA-24 · St.Charles, MOAug 12, 1967 · N7272P · Substantial damageNTSB MKC68F0255Accident · No injuriesClosedPiper PA-28 · Rolla, MOJul 31, 1967 · N8884W · DestroyedNTSB MKC68D0138Accident · No injuriesClosedPiper PA-24 · Bigelow, MOJul 29, 1967 · N6803P · Substantial damageNTSB MKC67F0591Accident · No injuriesClosedPiper PA-28 · St Joseph, MOMay 31, 1967 · N9178W · Substantial damageNTSB MKC67D0550Accident · No injuriesClosedPiper PA-24 · Columbia, MOJan 13, 1967 · N7451P · Substantial damageNTSB MKC67F0335Accident · No injuriesClosedPiper PA-24 · Republic, MONov 28, 1966 · N6264P · Substantial damageNTSB MKC67F0218Accident · No injuriesClosedPiper PA-28 · Webb City, MOSep 12, 1966 · N8803W · Substantial damageNTSB MKC67F0192Accident · Serious injuriesClosedPiper PA-24 · Mt Vernon, MOAug 21, 1966 · N5701P · Substantial damageNTSB MKC66D0492Accident · No injuriesClosedPiper PA-25 · Nevada, MOFeb 12, 1966 · N7682Z · Substantial damageNTSB MKC66D0412Accident · No injuriesClosedPiper PA-32 · Kansas City, MOJan 29, 1966 · N3383W · Substantial damageNTSB MKC66D0256Accident · No injuriesClosedPiper PA-28 · Sedalia, MOAug 29, 1965 · N8520W · Substantial damageNTSB MKC66F0165Accident · Minor injuriesClosedCallair 9A · Missouri Vly, MOJul 31, 1965 · N3564G · Substantial damageNTSB MKC66F0123Accident · No injuriesClosedPiper PA-24 · Cassville, MOJun 22, 1965 · N5915P · Substantial damageNTSB MKC66F0013Accident · No injuriesClosedPiper PA-24 · St Charles, MOApr 30, 1965 · N7272P · Substantial damageNTSB MKC65D0133Accident · No injuriesClosedPiper PA-24 · Chillicothe, MOJan 12, 1965 · N8031P · Substantial damageNTSB UNK64X3719Accident · No injuriesClosedPiper PA24 · Cabool, MOSep 1, 1964 · N8316P · Substantial damageNTSB UNK64X1823Accident · Minor injuriesClosedPiper PA24 · Monett, MOMay 18, 1964 · N7697P · Substantial damage