NTSB investigations: Austro E4-A

5 cases on aircraft whose registry engine model is Austro E4-A, where NTSB found Aircraft control. 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

20192026
NTSB investigations: Austro E4-A per year, 2019–2026: 5 cases
20191
20211
20231
20241
20251

Latest 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.engine_model_code IN ('06402')
      AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE f.case_mkey = x.case_mkey AND f.aircrafts_position = x.position AND starts_with(f.\"findingCode\", '02063040')))
  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.

NTSB ERA25LA198Accident · Serious injuriesClass 3 · LimitedFinal reportDiamond Aircraft Ind DA 40 NG · Sanford, NCThe mechanic’s re-use of worm drive clamps, which resulted in a separation of the turbocharger air discharge duct and a partial loss of engine power during initial climb.May 7, 2025 · N499BW · Substantial damageNTSB WPR24LA116Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA 40 NG · Coolidge, AZThe student pilot’s improper landing flare, which resulted in a hard landing in gusty wind conditions. Contributing, was the failure of the flight instructor to intervene in a timely manner.Mar 21, 2024 · N755LA · Substantial damageNTSB ERA23LA140Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA 40 NG · Lake Katrine, NYThe pilot’s failure to maintain an appropriate pitch attitude and descent rate during landing, which resulted in a hard landing. Contributing to the accident was the flight instructor’s inadequate remedial action.Feb 6, 2023 · N871LA · Substantial damageNTSB CEN21FA252Accident · 2 fatalClass 3 · FieldFinal reportDiamond Aircraft Ind DA 40 NG · Darlington, INA loss of control while practicing an aerodynamic stall, which resulted in a spin and impact with terrain.Jun 6, 2021 · N853L · DestroyedNTSB GAA19CA431Accident · No injuriesData collectionFinal reportDiamond DA40 · Tavernier, FLThe pilot's delayed decision to go around in high-temperature and high-density altitude conditions and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.Jul 4, 2019 · N420NG · Substantial damage