NTSB investigations: Lycoming 0-320 series, 1997, CA
13 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\") = 1997
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") = 1997
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 LAX98LA055Accident · No injuriesLimited investigationFinal reportCessna 172N · San Jose, CAthe student pilot's failure to maintain an appropriate airspeed and proper rate of descent, and his misjudged landing flare, which led to an uncontrolled porpoise and eventual collapse of the landing gear.NTSB LAX98FA043Accident · 1 fatalField investigationFinal reportCessna 172N · La Jolla, CAthe pilot's act of suicide by intentionally diving his aircraft into the ocean.NTSB LAX98LA042Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Long Beach, CAthe flight instructor's failure to thoroughly brief his student on the performance standards of the proposed autorotation and the method to be used for a positive transfer of controls. The student's failure to verify the performance standards of the…NTSB LAX98FA039Accident · 2 fatalField investigationFinal reportMooney M20 · Big Bear, CAVFR flight by the pilot into instrument meteorological conditions (VMC), which led to spatial disorientation, loss of aircraft control, and an uncontrolled descent into terrain. Related factors were: the adverse weather conditions, the pilot's lack of…NTSB LAX98LA030Accident · No injuriesLimited investigationFinal reportCessna 172P · San Diego, CAThe student pilot's failure to maintain adequate clearance from a hangar while taxiing.NTSB LAX97LA267Accident · No injuriesLimited investigationFinal reportChampion 7GCBC · San Jose, CAThe pilot's failure to maintain directional control, and excessive remedial action, which resulted in an inadvertent swerve off the runway.NTSB LAX97LA178Accident · Minor injuriesLimited investigationFinal reportRobinson R-22 · Santa Margarita, CAThe failure of the pilot to maintain adequate rotor rpm during a low pass maneuvering flight resulting in loss of control. High density altitude was a factor in the accident.NTSB LAX97LA199Accident · No injuriesLimited investigationFinal reportCessna 172N · El Monte, CAthe student pilot's misunderstanding of the controller's clearance during an aborted touch-and-go landing.NTSB LAX97LA135Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Little River, CAThe pilot's failure to properly judge the flare altitude.NTSB LAX97LA128Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Santa Barbara, CAthe pilot's improper planning/decision, which resulted in loss of engine power, due to fuel exhaustion. His psychological condition was a related factor.NTSB LAX97LA119Accident · No injuriesLimited investigationFinal reportCessna 172N · Oakland, CAthe student pilot's failure to completely reduce the throttle after landing, and his failure to maintain proper runway alignment.NTSB LAX97LA113Accident · No injuriesLimited investigationFinal reportCessna 172M · Petaluma, CAThe pilot's inadequate compensation for the crosswind condition and his failure to maintain directional control.NTSB LAX97LA102Accident · No injuriesLimited investigationFinal reportGreen Cozy III · San Martin, CAA loss of engine power due to fuel contamination. A factor in the accident is the aircraft design, which routes hydraulic lines through the fuel tank.