NTSB investigations: Continental 0-200 series, MD
76 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\" = 'MD' 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" = 'MD' 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 NYC73FIG19Accident · Minor injuriesClosedCessna 150K · College Park, MDNTSB NYC73FIG11Accident · Minor injuriesClosedCessna 150G · College Park, MDNTSB NYC72FIG27Accident · Minor injuriesClosedCessna 150 · Gaithersburg, MDNTSB NYC72FIG22Accident · No injuriesClosedCessna 150 · College Park, MDNTSB NYC72FIG20Accident · No injuriesClosedCessna 150 · Laurel, MDNTSB NYC72FIG16Accident · No injuriesClosedCessna 150J · Crownsville, MDNTSB NYC72AN024Accident · No injuriesClosedCessna 150K · Frederick, MDNTSB IAD72DIG03Accident · No injuriesClosedCessna 150 · Finksburg, MDNTSB DIA69D0114Accident · No injuriesClosedCessna 150 · Brookeville, MDNTSB DIA69F0006Accident · No injuriesClosedCessna 150 · Fallston, MDNTSB DIA68F0002Accident · Minor injuriesClosedCessna 150 · Michellville, MDNTSB DIA67D0043Accident · No injuriesClosedCessna 150 · College Park, MDNTSB DIA67F0040Accident · No injuriesClosedChampion 402 · Friendly, MDNTSB DIA67D0032Accident · No injuriesClosedCessna 150 · Hagerstown, MDNTSB DIA67D0031Accident · No injuriesClosedCessna 150F · Gaithersburg, MDNTSB NYC67D0362Accident · No injuriesClosedCessna 150 · Lower Marlboro, MDNTSB NYC67D0177Accident · No injuriesClosedCessna 150F · Hurlock, MDNTSB NYC67D0102Accident · No injuriesClosedCessna 150 · Gaithersburg, MDNTSB NYC66F0712Accident · No injuriesClosedCessna 150 · Friendly, MDNTSB NYC66D0533Accident · No injuriesClosedCessna 150 · Friendly, MDNTSB NYC66D0507Accident · No injuriesClosedCessna 150 · Gaithersburg, MDNTSB NYC66D0337Accident · No injuriesClosedChampion 7ECA · Clinton, MDNTSB NYC66D0331Accident · Minor injuriesClosedCessna 150 · Gaithersburg, MDNTSB NYC66D0315Accident · No injuriesClosedCessna 150 · Pocomoke City, MDNTSB NYC66D0058Accident · No injuriesClosedCessna 150 · Friendly, MDNTSB UNK64X1968Accident · No injuriesClosedChampion 402 · Friendly, MD