Skip to content

NTSB investigations: Champion 7KCAB, CA

36 cases on aircraft the registry lists as Champion 7KCAB. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19672026

Where

Latest cases

Query with SQL

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 ('21101P3')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 ('21101P3'))
  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 ('21101P3'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 WPR18FA237Accident · 2 fatalClass 3 · FieldFinal reportChampion 7KCAB · Descanso, CAThe pilot's decision to enter a spin without sufficient altitude to recover. Also causal to the accident was the pilot's inadequate preflight weight and balance calculations, which placed the airplane outside the normal and acrobatic category flight envelope,…Aug 22, 2018 · N1682G · Substantial damage NTSB WPR11LA063Accident · No injuriesLimited investigationFinal reportChampion 7KCAB · Rialto, CAFatigue cracking of the left main landing gear leg, which resulted in a gear collapse during landing.Nov 27, 2010 · N5101X · Substantial damage NTSB LAX92LA070Accident · 2 fatalLimited investigationFinal reportBellanca 7KCAB · Happy Camp, CAThe excessive nature of the maneuvers attempted by the pilot at a low altitude during the takeoff initial climb, the failure of the pilot to maintain proper pitch attitude and airspeed to avoid an aerodynamic stall, and inadequate altitude to perfrom…Dec 25, 1991 · N1679G · Destroyed NTSB LAX90FA094Accident · 2 fatalField investigationFinal reportChampion 7KCAB · Ojai, CAThe pilot's performing aerobatic maneuvers at a low altitude and failure to maintain altitude.Feb 19, 1990 · N5156T · Destroyed NTSB LAX89LA322Accident · Minor injuriesLimited investigationFinal reportBellanca Citabria · Auburn, CAThe pilot's inadvertent activation of nose down trim which resulted in a loss of control and collision with a tree. Contributing factor(s) was: the pilot's lack of experience in this type of airplane.Sep 25, 1989 · N1679G · Substantial damage NTSB LAX86FA320Accident · No injuriesField investigationFinal reportBellanca 7GCBC · Van Nuys, CATwo plts, 1 flying Bellanca 7GCBC, N50443, the other flying champion 7KCAB, N443E, took their girl friends on a flt which included formation flying. The champion plt rprtd he flew formation with the Bellanca with aprx a 20' spread. Rprtdly, about half way…Aug 9, 1986 · N50443 · 2 aircraft · Substantial damage NTSB LAX84LA157Accident · Minor injuriesLimited investigationFinal reportBellanca 7KCAB · Santa Ana, CAWhile taxiing after landing, a gust of wind overturned the acft. The winds were gusting to 40 KTS.Jan 26, 1984 · N7571F · Substantial damage NTSB LAX84LA020Accident · No injuriesLimited investigationFinal reportChampion 7KCAB · Santa Ynez, CAThe plt made his apch to land on rwy 26 with winds reportedly from 270 deg at 10 gusting 15 KTS. During the landing, the acft touched down short of the runway in an area containing deep furrows. Subsequently, the main gear collapsed & the fuselage & wings of…Sep 17, 1983 · N5156X · Substantial damage NTSB LAX81FUG34Accident · Minor injuriesClosedBellanca 7KCAB · Chino, CAMay 19, 1981 · N1877G · Substantial damage NTSB LAX81FA023Accident · 1 fatalClosedCitabria 7KCAB · Truckee, CADec 20, 1980 · N9144L · Destroyed NTSB LAX80FA075Accident · 1 fatalClosedChampion 7KCAB · Corona, CAApr 6, 1980 · N5100X · Destroyed NTSB LAX79FVM31Accident · No injuriesClosedBellanca 7KCAB · Palo Alto, CAAug 27, 1979 · N5152T · Substantial damage NTSB OAK78DVD56Accident · No injuriesClosedChampion 7KCAB · Stockton, CASep 4, 1978 · N5273X · Substantial damage NTSB LAX78FUM15Accident · No injuriesClosedChampion 7KCAB · El Cajon, CAMar 19, 1978 · N5163T · Substantial damage NTSB LAX78DUM09Accident · No injuriesClosedBellanca 7KCAB · Escondido, CADec 24, 1977 · N3045G · Substantial damage NTSB OAK77DVG51Accident · No injuriesClosedChampion 7KCAB · Sacramento, CAJul 15, 1977 · N5194X · Substantial damage NTSB OAK76DXQ54Accident · No injuriesClosedChampion 7KCAB · S-Lake Tahoe, CAJul 3, 1976 · N1676G · Substantial damage NTSB OAK76DVD33Accident · No injuriesClosedChampion 7KCAB · Concord, CAApr 13, 1976 · N7589F · Substantial damage NTSB OAK73AP027Accident · 1 fatalClosedChampion 7KCAB · Madera, CAMar 17, 1973 · N9027L · Destroyed NTSB OAK73DVA03Accident · No injuriesClosedChampion 7KCAB · Piedra, CAJul 8, 1972 · N1676G · Substantial damage NTSB OAK73AP001Accident · 2 fatalClosedChampion 7KCAB · San Ramon, CAJul 8, 1972 · N5136X · Destroyed NTSB LAX72DUQ88Accident · No injuriesClosedChampion 7KCAB · Pacoima, CAMay 21, 1972 · N5065X · Substantial damage NTSB LAX72FUQ77Accident · No injuriesClosedChampion 7KCAB · Van Nuys, CAApr 9, 1972 · N2552G · Substantial damage NTSB LAX72FUQ73Accident · No injuriesClosedChampion 7KCAB · Valencia, CAApr 1, 1972 · N9069L · Substantial damage NTSB LAX72DUQ60Accident · No injuriesClosedChampion 7KCAB · Santa Paula, CAFeb 1, 1972 · N1684G · Substantial damage NTSB LAX72FUQ04Accident · Serious injuriesClosedChampion 7KCAB · Lancaster, CAJul 15, 1971 · N5150T · Destroyed NTSB OAK71AP048Accident · 2 fatalClosedChampion 7KCAB · Antioch, CAMay 28, 1971 · N5136X · Destroyed NTSB OAK71DVD46Accident · Minor injuriesClosedChampion 7ECA · Antioch, CAMay 20, 1971 · N5223X · Destroyed NTSB LAX71FUM33Accident · Minor injuriesClosedChampion 7KCAB · Julian, CAMar 7, 1971 · N2552G · Substantial damage NTSB LAX71DUQ42Accident · No injuriesClosedChampion 7KCAB · Pacoima, CANov 14, 1970 · N5065X · Substantial damage NTSB LAX71FUQ16Accident · No injuriesClosedChampion 7KCAB · Van Nuys, CASep 7, 1970 · N5286X · Substantial damage NTSB OAK71DVG02Accident · Minor injuriesClosedChampion 7KCAB · Platina, CAJul 19, 1970 · N5231X · Substantial damage NTSB LAX70DUG55Accident · No injuriesClosedChampion 7KCAB · Adelanto, CAJun 14, 1970 · N7546F · Substantial damage NTSB OAK68A0068Accident · 1 fatalClosedChampion 7KCAB · Angels Camp, CAMay 17, 1968 · N1849G · Destroyed NTSB OAK68D0017Accident · No injuriesClosedChampion 7KCAB · Eureka, CAMay 30, 1967 · N5153T · Substantial damage NTSB LAX67A0085Accident · 1 fatalClosedChampion 7KC-AB · Rubidoux, CAMar 17, 1967 · N5149T · Destroyed