NTSB investigations: Continental 0-200 series, KS
143 cases on aircraft whose registry engine model is Continental 0-200 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 ('17020'))
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 ('17020'))
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 MKC79DCQ17Accident · No injuriesClosedCessna 150 · Benton, KSNTSB MKC79FCG31Accident · No injuriesClosedCessna 150 · Olathe, KSNTSB MKC79DCQ12Accident · No injuriesClosedCessna 150 · Kinsley, KSNTSB MKC78FCQ36Accident · 1 fatalClosedVari-Eze · Liberal, KSNTSB MKC78DCG20Accident · No injuriesClosedCessna 150M · Lawrence, KSNTSB MKC78DCQ05Accident · Minor injuriesClosedCessna 150 · Wellington, KSNTSB MKC77DCQ51Accident · No injuriesClosedCessna 150 · Greensburg, KSNTSB MKC77DCQ38Accident · Minor injuriesClosedCessna 150 · Maize, KSNTSB MKC77FCG17Accident · No injuriesClosedCessna 150M · Olathe, KSNTSB MKC77DCQ21Accident · No injuriesClosedCessna 150 · Manhattan, KSNTSB MKC77DCG12Accident · No injuriesClosedCessna 150 · Lyndon, KSNTSB MKC77DCQ11Accident · Minor injuriesClosedCessna 150 · Emporia, KSNTSB MKC76DCH01Accident · No injuriesClosedCessna 150 · Kansas City, KSNTSB MKC76DCQ72Accident · No injuriesClosedCessna 150 · Clyde, KSNTSB MKC76DCQ74Accident · No injuriesClosedCessna 150 · Clay Center, KSNTSB MKC76DCQ68Accident · No injuriesClosedCessna 150 · Flush, KSNTSB MKC76DCQ64Accident · No injuriesClosedCessna 150G · Oxford, KSNTSB MKC76DCQ60Accident · No injuriesClosedCessna 150 · Colby, KSNTSB MKC76FCQ54Accident · No injuriesClosedCessna A150M · Wichita, KSNTSB MKC76DCG68Accident · No injuriesClosedCessna 150 · Garnett, KSNTSB MKC76DCG57Accident · No injuriesClosedCessna 150L · Lawrence, KSNTSB MKC76DCQ15Accident · No injuriesClosedCessna 150 · Council Grove, KSNTSB MKC76DCQ10Accident · No injuriesClosedBaby Ace Corbin · Tennis, KSNTSB MKC75DCG45Accident · Minor injuriesClosedCessna 150 · Meriden, KSNTSB MKC75FCQ38Accident · No injuriesClosedCessna 150 · Pratt, KSNTSB MKC75DCG20Accident · No injuriesClosedCessna 150 · Olathe, KSNTSB MKC74AK040Accident · 2 fatalClosedCessna 150J · Pittsburg, KSNTSB MKC74DCG19Accident · No injuriesClosedCessna 150 · Lawrence, KSNTSB MKC74DCG16Accident · No injuriesClosedCessna 150L · Pleasanton, KSNTSB MKC74DCQ02Accident · No injuriesClosedCessna 150 · Ashland, KSNTSB MKC73DCQ21Accident · Minor injuriesClosedCessna 150J · Derby, KSNTSB MKC73DCQ16Accident · No injuriesClosedCessna 150D · Great Bend, KSNTSB MKC73FCQ05Accident · No injuriesClosedCessna A150K · Oakley, KSNTSB MKC73FCQ10Accident · No injuriesClosedCessna 150 · Augusta, KSNTSB MKC72DCQ60Accident · Serious injuriesClosedCessna 150 · Phillipsburg, KSNTSB MKC72FCQ52Accident · Minor injuriesClosedCessna 150L · Augusta, KSNTSB MKC72DCQ53Accident · Minor injuriesClosedCessna 150 · Mcpherson, KSNTSB MKC72DCQ37Accident · No injuriesClosedCessna 150L · Clay Center, KSNTSB MKC72DCQ23Accident · No injuriesClosedCessna 150 · Med Lodge, KSNTSB MKC72DC014Accident · No injuriesClosedCessna 150 · Stafford, KSNTSB MKC71DCG65Accident · No injuriesClosedCessna 150H · Stillwell, KSNTSB MKC71AK012Accident · 2 fatalClosedCessna 150G · Stanley, KSNTSB MKC71DCQ03Accident · No injuriesClosedCessna 150 · Dodge City, KSNTSB MKC70DCG29Accident · No injuriesClosedCessna 150 · Eudora, KSNTSB MKC70DCG23Accident · No injuriesClosedCessna 150 · Gardner, KSNTSB MKC70DCQ18Accident · No injuriesClosedCessna 150H · Goodland, KSNTSB MKC70DCG13Accident · No injuriesClosedCessna 150 · Atchison, KSNTSB MKC70F0304Accident · Minor injuriesClosedCessna 150 · Leawood, KSNTSB MKC70D0001Accident · Minor injuriesClosedCessna 150 · Ottawa, KSNTSB MKC69D0367Accident · No injuriesClosedCessna 150J · Johnson, KS