NTSB investigations: Champion 7GCAA, 1986
4 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 | 7 |
|---|---|
| 1967 | 12 |
| 1968 | 11 |
| 1969 | 7 |
| 1970 | 7 |
| 1971 | 8 |
| 1972 | 6 |
| 1973 | 6 |
| 1974 | 7 |
| 1975 | 4 |
| 1976 | 2 |
| 1977 | 8 |
| 1978 | 1 |
| 1979 | 2 |
| 1980 | 2 |
| 1981 | 5 |
| 1982 | 3 |
| 1983 | 1 |
| 1984 | 1 |
| 1985 | 8 |
| 1986 | 4 |
| 1987 | 1 |
| 1988 | 2 |
| 1989 | 1 |
| 1990 | 2 |
| 1991 | 1 |
| 1992 | 3 |
| 1993 | 2 |
| 1994 | 2 |
| 1998 | 1 |
| 1999 | 1 |
| 2000 | 3 |
| 2001 | 1 |
| 2004 | 2 |
| 2007 | 2 |
| 2009 | 2 |
| 2013 | 2 |
| 2014 | 2 |
| 2015 | 1 |
| 2018 | 1 |
| 2020 | 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 year(c.\"eventDate\") = 1986
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 year(c."eventDate") = 1986
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 NYC86LA179Accident · No injuriesLimited investigationFinal reportChampion 7GCAA · Newburyport, MAPilot made a precautionary landing after experiencing a rudder control failure after a banner pick up. The left aft rudder cable had parted 49.5 inches aft of the rudder pedal attachment point.NTSB NYC86LA167Accident · No injuriesLimited investigationFinal reportChampion 7GCAA · Lakewood, NJAfter returning to the airport, the pilot lost directional control during the landing and the aircraft veered off the runway. Subsequently, the aircraft struck a runway light and the left main wheel & left wing were damaged.NTSB ATL86LA117Accident · No injuriesLimited investigationFinal reportBellanca 7-GCAA · Chester, SCAircraft was being repositioned on airport for glider tow. Tow rope was attached and pilot concentrated his attention on avoiding entangling tow rope on runway lights. When pilot noticed the aircraft was too low he attempted a go-around with insufficient…NTSB DEN86LA104Accident · No injuriesLimited investigationFinal reportChampion 7GCAA · Falcon, COAccording to the plt, when the acft slowed after landing, it turned 'sharply to the right.' The plt stated he experienced 'extreme tailwheel shudder' prior to this during the landing roll. During the investigation, it was ascertained that the tailwheel spring…