NTSB investigations: Champion 7AC, CA
9 cases on aircraft the registry lists as Champion 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
| 1964 | 1 |
|---|---|
| 1966 | 2 |
| 1968 | 1 |
| 1972 | 1 |
| 1973 | 1 |
| 1982 | 1 |
| 1987 | 1 |
| 2004 | 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\" = 'CA' 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 ('21101MA'))
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" = 'CA' 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 ('21101MA'))
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 LAX04LA239Accident · 1 fatalLimited investigationFinal reportChampion 7AC · La Porte, CAthe student pilot's failure to maintain clearance with trees while flying along a mountainous ravine.NTSB LAX87LA333Accident · Minor injuriesLimited investigationFinal reportAeronca Champ 7AC · Victorville, CAWhile climbing out over a ridge, the instructor, who was sitting in back, heard his student yell something. The instructor looked out the front windscreen just in time to see powerlines. Simultaneously, the student pushed the stick forward to go under the…NTSB LAX82DA065Accident · No injuriesFinal reportCessna 180 · San Jose, CABellanca N71681 was awaiting clearance for takeoff when Cessna N3343D taxied into the turning propeller during a positioning maneuver.NTSB LAX73DUG59Accident · No injuriesClosedChampion 7CCM · Riverside, CANTSB LAX72FUQ64Accident · Minor injuriesClosedAeronca 7AC · Simi, CANTSB OAK68A0061Accident · 2 fatalClosedAeronca 7BCM · Hopland, CANTSB OAK66F0283Accident · Serious injuriesClosedAeronca 7AC · Nipomo Mesa, CANTSB LAX66D0352Accident · No injuriesClosedAeronca 7AC · Pacoima, CANTSB UNK64X2194Incident · No injuriesClosedAero Comm 560F · Los Angeles, CA