NTSB investigations: Lycoming 0-320 series, 1996
11 cases on aircraft whose registry engine model is Lycoming 0-320 series, where the first occurrence was “Loss of engine power(total) - nonmechanical”. 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 | 26 |
|---|---|
| 1983 | 23 |
| 1984 | 32 |
| 1985 | 24 |
| 1986 | 24 |
| 1987 | 21 |
| 1988 | 14 |
| 1989 | 20 |
| 1990 | 21 |
| 1991 | 21 |
| 1992 | 19 |
| 1993 | 16 |
| 1994 | 15 |
| 1995 | 15 |
| 1996 | 11 |
| 1997 | 9 |
| 1998 | 25 |
| 1999 | 18 |
| 2000 | 14 |
| 2001 | 10 |
| 2002 | 19 |
| 2003 | 15 |
| 2004 | 17 |
| 2005 | 12 |
| 2006 | 11 |
| 2007 | 9 |
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\") = 1996
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\" = 353))
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") = 1996
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" = 353))
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 IAD96LA155Accident · Serious injuriesLimited investigationFinal reportMerritt Acro Sport II · Cumberland, MDThe pilot's failure to select the electric fuel boost pump during take off which resulted in loss of engine power due to fuel starvation and the subsequent forced landing. A factor to this accident was the owner/builder alteration of the fuel system by…NTSB ANC96TA148Accident · No injuriesFinal reportPiper PA-18 · Elmendorf, AKloss of engine power due to fuel starvation, which resulted from improper positioning of the fuel tank selector; inadequate supervision by the flight instructor (CFI); and the flight crew's improper emergency procedure.NTSB FTW96LA316Accident · 2 fatalLimited investigationFinal reportKraft AIR Master · Katy, TXthe pilot's improper positioning of the fuel tank selector, which resulted in fuel starvation, loss of engine power, and a forced landing. The lack of suitable terrain for a forced landing was a related factor.NTSB CHI96LA250Accident · Minor injuriesLimited investigationFinal reportPoppenhagen PUD Knocker Special · Grafton, NDthe inadequate fuel system design by the builder which led to fuel starvation.NTSB FTW96LA221Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-150 · Paradise, TXThe loss of engine power and hydraulic pressure for reasons undetermined. A factor was the lack of suitable terrain for the forced landing.NTSB MIA96LA141Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Tallahassee, FLthe pilot's mismanagement of fuel, by failing to reposition the fuel selector to the left tank after fuel was used from the right tank, which resulted in fuel starvation, loss of engine power, and a forced landing. A factor relating to the accident was: the…NTSB ATL96LA085Accident · Minor injuriesLimited investigationFinal reportMerle Musson Cozy · Covington, TNThe clogged fuel strainer that resulted in an engine stoppage. A factor was the lack of a suitable landing site.NTSB FTW96LA146Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Gladewater, TXfuel starvation due to the pilot inadvertently turning the fuel selector to the OFF position. A factor was the lack of suitable terrain for the forced landing.NTSB CHI96LA096Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Bourbon, INWater contamination in the fuel, and an inadequate preflight by the pilot. Factors relating to the accident were: soft terrain in the emergency landing area, and an improper soft field landing procedure used by the pilot.NTSB LAX96LA117Accident · No injuriesLimited investigationFinal reportCessna 172P · Raymond, CAThe pilot's failure to verify the quantity of fuel onboard the aircraft prior to departure, which resulted in fuel exhaustion.NTSB CHI96FA073Accident · 3 fatalField investigationFinal reportPiper PA-28-140 · Hallam, NEimproper planning/decision by the pilot, which resulted in fuel exhaustion, due to an inadequate supply of fuel. Darkness was a related factor.