NTSB investigations: Lycoming 0-320 series, 2002
21 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
Open the mapLatest 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\") = 2002
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") = 2002
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 NYC03LA023Accident · No injuriesLimited investigationFinal reportCessna 172K · Prestonsburg, KYThe loss of oil pressure for undetermined reasons, which resulted in a failure of connecting rod end bolts, due to an over temperature condition.NTSB FTW03LA040Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Porter, TXThe loss of engine power for an undetermined reason.NTSB CHI03LA016Accident · No injuriesLimited investigationFinal reportLaFerriere Vans RV-4 · Lake Geneva, WIThe loss of engine power due to carburetor ice. A contributing factor was the ditch adjacent to the roadway.NTSB LAX03LA015Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Queen Creek, AZa loss of engine power for undetermined reasons.NTSB ATL03LA003Accident · No injuriesLimited investigationFinal reportCessna 172N · Pompano Beach, FLThe loss of engine power for undetermined reasons.NTSB MIA02FA162Accident · 1 fatalField investigationFinal reportGulfstream American AA-5A · Greeneville, TNA loss of engine power for undetermined reasons and the pilot's decision to continue flight with a known equipment deficiency. Also causal was the pilot's failure to maintain airspeed which resulted in a stall.NTSB LAX02LA269Accident · No injuriesLimited investigationFinal reportCessna 172N · Lakeside, CAThe failure of the engine to respond for undetermined reasons. Also causal was the student's decision to continue the simulated emergency maneuver to an altitude that was insufficient to allow for contingency options. The unsuitable nature of the terrain…NTSB FTW02LA244Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Price, TXThe loss of engine power for an undetermined reason, which resulted in a forced landing.NTSB SEA02LA163Accident · Minor injuriesLimited investigationFinal reportPiper PA-14 · Eastsound, WALoss of engine power for undetermined reasons.NTSB CHI02LA263Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Seneca, ILThe loss of engine power for undetermined reasons. Factors were the low altitude, the trees, and the unsuitable terrain encountered for the forced landing.NTSB CHI02LA252Accident · Minor injuriesLimited investigationFinal reportLancair 320 · Iola, KSthe engine failure for undetermined reasons and the lack of a suitable landing area to execute a forced landing.NTSB FTW02LA251Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Masterson, TXThe loss of engine power due to fuel starvation as a result of a blockage of the carburetor. A contributing factor was the lack of suitable terrain for the emergency landing.NTSB IAD02LA080Accident · Serious injuriesLimited investigationFinal reportCessna 172K · Patuxent River, MDThe pilot's inadequate fuel calculations, which resulted in fuel exhaustion and a subsequent loss of engine power.NTSB FTW02LA185Accident · Minor injuriesLimited investigationFinal reportQuinn RV-6A · El Paso, TXA loss of engine power for undetermined reasons.NTSB LAX02FA191Accident · 3 fatalField investigationFinal reportPiper PA-23-160 · Rio Rico, AZa loss of engine power in the left engine for undetermined reasons, and the failure of the flying pilot to maintain an adequate single engine minimum control airspeed and aircraft control. Also causal was the decision of all three of the pilots to continue…NTSB FTW02LA159Accident · No injuriesLimited investigationFinal reportCessna 172N · Glen Rose, TXThe pilot's failure to set the ignition key to the both magnetos position, which resulted in a loss of engine power. Contributing factors were the failure of the left magneto, the lack of suitable terrain for the forced landing, and the dark night.NTSB FTW02LA133Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Owasso, OKThe loss of engine power as a result of the pilot's failure to remove the engine cowling plugs during the preflight inspection. A contributing factor was lack of suitable terrain for the forced landing.NTSB SEA02LA071Accident · No injuriesLimited investigationFinal reportBrunger Osprey II · Orofino, IDThe aircraft's inadequate carburetor heat air box system, leading to an accumulation of ice in the carburetor throat during final approach to landing. Factors include carburetor icing conditions, the pilot's failure to correctly judge the height of the…NTSB LAX02TA105Accident · No injuriesFinal reportPiper PA-18-150 · Winnemucca, NVThe pilot's inadequate fuel consumption calculations that lead to fuel exhaustion.NTSB FTW02LA082Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Mount Selman, TXthe loss of engine power for an undetermined reason, which resulted in a forced landing. A factor was the lack of suitable terrain for the forced landing.NTSB IAD02LA028Accident · 1 fatalLimited investigationFinal reportWilburn Jodel F-12 · Clarksville, VAThe pilot's failure to maintain airspeed after a loss of engine power, which resulted in an inadvertent stall/spin. Also causal, was the loss of engine power for undetermined reasons.