Fatal NTSB investigations: Diamond Aircraft Ind DA 40
11 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 | 1 |
|---|---|
| 2007 | 1 |
| 2009 | 1 |
| 2010 | 1 |
| 2012 | 1 |
| 2013 | 1 |
| 2014 | 1 |
| 2022 | 2 |
| 2023 | 1 |
| 2026 | 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.\"highestInjuryLevel\" = 'Fatal'
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 c."highestInjuryLevel" = 'Fatal'
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 CEN27LA005Accident · 2 fatalClass 3 · LimitedPreliminary reportDiamond Aircraft Ind DA 40 · Eldorado Springs, COOn October 4, 2026, about 2130 mountain daylight time, a Diamond Aircraft DA-40 airplane, N162GL, was destroyed when it was involved in an accident near Eldorado Springs, Colorado. The pilot and passenger were fatally injured. The airplane was operated as a…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.NTSB ERA22LA362Accident · 1 fatalClass 3 · LimitedFinal reportDiamond DA-40 · Bardstown, KYThe pilot’s failure to provide adequate instructions to remain seated until the engine was shut down, which resulted in the passenger’s decision to exit the cockpit while the engine was operating and subsequently being struck by the rotating propeller.NTSB WPR22FA164Accident · 4 fatalClass 3 · FieldFinal reportDiamond Aircraft Ind DA 40 · Cedar City, UTThe pilot’s failure to maintain obstacle clearance, which resulted in controlled flight into terrain. Contributing to the accident was the pilot’s decision to operate the airplane above its maximum gross weight.NTSB CEN14WA502Accident · 1 fatalForeign investigationDiamond Aircraft Ind DA 40 · Kulusuk, GreenlandOn September 11, 2014, about 1600 coordinated universal time, a Diamond Aircraft Industries Inc. DA 40 airplane, N39SE, owned and operated by Milou 1 LLC, was substantially damaged when it impacted terrain near Kulusuk, Greenland. Visual meteorological…NTSB ERA13WA319Accident · 2 fatalForeign investigationDiamond DA40-180 · Ticlio, PeruNTSB ERA13FA083Accident · 1 fatalField investigationFinal reportDiamond Aircraft Ind DA 40 · Lake Park, GAThe noninstrument-rated pilot’s improper decision to depart in dark, night marginal visual flight rules conditions, which resulted in his spatial disorientation and subsequent loss of airplane control.NTSB ERA11FA085Accident · 1 fatalField investigationFinal reportDiamond Aircraft Ind DA 40 · Pearlington, MSThe pilot’s controlled flight into terrain likely due to spatial disorientation, while flying over sparsely lighted terrain at night.NTSB WPR09FA146Accident · 2 fatalField investigationFinal reportDiamond Aircraft Ind DA-40 · Arcata, CAThe pilot's failure to maintain proper altitude and glidepath while executing a night instrument approach. Contributing to the accident was the pilot's fatigue.NTSB LAX07FA160Accident · 2 fatalField investigationFinal reportDiamond Aircraft Industries DA 40 · Lake Pleasant, AZThe pilot's failure to maintain sufficient altitude above the surface of water during an intentional buzzing maneuver. Contributing to the accident was the nighttime lighting environment.NTSB ATL05FA034Accident · 3 fatalField investigationFinal reportDiamond DA40-180 · Pelzer, SCThe pilot's failure to follow IFR procedures and to maintain assigned altitude resulting in a collision with a transmission wire and trees.