NTSB investigations: Emigh TROJAN A-2

8 cases on aircraft the registry lists as Emigh TROJAN A-2. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19642026

NTSB investigations: Emigh TROJAN A-2 per year, 1964–2026: 8 cases
1964	1
1965	1
1966	2
1968	1
1972	1
2000	1
2026	1

Where

Open the map

Latest cases

Query with SQL

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 ('3270102')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 ('3270102'))
  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 ('3270102'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 WPR26LA227Accident · No injuriesClass 3 · LimitedPreliminary reportEmigh Trojan A2 · Healdsburg, CAOn June 21, 2026, about 1210 Pacific daylight time, an Emigh Trojan A-2, N8329H, was substantially damaged when it was involved in an accident near Healdsburg, California. The flight instructor and student pilot were not injured. The airplane was operated as…Jun 21, 2026 · N8329H · Substantial damage NTSB LAX00FA170Accident · 2 fatalField investigationFinal reportEmigh Trojan A2 · Brentwood, CAthe pilot's failure to maintain control of the airplane.Apr 22, 2000 · N8324H · Destroyed NTSB DEN73AD008Accident · 2 fatalClosedEmigh Acft Trojan · Edgewood, NMAug 23, 1972 · N8341H · Destroyed NTSB FTW68O0017Accident · 2 fatalClosedEmigh Acft Trojan · Punta Final, MexicoMar 23, 1968 · N8325H · Destroyed NTSB MKC67F0104Accident · Minor injuriesClosedEmigh A-2 · Wichita, KSJul 5, 1966 · N8347H · Substantial damage NTSB FTW66A0085Accident · 1 fatalClosedEmigh Acft A-2 · Freer, TXApr 2, 1966 · N8332H · Destroyed NTSB SEA66A0001Accident · 2 fatalClosedEmigh Trojan · Vacaville, CAJul 1, 1965 · N8321H · Destroyed NTSB UNK64X2988Accident · 2 fatalClosedEmigh TA-2 · San Pedro, CAJul 23, 1964 · N8349H · Destroyed