NTSB investigations: Lycoming 0-540 series, CA
11 cases on aircraft whose registry engine model is Lycoming 0-540 series, where the first occurrence was “Loss of control - in flight”. 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
| 1983 | 1 |
|---|---|
| 1985 | 1 |
| 1987 | 1 |
| 1988 | 1 |
| 1992 | 1 |
| 1993 | 1 |
| 1996 | 3 |
| 2005 | 1 |
| 2006 | 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 c.\"eventStateOrRegion\" = 'CA' AND c.\"eventCountry\" = 'USA'
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\" = 250))
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 c."eventStateOrRegion" = 'CA' AND c."eventCountry" = 'USA'
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" = 250))
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 LAX06FA082Accident · 2 fatalField investigationFinal reportPiper PA-28-235 · Mammoth Lakes, CAthe pilot's failure to maintain an adequate airspeed resulting in a stall/spin.NTSB LAX05FA189Accident · Serious injuriesField investigationFinal reportRobinson R44 · Lucerne Valley, CAthe pilot's failure to maintain adequate main rotor rpm and directional control while maneuvering at low altitude. Contributing factors in the accident were the helicopter's gross weight in excess of the maximum hover out of ground effect limit, a high…NTSB LAX97FA070Accident · 4 fatalField investigationFinal reportPiper PA-23-250 · Lucerne Valley, CAthe pilot's failure to maintain an adequate airspeed after encountering turbulence, low level wind shear, and an open door.NTSB LAX97FA047Accident · 1 fatalField investigationFinal reportPiper PA-28-236 · Lost Hills, CAThe pilot's continued VFR flight into instrument meteorological conditions, which led to spatial disorientation and loss of aircraft control, and the pilot exceeding the aircraft's design stress limits during an attempted recovery. The noninstrument-rated…NTSB LAX96LA297Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Truckee, CAThe pilot's failure to properly compensate for a crosswind component during the go-around in a high density altitude environment that led to a loss of aircraft control..NTSB LAX94FA058Accident · 3 fatalField investigationFinal reportSiai-Marchetti F-260 · Santa Monica, CAthe dual student pilot's failure to maintain minimum air speed in flight which resulted in an inadvertent stall/spin. Contributing to the accident was the improper weight and balance, inadequate altitude, and inadequate supervision.NTSB LAX92FA151Accident · 1 fatalField investigationFinal reportPiper PA 28-236 · Lebec, CAThe pilot's delayed inflight decision to reverse course to avoid forecast adverse weather conditions. Contributing to the accident was icing conditions and lightning.NTSB LAX88FA312Accident · 2 fatalField investigationFinal reportPiper PA-28-235 · Camarillo, CAThe pilot decided to operate the aircraft with a known electrical deficiency during night instrument meteorlogical conditions and the decision of the pilot to conduct a flight operation in which he was not certified. Contributing to this accident was the…NTSB LAX87DVA04Accident · No injuriesFinal reportHiller OH-23G · Delano, CADuring an aerial application flight, the pilot returned to the loading truck for approximately 5 additional gallons of chemical to finish the application. The loader; however, loaded 70 gallons and when the pilot took off the rotor RPM began to bleed off. The…NTSB LAX85LVA01Accident · No injuriesFinal reportPiper PA28-236 · Porterville, CAWhile on final apch to rwy 30 at Porterville arpt, and as the acft flared for landing, the left wheel and left wing touched the rwy, and the acft bounced into the air, stalled, and crashed just left of the rwy. The plt stated, 'a gust of wind pitched the nose…NTSB LAX83LA421Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Clearlake, CADuring arrival, the plt made an apch to rwy 30 at night in calm wind conditions. He reported that on final apch, he allowed the airspeed to get low & the acft stalled and struck the ground approximately 300 feet short of the rwy. The rwy was equipped with…