Champion 7EC
FAA incident reports · 113
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 ('21101NM')
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 ('21101NM')
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 19770728022249ABlanca 7FC · Baroda, MIBox was not effectively secured. Restricted aft movement of control stick on landing.Accident 19770614015219ABlanca 7EC · Urbana, ILStruck 30 ft power line.Accident 19760719023519ABlanca 7EC · Olivia, MNL wheel dropped into a badger hole.Accident 19760425010039ABlanca 7EC · Fertile, MNAccident 19760311005889ABlanca 7FC · Lebanon, INAccident 19751014035369ABlanca 7EC · Homer, AKAccident 19750831024999ABlanca 7EC · Petaluma, CAUnexpected gusts at flare turned acft. Plt pulled up to avoid hangars,acft & pool.Accident 19750610015419ABlanca 7EC · Corona, CABounced ldg,added pwr drifted off rnwy,whls entered high weeds & brushAccident 19750304003999ABlanca 7EC · Northfield, MNApld brakes acft slid l and then struck a snowbank adj to rwy.Accident 19740824028689ABlanca 7EC · Vina, CABuzzing parents home. Dr stated occupants had been drinking.Accident 19730704028539ABlanca 7EC · Tacoma, WAFloat equipped. Both spreader bars corroded.Accident 19730401009599ABlanca 7EC · Lakeland, FLDrg lift off acft struck either a light or the grass. Turned l,hit gnd on r wing and side.Accident 19730323006079ABlanca 7EC · Ambler, PAAircrafts N39825,N6631A sustantial damage. Winds gusting 35K.
Back to Champion 7EC