OpenAirDocs.org

NTSB investigations: Lycoming I0360 series, 2004, CA

7 cases on aircraft whose registry engine model is Lycoming I0360 series. 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

19642026

Where

Open the map

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\") = 2004
    AND c.\"eventStateOrRegion\" = 'CA' 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 ('41515'))
  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 LAX05LA012Accident · No injuriesLimited investigationFinal reportBeech C24R · Cloverdale, CAthe loss of engine power due to fuel starvation from the pilot's inadequate fuel system management and his delay in selecting the fullest fuel tank.Oct 22, 2004 · N18942 · Substantial damageNTSB LAX05LA007Accident · 1 fatalLimited investigationFinal reportDeRosier DR-107 · San Diego, CAthe pilot's failure to maintain adequate clearance from terrain while performing low-level aerobatic maneuvers.Oct 15, 2004 · N31SH · Substantial damageNTSB LAX04FA226Accident · 2 fatalField investigationFinal reportPiper PA-28R-180 · Columbia, CAThe loss of engine power for undetermined reason during takeoff-initial climb, and the pilot's failure to maintain sufficient airspeed to avoid a stall/mush. Factors associated with the accident are an inadvertent stall/mush, and the pilot's failure to abort…May 31, 2004 · N7626J · DestroyedNTSB LAX04CA215Accident · No injuriesData collectionFinal reportPiper PA-28R-200 · Galt, CAthe pilot under instruction's failure to maintain an adequate airspeed on final and misjudged flare, which resulted in stall/mush and hard landing. The certified flight instructor's inadequate supervision and failure to initiate timely remedial action were…Apr 25, 2004 · N169JP · Substantial damageNTSB LAX04FA139Accident · 1 fatalField investigationFinal reportPiper PA-28R-180 · Pine Mtn Club, CAThe pilot's continued visual flight into adverse weather conditions at night, which resulted in an in-flight collision with mountainous terrain. The pilot's failure to obtain preflight weather information for the route of flight was also causal.Feb 28, 2004 · N7687J · DestroyedNTSB LAX04LA138Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Hollister, CAthe student pilot's failure to maintain directional control and the instructor's inadequate supervision of the flight.Feb 13, 2004 · N55073 · Substantial damageNTSB LAX04LA090Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · California City, CAthe pilot's decision to continue taxiing during dark night conditions without an operable taxi/landing light or taxiway lights and his failure to maintain taxiway alignment. Contributing factors to the accident were the dark night light conditions, the failed…Jan 7, 2004 · N3820T · Substantial damage