NTSB investigations: Continental 0-200 series, NE
62 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\" = 'NE' 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" = 'NE' 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 MKC71DCJ42Accident · No injuriesClosedCessna 150 · Mccook, NENTSB MKC71FCJ31|MKC71FCJ32Accident · No injuriesClosedCessna 150 · Columbus, NENTSB MKC70D0159Accident · Minor injuriesClosedCessna 150 · Ogallala, NENTSB MKC69D0450Accident · No injuriesClosedCessna 150F · Thedford, NENTSB MKC69D0361Accident · No injuriesClosedCessna 150 · Fairmont, NENTSB MKC69F0111Accident · No injuriesClosedCessna 150G · Saronville, NENTSB MKC69F0102Accident · No injuriesClosedCessna 150 · North Platte, NENTSB MKC68D0589Accident · No injuriesClosedCessna 150 · Syracuse, NENTSB MKC68F0299Accident · Minor injuriesClosedCessna 150H · Millard, NENTSB MKC68D0270Accident · Minor injuriesClosedCessna 150 · Lodgepole, NENTSB MKC67F0141Accident · No injuriesClosedCessna 150F · Columbus, NENTSB MKC66F0345Accident · No injuriesClosedCessna 150 · Lincoln, NE