NTSB investigations: Lycoming 0-235 series, IN
94 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\" = 'IN' 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" = 'IN' 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 CHI82DA055Accident · No injuriesFinal reportPiper PA-38-112 · Lebanon, INWhile the instructor was demonstrating recovery procedures from a low approach, the main gear struck snow on a small rise about 400 feet short of the runway. Subsequently, the pilot was forced to land in about 18 inches of snow and the gear failed. The…NTSB CHI81DEX26Accident · No injuriesClosedCessna 152 · Shelbyville, INNTSB CHI81DEX09Accident · No injuriesClosedCessna 152 · Columbus, INNTSB CHI81FEX05Accident · No injuriesClosedCessna 152 · Noblesville, INNTSB CHI81FET29Accident · No injuriesClosedBellanca 7ECA · Gary, INNTSB CHI80FEX14Accident · No injuriesClosedGrumman AA-1C · Mt Comfort, INNTSB CHI80DET13Accident · No injuriesClosedCessna 152 · Francesville, INNTSB CHI79FET30Accident · No injuriesClosedCessna 152 · East Chicago, INNTSB CHI79DET29Accident · No injuriesClosedGrumman AA1C · Roselawn, INNTSB CHI79FEX12Accident · No injuriesClosedCessna 152 · Bloomington, INNTSB CHI78FET35Accident · Minor injuriesClosedCessna 152 · Lake Village, INNTSB CHI78FET24Accident · No injuriesClosedEaa Biplane GB-1 · Wanatah, INNTSB CHI78FET14Accident · No injuriesClosedGrum Amer AA-1B · Fort Wayne, INNTSB CHI78FET11Accident · No injuriesClosedGrum Amer AA1-B · Fort Wayne, INNTSB CHI77DEX35Accident · No injuriesClosedBellanca 7ECA · Lebanon, INNTSB CHI77DET15Accident · No injuriesClosedPiper PA-16 · Roselawn, INNTSB CHI76DET32Accident · No injuriesClosedPiper PA-18 · Valparaiso, INNTSB CHI76DEA09Accident · No injuriesClosedAmer Avco AA1-A · Anderson, INNTSB CHI74DEA36Accident · No injuriesClosedAmer Avco AA-1B · English, INNTSB CHI74FEA20Accident · No injuriesClosedPiper PA-22 · Monroe City, INNTSB CHI74DET07Accident · Minor injuriesClosedLuscombe 8F · Crown Point, INNTSB CHI73FEA07Accident · Minor injuriesClosedAmer Avco AA1 · W.Lafayette, INNTSB CHI70FBA02Accident · No injuriesClosedPiper PA-22 · Mooresville, INNTSB CHI70DBA01Accident · No injuriesClosedPiper PA-22 · Monticello, INNTSB CHI70F0175Accident · No injuriesClosedChampion 7ECA · Greenwood, INNTSB CHI68F0592Accident · No injuriesClosedChampion 7ECA · Gary, INNTSB CHI68D0399Accident · No injuriesClosedPiper PA-22 · English, INNTSB CHI68D0349Accident · No injuriesClosedPiper PA-16 · Noblesville, INNTSB CHI68D0067Accident · No injuriesClosedPiper PA-12 · Evansville, INNTSB CHI67D0643Accident · No injuriesClosedPiper PA-22 · Spiceland, INNTSB CHI67F0478Accident · No injuriesClosedChampion 7ECA · Gary, INNTSB CHI66F0770Accident · No injuriesClosedPiper PA-22 · Logansport, INNTSB CHI66F0381Accident · No injuriesClosedPiper PA-12 · Rensselaer, INNTSB CHI66F0140Accident · No injuriesClosedPiper PA-22 · Michigan City, INNTSB MKC66D0091Accident · No injuriesClosedPiper PA-12 · Valpariso, INNTSB CHI66F0058Accident · Minor injuriesClosedPiper PA-22 · Jeffersonville, INNTSB CHI65D0152Accident · No injuriesClosedPiper PA-22 · Warren, INNTSB UNK65X0936Accident · No injuriesClosedPiper PA22 · Windfall, INNTSB UNK64X4080Accident · Serious injuriesClosedCommonwealt H185 · Fortville, INNTSB UNK64X3447Accident · No injuriesClosedPiper PA22 · Marion, INNTSB UNK64X2460Accident · No injuriesClosedLuscombe 8A · Jeffersonvlle, INNTSB UNK64X1203Accident · No injuriesClosedPiper PA22 · Dyer, INNTSB UNK64X1145Accident · No injuriesClosedPiper PA22 · Richmond, INNTSB UNK64X0658Accident · No injuriesClosedPiper PA22 · Lake Village, IN