NTSB investigations: AiResearch TPE331 series
8 cases on aircraft whose registry engine model is AiResearch TPE331 series, where the defining event was Loss of control on ground. 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 per year
| 2009 | 1 |
|---|---|
| 2016 | 2 |
| 2018 | 1 |
| 2020 | 2 |
| 2024 | 1 |
| 2026 | 1 |
Where
Open the mapLatest cases
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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('01514', '01517')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e.\"isDefiningEvent\" AND e.\"tier2Number\" = '230'))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('01514', '01517')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e."isDefiningEvent" AND e."tier2Number" = '230'))
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 WPR26LA080Accident · No injuriesClass 3 · LimitedPreliminary reportFairchild SA227-AC · Prescott, AZOn January 13, 2026, about 0624 mountain standard time, a Fairchild SA227-AC airplane, N370AE, was substantially damaged when it was involved in an accident near Prescott Municipal Airport (PRC), Prescott, Arizona. The pilot was not injured. The airplane was…NTSB WPR24LA165Accident · No injuriesClass 4 · LimitedFinal reportGrumman Acft ENG Cor-Schweizer G-164A · Rome, ORThe pilot’s failure to maintain airplane control during landing.NTSB WPR20LA172Accident · No injuriesClass 3 · LimitedFinal reportAyres S2R · Imperial, CAThe pilot's loss of control during a landing roll due to a failure of the main O-ring in the right brake assembly, which resulted in a loss of brake pressure and subsequent brake failure.NTSB CEN20LA125Accident · No injuriesClass 3 · LimitedFinal reportMitsubishi MU 2B-40 · Chilton, WIThe pilot's decision to land on the turf runway with insufficient landing performance and his subsequent loss of control during the landing roll.NTSB GAA18CA098Accident · No injuriesData collectionFinal reportSwearingen SA227 · Rock Springs, WYThe pilot's failure to maintain directional control while taxiing in gusting tailwind conditions.NTSB WPR17LA030Accident · No injuriesLimited investigationFinal reportAero Commander 690 · Scottsdale, AZThe pilot’s loss of directional control during the landing roll, which resulted in the runway excursion onto the rock-covered runway safety area.NTSB CEN16LA173Accident · No injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G 164B · Iowa, LAThe pilot's failure to maintain directional control while landing with an inoperative right brake.NTSB ANC09LA104Accident · No injuriesLimited investigationFinal reportCASA 212-200 · Savoonga, AKThe pilot’s failure to maintain directional control during the landing roll in a gusting crosswind.