Champion 7GCAA
FAA incident reports · 123
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 ('21101N8')
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 ('21101N8')
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 19770305004579ABlanca 7GCAA · Islip, NYL main lndg gr broke. Sfc depression appeard to be the result of a previous object strike.Accident 19770129000849ABlanca 7GCAA · Hardin, MTThreaded collar,p/n 3-665A,bottom of oleo slipped down strut. 41HRS on part. Tkof fm Ranch Strip.Accident 19770128001399ABlanca 7GCAA · Marana, AZAcft abandoned. Inj index presumed.Accident 19761125039499ABlanca 7GCAA · Anneville, PAAccident 19760728023649ABlanca 7GCAA · OHAccident 19760509012179ABlanca 7GCAA · Warm Springs, NVStarted slip on final. Ctcd rwy in crab attitudeAccident 19750729037709ABlanca 7GCAA · New Shrewsbury, NJBanner pick up with 11K tailwind.Accident 19750726022309ABlanca 7GCAA · Boise, IDPrecautionary ldg previous flt. Tkof fm gravel rd,wing hit dirt bank.Accident 19750323005469ABlanca 7GCAA · Fairfield, CASim emerg ldg.Accident 19750222003169ABlanca 7GCAA · Fort Ann, NYAccident 19741106036199ABlanca 7GCAA · Shelbyville, ILAs power was apld for tkof acft veered l hit ditch.Accident 19740815026929ABlanca 7GCAA · Salinas, CAIp corrected too late.Accident 19740814029319ABlanca 7GCAA · Clio, MIIp briefed on LCL wx by otr plt. Drg turn aftr clean up swath acft apreared to mush and stall.Accident 19740803025239ABlanca 7GCAA · Asbury Park, NJRegained ctl turned back to rwy. Lost ctl again dptd r side. Plt atmtd get airborne gr hit embkmnt.Accident 19740630024219ABlanca 7GCAA · Frankfort, MIHit a Cessna 182 minor dmg and a Piper aztec substantial dmg. Loose centering mechanism.Accident 19740209002649ABlanca 7GCAA · Warroad, MNAcft in near vert dscnt from abt 300-400FT alt.Accident 19740115002569ABlanca 7GCAA · Andover, IAAcft at low alt obsvd by fox hunters turn l nose dropped sharply hit gnd nose lo steep l bank.Accident 19731208041939ABlanca 7HC · South Haven, MIBlood alcohol lvl 0.23 pct. Acft alt EST fm 750FT to 1400FT.owners manual-1000FT act lost 3 turns.Accident 19730610016579ABlanca 7HC · Blanding, UTWind gusting 8K.aerial search. Hit trees.Accident 19730610016569ABlanca 7HC · Walls, MSLow pass at funeral. Had been flying acft with 20-30 mph lower stall speed.Accident 19730521014589ABlanca 7GCAA · Longmont, COWind gusting 20K.l wg tip dragged rwy. Acft settled on r gr after hitting ditch.Accident 19730407007609ABlanca 7GCAA · Kendallville, INImproperly installed control stick handle separated drg ldg. Acft dropped abruptly.Accident 19730318005689ABlanca 7GCAA · Chowchilla, CA
Back to Champion 7GCAA