NTSB investigations: Bellanca 7ECA, 1985
5 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.
Cases per year
| 1972 | 2 |
|---|---|
| 1973 | 6 |
| 1974 | 5 |
| 1975 | 9 |
| 1976 | 6 |
| 1977 | 9 |
| 1978 | 15 |
| 1979 | 8 |
| 1980 | 14 |
| 1981 | 9 |
| 1982 | 10 |
| 1983 | 4 |
| 1984 | 8 |
| 1985 | 5 |
| 1986 | 6 |
| 1987 | 4 |
| 1988 | 8 |
| 1989 | 2 |
| 1990 | 2 |
| 1991 | 6 |
| 1992 | 6 |
| 1993 | 3 |
| 1994 | 3 |
| 1995 | 7 |
| 1996 | 3 |
| 1997 | 4 |
| 1999 | 1 |
| 2000 | 3 |
| 2001 | 5 |
| 2002 | 1 |
| 2003 | 2 |
| 2004 | 6 |
| 2005 | 4 |
| 2006 | 3 |
| 2007 | 2 |
| 2010 | 1 |
| 2012 | 2 |
| 2013 | 5 |
| 2016 | 4 |
| 2018 | 3 |
| 2019 | 1 |
| 2020 | 1 |
| 2021 | 1 |
| 2022 | 1 |
| 2023 | 3 |
| 2024 | 1 |
| 2026 | 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 year(c.\"eventDate\") = 1985
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 year(c."eventDate") = 1985
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" 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 LAX86LA018Accident · Minor injuriesLimited investigationFinal reportChampion 7ECA · Turlock, CAThe acft made a forced lndg after a loss of power during a descent. The plt stated that the eng RPM decreased to 1100 with all other gauges in the green. He also said he could not get the fuel drain sumpt to drain as it was frozen shut during preflt. The plt…NTSB MKC85LA224Accident · Minor injuriesLimited investigationFinal reportBellanca Citabria 7ECA · Council Bluffs, IAOn climbout fm the Council Bluffs airport the plt reported a loss of engine power and the engine quitting. The plt attempted an air restart but was too low to the grnd to continue. The plt weaved in and out of trees during his descent finally impacting the…NTSB FTW85LA264Accident · Serious injuriesLimited investigationFinal reportBellanca 7ECA · Ville Platte, LAThe plt had rented the acft for a local flt and was observed by ground witnesses to have flown very low (50 ft AGL) over miller lake when the left wing struck a tree. The acft continued for aprx 50 ft in a left wing low attitude before striking another tree,…NTSB SEA85LA114Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Rio Vista, CAThe instructor plt (CFI) reported that during a bounced landing recovery, the student plt held the acft in a 3-point attitude above the rwy. As airspeed decayed, the (CFI) took control & added full power. However, the right wing dropped & grazed rising…NTSB BFO85LA020Accident · No injuriesLimited investigationFinal reportBellanca 7-ECA Citabria · Annapolis, MDDuring final apch to rwy 30, a go-around was executed due to a shift in wind direction, according to the plt. He subsequently entered the pattern for rwy 12, made a full stop lndg with no difficulties, and took off again for a planned touch and go on the next…