NTSB investigations: Champion 7EC, CA
16 cases on aircraft the registry lists as Champion 7EC. 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 | 2 |
|---|---|
| 1965 | 1 |
| 1966 | 2 |
| 1968 | 1 |
| 1970 | 1 |
| 1972 | 1 |
| 1974 | 1 |
| 1975 | 2 |
| 1979 | 1 |
| 1993 | 1 |
| 2006 | 1 |
| 2013 | 1 |
| 2015 | 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 ('21101NM'))
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 ('21101NM'))
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 GAA15CA006Accident · No injuriesData collectionFinal reportChampion 7EC · Upland, CAThe pilot's failure to maintain directional control during landing.NTSB WPR13CA357Accident · No injuriesData collectionFinal reportChampion 7EC · Sonoma, CAThe pilot's failure to maintain directional control during the landing roll.NTSB LAX06LA293Accident · 2 fatalLimited investigationFinal reportChampion 7EC · Clipper Mills, CAThe pilot failed to maintain clearance from mountainous terrain. A contributing factor was the pilot's impairment from ingestion of marijuana.NTSB LAX93LA142Accident · No injuriesLimited investigationFinal reportChampion 7EC · Riverside, CAThe cfi's inadequate supervision of the flight, the dual student's failure to maintain directional control and improper use of the normal brakes. Contributing to this accident was the dual student's improper use of the rudder.NTSB LAX79FUG11Accident · No injuriesClosedChampion 7EC · Upland, CANTSB OAK7LDVD06Accident · Minor injuriesClosedChampion 7EC · Petaluma, CANTSB LAX75FUG47Accident · Minor injuriesClosedAeronca 7EC · Corona, CANTSB OAK75FVG20Accident · Serious injuriesClosedChampion 7EC · Vina, CANTSB OAK73FVD17Accident · No injuriesClosedChampion 7EC · Fremont, CANTSB OAK71AP008Accident · 2 fatalClosedChampion 7EC · Vacaville, CANTSB OAK69D0051Accident · No injuriesClosedAeronca 7EC · Fremont, CANTSB OAK67D0030Accident · No injuriesClosedAeronca 7EC · San Francisco, CANTSB OAK66D0214Accident · No injuriesClosedChampion 7EC · Oakland, CANTSB OAK66F0063Accident · Minor injuriesClosedChampion 7EC · Madera, CANTSB UNK65X0540Accident · No injuriesClosedChampion 7EC · Bridgeport, CANTSB UNK64X3798Accident · No injuriesClosedChampion 7EC · Antioch, CA