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.
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" DESCRun it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB CHI67D0205Accident · Minor injuriesClosedChampion 7EC · Urbana, ILNTSB MIA66F0534Accident · No injuriesClosedPiper PA-18 · Selma, ALNTSB CHI66F0780Accident · No injuriesClosedPiper PA-18 · Frankilin, INNTSB NYC66D0637Accident · No injuriesClosedAeronca 7FC · Coventry, RINTSB CHI67D0002Accident · No injuriesClosedLuscombe 8F · Ringwood, ILNTSB MKC66D0518Accident · Minor injuriesClosedChampion 7FC · White Bear Lk, MNNTSB CHI66D0729Accident · No injuriesClosedLuscombe 8F · Canton, OHNTSB SEA66D0292Accident · No injuriesClosedCessna 140 · Paisley, ORNTSB MKC66D0519Accident · No injuriesClosedLuscombe 8E · St. Charles, MONTSB MIA66D0476Accident · Minor injuriesClosedChampion 7FC · Millington, TNNTSB CHI66F0667Accident · No injuriesClosedChampion 7FC · Champaign, ILNTSB MKC66D0488Accident · No injuriesClosedAeronca 7CCM · Eveleth, MNNTSB FTW66F0579Accident · No injuriesClosedPiper PA-18 · Oak Grove, LANTSB FTW66F0537Accident · No injuriesClosedChampion 7FC · Kaplan, LANTSB CHI66F0607Accident · No injuriesClosedChampion 7FC · Circleville, OHNTSB CHI66F0630Accident · No injuriesClosedAlon A-2 · Waukegan, ILNTSB OAK66D0214Accident · No injuriesClosedChampion 7EC · Oakland, CANTSB CHI66F0698Accident · No injuriesClosedChampion 7FC · Savoy, ILNTSB LAX66F0256Accident · No injuriesClosedChampion 7FC · Santa Monica, CANTSB MIA66D0468Accident · No injuriesClosedCessna 120 · Jonesboro, GANTSB MKC66D0493Accident · No injuriesClosedLuscombe 8A · Baudette, MNNTSB ANC66A0033Accident · 2 fatalClosedPiper PA-18 · Anchorage, AKNTSB MIA66F0438Accident · Minor injuriesClosedChampion 7EC · Venice, FLNTSB MKC66D0432Accident · No injuriesClosedPiper PA-18 · Summit, SDNTSB FTW66F0532Accident · Minor injuriesClosedPiper J3 · Orange, TXNTSB CHI66F0572Accident · Minor injuriesClosedChampion 7FC · Bryan, OHNTSB MKC66D0469Accident · No injuriesClosedChanpion 7FC · Hopkins, MNNTSB CHI66D0537Accident · No injuriesClosedCessna 140 · Petersburg, MINTSB MKC66D0417Accident · No injuriesClosedPiper PA-11 · Rugby, ND