NTSB investigations: Lycoming 0-320 series, 2005, WA
5 cases on aircraft whose registry engine model is Lycoming 0-320 series. 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
| 1964 | 5 |
|---|---|
| 1965 | 11 |
| 1966 | 7 |
| 1967 | 12 |
| 1968 | 4 |
| 1969 | 5 |
| 1970 | 4 |
| 1971 | 6 |
| 1972 | 8 |
| 1973 | 4 |
| 1974 | 1 |
| 1975 | 6 |
| 1976 | 10 |
| 1977 | 2 |
| 1978 | 12 |
| 1979 | 10 |
| 1980 | 9 |
| 1981 | 14 |
| 1982 | 8 |
| 1983 | 7 |
| 1984 | 6 |
| 1985 | 6 |
| 1986 | 3 |
| 1987 | 5 |
| 1988 | 5 |
| 1989 | 8 |
| 1990 | 4 |
| 1991 | 8 |
| 1992 | 8 |
| 1993 | 3 |
| 1994 | 11 |
| 1995 | 8 |
| 1996 | 6 |
| 1997 | 8 |
| 1998 | 11 |
| 1999 | 11 |
| 2000 | 9 |
| 2001 | 9 |
| 2002 | 8 |
| 2003 | 7 |
| 2004 | 16 |
| 2005 | 5 |
| 2006 | 4 |
| 2007 | 1 |
| 2008 | 11 |
| 2009 | 7 |
| 2010 | 6 |
| 2011 | 7 |
| 2012 | 7 |
| 2013 | 6 |
| 2014 | 3 |
| 2015 | 1 |
| 2016 | 5 |
| 2017 | 4 |
| 2018 | 4 |
| 2019 | 2 |
| 2020 | 3 |
| 2021 | 4 |
| 2022 | 4 |
| 2023 | 1 |
| 2024 | 3 |
| 2025 | 2 |
| 2026 | 6 |
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\") = 2005
AND c.\"eventStateOrRegion\" = 'WA' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41508'))
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") = 2005
AND c."eventStateOrRegion" = 'WA' AND c."eventCountry" = 'USA'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41508'))
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 SEA06FA007Accident · 3 fatalField investigationFinal reportPiper PA-28-140 · Everett, WAThe pilot's inadequate airspeed during his aborted landing takeoff/climb which lead to a series of stall/mushes and subsequent impact with trees. Contributing factors were the pilot's loss of aircraft control during his initial landing approach and his…NTSB SEA05LA185Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Mead, WASeparation of the tailwheel assembly spring resulting in a loss of directional control and subsequent collision with a berm. The berm was a factor in the accident.NTSB SEA05LA163Accident · No injuriesLimited investigationFinal reportSteele Safari · Leavenworth, WAThe failure of the tail rotor drive shaft during cruise flight. Factors include soft, grassy terrain at the location where the pilot executed the autorotational landing.NTSB SEA05CA159Accident · No injuriesData collectionFinal reportCessna 172M · Hoquiam, WAThe pilot's failure to maintain clearance from a fence. The fence was a factor.NTSB SEA05LA106Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Puyallup, WAThe fatigue cracking of the upper torque link attach lugs on the right main landing gear strut, which resulted in separation of the right main landing gear.