NTSB investigations: Champion 7KCAB
8 cases on aircraft the registry lists as Champion 7KCAB, where the first occurrence was “Loss of control - on ground/water”. 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
| 1982 | 1 |
|---|---|
| 1985 | 1 |
| 1986 | 1 |
| 1987 | 1 |
| 1990 | 1 |
| 1991 | 1 |
| 1997 | 1 |
| 2000 | 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 ('21101P3')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 260))
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 ('21101P3')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 260))
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 FTW00LA227Accident · No injuriesLimited investigationFinal reportChampion 7KCAB · Rayville, LAThe flight instructor's failure to maintain directional control. A factor was the wind gusts.NTSB CHI97LA247Accident · No injuriesLimited investigationFinal reportChampion 7KCAB · Hampshire, ILthe pilot's failure to maintain directional control of the airplane during landing, and his excessive use of brakes, which resulted in a nose over. Factors relating to the accident were: the crosswind condition, and the pilot's lack of experience in the make…NTSB ATL92LA001Accident · No injuriesLimited investigationFinal reportChampion 7KCAB · Cartersville, GAThe failure of the pilot to maintain control of the aircraft during the landing roll and the improper remedial action taken by the pilot to regain control of the airplane.NTSB MKC90LA104Accident · No injuriesLimited investigationFinal reportChampion 7KCAB · Scott, ARPilot in command's failure to maintain directional control during the landing roll. Related to the accident was tall grass and soft terrain.NTSB LAX87LA127Accident · Minor injuriesLimited investigationFinal reportChampion 7KCAB · Roosevelt, AZAt the end of a pleasure cross-country flight, the pilot reported that during the landing roll, the passenger was moving around in the back seat and accidentally pressed on the right brake. Before the pilot could get the aircraft under control, the aircraft…NTSB MKC86LA116Accident · No injuriesLimited investigationFinal reportChampion 7KCAB · Crete, NEThe plt of this tail-wheel acft attempted a landing on a rwy with a strong x-wind. After a go-around, he started an apch to a turf rwy that was better aligned with the wind but made a go-around when he thought the grass was too high. He then attempted another…NTSB FTW85LA292Accident · No injuriesLimited investigationFinal reportChampion 7KCAB · Chattanooga, OKThe plt lost directional control while landing in a crosswind and the acft ground looped after the left main landing gear contacted soft terrain alongside of the runway. The nearest official aviation weather reporting station was at lawton, OK, located 16…NTSB SEA82DA026Accident · No injuriesFinal reportBellanca 7KCAB · Burns, ORDuring landing in calm wind conditions, the aircraft bounced slightly. On the second touchdown, it veered left and struck a snowbank. The student pilot reported that it seemed like the left brake froze. The left brake was examined for possible dragging and…