NTSB investigations: Bellanca 7ECA, 1996
3 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\") = 1996
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") = 1996
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 SEA96LA215Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Arlington, WAinadequate visual lookout by the pilot of the Piper J3, and failure of the flight instructor in the Bellance to ensure that clearance was maintained from the other moving aircraft. Factors relating to the accident were: the inherent visual restrictions…NTSB NYC96LA166Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Bedford, MAThe pilot's inadequate compensation for wind conditions, and his failure to maintain directional control, which resulted in a ground loop/swerve. The variable wind condition was a related factor.NTSB CHI96LA242Accident · Serious injuriesLimited investigationFinal reportBellanca 7ECA · Belle Plaine, MNthe pilot's misjudgment of the distance and speed during the landing, and his delay in initiating a go-around. Factors relating to the accident were: the tall grass and ravine at the end of the runway.