NTSB investigations: Schweizer 269C, NV
7 cases on aircraft the registry lists as Schweizer 269C. 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
| 2008 | 1 |
|---|---|
| 2009 | 1 |
| 2011 | 1 |
| 2012 | 1 |
| 2015 | 1 |
| 2018 | 1 |
| 2020 | 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.\"eventStateOrRegion\" = 'NV' 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 ('8059502'))
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" = 'NV' 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 ('8059502'))
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 WPR20LA190Accident · No injuriesClass 3 · LimitedFinal reportSchweizer 269C · North Las Vegas, NVA total loss of engine power for reasons that could not be determined based on the available information.NTSB WPR18LA170Accident · Minor injuriesClass 3 · LimitedFinal reportSchweizer 269C · Las Vegas, NVThe pilot’s failure to take the appropriate corrective action for ground resonance, which resulted in a loss of helicopter control.NTSB WPR15LA245Accident · Minor injuriesLimited investigationFinal reportSchweizer 269C · Las Vegas, NVA total loss of engine power during a practice autorotation for reasons that could not be determined.NTSB WPR12CA100Accident · Minor injuriesData collectionFinal reportSchweizer 269C · Las Vegas, NVThe pilot's inadequate compensation for the known wind conditions during a hovering maneuver, which resulted in a loss of tail rotor effectiveness and directional control.NTSB WPR11CA250Accident · Serious injuriesData collectionFinal reportSchweizer 269C · Las Vegas, NVThe pilot's failure to maintain adequate clearance from terrain while attempting a transition from hovering flight to forward flight over a mesa in windy, downdraft conditions.NTSB WPR09LA213Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Las Vegas, NVLoss of engine power during approach for undetermined reasons.NTSB LAX08CA069Accident · Minor injuriesData collectionFinal reportSchweizer 269C · Las Vegas, NVThe certificated flight instructor's delayed remedial action, and inadequate supervision while landing on a pinnacle. Factors contributing to the accident were the lack of suitable terrain for a forced landing, and the student's failure to maintain rotor rpm.