NTSB investigations: Schweizer 269C-1

6 cases on aircraft the registry lists as Schweizer 269C-1, where the first occurrence was “Loss of control - in flight”. 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

20002026

NTSB investigations: Schweizer 269C-1 per year, 2000–2026: 6 cases
2000	1
2004	2
2006	1
2007	2

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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('8059504') AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 250)) 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('8059504')
      AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 250))
  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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('8059504')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 250))
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 NYC07LA077Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Plymouth, MAThe student pilot's failure to maintain control of the helicopter during a hover, and the flight instructor's delayed remedial action.Mar 12, 2007 · N2074K · Substantial damage NTSB NYC07CA093Accident · No injuriesData collectionFinal reportSchweizer 269C · Plymouth, MAThe student pilot's failure to maintain control of the helicopter during landing, and the flight instructor's delayed remedial action.Feb 1, 2007 · N2074K · Substantial damage NTSB ANC06CA090Accident · Minor injuriesData collectionFinal reportSchweizer 300C · Titusville, FLThe failure of the certificated flight instructor (CFI) to maintain control of the helicopter, which resulted in an in-flight collision with terrain. A factor associated with the accident was the dual student's improper use of the cyclic trim.Jul 12, 2006 · N1831A · Substantial damage NTSB FTW04LA209Accident · No injuriesLimited investigationFinal reportSchweizer 269C-1 · Denton, TXThe student pilot's failure to maintain control of the helicopter and the instructor's inadequate supervision of the flight by his delay in taking remedial action.Aug 9, 2004 · N204LH · Substantial damage NTSB LAX04CA233Accident · No injuriesData collectionFinal reportSchweizer 269C-1 · Brentwood, CAthe student's improper use of the cyclic control, the flight instructor's inadequate supervision, and his delayed remedial action. A factor in the accident was the CFI's diverted attention.Jun 5, 2004 · N9421K · Substantial damage NTSB LAX00LA216Accident · No injuriesLimited investigationFinal reportSchweizer 269C-1 · Brentwood, CAThe student's improper execution of a quick-stop maneuver in that he misjudged his altitude and failed to terminate at a stationary hover prior to descending to a low hover. This resulted in an excessive engine power requirement and the student improperly…Jun 5, 2000 · N2029H · Substantial damage