NTSB investigations: Lycoming 0-290 series, AZ
30 cases on aircraft whose registry engine model is Lycoming 0-290 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
| 1964 | 2 |
|---|---|
| 1966 | 2 |
| 1972 | 1 |
| 1973 | 1 |
| 1974 | 1 |
| 1978 | 1 |
| 1981 | 1 |
| 1982 | 1 |
| 1984 | 1 |
| 1985 | 1 |
| 1986 | 1 |
| 1987 | 1 |
| 1988 | 1 |
| 1989 | 1 |
| 1990 | 1 |
| 1991 | 2 |
| 1993 | 1 |
| 1994 | 1 |
| 1996 | 1 |
| 1999 | 1 |
| 2004 | 1 |
| 2008 | 1 |
| 2009 | 3 |
| 2014 | 1 |
| 2015 | 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\" = 'AZ' 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 ('41506'))
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" = 'AZ' 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 ('41506'))
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 GAA15CA187Accident · No injuriesData collectionFinal reportHier James A Long EZ · Show Low, AZThe right main landing gear leg fracture, which resulted in the landing gear wheel separation and a runway excursion.NTSB WPR14CA266Accident · No injuriesData collectionFinal reportLuscombe 8A · Tucson, AZThe student pilot's use of excessive brakes during taxi, which resulted in a loss of aircraft control.NTSB WPR09CA257Accident · No injuriesData collectionFinal reportPiper PA-20 · Glendale, AZThe pilot's inadequate compensation for the crosswind conditions and failure to maintain directional control on the landing roll out.NTSB WPR09CA231Accident · Serious injuriesData collectionFinal reportFuhrmann-Super Emeraude Stretched · Peach Springs, AZThe airplane's encounter with turbulence after takeoff, which resulted in an uncontrolled descent and collision with terrain.NTSB WPR09CA081Accident · No injuriesData collectionFinal reportParker 77 · Phoenix, AZThe pilot's failure to maintain directional control during landing. Contributing to the accident was the pilot's improper application of brakes.NTSB WPR09CA031Accident · No injuriesData collectionFinal reportPiper PA-22-135 · San Manuel, AZThe pilot's failure to maintain lateral aircraft control that resulted in collision with terrain during landing.NTSB LAX04CA286Accident · No injuriesData collectionFinal reportPiper PA-20 · Glendale, AZthe pilot's failure to maintain directional control during the takeoff roll.NTSB LAX99LA171Accident · Minor injuriesLimited investigationFinal reportWidner RV-3A · Casa Grande, AZThe pilot's inadequate compensation for the existing crosswind condition and his subsequent failure to maintain directional control during the takeoff roll. The pilot's distraction in looking for the aircraft which announced an intention to land in the…NTSB LAX96LA240Accident · 1 fatalLimited investigationFinal reportExperimental Mini Mustang · Page, AZthe pilot's inadequate compensation for crosswind conditions, and his failure to maintain control of the aircraft. A factor relating to the accident was: the gusty/crosswind condition.NTSB LAX94FA360Accident · 2 fatalField investigationFinal reportPiper PA-18-135 · Winslow, AZthe pilot's inadvertent stall and uncontrolled descent into the ground from a low altitude while scouting for game.NTSB LAX93LA292Accident · Minor injuriesLimited investigationFinal reportSanders S-1C · Saint Johns, AZthe pilot's inadequate compensation for the existing cross wind conditions and his subsequent failure to maintain directional control of the aircraft.NTSB LAX91LA295Accident · No injuriesLimited investigationFinal reportPiper PA 22 · Duncan, AZThe pilot's failure to maintain a proper airspeed during the approach and an inadvertent entry into a stall/mush which resulted in a hard landing.NTSB LAX91LA260Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Sonita, AZA loss of engine power due to a broken piston ring in the number 3 cylinder, which resulted in the aircraft's inability to maintain level flight.NTSB LAX90LA253Accident · No injuriesLimited investigationFinal reportPiper PA22-150 · Springerville, AZThe encounter with a downdraft beyond the climb capability of the aircraft.NTSB LAX90DUJ01Accident · No injuriesFinal reportRoger Nelson Aeronica/T · Sierra Vista, AZThe pilot's inaccurate placement of the aircraft wheels into depressions in a platform mounted on a moving pickup truck during an airshow performance.NTSB LAX88LA286Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-135 · Parker, AZThe pilot reported that just after tkof from a river the eng was not developing sufficient power to maintain altitude. The pilot made a landing and during the landing roll collided with rough terrain. After the accident, the engine was test run and found to…NTSB LAX87DUJ06Accident · 1 fatalFinal reportDavis Midget Mustang · Kirkland, AZDuring a low level aerobatic flight, the aircraft collided with the terrain after completing a roll. There were no mechanical failures or malfunctions reported. The plt performed the last roll in view of two friends driving in a car near the acc scene.…NTSB LAX86FUJ06Accident · No injuriesFinal reportForbes-Wolfram Special DSA-1M · St. Johns, AZThe plt reported that persons over 5 ft 9 in tall experience limited right aileron control authority due to the small cockpit of the homebuilt experimental acft, which is used exclusively for air racing. The plt said the right knee of tall persons limits the…NTSB LAX86LA054Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Deer Valley, AZShortly after begining descent from 7,500 ft. m.s.l. the acft experienced a total loss of power. Prior to descent the plt richened the mixture and applied carb heat. The pilot radioed his position & situation to Deer Valley tower, Deer Valley, Arizona while…NTSB LAX84LA408Accident · Minor injuriesLimited investigationFinal reportNesmith Cougar 1 · Williams, AZWhile en route, the plt elected to land at the Williams muni arpt for a rest stop. He noted that rwy 2/20 was closed; however, he observed what appeared to be a new gravel strip, oriented north/south & an airplane on the arpt. The plt assumed the arpt was…NTSB LAX82FUJ33Accident · No injuriesFinal reportHatz CB-1 · Tucson, AZThe pilot reported that during landing, he flared early, misjudged his height, and landed hard. The left gear failed during touchdown, and the aircraft flipped over.NTSB LAX81FUJ54Accident · Minor injuriesClosedCougar 1 · Willcox, AZNTSB LAX78DUK03Accident · Serious injuriesClosedPiper PA-22 · Seligman, AZNTSB LAX75FUJ11Accident · No injuriesClosedWittman W-8 · Casa Grande, AZNTSB LAX73FUJ61Accident · No injuriesClosedPiper PA-22 · Florence, AZNTSB LAX73DUJ26Accident · No injuriesClosedPiper PA-22 · Duncan, AZNTSB LAX67F0233Accident · No injuriesClosedPiper PA-20 · Yuma, AZNTSB LAX67D0020Accident · No injuriesClosedPiper PA-22 · Strawberry, AZNTSB UNK64X3248Accident · No injuriesClosedPiper PA18A · Douglas, AZNTSB UNK64X3120Accident · Minor injuriesClosedPiper PA18 · Willcox, AZ