Engineering & Research ERCOUPE 415-C
FAA incident reports · 114
Matched to the registry by N-number and event date, newest first.
Query with SQL
duckdb -csv -c "SELECT report_number, event_date, event_type, city, state, aircraft_make, aircraft_model, aircraft_damage, fatal_injuries, n_number
FROM 'https://openairdocs.org/data/latest/faa_incident_report.parquet'
WHERE aircraft_model_code IN ('0420312')
ORDER BY event_date DESC, report_number 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 report_number, event_date, event_type, city, state, aircraft_make, aircraft_model, aircraft_damage, fatal_injuries, n_number
FROM 'https://openairdocs.org/data/latest/faa_incident_report.parquet'
WHERE aircraft_model_code IN ('0420312')
ORDER BY event_date DESC, report_number 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.
Accident 19751108035709AUnivar 415C · Pittsfield, ILTotal brake fluid loss.Accident 19750913035249AUnivar 415C · Pensacola, FLPwr off apch with hi sink rate.Accident 19750907028689AUnivar 415C · Pearsall, TXPlt had 2 hrs in 2 ctl type acft.Accident 19750824027289AUnivar 415C · Sonoma, CAStdnt plt cert expired over 3YR.acft 2 mos out of annual.Accident 19750109000899AUnivar 415C · Vacaville, CAAccident 19741011039749AUnivar 415C · Plainwell, MIShort fld ldg,rate of dscnt increased aftr clrg obstructing brush. Wind gusting 20K.Accident 19740713021449AUnivar 415C · Hartington, NEAccident 19740612017839AUnivar 415C · Casper, WYFuel pump malfunction.Accident 19740421007809AUnivar 415C · Gretna, LANr 1 cyl connecting rod failed. Plt tried to lnd on hwy.Accident 19740318005999AUnivar 415C · Alice, TXEng lost pwr prev. Plt on final to arpt when eng regained pwr. Made go arnd ok,then eng quit.Accident 19731211039679AUnivar 415C · West Middlesex, PAUndershot approach struck trees on approach end of runwayAccident 19730920031669AUnivar 415C · Portage, WIPilot landed in crabbed attitude. Scuffed nose tire sidewall on pavement.Accident 19730909029679AUnivar 415C · Silver City, OKStdnt plt prtcng lndg on sand bar in river. Acft hit wtr short of sand bar. Eng did not accelerate.Accident 19730223003999AUnivar 415C · Bardwell, KYFuel pump failed to supply fuel from wing tank to nose header tank. Lndd on soft fld.
Back to Engineering & Research ERCOUPE 415-C