NTSB investigations: Diamond Aircraft Ind DA 42 NG, FL
6 cases on aircraft the registry lists as Diamond Aircraft Ind DA 42 NG. 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
| 2012 | 1 |
|---|---|
| 2019 | 1 |
| 2020 | 1 |
| 2022 | 1 |
| 2023 | 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.\"eventStateOrRegion\" = 'FL' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2990105', '2990205'))
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."eventStateOrRegion" = 'FL' AND c."eventCountry" = 'USA'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2990105', '2990205'))
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 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.NTSB ERA22LA395Accident · 1 fatalClass 3 · LimitedFinal reportDiamond Aircraft Industries DA 42 · Orlando, FLThe flight crew’s insufficient evaluation of the deteriorating weather conditions in the area, which resulted in an encounter with a microburst.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.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.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.