NTSB investigations: AiResearch TPE331-6-251M
5 cases on aircraft whose registry engine model is AiResearch TPE331-6-251M. 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
| 2008 | 2 |
|---|---|
| 2014 | 1 |
| 2016 | 1 |
| 2025 | 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 ('01521'))
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 ('01521'))
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 CEN25LA304Accident · Serious injuriesClass 3 · LimitedPreliminary reportAyres S2R-G6 · Slayton, MNOn August 6, 2025, about 1300 central daylight time, a Ayres Corporation S2R-G6, airplane, registration N2239V, was substantially damaged when it was involved in an accident near Slayton, Minnesota. The pilot was seriously injured. The airplane was operated…NTSB ERA16LA320Accident · No injuriesLimited investigationFinal reportBeech B100 · Jackson, TNThe pilot’s improper landing flare, which resulted in a hard landing.NTSB ERA14CA276Accident · Minor injuriesData collectionFinal reportSwearingen SA 226AT · Dayton, TNThe pilot's failure to extend the landing gear during the approach, which resulted in a gear-up landing.NTSB SEA08LA117Accident · No injuriesLimited investigationFinal reportRockwell 690C · Minden, NVThe collapse of both main landing gear for undetermined reasons.NTSB CHI08CA074Accident · No injuriesData collectionFinal reportSwearingen SA-226AT · Ankeny, IAThe pilot's failure to maintain directional control during the takeoff roll. Contributing to the accident was the snow on the runway and the snowbank.