NTSB investigations: Mitsubishi MU-2B
12 cases on aircraft the registry lists as Mitsubishi MU-2B. 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
| 1968 | 2 |
|---|---|
| 1970 | 1 |
| 1971 | 1 |
| 1973 | 1 |
| 1976 | 1 |
| 1979 | 2 |
| 1980 | 1 |
| 1981 | 1 |
| 1982 | 1 |
| 1985 | 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 c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('5780404'))
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 c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('5780404'))
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 MIA85IA203Incident · No injuriesIncident investigationFinal reportMitsubishi MU-2K · San Juan, PRAfter departure the nose gear unsafe light remained illuminated peter gear retraction. Attempts to get a safe light on the nose gear in the extended position was unsuccessful and when the aircraft landed it settled onto a partially retracted nose gear.…NTSB LAX82FA255Accident · Minor injuriesField investigationFinal reportMitsubishi MU-2B · Schellville, CAAt approximately 800 ft down the left side of the rwy the left eng experienced a power loss. The acft swerved off the left side of the rwy colliding with a drainage ditch & coming to rest inverted. Examination of the fuel control unit revealed that the…NTSB MIA81FA072Accident · No injuriesClosedMitsubishi MU-2 · Miami, FLNTSB LAX81FA088Accident · 1 fatalClosedMitsubishi MU-2B · Henderson, NVNTSB MKC79FA046Accident · 7 fatalClosedMitsubishi MU-2B · Hays, KSNTSB MKC79FCG38Accident · No injuriesClosedMitsubishi MU-2B · Gardner, KSNTSB IAD76FLQ36Accident · No injuriesClosedMitsubishi MU-2B · Louisville, KYNTSB FTW74AF040Accident · 1 fatalClosedMitsubishi MU-2B · Coleman, TXNTSB MKC72FCD49Accident · Serious injuriesClosedMitsubishi MU-2B · Lemars, IANTSB CHI71FGD22Accident · Serious injuriesClosedMitsubishi MU-2B · Northfield, OHNTSB MKC69A0039Accident · 5 fatalClosedMitsubishi MU-2B · Springfield, MONTSB NYC68F0411Accident · No injuriesClosedMitsubishi MU-2B · Pittsburgh, PA