NTSB investigations: Continental 0-300 series, MO

86 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\" = '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 ('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 MKC68D0492Accident · No injuriesClosedCessna 172 · Warrensburg, MOMar 2, 1968 · N8182X · Substantial damageNTSB MKC68D0410Accident · No injuriesClosedCessna 172 · Kansas City, MONov 24, 1967 · N8673B · Substantial damageNTSB MKC68D0251Accident · Minor injuriesClosedCessna 172 · Clinton, MOSep 11, 1967 · N3738L · Substantial damageNTSB MKC68D0121Accident · Minor injuriesClosedCessna 172 · Forest City, MOJul 11, 1967 · N7860U · Substantial damageNTSB MKC68D0296Accident · No injuriesClosedCessna 172 · St Joseph, MOJul 6, 1967 · N8040B · Substantial damageNTSB MKC68F0244Accident · Minor injuriesClosedCessna 172 · Vandalia, MOJun 3, 1967 · N1491Y · Substantial damageNTSB MKC67D0537Accident · No injuriesClosedCessna 172F · Bridgeton, MOFeb 13, 1967 · N8164U · Substantial damageNTSB MKC67A0018Accident · 1 fatalClosedCessna 172E · Knox City, MOAug 28, 1966 · N3915S · DestroyedNTSB MKC67D0063Accident · No injuriesClosedCessna 172F · Kennett, MOJun 30, 1966 · N7871U · Substantial damageNTSB MKC67D0152Accident · No injuriesClosedCessna 172 · Piedmont, MOJun 22, 1966 · N4408L · Substantial damageNTSB MKC67F0028Accident · No injuriesClosedCessna 172 · Berger, MOJun 17, 1966 · N7287A · Substantial damageNTSB MKC67D0069Accident · No injuriesClosedCessna 172 · St.Charles, MOMay 28, 1966 · N5643A · Substantial damageNTSB MKC66D0585Accident · No injuriesClosedCessna 172 · Camdenton, MOMay 21, 1966 · N5597R · Substantial damageNTSB MKC66F0537Accident · No injuriesClosedMaule M-4 · Fredericktown, MOMay 2, 1966 · N4715T · Substantial damageNTSB MKC66F0528Accident · No injuriesClosedCessna 172 · St. Joseph, MOApr 2, 1966 · N5755R · Substantial damageNTSB MKC66D0490Accident · No injuriesClosedCessna 172 · Moberly, MOApr 2, 1966 · N5652T · Substantial damageNTSB MKC67D0001Accident · Minor injuriesClosedCessna 172F · Rich Fountain, MOMar 26, 1966 · N8703U · Substantial damageNTSB MKC66F0446Accident · No injuriesClosedCessna 172B · St.Louis, MOMar 19, 1966 · N8080X · Substantial damageNTSB MKC66D0530Accident · No injuriesClosedCessna 172 · Poplar Bluff, MOMar 16, 1966 · N1647Y · Substantial damageNTSB MKC66D0445Accident · No injuriesClosedCessna 172 · Macon, MOMar 6, 1966 · N2975U · Substantial damageNTSB MKC66D0425Accident · No injuriesClosedCessna 172 · Springfield, MOFeb 19, 1966 · N2852U · Substantial damageNTSB MKC66D0373Accident · No injuriesClosedCessna 170B · Kirksville, MOJan 2, 1966 · N1695D · Substantial damageNTSB MKC66D0290Accident · No injuriesClosedCessna 172 · Reed Springs, MOOct 23, 1965 · N7286T · Substantial damageNTSB MKC66D0257Accident · No injuriesClosedCessna 172 · Warrensburg, MOOct 13, 1965 · N5674R · Substantial damageNTSB MKC66D0156Accident · No injuriesClosedCessna 172 · Camdenton, MOAug 16, 1965 · N5305T · Substantial damageNTSB MKC66D0202Accident · No injuriesClosedCessna 170B · Carthage, MOAug 12, 1965 · N3489C · Substantial damageNTSB MKC66F0097Accident · Serious injuriesClosedCessna 172C · Ozark, MOJun 26, 1965 · N1626Y · Substantial damageNTSB MKC65D0052Accident · No injuriesClosedCessna 172 · Bowling Green, MOFeb 20, 1965 · N5455T · Substantial damageNTSB MKC65F0080Accident · No injuriesClosedCessna 172 · Kansas City, MOJan 25, 1965 · N5009A · Substantial damageNTSB MKC65F0026Accident · No injuriesClosedCessna 172 · Kansas City, MOJan 9, 1965 · N8040B · Substantial damageNTSB UNK65X1137Accident · No injuriesClosedCessna 172F · St Louis, MODec 26, 1964 · N8238U · Substantial damageNTSB UNK65X0796Accident · No injuriesClosedCessna 172 · East Prairie, MONov 22, 1964 · N6833A · Substantial damageNTSB UNK64X4097Accident · No injuriesClosedCessna 172E · Festus, MOSep 22, 1964 · N5347T · Substantial damageNTSB UNK64X1528Accident · No injuriesClosedCessna 172 · Harrisonville, MOApr 30, 1964 · N8455X · Substantial damageNTSB UNK64X0758Accident · No injuriesClosedCessna 170 · St Joseph, MOFeb 29, 1964 · N3492C · Substantial damageNTSB UNK64X0726Accident · No injuriesClosedCessna 172B · Harrisonville, MOFeb 28, 1964 · N7599X · Substantial damage