NTSB investigations: Lycoming 0-290 series, TX
88 cases on aircraft whose registry engine model is Lycoming 0-290 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\" = 'TX' 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 ('41506'))
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" = 'TX' 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 ('41506'))
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 FTW72FRA08Accident · Minor injuriesClosedTaylorcraft BC12-D · Bryan, TXNTSB FTW71FRA42Accident · Minor injuriesClosedPiper PA-22 · Dayton, TXNTSB FTW71DQG54Accident · No injuriesClosedPiper PA-22 · Ozona, TXNTSB FTW71FQG43Accident · No injuriesClosedPiper PA-22 · Denver City, TXNTSB FTW71FPD10Accident · Serious injuriesClosedPiper PA-22 · Mineral Wells, TXNTSB FTW71FRA10Accident · No injuriesClosedPiper PA-20 · League City, TXNTSB FTW70DQG17Accident · No injuriesClosedPiper PA-18 · Wayside, TXNTSB FTW70DRG37Accident · No injuriesClosedPiper PA-18 · Norias, TXNTSB FTW70FBG07Accident · Minor injuriesClosedPiper PA-22 · Port Lavaca, TXNTSB FTW70D0239Accident · No injuriesClosedPiper PA-20 · Nacogdoches, TXNTSB DEN69D0197Accident · No injuriesClosedPitts Spcl SC-1 · El Paso, TXNTSB FTW69F0433Accident · No injuriesClosedPiper PA-22 · Bay City, TXNTSB FTW69D0375Accident · No injuriesClosedTaylorcraft BC12-D · Mcgregor, TXNTSB FTW68D0524Accident · No injuriesClosedPiper PA-22 · Levelland, TXNTSB FTW68D0356Accident · No injuriesClosedPiper PA-18 · Canyon, TXNTSB FTW68D0116Accident · No injuriesClosedAeronca 7GC · Imperial, TXNTSB FTW68D0069Accident · No injuriesClosedPiper J3C-65 · Canyon, TXNTSB FTW68F0081Accident · Serious injuriesClosedPiper PA-22 · Sherman, TXNTSB FTW68D0080Accident · No injuriesClosedPiper PA-20 · Friendswood, TXNTSB FTW68D0037Accident · No injuriesClosedPiper PA-22 · Dallas, TXNTSB FTW67F0561Accident · No injuriesClosedPiper PA-18 · Dalhart, TXNTSB FTW68F0246Accident · Minor injuriesClosedPiper PA-22 · Dallas, TXNTSB FTW67F0303Accident · No injuriesClosedPiper PA-22 · Addison, TXNTSB FTW67F0388Accident · No injuriesClosedCessna 140 · Lipan, TXNTSB FTW67D0018Accident · No injuriesClosedPiper PA-22 · Levelland, TXNTSB FTW66D0548Accident · No injuriesClosedReynolds JCR-1 · Big Spring, TXNTSB FTW66D0492Accident · No injuriesClosedPiper PA-22 · Sunray, TXNTSB FTW66D0441Accident · No injuriesClosedPiper PA-22 · Amarillo, TXNTSB FTW66F0228Accident · Minor injuriesClosedPiper PA-18 · Booker, TXNTSB FTW66F0215Accident · No injuriesClosedPiper PA-22 · Big Lake, TXNTSB UNK65X1400Accident · No injuriesClosedPiper PA-18 · Kingsville, TXNTSB UNK65X1382Accident · No injuriesClosedPiper PA-22 · Seminole, TXNTSB UNK65X1024Accident · No injuriesClosedPiper PA22 · Sanford, TXNTSB UNK65X0653Accident · No injuriesClosedPiper PA22 · Fort Mckavett, TXNTSB UNK64X3771Accident · No injuriesClosedPiper PA16 · Cotulla, TXNTSB UNK64X2240Accident · No injuriesClosedPiper PA18 · Peacock, TXNTSB UNK64X0995Accident · Minor injuriesClosedPiper PA22 · Sweetwater, TXNTSB UNK64X0958Accident · No injuriesClosedPiper PA20 · Anson, TX