NTSB investigations: Champion 7GCAA, CA
19 cases on aircraft the registry lists as Champion 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
| 1966 | 2 |
|---|---|
| 1967 | 2 |
| 1968 | 4 |
| 1970 | 2 |
| 1971 | 2 |
| 1973 | 1 |
| 1974 | 1 |
| 1975 | 1 |
| 1984 | 1 |
| 2000 | 1 |
| 2004 | 1 |
| 2013 | 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 ('21101N8'))
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 ('21101N8'))
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 WPR13FA370Accident · 2 fatalField investigationFinal reportChampion 7GCAA · Paradise, CAThe pilot's failure to maintain airplane control during low-altitude maneuvering after encountering an updraft.NTSB LAX05CA024Accident · No injuriesData collectionFinal reportChampion 7GCAA · Petaluma, CAthe pilot's failure to follow the published prestart, start, and shutdown procedures.NTSB LAX00LA295Accident · No injuriesLimited investigationFinal reportChampion 7GCAA · Newell, CAA hidden depression in the ground that resulted in the collapse of the landing gear during the forced landing roll.NTSB LAX84LA249Accident · No injuriesLimited investigationFinal reportChampion 7GCAA · Fort Bidwell, CAAccording to the plt the wx blocked several of the mountain passes along the route of flight. When the wx continued to deteriorate the plt landed in a field. The main gear 'dug-in and the acft flipped on it's back.'NTSB OAK75FVG49Accident · Minor injuriesClosedChampion 7GCAA · Fairfield, CANTSB OAK75DVM07Accident · No injuriesClosedChampion 7DC · Salinas, CANTSB OAK73DVA45Accident · No injuriesClosedChampion 7GCAA · Chowchilla, CANTSB OAK72DVG02Accident · No injuriesClosedChampion 7GCAA · Potter Vlly, CANTSB OAK71DVD36Accident · No injuriesClosedChampion 7GC-AA · Santa Rosa, CANTSB LAX71DUQ40Accident · Minor injuriesClosedChampion 7GCAA · Lebec, CANTSB OAK70DVM18Accident · No injuriesClosedChampion 7ECA · Palo Alto, CANTSB OAK69D0183Accident · No injuriesClosedChampion 7KCAB · Fremont, CANTSB LAX69A0008Accident · 2 fatalClosedChampion 7GCAA · Compton, CANTSB OAK69F0043Accident · Minor injuriesClosedChampion 7GCAA · Pleasanton, CANTSB LAX68F0288Accident · Minor injuriesClosedChampion 7GCAA · Santa Paula, CANTSB LAX68A0060Accident · 2 fatalClosedChampion 7GCAA · Lucerne Vly, CANTSB LAX68A0002Accident · 2 fatalClosedChampion 7GCAA · Amboy, CANTSB OAK67D0222Accident · No injuriesClosedChampion 7GCAA · Petaluma, CANTSB OAK67D0016Accident · No injuriesClosedChampion 7GCA · Dixon, CA