NTSB investigations: Schweizer 269C, 2002
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\") = 2002
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") = 2002
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 LAX03LA052Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Los Banos, CAThe improper engine overhaul by other maintenance personnel, which resulted in an exhaust valve failure and a total loss of engine power while in maneuvering flight.NTSB DEN02LA098Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Broomfield, COmaintenance personnel's failure to secure the landing skid oleo strut bolt during the last 50-hour inspection, causing the left rear skid to collapse and the tail rotor to strike the ground.NTSB ATL02LA159Accident · Serious injuriesLimited investigationFinal reportSchweizer 300C · Haleyville, ALThe failure of maintenance personnel to perform an adequate inspection of loose intake components, which resulted in a total loss of engine power and subsequent emergency descent, forced landing, and collision with terrain in dark night conditions.NTSB LAX02LA161Accident · Minor injuriesLimited investigationFinal reportSchweizer 269C · Phoenix, AZthe CFI's failure to maintain an adequate airspeed resulted in a settling with power, and the CFI's failure to take remedial action. A factor in the accident was the high density altitude.NTSB LAX02LA137Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Scottsdale, AZThe flight instructor's inadequate remedial action following the onset of ground resonance.