NTSB investigations: Continental 0-300 series, NC
68 cases on aircraft whose registry engine model is Continental 0-300 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\" = 'NC' 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 ('17022'))
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" = 'NC' 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 ('17022'))
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 IAD70DKM08Accident · No injuriesClosedCessna 172 · Statesville, NCNTSB IAD70D0121Accident · No injuriesClosedCessna 172 · Monroe, NCNTSB DIA69D0183Accident · No injuriesClosedCessna 172 · Rutherfordton, NCNTSB DIA69D0157Accident · Minor injuriesClosedMaule M-4 · Lillington, NCNTSB DIA69F0144Accident · Serious injuriesClosedCessna 172 · Mooresville, NCNTSB DIA69D0077Accident · Minor injuriesClosedCessna 172 · Raleigh, NCNTSB DIA68D0186Accident · No injuriesClosedCessna 172 · Rose Hill, NCNTSB DIA68D0102Accident · No injuriesClosedCessna 172 · Davis, NCNTSB DIA68A0015Accident · No injuriesClosedCessna 172H · Asheboro, NCNTSB DIA68D0050Accident · No injuriesClosedCessna 172G · Chapel Hill, NCNTSB DIA68F0032Accident · Serious injuriesClosedCessna 172 · Greenville, NCNTSB DIA67F0091Accident · Minor injuriesClosedCessna 172G · Canton, NCNTSB DIA67D0004Accident · No injuriesClosedCessna 172 · Long Beach, NCNTSB MIA66D0612Accident · No injuriesClosedCessna 172 · High Point, NCNTSB MIA66F0563Accident · Minor injuriesClosedCessna 172 · Hendersonville, NCNTSB MIA66F0519Accident · Minor injuriesClosedCessna 172 · Clemmons, NCNTSB MIA66F0187Accident · Serious injuriesClosedCessna 170B · Grimesland, NCNTSB UNK64X3725Accident · No injuriesClosedCessna 172 · Candor, NC