NTSB investigations: Diamond Aircraft Ind DA20-C1
89 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, newest first
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.\"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."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 CEN13LA291Accident · Minor injuriesLimited investigationFinal reportDiamond Aircraft Ind DA 20-C1 · Englewood, COThe in-flight separation of the engine throttle lever and throttle cable due to maintenance personnel not applying sufficient torque to the self-locking nut or improperly reusing a degraded self-locking nut.NTSB WPR13CA170Accident · No injuriesData collectionFinal reportDiamond DA 20-C1 · Provo, UTThe student pilot’s failure to maintain airspeed and airplane control during an attempted go-around.NTSB ERA12LA246Accident · Serious injuriesLimited investigationFinal reportDiamond Aircraft Ind DA 20-C1 · Beaver Falls, PAThe operator’s maintenance personnel’s improper adjustment of the engine's fuel system, which resulted in a total loss of engine power.NTSB CEN12FA080Accident · 1 fatalField investigationFinal reportDiamond Aircraft Ind DA 20-C1 · Bern, WIThe non-instrument-rated pilot's continued visual flight into instrument meteorological conditions, which resulted in a loss of control and subsequent impact with the terrain.NTSB CEN12CA041Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 20-C1 · Pueblo, COThe certified flight instructor’s delayed remedial action. Contributing to the accident was the student pilot's failure to maintain control prior to the landing.NTSB ERA12LA034Accident · Minor injuriesLimited investigationFinal reportDiamond Aircraft Ind DA 20-C1 · Newnan, GAA total loss of engine power for undetermined reasons.NTSB ERA11LA306Accident · Serious injuriesLimited investigationFinal reportDiamond Aircraft Ind DA 20-C1 · Wurtsboro, NYThe pilot’s performance of aerobatic maneuvers at low altitude and his failure to maintain airspeed, which resulted in an aerodynamic stall.NTSB WPR11FA050Accident · 2 fatalField investigationFinal reportDiamond Aircraft Ind DA20-C1 · Payson, UTThe pilots' failure to maintain adequate airspeed during a slow flight maneuver that resulted in a stall and spin, and the flight instructor’s delayed or improper remedial actions to recover from the spin. Contributing to the accident was the flight school’s…NTSB CEN10IA554Incident · No injuriesIncident investigationFinal reportDiamond Aircraft Ind DA 20-C1 · Bloomington, ILThe cracked nose landing gear fork assembly found during the preflight inspection.NTSB CEN10CA373Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 20-C1 · Bloomington, ILThe pilot's failure to maintain adequate airspeed during landing, which resulted in a stall.NTSB ERA10CA196Accident · No injuriesData collectionFinal reportDiamond DA20 · Chesapeake, VAThe pilot's improper recovery from a bounced landing.NTSB WPR10CA146Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 20-C1 · Delta, UTThe student pilot's incorrect use of the flaps and failure to attain and maintain an adequate airspeed during the attempted go-around procedure, which led to a stall/mush condition. Contributing to the accident was the student pilot's lack of familiarity with…NTSB WPR09CA322Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 20-C1 · Spanish Fork, UTThe student pilot’s improper landing flare.NTSB CEN09CA300Accident · Minor injuriesData collectionFinal reportDiamond DA20 · Olathe, KSThe student pilot's improper landing flare and recovery from a bounced landing, as well as his improper decision to continue the takeoff after striking the propeller on the runway.NTSB CEN09CA304Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 20-C1 · San Antonio, TXThe instructor pilot’s improper landing flare.NTSB ERA09CA268Accident · No injuriesData collectionFinal reportDiamond DA20 · Townsend, GAThe pilot's failure to maintain directional control during a landing roll with a crosswind. Contributing to the accident was the pilot's lack of experience in the make and model airplane.NTSB ERA09LA239Accident · Serious injuriesLimited investigationFinal reportDiamond DA20 · Shelbyville, TNA partial loss of engine power for an undetermined reason.NTSB ERA09CA192Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 20-C1 · Morristown, NJThe student pilot's failure to maintain directional control during the takeoff roll.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 NYC08CA313Accident · No injuriesData collectionFinal reportDiamond Aircraft Industry DA 20-C1 · Stevensville, MDThe student pilot's failure to maintain directional control during takeoff.NTSB DFW08TA225Accident · Serious injuriesFinal reportDiamond Aircraft Industries DA-20-C-1 · Pueblo, COThe student pilot's inability to maintain aircraft control due to an encounter with wake turbulence from a preceding larger aircraft. Contributing to the accident was the instructor pilot's failure to intervene.NTSB MIA08LA156Accident · Minor injuriesLimited investigationFinal reportDiamond DA-20-C1 · Peachtree City, GAA partial loss of engine power for undetermined reasons.NTSB MIA08CA148Accident · No injuriesData collectionFinal reportDiamond DA20-C1 · Norfolk, VAThe flight instructor's inadequate supervision of the student pilot while taxiing for takeoff. A factor contributing to the accident was the student pilot's failure to maintain a visual lookout.NTSB DEN08CA067Accident · No injuriesData collectionFinal reportDiamond Aircraft Industries DA 20-C1 · Pueblo, COthe failure of the student pilot, and then the flight instructor to maintain aircraft control during the landing. Contributing factors were the flight instructor's delayed remedial action, and the crosswind conditions.NTSB SEA08LA090Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Industries DA 20-C1 · Spanish Fork, UTThe fatigue failure of the nose wheel fork assembly attachment stud/bolt during takeoff initial climb, and the collapse of the nose gear during landing.NTSB NYC08LA116Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Industries DA 20 · Key West, FLA loss of engine power for undetermined reasons.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 SEA08LA008Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Industries DA 20-C1 · Santaquin, UTA total loss of engine power for undetermined reasons. Factors include rough/uneven vegetation-covered terrain at the location where the pilot executed his emergency forced landing.NTSB SEA07CA184Accident · No injuriesData collectionFinal reportDiamond Aircraft Industries DA20-C1 · La Pine, ORThe pilot's selection of an unsuitable landing site for a precautionary landing. Contributing factors were the pilot's failure to refuel the airplane, the low fuel level, and trees.NTSB DEN07IA066Incident · No injuriesIncident investigationFinal reportDiamond Aircraft Industries DA-20-C1 · Pueblo, COThe failure of the horizontal stabilizer forward bracket bolts due to insufficent preload during factory installation.NTSB NYC06LA086Accident · Serious injuriesLimited investigationFinal reportDiamond Aircraft Industries DA 20-C1 · Clay Township, PAA loss of engine power during cruise flight for undetermined reasons, which resulted in a forced landing and subsequent impact with trees.NTSB DFW05FA244Accident · 2 fatalField investigationFinal reportDiamond Aircraft Industries DA20-C1 · Pleasanton, TXThe flight instructor's failure to maintain clearance from an unmarked transmission line. A contributing factor was the low altitude flight.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.NTSB ATL04LA022Accident · No injuriesLimited investigationFinal reportDiamond DA 20-C1 · Murfreesboro, TNThe pilot's failure to attain adequate airspeed, which resulted in a stall mush and collision with a taxiway sign. A factor was the pilot's delay in aborting the landing.NTSB IAD03CA065Accident · No injuriesData collectionFinal reportDiamond Aircraft Industries DA20-C1 Katana · Hillsboro, TXThe pilot's failure to maintain directional control of the airplane during the takeoff roll. A factor in the accident was the pilot's lack of total flying experience.NTSB DEN03LA008Accident · Minor injuriesLimited investigationFinal reportDiamond Aircraft Industries DA20-C1 · Grand Junction, COThe pilot's inadequate preflight and in-flight planning resulting in fuel mismanagement and fuel exhaustion.NTSB NYC02FA131Accident · 1 fatalField investigationFinal reportDiamond Aircraft Industries DA 20C-1 · Leesburg, VAA loss of engine power for undetermined reasons.NTSB DEN01LA122Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Industries DA 20C-1 · Provo, UTthe inadvertent stall by the pilot during an aborted landing. Contributing factors were an excessive flare, premature retraction of the flaps, and gusty wind conditions.NTSB DEN00IA133Incident · No injuriesIncident investigationFinal reportDiamond Aircraft Industries 20C-1 · Spanish Fork, UTThe company maintenance personnel's inadequate torquing procedures of the propeller attachment bolts which resulted in the fatigue failure of the propeller attachment bolts and the in-flight separation of the propeller.