NTSB investigations: Bellanca 7ECA
17 cases on aircraft the registry lists as Bellanca 7ECA, where the first occurrence was “Loss of control - in flight”. 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
| 1982 | 2 |
|---|---|
| 1983 | 1 |
| 1984 | 4 |
| 1987 | 1 |
| 1988 | 1 |
| 1991 | 2 |
| 1992 | 2 |
| 1995 | 1 |
| 2005 | 2 |
| 2006 | 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 ('1220460')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 250))
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 ('1220460')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 250))
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 CHI06LA073Accident · 2 fatalLimited investigationFinal reportBellanca 7ECA · Pontiac, MIThe excessive bank angle executed by the flight crew and their failure to maintain airspeed during the turn, which led to the inadvertent stall and subsequent impact with the ground. A factor was the low altitude.NTSB LAX05CA282Accident · No injuriesData collectionFinal reportBellanca 7ECA · San Jose, CAthe pilot's failure to maintain directional control of the airplane during the landing flare, which resulted in a collision with an runway sign.NTSB MIA05FA152Accident · 2 fatalField investigationFinal reportBellanca 7ECA · Freeport, FLThe failure of the pilot to maintain airspeed resulting in inadvertent stall, uncontrolled descent, and in-flight collision with terrain.NTSB ANC95FA147Accident · 2 fatalField investigationFinal reportChampion 7ECA · Palmer, AKfailure of the pilot to maintain adequate airspeed, while maneuvering at low altitude, which resulted in an inadvertent stall/spin and collision with the terrain.NTSB ATL93FA030Accident · 2 fatalField investigationFinal reportBellanca 7ECA · Pike Road, ALThe failure of the pilot in command to maintain airspeed during the initial climb, which resulted in an inadvertent stall and collision with the ground. Factors were the inadequate preflight planning and preparation of the pilot in command in that he operated…NTSB NYC92LA140Accident · Minor injuriesLimited investigationFinal reportBellanca 7ECA · East Liverpool, OHA collision with trees after the pilot failed to maintain directional control during an aborted landing.NTSB DEN92LA010Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Watkins, COFailure to maintain directional control of the airplane during landing flare. A factor was the crosswind condition that existed at the time of the accident.NTSB LAX92LA046Accident · 2 fatalLimited investigationFinal reportBellanca 7ECA · Fremont, CAThe pilot-in-command's failure to maintain an airspeed above the stall speed. His over confidence in his personal ability, lack of familiarity with the aircraft, and his inadequate training in acrobatic flight were factors in the accident.NTSB CHI88FA188Accident · 1 fatalField investigationFinal reportBellanca 7ECA · Flushing, MIPilot's physical incapacitation due to a coronary seizure, which resulted in a loss of aircraft control, and a stall/spin into the ground.NTSB LAX87FA341Accident · 1 fatalField investigationFinal reportBellanca 7ECA · Sonoma, CAThe 70-hour student plt had recently passed the pvt plt written exam & had completed most of the flt trng for certification. He was looking forward to becoming a licensed plt. While on a personal flt, the plt flew over his brother's residence & was observed…NTSB LAX85FA015Accident · 1 fatalField investigationFinal reportBellanca 73CA · Porterville, CAThe acft crashed after an inflt loss of control during both the landing flare & subsequent go around attempt. The plt stated that he was approaching touchdown in a three point attitude when 'a gust of wind suddenly pushed (the acft) to the right of the…NTSB NYC84LA198Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Ellington, CTAcft was on short final with 100 degree left x-wind 0F 10 KTS gusting to 15 KTS. When a gust occurred the left wing dragged the rwy and the acft cartwheeled.NTSB LAX84LA316Accident · Minor injuriesLimited investigationFinal reportBellanca 7ECA · King City, CAThe acft right wing dragged the ground shortly after takeoff; the acft cartwheeled and came to rest against a tractor. The plt reported that he began a turn at 500 ft AGL and the acft entered an accelerated stall. A passenger reported thatthe acft became…NTSB FTW84FA114Accident · 2 fatalField investigationFinal reportBellanca 7ECA · Throckmorton, TXThe acft crashed in a steep left wing down, nose down attitude. The flt had been for the purpose of checking out the front seat plt on pipe line patrol. The front seat plt had only 22 hrs in this make & model. The weather was VMC and no mechanical…NTSB ANC83LA123Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Sterling, AKThe acft was taking off to the south and collided with trees alongside the runway. The pilot stated that as the acft lifted off he passed a clearing on the right and a crosswind drifted the acft left across the runway into trees. The left wing clipped a tree…NTSB LAX82DA318Accident · Minor injuriesFinal reportBellanca 7ECA · Hayward, CAWhile landing on runway 28R, the plane veered off the left side of the runway and was damaged.NTSB CHI82DA215Accident · Serious injuriesFinal reportBellanca 73CA · Fairfield, ILThe pilot stated that after takeoff he flew 3 or 4 miles, started a right turn and could not recall any further events concerning the flight. Investigation revealed the aircraft crashed on flat terrain. Examination of the flight controls did not reveal any…