NTSB investigations: Lycoming I0360 SER A&C, 2007
21 cases on aircraft whose registry engine model is Lycoming I0360 SER A&C. 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
| 1966 | 1 |
|---|---|
| 1967 | 1 |
| 1969 | 3 |
| 1970 | 2 |
| 1971 | 1 |
| 1972 | 3 |
| 1973 | 1 |
| 1974 | 1 |
| 1975 | 1 |
| 1976 | 8 |
| 1977 | 9 |
| 1978 | 5 |
| 1979 | 5 |
| 1980 | 8 |
| 1981 | 6 |
| 1982 | 18 |
| 1983 | 11 |
| 1984 | 12 |
| 1985 | 9 |
| 1986 | 13 |
| 1987 | 13 |
| 1988 | 9 |
| 1989 | 6 |
| 1990 | 12 |
| 1991 | 7 |
| 1992 | 6 |
| 1993 | 11 |
| 1994 | 5 |
| 1995 | 9 |
| 1996 | 6 |
| 1997 | 7 |
| 1998 | 9 |
| 1999 | 16 |
| 2000 | 10 |
| 2001 | 25 |
| 2002 | 25 |
| 2003 | 29 |
| 2004 | 32 |
| 2005 | 23 |
| 2006 | 19 |
| 2007 | 21 |
| 2008 | 12 |
| 2009 | 16 |
| 2010 | 17 |
| 2011 | 23 |
| 2012 | 13 |
| 2013 | 14 |
| 2014 | 11 |
| 2015 | 10 |
| 2016 | 19 |
| 2017 | 16 |
| 2018 | 14 |
| 2019 | 7 |
| 2020 | 11 |
| 2021 | 10 |
| 2022 | 7 |
| 2023 | 6 |
| 2024 | 9 |
| 2025 | 7 |
| 2026 | 7 |
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\") = 2007
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41511'))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41511'))
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 NYC08LA059Accident · 1 fatalLimited investigationFinal reportWootton, John Aero Canard · Statesville, NCAn inadvertent opening of the canopy during takeoff.NTSB MIA08CA019Accident · Minor injuriesData collectionFinal reportLake LA-4-200 · Jacksonville, FLThe pilot's failure to maintain altitude while maneuvering over water. Contributing to the accident was glassy water conditions.NTSB NYC08LA018Accident · No injuriesLimited investigationFinal reportBlair Skybolt · Guntersville, ALSeparation of the right tailwheel control link spring from the right control arm of the tailwheel, which resulted in a loss of control during landing.NTSB DFW08CA033Accident · No injuriesData collectionFinal reportCessna 172R · Lufkin, TXThe pilot's improper recovery from a bounced landing.NTSB DFW08CA007Accident · No injuriesData collectionFinal reportCessna 172R · New Braunfels, TXThe pilot's improper recovery from a bounced landing.NTSB LAX08CA006Accident · No injuriesData collectionFinal reportAviat A-1 · Arroyo Grande, CAThe pilot's misjudged altitude and distance on the approach that led to an undershoot and inadequate obstacle clearance.NTSB NYC07LA212Accident · 2 fatalLimited investigationFinal reportSchrack Starduster Too · Verona, KYThe pilot's failure to maintain airspeed during initial climb. Contributing to the accident was the inadvertent stall.NTSB NYC07LA208Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Daytona Beach, FLThe inadequate visual lookout of the pilot of the unknown airplane.NTSB ATL07LA116Accident · 2 fatalLimited investigationFinal reportNiva Thorp T-18 · Wellington, FLA loss of engine power due to a partially blocked intake manifold and water contamination of the fuel.NTSB CHI07LA211Accident · Minor injuriesLimited investigationFinal reportMooney M20J · Eden Prairie, MNThe pilot's inability to maintain control of the airplane for undetermined reasons. Contributing to the accident were the embankment and the fence.NTSB NYC07CA137Accident · Minor injuriesData collectionFinal reportPiper PA-28RT-201 · Tinicum, PAThe instrument-rated pilot's failure to maintain runway alignment by instruments after encountering fog during the initial climb. A factor was the foggy weather conditions.NTSB LAX07CA170Accident · No injuriesData collectionFinal reportCessna 172S · Carson City, NVThe loss of directional control for undetermined reasons.NTSB NYC07CA108Accident · No injuriesData collectionFinal reportPiper PA28R-201 · Leesburg, FLThe flight instructor's failure to take remedial action, and the private pilot's failure to maintain proper airspeed, which resulted in a hard landing.NTSB MIA07CA090Accident · No injuriesData collectionFinal reportCessna 172R · Lantana, FLThe student pilot's failure to maintain directional control of the airplane during landing roll.NTSB LAX07CA141Accident · No injuriesData collectionFinal reportBishop Thomas W BISHOP-ACRO · Stead, NVFuel exhaustion due to the pilot's inadequate pre-flight inspection and his failure to verify that an adequate fuel supply was on board the aircraft.NTSB DEN07CA088Accident · No injuriesData collectionFinal reportAcro Sport Acroduster II SA750 · Albuquerque, NMThe pilot's failure to maintain directional control during the landing roll.NTSB MIA07LA074Accident · Serious injuriesLimited investigationFinal reportConsolidated Aeronautics Lake LA-4-200 · Sarasota, FLThe total loss of engine power for undetermined reasons during initial climb after takeoff, resulting in a forced landing, and an in-flight collision with transmission wires and terrain.NTSB SEA07LA087Accident · Serious injuriesLimited investigationFinal reportBurdette RV-3 · Bountiful, UTThe pilot's failure to maintain directional control during the landing roll. Factors include an earthen berm near the point where the aircraft departed the side of the runway.NTSB MIA07CA065Accident · No injuriesData collectionFinal reportCessna 172R · Orlando, FLThe student pilot's inadequate compensation for the wind conditions while landing. Factors associated with the accident are a crosswind and wind gusts.NTSB ATL07CA048Accident · No injuriesData collectionFinal reportMooney M20J · Toccoa, GAThe pilot's failure to maintain airspeed during a go-around resulting in an inadvertenent stall and collision with the ground.NTSB CHI07CA054Accident · No injuriesData collectionFinal reportCessna 172S · Alton, ILThe student pilot's inadequate recovery from a bounced landing, which resulted in the airplane impacting a runway sign. A factor in the accident was the student pilot's misjudged landing flare.