NTSB investigations: Champion 7ECA, MA
12 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 |
|---|---|
| 1968 | 1 |
| 1971 | 1 |
| 1973 | 2 |
| 1974 | 2 |
| 1975 | 1 |
| 1977 | 1 |
| 1982 | 1 |
| 1988 | 1 |
| 2002 | 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\" = 'MA' 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" = 'MA' 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 NYC02LA179Accident · Minor injuriesLimited investigationFinal reportChampion 7ECA · Stow, MAThe pilot's improper recover from a bounce landing, which resulted in a loss of directional control and collision with a vehicle. A factor in this accident was the crosswind condition.NTSB NYC88LA220Accident · Minor injuriesLimited investigationFinal reportChampion 7ECA · Lakeville, MAAccording to the acft owner, N9022L'S fuel tanks were only one quarter full of fuel when the plt took off. The pax said that after about an hour of flying the engine began to run roughly and then it finally quit. The plt made an unsuccessful forced landing.…NTSB NYC82DA195Accident · No injuriesFinal reportChampion 7ECA · Lawrence, MAThe instructor pilot reported that there was a loss of power after the student had adjusted his pattern for another aircraft and turned on final approach. The instructor took control of the aircraft and landed on a street. During the landing the aircraft…NTSB NYC77DNA33Accident · No injuriesClosedCitabria 7ECA · Race Point, MANTSB NYC76DNA03Accident · Minor injuriesClosedBellanca 7ECA · Martha Vinyard, MANTSB NYC75ANA27Accident · Serious injuriesClosedChampion 7ECA · Hanson, MANTSB NYC75DNA06Accident · No injuriesClosedBellanca 7ECA · Marthas Vnyd, MANTSB NYC74DNA18Accident · Minor injuriesClosedChampion 7ECA · Malboro, MANTSB NYC74DNA21Accident · No injuriesClosedChampion 7AC · Tewksbury, MANTSB NYC72FNA07Accident · No injuriesClosedChampion 7ECA · West Tisbury, MANTSB NYC68D0342Accident · No injuriesClosedChampion 7ECA · Norfolk, MANTSB NYC66F0122Accident · Minor injuriesClosedChampion 7ECA · Norfolk, MA