Fatal NTSB investigations: AiResearch TPE331 series, 2004
6 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
| 1979 | 1 |
|---|---|
| 1980 | 1 |
| 1981 | 1 |
| 1982 | 1 |
| 1983 | 1 |
| 1984 | 5 |
| 1985 | 2 |
| 1986 | 1 |
| 1987 | 1 |
| 1988 | 1 |
| 1993 | 1 |
| 1995 | 1 |
| 1997 | 1 |
| 2000 | 1 |
| 2001 | 2 |
| 2002 | 2 |
| 2003 | 4 |
| 2004 | 6 |
| 2005 | 2 |
| 2006 | 4 |
| 2007 | 2 |
| 2009 | 1 |
| 2011 | 1 |
| 2014 | 1 |
| 2015 | 1 |
| 2016 | 2 |
| 2017 | 1 |
| 2018 | 1 |
| 2020 | 1 |
| 2021 | 2 |
| 2024 | 2 |
| 2025 | 3 |
| 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 year(c.\"eventDate\") = 2004
AND c.\"highestInjuryLevel\" = 'Fatal'
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") = 2004
AND c."highestInjuryLevel" = 'Fatal'
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 DEN05FA034Accident · 2 fatalField investigationFinal reportMitsubishi MU-2B-60 · Englewood, COthe pilot's failure to maintain minimum controllable airspeed during the night visual approach resulting in a loss of control and uncontrolled descent into terrain. A contributing factor was the precautionary shutdown of the left engine for undetermined…NTSB IAD05FA023Accident · 6 fatalClass 1 · FieldFinal reportCASA 212-200-CC · Bamiyan, Afghanistanthe captain's inappropriate decision to fly a nonstandard route and his failure to maintain adequate terrain clearance, which resulted in the inflight collision with mountainous terrain. Factors were the operator's failure to require its flight crews to file…NTSB DCA05MA004Accident · 13 fatalClass 1 · MajorFinal reportBritish Aerospace Jetstream 32 · Kirksville, MOthe pilots' failure to follow established procedures and properly conduct a nonprecision instrument approach at night in IMC, including their descent below the minimum descent altitude (MDA) before required visual cues were available (which continued…NTSB ANC04FA063Accident · 1 fatalField investigationFinal reportBeech C-45H · Kodiak, AKThe pilot's failure to follow proper IFR procedures by not adhering to the published missed approach procedures, which resulted in an in-flight collision with tree-covered terrain. Factors contributing to the accident were a low ceiling, fog, rain, and the…NTSB LAX04FA165Accident · 2 fatalField investigationFinal reportMitsubishi MU-2B-40 · Napa, CAThe pilot's failure to maintain control of the airplane following a shutdown of the left engine during a night visual approach. A factor contributing to the accident was the dark night.NTSB DEN04FA035Accident · 1 fatalField investigationFinal reportRockwell 690A · Cortez, COthe pilot's inadequate planned approach and his failure to maintain airspeed which resulted in a stall. Contributing factors were low altitude flight maneuvering in an attempt to lose excessive altitude and realign the airplane for landing, and his failure to…