NTSB investigations: Diamond Aircraft Ind DA 40, 2023
6 cases on aircraft the registry lists as Diamond Aircraft Ind DA 40. 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
| 2004 | 3 |
|---|---|
| 2005 | 1 |
| 2007 | 2 |
| 2008 | 2 |
| 2009 | 5 |
| 2010 | 3 |
| 2011 | 1 |
| 2012 | 1 |
| 2013 | 2 |
| 2014 | 2 |
| 2015 | 1 |
| 2016 | 1 |
| 2017 | 2 |
| 2018 | 4 |
| 2019 | 1 |
| 2020 | 3 |
| 2021 | 3 |
| 2022 | 3 |
| 2023 | 6 |
| 2024 | 1 |
| 2025 | 2 |
| 2026 | 2 |
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 year(c.\"eventDate\") = 2023
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2990002', '05611H8', '2990011'))
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 year(c."eventDate") = 2023
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2990002', '05611H8', '2990011'))
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 WPR24LA064Accident · No injuriesClass 3 · LimitedFinal reportDiamond Aircraft Ind DA 40 · Spanish Fork, UTMaintenance personnel’s improper installation of the left magneto, which resulted in oil starvation to the engine and a subsequent total loss of engine power.NTSB ANC24LA005Accident · Serious injuriesClass 3 · LimitedFinal reportDiamond Aircraft Ind DA 40 · Kapolei, HIA partial loss of engine power due to lose baffling from the muffler, which resulted in an obstruction of the exhaust system.NTSB ERA24LA061Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA 40 · Manassas, VAAn in-flight collision with a bird during initial climb.NTSB ERA23LA312Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA 40 · Roanoke, VAThe student pilot’s failure to maintain directional control during the landing, and the flight instructor’s inadequate remedial action.NTSB WPR23LA133Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA 40 · Winnemucca, NVThe student pilot’s failure to maintain directional control, and the flight instructor’s delayed remedial action.NTSB ERA23FA138Accident · 2 fatalClass 3 · FieldFinal reportDiamond Aircraft Ind DA 40 · West Palm Beach, FLThe pilots’ exceedance of the airplane’s critical angle of attack following a go-around/low pass over the runway, which resulted in a loss of control and impact with terrain.