NTSB investigations: AiResearch TPE331 series, 1984
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
| 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\") = 1984
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") = 1984
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 FTW85FA086Accident · 1 fatalField investigationFinal reportCessna 441 · Marble Falls, TXThe acft crashed aprx 1.5 miles south of the departure end of rwy 17 during an attempted rwy 17 NDB apch. The acft was cleared for the apch at 2012 CST and the plt canceled IFR reporting the arpt in sight at 2014. A witness located aprx 1 mile south of the…NTSB DEN84MA266Accident · 4 fatalMajor investigationFinal reportAero Commander 690 · Little America, WYAbout 10 min after takeoff at 1005 MDT, the plt was cleared to climb to FL 190. This was atc's last communication with the acft. At 1030:39, the controller attempted to contact the plt to advise that he had lost radar contact & to recycle the transponder &…NTSB FTW84LA228Accident · 1 fatalLimited investigationFinal reportRockwell S-2R · Bay City, TXWhile spraying a field with propanel & modown grass killers, the plt was crossing below a high tension power line. The vertical stabilizer contacted the lowest wire which tore loose the vertical stabilizer. The acft pitched nose up, then it dove down, crashed…NTSB DCA84AA022Accident · 1 fatalFinal reportMitsubishi MU-2B-60 · Burlington, CTThe acft was flown earlier in the day for a sales demonstration. On the return flt, when the landing gear were lowered, the plt thought he heard a noise emitting from the gear, although cockpit indications were normal. The acft landed at johnnycake arpt & was…NTSB ATL84IA134Incident · No injuriesIncident investigationFinal reportBeech C90 · Herndon, VAThe acft entered an uncommanded dive at about 11,000 ft MSL, with recovery made below 2,000 ft MSL. Investigation revealed that during the descent, in order to accomodate other air traffic, the plt exceeded vne speeds. Shortly, thereafter the elevator trim…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…