NTSB investigations: Lycoming AEIO-540 series, CA
22 cases on aircraft whose registry engine model is Lycoming AEIO-540 series. 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
| 1993 | 1 |
|---|---|
| 1996 | 1 |
| 1998 | 1 |
| 1999 | 1 |
| 2001 | 1 |
| 2002 | 1 |
| 2003 | 3 |
| 2006 | 3 |
| 2009 | 1 |
| 2011 | 1 |
| 2012 | 2 |
| 2013 | 1 |
| 2014 | 1 |
| 2016 | 1 |
| 2020 | 1 |
| 2021 | 1 |
| 2022 | 1 |
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 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 ('41568'))
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 ('41568'))
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 WPR22LA153Accident · No injuriesClass 4 · LimitedFinal reportStoddard Hamilton Glasair Super II · Oxnard, CAThe pilot’s failure to maintain airplane control while on final approach, which resulted in a collision with a runway approach light.NTSB WPR21LA076Accident · No injuriesClass 4 · LimitedFinal reportExtra Flugzeugbau EA 300/L · Santa Monica, CAThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground-loop.NTSB WPR20CA174Accident · No injuriesClass 4 · Data collectionFinal reportExtra EA 300 · Concord, CAThe pilot's loss of directional control during the landing roll, which resulted in a ground loop.NTSB GAA16CA127Accident · No injuriesData collectionFinal reportCessna 150 · Santa Paula, CAThe tailwheel pilot's failure to see and avoid a stationary airplane performing a run-up, which resulted in a ground collision.NTSB WPR14LA329Accident · No injuriesLimited investigationFinal reportChristen Industries Pitts S 2B · Oceanside, CAThe total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot’s inadequate fuel planning.NTSB WPR14LA025Accident · No injuriesLimited investigationFinal reportAviat S2 · Livermore, CAFailure of the pilots of the Pitts airplane to maneuver the airplane as necessary to observe the taxi route and avoid the Cessna airplane ahead. Contributing to the accident was the local controller's failure to provide the required warning of traffic ahead…NTSB WPR12LA407Accident · 1 fatalLimited investigationFinal reportMoore Edward R MXS · Borrego Springs, CAThe pilot’s inability to maintain control of the airplane following the loss of aileron and elevator control due to the forward flight control torque tube assembly’s detachment from the forward bearing. Contributing to the accident was the inadequate…NTSB WPR12FA155Accident · 2 fatalField investigationFinal reportExtra Flugzeugbau EA-300 · Salinas, CAA loose portable XM-GPS antenna that migrated to the tail section of the airplane and jammed the elevator bell crank. Contributing to the accident was the pilot’s failure to account for the cockpit portable GPS antenna during preflight or postflight…NTSB WPR11LA458Accident · Serious injuriesLimited investigationFinal reportAviat Pitts S-2B · Redlands, CAThe pilot’s failure to maintain airspeed while maneuvering, which resulted in an aerodynamic stall. Contributing to the accident was the pilot’s impairment from alcohol.NTSB WPR09LA203Accident · 1 fatalLimited investigationFinal reportExtra EA-300 · Santa Barbara, CAThe pilot's failure to maintain clearance with terrain for undetermined reasons while performing aerobatics.NTSB LAX06LA262Accident · Serious injuriesLimited investigationFinal reportExtra Flugzeugbau EA-300 · Mojave, CAthe pilot's failure to maintain an adequate airspeed while performing low-level aerobatics that resulted in an inadvertent accelerated stall and in-flight collision with terrain.NTSB LAX06LA190Accident · No injuriesLimited investigationFinal reportAviat Pitts S-2B · Antioch, CAThe loss of oil pressure due to metal pieces from the number 5 piston skirt in the oil system, which prevented the oil valve top ball valve from seating. The muddy terrain was a factor.NTSB ANC06LA026Accident · 1 fatalLimited investigationFinal reportExtra Flugzeugbau 300S · Greenfield, CAThe pilot's failure to maintain adequate airspeed during the base leg to final approach phase of a VFR landing pattern, which resulted in an inadvertent stall and an uncontrolled descent. A factor contributing to the accident was the inadvertent stall/mush.NTSB LAX04LA039Accident · Serious injuriesLimited investigationFinal reportZivko Edge 540-T · King City, CAThe after market manufacturer's improper application of a crankshaft , which exceeded the original manufacturer's intended use. A factor in the accident was the oil covering the windscreen, which restricted the pilot's ability to see.NTSB LAX03CA287Accident · Minor injuriesData collectionFinal reportAviat Pitts S-2C · Mountain View, CAthe pilot's failure to maintain an adequate clearance with the runway during a low altitude aerobatic maneuver.NTSB LAX03LA081Accident · Serious injuriesLimited investigationFinal reportPitts S-2B · Long Beach, CAThe pilot's excessive pull up, which resulted in a failure to obtain/maintain flying speed and a subsequent stall/mush.NTSB LAX02LA074Accident · No injuriesLimited investigationFinal reportAviat Pitts S-2B · Hawthorne, CAFailure of the student to maintain directional control of the airplane on the landing rollout and failure of the CFI to adequately supervise the flight. A contributing factor was the decreased tension of the right main landing gear shock cord/bungee.NTSB LAX02FA003Accident · 1 fatalField investigationFinal reportEdge 540 · San Juan Capist, CAthe pilot's failure to maintain an adequate terrain/object altitude clearance while intentionally performing low level aerobatics, which resulted in a loss of aircraft control.NTSB LAX99LA103Accident · No injuriesLimited investigationFinal reportZivko Aeronautics Edge 540 · Livermore, CAThe manufacturer's inadequate quality control procedures, which allowed an improperly manufactured crankshaft to be shipped, resulting in the separation of one counterweight from the crankshaft lug and the subsequent catastrophic internal failure of the…NTSB LAX98LA150Accident · No injuriesLimited investigationFinal reportPitts S-2B · Greenfield, CAThe pilot's failure to maintain directional control. A related factor was the proximity of high brush located on both sides of the runway.NTSB LAX96LA232Accident · Minor injuriesLimited investigationFinal reportMoore Goshawk 350 · Livermore, CAan overstress failure of the left rudder cable.NTSB LAX93LA359Accident · No injuriesLimited investigationFinal reportChristen Industries Pitts S-2B · Hawthorne, CAdual student's failure to maintain directional control and improper use of the rudder and the CFI's inadequate supervision of the flight.