NTSB investigations: Continental 0-300 series, AZ
72 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\" = 'AZ' 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" = 'AZ' 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 LAX70D0191Accident · No injuriesClosedGlobe GC-1A · Casa Grande, AZNTSB LAX68F0323Accident · No injuriesClosedCessna 172 · Yuma, AZNTSB LAX68D0211Accident · No injuriesClosedCessna 172 · Lk Havsu Cty, AZNTSB LAX68F0150Accident · No injuriesClosedCessna 172 · Phoenix, AZNTSB LAX68D0096Accident · No injuriesClosedCessna 172 · Holbrook, AZNTSB LAX68D0017Accident · No injuriesClosedCessna 172 · Phoenix, AZNTSB LAX67F0333Accident · 1 fatalClosedCessna 172 · Phoenix, AZNTSB LAX67D0168Accident · No injuriesClosedCessna 172G · Winslow, AZNTSB LAX67D0164Accident · No injuriesClosedCessna 172 · Grand Canyon, AZNTSB LAX67D0155Accident · Minor injuriesClosedCessna 172 · Sonoita, AZNTSB DEN67D0013Accident · No injuriesClosedCessna 172 · Sierra Vista, AZNTSB DEN66D0338Accident · No injuriesClosedCessna 170B · Phoenix, AZNTSB DEN66D0313Accident · No injuriesClosedCessna 172 · San Simon, AZNTSB DEN66D0210Accident · Minor injuriesClosedCessna 172 · Bowie, AZNTSB DEN66D0134Accident · No injuriesClosedCessna 170B · Phoenix, AZNTSB DEN65D0084Accident · No injuriesClosedCessna 172D · Tucson, AZNTSB UNK65X1304Accident · No injuriesClosedCessna 170B · Gila Bend, AZNTSB UNK65X0974Accident · No injuriesClosedCessna 172 · Kingman, AZNTSB UNK65X0282Accident · No injuriesClosedCessna 172 · Grand Canyon, AZNTSB UNK64X2168Accident · No injuriesClosedCessna 172 · Page, AZNTSB UNK64X0406Accident · No injuriesClosedCessna 170B · Flagstaff, AZNTSB UNK64X0146Accident · No injuriesClosedCessna 172 · Scottsdale, AZ