NTSB investigations: Continental IO-520 series, NM
84 cases on aircraft whose registry engine model is Continental IO-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 ('17032'))
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 ('17032'))
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 DEN77DQG07Accident · Minor injuriesClosedCessna 188 · Clovis, NMNTSB DEN77DQA43Accident · No injuriesClosedCessna 188 · Grady, NMNTSB DEN77FQA21Accident · Minor injuriesClosedCessna TU206F · Albuquerque, NMNTSB DEN77DQD07Accident · No injuriesClosedCessna 411 · Artesia, NMNTSB DEN77DQG01Accident · No injuriesClosedCessna 185E · Clovis, NMNTSB DEN77FQA07Accident · No injuriesClosedBellanca 17-30A · Albuquerque, NMNTSB DEN76FQA46Accident · No injuriesClosedCessna T210 · Los Alamos, NMNTSB DEN76FQA24Accident · No injuriesClosedCessna 206 · Abiquiu, NMNTSB DEN76FQA19Accident · Minor injuriesClosedCessna 206 · Des Moines, NMNTSB DEN76DQA14Accident · No injuriesClosedBeech 58 · Ruidoso, NMNTSB DEN75FQA50Accident · No injuriesClosedBeech V35B · Albuquerque, NMNTSB DEN75AD057Accident · No injuriesClosedCessna U206E · Farmington, NMNTSB DEN75FQA39Accident · No injuriesClosedCessna 206 · Albuquerque, NMNTSB DEN75FQD15Accident · Minor injuriesClosedCessna A185E · Las Cruces, NMNTSB DEN75DQA10Accident · Minor injuriesClosedCessna 206 · La Vida Msn, NMNTSB DEN75FQA04Accident · No injuriesClosedBeech D55 · Bernalillo, NMNTSB DEN74FQA02Accident · No injuriesClosedCessna 210E · Albuquerque, NMNTSB DEN73AD044Accident · Serious injuriesClosedCessna U206 · Las Cruces, NMNTSB DEN73DQD11Accident · No injuriesClosedBeech A36 · Pinon, NMNTSB DEN73FQD10Accident · No injuriesClosedCessna 210D · Sunland, NMNTSB DEN73FQA16Accident · Minor injuriesClosedBeech S35 · Albuquerque, NMNTSB DEN72FQA15Accident · No injuriesClosedCessna 411 · Albuquerque, NMNTSB DEN71DQA45Accident · No injuriesClosedCessna 210 · Los Alamos, NMNTSB DEN70F0117Accident · No injuriesClosedBellanca 17-30 · Grants, NMNTSB DEN70F0103Accident · No injuriesClosedCessna A188 · Roswell, NMNTSB DEN69D0138Accident · No injuriesClosedBeech 35C33A · Albuquerque, NMNTSB DEN69D0137Accident · No injuriesClosedCessna 210 · Hobbs, NMNTSB DEN69A0020Accident · 2 fatalClosedBeech S35 · Las Cruces, NMNTSB DEN69F0048Accident · No injuriesClosedCessna 188 · Tucumcari, NMNTSB DEN69F0038Accident · No injuriesClosedBeech 36 · Socorro, NMNTSB DEN69F0013Accident · Minor injuriesClosedCessna TU206 · Santa Fe, NMNTSB DEN68D0263Accident · Minor injuriesClosedCessna 210 · Farmington, NMNTSB DEN68D0088Accident · No injuriesClosedCessna 210 · Cimarron, NMNTSB DEN67D0204Accident · No injuriesClosedCessna 210 · Corona, NM