NTSB investigations: Mitsubishi MU-2B-20, 1982
3 cases on aircraft the registry lists as Mitsubishi MU-2B-20. 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
| 1970 | 1 |
|---|---|
| 1971 | 1 |
| 1972 | 1 |
| 1973 | 3 |
| 1974 | 1 |
| 1976 | 1 |
| 1979 | 2 |
| 1981 | 1 |
| 1982 | 3 |
| 1985 | 2 |
| 1986 | 1 |
| 1987 | 2 |
| 1989 | 1 |
| 1991 | 1 |
| 1996 | 1 |
| 1999 | 1 |
| 2001 | 1 |
| 2002 | 1 |
| 2011 | 2 |
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.aircraft_model_code IN ('5780407'))
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.aircraft_model_code IN ('5780407'))
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 ATL83FA063Accident · Serious injuriesField investigationFinal reportMitsubishi MU-2B · Louisville, KYA takeoff was initiated from a 3539 ft wet/upsloping rwy. The gross wt of the acft was about 9300 lbs (300 lbs under themax gross wt). The plt stated the acft accelerated, but never reach '107.' After using about 2700 ft, the plt decided to abort the takeoff,…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.