NTSB investigations: AiResearch TPE331 series, 1999
7 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\") = 1999
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") = 1999
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 MIA00LA004Accident · No injuriesLimited investigationFinal reportFairchild SA227-AC · Opa Locka, FLThe improper flare by the co-pilot, and the failure of the captain to take remedial action by applying power to arrest the observed high rate of descent resulting in a hard landing. A finding in the accident was the inadequate maintenance adjustment of the…NTSB LAX99LA281Accident · Minor injuriesLimited investigationFinal reportAyres S2R-G10 · Stanfield, AZThe pilot's delay in aborting the takeoff after noting sluggish acceleration during the takeoff roll, which resulted in a runway overrun.NTSB CHI99LA175Accident · No injuriesLimited investigationFinal reportAyres S2R-G10 · North Platte, NEThe pilot failed to maintain directional control during takeoff.NTSB IAD99LA045Accident · No injuriesLimited investigationFinal reportGulfstream American 690C · Hot Springs, VAA hard landing due to the pilot's inadequate compensation for the wind conditions.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 DEN99LA047Accident · No injuriesLimited investigationFinal reportSwearingen SA226TC · Denver, COThe pilot of N328BA's failure to maintain visual lookout while taxiing, causing the subsequent collision with N151SA.NTSB NYC99IA056Incident · No injuriesIncident investigationFinal reportPiper PA42-1000 · Lexington, KYImproper assembly of the engine gearcase by the manufacturer, which resulted in an uncontained failure of the 1st bull gear.