NTSB investigations: Lycoming 0-540 series, 1982
7 cases on aircraft whose registry engine model is Lycoming 0-540 series, where the first occurrence was “Loss of control - on ground/water”. 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 | 7 |
|---|---|
| 1983 | 7 |
| 1984 | 3 |
| 1985 | 7 |
| 1986 | 2 |
| 1987 | 3 |
| 1988 | 3 |
| 1989 | 2 |
| 1990 | 3 |
| 1991 | 2 |
| 1992 | 4 |
| 1993 | 1 |
| 1994 | 4 |
| 1995 | 2 |
| 1996 | 4 |
| 1997 | 4 |
| 1998 | 2 |
| 1999 | 6 |
| 2001 | 2 |
| 2002 | 2 |
| 2003 | 6 |
| 2004 | 2 |
| 2005 | 2 |
| 2006 | 3 |
| 2007 | 1 |
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\" = 260))
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" = 260))
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 MKC82DA127Accident · No injuriesFinal reportPiper PA-28-235D · Falls City, NEThe pilot reported that while he was landing with a 6 to 7 kt crosswind, the plane was blown toward the left side of the runway. In order to avoid the runway lights, he intentionally maneuvered the aircraft off the side of the runway, into the grass. When he…NTSB FTW82DA162Accident · Minor injuriesFinal reportPiper PA-25-235 · Lubbock, TXPrior to the flight, the aircraft had been serviced in preparation for the beginning of the spraying season. As part of the servicing, the operator/pilot added hydraulic fluid to the left brake. However, he did not purge the system of air after adding the…NTSB CHI82DA122Accident · Minor injuriesFinal reportPiper PA-28-235 · Graytown, OHDuring landing roll the aircraft contacted a soft area on the pilot's privately owned sod runway. The nose gear collapsed and the aircraft came to rest with the tail in the air.NTSB CHI82DA092Accident · Minor injuriesFinal reportPiper PA-24-250 · Columbus, OHWhile performing a touch and go landing on runway 27R, the aircraft veered off the runway to the right and struck a drainage ditch. The pilot reported that the wind was from 350 degrees at 15 knots. Runway 32, an asphalt runway with a length of 3040 ft and a…NTSB CHI82DA087Accident · No injuriesFinal reportCessna 182 · Lake Village, INThe pilot reported that the wind was from the west at 25, gusting 40 knots. During landing on runway 36, he touched down long and then attempted to go-around. At the north end of the field, the aircraft encountered soft, soggy terrain, the pilot lost…NTSB FTW82DA115Accident · No injuriesFinal reportPiper PA-25-235C · Big Spring, TXThe pilot reported that he had been practicing crosswind landings in winds that were gusting to 25 knots. On the last landing, he used flaps. He reported that he had landed and was taxiing on the runway when a gust of wind raised the right wing. The left wing…NTSB LAX82DA059Accident · No injuriesFinal reportCessna TR182 · Las Vegas, NVThe pilot stated that on landing after the second bounce the plane veered left and ran off the runway on to the desert and flipped over.