NTSB investigations: Lycoming 0-235 series, 2002
5 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
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\") = 2002
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") = 2002
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 SEA03LA017Accident · No injuriesLimited investigationFinal reportGrumman American AA-1C · Rigby, IDThe pilot's selection of a fuel tank with inadequate fuel resulting in fuel starvation and a complete power loss during the initial climb. A contributing factor was the ditch which the aircraft impacted during the forced landing resulting in the collapse of…NTSB NYC03LA010Accident · No injuriesLimited investigationFinal reportCessna 152 · Salisbury, MAThe pilot's inadequate preflight inspection, which resulted in a loss of engine power due to fuel contamination. Factors in this accident were the corroded fuel tanks caps, and an inadequate annual inspection.NTSB NYC02LA176Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Athens, OHThe student pilot's improper fuel management, which resulted in fuel starvation during cruise flight. A factor was the operator's failure to perform maintenance on a fuel gauge that was noted twice in a discrepancy log.NTSB SEA02LA155Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Darrington, WALoss of engine power during takeoff due to an undersized gascolator gasket resulting in a loss of fuel flow to the engine. A ditch was a factor.NTSB ATL02LA124Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Greenville, NCThe pilot's improper preflight planning and fuel management resulting in fuel exhaustion, and the total loss of engine power. The airplane nosed over during a forced landing to a cotton field.