NTSB investigations: Continental O-470 series, 1968

181 cases on aircraft whose registry engine model is Continental O-470 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\") = 1968
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17026'))
  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 FTW69O0004Accident · Minor injuriesClosedCessna 182 · Zaragoza, MexicoSep 5, 1968 · N6028B · Substantial damageNTSB FTW69F0167Accident · No injuriesClosedCessna 180 · El Paso, TXSep 4, 1968 · N4994A · Substantial damageNTSB MKC69D0181Accident · No injuriesClosedCessna 182 · Pratt, KSSep 2, 1968 · N2811F · Substantial damageNTSB DIA69D0065Accident · No injuriesClosedCessna 182 · Norfolk, VASep 2, 1968 · N4738D · Substantial damageNTSB OAK69D0138Accident · No injuriesClosedCessna 182 · Santa Rosa, CASep 1, 1968 · N2504R · Substantial damageNTSB NYC69D0171Accident · No injuriesClosedCessna 180 · Beaver Falls, PASep 1, 1968 · N2493C · Substantial damageNTSB NYC69F0132Accident · No injuriesClosedCessna 310 · Pittstown, NJAug 30, 1968 · N2199C · Substantial damageNTSB DEN69D0082Accident · No injuriesClosedCessna 182K · Albuquerque, NMAug 30, 1968 · N2625Q · Substantial damageNTSB ANC69D0093Accident · No injuriesClosedCessna 180A · Seward, AKAug 30, 1968 · N9792B · Substantial damageNTSB ANC69D0059Accident · No injuriesClosedCessna 180 · Anchorage, AKAug 30, 1968 · N2757X · Substantial damageNTSB NYC69F0150Accident · No injuriesClosedCessna 182A · So.Vineland, NJAug 27, 1968 · N6340B · DestroyedNTSB MKC69D0122Accident · No injuriesClosedCessna 182K · Arthur, NEAug 25, 1968 · N2679R · Substantial damageNTSB FTW69F0172Accident · No injuriesClosedCessna 182 · Corpus Christ, TXAug 25, 1968 · N42279 · Substantial damageNTSB OAK69F0092Accident · Minor injuriesClosedCessna 182 · Kamuela, HIAug 23, 1968 · N5332B · DestroyedNTSB NYC69D0138Accident · No injuriesClosedCessna 182 · Northampton, MAAug 21, 1968 · N3538F · Substantial damageNTSB CHI69F0197Accident · No injuriesClosedCessna 182 · Orion, MIAug 19, 1968 · N5095D · Substantial damageNTSB MIA69D0160Accident · Minor injuriesClosedCessna 182 · Toccoa, GAAug 18, 1968 · N6018B · Substantial damageNTSB DEN69D0120Accident · No injuriesClosedCessna 182 · Casper, WYAug 15, 1968 · N9993T · Substantial damageNTSB DEN69F0066Accident · Minor injuriesClosedCessna 182K · Mountainair, NMAug 12, 1968 · N2494Q · Substantial damageNTSB OAK69D0099Accident · No injuriesClosedCessna 182 · Napa, CAAug 11, 1968 · N3397R · Substantial damageNTSB CHI69D0131Accident · No injuriesClosedCessna 180 · Sabina, OHAug 11, 1968 · N1537C · Substantial damageNTSB MIA69F0162Accident · No injuriesClosedCessna 182K · York, SCAug 9, 1968 · N2705Q · Substantial damageNTSB CHI69F0229Accident · No injuriesClosedCessna 182K · Somerset, KYAug 8, 1968 · N2472Q · Substantial damageNTSB ANC69D0042Accident · Minor injuriesClosedCessna 180 · Kenai, AKAug 8, 1968 · N5231D · Substantial damageNTSB SEA69D0108Accident · No injuriesClosedCessna 180 · Glendive, MTAug 7, 1968 · N5224D · Substantial damageNTSB MIA69D0253Accident · Minor injuriesClosedCessna 182H · Chamblee, GAAug 6, 1968 · N2402X · Substantial damageNTSB LAX69F0127Accident · No injuriesClosedCessna 182 · Fullerton, CAAug 5, 1968 · N8878X · Substantial damageNTSB MKC69F0087Accident · No injuriesClosedCessna 188 · Elgin, NEAug 4, 1968 · N9803V · Substantial damageNTSB MKC69D0140Accident · No injuriesClosedCessna 182 · Iowa City, IAAug 4, 1968 · N3042F · Substantial damageNTSB FTW69D0151Accident · No injuriesClosedCessna 182A · Lexington, OKAug 4, 1968 · N6123B · Substantial damageNTSB DEN69D0098Accident · No injuriesClosedCessna 150E · Aurora, COAug 4, 1968 · N3918U · Substantial damageNTSB MKC69D0109Accident · No injuriesClosedCessna 188 · Ulysses, KSAug 2, 1968 · N8086V · Substantial damageNTSB FTW69D0195Accident · No injuriesClosedCessna 180 · Dripping Spgs, TXAug 2, 1968 · N4596B · Substantial damageNTSB CHI69D0273Accident · No injuriesClosedCessna 182 · Carrollton, KYAug 1, 1968 · N5684B · Substantial damageNTSB MIA69D0082Accident · No injuriesClosedCessna 182L · Muscle Shoals, ALJul 31, 1968 · N3456R · Substantial damageNTSB FTW69D0082Accident · No injuriesClosedCessna 182 · Pond Creek, OKJul 28, 1968 · N3579U · Substantial damageNTSB CHI69D0151Accident · No injuriesClosedCessna 310C · Richmond, INJul 28, 1968 · N2652C · Substantial damageNTSB MIA69D0131Accident · No injuriesClosedCessna 182L · Jacksonville, FLJul 27, 1968 · N42120 · Substantial damageNTSB SEA68D0082Accident · No injuriesClosedCessna 182 · Kalispell, MTJul 26, 1968 · N3530U · Substantial damageNTSB MKC69D0149Accident · No injuriesClosedCessna 182 · Monett, MOJul 22, 1968 · N8482S · Substantial damageNTSB CHI69F0130Accident · No injuriesClosedCessna 182 · Hebron, OHJul 21, 1968 · N3208S · Substantial damageNTSB NYC69F0092Accident · No injuriesClosedCessna 180 · Millbrook, NYJul 20, 1968 · N2388C · Substantial damageNTSB MIA69D0229Accident · No injuriesClosedCessna 180 · Fitzgerald, GAJul 20, 1968 · N1606C · Substantial damageNTSB FTW69D0056Accident · No injuriesClosedCessna 180 · Houma, LAJul 20, 1968 · N751MC · Substantial damageNTSB MIA69D0075Accident · No injuriesClosedCessna 180 · Alexander Cty, ALJul 19, 1968 · N4971A · 2 aircraft · Minor damageNTSB DIA69F0151Accident · Serious injuriesClosedCessna 182L · Nitro, WVJul 17, 1968 · N42188 · DestroyedNTSB OAK69D0091Accident · No injuriesClosedCessna 182 · Annapolis, CAJul 13, 1968 · N3127S · Substantial damageNTSB FTW69D0130Accident · No injuriesClosedCessna 188 · Eagle Pass, TXJul 9, 1968 · N9778V · Substantial damageNTSB NYC69D0083Accident · No injuriesClosedCessna 182 · Mansfield, MAJul 5, 1968 · N42578 · Substantial damageNTSB DEN69F0065Accident · No injuriesClosedCessna 180 · Las Cruces, NMJul 5, 1968 · N180Y · Substantial damage