NTSB investigations: Lycoming IO-360-L2A, 2007

8 cases on aircraft whose registry engine model is Lycoming IO-360-L2A, where the first occurrence was “Hard landing”. 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

20012026
NTSB investigations: Lycoming IO-360-L2A, 2007 per year, 2001–2026: 24 cases
20011
20032
20047
20051
20065
20078

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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41597')
      AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 200))
  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.

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…Jul 18, 2007 · N907JW · Substantial damageNTSB 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.Jul 15, 2007 · N13151 · Substantial damageNTSB LAX07CA202Accident · No injuriesData collectionFinal reportCessna 172S · Spanish Fork, UTThe pilot's misjudged landing flare resulting in a porpoise and hard touchdown.Jul 3, 2007 · N619TH · Substantial damageNTSB ATL07CA093Accident · No injuriesData collectionFinal reportCessna 172S · Batavia, NYThe student pilot's failure to flare the airplane during landing resulting in a hard landing.Jun 15, 2007 · N2228L · Substantial damageNTSB NYC07CA131Accident · No injuriesData collectionFinal reportCessna 172S · Raleigh-Durham, NCThe pilot's improper recovery from a bounced landing.Jun 2, 2007 · N2298W · Substantial damageNTSB 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.May 9, 2007 · N924LP · Substantial damageNTSB 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.May 7, 2007 · N533ER · Substantial damageNTSB SEA07CA120Accident · No injuriesData collectionFinal reportCessna 172R · Livermore, CAThe pilot's improper flare during landing.May 1, 2007 · N28BC · Substantial damage