NTSB investigations: Lycoming IO-540 series, 2000
27 cases on aircraft whose registry engine model is Lycoming IO-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 | 1 |
|---|---|
| 1965 | 2 |
| 1966 | 1 |
| 1967 | 4 |
| 1968 | 1 |
| 1969 | 2 |
| 1970 | 3 |
| 1971 | 1 |
| 1972 | 3 |
| 1973 | 1 |
| 1974 | 1 |
| 1975 | 1 |
| 1976 | 4 |
| 1977 | 3 |
| 1978 | 6 |
| 1979 | 7 |
| 1980 | 18 |
| 1981 | 10 |
| 1982 | 16 |
| 1983 | 17 |
| 1984 | 30 |
| 1985 | 20 |
| 1986 | 17 |
| 1987 | 15 |
| 1988 | 12 |
| 1989 | 11 |
| 1990 | 14 |
| 1991 | 14 |
| 1992 | 19 |
| 1993 | 24 |
| 1994 | 13 |
| 1995 | 14 |
| 1996 | 16 |
| 1997 | 16 |
| 1998 | 16 |
| 1999 | 28 |
| 2000 | 27 |
| 2001 | 32 |
| 2002 | 37 |
| 2003 | 30 |
| 2004 | 35 |
| 2005 | 30 |
| 2006 | 31 |
| 2007 | 34 |
| 2008 | 29 |
| 2009 | 19 |
| 2010 | 29 |
| 2011 | 22 |
| 2012 | 26 |
| 2013 | 21 |
| 2014 | 28 |
| 2015 | 19 |
| 2016 | 18 |
| 2017 | 28 |
| 2018 | 27 |
| 2019 | 16 |
| 2020 | 15 |
| 2021 | 27 |
| 2022 | 23 |
| 2023 | 24 |
| 2024 | 14 |
| 2025 | 18 |
| 2026 | 16 |
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\") = 2000
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41530', '41585'))
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") = 2000
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41530', '41585'))
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 SEA01WA033Accident · 4 fatalForeign investigationAerostar 602P · Penticton, CanadaNTSB MIA01LA032Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300 · Wewahitchka, FLa loss of engine power due to the number 5 cylinder connecting rod separating at the rod cap, resulting in a forced landing and subsequent impact with rough uneven terrain.NTSB LAX01LA045Accident · Serious injuriesLimited investigationFinal reportCollette Glassair III · Guistine, CAMaintenance personnel misrouted the crankcase breather hose so that it was pinched when the cowling was installed. This pressurized the crankcase displacing the oil seal and forcing oil out of the engine. A factor was the unsuitable terrain encountered during…NTSB LAX01LA030Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301 · Dayton Valley, NVThe pilot's failure to attain a proper glide path during the final approach resulting in an undershoot of the runway. Factors were the lack of runway lights and night lighting condition.NTSB FTW01LA016Accident · Serious injuriesLimited investigationFinal reportSteven R. Jackson Harmon Rocket 2 · Houston, TXThe collapsing of the inner liner of the induction air hose, resulting in a restriction of airflow to the engine and subsequent loss of engine power. A factor was the lack of suitable terrain for the forced landing.NTSB LAX01FA003Accident · 1 fatalField investigationFinal reportCessna 182S · Santa Rosa, CAthe pilot's loss of airplane control due to spatial disorientation. A related factor was the low ceiling.NTSB ATL01LA004Accident · No injuriesLimited investigationFinal reportJoseph A. Grimaud Seawind 3000 · Chapin, SCA total loss of engine power for undetermined reasons. A factor was the trees.NTSB DEN01LA001Accident · No injuriesLimited investigationFinal reportMaule M-7-235B · Ogden, UTThe pilot's failure to maintain a proper descent rate during landing flare/touchdown. A factor was the tail wheel failure due to overload.NTSB NYC00LA252Accident · No injuriesLimited investigationFinal reportPiper PA-60-601P · Northampton, MAThe pilot's improper preflight planning which resulted in an attempted takeoff from a taxiway. A factor in the accident was the fog.NTSB CHI00FA284Accident · 2 fatalField investigationFinal reportBeech K35 · Manitowish Watr, WIthe pilot not maintaining altitude/clearance from the trees during an approach on a dark, low overcast night, the pilot's improper use of an IFR procedure without clearance, and the pilot's improper in-flight decision to attempt an IFR approach without…NTSB DEN00LA158Accident · No injuriesLimited investigationFinal reportMaule MX-7-235 · Broomfield, COthe pilot's failure to maintain directional control during landing roll. A contributing factor was the crosswind.NTSB NYC00FA239Accident · Serious injuriesField investigationFinal reportCessna 206H · Mayville, NYAn engine compartment explosion due to a fuel/fuel vapor leak of undetermined origin. A secondary explosion resulted from a lack of lubrication to the number 6 connecting rod bearing. Contributing to the pilot's injuries was his reduced visibility during the…NTSB IAD00LA072Accident · Serious injuriesLimited investigationFinal reportAero Commander 114-B · Somerset, PAPilot's improper pre-flight planning, which resulted in a loss of engine power due to fuel exhaustion.NTSB LAX00LA282Accident · Serious injuriesLimited investigationFinal reportDaniel J. Lee Express 90 · Cottonwood, CAThe pilot's failure to maintain directional control during landing roll, which resulted in the on ground collision with trees.NTSB CHI00LA217Accident · No injuriesLimited investigationFinal reportCessna 182S · Millard, NEthe improper recovery from the bounced landing and the porpoise encountered by the pilot. Factors were the misjudged flare by the pilot and the runway light.NTSB MIA00LA219Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Washington, NCThe inadvertent stall by the pilot-in-command while returning for a precautionary landing. Contributing to the accident was the loose engine cowling.NTSB NYC00LA188Accident · No injuriesLimited investigationFinal reportCessna 182S · White Plains, NYThe student pilot's failure to recover from a bounced landing and her failure to perform a go-around.NTSB IAD00LA060Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Fitchburg, MApilot's inadequate compensation for the crosswind. A factor was the crosswind.NTSB CHI00LA189Accident · No injuriesLimited investigationFinal reportStaudacher S-300D2 · Kenosha, WIThe fatigue failure of the rod end bearing and the separation of the aileron. A factor was the inadequate design change by the aircraft designer.NTSB DEN00LA101Accident · Minor injuriesLimited investigationFinal reportSchumacher Swearingen SX-300 · Richfield, UTFuel starvation due to the unavailability of fuel to the engine for undetermined reasons and the pilot's misjudgment of distance/altitude on final approach. Contributing factors were the pilot's premature gear extension and the berm.NTSB CHI00LA149Accident · No injuriesLimited investigationFinal reportPiper PA-36-200 · Oakley, KSthe directional control not maintained by the pilot. The thunderstorm, quartering tailwind/crosswind and the weather evaluation by the pilot were contributing factors.NTSB NYC00LA111Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301 · East Haddam, CTThe private pilots failure to obtain the proper touchdown point and the CFI's delay in remedial action.NTSB CHI00LA078Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Saginaw, MIthe pilots failure to maintain directional control of the aircraft. Factors were the icy runway and the snowbank.NTSB ATL00LA028Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Nashville, TNThe pilot's failure to maintain directional control during the landing roll.NTSB CHI00LA073Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Amery, WIthe pilots failure to maintain directional control. Factors to the accident were the icing conditions, the snow and ice covered runway and the snowbank.NTSB IAD00LA021Accident · 2 fatalLimited investigationFinal reportWood Seawind 3000 · Cumberland Gap, VAThe pilot's continued flight from visual flight rules into instrument meteorological conditions.NTSB ANC00LA022Accident · No injuriesLimited investigationFinal reportPiper PA-32-301 · Ekuk, AKThe pilot's selection of an unsuitable runway for landing. Factors associated with the accident were the inadequate runway maintenance by the runway maintenance personnel, snow berms, and insufficient runway condition information disseminated by the company…