NTSB investigations: Continental O-470 series, 1978
161 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\") = 1978
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.
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") = 1978
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" 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 ANC78FA069Accident · 2 fatalClosedCessna 182Q · Ketchikan, AKNTSB FTW78DRD52Accident · Minor injuriesClosedCessna 180F · Buras, LANTSB OAK78FA044Accident · 1 fatalClosedCessna 182Q · Eureka, CANTSB IAD78FA096Accident · No injuriesClosedCessna 180 · Roanoke, VANTSB MKC78DCJ41Accident · No injuriesClosedCessna 182 · Aurora, NENTSB IAD78FKW10Accident · No injuriesClosedCessna 182 · Westmoreland, TNNTSB CHI78FET33Accident · No injuriesClosedCessna 182M · Chesterton, INNTSB ANC78DA068Accident · No injuriesClosedCessna 180C · Pt. Possession, AKNTSB MKC78DER83Accident · No injuriesClosedCessna 180B · Eveleth, MNNTSB NYC78FNA41Accident · No injuriesClosedCessna 182 · Hyannis, MANTSB OAK78DVM36Accident · No injuriesClosedCessna 182 · Salinas, CANTSB NYC78FNC42Accident · Minor injuriesClosedCessna 182D · Hollis, NHNTSB FTW78DRA34Accident · No injuriesClosedCessna 180K · Houston, TXNTSB LAX78FUG41Accident · No injuriesClosedCessna 182E · Temecula, CANTSB LAX78FUA20Accident · No injuriesClosedCessna 180 · Long Beach, CANTSB FTW78FPJ31Accident · No injuriesClosedCessna 182 · Cushing, OKNTSB FTW78FA065Accident · 3 fatalClosedCessna 310B · Cameron, LANTSB CHI78FEM29Accident · No injuriesClosedCessna 180 · Otsego Lake, MINTSB IAD78DLQ25Accident · No injuriesClosedCessna 182F · Flemingsburg, KYNTSB NYC78FHM20Accident · Serious injuriesClosedCessna 182 · Fairfield, NJNTSB MKC78FER67Accident · Minor injuriesClosedCessna 180J · Goodland, MNNTSB MIA78DLA42Accident · No injuriesClosedCessna 182 · Gainesville, FLNTSB LAX78FVA21Accident · No injuriesClosedCessna 182 · Avalon, CANTSB OAK78FAO36Accident · 4 fatalClosedCessna 182A · Red Bluff, CANTSB OAK78DVG55Accident · No injuriesClosedCessna 182 · Fair Oaks, CANTSB LAX78FA058Accident · 1 fatalClosedCessna 182 · San Diego, CANTSB ANC78DAG82Accident · No injuriesClosedCessna 180 · Bethel, AKNTSB DEN78FTC29Accident · Serious injuriesClosedCessna 182 · Tipton, WYNTSB MIA78FLD57Accident · Minor injuriesClosedCessna 180H · New Smyrna Bch, FLNTSB MIA78FLA41Accident · No injuriesClosedCessna 180 · Jacksonville, FLNTSB OAK78FA035Accident · 4 fatalClosedCessna 182P · S Lake Tahoe, CANTSB IAD78FIJ15Accident · Minor injuriesClosedCessna 182E · Charleston, WVNTSB MKC78FCG35Accident · No injuriesClosedCessna 182 · Columbia, MONTSB FTW78DQG47Accident · No injuriesClosedCessna 182 · Tulia, TXNTSB FTW78DRJ21Accident · No injuriesClosedCessna 180J · Shreveport, LANTSB ANC78DA041Accident · No injuriesClosedCessna 180H · Aniakchak Bay, AKNTSB LAX78DUJ72Accident · Minor injuriesClosedCessna 182 · Page, AZNTSB SEA78FA036Accident · 1 fatalClosedCessna 182A · Featherville, IDNTSB MIA78DLA37Accident · No injuriesClosedCessna 182 · Fargo, GANTSB IAD78DID08Accident · No injuriesClosedBeech T-34B · Dillwyn, VANTSB ANC78DAG67Accident · No injuriesClosedCessna 180A · Dillingham, AKNTSB FTW78DQG33Accident · No injuriesClosedCessna 182 · Rotan, TXNTSB CHI78FEK22Accident · No injuriesClosedCessna 182 · Columbus, OHNTSB IAD78FIJ12Accident · Minor injuriesClosedCessna 182L · Man, WVNTSB MIA78DKG46Accident · Serious injuriesClosedCessna 182 · Atlanta, GANTSB SEA78DYP30Accident · No injuriesClosedCessna 180 · Kahlotus, WANTSB LAX78AA050Accident · 4 fatalClosedCessna 310 · Irvine, CANTSB UNK78X0122Accident · 2 fatalClosedCessna 180C · Numazi, JANTSB FTW78DPJ25Accident · No injuriesClosedCessna 182 · Lawton, OKNTSB MKC78FCG31Accident · No injuriesClosedCessna 180H · Warrensburg, MO