NTSB investigations: Continental 0-300 series, NC

68 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\" = 'NC' 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 IAD70DKM08Accident · No injuriesClosedCessna 172 · Statesville, NCMay 11, 1970 · N7079A · Substantial damageNTSB IAD70D0121Accident · No injuriesClosedCessna 172 · Monroe, NCDec 29, 1969 · N5775A · Substantial damageNTSB DIA69D0183Accident · No injuriesClosedCessna 172 · Rutherfordton, NCMay 11, 1969 · N7465A · Substantial damageNTSB DIA69D0157Accident · Minor injuriesClosedMaule M-4 · Lillington, NCMar 15, 1969 · N4731T · Substantial damageNTSB DIA69F0144Accident · Serious injuriesClosedCessna 172 · Mooresville, NCFeb 10, 1969 · N371LA · Substantial damageNTSB DIA69D0077Accident · Minor injuriesClosedCessna 172 · Raleigh, NCSep 26, 1968 · N3976L · Substantial damageNTSB DIA68D0186Accident · No injuriesClosedCessna 172 · Rose Hill, NCMar 22, 1968 · N6342E · Substantial damageNTSB DIA68D0102Accident · No injuriesClosedCessna 172 · Davis, NCSep 30, 1967 · N4117L · Substantial damageNTSB DIA68A0015Accident · No injuriesClosedCessna 172H · Asheboro, NCSep 22, 1967 · N3244L · Substantial damageNTSB DIA68D0050Accident · No injuriesClosedCessna 172G · Chapel Hill, NCJul 20, 1967 · N5899R · Substantial damageNTSB DIA68F0032Accident · Serious injuriesClosedCessna 172 · Greenville, NCJun 12, 1967 · N1605F · DestroyedNTSB DIA67F0091Accident · Minor injuriesClosedCessna 172G · Canton, NCMay 7, 1967 · N4374L · Substantial damageNTSB DIA67D0004Accident · No injuriesClosedCessna 172 · Long Beach, NCDec 26, 1966 · N8062B · Substantial damageNTSB MIA66D0612Accident · No injuriesClosedCessna 172 · High Point, NCJun 21, 1966 · N7315T · Substantial damageNTSB MIA66F0563Accident · Minor injuriesClosedCessna 172 · Hendersonville, NCJun 2, 1966 · N5498R · Substantial damageNTSB MIA66F0519Accident · Minor injuriesClosedCessna 172 · Clemmons, NCMay 5, 1966 · N2815U · Substantial damageNTSB MIA66F0187Accident · Serious injuriesClosedCessna 170B · Grimesland, NCAug 30, 1965 · N8033A · Substantial damageNTSB UNK64X3725Accident · No injuriesClosedCessna 172 · Candor, NCSep 1, 1964 · N1543Y · Substantial damage