NTSB investigations: Continental O-470 series, WY
92 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 c.\"eventStateOrRegion\" = 'WY' AND c.\"eventCountry\" = 'USA'
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 c."eventStateOrRegion" = 'WY' AND c."eventCountry" = 'USA'
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 DEN76DTC40Accident · No injuriesClosedCessna 182 · Cheyenne, WYNTSB DEN76DTC10Accident · No injuriesClosedCessna 180 · Wheatland, WYNTSB DEN75FTC25Accident · No injuriesClosedCessna 182K · Casper, WYNTSB DEN75FTC16Accident · No injuriesClosedCessna 180H · Gillette, WYNTSB DEN75FTC12Accident · Minor injuriesClosedCessna 182 · Gillette, WYNTSB DEN74DTC34Accident · No injuriesClosedCessna 182J · Wheatland, WYNTSB DEN74DTC28Accident · No injuriesClosedCessna 182L · Cheyenne, WYNTSB DEN74FTC11Accident · Minor injuriesClosedCessna 411 · Farson, WYNTSB DEN73FTC27Accident · No injuriesClosedCessna 180 · Kemmerer, WYNTSB DEN73DTC22Accident · No injuriesClosedCessna 180A · Glendo, WYNTSB DEN73DTC17Accident · No injuriesClosedCessna 180 · Gillette, WYNTSB DEN73DTC10Accident · No injuriesClosedCessna 180B · Glendo, WYNTSB DEN73AD007Accident · 3 fatalClosedCessna 180 · Casper, WYNTSB DEN72DTC06Accident · No injuriesClosedCessna 182C · Lusk, WYNTSB DEN72DTC01Accident · No injuriesClosedCessna 182E · Gillette, WYNTSB DEN71DXA07Accident · No injuriesClosedCessna 180 · Cody, WYNTSB DEN70DXA09Accident · No injuriesClosedCessna 182 · Laramie, WYNTSB DEN70D0047Accident · No injuriesClosedCessna 182 · Cody, WYNTSB DEN70F0077Accident · No injuriesClosedCessna 180 · Casper, WYNTSB DEN70D0028Accident · No injuriesClosedCessna 182 · Lusk, WYNTSB DEN69D0239Accident · No injuriesClosedCessna 180H · Riverton, WYNTSB DEN69D0201Accident · No injuriesClosedCessna 182C · Casper, WYNTSB DEN69D0120Accident · No injuriesClosedCessna 182 · Casper, WYNTSB DEN68D0164Accident · No injuriesClosedCessna 180 · Casper, WYNTSB DEN68D0064Accident · No injuriesClosedCessna 182 · Riverton, WYNTSB DEN68F0080Accident · No injuriesClosedCessna 180 · Lander, WYNTSB DEN68D0031Accident · No injuriesClosedCessna 180 · Moorcroft, WYNTSB DEN67D0248Accident · No injuriesClosedCessna 182C · Lander, WYNTSB DEN67D0154Accident · No injuriesClosedCessna 182 · Rock River, WYNTSB DEN67D0096Accident · No injuriesClosedCessna 180 · Kemmerer, WYNTSB DEN66D0307Accident · No injuriesClosedCessna 182 · Big Piney, WYNTSB DEN66F0213Accident · No injuriesClosedCessna 180 · Rock Springs, WYNTSB DEN66D0191Accident · No injuriesClosedCessna 182 · Frannie, WYNTSB DEN66F0125Accident · Minor injuriesClosedCessna 182C · Laramie, WYNTSB DEN66D0126Accident · Minor injuriesClosedBellanca 14-19 · Douglas, WYNTSB DEN66D0124Accident · No injuriesClosedCessna 180 · Medicine Bow, WYNTSB DEN65D0087Accident · No injuriesClosedCessna 182 · Pine Bluffs, WYNTSB DEN65F0019Accident · No injuriesClosedCessna 180 · Lander, WYNTSB UNK64X3225Accident · No injuriesClosedCessna 182A · Rock Springs, WYNTSB UNK64X0903Accident · No injuriesClosedCessna 180 · Cheyenne, WYNTSB UNK64X0451Accident · No injuriesClosedCessna 310B · Casper, WYNTSB UNK64X0213Accident · 1 fatalClosedCessna 182F · Thernopolis, WY