NTSB investigations: Continental TSIO-520 series, NM
61 cases on aircraft whose registry engine model is Continental TSIO-520 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\" = 'NM' 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 ('17040'))
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" = 'NM' 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 ('17040'))
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 DEN80DQD04Accident · No injuriesClosedCessna 210 · Animas, NMNTSB DEN80FQA11Incident · No injuriesClosedCessna 402A · Albuquerque, NMNTSB DEN80DQG03Accident · No injuriesClosedCessna 206 · Hobbs, NMNTSB DEN79FQA33Accident · No injuriesClosedCessna TC210 · Albuquerque, NMNTSB DEN79FA052Accident · Serious injuriesClosedCessna P210 · Farmington, NMNTSB DEN79FQA24Accident · No injuriesClosedCessna 402 · Albuquerque, NMNTSB DEN79FQA21Accident · No injuriesClosedCessna 340 · Angel Fire, NMNTSB DEN79FQA19Accident · Serious injuriesClosedCessna T210M · Albuquerque, NMNTSB DEN78FQA57Accident · No injuriesClosedCessna TU206F · Mesita, NMNTSB DEN77FQA04Accident · Minor injuriesClosedCessna TU206F · Albuquerque, NMNTSB DEN76FQA37Accident · Serious injuriesClosedCessna T207 · Gallup, NM