NTSB investigations: Continental 0-200 series, OK
126 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\" = 'OK' 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" = 'OK' 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 FTW82DA186Accident · No injuriesFinal reportCessna 150 · Knowles, OKDuring a cross country flight the student pilot elected to land in a pasture near his home. On takeoff the aircraft collided with a fence resulting in substantial damage to the aircraft. The pilot returned to the pasture and landed without further incident.…NTSB FTW82FPJ02Accident · Serious injuriesClosedCessna 150 · Asher, OKNTSB FTW81FPJ27Accident · Minor injuriesClosedCessna 150 · Guthrie, OKNTSB FTW81FPJ20Accident · Minor injuriesClosedCessna 150 · Dover, OKNTSB FTW80FPJ32Accident · No injuriesClosedCessna 150G · Norman, OKNTSB FTW79FPM10Accident · No injuriesClosedCessna 150 · Vinita, OKNTSB FTW78DPJ38Accident · No injuriesClosedCessna 150 · Tuttle, OKNTSB FTW78FPM18Accident · No injuriesClosedCessna 150 · Tulsa, OKNTSB FTW78FPM12Accident · No injuriesClosedCessna 150 · Owasso, OKNTSB FTW78DPM02Accident · No injuriesClosedCessna 150 · Claremore, OKNTSB FTW77FPM21Accident · Minor injuriesClosedCessna 150 · Tulsa, OKNTSB FTW77FPM17Accident · No injuriesClosedCessna 150 · Tulsa, OKNTSB FTW77DPJ32Accident · No injuriesClosedCessna 150 · Olustee, OKNTSB FTW77FPM09Accident · No injuriesClosedCessna 150M · Tulsa, OKNTSB FTW77DPJ06Accident · No injuriesClosedCessna 150 · Medford, OKNTSB FTW76FPM31Accident · No injuriesClosedCessna 150 · Yanush, OKNTSB FTW76DPM25Accident · Serious injuriesClosedCessna 150 · Chelsea, OKNTSB FTW76DPJ35Accident · No injuriesClosedCessna 150 · Clinton, OKNTSB FTW76DPJ17Accident · No injuriesClosedTaylorcraft 19 · Oklahoma City, OKNTSB FTW75FPM19Accident · No injuriesClosedCessna 150F · Kansas, OKNTSB FTW75DPM11Accident · No injuriesClosedCessna 150 · Stilwell, OKNTSB FTW75FPM02Accident · No injuriesClosedCessna 150L · Kiefer, OKNTSB FTW74FPM16Accident · No injuriesClosedCessna 150K · Sand Springs, OKNTSB FTW74DPM13Accident · No injuriesClosedCessna 150 · Tulsa, OKNTSB FTW74DPM04Accident · No injuriesClosedCessna 150E · Warner, OKNTSB FTW73FPJ21Accident · No injuriesClosedCessna 150L · Yukon, OKNTSB FTW72FPM17Accident · Minor injuriesClosedCessna 150 · Kiefer, OKNTSB FTW72FPJ25Accident · Serious injuriesClosedCessna 150 · Mangum, OKNTSB FTW72DPJ07Accident · Minor injuriesClosedCessna 150H · Okene, OKNTSB FTW72DPJ01Accident · Minor injuriesClosedCessna 150L · Yukon, OKNTSB FTW71FPJ34Accident · Minor injuriesClosedCessna 150K · Bethany, OKNTSB FTW71FPJ29Accident · Minor injuriesClosedCessna 150K · Mustang, OKNTSB FTW71DPJ28Incident · No injuriesClosedCessna 150 · Woodward, OKNTSB FTW71DPJ26Accident · No injuriesClosedCessna 150 · East Jesse, OKNTSB FTW71FPJ24Accident · No injuriesClosedCessna 150 · Wellston, OKNTSB FTW71DPJ16Accident · No injuriesClosedCessna 150 · Chattanooga, OKNTSB FTW70DPM04Accident · No injuriesClosedCessna 150F · Dewey, OKNTSB FTW70DPJ04Accident · No injuriesClosedCessna 150 · Lawton, OKNTSB FTW70AF049Accident · No injuriesClosedPiper PA-23 · Tulsa, OKNTSB FTW70F0286Accident · Serious injuriesClosedCessna 150 · Purcell, OKNTSB FTW70D0172Accident · No injuriesClosedCessna 150G · Jenks, OKNTSB FTW70F0165Accident · No injuriesClosedCessna 150 · Norman, OKNTSB FTW70D0007Accident · No injuriesClosedCessna 150 · Leon, OKNTSB FTW69D0545Accident · No injuriesClosedCessna 150 · Ardmore, OKNTSB FTW69D0214Accident · No injuriesClosedCessna 150F · Hobart, OKNTSB FTW69D0218Accident · No injuriesClosedChampion 7EC · Enid, OKNTSB FTW69D0212Accident · No injuriesClosedCessna 150 · Altus, OKNTSB FTW69D0188Accident · No injuriesClosedCessna 150 · Norman, OKNTSB FTW69D0168Accident · No injuriesClosedCessna 150 · Thomas, OKNTSB FTW69F0124Accident · No injuriesClosedCessna 150 · Beaver, OK