Champion 7AC
FAA incident reports · 60
Matched to the registry by N-number and event date, newest first.
Query with SQL
duckdb -csv -c "SELECT report_number, event_date, event_type, city, state, aircraft_make, aircraft_model, aircraft_damage, fatal_injuries, n_number
FROM 'https://openairdocs.org/data/latest/faa_incident_report.parquet'
WHERE aircraft_model_code IN ('21101MA')
ORDER BY event_date DESC, report_number 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 report_number, event_date, event_type, city, state, aircraft_make, aircraft_model, aircraft_damage, fatal_injuries, n_number
FROM 'https://openairdocs.org/data/latest/faa_incident_report.parquet'
WHERE aircraft_model_code IN ('21101MA')
ORDER BY event_date DESC, report_number 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.
Accident 19770702031559ABlanca 7AC · Egg Harbor, NJR eng cowling opend in flight. Plt expired on 7/12177.Accident 19770411009399ABlanca 7AC · Vancouver, WA15YR old,no certificate,flying with owners permission. Pax not aware of plts lack of experience.Accident 19761205040479ABlanca 7AC · Remington, INAccident 19760731021479ABlanca 7AC · Thomas, OKChecking cattle.Accident 19760323008289ABlanca 7KCA* · Dillingham, AKBlood alcohol level 177 mg . Plts last student medical dtd feb 71.Accident 19750403006759ABlanca 7AC · San Augustine, TXAuto gas in tank. Lost ctl trying to ret to fld.Accident 19740623018949ABlanca 7AC · Winterport, MEPlt diverted attention from flying during search. Acft stalled drg turn.Accident 19740407011069ABlanca 7AC · Falmouth, KYWind gusting 30K.rolled aprx 1500FT enctrd wind gust.Accident 19740130002589ABlanca 7AC · Dayton, TNStruck power lines while attempting forced landing on highway.Accident 19730527025209ABlanca 7HC · Riverside, CAAcft reg and dmg not rptd on parked acft.
Back to Champion 7AC