NTSB investigations: Lycoming 0-320 series, 1998
17 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\") = 1998
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") = 1998
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 MIA99LA060Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Immokalee, FLThe certified flight instructor's inadequate supervision and his inadequate management of the fuel, which resulted in fuel exhaustion.NTSB NYC99LA040Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Fairfield, PAThe pilot's failure to properly use carburetor heat which resulted in carburetor ice and loss of engine power. Contributing factor were trees.NTSB ANC99LA011Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Willow, AKA loss of engine power due to an undetermined reason. A factor associated with the accident was unsuitable terrain for a forced landing.NTSB CHI98LA362Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Iowa City, IAA loss of engine power for undetermined reasons.NTSB ATL98LA131Accident · No injuriesLimited investigationFinal reportPiper PA 22-150 · Lancaster, SCThe loss of engine power for undetermined reasons. Factor were conditions favorable for the formation of carburetor ice..NTSB CHI98LA335Accident · No injuriesLimited investigationFinal reportCessna 172 · Harrisburg, ILthe loss of engine power for undetermined reasons.NTSB ATL98LA116Accident · Serious injuriesLimited investigationFinal reportPiper PA-12 · Myrtle Beach, SCThe pilot's inadequate preflight planning of fuel required for the flight that resulted in fuel exhaustion and the total loss of engine power. A factor was the pilot continued flight operation with known deficiencies in equipment.NTSB ANC98LA123Accident · Minor injuriesLimited investigationFinal reportPiper PA-14 · Chugiak, AKThe loss of engine power for an undetermined reason.NTSB CHI98FA300Accident · 2 fatalField investigationFinal reportPiper PA-18-150 · Rosemount, MNThe loss of engine power due to water-contaminated fuel and the pilot's failure to maintain adequate airspeed which resulted in a stall.NTSB CHI98LA255Accident · Minor injuriesLimited investigationFinal reportCessna 172N · New Lenox, ILLoss of engine power for undetermined reasons.NTSB FTW98LA321Accident · No injuriesLimited investigationFinal reportPiper PA-23 · Bridgeport, TXThe flight instructor's delay in recognizing and responding to the loss of right engine power which resulted in the airplane landing short of the runway. A factor was the loss of right engine power for undetermined reasons.NTSB SEA98LA133Accident · No injuriesLimited investigationFinal reportBeech 23 · Oakville, WALoss of power due to the failure of an exhaust valve, and overloading of the landing gear. Factors include the failure of maintenance personnel to verify proper compliance with an Airworthiness Directive related to the exhaust valve, and soft terrain.NTSB FTW98LA242Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-1C · Roanoke, TXThe loss of engine power resulting from an excessively rich mixture for an undetermined reason. A factor was the lack of suitable terrain for the forced landing.NTSB CHI98LA147Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Hannibal, MOa loss of engine power due to undetermined reasons. A factor was the rough field in which the forced landing was made.NTSB NYC98LA089Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Berkley, MAloss of engine power for undetermined reason(s), which resulted in a forced landing and subsequent nose-over on uneven terrain. Uneven terrain (furrow) in the forced landing area was a related factor.NTSB ATL98TA054Accident · No injuriesFinal reportCessna 172 · Arcadia, FLThe pilot's inadequate pre-flight and in-flight planning, which resulted in fuel exhaustion and the loss of power. Trees and rough/uneven terrain are contributing factors.NTSB MIA98LA093Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Titusville, FLloss of engine power for undetermined reason(s), which resulted in a forced landing. Factors relating to the accident were: the lack of suitable terrain and obstructions in the emergency landing area.