NTSB investigations: AiResearch 331 SER 605HP, 1982
4 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\") = 1982
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") = 1982
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 CHI83LA051Accident · Minor injuriesLimited investigationFinal reportMitsubishi MU-2B-20 · Muskegon, MIThe pilot descended below his altitude and struck trees approximately 4.7 miles south of his destination. The aircraft continued to fly and the pilot elected to make an emergency landing. After touchdown the aircraft skidded down the runway for approximately…NTSB ATL83FA039Accident · Serious injuriesField investigationFinal reportAero Commander 680W · Atlanta, GAThe plt reported that on the previous flt, the center fuel tank gauge was malfunctioning and indicated 800 lbs even when it was full with 1400 lbs. After lndg at charlotte,NC, it was still indicating 800 lbs. Bfr tkof, the center tank was refilled. While en…NTSB MKC82DA146Accident · No injuriesFinal reportMitsubishi MU-2B-20 · Camdenton, MOThe pilot landed hard damaging the landing gear on a paved area short of the displaced threshold. Flaps were set at 20 degrees instead of 40 degrees. After initial landing, the aircraft swerved right and went off the runway.NTSB MKC82IA137Incident · No injuriesIncident investigationFinal reportMitsubishi MU-2B-25 · St. Joseph, MOAfter takeoff, the pilot was cleared to climb to 6000 ft MSL. While climbing through about 5000 ft, he heard a loud noise (bam) as the left engine lost power. The left engine was shut down and feathered and a landing was made with no other problems. An…