NTSB investigations: Lycoming IO-360-L2A, 2007
22 cases on aircraft whose registry engine model is Lycoming IO-360-L2A. 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
| 2001 | 2 |
|---|---|
| 2002 | 1 |
| 2003 | 7 |
| 2004 | 18 |
| 2005 | 13 |
| 2006 | 15 |
| 2007 | 22 |
| 2008 | 24 |
| 2009 | 20 |
| 2010 | 20 |
| 2011 | 21 |
| 2012 | 22 |
| 2013 | 14 |
| 2014 | 16 |
| 2015 | 12 |
| 2016 | 21 |
| 2017 | 24 |
| 2018 | 11 |
| 2019 | 14 |
| 2020 | 14 |
| 2021 | 20 |
| 2022 | 10 |
| 2023 | 15 |
| 2024 | 19 |
| 2025 | 13 |
| 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\") = 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 ('41597'))
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 ('41597'))
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 SEA08CA052Accident · No injuriesData collectionFinal reportCessna 172S · Fullerton, CAThe pilot's failure to maintain clearance while taxiing. Contributing to the accident was the pilot's diverted attention.NTSB LAX08FA023Accident · 1 fatalField investigationFinal reportCessna 172S · Palm Springs, CAThe flight instructor's failure to maintain sufficient airspeed to avoid a stall during takeoff-initial climb, and his impairment from alcohol.NTSB CHI08CA029Accident · No injuriesData collectionFinal reportCessna 172R · Brookings, SDThe student pilot's failure to maintain directional control during takeoff roll. Contributing to the accident was the student pilot's lack of solo flight experience and the runway sign.NTSB CHI07CA308Accident · No injuriesData collectionFinal reportCessna 172 SP · Heath, OHThe improper flare and inadequate recovery from a bounced landing by the student pilot. A factor was the student pilot's lack of experience.NTSB DFW07CA210Accident · No injuriesData collectionFinal reportCessna 172 · McKinney, TXThe student pilot's failure to compensate for existing conditions while landing. A contributing factor was the prevailing crosswind.NTSB DFW07LA207Accident · No injuriesLimited investigationFinal reportCessna 172S · Tyler, TXThe pilot's failure to maintain control of the airplane during takeoff. A contributing factor was the encounter with wake turbulence.NTSB SEA07CA243Accident · No injuriesData collectionFinal reportCessna 172S · Bakersfield, CAThe student pilot's failure to maintain directional control of the airplane during the landing roll, which resulted in a collision with a taxiway sign.NTSB DEN07CA154Accident · No injuriesData collectionFinal reportCessna 172R · Fort Collins, COThe student pilot's improper flare and recovery from a bounced landing.NTSB SEA07CA207Accident · No injuriesData collectionFinal reportCessna 172S · Pahokee, FLThe student pilot's improper flare during the landing which resulted in a hard landing. The student pilot's failure to relinquish control of the aircraft, the flight instructors inadequate supervision and not being able to recover control of the aircraft from…NTSB ATL07CA105Accident · No injuriesData collectionFinal reportCessna 172S · Beverly, MAThe pilot's improper flare, which resulted in a hard landing and nose gear collapse. A contributing factor was the wind gust.NTSB LAX07CA202Accident · No injuriesData collectionFinal reportCessna 172S · Spanish Fork, UTThe pilot's misjudged landing flare resulting in a porpoise and hard touchdown.NTSB LAX07CA199Accident · No injuriesData collectionFinal reportCessna 172S · Santa Barbara, CAthe pilot's failure to maintain directional control.NTSB LAX07CA193Accident · No injuriesData collectionFinal reportCessna 172S · Jacksonville, FLthe student pilot's failure to maintain directional control.NTSB ATL07CA093Accident · No injuriesData collectionFinal reportCessna 172S · Batavia, NYThe student pilot's failure to flare the airplane during landing resulting in a hard landing.NTSB NYC07CA131Accident · No injuriesData collectionFinal reportCessna 172S · Raleigh-Durham, NCThe pilot's improper recovery from a bounced landing.NTSB LAX07CA185Accident · Minor injuriesData collectionFinal reportCessna 172S · Wendover, UTThe pilot's failure to maintain directional control during the landing roll.NTSB NYC07CA116Accident · No injuriesData collectionFinal reportCessna 172S · Asheville, NCThe pilot's improper landing flare which resulted in a hard landing. A factor in the accident was the visual illusion experienced by the pilot from landing on a long, wide runway.NTSB LAX07CA171Accident · No injuriesData collectionFinal reportCessna 172S · Payson, AZThe pilot's inadequate in-flight planning/decision, excessive airspeed on final approach, and failure to execute a go-around resulting in a misjudged flare and hard landing.NTSB CHI07LA164Accident · No injuriesLimited investigationFinal reportCessna 172R · Chesterfield, MOInadequate flare during landing. The induced oscillation, not performing a go-around, the pilot's lack of experience and the failure to perform remedial action were factors.NTSB SEA07CA120Accident · No injuriesData collectionFinal reportCessna 172R · Livermore, CAThe pilot's improper flare during landing.NTSB LAX07CA101Accident · No injuriesData collectionFinal reportCessna 172S · Prescott, AZthe student pilot's failure to maintain directional during the landing rollout and the certified flight instructor's inadequate supervision.NTSB MIA07CA045Accident · No injuriesData collectionFinal reportCessna 172S · Sanford, FLThe inadvertent inflight collision with a bird resulting in damage to the airplane and the pilot having limited control capability.