NTSB investigations: Ercoupe 415-C
416 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.
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 ('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."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" 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 DEN01LA065Accident · No injuriesLimited investigationFinal reportErco 415-C · Ivins, UTThe unsuitable terrain on which to make a forced landing. A contributing factors was the carburetor icing conditions.NTSB DEN00LA183Accident · 2 fatalLimited investigationFinal reportErcoupe 415-C · Tucumcari, NMloss of control during initial climb following takeoff by an unqualified person.NTSB SEA00LA175Accident · Serious injuriesLimited investigationFinal reportErcoupe 415-C · Wapato, WAThe pilot's failure to maintain clearance from the trees off the approach end of the runway, and his delay of the remedial action that would have allowed him to clear the trees. Factors include the pilot's failure to maintain a proper glidepath, trees off the…NTSB CHI00LA273Accident · Minor injuriesLimited investigationFinal reportErcoupe 415-C · Parsons, KSthe pilot not maintaining clearance from the fence post and not attaining the proper touchdown point. A factor was the fence post.NTSB FTW00LA213Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Stephenville, TXThe collision with a bird while in cruise flight.NTSB CHI00LA162Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Joliet, ILthe engine failure for undetermined reasons. Factors were the low altitude, remedial action not possible by the pilot, and the ditch.NTSB LAX00LA111Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · San Bernardino, CAthe total failure of the engine number 1 cylinder exhaust valve.NTSB CHI99LA242Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Bristol, WIthe pilot's failure to perform a proper recovery from the bounced landing, resulting in the airplane's nose gear striking the runway. A factor relating to the accident was the excessive airspeed maintained during the landing.NTSB LAX99LA061Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · San Ysabel, CAA fatigue fracture of the crankshaft and the resulting separation of the propeller.NTSB CHI98LA248Accident · Serious injuriesLimited investigationFinal reportForney 415-C · Laurie, MOthe jammed aileron and elevator controls for undetermined reasons.NTSB CHI98LA094Accident · 1 fatalLimited investigationFinal reportErcoupe 415-C · Wood Lake, NEthe pilot's intentional flight into adverse weather conditions, the wing ice, and the inadvertent stall. Factors contributing to this accident were the rain, freezing rain and low ceilings.NTSB MIA97LA234Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Siler City, NCFailure of the pilot to obtain a preflight weather briefing, inaccurate weather evaluation by the pilot, and his poor in-flight planning decision for descending too low to read a road sign.NTSB SEA97LA197Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Elma, WAThe pilot's inadequate compensation for wind conditions while landing. A factor was the crosswind.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.NTSB FTW97LA172Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Canon City, COThe pilot's failure to maintain an adequate visual lookout. A factor was the pilot's attention being diverted.NTSB CHI96LA311Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Cambridge, ILThe pilot's failure to maintain control of the airplane while landing. A factor associated with the accident was the downdraft reported by the pilot.NTSB LAX96LA282Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Page, AZdecision of the pilot to operate the airplane with an inoperative transfer pump and inaccurate fuel consumption calculations.NTSB BFO96LA038Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Hurlock, MDinadequate inspection by maintenance personnel which failed to detect a fatigue crack, and resulted in an in-flight crankshaft fracture and propeller assembly separation. A related factor was the deep snow encountered during the subsequent forced landing.NTSB CHI95LA004Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Cloverdale, INthe total loss of engine power due to a blocked orifice in the fuel pump. A related factor is the rough/uneven terrain encountered during the forced landing.NTSB NYC94LA153Accident · No injuriesLimited investigationFinal reportErcoupe 415C · Scriba, NYThe pilot's failure to maintain adequate airspeed which resulted in a stall and inflight collision with trees.NTSB LAX94LA167Accident · 1 fatalLimited investigationFinal reportErcoupe 415-C · Stallion Spring, CAThe pilot's continued VFR flight into instrument meteorological conditions. His failure to obtain a weather briefing, the low clouds, and the mountainous terrain were factors in the accident.NTSB BFO93FA188Accident · 2 fatalField investigationFinal reportErcoupe 415-CD · Charles City, VAthe pilot exceeded the design stress limits of the airplane which resulted in an in-flight break-up.NTSB LAX93LA374Accident · No injuriesLimited investigationFinal reportErcoupe 415C · Columbia, CAthe pilot's improper use of the elevator control during the takeoff ground roll which resulted in a porpoise and nose gear collapse. A factor in the accident was the pilot's low total experience and lack of total time in type.NTSB LAX93LA362Accident · Minor injuriesLimited investigationFinal reportErcoupe 415-C · Twentynine Palm, CAThe pilot's attemted takeoff from a taxiway due to alcoholic impairment. The night light condition was a factor.NTSB CHI93LA306Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Liberty, MOThe pilot's failure to maintain adequate aircraft control during the emergency landing. A factor is the pilot's lack of experience in the aircraft.NTSB CHI93LA186Accident · Minor injuriesLimited investigationFinal reportErcoupe 415C · Derby, KSThe pilot in command's misjudged approach to landing.NTSB SEA93LA098Accident · Minor injuriesLimited investigationFinal reportErcoupe 415-C · Helena, MTThe inadequate lookout by the PIC and his failure to maintain clearance from electrical wires. A factor relating to the accident was the presence of electrical wires near the approach end of the airstrip.NTSB CHI93LA005Accident · Minor injuriesLimited investigationFinal reportUnivair 415C · Waukesha, WIThe pilot's inadequate remedial actions and his misjudged emergency procedure (approach to landing).NTSB LAX92LA335Accident · Serious injuriesLimited investigationFinal reportErcoupe 415C · Dunsmuir, CAThe pilot's failure to perform any preflight planning or preparation and selected the wrong runway. Factors relating to this accident was the existing tailwind, high density altitude.NTSB LAX92LA272Accident · Minor injuriesLimited investigationFinal reportErcoupe 415C · Santa Clarita, CAFuel starvation caused by the inflight separation of the fuel gascolator bowl due to improper component installation.NTSB BFO92LA067Accident · No injuriesLimited investigationFinal reportErcoupe 415C · Vine Grove, KYThe pilot's failure to maintain directional control. Contributing factors were wind gusts and the pilot's inadequate compensation for wind.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.NTSB LAX91FA334Accident · 1 fatalField investigationFinal reportErcoupe 415C · Rubidoux, CAThe mechanic's improper installation of the magnetos and the pilot's failure to maintain flying speed. Factors related to this accident are the pilot's inadvertent stall and the residential area.NTSB LAX91LA196Accident · Minor injuriesLimited investigationFinal reportErcoupe 415C · King City, CAThe total loss of engine power which resulted from the drain valve fitting on a newly installed gascolator dislodging during cruise flight.NTSB DEN91LA062Accident · Minor injuriesLimited investigationFinal reportErcoupe 415-C · Santa Rosa, NMThe pilot of the other aircraft failed to maintain clearance between the aircraft.NTSB MIA91LA118Accident · Minor injuriesLimited investigationFinal reportErcoupe 415-C · Green Cove Spgs, FLLoss of control while on approach to land due to failure of the pilot to maintain vs resulting in the airplane stalling and impacting the ground nose low.NTSB LAX91LA089Accident · No injuriesLimited investigationFinal reportErcoupe 415C · Pixley, CAThe failure of the pilot to use carburetor heat in carburetor icing conditions. Contributing to the accident was the lack of experience in the accident airplane make and model.NTSB SEA91LA033Accident · 1 fatalLimited investigationFinal reportErco 415-C · Ola, IDThe pilot's failure to maintain sufficient altitude for terrain clearance. Also causal was the pilot's impairment due to alcohol. Contributing factors were the night light condition and the hilly terrain.NTSB CHI91DEM01Accident · 1 fatalFinal reportErcoupe 415C · Shelby, MIThe pilot's continued flight into IMC.NTSB FTW90LA187Accident · 1 fatalLimited investigationFinal reportErcoupe 415-C · Greers Ferry, ARThe pilot's decision to penetrate adverse weather and the resultant spatial disorientation. Factors were the weather conditions and the pilot's lack of instrument training/experience.NTSB CHI90LA207Accident · No injuriesLimited investigationFinal reportAircoupe F-1 · Washington, MOFailure of the other aircraft's pilot to maintain an adequate visual lookout prior to turning to final. A factor in the accident was the restricted visual lookout for this aircraft's pilot.NTSB DEN90LA137Accident · Minor injuriesLimited investigationFinal reportErcoupe 415C · Truth/Consequen, NMThe pilot's failure to maintain proper airspeed and obtain a proper climb rate after takeoff.NTSB SEA90LA017Accident · No injuriesLimited investigationFinal reportErcoupe 415D · Vancouver, WAThe pilot's inadvertant leaning of the fuel mixture to near idle cutoff, causing the engine to quit.NTSB ATL89LA146Accident · 1 fatalLimited investigationFinal reportErcoupe 415-C · Troy, NCAn undetermined powerplant problem, which resulted in a loss of engine power, and the pilot/mechanic's failure to assure the aircraft was properly inspected before flight. Factors related to the accident were: the pilot's delay in making a precautionary…NTSB MKC88LA113Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Florence, MOWhile on a personal flight, PIC said he began to lose engine power. He elected to make a precautionary ldg in a farm field, and during the roll out, the nose wheel struck a ditch. Post flt examination failed to reveal any cause for the partial power loss.NTSB ATL88LA183Accident · Minor injuriesLimited investigationFinal reportErcoupe 415-C · Whiteville, NCThe student plt reported that the engine began to skip and lose pwr about 20 minutes after departure. The engine subsequently lost all pwr and the student made a forced ldg in a plowed field. The airplane nosed over during the ldg. Post-crash exam of the…NTSB ATL88LA093Accident · No injuriesLimited investigationFinal reportErcoupe 415C · Spartanburg, SCWhen the pilot was unable to find assistance to remove the nose wheel chock from the aircraft, he applied enough power to jump the chock. He was unable to retard the throttle before colliding with a parked aircraft and striking a concrete wall.NTSB ATL88LA058Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Marlboro, OHThe student plt rptd that he flew a flat final apch to remain clear of trees. The airspeed began to drop, and the airplane subsequently landed hard after clearing the trees.NTSB NYC87LA224Accident · Serious injuriesLimited investigationFinal reportErcoupe 415-C · York, PAThe Ercoupe model 415 experienced a loss of power in flight. The pilot made a forced landing in a field. He went under some power lines, however, he could not avoid the telephone lines and went through them. The pilot received serious injuries and the…NTSB LAX87LA283Accident · Serious injuriesLimited investigationFinal reportErcoupe 415-C · Galt, CADuring the takeoff ground roll on a 2000 ft private runway, at the point to rotate, the plt applied back pressure, however, the aircraft did not respond. Aprx three quarters of the way down the rwy the plt realized that the acft was not lifting off and he…