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.
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" 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 FTW69O0004Accident · Minor injuriesClosedCessna 182 · Zaragoza, MexicoNTSB FTW69F0167Accident · No injuriesClosedCessna 180 · El Paso, TXNTSB MKC69D0181Accident · No injuriesClosedCessna 182 · Pratt, KSNTSB DIA69D0065Accident · No injuriesClosedCessna 182 · Norfolk, VANTSB OAK69D0138Accident · No injuriesClosedCessna 182 · Santa Rosa, CANTSB NYC69D0171Accident · No injuriesClosedCessna 180 · Beaver Falls, PANTSB NYC69F0132Accident · No injuriesClosedCessna 310 · Pittstown, NJNTSB DEN69D0082Accident · No injuriesClosedCessna 182K · Albuquerque, NMNTSB ANC69D0093Accident · No injuriesClosedCessna 180A · Seward, AKNTSB ANC69D0059Accident · No injuriesClosedCessna 180 · Anchorage, AKNTSB NYC69F0150Accident · No injuriesClosedCessna 182A · So.Vineland, NJNTSB MKC69D0122Accident · No injuriesClosedCessna 182K · Arthur, NENTSB FTW69F0172Accident · No injuriesClosedCessna 182 · Corpus Christ, TXNTSB OAK69F0092Accident · Minor injuriesClosedCessna 182 · Kamuela, HINTSB NYC69D0138Accident · No injuriesClosedCessna 182 · Northampton, MANTSB CHI69F0197Accident · No injuriesClosedCessna 182 · Orion, MINTSB MIA69D0160Accident · Minor injuriesClosedCessna 182 · Toccoa, GANTSB DEN69D0120Accident · No injuriesClosedCessna 182 · Casper, WYNTSB DEN69F0066Accident · Minor injuriesClosedCessna 182K · Mountainair, NMNTSB OAK69D0099Accident · No injuriesClosedCessna 182 · Napa, CANTSB CHI69D0131Accident · No injuriesClosedCessna 180 · Sabina, OHNTSB MIA69F0162Accident · No injuriesClosedCessna 182K · York, SCNTSB CHI69F0229Accident · No injuriesClosedCessna 182K · Somerset, KYNTSB ANC69D0042Accident · Minor injuriesClosedCessna 180 · Kenai, AKNTSB SEA69D0108Accident · No injuriesClosedCessna 180 · Glendive, MTNTSB MIA69D0253Accident · Minor injuriesClosedCessna 182H · Chamblee, GANTSB LAX69F0127Accident · No injuriesClosedCessna 182 · Fullerton, CANTSB MKC69F0087Accident · No injuriesClosedCessna 188 · Elgin, NENTSB MKC69D0140Accident · No injuriesClosedCessna 182 · Iowa City, IANTSB FTW69D0151Accident · No injuriesClosedCessna 182A · Lexington, OKNTSB DEN69D0098Accident · No injuriesClosedCessna 150E · Aurora, CONTSB MKC69D0109Accident · No injuriesClosedCessna 188 · Ulysses, KSNTSB FTW69D0195Accident · No injuriesClosedCessna 180 · Dripping Spgs, TXNTSB CHI69D0273Accident · No injuriesClosedCessna 182 · Carrollton, KYNTSB MIA69D0082Accident · No injuriesClosedCessna 182L · Muscle Shoals, ALNTSB FTW69D0082Accident · No injuriesClosedCessna 182 · Pond Creek, OKNTSB CHI69D0151Accident · No injuriesClosedCessna 310C · Richmond, INNTSB MIA69D0131Accident · No injuriesClosedCessna 182L · Jacksonville, FLNTSB SEA68D0082Accident · No injuriesClosedCessna 182 · Kalispell, MTNTSB MKC69D0149Accident · No injuriesClosedCessna 182 · Monett, MONTSB CHI69F0130Accident · No injuriesClosedCessna 182 · Hebron, OHNTSB NYC69F0092Accident · No injuriesClosedCessna 180 · Millbrook, NYNTSB MIA69D0229Accident · No injuriesClosedCessna 180 · Fitzgerald, GANTSB FTW69D0056Accident · No injuriesClosedCessna 180 · Houma, LANTSB MIA69D0075Accident · No injuriesClosedCessna 180 · Alexander Cty, ALNTSB DIA69F0151Accident · Serious injuriesClosedCessna 182L · Nitro, WVNTSB OAK69D0091Accident · No injuriesClosedCessna 182 · Annapolis, CANTSB FTW69D0130Accident · No injuriesClosedCessna 188 · Eagle Pass, TXNTSB NYC69D0083Accident · No injuriesClosedCessna 182 · Mansfield, MANTSB DEN69F0065Accident · No injuriesClosedCessna 180 · Las Cruces, NM