Final NTSB investigations: Champion 7DC
8 cases on aircraft the registry lists as Champion 7DC. 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 | 2 |
|---|---|
| 1969 | 1 |
| 1970 | 1 |
| 1981 | 1 |
| 1988 | 1 |
| 1990 | 1 |
| 1995 | 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.\"completionStatus\" = 'Completed'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('21101NB'))
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."completionStatus" = 'Completed'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('21101NB'))
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 BFO95LA086Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Batavia, OHwas the the second pilot's loss of directional control during the takeoff roll, and the flight instructor/pilot-in-command's inadequate supervision of the flight instructor/second pilot. A related factor was the flight instructor/second pilot's lack of total…NTSB FTW90FA059Accident · 1 fatalField investigationFinal reportAeronca 7DC · El Paso, TXPower loss due to failure of the carburetor assembly and the pilot's failure to correct known deficiencies. Factors were contaminated fuel, partially blocked fuel screen, fouled spark plugs, the rough terrain, and the lack of shoulder harnesses.NTSB CHI88DER07Accident · 2 fatalFinal reportChampion 7CCM · Int'L Falls, MNThere were no eyewitnesses to this accident. The aircraft with an instructor and student aboard was reported missing. When located the seaplane had descended into a wooded swamp and the aircraft was substantially damaged and both occupants received fatal…NTSB NYC81FFJ18Accident · Minor injuriesClosedAeronca 7DC · Albion, NYNTSB ANC71DAA17Accident · No injuriesClosedChampion 7EC · Fairbanks, AKNTSB FTW70D0062Accident · No injuriesClosedAeronca 7DC · Waco, TXNTSB UNK65X0840Accident · 1 fatalClosedAeronca 7DC · Eagle River, AKNTSB UNK64X1824Accident · No injuriesClosedAeronca 7AC · Glasgow, MT