Fatal NTSB investigations: Lycoming 0-540 series
31 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 | 1 |
|---|---|
| 1983 | 2 |
| 1985 | 3 |
| 1986 | 1 |
| 1988 | 3 |
| 1989 | 1 |
| 1990 | 2 |
| 1991 | 2 |
| 1992 | 1 |
| 1993 | 3 |
| 1994 | 3 |
| 1998 | 2 |
| 2000 | 2 |
| 2002 | 2 |
| 2003 | 2 |
| 2006 | 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.\"highestInjuryLevel\" = 'Fatal'
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\" = 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."highestInjuryLevel" = 'Fatal'
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" = 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 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 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 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 CHI02LA121Accident · 2 fatalLimited investigationFinal reportYoder GP-4 · Mount Pleasant, MIThe inadvertent stall/spin by the pilot-in-command.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 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 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 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 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 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 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 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 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…NTSB ANC88FA059Accident · 3 fatalField investigationFinal reportPiper PA-32-260 · Skwentna, AKThe on-demand air taxi flight with the pilot and two passengers struck the rock face of a mountain at the 8600 foot level. According to witnesses at the time of the accident the weather conditions were poor and visibility was less than one-half mile. The…NTSB LAX86FA233Accident · 4 fatalField investigationFinal reportPiper PA 28-236 · Chino, CAThe private non-instrument rated pilot, overflew his home airport by 23 nautical miles upon returning from a night cross country flight and descended into a hill. Instrument meteorological conditions were reported in the area due to reduced visibility. The…NTSB LAX86FA063Accident · 2 fatalField investigationFinal reportCessna TR182 · Independence, CAWhile en route, the acft collided with moutainous terrain (trrn) at an aprx elev of 13,500 ft. previously, the plt had requested & was rcvg traffic advisories fm ARTCC. Bfr the acdnt, the acft's psn & alt (mode c reply) were noted by the controller (ctlr). No…NTSB ANC85LA188Accident · 2 fatalLimited investigationFinal reportMaule M-5-235C · Mccarthy, AKThe pilot departed a sand bar near the bernard glacier on 8/8/85, and never returned to pick up the passenger he had dropped off earlier. On 8/12/91 the wreckage was found by hunters at 61-11N 141-42W at the 1,000-FT level in mountainous terrain. The wreckage…NTSB LAX85FA216Accident · 1 fatalField investigationFinal reportPiper PA25-235 · Walnut Grove, CAThe acft flew into the ground on a procedure turnaround while spraying wheat with a toxic chemical. The acft did not stall and the engine sound did not change. A separated aileron crossover cable showed no fatigue. The cholinesterase level in the pilot's…NTSB DEN83FA180Accident · 4 fatalField investigationFinal reportPiper PA-28-235C · Pitkin, COThe acft was on a x-country flt from camarillo, CA to oshkosh, WI. The plt landed at about noon at montrose, CO, where the acft was refueled & the occupants went to a restaurant to eat. After departing montrose, the acft was seen flying low over rising,…NTSB FTW83FA261Accident · 1 fatalField investigationFinal reportPiper PA-25-235 · Omega, OKThe plt had just completed spraying a field & was in a right turn when the right wing tip hit gently rising terrain. The owner thought that the plt might have diverted his attention while looking at a farmer's map to locate the next field. (Several similar…NTSB LAX82FA260Accident · 5 fatalField investigationFinal reportCessna TR182 · Happy Camp, CAThe aircraft impacted the side of a narrow and steep canyon in a climb attitude. The weather was VFR. The crash occurrednorthwest of the departure point after about 1 hour and 15 minutes of flight. No flight plan was filed, destination was not determined.