NTSB investigations: Lycoming 0-540 series, 1985
5 cases on aircraft whose registry engine model is Lycoming 0-540 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 | 5 |
|---|---|
| 1983 | 5 |
| 1984 | 1 |
| 1985 | 5 |
| 1986 | 1 |
| 1987 | 1 |
| 1990 | 1 |
| 1991 | 3 |
| 1992 | 3 |
| 1993 | 1 |
| 1994 | 5 |
| 1995 | 2 |
| 1996 | 4 |
| 1997 | 4 |
| 1999 | 2 |
| 2000 | 3 |
| 2001 | 6 |
| 2002 | 9 |
| 2003 | 5 |
| 2004 | 6 |
| 2005 | 3 |
| 2006 | 4 |
| 2007 | 3 |
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\") = 1985
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\" = 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") = 1985
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" = 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 ATL85LA246Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Goodway, ALDuring aerial application the acft lost total pwr and the plt made an emergency landing in a fld. The plt stated that shortly after the eng lost pwr, he noticed smoke coming from the eng nacelle. After landing in the fld, the acft began to burn and was…NTSB LAX85LA303Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Santa Maria, CAThe pilot reported to the tower, while on base leg, that he was out of fuel. He then landed short and contacted a fence and a tree on the landing roll. The pilot stated that the aircraft contained 45 gallons of fuel when he departed and that he had flown for…NTSB NYC85LA168Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · New Milford, CTAccording to the plt, the preflt and runup checks were normal. The plt then applied full pwr for takeoff and rotation was initiated at 60 KTS. After liftoff, the acft appeared to loose pwr and began to yaw to the left. The stall warning horn sounded and the…NTSB NYC85LA137Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Batavia, NYThe acft was substantially damaged during a forced landing following a loss of pwr on initial takeoff climb. The plt reported that at an alt of aprx 100 ft AGL, the eng quit operating. A forced landing was made 100 yrds off the end of rwy 28. Inspection of…NTSB MIA85LA130Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Everglades, FLThe acft was on a flt over the Everglades at aprx 500 ft AGL, when the eng began to run rough & decreased to about 1200 RPM. During a forced landing, the acft fuel system burst before the acft came to rest & a fire erupted. The plt exited the acft & attempted…