NTSB investigations: Lycoming 0-320 series, WA
10 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
| 1986 | 1 |
|---|---|
| 1987 | 1 |
| 1988 | 1 |
| 1994 | 1 |
| 1997 | 1 |
| 1998 | 3 |
| 2002 | 1 |
| 2006 | 1 |
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 c.\"eventStateOrRegion\" = 'WA' AND c.\"eventCountry\" = 'USA'
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 c."eventStateOrRegion" = 'WA' AND c."eventCountry" = 'USA'
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 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 SEA02LA113Accident · No injuriesLimited investigationFinal reportCessna 177 · Mt. Vernon, WAThe pilot's failure to accurately determine the amount of fuel onboard. Factors included trees, and a portable restroom.NTSB SEA98LA191Accident · No injuriesLimited investigationFinal reportCessna 172L · Puyallup, WAThe pilot-in-command's failure to refuel en-route resulting in fuel exhaustion. Contributing factors were a vehicle (in the landing path) and dark night conditions.NTSB SEA98LA169Accident · No injuriesLimited investigationFinal reportWiles S1-C · Yelm, WAFuel exhaustion due to overflying an intermediate fuel stop. Factors include high grass in the forced landing area.NTSB SEA98LA068Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Monroe, WAFuel starvation due to the flight instructor's improper in-flight decision to simulate an engine failure by pulling the mixture control toward the lean position until the engine shut down, and his failure to return the mixture to the rich position until after…NTSB SEA97LA166Accident · Minor injuriesLimited investigationFinal reportCessna 172I · Naches, WAinadequate preflight by the pilot, and subsequent fuel exhaustion, which led to a forced landing and subsequent nose over of the aircraft. Related factors were: the FBO did not refuel the aircraft as requested, and soft terrain was encountered during the…NTSB SEA94LA217Accident · Minor injuriesLimited investigationFinal reportAllen D. Potts WAG-A-BOND · Benton City, WAFuel starvation and inadequate compensation for wind conditions. A factor to the accident was soft terrain.NTSB SEA88LA040Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Kennewick, WAAt about 75 feet AGL a total loss of power occurred. The plt landed on the remaining runway but overran the rwy, coming to rest 200 ft beyond the end. During the overrun, the nose gear struck a rock and the acft nosed over. The aircraft's fuel tanks contained…NTSB SEA87LA066Accident · No injuriesLimited investigationFinal reportCessna 172 · Lopez Island, WADuring cruise the acft engine quit due to fuel exhaustion. The pilot neglected to visually check the fuel tanks prior to departure, but rather relied on fuel gauges and his own estimation that enough fuel would be remaining to complete the flight. During…NTSB SEA86LA185Accident · No injuriesLimited investigationFinal reportVarga 2150A · Everett, WAThe plt reported he made an emergency landing in a wheat field following a loss of power due to fuel exhaustion. The acft struck a ditch and nosed over during the landing roll. The plt stated he sould have refueled at the last stop.