NTSB investigations: Continental O-470 series, KS
115 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\" = 'KS' 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" = 'KS' 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 MKC76FCG31Accident · Serious injuriesClosedCessna 180 · Edgerton, KSNTSB MKC76FCG07Accident · Minor injuriesClosedBeech D45 · Olathe, KSNTSB MKC75DCQ48Accident · No injuriesClosedCessna 188 · Selden, KSNTSB MKC75DCQ42Accident · No injuriesClosedCessna 182 · Elkhart, KSNTSB MKC75DC001Accident · No injuriesClosedCessna 180 · Wichita, KSNTSB MKC73DCQ38Accident · No injuriesClosedCessna 188 · North Fowler, KSNTSB MKC73DCQ32Accident · No injuriesClosedCessna 182A · Yates Center, KSNTSB MKC73FCQ34Accident · No injuriesClosedCessna 182L · Scandia, KSNTSB MKC73DCQ04Accident · No injuriesClosedCessna 180 · Newton, KSNTSB MKC73FCO02Accident · No injuriesClosedBeech H35 · Newton, KSNTSB MKC73DCQ01Accident · No injuriesClosedCessna 182M · Wichita, KSNTSB MKC72DCQ63Accident · Minor injuriesClosedCessna 182 · Russell, KSNTSB MKC72DCQ38Accident · No injuriesClosedCessna 182L · Wichita, KSNTSB MKC72FCQ34Accident · No injuriesClosedCessna 180 · Valley Cntr, KSNTSB MKC72FCQ32Accident · No injuriesClosedCessna 182N · Wichita, KSNTSB MKC72FCQ24Accident · No injuriesClosedCessna 182J · Arkansas Cty, KSNTSB MKC71DCG52Accident · Minor injuriesClosedCessna 182 · Olathe, KSNTSB MKC71FCQ31Accident · No injuriesClosedCessna 180 · Longton, KSNTSB MKC71DCQ24Accident · No injuriesClosedCessna 182M · Manhattan, KSNTSB MKC71FCG34Accident · No injuriesClosedCessna 310 · Lawrence, KSNTSB MKC71DCQ21Accident · No injuriesClosedCessna 180 · Sharon Sprgs, KSNTSB MKC71FCG04Accident · No injuriesClosedCessna 182 · Kansas City, KSNTSB MKC70FCQ20Accident · No injuriesClosedCessna 180B · Syracuse, KSNTSB MKC70DCQ17Accident · No injuriesClosedCessna 182M · Wichita, KSNTSB MKC70DCG16Accident · No injuriesClosedCessna 182 · Topeka, KSNTSB MKC70D0268Accident · No injuriesClosedCessna 182 · Topeka, KSNTSB MKC70D0115Accident · No injuriesClosedCessna 182 · Leawood, KSNTSB MKC69D0449Accident · No injuriesClosedCessna 182K · Augusta, KSNTSB MKC69D0411Accident · No injuriesClosedCessna 182M · Wichita, KSNTSB MKC69F0356Accident · Minor injuriesClosedCessna 210 · Augusta, KSNTSB MKC69D0430Accident · No injuriesClosedCessna 182B · Bonner Sprgs, KSNTSB MKC69D0259Accident · No injuriesClosedCessna 182L · Garden City, KSNTSB MKC69A0015Accident · 2 fatalClosedCessna 182B · Olathe, KSNTSB MKC69D0181Accident · No injuriesClosedCessna 182 · Pratt, KSNTSB MKC69D0109Accident · No injuriesClosedCessna 188 · Ulysses, KSNTSB MKC69D0055Accident · No injuriesClosedCessna 182 · Leawood, KSNTSB MKC68D0502Accident · No injuriesClosedBellanca 14-192 · Moscow, KSNTSB MKC68F0450Accident · No injuriesClosedCessna 182J · Kansas City, KSNTSB MKC68F0324Accident · No injuriesClosedCessna 182K · Augusta, KSNTSB MKC68D0381Accident · No injuriesClosedCessna 182 · Bonner Sprgs, KSNTSB MKC68A0017Accident · 2 fatalClosedCessna 182D · Grenola, KSNTSB MKC68D0198Accident · No injuriesClosedCessna 182H · Hammond, KSNTSB MKC67A0089Accident · 1 fatalClosedCessna 188 · Sharon Sprgs, KSNTSB MKC67D0517Accident · No injuriesClosedBellanca 14-19 · Liberal, KSNTSB MKC67D0495Accident · No injuriesClosedCessna 182A · Kinsley, KSNTSB MKC67F0448Accident · No injuriesClosedCessna 182 · Norton, KSNTSB MKC67D0371Accident · No injuriesClosedCessna 310D · Olathe, KSNTSB MKC67D0317Accident · No injuriesClosedCessna 180 · Basehor, KSNTSB MKC67D0222Accident · No injuriesClosedCessna 182 · Leawood, KSNTSB MKC67D0089Accident · No injuriesClosedCessna 182 · Larned, KS