Skip to content

NTSB investigations: Ercoupe 415-C, TX

21 cases on aircraft the registry lists as Ercoupe 415-C. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19642026

Where

Latest cases

Query with SQL

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" = 'TX' 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 ('0420322')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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\" = 'TX' 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 ('0420322'))
  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" = 'TX' 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 ('0420322'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 CEN17LA089Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Butterfield, TXA malfunction of the fuel transfer system for reasons that could not be determined based on the available information, a stuck float in the header tank sight gauge that resulted in an inaccurate fuel quantity indication, and the pilot’s inadequate monitoring…Jan 28, 2017 · N94694 · Substantial damage NTSB FTW03LA123Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Ranger, TXThe loss of engine power for an undetermined reason.Apr 4, 2003 · N93815 · Substantial damage NTSB FTW01LA077Accident · Serious injuriesLimited investigationFinal reportErcoupe 415-C · Houston, TXthe pilot's failure to execute a go-around after becoming low on a visual approach.Mar 13, 2001 · N93504 · Substantial damage NTSB FTW00LA213Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Stephenville, TXThe collision with a bird while in cruise flight.Jul 14, 2000 · N99236 · Substantial damage NTSB FTW97LA266Accident · No injuriesLimited investigationFinal reportErcoupe Ercoupe 415-C · Huntsville, TXInadvertent stall due to the student pilot's failure to maintain airspeed and a proper descent rate. A factor was the inadequate supervision by the flight instructor.Jul 7, 1997 · N99739 · Substantial damage NTSB FTW92LA083Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Whitehouse, TXThe pilot's inadequate preflight inspection and the engine power loss due to fuel contamination with water. A factor was the lack of suitable terrain available for the forced landing.Mar 7, 1992 · N94063 · Substantial damage NTSB FTW81FRG57Accident · No injuriesClosedErco 415-C · Seguin, TXAug 2, 1981 · N87039 · Substantial damage NTSB FTW81DRA10Accident · No injuriesClosedErco 415-L · Texas City, TXDec 11, 1980 · N99368 · Destroyed NTSB FTW79FQG54Accident · No injuriesClosedErco 415-C · Odessa, TXAug 12, 1979 · N99271 · Minor damage NTSB FTW72FRA18Accident · Minor injuriesClosedErco 415 · Houston, TXOct 30, 1971 · N93610 · Substantial damage NTSB FTW71FRG77Accident · No injuriesClosedErcoupe 415-C · San Antonio, TXFeb 5, 1971 · N93988 · Substantial damage NTSB FTW69F0532Accident · No injuriesClosedErcoupe 415-C · East Tawakoni, TXMay 27, 1969 · N99985 · Substantial damage NTSB FTW69F0234Accident · Serious injuriesClosedErco 415-C · Franklin, TXSep 24, 1968 · N87323 · Destroyed NTSB FTW69F0177Accident · No injuriesClosedErco 415-C · Keller, TXAug 29, 1968 · N99601 · Substantial damage NTSB FTW69D0053Accident · No injuriesClosedErcoupe 415-C · Wheeler, TXJun 10, 1968 · N94343 · Substantial damage NTSB FTW68D0393Accident · No injuriesClosedErco 415-C · Wichita Falls, TXDec 24, 1967 · N3387H · Substantial damage NTSB FTW67D0354Accident · Minor injuriesClosedErcoupe 415-C · Pecos, TXNov 30, 1966 · N87082 · Substantial damage NTSB FTW66F0676Accident · No injuriesClosedErcoupe 415-C · Frankston, TXMay 21, 1966 · N3136H · Destroyed NTSB FTW66F0539Accident · No injuriesClosedErcoupe 415-C · Cedar Hill, TXMar 20, 1966 · N99685 · Substantial damage NTSB FTW66D0498Accident · No injuriesClosedErcoupe 415-C · Plainview, TXFeb 5, 1966 · N2609H · Substantial damage NTSB UNK65X1017Accident · No injuriesClosedErcoupe 415C · Sunray, TXDec 15, 1964 · N93988 · Substantial damage