NTSB investigations: Diamond Aircraft Ind DA20-C1, IN
6 cases on aircraft the registry lists as Diamond Aircraft Ind DA20-C1. 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
| 2015 | 1 |
|---|---|
| 2019 | 2 |
| 2021 | 1 |
| 2023 | 1 |
| 2025 | 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\" = 'IN' 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 ('2990001'))
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" = 'IN' 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 ('2990001'))
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 CEN25LA392Accident · No injuriesClass 4 · LimitedFinal reportDiamond DA20-C1 · Terre Haute, INThe failure of the nose landing gear strut and associated nosewheel separation during takeoff.NTSB CEN23LA281Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA20-C1 · Jeffersonville, INThe pilot’s improper fuel management, which resulted in fuel exhaustion and a total loss of engine power.NTSB CEN21LA134Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA20-C1 · Indianapolis, INThe pilot’s improper landing flare that resulted in a bounced touch and go landing and subsequent nose wheel separation.NTSB GAA19CA569Accident · No injuriesData collectionFinal reportDiamond DA20 · Fort Wayne, INThe pilot's improper preflight fuel planning, which resulted in fuel exhaustion, a total loss of engine power, and impact with a tree during an off-airport landing.NTSB GAA19CA330Accident · No injuriesData collectionFinal reportDiamond DA20 · Terre Haute, INThe student pilot's failure to maintain the runway heading and to relinquish the flight controls to the flight instructor when told to do so while landing in gusting, crosswind conditions, which resulted in a runway excursion and impact with runway lighting.NTSB CEN15LA106Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Ind DA 20 C1 · Shipshewana, INThe total loss of engine power due to impact ice obstructing the primary air induction system, which resulted from the student pilot’s failure to operate the alternate air control. Contributing to the accident was the student pilot’s lack of knowledge about…