NTSB investigations: AiResearch TPE331 series, 2007
8 cases on aircraft whose registry engine model is AiResearch TPE331 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 per year
| 1966 | 1 |
|---|---|
| 1968 | 1 |
| 1970 | 1 |
| 1976 | 2 |
| 1978 | 3 |
| 1979 | 1 |
| 1980 | 2 |
| 1981 | 6 |
| 1982 | 4 |
| 1983 | 2 |
| 1984 | 6 |
| 1985 | 7 |
| 1986 | 2 |
| 1987 | 2 |
| 1988 | 3 |
| 1989 | 3 |
| 1990 | 5 |
| 1991 | 3 |
| 1992 | 5 |
| 1993 | 6 |
| 1994 | 2 |
| 1995 | 7 |
| 1996 | 7 |
| 1997 | 2 |
| 1998 | 3 |
| 1999 | 7 |
| 2000 | 6 |
| 2001 | 6 |
| 2002 | 6 |
| 2003 | 11 |
| 2004 | 10 |
| 2005 | 10 |
| 2006 | 7 |
| 2007 | 8 |
| 2008 | 6 |
| 2009 | 7 |
| 2010 | 2 |
| 2011 | 4 |
| 2012 | 4 |
| 2014 | 1 |
| 2015 | 2 |
| 2016 | 6 |
| 2017 | 2 |
| 2018 | 4 |
| 2019 | 3 |
| 2020 | 3 |
| 2021 | 5 |
| 2022 | 3 |
| 2023 | 2 |
| 2024 | 5 |
| 2025 | 3 |
| 2026 | 4 |
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 year(c.\"eventDate\") = 2007
AND 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'))
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 year(c."eventDate") = 2007
AND 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'))
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 SEA08CA034Accident · No injuriesData collectionFinal reportAyres S2R-G1 · Calexico, CAThe pilot's failure to maintain directional control while landing. A factor in the accident was the close proximity of the drainage ditch to the edge of the private airstrip's runway.NTSB DFW08LA035Accident · No injuriesLimited investigationFinal reportAyres S2-R · Lenora, TXThe loss of engine power due to separation of the "P3" line from the engine's fuel control.NTSB ANC07FA103Accident · 1 fatalField investigationFinal reportShort Bros. SC-7 · McGrath, AKA collision with trees during takeoff-initial climb for an undetermined reason.NTSB ANC07LA095Accident · No injuriesLimited investigationFinal reportShort Bros. SC-7 · McGrath, AKThe pilot's selection of unsuitable terrain for landing and subsequent nose gear collapse during the landing roll. Contributing to the accident was the soft terrain.NTSB CHI07LA207Accident · 1 fatalLimited investigationFinal reportWeatherly 620B · Wyoming, ILThe pilot's failure to maintain clearance with the power lines during the aerial application flight. Contributing to the accident were the power lines and the low altitude.NTSB DFW07CA150Accident · No injuriesData collectionFinal reportAyres S2R-G10 · Colorado City, TXThe loss of engine power due to an oil leak. A contributing factor was the lack of suitable terrain for the forced landing.NTSB ANC07LA032Accident · No injuriesLimited investigationFinal reportBeech D18S · Levelock, AKThe pilot's misjudged flare, which precipitated a hard landing, and damage to the main landing gear, resulting in a main landing gear collapse during the landing roll. A factor contributing to the accident was the overload failure of the main landing gear…NTSB CHI07LA108Accident · No injuriesLimited investigationFinal reportSwearingen SA-226T · Wheeling, ILPartial failure of the left engine propeller governor during the takeoff ground roll. Factors included that directional control was not possible by the pilot which subsequently led to a collision with an airport sign.