NTSB investigations: Continental 0-300 series, AZ

72 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 c.\"eventStateOrRegion\" = 'AZ' 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 ('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 LAX70D0191Accident · No injuriesClosedGlobe GC-1A · Casa Grande, AZNov 3, 1969 · N80720 · Substantial damageNTSB LAX68F0323Accident · No injuriesClosedCessna 172 · Yuma, AZJan 28, 1968 · N3900L · Substantial damageNTSB LAX68D0211Accident · No injuriesClosedCessna 172 · Lk Havsu Cty, AZOct 15, 1967 · N7456X · Substantial damageNTSB LAX68F0150Accident · No injuriesClosedCessna 172 · Phoenix, AZSep 24, 1967 · N5781R · Substantial damageNTSB LAX68D0096Accident · No injuriesClosedCessna 172 · Holbrook, AZJul 15, 1967 · N6323E · DestroyedNTSB LAX68D0017Accident · No injuriesClosedCessna 172 · Phoenix, AZJun 5, 1967 · N8014L · Substantial damageNTSB LAX67F0333Accident · 1 fatalClosedCessna 172 · Phoenix, AZMar 9, 1967 · N3959S · Substantial damageNTSB LAX67D0168Accident · No injuriesClosedCessna 172G · Winslow, AZOct 13, 1966 · N5917R · Substantial damageNTSB LAX67D0164Accident · No injuriesClosedCessna 172 · Grand Canyon, AZOct 8, 1966 · N1752F · Substantial damageNTSB LAX67D0155Accident · Minor injuriesClosedCessna 172 · Sonoita, AZOct 2, 1966 · N5932R · DestroyedNTSB DEN67D0013Accident · No injuriesClosedCessna 172 · Sierra Vista, AZMay 11, 1966 · N9180Z · Substantial damageNTSB DEN66D0338Accident · No injuriesClosedCessna 170B · Phoenix, AZMay 8, 1966 · N8194A · Substantial damageNTSB DEN66D0313Accident · No injuriesClosedCessna 172 · San Simon, AZFeb 8, 1966 · N5942A · Substantial damageNTSB DEN66D0210Accident · Minor injuriesClosedCessna 172 · Bowie, AZJan 9, 1966 · N7513T · DestroyedNTSB DEN66D0134Accident · No injuriesClosedCessna 170B · Phoenix, AZSep 21, 1965 · N2917D · Substantial damageNTSB DEN65D0084Accident · No injuriesClosedCessna 172D · Tucson, AZMay 9, 1965 · N2533U · Substantial damageNTSB UNK65X1304Accident · No injuriesClosedCessna 170B · Gila Bend, AZJan 17, 1965 · N2255D · Substantial damageNTSB UNK65X0974Accident · No injuriesClosedCessna 172 · Kingman, AZDec 11, 1964 · N1326Y · Substantial damageNTSB UNK65X0282Accident · No injuriesClosedCessna 172 · Grand Canyon, AZOct 15, 1964 · N8118B · Substantial damageNTSB UNK64X2168Accident · No injuriesClosedCessna 172 · Page, AZJun 7, 1964 · N6221E · Substantial damageNTSB UNK64X0406Accident · No injuriesClosedCessna 170B · Flagstaff, AZJan 30, 1964 · N3514C · Substantial damageNTSB UNK64X0146Accident · No injuriesClosedCessna 172 · Scottsdale, AZJan 4, 1964 · N7452T · Substantial damage