NTSB investigations: Continental O-470 series, VA
67 cases on aircraft whose registry engine model is Continental O-470 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\" = 'VA' 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 ('17026'))
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" = 'VA' 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 ('17026'))
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 NYC72DID09Accident · No injuriesClosedCessna 182J · Ashland, VANTSB IAD71FID14Accident · 1 fatalClosedCessna 182 · Crewe, VANTSB IAD70AI044Accident · 1 fatalClosedCessna 182 · Dublin, VANTSB DIA69F0135Accident · No injuriesClosedCessna 182 · Petersburg, VANTSB DIA69D0065Accident · No injuriesClosedCessna 182 · Norfolk, VANTSB DIA68F0005Accident · No injuriesClosedCessna 182 · Quinton, VANTSB NYC67D0470Accident · No injuriesClosedCessna 182A · Turbeville, VANTSB NYC67D0412Accident · No injuriesClosedCessna 182J · Warrenton, VANTSB NYC67F0078Accident · Minor injuriesClosedCessna 182J · Roanoke, VANTSB NYC66F0387Accident · No injuriesClosedCessna 182 · Fork Union, VANTSB NYC66F0043Accident · No injuriesClosedCessna 310B · Leesburg, VANTSB NYC66F0079Accident · No injuriesClosedCessna 182 · Woodbridge, VANTSB NYC66D0248Accident · No injuriesClosedCessna 182E · Sandston, VANTSB NYC65F0211Accident · No injuriesClosedCessna 182 · Dulles Arpt, VANTSB UNK65X1469Accident · Serious injuriesClosedCessna 182C · Rustburg, VANTSB UNK64X2254Accident · 1 fatalClosedCessna 180 · Fancy Gap, VANTSB UNK64X0583Accident · No injuriesClosedCessna 180 · Norfolk, VA