NTSB investigations: Lycoming 0-320 series, 2006
18 cases on aircraft whose registry engine model is Lycoming 0-320 series, where the first occurrence was “Loss of engine power”. 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
| 1982 | 15 |
|---|---|
| 1983 | 11 |
| 1984 | 7 |
| 1985 | 9 |
| 1986 | 16 |
| 1987 | 18 |
| 1988 | 4 |
| 1989 | 4 |
| 1990 | 6 |
| 1991 | 12 |
| 1992 | 9 |
| 1993 | 8 |
| 1994 | 7 |
| 1995 | 14 |
| 1996 | 9 |
| 1997 | 16 |
| 1998 | 17 |
| 1999 | 15 |
| 2000 | 13 |
| 2001 | 23 |
| 2002 | 21 |
| 2003 | 21 |
| 2004 | 20 |
| 2005 | 13 |
| 2006 | 18 |
| 2007 | 15 |
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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41508')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 350))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41508')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 350))
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 SEA07LA038Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Blaine, WAThe loss of engine power for undetermined reasons. Factors were the unsuitable rough/uneven terrain.NTSB CHI07CA044Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Cheyboygan, MIA loss of engine power for undetermined reasons. A factor was the soft terrain encountered during the lanidng.NTSB DFW06CA212Accident · Minor injuriesData collectionFinal reportVans RV4 · Springtown, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW06LA208Accident · No injuriesLimited investigationFinal reportMorton Mustang II · Conroe, TXThe loss of engine power for an undetermined reason. A contributing factor was the lack of suitable terrain for the forced landing.NTSB CHI06CA253Accident · No injuriesData collectionFinal reportHedeman Tailwind W8 · Platteville, WIThe loss of engine power as a result of the pilot's inadequate preflight which resulted in a blocked fuel vent that led to fuel starvation.NTSB DFW06LA199Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Houston, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB CHI06LA230Accident · 1 fatalLimited investigationFinal reportDix Acro Sport II · Coldwater, MIThe loss of engine power for undetermined reasons and the pilot's failure to maintain sufficient airspeed during the resulting forced landing which resulted in the inadvertent stall and subsequent impact with the ground. The rising terrain was a factor.NTSB ANC06LA104Accident · No injuriesLimited investigationFinal reportCessna 172N · Anchorage, AKThe possible loss of engine power during takeoff/initial climb for an unknown reason, which resulted in a forced landing in rough terrain and a nose over.NTSB ATL06LA090Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Nashville, TNImproper installation of the fuel line by maintenance personnel which resulted in the fuel line disconnecting and a loss of engine power during approach.NTSB NYC06LA124Accident · Minor injuriesLimited investigationFinal reportCessna C-172N · Vineyard Haven, MAThe pilot's improper preflight planning and improper fuel consumption calculations, which resulted in fuel exhaustion and a subsequent loss of engine power.NTSB LAX06LA183Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-151 · Oxnard, CAThe loss of engine power for undetermined reasons.NTSB CHI06CA136Accident · No injuriesData collectionFinal reportMiller Rutan Long-Ez · Morris, ILThe partial loss of engine power during the final approach to landing for undetermined reasons, and the unsuitable terrain for landing encountered by the pilot. The tall grass was a factor.NTSB ANC06LA056Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Naknek, AKA loss of engine power during cruise flight for an undetermined reason, which resulted in a forced landing and subsequent collision with high vegetation and the ground.NTSB CHI06LA084Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Muncie, INThe loss of engine power during the final approach to land for an undetermined reason.NTSB CHI06LA081Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Schaumburg, ILThe loss of engine power for an undetermined reason during takeoff-initial climb.NTSB MIA06LA054Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Lehigh Acres, FLThe loss of engine power for undetermined reasons, resulting in a nose-over during the forced landing.NTSB SEA06LA049Accident · No injuriesLimited investigationFinal reportCessna 172N · Snohomish, WACarburetor heat was not used during the initial climb in probable serious carburetor icing conditions during cruise power. Carburetor icing conditions and wet terrain were factors.NTSB NYC06LA050Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Yonkers, NYA loss of engine power for undetermined reasons, which resulted in a ditching.