NTSB investigations: Champion 7HC
15 cases on aircraft the registry lists as Champion 7HC. 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 | 3 |
| 1970 | 1 |
| 1973 | 1 |
| 1977 | 3 |
| 1983 | 1 |
| 1986 | 1 |
| 1987 | 1 |
| 2009 | 1 |
| 2011 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('21101PN'))
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 ('21101PN'))
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 ANC15CA064Accident · No injuriesData collectionFinal reportChampion 7HC · Coldfoot, AKThe loss of engine power due to carburetor icing and the pilot's failure to recognize conditions favorable for carburetor icing and apply use of carburetor heat.NTSB ANC11CA049Accident · No injuriesData collectionFinal reportChampion 7HC · Kenai, AKThe pilot's selection of unsuitable terrain for landing, resulting in the collapse of the main landing gear, and a nose over.NTSB ERA09LA230Accident · 1 fatalLimited investigationFinal reportChampion 7HC · Centre, ALThe pilot's inability to maintain aircraft control during climb due to an improperly installed rudder pedal control tube.NTSB ANC87LA123Accident · Minor injuriesLimited investigationFinal reportChampion 7HC · Seward, AKThe pilot lost directional control on landing and veered to the right side of the runway. The aircraft then struck a small mound and nosed over on its back. The pilot stated that he landed with a 7 to 10 knot tailwind.NTSB NYC86FNC08Accident · 2 fatalFinal reportChampion 7HC · Epsom, NHA student pilot and passenger on a local flight collided with a tree, crashed and burned. No malfunction was found with the aircraft and engine. The plts flt time was not reported or available.NTSB MIA84LA021Accident · No injuriesLimited investigationFinal reportChampion 7HC · Ft. Lauderdale, FLThe plt of Champion 7HC, N8918R, stated that he taxied over a rough field to rwy 13. While crossing the field, something struck the bottom of the fusellage & broke the ailron bellcrank which connected the control stick to the aileron pushrods. Subsequently,…NTSB SEA78DYA02Accident · No injuriesClosedChampion 7GC · Mudlake, IDNTSB MIA77FK648Accident · No injuriesClosedChampion 7HC · Savannah, GANTSB MIA77FKG20Accident · No injuriesClosedChampion 7HC · Vidalia, GANTSB IAD74FKM31Accident · No injuriesClosedChampion 7HC · Thomasville, NCNTSB MIA70DLG16Accident · Minor injuriesClosedChampion 7HC · Taxahaw, SCNTSB OAK66F0282Accident · No injuriesClosedChampion 7HC · Sacramento, CANTSB MKC66F0516Accident · No injuriesClosedChampion 7HC · Stanley, KSNTSB ANC66D0103Accident · No injuriesClosedChampion 7HC · Delta Junctn, AKNTSB CHI65F0041Accident · No injuriesClosedAeronca 7HC · Watertown, WI