NTSB investigations: Lycoming 0-320 series, 2006
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
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\") = 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\" = 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") = 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" = 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 SEA07LA017Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Caldwell, IDThe pilot's inadequate in-flight planning by failing to refuel while en route which resulted in fuel exhaustion and loss of engine power while on approach to the airport. Rough/uneven terrain was a factor.NTSB DFW07FA023Accident · 2 fatalField investigationFinal reportMcCutchan Glasair · Mineral Wells, TXThe pilot's failure to maintain airspeed during a forced landing, resulting in an inadvertent stall. A factor was the loss of engine power due to fuel exhaustion.NTSB LAX06CA294Accident · No injuriesData collectionFinal reportGrumman American Avn. AA-5 · Watsonville, CAA loss of engine power due to fuel exhaustion as a result of the pilot's inadequate preflight planning, en route fuel consumption calculations, and in-flight decision to continue to the destination instead of stopping en route for fuel.NTSB SEA06LA154Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-150 · Ontario, ORThe pilot's inadequate inflight decision by failing to refuel while en route, resulting in fuel exhaustion and the loss of power. Factors were the en route high wind condition and the soft terrain.NTSB LAX06LA251Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Grass Valley, CAThe loss of available engine power due to vapor lock. A contributing factor was the high temperature.NTSB DFW06CA179Accident · Minor injuriesData collectionFinal reportPiper PA-28-161 · Georgetown, TXThe flight instructor's inadequate supervision of the flight, which resulted in a loss of engine power due to fuel starvation after the private pilot inadvertently positioned the fuel selector to the OFF position. Contributor factors were the lack of suitable…NTSB DFW06CA160Accident · Serious injuriesData collectionFinal reportPiper PA-28-151 · Brownwood, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB MIA06CA111Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Ormond Beach, FLA loss of engine power due to the student pilot's improper positioning of the fuel selector during takeoff. A contributing factor was the pilot's failure to abort the takeoff.NTSB SEA06LA053Accident · Serious injuriesLimited investigationFinal reportCessna 150 · White Salmon, WAThe pilot's failure to maintain aircraft control and the subsequent inadvertent stall/spin to the ground. Contributing factors were the inadequate preflight by the pilot, and the airplane's fuel contamination by water.NTSB NYC06LA064Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Smoketown, PAThe pilot's improper pre-flight planning and improper fuel consumption calculations, which resulted in fuel exhaustion and a subsequent loss of engine power.NTSB DFW06CA051Accident · Minor injuriesData collectionFinal reportCessna 177 · Antlers, OKThe loss of engine power due to fuel exhaustion as result of the pilot's inadequate preflight planning. A contributing factor was the encounter with windshear during the forced landing.