Fatal NTSB investigations: Lycoming IO-540 series, 2007
11 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
Latest 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\") = 2007
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") = 2007
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 LAX08FA028Accident · 3 fatalField investigationFinal reportPiper PA-60-602P · McFarland, CAThe pilot's inadequate preflight preparation and improper fueling procedures that led to fuel exhaustion.NTSB NYC07FA226Accident · 1 fatalField investigationFinal reportPiper PA-32R-301 · Whitfield, ALThe pilot’s intentional flight into known thunderstorms.NTSB CHI07FA279Accident · 2 fatalField investigationFinal reportSocata TB-20 Trinidad · Pointe Aux Pins, MIUndetermined.NTSB SEA07FA223Accident · 4 fatalField investigationFinal reportRobinson R44 II · Easton, WAThe pilot's improper planning/decision in attempting a downwind takeoff under high density altitude conditions that resulted in a loss of control and impact with terrain. Contributing to the accident were the helicopter's gross weight in excess of the maximum…NTSB SEA07FA199Accident · 2 fatalField investigationFinal reportCessna 182S · New River, AZThe pilot's inadvertent VFR flight into IMC and his ensuing failure to maintain aircraft control while in cruise flight. Contributing factors were the cloudy weather and the dark night conditions.NTSB DFW07FA149Accident · 1 fatalField investigationFinal reportSocata TB-20 · Groesbeck, TXThe pilot's loss of control due to spatial disorientation. Contributing factors were the pilot's perceived need to fly to home station and his lack of flight experience in actual instrument meteorological conditions.NTSB CHI07LA115Accident · 2 fatalLimited investigationFinal reportBird Seawind 3000 · Knox City, MOThe loss of engine power for an undetermined reason. Contributing to the accident was the unsuitable terrain that was encountered by the pilot during the forced landing.NTSB ATL07LA073Accident · 1 fatalLimited investigationFinal reportCulver, Aurther L. Seawind 3000 · Yanceyville, NCThe pilot's failure to maintain clearance/altitude while operating in instrument meteorological conditions (IMC). Contributing to the accident was the pilot's lack of an instrument rating, his improper decision to operate in IMC, a low cloud ceiling, and…NTSB DEN07FA079Accident · 2 fatalField investigationFinal reportRobinson R44 II · Ponte Vedra Bch, FLthe mechanic's improper installation of the attachment hardware for the servo to swashplate push-pull tube joint which resulted in a disconnection, subsequent loss of control, and impact with terrain. Contributing factors were the company management's…NTSB LAX07LA099Accident · 1 fatalLimited investigationFinal reportMallian Rocket II · Arvin, CALoss of control during cruise for undetermined reasons.NTSB NYC07FA055Accident · 1 fatalField investigationFinal reportPiper PA-60-601P · Jamestown, NYThe pilot's incorrect selection of the right engine fuel selector position, which resulted in fuel starvation of the right engine, a loss of the right engine's power, and a loss of control during initial climb. Contributing to the accident were the pilot's…