Final NTSB investigations: Emroth-Emair MA-1
9 cases on aircraft the registry lists as Emroth-Emair 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
| 1975 | 1 |
|---|---|
| 1976 | 2 |
| 1977 | 1 |
| 1978 | 2 |
| 1985 | 1 |
| 1987 | 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 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 ('3280101'))
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 ('3280101'))
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 LAX87DJA09Accident · No injuriesFinal reportEmair MA-1-B · Paauilo, HIDuring an aerial application flt, just after take off, the plt noted that the engine oil temp was high and that blue smoke was coming from the engine. Unable to land at the airport, the acft collided with the terrain short of the runway and nosed over.…NTSB LAX87DJA08Accident · No injuriesFinal reportEmair MA-1B · Pahala, HIDuring an aerial application operation, while taking off, the aircraft veered off the runway and came to rest nose down. Inspection of the landing gear revealed that the left main landing gear scissor bolt broke.NTSB LAX85FJA01Accident · No injuriesFinal reportEmair MA-1 · Paanilo, HIThe plt initiated his 1st spray pass uphill with about a 5 to 10 kt quartering tail wind. While on the swath run, he noted the airspeed was decaying, so he aborted the pass by turning into the wind. However, this resulted in flying over more rapidly rising…NTSB OAK79DJA02Accident · No injuriesClosedMurrayair MA-1B · Maui, HINTSB OAK78DVA57Accident · No injuriesClosedEmair MA-1B · Tipton, CANTSB MIA77DLD40Accident · No injuriesClosedEmair MA-1B · Ocala, FLNTSB OAK77FVW05Accident · No injuriesClosedEmair 1200MA · Las Vegas, NVNTSB OAK76DJA16Accident · No injuriesClosedMurrayair MA-1 · Honokaa, HINTSB OAK76FJA08Accident · No injuriesClosedMurrayair MA-1 · Hilo, HI