NTSB investigations: Lycoming 0-235 series, 1998
10 cases on aircraft whose registry engine model is Lycoming 0-235 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 | 10 |
|---|---|
| 1983 | 8 |
| 1984 | 4 |
| 1985 | 3 |
| 1986 | 5 |
| 1987 | 4 |
| 1988 | 5 |
| 1989 | 1 |
| 1990 | 5 |
| 1991 | 8 |
| 1992 | 6 |
| 1993 | 3 |
| 1994 | 3 |
| 1995 | 3 |
| 1996 | 3 |
| 1997 | 7 |
| 1998 | 10 |
| 1999 | 5 |
| 2000 | 9 |
| 2001 | 7 |
| 2002 | 4 |
| 2003 | 9 |
| 2004 | 11 |
| 2005 | 10 |
| 2006 | 5 |
| 2007 | 11 |
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 ('41505')
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 ('41505')
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 FTW99LA064Accident · No injuriesLimited investigationFinal reportCessna 152 · Bowie, TXThe hard landing due to the flight instructor's delayed remedial action to take control of the airplane when the engine lost power. Factors were the loss of engine power for an undetermined reason, and the rough and uneven terrain.NTSB FTW99LA058Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Peaster, TXThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB CHI99FA052Accident · 1 fatalField investigationFinal reportCessna 152 · Sherrill, IAthe pilot continued flying with a known discrepancy and he failed to maintain airspeed and lost control of the airplane while attempting a forced landing. Factors included the tailwind and the undetermined loss of power.NTSB ATL99LA034Accident · No injuriesLimited investigationFinal reportCessna 152 · Shelbyville, TNWater contamination of the fuel supply, resulting from the pilot's inadequate preflight inspection.NTSB FTW99LA008Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Bridgeport, TXThe partial loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB NYC99LA003Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Toughkenamon, PAThe pilot's inadequate preflight inspections which failed to detect an open fuel strainer valve, which resulted in a loss of engine power.NTSB NYC98LA159Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-1A · Point Of Woods, NYImproper maintenance which resulted in the installation of an incorrect venturi and the subsequent loss of engine power.NTSB FTW98LA269Accident · No injuriesLimited investigationFinal reportCessna 152 · Boyd, TXThe loss of engine power due to the total loss of engine oil for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB ANC98LA033Accident · No injuriesLimited investigationFinal reportPiper J5-C · Valdez, AKThe owner/pilot mechanic's improper overhaul of the engine, and lack of proper lubricating cylinder grease. A factor in the accident was the lack of a suitable area for a forced landing.NTSB FTW98LA091Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Boyd, TXloss of engine power resulting from the pilot's delayed use of carburetor heat during serious carburetor icing conditions. Factors were: the lack of suitable terrain for the forced landing and an evasive maneuver which led to an inadvertent stall.