NTSB investigations: Lycoming 0-540 series, 1997
26 cases on aircraft whose registry engine model is Lycoming 0-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
| 1964 | 146 |
|---|---|
| 1965 | 151 |
| 1966 | 150 |
| 1967 | 192 |
| 1968 | 128 |
| 1969 | 110 |
| 1970 | 110 |
| 1971 | 118 |
| 1972 | 115 |
| 1973 | 83 |
| 1974 | 98 |
| 1975 | 83 |
| 1976 | 77 |
| 1977 | 97 |
| 1978 | 78 |
| 1979 | 92 |
| 1980 | 82 |
| 1981 | 80 |
| 1982 | 58 |
| 1983 | 59 |
| 1984 | 51 |
| 1985 | 59 |
| 1986 | 29 |
| 1987 | 47 |
| 1988 | 41 |
| 1989 | 35 |
| 1990 | 39 |
| 1991 | 31 |
| 1992 | 28 |
| 1993 | 26 |
| 1994 | 41 |
| 1995 | 41 |
| 1996 | 41 |
| 1997 | 26 |
| 1998 | 30 |
| 1999 | 35 |
| 2000 | 35 |
| 2001 | 40 |
| 2002 | 52 |
| 2003 | 39 |
| 2004 | 35 |
| 2005 | 39 |
| 2006 | 43 |
| 2007 | 30 |
| 2008 | 38 |
| 2009 | 37 |
| 2010 | 28 |
| 2011 | 37 |
| 2012 | 24 |
| 2013 | 15 |
| 2014 | 31 |
| 2015 | 24 |
| 2016 | 27 |
| 2017 | 25 |
| 2018 | 25 |
| 2019 | 32 |
| 2020 | 24 |
| 2021 | 28 |
| 2022 | 25 |
| 2023 | 30 |
| 2024 | 23 |
| 2025 | 25 |
| 2026 | 23 |
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 year(c.\"eventDate\") = 1997
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'))
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 year(c."eventDate") = 1997
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'))
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 NYC98LA038Accident · No injuriesLimited investigationFinal reportCessna TR182 · Owenton, KYThe pilot's inadequate preflight/inflight decision and VFR flight in instrument meteorological conditions. Contributing was a low ceiling.NTSB FTW98LA060Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Lubbock, TXThe inadequate maintenance of the landing gear assembly by maintenance personnel resulting in a partial gear extension, and the pilot's misjudgment of a proper touchdown point to intentionally shut down the engine resulting in the airplane landing short of…NTSB CHI98LA034Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-235 · Ulysses, KSthe pilot's continued flight into adverse weather conditions, his failure to activate the pitot heat system, and his failure to maintain clearance from the terrain. Factors associated with this accident were: the pilot did not obtain a preflight weather…NTSB CHI98LA029Accident · 1 fatalLimited investigationFinal reportPiper PA-24-250 · Robinson, ILthe pilot's improper decision to continue flight into adverse weather conditions The low ceiling and the heavy rain were factors.NTSB CHI98LA037Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Lakeville, MNfuel starvation due a deteriorated grommet in an Adel clamp, and a loose mixture control cable.NTSB LAX98LA019Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Fullerton, CAthe pilot's failure to maintain directional control of the airplane during landing roll, which resulted in an inadvertent ground swerve and subsequent damage to the airplane.NTSB FTW97LA316Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Caldwell, TXThe loss of engine power due to fuel exhaustion which resulted from a leaking fuel cap. Factors were the dark night conditions, and the lack of suitable terrain for the forced landing.NTSB ATL97FA118Accident · 3 fatalField investigationFinal reportPiper PA-24-250 · Palm Bch Garden, FLloss of engine power for undetermined reasons and the pilot's failure to maintain flying speed.NTSB LAX97LA279Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · San Diego, CAa loss of engine power for undetermined reasons.NTSB ATL97FA113Accident · Serious injuriesField investigationFinal reportPilatus BN-2 Islander · Fajardo, PRThe pilot's failure to maintain adequate visual lookout.NTSB CHI97LA244Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Fond Du Lac, WIthe pilot's improper use of the throttle control friction lock, and his inadequate remedial action. Related factors were his lack of experience in type of aircraft, the pilot's habit interference, and the presence of parked (standing) aircraft.NTSB CHI97LA209Accident · No injuriesLimited investigationFinal reportPiper PA-25-235A · O'Neil, NEfuel exhaustion, due to the pilot's improper planning/decision and inadequate fuel consumption calculations. Factors relating to the accident were: the lack of an operable fuel indication system, and the high winds.NTSB FTW97LA202Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Lamar, COFailure of the left magneto and crank shaft idler drive gears. Factors were failure to perform a 100 hour inspection and unsuitable terrain for a forced landing.NTSB CHI97LA165Accident · No injuriesLimited investigationFinal reportCessna 182RG · Kansas City, MOthe pilot's improper flare, which resulted in a hard landing. A factor relating to the accident was the excessive airspeed.NTSB CHI97LA132Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Correctionville, IAthe pilot's inadequate compensation for wind conditions, while taxiing, which resulted in loss of aircraft control, an encounter with terrain, and subsequent failure of the left main landing gear. The unfavorable wind condition was a related factor.NTSB SEA97LA100Accident · No injuriesLimited investigationFinal reportCessna TR182RG · Ennis, MTThe pilot's failure to adequately compensate for the wind conditions. Factors contributing to the accident were the gusting winds, and the presence of a ditch on the edge of the landing area.NTSB MIA97WA181Accident · 1 fatalForeign investigationPiper PA-23-250 · Bimini, BahamasNTSB NYC97LA061Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Bowling Green, OHthe pilot's improper planning/decision, which resulted in airframe ice and the loss of adequate lift to maintain continued flight. The adverse weather (icing) condition was a related factor.NTSB FTW97LA131Accident · Serious injuriesLimited investigationFinal reportHiller UH-12E · Donna, TXThe pilot's failure to maintain clearance with the power lines during an aerial application flight. A factor was the power lines.NTSB DCA97WA032Accident · Serious injuriesForeign investigationBritten-Norman BN2A-26 · Paseo Las Palma, Costa RicaNTSB FTW97LA111Accident · No injuriesLimited investigationFinal reportCessna TR182 · Pueblo, COImproper repair to the nose landing gear assembly. A factor was binding of the nose gear extension assembly due to the improper repair.NTSB LAX97LA111Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · Palo Alto, CAthe pilot's improper flare and improper recovery from a bounced landing, which resulted in a porpoise and subsequent overload failure of the nose gear.NTSB FTW97FA103Accident · 5 fatalField investigationFinal reportPiper PA-24-250 · Farmington, NMloss of aircraft control for undetermined reason(s).NTSB ANC97LA023Accident · No injuriesLimited investigationFinal reportMaule M-5 · Chugiak, AKThe pilot's failure to attain the proper touchdown point during landing. The snow-covered runway was a factor.NTSB CHI97LA052Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Franklin, MNThe pilot's inadequate inflight planning and his fuel mismanagement, which resulted in fuel exhaustion and the loss of engine power. A contributing factor with this accident was a frost blocked cockpit windshield.NTSB CHI97LA051Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · St. Ignace, MIthe pilot's failure to maintain proper runway alignment during the takeoff roll. A factor associated with the accident was the snowbank which the airplane contacted.