NTSB investigations: Lycoming I0360 SER A&C, 2007, FL

7 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

19722026
NTSB investigations: Lycoming I0360 SER A&C, 2007, FL per year, 1972–2026: 73 cases
19721
19761
19801
19811
19831
19851
19862
19873
19892
19901
19922
19952
19961
19971
19981
19991
20002
20011
20024
20031
20042
20051
20063
20077
20082
20105
20111
20121
20132
20142
20161
20174
20182
20202
20213
20232
20241
20252

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.\"eventStateOrRegion\" = 'FL' AND c.\"eventCountry\" = 'USA'
    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.

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.Nov 25, 2007 · N1055L · Substantial damageNTSB NYC07LA208Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Daytona Beach, FLThe inadequate visual lookout of the pilot of the unknown airplane.Sep 2, 2007 · N465MA · 2 aircraft · Substantial damageNTSB 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.Aug 19, 2007 · N6GN · Substantial damageNTSB 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.May 4, 2007 · N809MS · Substantial damageNTSB MIA07CA090Accident · No injuriesData collectionFinal reportCessna 172R · Lantana, FLThe student pilot's failure to maintain directional control of the airplane during landing roll.May 2, 2007 · N7273M · Substantial damageNTSB 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.Apr 13, 2007 · N8543W · Substantial damageNTSB 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.Mar 26, 2007 · N95129 · Substantial damage