NTSB investigations: Lycoming I0360 series, 2007

9 cases on aircraft whose registry engine model is Lycoming I0360 series, where the first occurrence was “Loss of control - on ground/water”. 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

19822026
NTSB investigations: Lycoming I0360 series, 2007 per year, 1982–2026: 94 cases
19824
19833
19843
19852
19863
19882
19895
19902
19912
19922
19932
19946
19951
19963
19971
19982
19993
20004
20015
200210
20035
20047
20055
20063
20079

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 ('41515')
      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\" = 260))
  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 CHI08CA047Accident · No injuriesData collectionFinal reportCessna Skyhawk 172 · Wausau, WIThe pilot failed to maintain directional control during the landing roll. Factors that contributed to the accident included the snow on the runway and the snowbank.Dec 8, 2007 · N2151J · Substantial damageNTSB NYC07LA227Accident · Serious injuriesLimited investigationFinal reportBeech A23-24 · West Chester, PAThe total failure of the left brake disc due to corrosion.Sep 14, 2007 · N5073T · Substantial damageNTSB ATL07CA124Accident · No injuriesData collectionFinal reportCessna C172R · Pawtucket, RIThe student pilot's failure to maintain control of the aircraft during the takeoff roll.Aug 30, 2007 · N2459Y · Substantial damageNTSB LAX07CA207Accident · Minor injuriesData collectionFinal reportCessna 170 · Spanaway, WAThe pilot's failure to maintain directional control during an aborted takeoff from a short and narrow runway.Jul 7, 2007 · N9716A · Substantial damageNTSB DFW07CA139Accident · No injuriesData collectionFinal reportMooney M-20E · Van, TXThe pilot's failure to maintain directional control during the takeoff run.Jun 19, 2007 · N115RC · DestroyedNTSB CHI07CA143Accident · No injuriesData collectionFinal reportPiper PA-28R-200 · Cincinnati, OHThe pilot's improper decision to leave the aircraft unattended while the engine was running. A factor in the accident was the disengagement of the parking brake.May 9, 2007 · N15027 · Substantial damageNTSB CHI07CA089Accident · No injuriesData collectionFinal reportCessna 172R · Columbus, OHThe pilot's failure to maintain directional control while landing. Contributing factors to the accident were the wind conditions and the runway sign.Mar 11, 2007 · N440ES · Substantial damageNTSB NYC07CA078Accident · No injuriesData collectionFinal reportCessna 172R · Norfolk, VAThe pilot's failure to maintain directional control while landing, which resulted in a collision with a runway sign. A factor was the crosswind.Mar 9, 2007 · N441QF · Substantial damageNTSB CHI07CA074Accident · No injuriesData collectionFinal reportCessna 172S · St. Louis, MOThe pilot's inadequate compensation for the wind conditions and failure to maintain directional control. Factors were the gusting crosswind conditions and the snow covered ground.Feb 16, 2007 · N270JA · Substantial damage