NTSB investigations: Continental 0-200 series, KY
79 cases on aircraft whose registry engine model is Continental 0-200 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\" = 'KY' 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 ('17020'))
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" = 'KY' 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 ('17020'))
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 IAD73FLQ34Accident · Minor injuriesClosedCessna 150H · Park City, KYNTSB CHI73AC016Accident · 1 fatalClosedCessna 150H · Louisville, KYNTSB CHI72FLQ33Accident · No injuriesClosedCessna 150 · Owenton, KYNTSB CHI72FLQ25Accident · No injuriesClosedCessna 150 · Berea, KYNTSB CHI72FLQ24Accident · 1 fatalClosedCessna 150H · Louisville, KYNTSB CHI72FLQ19Accident · No injuriesClosedCessna 150 · Hawesville, KYNTSB CHI72FLQ10Accident · Serious injuriesClosedCessna 150H · Hazard, KYNTSB CHI71FLQ25Accident · No injuriesClosedCessna 150K · New Haven, KYNTSB MIA71DLT15Accident · No injuriesClosedCessna 150 · Whitesville, KYNTSB CHI71FLQ22Accident · No injuriesClosedCessna 150 · Lexington, KYNTSB CHI71DGJ01Accident · No injuriesClosedCessna 150 · Murray, KYNTSB CHI70DGJ14Accident · No injuriesClosedCessna 150 · Elizabethtown, KYNTSB CHI70DGJ10Accident · No injuriesClosedCessna 150 · Adairville, KYNTSB CHI70F0387Accident · Serious injuriesClosedCessna 150 · Lebanon, KYNTSB CHI70F0329Accident · No injuriesClosedCessna 150 · Cherokee Sta, KYNTSB CHI70D0024Accident · No injuriesClosedCessna 150 · Louisville, KYNTSB CHI70F0166Accident · Minor injuriesClosedCassutt HL-1 · Henderson, KYNTSB CHI70D0178Accident · No injuriesClosedCessna 150 · Owensboro, KYNTSB CHI70F0008Accident · Serious injuriesClosedCessna 150 · Lexington, KYNTSB CHI69D0669Accident · Minor injuriesClosedCessna 150H · Middletown, KYNTSB CHI69A0089Accident · 1 fatalClosedCessna 150 · Prospect, KYNTSB CHI69F0279Accident · No injuriesClosedCessna 150 · Hodgenville, KYNTSB CHI69F0244Accident · No injuriesClosedCessna 150 · Oscar, KYNTSB CHI69D0282Accident · No injuriesClosedCessna 150 · Lynnville, KYNTSB CHI69D0206Accident · No injuriesClosedCessna 150 · Mt Sterling, KYNTSB CHI68F0711Accident · No injuriesClosedCessna 150 · West Paducah, KYNTSB CHI68F0731Accident · No injuriesClosedCessna 150 · Frankfort, KYNTSB CHI67D0342Accident · Minor injuriesClosedCessna 150D · London, KYNTSB CHI65D0045Accident · No injuriesClosedCessna 150 · Arrollton, KY