NTSB investigations: Lycoming 0-320 series, 1983, WA
7 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
Latest 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\") = 1983
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") = 1983
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 SEA83FA189Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Everett, WAThe acft collided with trees and the ground in an attempt to return to the arpt after takeoff. The acft crashed one milesouth of the arpt in IMC weather in the early hours of the morning. Witnesses said dense fog existed at the time with zero visibility. The…NTSB SEA83LA182Accident · No injuriesLimited investigationFinal reportPiper PA28-140 · Arlington, WAThe acft nosed over while taxiing unoccupied after being hand propped for a start by the pilot. The pilot stated that hewas unable to start the acft normally so he hand propped it with no one in the cockpit. The unoccupied acft taxied from the ramp across the…NTSB SEA83LA163Accident · No injuriesLimited investigationFinal reportCessna 172M · Friday Harbor, WADuring arrival, the plt elected to land on an uphill rwy with a tail wind. She stated that she was high on final & side slipped until reaching the correct altitude while using the VASI lights for a reference. As she approached the rwy, the wind blew the acft…NTSB SEA83LA112Accident · No injuriesLimited investigationFinal reportCessna 180H · Blakely Island, WAA Cessna 180H, N2429F, was being landed on rwy 19 after a Cessna 172M, N80202, had just landed. The Cessna 180 plt stated that during arrival, the wind socks at the ends of the rwy were swinging in all directions & there was light to moderate turbulence.…NTSB SEA83LA075Accident · No injuriesLimited investigationFinal reportCessna 172 PII · Snohomish, WAThe plt stated he misjudged the approach to land and landed on the last 1/3 of the runway. Brakes were applied during landing roll but the acft rolled off the end of the runway, struck a ditch with the nosewheel and came to rest inverted.NTSB SEA83LA066Accident · No injuriesLimited investigationFinal reportCessna 172N · Telma, WAThe aircraft collided with deep unplowed snow on the runway during takeoff and nosed over. The pilot stated that he had landed on frozen snow but when he returned to takeoff the snow was soft. He had a 1200 ft long portion of the runway cleared but it was…NTSB SEA83FA060Accident · 1 fatalField investigationFinal reportGlasair SH-2 · 5 Nm E. Of Kent, WAThe homebuilt acft collided with powerlines on final approach and crashed. The pilot was on a flight from one airport toanother to demonstrate his acrt to other builders of the acft. He was observed to enter the pattern and fly a low base leg and final…