Fatal NTSB investigations: Lycoming IO-540 series, 2002
21 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
| 1971 | 1 |
|---|---|
| 1978 | 2 |
| 1979 | 2 |
| 1981 | 2 |
| 1982 | 2 |
| 1983 | 3 |
| 1984 | 3 |
| 1985 | 5 |
| 1986 | 5 |
| 1987 | 1 |
| 1988 | 3 |
| 1989 | 3 |
| 1990 | 2 |
| 1991 | 2 |
| 1992 | 5 |
| 1993 | 4 |
| 1994 | 5 |
| 1995 | 5 |
| 1996 | 1 |
| 1997 | 6 |
| 1998 | 4 |
| 1999 | 7 |
| 2000 | 4 |
| 2001 | 10 |
| 2002 | 21 |
| 2003 | 12 |
| 2004 | 10 |
| 2005 | 11 |
| 2006 | 11 |
| 2007 | 11 |
| 2008 | 13 |
| 2009 | 7 |
| 2010 | 13 |
| 2011 | 8 |
| 2012 | 5 |
| 2013 | 4 |
| 2014 | 9 |
| 2015 | 5 |
| 2016 | 3 |
| 2017 | 7 |
| 2018 | 6 |
| 2019 | 9 |
| 2020 | 3 |
| 2021 | 3 |
| 2022 | 3 |
| 2023 | 7 |
| 2024 | 3 |
| 2025 | 2 |
| 2026 | 3 |
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\") = 2002
AND 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 ('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") = 2002
AND 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 ('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 ATL03FA025Accident · 4 fatalField investigationFinal reportPiper PA-32-300 · Macon, GAThe loss of engine power due to oil starvation.NTSB FTW03LA061Accident · 1 fatalLimited investigationFinal reportCreekmore Team Rocket F-1 · Rosenberg, TXThe in-flight separation of the vertical stabilizer as a result of the builder's failure to install the upper attachment fitting for the vertical fin aft spar.NTSB MIA03WA031Accident · 2 fatalForeign investigationPiper PA-23-250 · Freeport, BahamasNTSB SEA03FA015Accident · 2 fatalField investigationFinal reportCaron Seawind · Bryant, WAA loss of engine power for undetermined reasons and the failure of the flying pilot to maintain flying speed resulting in an inadvertent stall, loss of control and subsequent collision with terrain.NTSB NYC03FA024Accident · 1 fatalField investigationFinal reportSocata TB-20 · Massena, NYThe pilot's failure to maintain airspeed, which resulted in a stall. Factors in this accident were the icing conditions, deteriorated airplane performance due to ice accumulation, and control interference by the passenger as reported by the pilot.NTSB MIA03LA019Accident · 3 fatalLimited investigationFinal reportJohn H. Heiring Express · Moncks Corner, SCThe pilot's failure to maintain airspeed following a loss of engine power for undetermined reasons, resulting in an inadvertent stall and subsequent uncontrolled descent and in-flight collision with water.NTSB FTW03WA032Accident · 1 fatalForeign investigationPiper PA-31-350 · Cambita, Dominican RepublicNTSB NYC03FA015Accident · 1 fatalField investigationFinal reportCessna 182S · Accident, MDThe pilots improper in-flight decision to continue flight into known adverse weather conditions. A factor related to the accident was the icing conditions.NTSB FTW03FA016Accident · 6 fatalField investigationFinal reportPiper PA-32-301 · Paron, ARThe pilot's failure to maintain altitude/clearance from terrain. Contributing factors were the low ceiling, the pilot's decision to fly in known adverse weather conditions, and his lack of an instrument rating.NTSB IAD03FA004Accident · 1 fatalField investigationFinal reportCessna 182S · Brownville Jct, METhe pilot's failure to maintain sufficient altitude while flying in mountainous terrain at night. A factor was the night lighting conditions.NTSB IAD03FA001Accident · 1 fatalField investigationFinal reportPiper Aerostar 602P · Bradford, PAThe pilot's failure to follow the published instrument approach procedure, which resulted in an early descent into trees and terrain. A factor was the night, instrument meteorological conditions.NTSB FTW03FA003Accident · 1 fatalField investigationFinal reportSocata TB-20 · Texarkana, ARThe inadvertamt stall by the student pilot, and the inadequate supervision by the flight instructor.NTSB CHI02FA294Accident · 2 fatalField investigationFinal reportAviat S-2C · Sheridan, INThe pilot's failure to maintain adequate altitude and airspeed while performing an aerobatic maneuver. Contributing factors were the pilot-in-command exceeding the aircraft weight and balance, and his inadequate preflight planning/preparation.NTSB MIA02FAMS3Accident · 1 fatalMissing aircraftFinal reportPiper PA-36-300 · MissingThe falure of the pilot to arrive at the intended destination for undetermined reasons. A finding in the investigation was the fact that clouds with tops to 44,000 feet were noted 38 miles south of the airplane's last position.NTSB ATL02LA144Accident · 5 fatalLimited investigationFinal reportPiper PA-32RT-300 · Atlantic Ocean, BahamasThe pilot continued VFR flight into IMC and thunderstorm conditions which resulted in spatial disorientation and subsequent loss of control of the airplane.NTSB CHI02FA197Accident · 1 fatalField investigationFinal reportPiper PA-60 · Columbus, INThe pilot's failure to maintain control of the airplane during a missed approach. Additional factors included the operator's inadequate oversight, the pilot's improper in-flight decision, conditions conducive to pilot fatigue, fog, and night.NTSB FTW02FA192Accident · 4 fatalField investigationFinal reportPiper PA-24-260 · Gorman, TXThe pilot's loss of control and the exceedence of the design limits of the airplane which resulted in an in-flight break-up. A factor was inadvertent VFR flight into IMC.NTSB CHI02FA120Accident · 1 fatalField investigationFinal reportCessna 182S · Sheboygan, WIThe pilot failed to maintain control of the airplane during the go-around for undetermined reasons.NTSB CHI02FA112Accident · 1 fatalField investigationFinal reportPiper 601P · Moscow, KSThe pilot's intentional operation of the airplane with a known engine boost problem resulting in the improper use of brakes to maintain directional control during takeoff, the brake system fire, and the loss of control for undetermined reasons during the…NTSB LAX02FA073Accident · 1 fatalField investigationFinal reportPiper Aerostar 601P · Stonyford, CAthe pilot's failure to maintain terrain clearance during cruise flight, which resulted in the in-flight collision with mountainous terrain. Factors in the accident were the mountainous terrain and the dark night light conditions.NTSB ANC02FA010Accident · 1 fatalField investigationFinal reportPiper PA-32 · Haines, AKThe pilot's continued VFR flight into instrument meteorological conditions, and subsequent collision with trees while in cruise flight. Factors in the accident were weather conditions consisting of freezing rain, mist, and low ceilings.