NTSB investigations: Schweizer 269C
12 cases on aircraft the registry lists as Schweizer 269C, where the first occurrence was “In flight collision with terrain/water”. 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.
Cases per year
| 1988 | 1 |
|---|---|
| 1991 | 1 |
| 1992 | 1 |
| 1993 | 1 |
| 1994 | 1 |
| 1995 | 1 |
| 1999 | 1 |
| 2001 | 1 |
| 2003 | 2 |
| 2006 | 1 |
| 2007 | 1 |
Where
Open the mapLatest cases
Query with SQL
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 ('8059502')
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\" = 230))
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 ('8059502')
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" = 230))
ORDER BY c."eventDate" DESC, c."ntsbNumber" 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.
NTSB SEA07CA220Accident · No injuriesData collectionFinal reportHughes 269C · Three Forks, MTThe student pilot's failure to maintain control of the aircraft during autorotation. The flight instructor's inadequate supervision was a factor.NTSB CHI06CA168Accident · No injuriesData collectionFinal reportSchweizer 269C · Grand Forks, NDThe dual student's failure to maintain rotor speed during the recovery from the intentional autorotation and the flight instructor's delayed remedial action. Contributing factors were the flight crew's intentional autorotation and dual student's misjudged…NTSB CHI04LA015Accident · 1 fatalLimited investigationFinal reportSchweizer 269C · Fenton, MIThe intentional low altitude flight maneuvering and the ostentatious display by the pilot. The water was a factor to the accident.NTSB SEA03LA151Accident · No injuriesLimited investigationFinal reportHughes 269C · Snohomish, WAThe dual students failure to maintain clearance from the terrain during the go-around from a simulated autorotational flare, and the instructor pilot's failure to take adequate remedial action to keep the dual student from allowing the aircraft to impact the…NTSB CHI01FA257Accident · 2 fatalField investigationFinal reportSchweizer 269C · Waterloo, INAircraft control not maintained for undetermined reasons.NTSB SEA99FA168Accident · 1 fatalField investigationFinal reportSchweizer 269C · Westport, ORThe pilot's failure to maintain clearance from terrain. Factors include low clouds and visibility and near-night light conditions.NTSB NYC95TA190Accident · Minor injuriesFinal reportSchweizer 269C · Baltimore, MDThe pilot's failure to maintain adequate terrain clearance which resulted in an inflight collision with the ground.NTSB LAX95FA033Accident · 1 fatalField investigationFinal reportSchweizer 269C · Valencia, CAthe pilot's failure to maintain adequate clearance from a dirt embankment while performing an undetermined maneuver.NTSB MIA93LA177Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Punta Gorda, FLThe pilot-in-command's improper use of the flight controls (cyclic and collective pitch) during a simulated autorotation with turn, resulting in an in flight collision with terrain with the tail skid and tailrotor blades.NTSB NYC92LA165Accident · No injuriesLimited investigationFinal reportSchweizer 269C · London, OHThe failure of the pilot to properly judge his altitude during a practice autorotation, which resulted in a tail rotor ground strike and roll over upon touchdown.NTSB LAX91LA391Accident · 1 fatalLimited investigationFinal reportSchweizer 269C · Kahului, HIThe student pilot entry into an uncontrolled descent while attempting to perform an autorotation. The student pilot's lack of total experience was a factor in the accident.NTSB MIA89LA018Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Arcadia, FLAfter making an apch to 'the numbers' on rwy 5, the plt decelerated the helicopter & began to air taxi to the refueling area. Subsquently, while decelerating and/or while taxiing, the tail rotor collided with terrain.