NTSB investigations: Lycoming 0-540 series, 2004
3 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\") = 2004
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") = 2004
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 DEN04CA121Accident · Minor injuriesData collectionFinal reportPiper PA-24-250 · Model, COthe pilot's improper in-flight planning and decision making resulting in a loss of engine power due to fuel exhaustion. A contributing factor was the trees.NTSB DEN04CA073Accident · No injuriesData collectionFinal reportPiper PA-25-235 · Flagler, COthe pilot's improper in-flight planning/decision which led to fuel exhaustion and subsequent loss of engine power. Factors contributing to the accident were the low altitude, low airspeed, and the inoperative fuel quantity gauge.NTSB ANC04LA043Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · West Palm Beach, FLThe incorrect assembly of the fuel selector valve by maintenance personnel, and the pilot's failure to make a precautionary landing to assess the fuel situation and lack of movement of the right fuel tank indicator. which resulted in fuel starvation and the…