NTSB investigations: Lycoming 0-320 series, 1994
15 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\") = 1994
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") = 1994
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 SEA95LA020Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · Casper, WYFuel exhaustion due to the pilot's failure to refuel.NTSB CHI94LA348Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Dale, INthe pilot's failure to assure an adequate fuel supply for the flight. Factors associated with the accident were poor preflight planning, inattentiveness to the fuel supply during the flight, the ditch, and the utility pole which was contacted during the…NTSB ANC94LA140Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Wasilla, AKThe pilot's failure to assure that an adequate supply of fuel was available to complete the flight. A factor in the accident was the siphoning of fuel from the fuel cap.NTSB CHI94LA308Accident · No injuriesLimited investigationFinal reportThalman Thorp T-18 · Kenosha, WIthe pilot's failure to use carburetor heat in carburetor icing conditions. A factor associated with the accident is the prevailing carburetor icing conditions.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 LAX94LA335Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Simi Valley, CAFuel exhaustion after the student pilot became lost/disoriented. Factors related to the accident were: failure of the supervising flight instructor (CFI) to follow the FAA approved syllabus, inadequate supervision by the company/operator management, darkness,…NTSB FTW94LA275Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Russellville, ARVFR flight into IMC.NTSB CHI94LA244Accident · No injuriesLimited investigationFinal reportMontana Coyote · Blaine, MNthe loss of engine power due to the blocked vent line.NTSB NYC94LA137Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Augusta, METhe improper positioning of the fuel selector because of inadequate inflight decision/planning which resulted in fuel exhaustion and the loss of engine power.NTSB ATL94LA136Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-160 · Hampton, GAThe pilot's inadequate aircraft pre-flight inspection, his failure to abort the takeoff, and his failure to maintain airspeed that resulted in a stall. A factor was the inadequate aircraft inspection that did not identify the worn fuel cell caps.NTSB CHI94LA205Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Lambertville, MIThe inadequate maintenance of the airplane resulting in a foreign object in the induction system.NTSB SEA94LA107Accident · No injuriesLimited investigationFinal reportRich RV-4 · Weston, IDThe pilot's failure to use carburetor heat. Factors include carburetor icing conditions, and no suitable site for a forced landing.NTSB BFO94LA067Accident · Serious injuriesLimited investigationFinal reportPiper PA-22 · Butler, PAThe pilot's failure to select the proper fuel tank, which resulted in fuel starvation and the loss of engine power.NTSB LAX94LA153Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-180 · Fairfield, AZThe flight instructor's inadvertent movement of the left engine propeller control into the feather position, his decision to by-pass suitable landing sites in an attempt to restart the left engine as the aircraft energy and performance capability…NTSB CHI94LA090Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Grand Forks, NDFuel starvation due to the improper positioning of the fuel tank selector by the student pilot.