NTSB investigations: Engineering & Research 415-CD
10 cases on aircraft the registry lists as Engineering & Research 415-CD. 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
| 1971 | 2 |
|---|---|
| 1972 | 1 |
| 1977 | 1 |
| 1980 | 1 |
| 1983 | 1 |
| 1985 | 1 |
| 1990 | 1 |
| 1999 | 1 |
| 2002 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('0420304'))
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 ('0420304'))
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 CHI02LA281Accident · No injuriesLimited investigationFinal reportErcoupe 415-CD · Effingham, ILThe partial loss of engine power due to the seized exhaust valve. A factor was the soft field.NTSB CHI99LA236Accident · No injuriesLimited investigationFinal reportErcoupe 415-CD · Wahoo, NEThe pilot's improper starting technique which resulted in the inadvertent starting of the engine, with no one in the airplane.NTSB FTW90FA092Accident · 1 fatalField investigationFinal reportErcoupe 415CD · Hereford, TXInadvertent stall. Factors were maximum gross weight exceeded by the pilot, the pilot's impairment due to drugs, and the pilot's lack of total experience.NTSB NYC85FA222Accident · 1 fatalField investigationFinal reportErcoupe 415-C · Carlisle, PADuring the second takeoff attempt from a pvt grass strip witnesses heard the eng sputter then quit soon after liftoff. The acft then descended to ground impact and burned. The acft had not been flown adn was kept out of doors for several months while the…NTSB LAX84FA028Accident · 1 fatalField investigationFinal reportErcoupe 415-CD · Compton, CAThe acft experienced a total power loss on takeoff & was demolished in the impact sequence & post crash fire. According to several interviewees the pilot had performed extensive non-stc'd modifications to the acft including the fuel system. An 'automotive…NTSB MIA80DA079Accident · 2 fatalClosedErco 415-D · Missing AircraftNTSB ANC77DAG35Accident · Minor injuriesClosedErco 415-D · Anchorage, AKNTSB DEN73FQD13Accident · No injuriesClosedErco 415-CD · Alamogordo, NMNTSB DEN72AD020Accident · 1 fatalClosedErco 415-CD · Kit Carson, CONTSB SEA72AS011Accident · 1 fatalClosedErco 415C · Boise, ID