NTSB investigations: AiResearch TPE331 series
10 cases on aircraft whose registry engine model is AiResearch TPE331 series, where the first occurrence was “Loss of control - in flight”. 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
| 1984 | 1 |
|---|---|
| 1985 | 2 |
| 1987 | 1 |
| 1992 | 1 |
| 1993 | 1 |
| 1997 | 1 |
| 2001 | 1 |
| 2004 | 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\" = 250))
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" = 250))
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 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…NTSB DEN01FA113Accident · 2 fatalField investigationFinal reportMitsubishi MU-2B-20 · Cerrillos, NMthe pilot's loss of aircraft control inflight for reasons undetermined. Contributing factors were the pilot's inadequate transition/upgrade training and his total lack of experience in aircraft make/model.NTSB SEA98FA023Accident · 2 fatalField investigationFinal reportAero Commander 690A · Yakima, WAA loss of aircraft control for undetermined reasons.NTSB LAX93FA333Accident · No injuriesField investigationFinal reportAero Commander 690A · Bishop, CAa loss of control and upset due to an inadequate adjustment of the ailerons and aileron trim tab by company maintenance personnel that resulted in a partial failure of the right horizontal stabilizer.NTSB NYC92LA128Accident · No injuriesLimited investigationFinal reportFairchild SA-227AC · Boston, MAThe loss of airplane control during a crosswind landing resulting in a hard bounced landing and a collision with the runway.NTSB DCA87MA030Accident · 2 fatalMajor investigationFinal reportCASA C-212-CC · Mayaguez, PRAfter several maintenance adjustments of the right propeller and flight idle fuel flow, the aircraft was test flown and released for flight. Several pilots continued to note descrepancies concerning the right propeller system. Adjustments were made and the…NTSB CHI85LA265Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Thief River Fl, MNThe acft collided with the ground shortly after takeoff about 800 ft from the end of the rwy. The plt stated that at about 5 pt afl the acft stalled and fell into a field off the end of the rwy.NTSB NYC85IA063Incident · No injuriesIncident investigationFinal reportCASA SAC-212-200 · Atlantic City, NJA construcciones sac 212-200 N296CA lost control during landing flare and landed hard on the grass along side runway 11 at bader field, new jersey, after all of the landing checks were completed the copilot pushed full forward the speed levers and called out…NTSB DCA84AA015Accident · 3 fatalFinal reportSwearingen SA226TC · Terre Haute, INAfter taking off from rwy 23, the acft crashed ssw of the arpt about 6300 ft from the departure end of the rwy & about 1800 ft to the left of the rwy centerline. Impact occurred while the acft was in a steep descent. The wreckage path was scattered along a…