NTSB investigations: Lycoming 0-235 series, 1998
8 cases on aircraft whose registry engine model is Lycoming 0-235 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 | 13 |
|---|---|
| 1983 | 21 |
| 1984 | 12 |
| 1985 | 12 |
| 1986 | 13 |
| 1987 | 11 |
| 1988 | 15 |
| 1989 | 17 |
| 1990 | 11 |
| 1991 | 15 |
| 1992 | 13 |
| 1993 | 18 |
| 1994 | 9 |
| 1995 | 5 |
| 1996 | 10 |
| 1997 | 11 |
| 1998 | 8 |
| 1999 | 5 |
| 2000 | 13 |
| 2001 | 6 |
| 2002 | 5 |
| 2003 | 8 |
| 2004 | 5 |
| 2005 | 5 |
| 2006 | 3 |
| 2007 | 4 |
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\" = 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") = 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" = 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 CHI99LA034Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Carrol, IAthe pilot's inadequate preflight inpection of the fuel tanks and filler neck caps before departure. Factors associated with this accident were the leaking right wing fuel tank filler cap and fuel exhaution.NTSB LAX99LA034Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Orinda, CAA loss of engine power due to water contamination of the fuel. A factor was the pilot's inadequate preflight, during which he neglected to note the contamination, and the dark night which made it difficult to select a landing spot.NTSB MIA99LA033Accident · No injuriesLimited investigationFinal reportCessna 152 · Coral Springs, FLThe delay by the pilot to obtain proper assistance after becoming lost/disoriented resulting in total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot's lack of total experience.NTSB CHI98LA321Accident · No injuriesLimited investigationFinal reportCessna 152 · Beecher, ILFuel exhaustion due to fuel mismanagement by the pilot-in-command. The rough terrain was a contributing factor.NTSB ATL98LA082Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Boynton Beach, FLThe pilot's inadequate preflight planning that resulted in a loss of engine power due to fuel exhaustion.NTSB FTW98LA132Accident · No injuriesLimited investigationFinal reportCessna 152 · Norman, OKFuel exhaustion due to the student pilot's failure to refuel. A factor was the lack of suitable terrain for the forced landing.NTSB ATL98LA046Accident · No injuriesLimited investigationFinal reportCessna 152 · Americus, GAthe pilot's improper planning/decision, which led to fuel exhaustion, loss of engine power, and a forced landing on unprepared terrain.NTSB FTW98LA125Accident · No injuriesLimited investigationFinal reportPiper PA-18-105 · Sheridan, WYthe pilot's improper use of carburetor heat, which resulted in loss of engine power due to carburetor ice. Factors relating to the accident were: the carburetor icing (weather) condition, and the lack of a suitable area for an emergency landing.