NTSB investigations: AiResearch TPE331 series
13 cases on aircraft whose registry engine model is AiResearch TPE331 series, where the first occurrence was “Loss of engine power”. 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
| 1990 | 1 |
|---|---|
| 1996 | 3 |
| 1999 | 1 |
| 2002 | 2 |
| 2003 | 1 |
| 2004 | 2 |
| 2006 | 1 |
| 2007 | 2 |
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_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 350))
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_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 350))
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 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 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 ATL06LA119Accident · No injuriesLimited investigationFinal reportAyres S2R · Doerun, GAThe loss of engine power for an underdetermined reason, resulting in a forced landing, an on ground collision with trees, and a post crash fire.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 FTW04LA158Accident · Minor injuriesLimited investigationFinal reportRockwell International S-2R · Needville, TXThe loss of engine power and subsequent in-flight fire for undetermined reasons.NTSB FTW03LA159Accident · No injuriesLimited investigationFinal reportAyres S2R-G6 · Palestine, ARThe shearing of the torsion shaft which resulted in a loss of engine power. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW02LA258Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-302 · Lacompte, LAThe loss of engine power for undetermined reason. A contributing factor was the lack of suitable terrain available to the pilot for the forced landing, and low altitude maneuvering.NTSB FTW03IA073Incident · No injuriesIncident investigationFinal reportMitsubishi MU-2B-60 · Memphis, TNthe loss of right engine power as a result of a fatigue failure of the propeller shaft coupling.NTSB ATL99LA054Accident · No injuriesLimited investigationFinal reportMitsubishi MU-2B-20 · Knoxville, TNA loss of engine power for undetermined reasons. Contributing to the accident was the failure of the landing gear to extend for undetermined reasons.NTSB SEA96LA176Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Belgrade, MTloss of engine power for undetermined reason(s). A factor relating to the accident was: a ditch in the field where the forced landing was executed.NTSB FTW96LA215Accident · Minor injuriesLimited investigationFinal reportMitsubishi MU-2B-40 · Houston, TXfailure of the pilot to obtain/maintain proper airspeed and flap setting for single engine flight. A factor relating to the accident was: Loss of power in the left engine for an undetermined reason.NTSB ATL96LA078Accident · No injuriesLimited investigationFinal reportMitsubishi MU-2B · Batesville, MSan anomaly in the fuel system that allowed a pressure differential to occur between the center and outer portions of the main integral fuel tank, which in turn resulted in fuel starvation of both engines. A factor relating to the accident was: failure of…NTSB DEN90LA047Accident · No injuriesLimited investigationFinal reportMitsubishi MU-2B-25 · Broomfield, COLoss of directional control by the pilot, during takeoff ground run. Contributing to this accident were a loss of power on the left engine due to snow ingestion, heavy snow showers in progress and an icy, snow covered runway.