NTSB investigations: AiResearch TPE331-5&6SER, CA
6 cases on aircraft whose registry engine model is AiResearch TPE331-5&6SER. 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
| 1988 | 1 |
|---|---|
| 1996 | 1 |
| 1997 | 1 |
| 1999 | 1 |
| 2014 | 1 |
| 2015 | 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.\"eventStateOrRegion\" = 'CA' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('01515'))
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."eventStateOrRegion" = 'CA' AND c."eventCountry" = 'USA'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('01515'))
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 GAA15CA303Accident · No injuriesData collectionFinal reportMitsubishi MU 2B-25 · Arvin, CAThe pilot's failure to maintain clearance from trees while taxiing into position for takeoff on a narrow private airstrip, resulting in the left wing striking a tree.NTSB WPR15TA002Accident · No injuriesFinal reportRockwell International 690B · Grass Valley, CAThe pilot’s unstabilized approach and failure to go around and his subsequent failure to maintain directional control during the landing roll.NTSB LAX99LA241Accident · No injuriesLimited investigationFinal reportRockwell 690B · Monterey, CAThe failure of maintenance personnel to properly adjust the drag brace preload during recent landing gear maintenance, which resulted in the overload failure and separation of the hydraulic cylinder attach boss.NTSB LAX97LA132Accident · No injuriesLimited investigationFinal reportBeech 100 · San Carlos, CAthe pilot's improper flare, which resulted in a hard landing; his improper adjustment of the landing gear warning horn squat switch(es); and his decision to attempt flight with known equipment deficiencies.NTSB LAX96LA196Accident · No injuriesLimited investigationFinal reportAyres S2R-G6 · Williams, CAThe pilot's failure to maintain directional control during a rejected takeoff, and the catastrophic failure of the engine's turbine section due to an improper overhaul procedure. A factor in the accident was the close proximity of the drainage ditch to the…NTSB LAX88LA218Accident · No injuriesLimited investigationFinal reportRockwell 690C · Hayward, CAAt the end of a cross country flight, while on final approach to the runway, the right engine quit. Shortly thereafter, the left engine quit. The pilot made a forced landing in a field short of the runway where during the landing roll the airplane collided…