NTSB investigations: Lycoming 0-320 series, 2006, CA
19 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\") = 2006
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") = 2006
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 LAX07FA061Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Bridgeport, CAThe pilot's attempted VFR flight into instrument meteorological conditions and subsequent failure to maintain aircraft control due to spatial disorientation. Contributing to the accident was mountain obscuration.NTSB LAX07FA060Accident · 2 fatalField investigationFinal reportPiper PA-28-161 · Big Pine, CAThe inadequate in-flight/planning decision of both pilots to fly up a box canyon at low altitude, and their failure to maintain clearance from the terrain.NTSB LAX07CA043Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Santa Clarita, CAthe student pilot's inadequate compensation for wind conditions and the instructor's failure to arrest the descent, which resulted in a dynamic rollover. Also causal was the inadequate supervision by the instructor. A factor in the accident was the wind shift…NTSB LAX07LA022Accident · Serious injuriesLimited investigationFinal reportFish Vans RV-6 · Turlock, CAa partial loss of engine power due to the broken piston rings in the no. 4 cylinder. Also causal was the pilot's failure to maintain adequate airspeed while maneuvering for a forced landing, which resulted in a stall/mush.NTSB LAX07CA009Accident · No injuriesData collectionFinal reportFinney Thorp T-18 · San Diego, CAthe pilot's inadequate compensation for the crosswind conditions and failure to maintain directional control during landing.NTSB LAX06CA294Accident · No injuriesData collectionFinal reportGrumman American Avn. AA-5 · Watsonville, CAA loss of engine power due to fuel exhaustion as a result of the pilot's inadequate preflight planning, en route fuel consumption calculations, and in-flight decision to continue to the destination instead of stopping en route for fuel.NTSB LAX06FA289Accident · 1 fatalField investigationFinal reportPiper PA-23-160 · Santa Maria, CAThe non-instrument rated pilot's decision to continue flight into instrument meteorological conditions resulting in spatial disorientation and a loss of control.NTSB LAX06CA282Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Auburn, CAthe pilot's failure to comply with weight and balance limitations and failure to attain an adequate airspeed, which resulted in a stall and loss of control.NTSB LAX06LA275Accident · 2 fatalLimited investigationFinal reportTerry Tevis RV-6A · Novato, CAThe pilot's failure to maintain terrain clearance while maneuvering. Rising terrain, fog and dark night conditions were factors.NTSB LAX06LA264Accident · 1 fatalLimited investigationFinal reportSchifferer Breezy RLU-1 · Ramona, CAThe pilot's failure to maintain adequate airspeed during the takeoff climb, that resulted in a stall/spin.NTSB LAX06CA253Accident · Serious injuriesData collectionFinal reportCessna 172M · Gasquet, CAthe pilot's selection of a runway favoring tailwind conditions, his delayed decision to go around, and his failure to attain and maintain an adequate airspeed during the aborted landing. Contributing factors were the tailwind and wind shear conditions…NTSB LAX06CA252Accident · No injuriesData collectionFinal reportCessna 172M · San Andreas, CAthe student pilot's improper soft-field takeoff technique and failure to obtain and maintain an adequate airspeed, which resulted in a stall mush. The certificated flight instructor's inadequate supervision of the maneuver was also causal.NTSB LAX06LA251Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Grass Valley, CAThe loss of available engine power due to vapor lock. A contributing factor was the high temperature.NTSB LAX06LA183Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-151 · Oxnard, CAThe loss of engine power for undetermined reasons.NTSB LAX06CA138Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Paso Robles, CAthe pilot's inadequate compensation for the crosswind conditions and failure to maintain directional control.NTSB LAX06CA125Accident · Minor injuriesData collectionFinal reportCessna 172N · Compton, CAcontrol interference by the student pilot during a go-around that resulted in an in-flight collision with power lines.NTSB LAX06CA116Accident · Minor injuriesData collectionFinal reportRobinson R22 · El Monte, CAthe pilot's inadequate compensation for the wind conditions, which resulted in the helicopter dynamically rolling over.NTSB LAX06CA115Accident · No injuriesData collectionFinal reportCessna 172M · Murrieta, CAa partial loss of engine power resulting from the student pilot's mismanagement of the mixture control.NTSB LAX06LA108Accident · No injuriesLimited investigationFinal reportCessna 172N · Sacramento, CAthe failure of the pilot of the other airplane to maintain an adequate clearance from obstacles while taxiing.