NTSB investigations: Schweizer SGS 1-26E, CA

7 cases on aircraft the registry lists as Schweizer SGS 1-26E. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19752026

NTSB investigations: Schweizer SGS 1-26E, CA per year, 1975–2026: 7 cases
1975	3
1977	1
1979	1
1980	1
1989	1

Where

Open the map

Latest cases

Query with SQL

SELECT c."ntsbNumber", c."eventDate", c."eventType", c."eventCity", c."eventStateOrRegion", a.n_number, a."aircraftMake", a."aircraftModel", c."highestInjuryLevel", c."totalFatal", c."completionStatus", c.report_url FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1 WHERE c."eventStateOrRegion" = 'CA' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('8050124')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

duckdb -csv -c "SELECT c.\"ntsbNumber\", c.\"eventDate\", c.\"eventType\", c.\"eventCity\", c.\"eventStateOrRegion\", a.n_number, a.\"aircraftMake\", a.\"aircraftModel\", c.\"highestInjuryLevel\", c.\"totalFatal\", c.\"completionStatus\", c.report_url
  FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c.\"mKey\" AND a.position = 1
  WHERE c.\"eventStateOrRegion\" = 'CA' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('8050124'))
  ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" 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 c."ntsbNumber", c."eventDate", c."eventType", c."eventCity", c."eventStateOrRegion", a.n_number, a."aircraftMake", a."aircraftModel", c."highestInjuryLevel", c."totalFatal", c."completionStatus", c.report_url
FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1
WHERE c."eventStateOrRegion" = 'CA' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('8050124'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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.

NTSB LAX89LA167Accident · Serious injuriesLimited investigationFinal reportSchweizer T-26E · Fremont, CAThe pilot's failure to maintain sufficient airspeed in an effort to avoid obstacles during an inadequately planned approach.Apr 22, 1989 · N1134S · Substantial damage NTSB LAX80DUG50Accident · Serious injuriesClosedSchweizer SGS126 · Rabbit Dry Lk, CAAug 9, 1980 · N17916 · Substantial damage NTSB LAX79FA069Accident · Serious injuriesClosedSchweizer SGS126 · Rosamond, CAAug 19, 1979 · N65930 · Destroyed NTSB LAX77FA055Accident · 1 fatalClosedSchweizer SGS126 · Ocotillo Wells, CAJul 4, 1977 · N2550H · Destroyed NTSB LAX76FUG15Accident · Minor injuriesClosedSchweizer SGS126 · Lke Elsinore, CASep 13, 1975 · N65961 · Substantial damage NTSB LAX75DUM15Accident · Minor injuriesClosedSchweizer 1-26 · Chula Vista, CAFeb 1, 1975 · N1138S · Destroyed NTSB LAX75DUQ20Accident · No injuriesClosedSchweizer SGS126 · Llano, CAJan 12, 1975 · N126TD · Substantial damage