NTSB investigations: Lycoming 0-540 series, 1982
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
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\") = 1982
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") = 1982
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 NYC82DA235Accident · No injuriesFinal reportCessna TR-182 · Honesdale, PAThe aircraft experienced a power loss at 300 feet after takeoff and a forced landing was made with the wheels up in a plowed field. An investigation revealed that a seal around the carburetor air mixing box had come loose and an oil seal in the turbocharger…NTSB CHI82DA347Accident · No injuriesFinal reportBell 47G-4A · Near Brooten, MNThe pilot had been engaged in a spraying operation for 2.5 hrs when he returned and landed on a flat bed type trailer to service the helicopter. After the hopper was serviced with 60 gal of herbicide, the pilot began his take off. He stated that just after…NTSB DEN82DA144Accident · No injuriesFinal reportPiper PA-25-235 · Leonard, NDThe pilot stated the engine lost power as he pulled up from the final spray run. The aircraft wing contacted a tree and a forced landing was made in a barley field. Post flight exam showed no reason for the power loss.NTSB MKC82DA097Accident · Minor injuriesFinal reportPiper PA-25-235 · Kimball, NEThe aircraft was loaded with 100 gallons of 2-4-D and 40 gallons of fuel. During the preflight run-up check, the pilot noted a mag drop of 225 RPM. He stated that leaning the fuel mixture cleared the excessive decrease in RPM, and he observed 2500 RPM on the…NTSB LAX82DA198Accident · No injuriesFinal reportPiper PA-24-250 · Apple Valley, CADuring a flight from saint george, ut to imperial, GA, the pilot encountered fog as he approached el cajon pass, south of Apple Valley, CA. He attempted to go under the fog but was unable. He reversed course and headed back toward Apple Valley. As he was…