NTSB investigations: Lycoming 0-320 series, 2008, CA
17 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 | 25 |
|---|---|
| 1965 | 30 |
| 1966 | 46 |
| 1967 | 50 |
| 1968 | 41 |
| 1969 | 33 |
| 1970 | 41 |
| 1971 | 30 |
| 1972 | 36 |
| 1973 | 31 |
| 1974 | 24 |
| 1975 | 24 |
| 1976 | 18 |
| 1977 | 39 |
| 1978 | 36 |
| 1979 | 32 |
| 1980 | 32 |
| 1981 | 30 |
| 1982 | 28 |
| 1983 | 27 |
| 1984 | 24 |
| 1985 | 19 |
| 1986 | 27 |
| 1987 | 22 |
| 1988 | 22 |
| 1989 | 19 |
| 1990 | 29 |
| 1991 | 22 |
| 1992 | 20 |
| 1993 | 28 |
| 1994 | 25 |
| 1995 | 20 |
| 1996 | 20 |
| 1997 | 13 |
| 1998 | 17 |
| 1999 | 20 |
| 2000 | 24 |
| 2001 | 24 |
| 2002 | 25 |
| 2003 | 21 |
| 2004 | 17 |
| 2005 | 20 |
| 2006 | 19 |
| 2007 | 18 |
| 2008 | 17 |
| 2009 | 17 |
| 2010 | 12 |
| 2011 | 9 |
| 2012 | 6 |
| 2013 | 11 |
| 2014 | 8 |
| 2015 | 12 |
| 2016 | 12 |
| 2017 | 12 |
| 2018 | 13 |
| 2019 | 14 |
| 2020 | 7 |
| 2021 | 7 |
| 2022 | 6 |
| 2023 | 13 |
| 2024 | 9 |
| 2025 | 3 |
| 2026 | 11 |
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\") = 2008
AND c.\"eventStateOrRegion\" = 'CA' 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") = 2008
AND c."eventStateOrRegion" = 'CA' 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 SEA08LA191Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Burbank, CAThe pilot's improper preflight and in-flight planning, which resulted in fuel exhaustion. Contributing to the accident were the pilot's loss of situational awareness while conducting the normal and emergency checklists during his turn from base to final…NTSB LAX08CA255Accident · No injuriesData collectionFinal reportPiper PA-20 · Grass Valley, CAThe pilot's failure to maintain directional control due to his foot slipping off one rudder pedal while braking.NTSB SEA08LA155Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Oakland, CAA loss of engine power due to oil starvation. The oil starvation event was due to the failure of maintenance personnel to tighten the mounting bolts for the newly installed vacuum pump.NTSB LAX08LA206Accident · No injuriesLimited investigationFinal reportCessna 172N · El Cajon, CAThe loss of engine power due to carburetor ice resulting from the flight instructor's failure to use the carburetor heat when simulating an engine failure. Contributing to the accident were the carburetor icing weather condition and the lack of suitable…NTSB LAX08CA192Accident · No injuriesData collectionFinal reportCessna 172M · San Diego, CAThe student pilot's failure to maintain directional control during a touch-and-go landing.NTSB LAX08CA169Accident · No injuriesData collectionFinal reportCessna 172M · Byron, CAThe student pilot's failure to maintain directional control during landing rollout.NTSB LAX08CA165Accident · No injuriesData collectionFinal reportCessna 172M · Byron, CAThe flight instructor's inadequate compensation for the wind conditions, and his inadequate supervision of the student pilot. Factors contributing to the accident were a sudden wind shift and wind gusts.NTSB SEA08LA142Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Big Bear City, CAThe pilot's failure to maintain adequate airspeed while on approach to landing that resulted in a stall/mush. Contributing to the accident was the wind shear and the high density altitude condition.NTSB LAX08CA149Accident · No injuriesData collectionFinal reportCessna 172N · Palo Alto, CAThe pilot's inadequate recovery from a bounced landing.NTSB LAX08CA150Accident · No injuriesData collectionFinal reportBellanca 7GCBC · Rockport, CAThe pilot's performance of VFR flight into IMC, resulting in failure to maintain terrain clearance. Contributing to the accident was the fog.NTSB LAX08CA114Accident · No injuriesData collectionFinal reportMurphy Murphy Rebel · Grass Valley, CAThe pilot's failure to maintain directional control.NTSB LAX08FA109Accident · Serious injuriesField investigationFinal reportPiper PA-23-160 · San Dimas, CAA loss of engine power in the left engine due to fuel starvation as a result of the pilot's inadequate preflight inspection and the pilot's failure to abort the takeoff following the power loss.NTSB SEA08CA088Accident · No injuriesData collectionFinal reportAmerican Champion 7GCAA · Tracy, CAThe flight instructor's inadequate compensation for the tailwind condition and failure to maintain adequate airspeed that led to an inadvertent stall.NTSB LAX08FA049Accident · 5 fatalField investigationFinal reportCessna 172N · Corona, CAThe failure of both pilots to see and avoid the other airplane.NTSB LAX08CA048Accident · Minor injuriesData collectionFinal reportWaltermire Glastar · Vacaville, CAThe pilot's failure to maintain directional control during landing and a lack of experience in conventional gear airplanes.NTSB SEA08CA065Accident · No injuriesData collectionFinal reportRobinson R-22 · Riverside, CAThe pilot's misjudged landing flare and improper use of the collective control.NTSB LAX08CA044Accident · No injuriesData collectionFinal reportBellanca 7GCBC · Exeter, CAThe pilot's failure to maintain directional control.