NTSB investigations: Bellanca 7GCAA, CO
4 cases on aircraft the registry lists as Bellanca 7GCAA. 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
| 1983 | 1 |
|---|---|
| 1984 | 1 |
| 1988 | 1 |
| 2024 | 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.\"eventStateOrRegion\" = 'CO' 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 ('1220501'))
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" = 'CO' 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 ('1220501'))
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 CEN24LA344Accident · Serious injuriesClass 3 · LimitedFinal reportBellanca 7GCAA · Rifle, COA total loss of engine power for undetermined reasons.NTSB DEN88LA085Accident · No injuriesLimited investigationFinal reportBellanca 7GCAA · Greeley, COThe CFI rated plt and his CFI rated passenger were practicing touch and go landings. The plt reported that the winds were light and variable. The plt reported that the tail wheel chattered during the last touchdown, and the aircraft swerved to the left. The…NTSB DEN84LA114Accident · No injuriesLimited investigationFinal reportBellanca 7GCAA · Monte Vista, COThe acft landed on a snow covered private airstrip and nosed over. The plt said that the 4 inch deep snow caused the acft to go over on its top.NTSB DEN83LA176Accident · No injuriesLimited investigationFinal reportBellanca 7GCAA · Elbert, COThe acft engine quit while the plt was performing aerobatics, an airstart was unsuccessful and a forced landing was madein an open field surrounded by trees. During the landing one wing hit a tree causing the acft to veer into a creek. The plt said he had…