Final NTSB investigations: Emroth-Emair MA-1B
11 cases on aircraft the registry lists as Emroth-Emair MA-1B. 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
| 1977 | 1 |
|---|---|
| 1978 | 1 |
| 1981 | 2 |
| 1985 | 1 |
| 1987 | 2 |
| 1989 | 1 |
| 1995 | 1 |
| 1996 | 1 |
| 1998 | 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.\"completionStatus\" = 'Completed'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('3280103'))
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."completionStatus" = 'Completed'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('3280103'))
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 LAX98LA286Accident · No injuriesLimited investigationFinal reportEmroth-Emair MA-1B · Lihue, HIThe failure of the pilot to maintain directional control of the aircraft during the landing.NTSB FTW96LA333Accident · No injuriesLimited investigationFinal reportEmroth-Emair MA-1B · Clayton, LAThe pilot's failure to maintain directional control during the takeoff roll. A factor was the wet grass runway.NTSB LAX96LA064Accident · No injuriesLimited investigationFinal reportEmroth Emair MA-1B · Pahala, HIthe failure of the pilot to adequately compensate for wind conditions, and to maintain directional control of the aircraft during the landing.NTSB LAX90DJA01Accident · Minor injuriesFinal reportEmair MA1-B · Hilo, HIThe failure of a main landing gear tire which caused the pilot to apply excessive brake pressure to avoid departing a narrow landing strip. Contributing to the accident was the pilot accepting an aircraft that had a tire worn beyond safe limits and…NTSB LAX87DJA07Accident · No injuriesFinal reportEmair MA-1B · Pahala, HIAt the end of an aerial application flt, the plt reported that after approaching the arpt in a light rain, he failed to keep the acft centered on the rwy. The acft exited the rwy to the left where it collided with the terrain and nosed over. There were no…NTSB LAX87DJA03Accident · Serious injuriesFinal reportEmroth Emair MA-1B · Naalehu, HIDuring an aerial application flight, the aircraft was observed to make a downwind run when the pilot dumped the load collided with the terrain, become airborne and eventually collided with trees. Witnesses stated that they heard the engine running and that it…NTSB LAX85FJA06Accident · 1 fatalFinal reportEmroth Emair MA-1B · Pahala, HIWitnesses reported seeing pieces of wood and fabric coming off the acft during it's second swath run. At the end of the run, the acft climbed abruptly to clear trees after which it entered an uncontrolled descent to ground impact. The acft was destroyed by…NTSB ATL81DKQ15Accident · No injuriesClosedEmair MA-1B · Webb, MSNTSB LAX81DJA05Accident · No injuriesClosedMurrayair MA-1B · Honokaa, HINTSB OAK79DJA03Accident · No injuriesClosedMurrayair MA1B · Honokaa, HINTSB OAK78DJA02Accident · No injuriesClosedEmair MA-1 · Lihue, HI