NTSB investigations: Continental 0-300 series, MO
86 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\" = 'MO' 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" = 'MO' 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 MKC68D0492Accident · No injuriesClosedCessna 172 · Warrensburg, MONTSB MKC68D0410Accident · No injuriesClosedCessna 172 · Kansas City, MONTSB MKC68D0251Accident · Minor injuriesClosedCessna 172 · Clinton, MONTSB MKC68D0121Accident · Minor injuriesClosedCessna 172 · Forest City, MONTSB MKC68D0296Accident · No injuriesClosedCessna 172 · St Joseph, MONTSB MKC68F0244Accident · Minor injuriesClosedCessna 172 · Vandalia, MONTSB MKC67D0537Accident · No injuriesClosedCessna 172F · Bridgeton, MONTSB MKC67A0018Accident · 1 fatalClosedCessna 172E · Knox City, MONTSB MKC67D0063Accident · No injuriesClosedCessna 172F · Kennett, MONTSB MKC67D0152Accident · No injuriesClosedCessna 172 · Piedmont, MONTSB MKC67F0028Accident · No injuriesClosedCessna 172 · Berger, MONTSB MKC67D0069Accident · No injuriesClosedCessna 172 · St.Charles, MONTSB MKC66D0585Accident · No injuriesClosedCessna 172 · Camdenton, MONTSB MKC66F0537Accident · No injuriesClosedMaule M-4 · Fredericktown, MONTSB MKC66F0528Accident · No injuriesClosedCessna 172 · St. Joseph, MONTSB MKC66D0490Accident · No injuriesClosedCessna 172 · Moberly, MONTSB MKC67D0001Accident · Minor injuriesClosedCessna 172F · Rich Fountain, MONTSB MKC66F0446Accident · No injuriesClosedCessna 172B · St.Louis, MONTSB MKC66D0530Accident · No injuriesClosedCessna 172 · Poplar Bluff, MONTSB MKC66D0445Accident · No injuriesClosedCessna 172 · Macon, MONTSB MKC66D0425Accident · No injuriesClosedCessna 172 · Springfield, MONTSB MKC66D0373Accident · No injuriesClosedCessna 170B · Kirksville, MONTSB MKC66D0290Accident · No injuriesClosedCessna 172 · Reed Springs, MONTSB MKC66D0257Accident · No injuriesClosedCessna 172 · Warrensburg, MONTSB MKC66D0156Accident · No injuriesClosedCessna 172 · Camdenton, MONTSB MKC66D0202Accident · No injuriesClosedCessna 170B · Carthage, MONTSB MKC66F0097Accident · Serious injuriesClosedCessna 172C · Ozark, MONTSB MKC65D0052Accident · No injuriesClosedCessna 172 · Bowling Green, MONTSB MKC65F0080Accident · No injuriesClosedCessna 172 · Kansas City, MONTSB MKC65F0026Accident · No injuriesClosedCessna 172 · Kansas City, MONTSB UNK65X1137Accident · No injuriesClosedCessna 172F · St Louis, MONTSB UNK65X0796Accident · No injuriesClosedCessna 172 · East Prairie, MONTSB UNK64X4097Accident · No injuriesClosedCessna 172E · Festus, MONTSB UNK64X1528Accident · No injuriesClosedCessna 172 · Harrisonville, MONTSB UNK64X0758Accident · No injuriesClosedCessna 170 · St Joseph, MONTSB UNK64X0726Accident · No injuriesClosedCessna 172B · Harrisonville, MO