Skip to content

Final NTSB investigations: Austro E4 series

11 cases on aircraft whose registry engine model is Austro E4 series. 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

20082026

Where

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."completionStatus" = 'Completed' AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('06400')) 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.\"completionStatus\" = 'Completed'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('06400'))
  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.engine_model_code IN ('06400'))
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 CEN26LA166Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA 42 NG · Colorado Springs, COMaintenance personnel's installation of an oversized tire, which prevented the left main landing gear from extending resulting in a precautionary gear up landing.Apr 9, 2026 · N311LH · Substantial damage NTSB WPR24LA256Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA 42 NG · Oshkosh, WIThe pilot’s failure to maintain control during an approach to land, which resulted in a hard landing.Jul 26, 2024 · N94NG · Substantial damage NTSB ERA23LA285Accident · Minor injuriesClass 3 · LimitedFinal reportDiamond DA40 · Yorktown Heights, NYA fatigue failure of the turbocharger housing, which resulted in a partial loss of engine power.Jun 29, 2023 · N44HH · Substantial damage NTSB ERA23LA177Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA 42 NG · Leesburg, FLThe flight instructor’s delayed remedial action, which resulted in a hard landing.Mar 31, 2023 · N306ER · Substantial damage NTSB WPR22LA159Accident · No injuriesClass 3 · LimitedFinal reportDiamond Aircraft Ind DA 42 · Long Beach, CAThe failure of the right main landing gear brace rib for reasons that could not be determined based on available information.Apr 19, 2022 · N822SA · Substantial damage NTSB ERA20CA143Accident · No injuriesData collectionFinal reportDiamond DA42 · Palm Coast, FLThe pilot receiving instruction’s failure to maintain airplane control during a simulated engine failure landing and subsequent attempted go-around in gusting crosswind conditions and the flight instructor's delayed remedial action.Apr 1, 2020 · N311ER · Substantial damage NTSB GAA19CA466Accident · No injuriesData collectionFinal reportDiamond DA 42 NG · Palatka, FLThe pilot receiving instruction's failure to extend the landing gear and the flight instructor's failure to verify that the landing gear was extended due to distraction, which resulted in a gear-up landing.Jul 10, 2019 · N805PA · Substantial damage NTSB WPR18LA118Accident · No injuriesClass 3 · LimitedFinal reportDiamond Aircraft Ind DA 42 NG · Bozeman, MTThe student pilot and flight instructor's failure to see and avoid the stationary airplane during taxi, which resulted in a ground collision.Apr 4, 2018 · N621ZC · 2 aircraft · Substantial damage NTSB WPR17LA050Accident · No injuriesClass 3 · LimitedFinal reportDiamond Aircraft Ind DA 40 NG · Kingman, AZThe loss of engine oil pressure during cruise flight, which resulted in partial loss of engine power and necessitated a forced landing. The loss of oil pressure was the result of a failed engine piston, likely initiated by foreign object damage, which…Dec 29, 2016 · N605SJ · Substantial damage NTSB WPR11CA336Accident · No injuriesData collectionFinal reportStearman C3-B · Spokane, WAThe pilot's failure to maintain directional control on landing. Contributing to the accident was the touch down in a slide-slip.Jul 16, 2011 · N3440 · Substantial damage NTSB SEA08LA206Accident · No injuriesLimited investigationFinal reportStearman C3-B · Stevenson, WAA loss of engine power due to fuel starvation from a piece of disintegrating gasket material that was blocking the fuel jet. Also causal was the failure of maintenance personnel to verify the condition of the gaskets when the carburetor was examined prior to…Sep 20, 2008 · N3440 · Substantial damage