NTSB investigations: Lycoming I0360 series, 2018, CA

6 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
NTSB investigations: Lycoming I0360 series, 2018, CA per year, 1964–2026: 299 cases
19644
19655
19664
196711
196810
196911
197015
19716
197210
19734
19746
19753
197610
19779
19786
197914
19805
19819
19826
19833
19843
19852
19866
19873
19885
19894
19903
19912
19927
19933
19944
19952
19965
19984
19992
20002
20013
20028
20035
20047
20054
20066
20073
20082
20094
20102
20114
20122
20134
20143
20154
20164
20172
20186
20193
20202
20212
20223
20231
20243
20253
20261

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\") = 2018
    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 GAA18CA319Accident · Minor injuriesData collectionFinal reportCessna 172 · San Diego, CAThe biplane pilot’s failure to see and avoid the stopped airplane.Jun 3, 2018 · N786SA · 2 aircraft · Substantial damageNTSB GAA18CA589Accident · No injuriesData collectionFinal reportPiper PA28R · Camarillo, CAThe flight instructor's improper landing flare, which resulted in a hard landing.Apr 23, 2018 · N9368N · Substantial damageNTSB GAA18CA207Accident · No injuriesData collectionFinal reportPiper PA34 · San Diego, CAThe pilot receiving instruction and flight instructor’s failure to properly configure the landing gear before landing, which resulted in landing with the landing gear retracted.Apr 10, 2018 · N4567T · Substantial damageNTSB WPR18FA112Accident · 1 fatalField investigationFinal reportMooney M20E · Marina, CAThe pilot's exceedance of the airplane's critical angle of attack during takeoff, which resulted in an aerodynamic stall/spin.Mar 26, 2018 · N213EJ · DestroyedNTSB WPR18LA101Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28R · Paso Robles, CAThe pilots' inadequate preflight inspection, which failed to ensure that the oil filler cap was secured and resulted in oil starvation and a total loss of engine power.Mar 7, 2018 · N33807 · Substantial damageNTSB WPR18LA069Accident · Serious injuriesLimited investigationFinal reportMooney M20E · Skyforest, CAThe pilot’s failure to establish the proper airspeed after departure and to maintain adequate clearance from a ridgeline in high-density and downdraft conditions and his subsequent exceedance of the airplane’s critical angle of attack, which resulted in an…Jan 17, 2018 · N5562Q · Substantial damage