NTSB investigations: Thielert TAE-125-02-99
5 cases on aircraft whose registry engine model is Thielert TAE-125-02-99. 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
| 2008 | 1 |
|---|---|
| 2012 | 1 |
| 2018 | 1 |
| 2021 | 1 |
| 2024 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('59302'))
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.engine_model_code IN ('59302'))
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 ERA25LA068Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA 42 NG · Daytona Beach, FLThe maintenance technician’s failure to follow the manufacturer’s recommended procedures during a wheel and tire change to ensure proper clearance of the tire to the wheel well resulting in the right main wheel becoming stuck in the well and subsequent…NTSB ERA21LA322Accident · No injuriesClass 3 · LimitedFinal reportDiamond DA42 · Hiddenite, NCThe flight instructor’s inability to stop the descent following a practice emergency descent for reasons that could not be determined.NTSB GAA18CA198Accident · No injuriesData collectionFinal reportCessna 172 · Brunswick, GAThe pilot receiving instruction’s failure to see and avoid an airplane holding short of the runway on the taxiway and the flight instructor’s lack of situational awareness.NTSB ERA13LA043Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Ind DA 42 NG · Palm Coast, FLThe pilot’s failure to maintain adequate airspeed, which resulted in a hard landing.NTSB MIA08LA205Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Ind DA42 · Lancaster, PAThe pilot's improper flare which resulted in a hard landing. Contributing to the accident was the pilot's lack of experience in the accident airplane make and model.