NTSB investigations: Aeronca 7BCM/CONV
7 cases on aircraft the registry lists as Aeronca 7BCM/CONV. 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
| 1965 | 1 |
|---|---|
| 1973 | 1 |
| 1986 | 1 |
| 1999 | 1 |
| 2007 | 1 |
| 2011 | 1 |
| 2016 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2110145'))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2110145'))
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 ERA16CA264Accident · Serious injuriesData collectionFinal reportAeronca 7BCM · Connellsville, PAThe pilot's failure to properly set the throttle and secure the airplane before hand-propping the engine for startup.NTSB CEN11CA157Accident · No injuriesData collectionFinal reportAeronca 7AC · Corsicana, TXThe student pilot’s failure to maintain directional control during landing.NTSB DFW08CA022Accident · No injuriesData collectionFinal reportAeronca 7AC · Fort Worth, TXThe pilot's failure to maintain direction control. A contributing factor was the tailwind.NTSB FTW99LA270Accident · No injuriesLimited investigationFinal reportAeronca 7-AC · Fort Worth, TXThe failure of the pilot to maintain directional control of the airplane during the landing roll.NTSB MKC86LA172Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Republic, MOThe pilot was flying a pattern around a field where he intended to land later. During a low pass, he applied power for a go- around but full power was not sufficient to prevent a touchdown. At touchdown, a side load collapsed the landing gear. The pilot is…NTSB MKC73DCQ35Accident · No injuriesClosedAeronca 7AC · Hunter, KSNTSB MKC65A0049Accident · 2 fatalClosedAeronca 7BCM · Stuart, NE