NTSB investigations: Champion 7ECA, FL
14 cases on aircraft the registry lists as Champion 7ECA. 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 |
|---|---|
| 1971 | 2 |
| 1972 | 2 |
| 1973 | 1 |
| 1976 | 2 |
| 1981 | 1 |
| 1988 | 1 |
| 1989 | 1 |
| 1991 | 1 |
| 1994 | 1 |
| 2019 | 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\" = 'FL' 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 ('21101NN'))
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" = 'FL' 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 ('21101NN'))
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 ERA20FA003Accident · Serious injuriesClass 3 · FieldFinal reportChampion 7ECA · Pembroke Pines, FLThe pilot’s failure to relinquish the airplane controls to the instructor during a power-off stall maneuver, which prevented the instructor’s recovering from the stall.NTSB MIA95FA027Accident · 2 fatalField investigationFinal reportChampion 7ECA · Arcadia, FLThe failure of the dual-student to maintain airspeed while maneuvering resulting in an inadvertent stall and uncontrolled descent. Contributing to the accident was improper supervision of the dual-student by the flight instructor.NTSB MIA91LA156Accident · Serious injuriesLimited investigationFinal reportChampion 7ECA · Quincy, FLThe pilot's inadequate preflight inspection and the blocked vent line.NTSB MIA89LA099Accident · Minor injuriesLimited investigationFinal reportChampion 7ECA · Ocala, FLFailure of the vehicle driver to see and yield to the acft that was landing on rwy 27. Contributing factors were: vehicle on the runway and inadequate visual lookout by the pilot.NTSB MIA88LA130Accident · No injuriesLimited investigationFinal reportChampion 7ECA · La Belle, FLDuring the ground run to take off, the unidentified pilot lost control of the acft. It departed the rwy, collided with a fence, nosed over, then came to rest. The identity of the plt has not been determined.NTSB MIA81FKT40Accident · Serious injuriesClosedChampion 7ECA · Marathon, FLNTSB MIA76FLD75Accident · Serious injuriesClosedChampion 7ECA · New Smyrna Bch, FLNTSB MIA76DKT89Accident · No injuriesClosedBellanca 7ECA · Miami, FLNTSB MIA74FLA04Accident · No injuriesClosedChampion 7ECA · Jacksonville, FLNTSB MIA73DLD19Accident · No injuriesClosedAeronca 7ECA · Arcadia, FLNTSB MIA72DLD65Accident · No injuriesClosedAeronca 7ECA · Anna Maria Is, FLNTSB MIA71FLA41Accident · Serious injuriesClosedChampion 7ECA · Bunnell, FLNTSB MIA71FKT43Accident · No injuriesClosedChampion 7ECA · Punta Gorda, FLNTSB MIA66F0032Accident · 1 fatalClosedChampion 7ECA-3 · Melbourne, FL