NTSB investigations: Murrayair MA-1, HI
13 cases on aircraft the registry lists as Murrayair MA-1. 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
| 1971 | 1 |
|---|---|
| 1972 | 1 |
| 1975 | 1 |
| 1976 | 3 |
| 1977 | 1 |
| 1978 | 1 |
| 1979 | 2 |
| 1981 | 1 |
| 1983 | 1 |
| 1986 | 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.\"eventStateOrRegion\" = 'HI' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('6070102'))
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."eventStateOrRegion" = 'HI' AND c."eventCountry" = 'USA'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('6070102'))
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 LAX87DJA01Accident · No injuriesFinal reportMurrayair MA-1 · Hilo, HIAfter returning from a spraying flt, the acft was refueled. After refueling, the plt used fuel to wash oil from the side of the acft & the wing step. When the eng was restarted about 2 min later, fuel fumes ignited & fire spread to the fuel truck. Both the…NTSB LAX83FJA05Accident · 1 fatalFinal reportMurrayair MA1B · Nr Lihue Arpt, HIThe acft collided with a tree during a turn-around while engaged in aerial application operations. The pilot had made a few runs over the same field until he exhausted his load. After landing and reloading he returned to the area to finish the job and on the…NTSB LAX81DJA09Accident · No injuriesClosedEmair MA-1B · Hanamaulu, HINTSB OAK79DJA09Accident · No injuriesClosedMurrayair MA-1 · Waipahu, HINTSB OAK79DJA06Accident · No injuriesClosedEmair MA-1 · Keaau, HINTSB OAK78DJA10Accident · No injuriesClosedEmair MA1B · Keaau, HINTSB OAK77FJA14Accident · Serious injuriesClosedMurrayair MA-I · Lihue, HINTSB OAK7MDJA03Accident · No injuriesClosedMurrayair MA-1 · Keaau, HINTSB OAK76DJA22Accident · No injuriesClosedMurrayair MA-1 · Koloa, HINTSB OAK76DJA18Accident · Minor injuriesClosedMurrayair MA-1 · Pahala, HINTSB OAK76DJA07Accident · No injuriesClosedMurrayair MA-1 · Hilo, HINTSB OAK72FJA13Accident · No injuriesClosedMurrayair MA-1 · Barbers Pt, HINTSB OAK71FJA08Accident · No injuriesClosedMurrayair MA-1 · Waipahu, HI