Schweizer SGS 2-32
FAA incident reports · 54
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 ('8050206')
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 ('8050206')
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 19740427012679AScwzer SGS232 · Yerrington, NVCollided with boulder after losing lift. Lnd in fld adjacent to strip.Accident 19740206002389AScwzer SGS232 · Llano, CACenter wheel sgl fixed ldg gr. Wind gusting 60K.Accident 19730622021709AScwzer SGS232 · Waialua, HIFlew into canyon while watching peacock.Accident 19730218003939AScwzer SGS232 · Maricopa, AZTow rope broke. Had to avoid telephone poles.
Back to Schweizer SGS 2-32