NTSB investigations: Continental IO-520 series, NC
76 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\" = 'NC' 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" = 'NC' 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 ATL81DKM02Accident · No injuriesClosedCessna 210 · Marion, NCNTSB ATL80DLJ18Accident · No injuriesClosedCessna 188B · Elizabeth City, NCNTSB IAD80FA037Accident · 1 fatalClosedCessna 401 · Linville, NCNTSB IAD80DKM14Accident · No injuriesClosedBeech A36 · Albemarle, NCNTSB IAD80FA023Accident · 2 fatalClosedBellanca 17-30A · Morrisville, NCNTSB IAD79FLJ01Accident · Minor injuriesClosedCessna 210H · Rocky Mt, NCNTSB IAD78FA095Accident · No injuriesClosedBeech D-55 · Hickory, NCNTSB IAD78DKM20Accident · Minor injuriesClosedCessna 310F · Liberty, NCNTSB IAD78DLJ13Accident · No injuriesClosedCessna 188T · Fairfield, NCNTSB IAD78FLJ01Accident · No injuriesClosedCessna 188B · Roanoke Rapids, NCNTSB IAD77FLJ26Accident · No injuriesClosedCessna 188 · Columbia, NCNTSB IAD77DLJ31Accident · No injuriesClosedCessna A188B · Merritt, NCNTSB IAD76FLJ28Accident · No injuriesClosedCessna A188B · Battleboro, NCNTSB IAD76DKM38Accident · No injuriesClosedCessna 310 · Greensboro, NCNTSB IAD76FKM19Accident · No injuriesClosedCessna 210 · Gastonia, NCNTSB IAD76FLJ11Accident · No injuriesClosedCessna 188B · Laurinburg, NCNTSB IAD75FLJ34Accident · No injuriesClosedCessna P206 · Washington, NCNTSB IAD75DKM26Accident · Minor injuriesClosedBeech F33A · Beech Mountain, NCNTSB IAD73FLJ21Accident · No injuriesClosedCessna 401A · Morrisville, NCNTSB NYC73AN044Accident · No injuriesClosedCessna 210L · Davis, NCNTSB NYC72FLJ24Accident · No injuriesClosedCessna 210G · Apex, NCNTSB IAD71DKM03Accident · No injuriesClosedBeech V35A · Statesville, NCNTSB IAD70FLJ06Accident · No injuriesClosedBellanca 17-30 · Raleigh, NCNTSB DIA69F0126Accident · No injuriesClosedCessna P206C · Morrisville, NCNTSB DIA68F0166Accident · No injuriesClosedCessna 210D · Robbinsville, NCNTSB DIA68D0135Accident · No injuriesClosedBeech 95-C55 · Engelhard, NC