NTSB investigations: Schweizer 269C, 2013
5 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
| 1988 | 1 |
|---|---|
| 1989 | 2 |
| 1990 | 2 |
| 1991 | 3 |
| 1992 | 5 |
| 1993 | 5 |
| 1994 | 8 |
| 1995 | 4 |
| 1996 | 2 |
| 1997 | 3 |
| 1998 | 6 |
| 1999 | 3 |
| 2000 | 4 |
| 2001 | 5 |
| 2002 | 5 |
| 2003 | 5 |
| 2004 | 6 |
| 2005 | 3 |
| 2006 | 6 |
| 2007 | 4 |
| 2008 | 5 |
| 2009 | 3 |
| 2010 | 5 |
| 2011 | 4 |
| 2012 | 5 |
| 2013 | 5 |
| 2014 | 2 |
| 2015 | 5 |
| 2017 | 1 |
| 2018 | 2 |
| 2019 | 1 |
| 2020 | 3 |
| 2022 | 1 |
| 2023 | 2 |
| 2024 | 1 |
| 2025 | 1 |
| 2026 | 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 year(c.\"eventDate\") = 2013
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 year(c."eventDate") = 2013
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 ERA14CA080Accident · Minor injuriesData collectionFinal reportSchweizer 269C · White Plains, NYThe flight instructor's failure to maintain airspeed during a practice autorotation, which resulted in a hard landing and subsequent loss of controlNTSB CEN13LA431Accident · Minor injuriesLimited investigationFinal reportSchweizer 269C · Gary, SDThe failure of the engine connecting rod due to fatigue.NTSB ERA13LA314Accident · Serious injuriesLimited investigationFinal reportSikorsky 269C · Burnham, METhe pilot's failure to maintain yaw control while operating out of ground effect at a low airspeed, which resulted in the loss of tail rotor effectiveness, an uncontrolled descent, and an in-flight collision with trees and terrain. Contributing to the…NTSB ERA13LA300Accident · Minor injuriesLimited investigationFinal reportSikorsky 269C · Lumberton, NJThe pilot's movement of the throttle to the idle detent at the beginning of a practice autorotation, which was contrary to procedures and resulted in the engine hesitating during the power recovery and a subsequent hard landing.NTSB WPR13CA253Accident · No injuriesData collectionFinal reportSchweizer 300C · Hamilton, MTThe student pilot’s failure to maintain helicopter control during a practice autorotation and the flight instructor's delayed remedial action.