NTSB investigations: Bellanca 7ECA, 1983
4 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\") = 1983
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") = 1983
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 LAX84LA120Accident · Minor injuriesLimited investigationFinal reportBellanca 7ECA · Murrieta, CAThe acft nosed over during landing rollout. The plt reported the acft speed on final was 80 mph which is faster than normal. The acft touched down about 900 ft down the 2682 ft rwy. The landing was on rwy 15 and the wind was from 045 degrees at 4 KTS. The plt…NTSB MKC84LA021Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · St. Joseph, MOThe acft nosed down during landing after the left main landing gear strut failed. The plt stated that on the 2nd touch- and-go landing, he felt a vibration and saw the left gear strut trailing at about a 45 degree angle. The plt chose to land on the grass…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 CHI83LA307Accident · No injuriesLimited investigationFinal reportBellanca Citabria 7ECA · Leslie, MIThe acft landed hard and bounced. The acft drifted left off the rwy and nosed over in a plowed area. The landing was on rwy 18 and the wind was from 270 degrees at 8 KTS. The student pilot said he needed more dual time in crosswind landings. He had 11 hours…