NTSB investigations: Lycoming 0-540 series, 2002
6 cases on aircraft whose registry engine model is Lycoming 0-540 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 | 8 |
|---|---|
| 1983 | 9 |
| 1984 | 5 |
| 1985 | 7 |
| 1986 | 5 |
| 1987 | 10 |
| 1988 | 6 |
| 1989 | 7 |
| 1990 | 7 |
| 1991 | 6 |
| 1992 | 2 |
| 1993 | 1 |
| 1994 | 7 |
| 1995 | 6 |
| 1996 | 6 |
| 1997 | 2 |
| 1998 | 3 |
| 1999 | 4 |
| 2000 | 5 |
| 2001 | 7 |
| 2002 | 6 |
| 2003 | 5 |
| 2004 | 3 |
| 2005 | 3 |
| 2006 | 4 |
| 2007 | 2 |
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 ('41532')
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 ('41532')
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 FTW03LA060Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Bryson, TXthe pilot's inadequate inflight planning and decision which resulted in a loss of engine power due to fuel exhaustion. The pilot's failure to refuel the airplane and dark night conditions were contributing factors.NTSB LAX03LA012Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Van Nuys, CAfuel starvation due to the pilot's mismanagement of the fuel system and failure to select a tank containing fuel.NTSB DEN02LA096Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Boulder, COthe pilot's inadequate preflight preparation, which resulted in fuel exhaustion and a subsequent loss of engine power, and his failure to maintain adequate airspeed during the forced landing, which resulted in an inadvertent stall/mush. Factors included the…NTSB DEN02LA040Accident · No injuriesLimited investigationFinal reportCessna TR182 · Kersey, COThe pilot's inadequate planning decision which led to fuel exhaustion and subsequent loss of engine power.NTSB IAD02LA044Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · Louisville, KYThe pilot's inadvertent selection of an empty fuel tank, which resulted in fuel starvation of the engine.NTSB LAX02LA095Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · San Jose, CAThe pilot's inadequate planning and improper fuel consumption calculation, which resulted in fuel exhaustion.