Champion 7ECA
FAA incident reports · 367
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 ('21101NN')
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 ('21101NN')
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 19740331014009ABlanca 7ECA · Xenia, OHLow alt acrobatics. Entered spin,un rcvr. Plt blood alcohol lvl 100MG .Accident 19740323007279ABlanca 7ECA · San Jose, CATall grass beside rwy.Accident 19740316005959ABlanca 7ECA · Midland, NCLwrg vis,lndd in open fld,r gr hit ditch aftr t/d.Accident 19740213002999ABlanca 7ECA · Plantersville, SCSim eng fail. Steep turn while low & slow.Accident 19740130003419ABlanca 7ECA · Austin, MNStruck snow bordering rwy.Accident 19731006039819ABlanca 7HC · Malboro, MABounced ldg acft airborne in near-stall attitude un clr trees plt elected chop pwr gnd loop acft.Accident 19730920037609ABlanca 7ECA · Statesboro, GAAsel flt test short fld ldg a/s critical plt applied power to rapidly eng did not respond.Accident 19730916030539ABlanca 7HC · Tewksbury, MAAcft svcd for am fish spot flt. Rope tied to tail broke.Accident 19730902028219ABlanca 7ECA · Painton, MOFail occurred arnd edges of weld for bolt hole bushing.Accident 19730804022149ABlanca 7ECA · Plano, TXPilot attempted takeoff from soft surface with tall grass. Carb air cleaner clogged by grass,seeds.Accident 19730729023509ABlanca 7HC · Jacksonville, FLEncountered gusty cross wind during takeoff run.Accident 19730707026461ABlanca 7HC · Sonoma, CAChampion crashed into residential garage.Beech had ctc with UNICOM.no ctc with champion.Accident 19730707020819ABlanca 7HC · Goldsboro, NCEntered half roll while avoiding hawk. Un recoverAccident 19730506012199ABlanca 7ECA · Kenai, AKHit filings on beach hidden by grnd contour and shack.Accident 19730326005239ABlanca 7ECA · Pacoima, CAWind gusting 20K.right ldg gr hit cement obstn.Accident 19730218003839ABlanca 7ECA · Clovis, NMGave way to air carrier. Went off taxiway on grass. Taxied into cement drain culvertAccident 19730207002249ABlanca 7ECA · Las Vegas, NVLeft gear shock strut failed
Back to Champion 7ECA