NTSB investigations: Continental 0-300 series, 1978

65 cases on aircraft whose registry engine model is Continental 0-300 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\") = 1978
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17022'))
  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 MIA78FA062Accident · 2 fatalClosedCessna 172 · Miles City, FLApr 7, 1978 · N6886A · DestroyedNTSB FTW78DQD16Accident · No injuriesClosedCessna 172G · Imperial, TXApr 6, 1978 · N3908L · Substantial damageNTSB MKC78FCG22Accident · No injuriesClosedMaule M-4 · Sedalia, MOMar 27, 1978 · N12026 · Substantial damageNTSB MKC78FA029Accident · 2 fatalClosedCessna 172 · Leawood, KSMar 19, 1978 · N6892A · DestroyedNTSB MKC78DCQ17Accident · No injuriesClosedCessna 172A · Syracuse, KSMar 13, 1978 · N7649T · Substantial damageNTSB CHI78FEM13Accident · No injuriesClosedCessna 172 · Plainwell, MIMar 10, 1978 · N7052T · Substantial damageNTSB SEA78DYM18Accident · Minor injuriesClosedCessna 172 · Brooks, ORMar 5, 1978 · N5704A · Substantial damageNTSB MIA78FKG24Accident · No injuriesClosedCessna 172E · Lula, GAMar 4, 1978 · N3788S · Substantial damageNTSB CHI78FEC22Accident · No injuriesClosedCessna 172E · Almont, MIMar 4, 1978 · N3063U · Substantial damageNTSB CHI78FEP21Accident · No injuriesClosedCessna 172H · Fond Du Lac, WIFeb 17, 1978 · N2760L · Substantial damageNTSB LAX78DUJ27Accident · Minor injuriesClosedCessna 172G · Taylor, AZFeb 16, 1978 · N4264L · Substantial damageNTSB NYC78DNC12Accident · No injuriesClosedCessna 172 · Wayne, MEJan 28, 1978 · N8818B · Substantial damageNTSB NYC78DNA12Accident · No injuriesClosedCessna 172 · Falmouth, MAJan 28, 1978 · N2934U · Substantial damageNTSB MKC78DCG14Accident · No injuriesClosedCessna 172H · Marshfield, MOJan 26, 1978 · N3864R · Substantial damageNTSB MKC78DER16Accident · No injuriesClosedCessna 172F · Glenwood, MNJan 1, 1978 · N8205U · Substantial damage