NTSB investigations: Aeronca 7AC, AZ
14 cases on aircraft the registry lists as Aeronca 7AC. 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 |
|---|---|
| 1966 | 1 |
| 1967 | 1 |
| 1969 | 1 |
| 1970 | 1 |
| 1972 | 2 |
| 1973 | 1 |
| 1974 | 1 |
| 1976 | 1 |
| 1979 | 1 |
| 1984 | 1 |
| 1985 | 1 |
| 1990 | 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\" = 'AZ' 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 ('2110102'))
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" = 'AZ' 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 ('2110102'))
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 LAX90LA134Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · Cottonwood, AZThe failure to the pilot to maintain control of the aircraft. Contributing to the accident was the decision of the pilot to attempt a landing in a cross wind condition well beyond the capability of the aircraft.NTSB LAX85LA099Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · Chandler, AZThe PIC reported the 2nd plt was flying the acft at the time of the accident while they were practicing off arpt landings. On the second takeoff, the 2nd plt executed a course reversal turn to land opposite the direction of takeoff. The initial turn was to…NTSB LAX84FA258Accident · 2 fatalField investigationFinal reportBellanca 7AC · Skull Valley, AZThe acft had been flown on several local flts, earlier that day. The last known flt originated at the ernest j love arpt, prescott, AZ, at 1600 MST. Subsequently, it crashed near the departure end of rwy 02 at the quarter circle 'j' arpt, which was in the…NTSB LAX79DUJ67Accident · No injuriesClosedAeronca 7AC · Tucson, AZNTSB LAX76AL088Accident · 1 fatalClosedChampion 7BCM · Wickenburg, AZNTSB LAX74DUJ58Accident · No injuriesClosedAeronca 7AC · Tucson, AZNTSB LAX73AL040Accident · 1 fatalClosedAeronca 7AC · Apache Jctn, AZNTSB LAX72FUJ81Accident · Serious injuriesClosedAeronca 7AC · Tucson, AZNTSB DEN72AD036Accident · 1 fatalClosedAeronca 7AC · Pima, AZNTSB LAX71DUJ05Accident · Minor injuriesClosedAeronca 7AC · Coolidge, AZNTSB LAX70D0045Accident · Minor injuriesClosedAeronca 7AC · Yuma, AZNTSB LAX68D0209Accident · No injuriesClosedAeronca 7AC · Cave Creek, AZNTSB DEN66F0286Accident · Minor injuriesClosedAeronca 7AC · Ajo, AZNTSB DEN66A0011Accident · 2 fatalClosedAeronca 7AC · Chandler, AZ