NTSB investigations: Continental C85 series, 1972

75 cases on aircraft whose registry engine model is Continental C85 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 ('17008'))
  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 MIA72DLD64Accident · No injuriesClosedPiper J-3 · Ormond Beach, FLMay 6, 1972 · N88257 · Substantial damageNTSB OAK72DVG54Accident · No injuriesClosedStits PB 2A · Franklin, CAMay 4, 1972 · N1367N · Substantial damageNTSB FTW72DPJ39Accident · No injuriesClosedCessna 140 · Yukon, OKMay 2, 1972 · N2875N · Substantial damageNTSB SEA72DYI20Accident · Minor injuriesClosedCessna 140 · Bend, ORApr 29, 1972 · N73079 · Substantial damageNTSB MIA72FKG95Accident · No injuriesClosedAeronca 7BCM · Hampton, GAApr 28, 1972 · N2553B · Substantial damageNTSB SEA72DYC36Accident · No injuriesClosedCessna 120 · The Dalles, TXApr 23, 1972 · N76892 · Substantial damageNTSB SEA72DYE29Accident · No injuriesClosedCessna 120 · Seattle, WAApr 17, 1972 · N1701N · Substantial damageNTSB MIA72FLA39Accident · Serious injuriesClosedCessna 140 · Milton, FLApr 10, 1972 · N72699 · Substantial damageNTSB CHI72DEE70Accident · No injuriesClosedLuscombe 8E · Rockton, ILApr 8, 1972 · N2351K · Substantial damageNTSB NYC72FLJ29Accident · No injuriesClosedLuscombe 8E · Kinston, NCApr 5, 1972 · N1558B · Substantial damageNTSB SEA73FYG32Accident · No injuriesClosedCessna 120 · George, WAMar 27, 1972 · N2696N · Substantial damageNTSB MKC72FCD64Accident · No injuriesClosedLuscombe 8E · Adel, IAMar 25, 1972 · N1306B · Substantial damageNTSB SEA72DYG38Accident · No injuriesClosedLuscombe 8E · Pullman, WAMar 17, 1972 · N1404B · Substantial damageNTSB DEN72FQA34Accident · No injuriesClosedLuscombe 8E · Taos, NMMar 9, 1972 · N2830K · Substantial damageNTSB LAX72DVA51Accident · No injuriesClosedCessna 140 · Bakersfield, CAFeb 27, 1972 · N1718V · Substantial damageNTSB SEA72DTA12Accident · No injuriesClosedCessna 140 · Glendive, MTFeb 20, 1972 · N2040N · Substantial damageNTSB MKC72DCJ48Accident · No injuriesClosedCessna 140 · Lincoln, NEFeb 17, 1972 · N76809 · Substantial damageNTSB SEA72FTA11Accident · No injuriesClosedCessna 140 · Hardin, MTFeb 15, 1972 · N72261 · Substantial damageNTSB MKC72DCQ47Accident · No injuriesClosedCessna 120 · Beaumont, KSFeb 13, 1972 · N33Y · Substantial damageNTSB OAK72FVG34Accident · Minor injuriesClosedErco 415-C · Sacramento, CAFeb 2, 1972 · N3212H · DestroyedNTSB FTW72DQG27Accident · No injuriesClosedAeronca 7BCM · Paducah, TXJan 31, 1972 · N2501B · Substantial damageNTSB MIA72DLD45Accident · No injuriesClosedCessna 140 · Ocoee, FLJan 29, 1972 · N89454 · Substantial damageNTSB SEA72DVC26Accident · No injuriesClosedLuscombe 8E · Orchards, WAJan 28, 1972 · N1717K · Substantial damageNTSB LAX72DUJ65Accident · No injuriesClosedCessna 140 · Phoenix, AZJan 21, 1972 · N2328N · Substantial damageNTSB MKC72DTK17Accident · No injuriesClosedAeronca 7BCM · Huron, SDJan 6, 1972 · N4256E · Substantial damage