NTSB investigations: Continental C90 series, 1966

79 cases on aircraft whose registry engine model is Continental C90 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\") = 1966
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17009'))
  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 CHI67D0205Accident · Minor injuriesClosedChampion 7EC · Urbana, ILMay 16, 1966 · N9904Y · Substantial damageNTSB MIA66F0534Accident · No injuriesClosedPiper PA-18 · Selma, ALMay 13, 1966 · N9132D · Substantial damageNTSB CHI66F0780Accident · No injuriesClosedPiper PA-18 · Frankilin, INMay 10, 1966 · N5466H · Substantial damageNTSB NYC66D0637Accident · No injuriesClosedAeronca 7FC · Coventry, RIMay 4, 1966 · N7583B · Substantial damageNTSB CHI67D0002Accident · No injuriesClosedLuscombe 8F · Ringwood, ILMay 1, 1966 · N2000B · Substantial damageNTSB MKC66D0518Accident · Minor injuriesClosedChampion 7FC · White Bear Lk, MNApr 24, 1966 · N9970Y · Substantial damageNTSB CHI66D0729Accident · No injuriesClosedLuscombe 8F · Canton, OHApr 17, 1966 · N1394B · Substantial damageNTSB SEA66D0292Accident · No injuriesClosedCessna 140 · Paisley, ORApr 15, 1966 · N3713V · Substantial damageNTSB MKC66D0519Accident · No injuriesClosedLuscombe 8E · St. Charles, MOApr 2, 1966 · N2960K · Substantial damageNTSB MIA66D0476Accident · Minor injuriesClosedChampion 7FC · Millington, TNMar 27, 1966 · N7534E · Substantial damageNTSB CHI66F0667Accident · No injuriesClosedChampion 7FC · Champaign, ILMar 25, 1966 · N7690E · Substantial damageNTSB MKC66D0488Accident · No injuriesClosedAeronca 7CCM · Eveleth, MNMar 21, 1966 · N2924E · Substantial damageNTSB FTW66F0579Accident · No injuriesClosedPiper PA-18 · Oak Grove, LAMar 19, 1966 · N8176D · Substantial damageNTSB FTW66F0537Accident · No injuriesClosedChampion 7FC · Kaplan, LAMar 15, 1966 · N4851E · Substantial damageNTSB CHI66F0607Accident · No injuriesClosedChampion 7FC · Circleville, OHMar 14, 1966 · N9890B · Substantial damageNTSB CHI66F0630Accident · No injuriesClosedAlon A-2 · Waukegan, ILMar 11, 1966 · N6357V · Substantial damageNTSB OAK66D0214Accident · No injuriesClosedChampion 7EC · Oakland, CAMar 9, 1966 · N9986Y · Substantial damageNTSB CHI66F0698Accident · No injuriesClosedChampion 7FC · Savoy, ILMar 9, 1966 · N7693E · Substantial damageNTSB LAX66F0256Accident · No injuriesClosedChampion 7FC · Santa Monica, CAMar 2, 1966 · N9839Y · Substantial damageNTSB MIA66D0468Accident · No injuriesClosedCessna 120 · Jonesboro, GAMar 1, 1966 · N2918N · Substantial damageNTSB MKC66D0493Accident · No injuriesClosedLuscombe 8A · Baudette, MNFeb 27, 1966 · N9929C · Substantial damageNTSB ANC66A0033Accident · 2 fatalClosedPiper PA-18 · Anchorage, AKFeb 20, 1966 · N8696D · 2 aircraft · Substantial damageNTSB MIA66F0438Accident · Minor injuriesClosedChampion 7EC · Venice, FLFeb 19, 1966 · N4334C · Substantial damageNTSB MKC66D0432Accident · No injuriesClosedPiper PA-18 · Summit, SDFeb 18, 1966 · N6980D · Substantial damageNTSB FTW66F0532Accident · Minor injuriesClosedPiper J3 · Orange, TXFeb 13, 1966 · N24934 · Substantial damageNTSB CHI66F0572Accident · Minor injuriesClosedChampion 7FC · Bryan, OHFeb 12, 1966 · N7540E · Substantial damageNTSB MKC66D0469Accident · No injuriesClosedChanpion 7FC · Hopkins, MNFeb 5, 1966 · N9072B · Substantial damageNTSB CHI66D0537Accident · No injuriesClosedCessna 140 · Petersburg, MIFeb 5, 1966 · N2473V · Substantial damageNTSB MKC66D0417Accident · No injuriesClosedPiper PA-11 · Rugby, NDFeb 1, 1966 · N87986 · Substantial damage