NTSB investigations: Lycoming 0-540 series
74 cases on aircraft whose registry engine model is Lycoming 0-540 series, where the first occurrence was “In flight collision with terrain/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 | 6 |
|---|---|
| 1983 | 2 |
| 1984 | 5 |
| 1985 | 4 |
| 1986 | 4 |
| 1987 | 1 |
| 1988 | 5 |
| 1989 | 2 |
| 1990 | 3 |
| 1991 | 3 |
| 1992 | 1 |
| 1993 | 4 |
| 1994 | 6 |
| 1995 | 1 |
| 1998 | 2 |
| 1999 | 3 |
| 2000 | 3 |
| 2001 | 5 |
| 2002 | 4 |
| 2003 | 4 |
| 2005 | 2 |
| 2006 | 3 |
| 2007 | 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.\"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\" = 230))
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."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" = 230))
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 CHI07LA254Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Overly, NDThe pilot's failure to maintain terrain clearance during the agricultural application flight. Contributing to the accident was the wheat crop.NTSB CHI06CA257Accident · No injuriesData collectionFinal reportPiper PA-25-235 · Anamoose, NDThe pilot not maintaining altitude/clearance from terrain during the aerial application pass.NTSB CHI06CA214Accident · No injuriesData collectionFinal reportRobinson R-44 · Wadsworth, ILThe pilot inadvertently pulled back on the cyclic when birds flew into the windscreen. A factor associated with the accident were the birds.NTSB SEA06LA052Accident · 1 fatalLimited investigationFinal reportRobinson R44 · Helena, MTThe pilot's intentional suicide. The unauthorized use of a helicopter and impairment by alcohol were factors.NTSB CHI05LA235Accident · Minor injuriesLimited investigationFinal reportRobinson R44 · Greenwood, INThe inadequate remedial action during landing by the pilot.NTSB SEA05CA117Accident · Minor injuriesData collectionFinal reportPiper PA-25-260 · Geraldine, MTThe pilot's failure to maintain clearance with rising terrain. Rising terrain was a factor.NTSB CHI03LA272Accident · No injuriesLimited investigationFinal reportPiper PA-25 · Brandon, WIThe pilot failed to maintain clearance from the corn crop during an aerial application maneuver. Additional factors were the terrain induced turbulence and the corn crop.NTSB CHI03FA219Accident · 1 fatalField investigationFinal reportPiper PA-28-235 · Jackson, MNThe pilot's intentional flight into terrain as an act of suicide.NTSB FTW03LA163Accident · 1 fatalLimited investigationFinal reportRobinson R44 · Brazos Blk 532undetermined, aircraft not recovered.NTSB NYC03LA093Accident · No injuriesLimited investigationFinal reportCessna R182 · Monticello, NYThe pilot's premature raising of the flaps during the aborted landing. A factor in this accident was the crosswind condition.NTSB IAD03FA019Accident · 2 fatalField investigationFinal reportPiper PA-32RT-300 · Bastian, VAThe pilot's failure to maintain an adequate altitude above terrain. Factors in the accident were the dark night conditions and the low cloud ceiling.NTSB CHI02CA248Accident · No injuriesData collectionFinal reportPiper PA-25-235 · Ray, NDThe pilot inadvertently stalled the airplane during takeoff. A factor was the tailwind.NTSB NYC02LA151Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Kelleys Island, OHThe pilot-in-command's failure to obtain a proper touchdown point. A factor was the downdraft.NTSB CHI02LA121Accident · 2 fatalLimited investigationFinal reportYoder GP-4 · Mount Pleasant, MIThe inadvertent stall/spin by the pilot-in-command.NTSB ANC02LA004Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-260 · Port Heiden, AKThe pilot's delay in aborting the landing. Factors in the accident were snow and ice on the runway surface, and the pilot's excessive taxi speed.NTSB ANC01LA131Accident · No injuriesLimited investigationFinal reportMaule M-7-235B · Koliganek, AKThe pilot's delay in aborting the takeoff. A factor in the accident was the pilot's diverted attention during the takeoff.NTSB CHI01LA281Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Kenmare, NDThe pilot failed to maintain clearance with the terrain during the aerial application flight. Factors associated with the accident were the high vegetation and the pilot's diverted attention during the flight.NTSB MIA01LA104Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-235 · Bainbridge, GAThe pilot's failure to maintain a visual lookout while maneuvering during a agricultural run, and inadvertent descent with a known sun glare resulting in an in-flight collision with terrain.NTSB ANC01TA035Accident · No injuriesFinal reportRobinson R-44 · Chickaloon, AKThe pilot's collision with terrain due to his inadequate planning of the approach, and his failure to maintain the helicopter's main rotor RPM during a go-around. Factors in the accident were a tailwind, flat lighting conditions, and snow-covered terrain.NTSB LAX01FA055Accident · 1 fatalField investigationFinal reportCessna TR182 · Petaluma, CAThe pilot's improper IFR procedure, failure to maintain course alignment, and use of a nonapproved handheld GPS receiver for navigation during flight in actual instrument meteorological conditions. Factors contributing to the accident were the low clouds and…NTSB DEN01FA003Accident · 1 fatalField investigationFinal reportCessna R-182 · Grants, NMthe pilot's continued VFR flight into IMC during cruise. Contributing factors were the dark night light conditions, and the cloudy weather conditions.NTSB SEA00LA158Accident · Minor injuriesLimited investigationFinal reportMaule M-5-235 · Paulina, ORThe pilot's failure to maintain an airspeed above stalling speed (Vs), which resulted in a stall/mush into the terrain. Factors include mountainous/hilly terrain, tall trees, a high density altitude, and the pilot's diverted attention as he attempted to keep…NTSB CHI99LA230Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Fargo, NDthe altitude/clearance not maintained by the pilot.NTSB CHI99LA229Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Lefor, NDthe altitude/clearance not maintained by the pilot.NTSB MIA99LA116Accident · Serious injuriesLimited investigationFinal reportMaule M-7-235B · Boca Grande, FLThe pilots failure to maintain a visual lookout on landing resulting in an in-flight collision with a wave.NTSB MIA98LA222Accident · 1 fatalLimited investigationFinal reportPiper PA-25-235 · Bainbridge, GAThe pilot's failure to maintain airspeed resulting in a stall.NTSB MIA98FA155Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · Fargo, GAthe left engine propeller blades struck the runway surface during takeoff, resulting in the pilot losing control of the airplane, and subsequently impacting with trees.NTSB FTW95LA304Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Stratton, COThe pilot's excessive rate of descent as he initiated the swath run and operation of the aircraft over the maximum allowable gross weight.NTSB CHI95LA062Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · Fort Dodge, IAThe pilot's improper IFR procedure. The low ceiling and fog were a factor.NTSB FTW95FA030Accident · 2 fatalField investigationFinal reportPiper PA-28-235 · Aurora, COTHE CFI's FAILURE TO MAINTAIN AIRCRAFT CONTROL DUE TO SPATIAL DISORIENTATION. FACTORS WERE: A DARK, MOONLESS NIGHT WITH NO VISIBLE HORIZON AND RECENCY OF NIGHT EXPERIENCE BY THE FLIGHT INSTRUCTOR.NTSB FTW95LA021Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Albuquerque, NMImproper planning/decision by the pilot, while attempting flight into known adverse weather (wind), and his inadequate compensation for wind conditions. The gusty crosswind conditions and turbulence were related factors.NTSB NYC94FA134Accident · 5 fatalField investigationFinal reportPiper PA-32-260 · Minford, OHThe pilot's failure to follow the published instrument departure procedure. A factor in the accident were the weather conditions.NTSB CHI94LA233Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Tribune, KSthe pilot's failure to maintain clearance above the corn crop during the swath run.NTSB FTW94FA220Accident · 2 fatalField investigationFinal reportSIAI-Marchetti F.260 · Dover, OKFailure of the pilot to maintain adequate altitude while performing an aerobatic demonstration. Factors related to the accident were: the pilot's inadequate training, his lack of experience in the type of operation, and insufficient FAA oversight of this type…NTSB FTW94FA031Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Longview, TXPoor judgment of the pilot due to impairment from consumption of alcohol and use of a drug (marijuana), and his failure to correct a descent, while maneuvering at low altitude. A factor related to the accident was: the pilot's psychological condition.NTSB ANC93LA159Accident · 1 fatalLimited investigationFinal reportMorgan Steen Skybolt MI-2 · Nome, AKThe pilot delayed in recovering from the aerobatic maneuver.NTSB ATL93LA121Accident · 1 fatalLimited investigationFinal reportPiper PA-25-235 · Bainbridge, GAThe pilot's failure to maintain adequate clearance from the ground.NTSB CHI93LA087Accident · Minor injuriesLimited investigationFinal reportPiper PA-32 · Austin, MNThe pilot's failure to maintain altitude. The pilot's continued flight into IMC, diverted attention and the environmental conditions were factors.NTSB CHI93LA017Accident · 1 fatalLimited investigationFinal reportPiper PA-25-260 · Trenton, NDThe pilot's improper aircraft handling while maneuvering at low altitude.NTSB SEA92FA222Accident · 3 fatalField investigationFinal reportMaule M-5-235C · Moran, WYThe pilot's failure to maintain clearance and altitude from terrain while maneuvering, and his failure to adequately compensate for the wind conditions. Factors contributing to the accident are terrain-induced turbulence, unfavorable winds, gusty high winds,…NTSB NYC91FA194Accident · 1 fatalField investigationFinal reportPiper PA-32-260 · Monongahela, PAThe failure of the pilot to achieve a proper touchdown on the runway due to diverted attention, pressure, and other psychological condition.NTSB BFO91LA032Accident · No injuriesLimited investigationFinal reportPiper PA32-260 · Roanoke, VAThe pilot's failure to maintain terrain clearance on a night visual approach.NTSB ATL91FA015Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Rock Hill, SCThe pilot misjudged the aircraft's altitude/clearance above the runway during a low pass and allowed the propeller to contact the runway; he then failed to maintain airspeed after a pull-up and allowed the aircraft to stall.NTSB SEA90LA168Accident · Serious injuriesLimited investigationFinal reportPiper PA24-250 · Lagrande, ORThe pilot did not allow the airplane to attain an adequate airspeed prior to the retraction of flaps and landing gear.NTSB FTW90DQG04Accident · 1 fatalFinal reportPiper PA-25-235 · Lubbock, TXFailure of the pilot to maintain adequate airspeed and altitude during a turn-around maneuver, which resulted in the aircraft stalling into the ground.NTSB DEN89FA209Accident · 2 fatalField investigationFinal reportPiper PA-32-260 · Lk Havasu City, CAPilot's attention diverted outside the airplane. This diversion resulted in the pilot failing to monitor his altitude while in a descending turn and inadvertently flying the airplane into the water.NTSB DEN89LA196Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-235 · Dove Creek, COImproper planning/decision by the pilot. Factors related to the accident were: high density altitude, uphill sloping runway, failure of the pilot to follow the checklist and use all of the available runway, and the rising terrain and obstruction (power line)…NTSB CHI89LA014Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Indianapolis, INShortly after liftoff and landing gear retraction, the pilot inadvertently allowed the aircraft to touch down on the runway. The pilot stated that his attention was distracted by conversation with one of the passengers and he failed to maintain a positive…NTSB LAX89FA021Accident · 1 fatalField investigationFinal reportCessna TR-182 · Paso Robles, CAThe pilot failed to maintain the proper altitude while executing the published instrument approach procedure.NTSB MKC88DCD03Accident · 1 fatalFinal reportPiper PA-25-235 · Eldora, IAPilot was spraying a bean field when a witness saw his aircraft strike the ground. The aircraft then climbed to approximately 200 feet and leveled off. It then began a gentle climb, then entered a spin and desended into the ground. Examination of the aircraft…