NTSB investigations: Champion 7FC, CA
17 cases on aircraft the registry lists as Champion 7FC. 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
| 1964 | 3 |
|---|---|
| 1965 | 2 |
| 1966 | 1 |
| 1967 | 2 |
| 1971 | 1 |
| 1972 | 2 |
| 1973 | 1 |
| 1974 | 1 |
| 1978 | 1 |
| 1984 | 1 |
| 1988 | 1 |
| 2022 | 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 ('21101NX'))
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 ('21101NX'))
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 WPR22LA369Accident · No injuriesClass 4 · LimitedFinal reportChampion 7FC · Maxwell, CAThe pilot’s failure to maintain directional control during landing, resulting in a runway excursion.NTSB LAX89LA033Accident · Serious injuriesLimited investigationFinal reportChampion 7FC · Hesperia, CAWitnesses rprtd that the winds at the arpt were out of the west at about 20 KTS with peak gusts of about 37 KTS. They stated the wind sock was indicating a direct x-wind with rwy 3/21 & that the plt initiated his takeoff on rwy 21. Witnesses rprtd that during…NTSB LAX84LA497Accident · No injuriesLimited investigationFinal reportChampion 7FC · Merced, CADuring takeoff the plt lost control of the acft. It veered off the rwy & collided with a dirt bank. The plt indicated that his wife may have unknowingly been applying pressure to the heel brakes during the attempted takeoff.NTSB LAX78DUQ24Accident · No injuriesClosedChampion 7FC · Mojave, CANTSB OAK75AP007Accident · 2 fatalClosedChampion 7FC · Newman, CANTSB LAX73DUQ40Accident · No injuriesClosedChampion 7FC · Mojave, CANTSB OAK73DVA16Accident · Minor injuriesClosedChampion 7FC · Hanford, CANTSB LAX72FUG47Accident · Minor injuriesClosedChampion 7FC · Corona, CANTSB LAX71DVW26Accident · No injuriesClosedChampion 7FC · Tecopa, CANTSB LAX68F0160Accident · No injuriesClosedChampion 7FC · Lancaster, CANTSB OAK67D0335Accident · No injuriesClosedChampion 7FC · San Carlos, CANTSB OAK67F0021Accident · No injuriesClosedChampion 7FC · Concord, CANTSB LAX66D0209Accident · Minor injuriesClosedChampion 7FC · San Diego, CANTSB LAX66D0021Accident · No injuriesClosedChampion 7FC · Bakersfield, CANTSB UNK64X3873Accident · No injuriesClosedChampion 7FC · Santa Barbara, CANTSB UNK64X1560Accident · No injuriesClosedAeronca 7FC · Santa Barbara, CANTSB UNK64X0719Accident · 2 fatalClosedChampion 7FC · Yucca Valley, CA