Skip to content

NTSB investigations: Bellanca 7ECA, AK

21 cases on aircraft the registry lists as Bellanca 7ECA. 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

19732026

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" = 'AK' 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 ('1220460')) 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\" = 'AK' 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 ('1220460'))
  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" = 'AK' 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 ('1220460'))
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 GAA18CA357Accident · No injuriesData collectionFinal reportBellanca 7ECA · Fairbanks, AKThe airplane’s collision with a bird while maneuvering.Jun 6, 2018 · N8646V · Substantial damage NTSB ANC13LA008Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Kenai, AKThe loss of engine power due to carburetor icing and the pilot's failure to apply carburetor heat when he reduced engine power.Nov 4, 2012 · N31281 · Substantial damage NTSB ANC97LA123Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Kaktovik, AKThe pilot's selection of an unsuitable takeoff area. A factor related to the accident was the rocky terrain.Aug 14, 1997 · N5507H · Substantial damage 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.Aug 22, 1995 · N57393 · Destroyed NTSB ANC94LA133Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Fairbanks, AKUndetermined.Sep 10, 1994 · N68522 · Substantial damage NTSB ANC92LA124Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Talarik Creek, AKThe pilot selected unsuitable terrain on which operate.Aug 6, 1992 · N31297 · Substantial damage NTSB ANC90LA165Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Blair Lakes, AKThe pilot's failure to maintain adequate lookout during the post-landing taxi. Contributing to the accident were the rough terrain, the pilot's lack of total experience, and his lack of familiarity with the geographic area.Sep 4, 1990 · N5504N · Substantial damage NTSB ANC90LA160Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Cordova, AKFuel exhaustion due to the pilot-in-command's improper preflight preparation and planning.Sep 2, 1990 · N7651S · Substantial damage NTSB ANC90LA023Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Tanana, AKFailure of the right main gear axle bolt.Dec 29, 1989 · N7615S · Substantial damage NTSB ANC87LA151Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Salcha, AKThe private pilot was unable to maintain directional control of the acft when he encountered a quartering crosswind gust on final approach. The left wing collided with brush and small trees along side of the unattended airstrip. The pilot rptd the wind…Sep 5, 1987 · N4183Y · Substantial damage NTSB ANC86FA080Accident · Serious injuriesField investigationFinal reportChampion 7ECA · Settlers Bay, AKThe instructor (CFI) gave the front seat plt a simulated forced lndg while the airplane was aligned with rwy 20 & the wind. The front seat plt elected to fly a traffic pattern to rwy 2. As the front seat plt maneuvered to line up with rwy 2, much alt was lost…Jun 16, 1986 · N11864 · Substantial damage NTSB ANC86LA043Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Fairbanks, AKThe pilot stated that during the takeoff on a public road the aircraft struck the road side with the right wing.Apr 6, 1986 · N1042E · Substantial damage 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…Jul 14, 1983 · N2757Z · Substantial damage NTSB ANC81FAA10Accident · No injuriesClosedBellanca 7ECA · North Pole, AKMar 26, 1981 · N53950 · Substantial damage NTSB ANC80DAG41Accident · No injuriesClosedBellanca 7ECA · Soldotna, AKApr 6, 1980 · N53804 · Substantial damage NTSB ANC78FAA20Accident · Minor injuriesClosedBellanca 7ECA · Fairbanks, AKJun 14, 1978 · N1042E · Substantial damage NTSB ANC78DAG62Accident · No injuriesClosedBellanca 7ECA · Palmer, AKJun 6, 1978 · N8554V · Substantial damage NTSB ANC77DAG98Accident · Minor injuriesClosedBellanca 7ECA · Palmer, AKAug 12, 1977 · N8853 · Substantial damage NTSB ANC75DAA08Accident · No injuriesClosedChampion 7ECA · Healy, AKAug 5, 1975 · N86592 · Substantial damage NTSB ANC74DAG40Accident · No injuriesClosedBellanca 7ECA · Ptarmigan Ps, AKSep 6, 1973 · N11864 · Substantial damage NTSB ANC74FAG07Accident · Serious injuriesClosedBellanca 7ECA · Anchorage, AKJul 21, 1973 · N90929 · Destroyed