NTSB investigations: Lycoming 0-235 series, TN
63 cases on aircraft whose registry engine model is Lycoming 0-235 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\" = 'TN' 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 ('41505'))
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" = 'TN' 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 ('41505'))
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 MIA67F0009Accident · Minor injuriesClosedPiper PA12 · Gallatin, TNNTSB MIA67D0007Accident · No injuriesClosedPiper PA22 · Tullahoma, TNNTSB MIA66F0449Accident · Minor injuriesClosedPiper PA-22 · Greenville, TNNTSB MIA66D0259Accident · No injuriesClosedPiper PA-22 · Tullahoma, TNNTSB MIA66D0117Accident · No injuriesClosedPiper PA-12 · Murfreesboro, TNNTSB MIA65D0074Accident · No injuriesClosedCessna 140 · Knoxville, TNNTSB MIA65F0040Accident · No injuriesClosedPiper PA-22 · Lavinia, TNNTSB UNK65X0748Accident · No injuriesClosedPiper PA22 · Cookeville, TNNTSB UNK65X0654Accident · No injuriesClosedPiper PA22 · Sanburg, TNNTSB UNK64X2111Accident · Minor injuriesClosedPiper PA22 · Covington, TNNTSB UNK64X1732Accident · No injuriesClosedPiper PA-22 · Clarksville, TNNTSB UNK64X1378Accident · No injuriesClosedPiper PA12 · Shady Grove, TNNTSB UNK64X0630Accident · 1 fatalClosedPiper PA12 · Ripley, TN