NTSB investigations: Diamond Aircraft Ind DA20-C1, AZ
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
| 2005 | 1 |
|---|---|
| 2007 | 1 |
| 2008 | 1 |
| 2013 | 1 |
| 2014 | 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\" = 'AZ' 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" = 'AZ' 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 WPR25LA009Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA20-C1 · Mesa, AZThe pilot receiving instruction’s failure to maintain airspeed during landing and the flight instructor’s delayed remedial action, which resulted in a hard landing.NTSB WPR14CA156Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 20 C1 · Mesa, AZThe student pilot's excessive speed during taxi which resulted in a runway overrun. Contributing to the accident was the pilot's inadequate monitoring of the remaining runway length available during the landing roll.NTSB WPR13LA331Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Ind DA 20-C1 · Mesa, AZThe student pilot’s failure to monitor and maintain clearance while taxiing, which resulted in collision with the parked airplane. Contributing to the accident was the parked airplane’s insufficient distance from the taxiway centerline.NTSB WPR09FA062Accident · 1 fatalField investigationFinal reportDiamond DA 20-C1 · Alamo Lake State Park, AZThe pilot's failure to maintain control during the performance of a maneuver and his failure to recover from the subsequent aerodynamic stall and spin.NTSB LAX08CA031Accident · No injuriesData collectionFinal reportDiamond Aircraft Industries DA-20-C1 · Mesa, AZthe student pilot's failure to maintain the proper glide path and misjudged flare, which resulted in a hard landing.NTSB LAX05LA170Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Industries DA 20-C1 · Glendale, AZthe pilot's misjudged landing flare that resulted in a stall and hard landing.