NTSB investigations: Mitsubishi MU-2B-35, 1988
2 cases on aircraft the registry lists as Mitsubishi MU-2B-35. 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
| 1976 | 1 |
|---|---|
| 1977 | 2 |
| 1978 | 3 |
| 1979 | 1 |
| 1980 | 1 |
| 1981 | 3 |
| 1984 | 1 |
| 1985 | 1 |
| 1986 | 1 |
| 1988 | 2 |
| 1989 | 1 |
| 1990 | 1 |
| 1993 | 2 |
| 1995 | 1 |
| 2000 | 1 |
| 2001 | 1 |
| 2002 | 1 |
| 2003 | 1 |
| 2006 | 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\") = 1988
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('5780411'))
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") = 1988
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('5780411'))
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 DCA89LA012Accident · 1 fatalLimited investigationFinal reportMitsubishi MU-2J · Missing (Pacific Ocean)During a flt at night from majuro, marshall islands to cairns, australia, the plt requested a dscnt from FL 190 to 12,000 to remove ice from the airframe. Later, he requested a climb to FL 200. After starting the climb, he made a mayday call to sidney flt…NTSB NYC88LA085Accident · No injuriesLimited investigationFinal reportMitsubishi MU-2B-35 · Philadelphia, PAThe Mitsubishi MU-2B-35 landed and damage was observed on the underside of the left wing midway between the engine and tip tank and outboard to the tip tank. Further examination of the wing showed a broken lower front wing spar and a bent rear lower wing…