NTSB investigations: AiResearch 331 SER 605HP, 1985
2 cases on aircraft whose registry engine model is AiResearch 331 SER 605HP. 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
| 1967 | 2 |
|---|---|
| 1968 | 2 |
| 1969 | 2 |
| 1970 | 1 |
| 1971 | 1 |
| 1973 | 2 |
| 1977 | 1 |
| 1978 | 4 |
| 1979 | 7 |
| 1980 | 4 |
| 1981 | 1 |
| 1982 | 4 |
| 1983 | 1 |
| 1984 | 3 |
| 1985 | 2 |
| 1986 | 1 |
| 1987 | 1 |
| 1994 | 1 |
| 1995 | 1 |
| 1998 | 1 |
| 2002 | 1 |
| 2003 | 2 |
| 2005 | 2 |
| 2017 | 1 |
| 2021 | 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 year(c.\"eventDate\") = 1985
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('01502'))
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") = 1985
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('01502'))
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 FTW86FA015Accident · 1 fatalField investigationFinal reportMitsubishi MU-2B-2D · El Paso, TXThe plt canceled his IFR flt plan and attempted to fly VFR at a relatively low alt over mountainous terrain with low scattered clouds on a dark night. He reported a large lighted area as being downtown El Paso when in reality it was most likely coronado…NTSB NYC85LA074Accident · No injuriesLimited investigationFinal reportAero Commander 680V · Kingstown, RIWhile en route at 12,500 ft, the plt noted a slight shudder & heard a 'wind noise' then the gear unsafe light illuminated. The plt slowed the acft to 135 KTS & tried recycling the gear, but the gear only dropped to the point where it would twist. All attempts…